Item Ledger / General Ledger Help

Hi,

I'm trying to create a business view to link F4111 and F0911 to be used in a custom report. The report will have a data selection that will filter out using F0911 fields aside from F4111. Since, values of certain fields in both tables are different (ILDOC != GLDOC) depending on the Doc Type, I'm having a hard time linking them together.

Any ideas?

Hi,

It's because a single record in F4111 will have many records in F0911 (due to debit and credit entry). I don't know what you want to achieve in terms of record retrieval...but you can add a link on ILKCO=GLKCO, ILDCT=GLDCT, ILJELN=GLJELN, ILICU=GLICU...and you can always fetch the offsetting record if you want to.

Hope this helps.