We are currently upgrading from 10.1.500 to 10.2.700 and are experiencing an issue with the General Ledger.
The General Ledger Report is correct when run as “Detail Account” but when run as “Full Account” it is incorrect, transactions from our legacy version are missing. This is causing an issue when running allocations, it doesn’t pick up the transactions that are missing from the Full Account general ledger so I don’t believe this is just an SSRS issue. Has anyone had a similar issue?
In case anyone comes across this issue, it was due to an extra character at the end of many glaccounts in our legacy version (erp.glacctdisp). Epicor was able to provide a datafix to remove.
Are you sure the same period range was selected for the Full Account report? I don’t see any lines for period 1 on that one.
That “extra character” is the segment separator. Do those accounts have dynamic segments?
Hi Calvin, thank you for providing the correct term. We do have dynamic segments on some accounts, but it would only be for ___-00-00-0000 accounts not any of the accounts that are having issues. The one thing these all seem to have in common is that they’re all allocation sources.
Yeah. After a second look, I see that extra charcater on only some of the rows for the same GL Acct#
What table was that query from? If you can find the Jrnl Code, Jrnl Num and line, you could run the Inventory WIP Recon report for that journal info and it could show you the source of the transaction that made those entries.