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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Purchase credit note n...
Microsoft Dynamics AX (Archived)

Purchase credit note not affect to inventory

(0) ShareShare
ReportReport
Posted on by Yin Mon Pyone 12

Hi Experts,

Purchase order has 10 partial purchase receipts and actually it should be 10 invoices for particular purchase receipts.

But finance team wrongly create one invoice which is linked to 10 purchase receipts but amount is only type for 1 purchase receipts quantity. Stock has been used and no more stock in inventory.

I want to reverse those purchase invoice to correct the invoice amount.

THank You.

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Purchase credit note not affect to inventory

    Hello Sweety Star,

    To get this right, I would like to know if my understanding is correct:

    - your finance team created an invoice for one of the receipts but instead of matching the one receipt, they actually matched all 10 receipts

    - is that right?

    Best regards,

    Ludwig

  • Yin Mon Pyone Profile Picture
    Yin Mon Pyone 12 on at
    RE: Purchase credit note not affect to inventory

    Hi Ludwig,

    Yes you are right.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Purchase credit note not affect to inventory

    Hello Sweety Star,

    Thank you for the confirmation.

    By matching all 10 product receipts with the value of a single invoice, the total average price of your products was reduced to a much smaller amount.

    You have two options to get this corrected in my opinion:

    Option 1:

    Use the closing and adjustment for to record an adjustment to the amounts posted.

    You should be able doing that after a reconciliation/close of the inventory has been processed.

    Here is a post that illustrates how this can be realized:

    www.loganconsulting.com/.../adjusting-cost-on-inventory-transactions-in-d365-for-finance-and-operations-part-i

    Option 2:

    If the first option does not work out then you would have to manually reverse what has been posted and matched.

    That is, you would basically have to create a lot of corrective POs, packing slips and first reverse the wrong invoice posting and match.

    Then you have to create new POs, packing slips and post the invoice correctly.

    When doing that ensure that you use the marking functionality to ensure that the corrections do not mess up your cost prices.

    I would try option 1 first as it seems faster and easier.

    Please test in a demo/test version first and let us know if this fixed your issue.

    Best regards,

    Ludwig

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,671 Moderator on at
    RE: Purchase credit note not affect to inventory

    Only if your finance team allows, rather than making it complicated here is a simple solution, just have them enter one -ve amount invoice (via invoice journal for the "total amount posted - correct amount". This will get the amount corrected on this invoice. Offset can be 9 other invoices that you want. This is assuming, purchase prices/cost are not varying between invoices as they belong to same vendor/purchase order. Hope this works and with user training it won't happen again.

    This will get you total of 10 invoices that you can use now to pay your vendors.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Purchase credit note not affect to inventory

    Good Morning Sweety Star,

    Have you been able to do some testing to check how to correct this best?

    Would be great if you could keep us updated here.

    Many thanks and best regards,

    Ludwig

  • Yin Mon Pyone Profile Picture
    Yin Mon Pyone 12 on at
    RE: Purchase credit note not affect to inventory

    Hi Ludwig,

    Thank Your for your time and advice.

    Option-1, if we use closing and adjustment, although Item cost is ok, it will not hit to vendor.

    Option-2, it is not possible to reverse as stock has been used.

    We are thinking that we will use "Adjustment" function which is under posted invoice.

    this will adjust item cost and one of the ledger account (for eg- clearance account).

    Then, finance will reverse that clearance account to vendor account by using journal.

    Is that our way correct?

    Thank You.

  • Yin Mon Pyone Profile Picture
    Yin Mon Pyone 12 on at
    RE: Purchase credit note not affect to inventory

    Thank you for your advice.

    We have tentative solution as I mentioned in above.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Purchase credit note not affect to inventory

    Hello Sweety Star,

    You are right. Option 1 won't affect the vendor. At the time you post the adjustment the stock value will increase by the adjustment amount and the offset will be a P&L account. The posting should be something like: DR: Inventory CR: P&L account. To get the vendor balance right, you would have to do an additional manual posting where you debit the P&L account against the vendor. Something like DR: P&L account CR: Vendor. 

    If you use the adjustment functionality in the PO form you are basically doing the same, as the inventory value will be increased and a P&L account be used as the offset account that you have to manually clear.

    The main difference to Option 1 in my opinion is that the adjustment made in the inventory and closing adjustment form is better to track and follow. Adjustments made are not easily visible and identifyable. Irrespective of that, both processes should give you the right result. 

    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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans