web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Financial cost not posted
Microsoft Dynamics AX (Archived)

Financial cost not posted

(0) ShareShare
ReportReport
Posted on by Dave.KWOK

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

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Dave.KWOK Profile Picture
    Dave.KWOK on at

    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
    Ludwig Reinhard Microsoft Employee on at

    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
    Dave.KWOK on at

    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
    Ludwig Reinhard Microsoft Employee on at

    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
    Dave.KWOK on at

    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
    Ludwig Reinhard Microsoft Employee on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans