GL missing

[ShashaQin]

Hi,
We found GL Entry will be lost in some case.
This is one sales invoice, including one finished goods item, and update stock ticked.

This is the Accounting Ledger of above sales invoice, looks some account records not generated. It should have one 'finished goods' account and one 'cost of goods sold' account like the third picture.

I'm not sure if this GL missing is caused by sales invoice created before stock entry, but the third picture is tested on version 7, that sales invoice is created before stock entry as well(Picture 1 and 2 are history data generated in the earlier version than version 7). I'm wondering if the version 7 fixed this issue, but not create a patch to fix the missing data.

[rohitwaghchaure]

Hi @ShashaQin
Can you check, what is the valuation rate of the item item1 before the date 09/09/2015.

[ShashaQin]

@rohitwaghchaure thank you for your reply. The valuation rate of the item1 is 0.
And I tested again on version 7, I found this problem still exists. 'Finished goods' account and 'Cost of goods sold' account are missing in GL Ledger.
I think the following two scenario will cause GL missing problem:

1. Stock entry created/submitted before sales invoice, but posting date is after the posting date of sales invoice.
2. Stock entry created/submitted after sales invoice.

[ShashaQin]

This is stock ledger for item1:

[ShashaQin]

This is GL report, the circled one couldn't find matched gl record that should be generated when submit SINV-12122 (as you can see the second picture)

[ShashaQin]

This will leave finish good account with amounts that won't be credited even if the correspondent Sales invoice or a Delivery Note is submitted.

[nabinhait]

@ShashaQin

You should always deliver / invoice after receiving the goods. If you deliver before receiving, system does not know the valuation rate and hence does not post the GLE for COGS.

To get better results, you should disable negative inventory, in case of perpetual inventory.

[ShashaQin]

@nabinhait Thank you for your reply. I know what you mean, but now our GL missed some data because of that. Do you have some suggestion or solution to fix those data?

[nabinhait]

May be a back-dated Stock Reconciliation for all the relevant items will fix the GL Entry for DN/SI.