Item is configured with Weighted average costing method.
While checking in Stock transaction inquiry screen for a particular period, closing cost is almost double than the opening, receipts, transfers and internal usage cost.
What could be the reason for this ? And from where can I check the details which is causing this issue ?
Hello Syad,
I would start first with the Inventory Movement Report under I/C Stock Control Reports - Inventory Movement. Make sure IC Day End Processing is run first to ensure you have the up-to-date costs..
Here is an example:
you can see all the In and Out transactions that resulted in the Ending Balance.
My guess is that there was an Inventory Cost Only Adjustment but you can investigate using the Movement Report.
Regards,
DCrampton
Hello Syad,
I would start first with the Inventory Movement Report under I/C Stock Control Reports - Inventory Movement. Make sure IC Day End Processing is run first to ensure you have the up-to-date costs..
Here is an example:
you can see all the In and Out transactions that resulted in the Ending Balance.
My guess is that there was an Inventory Cost Only Adjustment but you can investigate using the Movement Report.
Regards,
DCrampton
Hi DC, Thank you for your reply.
Yes I have run the day end process, checked movement report but don't find any cost only adjustment.
I have another mismatch within IC which I noticed with other clients as well earlier. Let me know if you have any suggestions to this..
Item Location details, movement report, & all the transactions screen location qty is all showing 259
But the stock transaction inquiry screen is showing qty 229. What could be the reason for this? Within the module different screens showing different quantities.
Check for Qty committed. If you look at your location details and scroll further to the right you will see another column 'Quantity Available' which is adjusted for Qty Committed.
Yes I checked qty committed in location details and it is 0.
Quantity available in location details in 259 but in the stock transactions inquiry screen it is 229.
Please suggest if anyone knows how to find this difference and the root cause to it.
Can you go to Location Details and see if there are additional Locations? the Finder - Location Quantities in the IC Adjustments screen takes all locations and sums it up.. I wonder if there are quantities in the other locations that add up to 30 units.
I use the Transaction History screen for transaction queries. See if you can find the reason for the difference.
