web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Reset all on hand to z...
Microsoft Dynamics AX (Archived)

Reset all on hand to zero for specific warehouse

(0) ShareShare
ReportReport
Posted on by bassiony 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

I have the same question (0)
  • 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

  • guk1964 Profile Picture
    guk1964 10,888 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?.

  • 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

  • Community Member Profile Picture
    Community Member 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

  • 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

  • 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

  • guk1964 Profile Picture
    guk1964 10,888 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

  • 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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans