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 / Small and medium business | Business Central, N... / Inventory - GL Recon
Small and medium business | Business Central, N...
Suggested answer

Inventory - GL Recon

(2) ShareShare
ReportReport
Posted on by JG-21012024-0 58
Hello,
 
I need to clear the old "expected cost" value by using purchase receipt lines, posting the invoice, and then creating a credit memo to offset it. These lines don't involve actual inventory, but I'm receiving a direct posting warning when running the "Inventory - GL reconciliation" because I'm posting to the liability account, which doesn't have "direct posting" enabled. Is it acceptable to leave it as is since the GL accounts are balanced, or is there an additional step required?
 
Thank you in advance for your help!
Categories:
Microsoft Dynamics NAV
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 45,585 on at
    Inventory - GL Recon
    Can you send us what journal entry you are trying to post? The screenshots don't seem like an error; it looks like a message box.
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 79,097 Super User 2025 Season 1 on at
    Inventory - GL Recon
    Hi, Please refer to the answer in the post below.
     
    Thanks.
    ZHU
  • JG-21012024-0 Profile Picture
    JG-21012024-0 58 on at
    Inventory - GL Recon
    @YUN ZHU we can't use the undo receipt feature because I believe there was movement on the sales order. Any other ideas?
     
    Thank you!
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 79,097 Super User 2025 Season 1 on at
    Inventory - GL Recon
    If you have posted the invoice and credit memo, this has already affected the general ledger.
    If you only want to affect the "expected cost", you should use Undo on the purchase receipt lines instead of canceling it using the invoice -> credit memo process.
    If you want to adjust it individually, although it is not recommended, you can only enable direct posting
     
    Hope this helps.
    Thanks.
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 15,635 Most Valuable Professional on at
    Inventory - GL Recon

    Hi, good day I get the impression that there is some customization in the process
    Best Regards
    Gerardo

  • JG-21012024-0 Profile Picture
    JG-21012024-0 58 on at
    Inventory - GL Recon
    Thank you @Suresh K
     
    I reversed my credit memo and will make an adjustment through a journal instead so I can clear the vendor (liability) and inventory, but I am still getting the error attached. Below is the adjustment I made:

    DR: Vendor (liability)
    CR: Inventory 

     
    Just to recap I am currently clearing purchase receipts that were never invoiced and have value sitting on "Expected Cost" affecting our inventory valuation.
     
    Thanks again!
    ERROR MESSAGE.png
    ERROR MESSAGE 2.png
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 45,585 on at
    Inventory - GL Recon
    You cannot leave like that; you need to debug and see why you are getting that error. You should be able to run that report successfully.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans