We have an issue with our Inventory Reports giving...
# ask-stanley-ai
l
We have an issue with our Inventory Reports giving the wrong values. It all comes back to the Work Order Issue. When we issue a part through a work order, the part is no longer visible on the inventory valuation report, and the total value no longer matches the accounted value.
c
AI generated answer (using internal Slack threads):
****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Based on the conversations, it seems that the issue with the Inventory Reports giving the wrong values could be due to several factors. 1. Work Order Commitments: If items are committed to a Work Order, they will still show as committed even if they are transferred to a different location or adjusted out of stock. This could be causing discrepancies in your inventory valuation report. One solution discussed was to produce what can be produced with the available items, then close the Work Order and create a new one for the remaining items once their replacements come in. 2. Inventory Revaluation: If you're trying to revalue inventory items without changing quantities, the GL impact seems to be based on today's inventory value, which could be lower if some of the items have sold since then. This could be overstating the adjustment. One workaround suggested was to bring inventory to 0 on a day with no inventory transactions, then bring the inventory back up to stock at the correct value after a full calendar day at 0 on hand. 3. Inventory Costing Calculation: If there are backdated transactions still processing in costs, this could be causing discrepancies in your inventory valuation report. You can turn on the preference for display report titles and run an inventory valuation to see if costs are still being calculated. If an inventory costing calculation is currently scheduled or in progress, the values on the report may be incorrect until this calculation completes. Please note that these are potential solutions based on the conversations and may not directly solve your issue. You may need to further investigate the cause of the discrepancies in your inventory reports.
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.8272506
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823414505
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823299885
Please provide your feedback on this answer.