You’re offline. This is a read only version of the page.
The user is attempting to change the quantity decimals for 2 of her items but is getting an error that the items are part of an open transaction. In addition to the regular inquiries in GP I have inquired on all of the Invoicing, SOP, POP and Inventory work tables. I also ran the script to find allocated items and inquired to see if the item was a component on a BOM. The only place I found the items in the work tables was in the IV10200 (inventory purchase receipts work) and the IV10201 (Inventory Purchase Receipts detail). Those are Shipment/Invoice receipts and were paid almost a year ago. They did an adjustment today to remove the quantities from inventory. I can find no corresponding history tables to replace the IV10200 and IV20101 tables and, according to the research I have done, this information only clears out of those tables if the box to clear sold receipts is checked during the inventory year end process. It also cautions against clearing it since it will remove the history of the transaction. In addition, it would no longer offset the adjustment transaction if it were removed.
The receipts and the adjustments are the only 2 transactions for the items to date. The questions are:
1. Would the records in those 2 tables be the reason the user is getting the error? That would seem strange since those tables do not clear even when the transaction is no longer open.
2. What would be the ramifications of removing history for the two items? Would that even resolve the error?
3. If it becomes necessary to change the Quantity Decimals in SQL, would there be any issue since there are no open transaction and the inventory balance is 0 for the 2 items?
Thanks!
*This post is locked for comments
Hello Nola,
Let me go through your inquiries one by one,
Question One
You are not supposed to touch any of the tables (IV10200 and IV10201) and neither any of the historical records in (IV30300) or (SEE30303), these tables include the posted inventory related transactions. After posting a receipt from purchasing, adjustment/ transfer from the inventory or sales invoice from the SOP, these four tables records the transactions accordingly.
It is worth to be mentioned, in inventory, there is nothing called open. Transactions are moved automatically to history when posted.
Question Two
removing transaction history will empty the IV30300 and associated tables, while keeping (IV10200, IV10201 and SEE30303) tables. The ramifications of removing inventory history is represented with losing the following source of data"
Have a look on below links.
community.dynamics.com/.../203362.aspx
community.dynamics.com/.../change-decimal-places-inventory-utility.aspx
Hope this helps!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (