You’re offline. This is a read only version of the page.
645
Hi
I have some inventory recalculation with settlement that didn't post to the GL. How Can I fix it ?
The recalculation is done, there is a lot of transaction in the settlement, but the voucher is blank.
Any Idea why this can happend?
Can I recreate the GL entry directly in the database
Thanks for your kelp
*This post is locked for comments
I have been able to regenerate the voucher.
I cancel all the recalculation to the point where there was no voucher. The recalculation with no voucher was a cancellation.
I unlinked the canellationRefId on the inventclosing table and I uncheck the cancelled for each line of the recalculation on the invent settlement table I also put back the RECALC to Active. This way I have been able to redo the cancellation of the recalculation and it rebalanced the GL.
Been able to do a recalculation to the end of the month and an invent closing.
Everything look ok.
I have seen this when there are a lot of transactions to process and the client machine may not be able to finish the task. This happens when companies rely on recalculation and only run inventory close e.g once a year or in some cases much longer periods. Its bad practise, but it happens. Even when you use helpers those only help the calculation part of the close, not the GL posting that results.
I don't know whether this is the cause of your problem- as Ludwig suggests then check the error messages.
If you think this may be the reasons, then you will find this old blog post of use to try and resolve things. http://natepaine.blogspot.com/2010/10/large-inventory-close-workaround.html
Hello alzelus,
In a test/demo environment you can certainly 'play' with the status.
However, I would not do that in a live environment if you are not absolutely sure what to do.
By the way, does your inventory recalculation has a log or an error sign? I regularly see recalculations that do not result in ledger postings. All depends on the transactions recorded. That is, if you do not see a ledger posting created there must not be something wrong.
Best regards,
Ludwig
It look like there was a problem at the moment of the posting to the ledger.
The settlement is full of transactions but none of them have been written to the GL. Even if I try to cancel it it is acting like it have been posted.
Can I play with the status in the DB to make it cancelable again ?
Hi,
One possibility might be that the voucher is still pending in the subledger journal postings not yet transferred form in GL. If this is not the case then print the adjustment report (print-adjustments) to get some additional insights. You might have settlements that are related to the 'marking' principle and consequently do not result in posted voucher transactions.
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (