Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

What to do next when the po has already posted but you realize the GL account for the item was wrongly set up in Posting Group in Navision 2018?

Posted on by 4,359

Dear Community,

I just realize one of the items in my inventory had a wrong GL account configured and a Purchase invoice was being issued.

1.May I ask what should be my net course of action in Navision?

2. Is there a way to transfer the amount in one wrong GL account to the correct GL account?

Thank you!

  • joshtechsolutions Profile Picture
    joshtechsolutions 4,359 on at
    RE: What to do next when the po has already posted but you realize the GL account for the item was wrongly set up in Posting Group in Navision 2018?

    Thanks Steve! Glad you are back. Hope you have had a good rest.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What to do next when the po has already posted but you realize the GL account for the item was wrongly set up in Posting Group in Navision 2018?

    Josh,

    Sorry for extended delay in reply but took some major time off. Directly fixing via GL Accounts is not advisable to keep the transaction audit intact. I recommend performing a Purchase Return Order to reverse the transaction. Then correct the Posting Group. Then quickly recreate the PO you received.

    If the above is not possible anymore, since you have paid the invoice, then I correct through a GL Journal entry and make sure you update the Posting Group so when you sell or consume the item is removed from the correct Inventory account.

    Hope this helps.

    Thanks,

    Steve

  • joshtechsolutions Profile Picture
    joshtechsolutions 4,359 on at
    RE: What to do next when the po has already posted but you realize the GL account for the item was wrongly set up in Posting Group in Navision 2018?

    Hi Steve,

    Yes, incorrect Incorrect Inventory Account or COGS. There are about 10 wrong entries, but since Zhu mentioned that it is not advisable to directly key into GL account. I wonder what is the next step.

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,472 Super User 2024 Season 2 on at
    RE: What to do next when the po has already posted but you realize the GL account for the item was wrongly set up in Posting Group in Navision 2018?

    Hi, I think the best way is to create a credit memo to cancel the wrong purchase invoice and then post a new correct one.
    It is not a good idea to directly adjust the amount in GL account.

    You can use the following method to create a credit memo quickly, or use copy document when creating credit memo.

    pastedimage1646781729189v1.png

    Hope this will help.

    Thank.

    ZHU

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What to do next when the po has already posted but you realize the GL account for the item was wrongly set up in Posting Group in Navision 2018?

    Josh,

    What is the actual issue? Incorrect Inventory Account or COGS or ? After you know the issue, we will need to correct the Chart of Accounts (GL Account) through a General Journal entry.  Now you also need to update the Inventory Posting Setup (Inventory Account) or General Posting Setup (Sales, Purchases, COGS, Direct Cost Applied, etc..). Both will resolve the incorrect Journal Entry and correct all future postings.

    Thanks,

    Steve

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans