Dear Experts, After inventory posting multiple lines are posted in TranGLC but in GLJrnDtl only accumulated amount (only single line) is posting. We are facing issue during reconciliation.
Please suggest how to do setting at company level so that multiple lines will post in GLJrnDtl.
It’s a setting in the COSandWIP Posting Rule. Set Summarization to “No Summarize” if you want every individual transaction to hit the GL Accounts.
You will need to create a new revision by copying the current active revision. you will then be able to change the setting on the new revision and make the new revision active.
PLEASE test the new revision in a test database thoroughly before making this change in the Live database. You want to be 100% sure of what will happen when you make the change. After making the new revision active, you will want to process all inventory transactions to make sure everything still posts as expected.
Thanks tsmith, I have created the new revision by copying the current active revision. After that changed the Summarization to “No Summarization” and made the new revision active in test application.
As a side note, you don’t want to perform reconciliation AFTER posting. This should be done BEFORE hand. That is why there is a summary feature by default (and performance).
If you need to break it out after posting then use a BAQ that joins TransGLC to GLJrnDtl.
For what it’s worth, you can see the inventory transactions that make up a “Periodic Posting Process” GL entry, by using the WIP Recon report. There you can enter the GL code (IJ), Fiscal Year, and GL Num. All the trans for that summarized GL entry will be reported.
Dear Jason, Please suggest how to reconcile COSAndWIP and GL report for all Inventory Journal Accounts fro perticular year and period.
You use the “Inventory/WIP Reconciliation Report” and set it to display both posted and unposted transactions. It will show transaction details for each account you choose during the selected Period/Date range.
Our Accounting Manager uses this report to reconcile Inventory and Labor GL accounts before running the Capture COS and WIP process.
Word of caution when using the WIP Recon Report. Each Part transaction can be shown as either the Tran date (date you told E10 the tran actually happened), or the Sys Date (the date the transaction was created.
And neither of these have to jive with the date the GL Trans created by the Capture COS/WIP will use.
For example,
Since Period 6 is closed, the PUR-STK tran cannot be recognized as happening on 6/30. So(depending on the settings in Capt COS/WIP), the PUR-STK tran is applied to FP 7 with a GL Tran Date of 7/1.
WIP Recon will show the tran as either on 6/30 (if using Tran date), or 7/5 (if using Sys Date). Neither of these match the 7/1 date the GL uses.
To further confound things. Running the Stock Status Report with a date of 6/30, it will include that PUR-STK tran making your inventory value not match the GL acct for inventory. Because the GL wasn’t hit until 7/1.
