Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inventory Location cle...
Microsoft Dynamics AX (Archived)

Inventory Location clean up

(0) ShareShare
ReportReport
Posted on by Yin Mon Pyone 4

Dear Experts,

Our inventory is used SWL , Site , Warehouse and Location.

Under one site, we have mainly two warehouses. For eg, Site = 001, Warehouse - Main Warehouse and Van Warehouse (for sales).

Site= 001

Main Warehouse = 001M

Van Warehouse = 001V

Van Warehouse is used for Sales and to control sales monthly. There are many Van Locations which represent to Van Cars under van warehouse. (notes: Products upload to each van car and send to customer shops)

Location 1 = 001V001

Location 2 = 001V002

Location 3= 001V003

So everyday, van warehouse has to be clear. Whatever balance are transferred to main warehouse (001M) everyday.

Last year we clean Van warehouse as zero but did not clean van locations. So, it becomes like eg  001V = 0 inventory and 001V001 = -100, 001V002=200 and 001V003=-100. Now we want to clean up van locations by using movement journal.

Could you advice how to clean up the location as warehouse is no inventory?

Thank You.

YMP

*This post is locked for comments

  • MATTGUO Profile Picture
    MATTGUO 22,317 on at
    RE: Inventory Location clean up

    Hi Sweety,

    When financial inventory is checked, the cost will be calculated by the warehouse or location level.

    If you donot check financial inventory for warehouse and location, the cost may be different if the purchased cost is different on location level.

  • Yin Mon Pyone Profile Picture
    Yin Mon Pyone 4 on at
    RE: Inventory Location clean up

    Hi All,

    We are using Site Warehouse Location (SWL). Our Physical storage setup is only Site and Warehouse.

    When system calculate the average cost, does system calculate cost by location?

    Cost in Warehouse and Cost in Location  can be different?

    Thank You.

    YMP

  • Yin Mon Pyone Profile Picture
    Yin Mon Pyone 4 on at
    RE: Inventory Location clean up

    Hi,

    I will use movement journal and will start with positive lines first.

    for unit cost for positive quantity, you can use either system auto cost or can enter your exact unit cost if you have.

    for offset account, either use inventory profit/loss or use temp account. But if you use temp account, you have clear after that.

  • Hello Word Profile Picture
    Hello Word 110 on at
    RE: Inventory Location clean up

    Hi YMP,

    Have you problem been solved?

    I have same issue as yours, but mine is at warehouse level.

    Could you please share the steps how to fix this issue?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,494 Super User 2025 Season 1 on at
    RE: Inventory Location clean up

    Hi YMP,

    You can use an inventory journal or transfer journal. Start with the lines with the positive on hand on the locations.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans