Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Financial cost not posted

(0) ShareShare
ReportReport
Posted on by

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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Financial cost not posted

    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

  • Dave.KWOK Profile Picture
    on at
    RE: Financial cost not posted

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Financial cost not posted

    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

  • Dave.KWOK Profile Picture
    on at
    RE: Financial cost not posted

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Financial cost not posted

    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

  • Dave.KWOK Profile Picture
    on at
    RE: Financial cost not posted

    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.  

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Financial cost not posted

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
Zain Mehmood Profile Picture

Zain Mehmood 6 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans