Microsoft Dynamics AX (Archived)

Inventory Adjustment for Location wise

(1) Share

Report

Posted on by Yin Mon Pyone

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

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
guk1964 10,888 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Weaveriski 23,620 Moderator on at

Like (1)

Report
Copy link

Link copied!

Use the transfer journal and transfer the same values for site and warehouse and just change the location.

Was this reply helpful? Yes No
Yin Mon Pyone 12 on at

Like (0)

Report
Copy link

Link copied!

Thank YOu

Was this reply helpful? Yes No
Yin Mon Pyone 12 on at

Like (0)

Report
Copy link

Link copied!

Thank You for your advice.

Was this reply helpful? Yes No
Yin Mon Pyone 12 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Weaveriski 23,620 Moderator on at

Like (0)

Report
Copy link

Link copied!

Use a counting journal by location, set everything to 0

Was this reply helpful? Yes No