F0911Z1 - Process

rk12345

Member
Hi Gurus,

Can anyone tell me the complete process of converting the Legacy Ledger to F0911 using the Z file F0911Z1.

Thanks !
 
Look in the General Accounting documentation under Converting Journal Entries for Batch Processing and Appendix D for the mapping (XE). The documentation is decent. You'll have to create the mappings from your old system to the new.

We use a three step process for importing from a system that is not a full accounting system, but you may be able to do in one or two. Using a table conversion, we import to a custom work area (we have little cleaning up to do first) and do our mapping to business units, object accounts, and cost objects on the initial import. Because of our data source application, we have to do some mapping by hand. We then use another table conversion to move the data to the Z tables. We review the data in P0911Z1 and then post to the general ledger tables using the R09110Z UBE.

Jim
 
Hi rk12345,

First of all, welcome aboard!

You can process the flat file at least two way:

1.) Using Table Conversion UBE
2.) Using normal UBE, open-read-close flat file using BSFN calls, converting data types where it is neccessary also using BSFN calls, populating F0911Z1 using Table I/O or using section Database Output feature.

You can read about F0911Z1 field and about other useful information in your OW/E1 help.

A.) In your OW/E1 browser select Help on the top side menu.
B.) Select the top menu choice (the description of this choice is vary, based on release and/or SP level)

Two window will pop-up.

- Chooes the top-side window, which has the input focus and navigate:

Interoperability Interface Tables > Journal Entry

- Close this window after you read or print this topic
- Do A. and B. again
- Now close the top-side window
- Select Financials
- navigate ahead:

General Accounting > General Accounting > Appendix F: Interoperability

- Check this topic. Keep your focus on Inbound processing (you can skip EDI and Outbound parts). Also check the "Working with Externally Reconciled Transactions" sub-topic here.

Check your OW/E1 Documentation CD too:

Financials / General Accounting / Appendix D: Batch Input Setup for Journal Entries

Hope this helps!

Please, next time attach your system configuration to your posts! Thanks.

Regards,

Zoltán
 
Back
Top