GLJrnDtl table

Epicor ERP 9
1

Epicor version 9.05.701

Hi, when i export the table “GLJrnDtl” it would be great to see the double entry of

The Accounts Receivable invoice AND the stock movement from balance sheet to the COS.

The report shows all entries as per the below example, however im struggling to build a more complete report of all the transactions together because there isn’t enough consistent data.
The 2 entries have different journal numbers, different transaction types…the only consistent data i can find is the JEDate…but this isn’t solid enough.

Any ideas??

image
image.png1866×292 24.4 KB

2

sussed it.

the last 3 digits of the stock movement element is the sales order number.

In excel, i was then able to use this as the tool to join both elements.