4
Dear Master,
We are using SWL (Site, Warehouse, Location) and our inventory are correct in Warehouse wise.
The problem is that when we look at location wise, it is incorrect.
So, my question is in AX, what is the best inventory journal for those adjustment?
Notes: we do not need to adjust cost.
Thank You.
*This post is locked for comments
Use a counting journal by location, set everything to 0
Yes, excellent. I accept to use transfer journal.
I have another case. for example, site- 002 , under site-002, there are two warehouses 002M (main) and 002V (van sales) .
Under 002V warehouse, there are several locations like 002V001, 002V002, 002V003, so on which represents to each sales Location (Van).
We are doing sales only on 002V and at the end of the day , 002V must be zero and all inventory balance must be transferred to 002M.
Our problem is in last year, when we did the inventory adjustment, users only did adjustment on Van Warehouse (clear to 002V = 0 ) and all the locations under 002V have + or - balance like eg 002V001 = 5 and 002V002= -5 . Now we want to zerorize to those locations without impacting cost.
How do we do and which journal to user for those adjustment?
Thank You.
Thank You for your advice.
Thank YOu
Use the transfer journal and transfer the same values for site and warehouse and just change the location.
For clarity - it seems you are referring to quantity not value - in which case the valuation method does not matter the physical on hand quantity needs to be right for all levels of location - i.e. inventory should be the right quantity in the right location and if its not then it needs to be adjusted to the actual quantity for that specific location
When you adjust a quantity how the cost value then changes i.e. at location, warehouse, or Site and how e.g. the weighted average is calculated i.e. across what other units of that item's inventory held in other locations. and how the values reflects in reports will depend on your set up. Nonetheless the physical needs to be correct for the location.
I am not clear whether you are controlling by location a location within a warehouse, or just by Warehouse. Averaging costs by each location rather than for all stock of an item in the same warehouse, or even Site average, is generally not pragmatic for most companies
Hello Yin Mon Pyone,
Do you actually track financial values at the inventory level?
Can you check this is your inventory storage dimension groups used?
If you don't track financial inventory at the location level, you won't get useful data in reports.
Best regards,
Ludwig
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (