Share
ReportThe 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
All responses (
Answers (
32,738
