I have one scenario here where the post financial inventory checkbox was unchecked.
Ledger was not able to be generated hence no financial cost was captured for po matching and posted invoice. Is there anyway we can regenerate the ledger entries for those transactions?
*This post is locked for comments
Hi Dave,
I see.
For 1), can you test posting an inventory adjustment journal for the item that was deducted before you change the settings of your item model group? This should bring the deducted item back to inventory.
Once this has been done you can add the financial parameter in the item model group, add a second SO line and post an invoice for $0.
This should fix the issue.
Would be great if you could test this.
Best regards,
Ludwig
Hi Ludwig,
For item 1, i think should not deduct inventory qty as it has already deducted on the original line.
Item 2 we will check on the setting.
Thanks and regards,
Dave
Hi Dave,
For 1), yes this workaround will reduce your inventory. Is this something you want to avoid?
For 2), there is a parameter available that allows you specifying the security level of already invoiced orders. If you set this parameter to none or warning then you can modify your order.
Best regards,
Ludwig
Hi Ludwig,
Thanks for your suggestion.
Few more question i would like to ask.
1. By adding another line with zero price, isnt that will deduct my inventory qty as well?
2. How can i perform this remedy as the SO already closed.
Thanks,
Dave
Hello Dave,
You refer to a sales order transaction, right?
If you have the stocked product parameter activated in the inventory model group but the financial ledger posting integration checkbox not, then only the sales revenue will be posted but no costs of the item.
This cannot be fixed easily and you are right that the margin on this specific sales order will be 100%.
One workaround is activating the financial posting Checkbox. Once this is done, you can add annother sales order line for the product. The sales price should be $0. Yet, because the item has a cost price >$0, only the costs will be posted and your margin will be correct.
Best regards,
Ludwig
Hi Ludwig,
Thanks for your quick response. Any double entries will be created if the post financial inventory checkbox is unchecked? My vendor told me that no ledger is being created hence sales will have 100% margin.
Hi,
The financial costs should be posted anyway. Can you check your inventory transaction and the (physical and financial) voucher form. What can you identify from there?
Best regards,
Ludwig
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
Community Member
48
Zain Mehmood
6
Moderator