Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inventory Closing Error
Microsoft Dynamics AX (Archived)

Inventory Closing Error

(0) ShareShare
ReportReport
Posted on by MuhammadFaisal 329

Hello Experts,

I am facing an error during the closing of the inventory. During the closing of the inventory an error popup that "Account number for transaction type Inventory, inventory loss does not exist." and the process of closing stopped and red cross is showing with  inventory closing line.

After receiving this error, I have add the account for inventory loss for All in the inventory posting and tried to resume the inventory closing but still inventory form is showing the same error.

I have tried to re-close the inventory for same period and infolog showed me that inventory of this period is closed. but the inventory closing line is still showing red cross.

I have also tried to close the inventory for the next month and infolog popup with showing the message "Another closing or adjustment has not finished yet." 


Please note that i am using FIFO inventory model.

Kindly suggest me what i should do next to resolve this issue.

Many Thanks and Regards

Faisal

*This post is locked for comments

  • MuhammadFaisal Profile Picture
    MuhammadFaisal 329 on at
    RE: Inventory Closing Error

    Hi magic1949,

    error log doesn't show any id or item detail which is causing problem. so i am blank in this case.

    Regards

    Faisal  

  • guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Inventory Closing Error

    A movement journal can still post - but still have  problem

    Are you able to id a specific transaction that has a problem?

  • MuhammadFaisal Profile Picture
    MuhammadFaisal 329 on at
    RE: Inventory Closing Error

    Hello  magic1949 ,

    Thank you for the reply. All movement journal are posted which have transactions related to the inventory closing period. So, i don't think so that the issue is with the movement journal and also verified that no open movement journal is available for the month of inventory closing and for the other suggestion, I am using marking option in movement journal with transfer order so there are too many lines in the settlement which are without the account.

    Can you please further guide that how can i only check the lines which are not lines of marking or purchase order so that i can filter out the only transaction which have financial transaction. in this way i will be able to find the actual transaction which is causing this error.

    Thanks and Regards

    Faisal

  • MuhammadFaisal Profile Picture
    MuhammadFaisal 329 on at
    RE: Inventory Closing Error

    Thank you for your reply. The in-complete closing is the last one not the second last. and button of cancellation is disable on the inventory closing form for this in-complete transaction line. so i cannot cancel it.

    Thanks and Regards,

    Faisal

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Inventory Closing Error

    You can't close a future period until prior periods are closed.

    The issue is probably on movement journal(s).

    Ideally reverse and reenter with the correct account - otherwise see this former thread suggests  relevant places to look https://community.dynamics.com/ax/f/33/t/232555

    Otherwise try this:

    Copy your live system to test.

    Find the transaction with the missing account, then go to the  InventSettlement table . and  look for another record  of the same type (same item group, same kind of transaction) that has the proper account, (if necessary then create new one to add and stock and then do another to delete it ( do it in an test system) . Compare the two records to see the difference i.e. which field is missing what account - specifically check the OperationsLedgerDimension column, for the record that is correct, to find what is entered there on the correct transaction   that belongs to the account of the item group, and for the record that is causing you the error, this field is probably   empty, complete the field with the same record that is correct (the field is editable).

    (You may have to do this for more than one transaction.)

    Run month end again and see if it now works and posts as expected, then back up your live system (just in case) and then do the same in your live system.

  • MuhammadFaisal Profile Picture
    MuhammadFaisal 329 on at
    RE: Inventory Closing Error

    Hello Crispin John Augustine,

    Thank you for the reply. At the time of closing, after poping up the error closing was stopped automatically by the message "Closing is being paused because of an error.Please fix the problem and resume the calculation."

    After receiving this message i configure the loss account in inventory posting and resumed the calculation but it gave the same error. i have already tried to re-close but it gave the error that inventory already closed.

    I am looking for same that if i can get rid of this in-complete closing. Any suggestion on it?

    Thanks and Regards,

    Faisal

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans