Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Wrong PO posted without cost price resulted in discrepancy with credit memo

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Dear All,

Here I required a solution for our ongoing issue regarding wrong PO posting will affect the GL account and item group.

Our team member created a PO with new SKU  and  posted without cost. We found the issue on very next day than issued  Purchase return for reversing the wrong PO and we posted the correct PO with value, which correct the inventory but not the GL account.

Direct cost applied - Average Costing Method have been using for us. Due to Purchase return credit memo posted to GL account was wrong and showing negative the value should be zero but it calcualting average and deducting the half from new posted cost

Kindly help us to clear the error.Nav-error.jpg

*This post is locked for comments

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    You could also have used a Credit Memo with Reverse Posted Document Lines function msdn.microsoft.com/.../hh168364(v=nav.90).aspx. As you currently did not have in your setup Exact Cost Reversing Mandatory as Santosh correctly mentioned, one good option is, as Andrea offered, to use Revaluation Journal to devaluate your item entry to zero: msdn.microsoft.com/.../hh168236(v=nav.90).aspx

  • Verified answer
    Andrea Antoniazzi Profile Picture
    Andrea Antoniazzi 285 on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Hi,

    In the Warehouse menu you should find the Revaluation Journal form. Here you can create a new line, select the item and, in the Applies-to Entry field, select the entry you need to revaluate.

    In the Unit Cost (Revalued) field you have to insert the correct unit cost and then you can post the entries.

    I suggest you to test the procedure in a test environment.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Dear Amol,

    Once after every purchase cycle we run Post Inventory Cost to G/L than only we identify the issue. Here the inventory qty is correct but cost posted to GL is wrong due to average cost method

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Kindly run Post Inventory Cost to G/L batch job and check

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Kindly run Post Inventory Cost to G/L batch job and checl

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Dear Mr.Santhosh,

    It's not checked. What's next to solve this issue.. guide us

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Dear Amol,

    Yes its posted without notice..thats why we reverse the entry and posted the new PO. Any thoughts?

  • Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Is the Transaction already posted ???

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Dear Santhosh,

    Will check and update you ASAP

  • Verified answer
    N Santosh Kumar Profile Picture
    N Santosh Kumar 40 on at
    RE: Wrong PO posted without cost price resulted in discrepancy with credit memo

    Hi Thirubala,

    In S&R Setup and P&P Setup called "Exact Cost Reversing Mandatory".  is checked or not checked.

    Kindly checked this option and then try again.

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 Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans