Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Reset all on hand to zero for specific warehouse

Posted on by 45

Hi All

i need x++ code or anything to reset all on hand items to zero because i have anew counting journal i will make but not all items is available now and this items which is not available having wrong on hand 

any solutions  please ,

Thanks.

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reset all on hand to zero for specific warehouse

    Hi,

    You mentioned that you do not know how much is availabe in the retail store and on hand in the system.

    If this is right, I would recommend doing a stock counting first before trying to fill and post a journal with quantities and items you do not know exactly.

    Best regards,

    Ludwig

  • guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Reset all on hand to zero for specific warehouse

    its about how you create your count journal - see Guy's post on this https://community.dynamics.com/ax/f/33/t/205731

  • bassiony Profile Picture
    bassiony 45 on at
    RE: Reset all on hand to zero for specific warehouse

    Hi,

    i have  a lot of item transaction and 3 retail stores before some time the post inventory having some issues,so a lot of item the real on hand now is not accurate in the system,so i am making new count journal to update on hand quantity but still the problem because some items thats having on hand in the system not on retail store now so how i can update all on hand for this item to zero ,this is the main problem i dont know which item is not available in retail store and have on hand in the system hope you get my point

    so i need before i make the count journal to make all on hand for all item as zero

    thanks

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reset all on hand to zero for specific warehouse

    Hi,

    Can you detail why you still have 30 items on hand?

    If you post 70 items in a counting journal there should be 70 on hand and not 100.

    Would be great if you could explain your issue in more detail.

    Many thanks and best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reset all on hand to zero for specific warehouse

    Use the checkbox on the left to select all -> Export -> Select Export All Data -> Add the field "Name" and "Quantity on Hand" -> Set to 0 -> Import back to OpenERP

  • bassiony Profile Picture
    bassiony 45 on at
    RE: Reset all on hand to zero for specific warehouse

    Dear ludwiq

    I know this and i already post the journal the problem ,suppose i have 100 items all this item having on hand quantity in the system

    When i make count i already found 70 items so this 70 items will only having correct on hand now,the other 30 items still having on hand quantity and not inserted in the count journal this happened due to some problem of posting inventory on hand before

    So i need to adjust the 30 item to zero on hand

    Thanks

  • guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Reset all on hand to zero for specific warehouse

    Can't you just do a counting journal to as zero?

    Or just issue it and offset against the cycle count loss account or a scrap account?.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reset all on hand to zero for specific warehouse

    Hello bassiony,

    Posting the new counting journal should change / reset the on hand quantity.

    Have you already posted the journal?

    Once, it is posted your on-hand inventory should be correct, meaning in line with the quantity that you specified in the journal.

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans