Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Issue with Financial E...
Microsoft Dynamics AX (Archived)

Issue with Financial Effect of Purchase Order Posting

(0) ShareShare
ReportReport
Posted on by Rajat walia 380

Dear Experts,

 

I am very new in AX and I have an issue with the financial effect of Purchase Order Posting.

I Notice that: Effect on Financials after Updating the status as Receive:

 

Purchase Accrual = -100     Cr.

Product Receipt =   100     Dr.

 

Effect on Financials after posting the Invoice for the same .

Purchase Accrual = 100 Dr.

Product Receipt   = -100 Cr.

Purchase, Inventory Receipt = 100 Dr.

Purchase Expenditure for Product = 0

Accounts Payable = -100 Cr.

 

But i want two more entries system must post.

First One Purchase Account = 100 Dr.

and Second One is Direct Cost Account = -100 Cr.

 

 

I will wait for your Response,

Thanks in Advance

Best Regards,

Rajat W

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Issue with Financial Effect of Purchase Order Posting

    Hello Rajat W,

    As an end user you cannot configure that accounting 'framework/logic'.

    A developer can do that.

    I would thus recommend that you talk to one and consider whether you want to adjust this or not because making modifications to the accounting framework can be 'tricky'.

    An alternative to this configuration are automatic charge codes that post with the invoice. If you setup a 100% charge code that debits and credits specific accounts you can basically achieve the same. Maybe this is something that you would like to test in addition. If this is interesting, you can find some hints on my blog how to realize that.

    Best regards,

    Ludwig

  • Rajat walia Profile Picture
    Rajat walia 380 on at
    RE: Issue with Financial Effect of Purchase Order Posting

    Hi Ludwig,

    Thank you for your precious time.

    i tested but charge and stock variation accounts are hitting at the time of posting receipt but i want to hit the same at the time of posting invoice.  Is there any setup which i am missing?

    and we are not following negative quantity with PO, so not an issue with us.

    Now the only thing both Accounts are hitting at the time of posting Receipt but how can we post at the time of posting invoice ?

    Thanks & Regards

    Rajat W

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Issue with Financial Effect of Purchase Order Posting

    Hello Rajat,

    Have you been able to test this functionality?

    Best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Issue with Financial Effect of Purchase Order Posting

    Hello Rajat,

    Those accounts are 'direct cost accounts' that you can use. They are posted when you post the invoice, as you mentioned.

    The only issue that I see is that those accounts are used only when purchasing items.

    If you have PO lines with negative quantities, the accounts won't be used. That's a major disadvantage. Therefore, test this feature carefully before using this in a live environment.

    Best regards,

    Ludwig

  • Rajat walia Profile Picture
    Rajat walia 380 on at
    RE: Issue with Financial Effect of Purchase Order Posting

    Hi Ludwig,

    Thanks For Your Response.

    So charge means Purchase Account and stock variation account means Direct Cost Account?

    if Yes Is it possible to hit this both accounts at the time of posting invoice?

    Previously i had worked on Microsoft Dynamics Nav and in Nav these both Accounts are hitting at the time of posting invoice only and i am looking for the same.

    Thanks Again,

    Rajat

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Issue with Financial Effect of Purchase Order Posting

    Hello Rajat W.,

    In the AP parameters form there is a parameter (post to charge account in ledger), which allows you creating the additional posting you ask for.

    To realize that you have to setup the charge and stock variation account types in the inventory posting matrix under inventory setup posting posting.

    Note: This additional posting is only created when you post a receipt. If you send back items to the vendor it is missing. To overcome this issue you can make use of auto charge codes that work in both 'directions' (receipt & issue).

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans