Reports: linking CO invoice lines to specific GL entries

Anyone have any luck with linking CO invoice lines to the specific revenue lines in the GL that they relate to? I would have thought the IVRF field in OINACC would drive the sequence in which records are written to FGLEDG, but that's not what I'm seeing. For example...

On the customer order and the invoice, the lines are in this sequence:

Line 1: $20

Line 2: $50

Line 3: $20

Line 4: $50

But in FGLEDG, the revenue lines in sequence are for $20, $20, $50, $50. The totals all match up, but I can't link records at the line level. I'd hate to take up an accounting dimension just to record a line number and am hoping there's another intermediate table that might be of use?

Find more posts tagged with

Accepted answers

All comments

Rene Bottern

Not exactly sure why you need the postings in FGLEDG on a Line level, but maybe that's the way to go.

Have you looked at tying it to OINACC though instead to get the Details?

Legacy Contributor

I validated with support that it is impossible to make such a link by default (it was a request by an office in the UAE). OINACC uses a sequence number that follows the order line, delivery line, and invoice line, but when the transition is made from OINACC to FGLEDG, records get written in a new sequence (keyed by EGAIT1), and there is no cross-reference against the line sequence in all the previous files, strangely.

Rene Bottern

Interesting, that is indeed strange.
You should be able to tie it all together using FSLEDG though, I have done this in the past in the DW, although it's a bit tricky to get all of the logic working correctly.
You can get some tips on how to do this from M3 itself by going in through OIS350 and drilling into the Accounting Transaction related to a specific Invoice.
Hopefully this helps some.

Copyright © 2025 Infor. All rights reserved.