web
You’re offline. This is a read only version of the page.
close
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 / Finance | Project Operations, Human Resources, ... / Open Inventory Transac...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Open Inventory Transactions for deleted production orders

(0) ShareShare
ReportReport
Posted on by AnnaP 20

Version: AX 2012 R1 Feature Pack 6.1.1108.2423

For various reasons we are no longer using the production control module. We ahve since run the job to clean up prodcition orders and no longer have any showing in any of the tables (ProdTable, etc). There are also no open journals in the production control module.

However we continue to have open Inventory Transactions for many of the no longer present production orders.

Some are Sold transactions with a reference of Production line or Co-product production.

Some are Purchased transactions with a reference of Production or Co-product production.

What can I do to clean these up? We have already ran the inventory close. These transactions are all several months old. Am I forced to just delete the InventTrans records?

Any ideas on how to proceed?

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,168 Super User 2025 Season 2 on at

    Hi Anna,

    It is not recommended to just delete inventory transactions. You can easily corrupt your environment. Can you tell more about the job you executed? Probably, it just deleted all production tables without any validations which causes the current issue.

    If you have Sold and Purchased transactions, it means that production orders were posted in the past. I do assume for a certain reason. The source entries to verify if they were correct or not was deleted with the custom job.

    What is the issue for having these transactions? If you have incorrect on-hand information, I would recommend to perform a counting or post a profit/loss inventory journal.

  • AnnaP Profile Picture
    AnnaP 20 on at

    The "deletion" came from running a job under TPC/Production control/Production orders cleanup

    I also tried running the other cleanup jobs there to no avail. There was no custom script

    For me deleting the InventTrans records is a last resort. Even before I ran the jobs that removed the prod orders the transactions remained open. They are not tied to any outstanding journals, etc.

    How else could I possibly close the transactions? There are no unposted journals. It isn't an onhand issue but finance is demanding they get cleaned up as they are effecting financial reports.

  • AnnaP Profile Picture
    AnnaP 20 on at

    The "deletion" came from running a job under TPC/Production control/Production orders cleanup

    I also tried running the other cleanup jobs there to no avail. There was no custom script

    For me deleting the InventTrans records is a last resort. Even before I ran the jobs that removed the prod orders the transactions remained open. They are not tied to any outstanding journals, etc.

    How else could I possibly close the transactions? There are no unposted journals. It isn't an onhand issue but finance is demanding they get cleaned up as they are effecting financial reports.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello AnnaP,

    Please don't delete the inventtrans records, as this might have some severe side effects on other things in AX (valuation, accounting, etc.)

    I would rather recommend doing a deep dive with your production and controlling/accounting people into this issue to find out why those transactions still show as open.

    If you cannot find a specific reason, why can't you leave those records as is?

    Best regards,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,168 Super User 2025 Season 2 on at

    Hi Anna,

    Thanks for the clarification you used an available job, however, I would like to understand the abbreviation 'TPC'. This cleanup task will probably only delete 'worksheet' type of tables, not posted transactions. Like mentioned above, if you need to cleanup on-hand, you have to post additional inventory transactions to zero them out; which would then also "clear" them from the financial reports.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans