web
You’re offline. This is a read only version of the page.
close
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 12

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

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

    Hi YMP,

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

  • Hello Word Profile Picture
    Hello Word 110 on at

    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?

  • Yin Mon Pyone Profile Picture
    Yin Mon Pyone 12 on at

    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.

  • Yin Mon Pyone Profile Picture
    Yin Mon Pyone 12 on at

    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

  • MATTGUO Profile Picture
    MATTGUO 22,349 Moderator on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans