Symptom
You are executing the G/L Account - Line Items report, however the wrong item-text is being shown for the journal entry items.
Reproducing the Issue
- Go to General Ledger work center
- Go to Lists view
- Open G/L Account - Line Items report.
- Execute the report with the Journal Entry Items
- Include the Journal Entry Item Text characteristic.
You see that for some journal entries you have different item texts, although the item text in these compared source documents (Customer Invoice) is the same.
Cause
In the customer invoices, for each of the line items, you have written a comment in both the Internal Comment and Customer Information tabs. In this case, if there are more than one text collection for an invoice item, the system would use any of them to create the journal entry, depending which one gets retrieved first in the backend. Hence, you may see different item text details in the report.
Resolution
This is the current design of the system. As there is no preference which text entry get sent to accounting, the system cannot decide which best comment get passed to accounting, as this may differ from customer to customer.
Keywords
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To