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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bin Quantity Table (IV...
Microsoft Dynamics GP (Archived)

Bin Quantity Table (IV00112) - Can I delete zero quantity lines?

(0) ShareShare
ReportReport
Posted on by Simon Baldock 60

We have about 1500 lines in the Bin Quantity Table which are redundant ie QUANTITY =0 and ATYALLOC=0 - where the item did exist at one time in the bin but is no longer there. When I run a stock count it includes all these zero lines which is totally unnecessary.

Is it safe to do a SQL delete where QUANTITY=0 on this table?

*This post is locked for comments

I have the same question (0)
  • Simon Baldock Profile Picture
    Simon Baldock 60 on at
    Re: Bin Quantity Table (IV00112) - Can I delete zero quantity lines?

    well, took the plunge and ran the script. Everything seems to be ok. Thanks for the help!

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: Bin Quantity Table (IV00112) - Can I delete zero quantity lines?

    No, we had no issues.  Are you re-using Stock Counts?  After you delete the bins and a Stock Count is created, you should not see these zero bins in the count.  Before we started running the procedure at night we used to remove the Zero bins from the Stock Count (AFTER it is created but BEFORE it is started).  There were no issues with this (unless the count was started and/or someone was editting the count while we were deleting zeroes-which is a DISASTER.)

    Tim

  • Simon Baldock Profile Picture
    Simon Baldock 60 on at
    Re: Bin Quantity Table (IV00112) - Can I delete zero quantity lines?

    Thanks for the reply Tim.  Did this throw up any issues when you did this?  Our issue was that even if the item was no longer in that bin - the count sheets continually listed all items that have ever been in that bin location - which was a lot of zero entries!

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: Bin Quantity Table (IV00112) - Can I delete zero quantity lines?

    We do that here every night with a SQL Job.  We make sure we don't delete any default bins.  I have been planning on refining this procedure to only delete zero bins after a certain amount of time (60 days).  Those zero bins might not be unnecessary when you're trying to find (missing) stock during a stock count.  But it has worked well for us so far.

    DELETE IV00112 WHERE QUANTITY = 0 AND ATYALLOC = 0 AND BIN NOT IN ('APPR','SHIP','INSP','FGRLS','WIP')

    Tim

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: Bin Quantity Table (IV00112) - Can I delete zero quantity lines?

    I don't know about deleting those lines, but you can use the Remove Bins Utility to disassociate the bin-item relationships.  Several rules exist to prevent valid item-bin relationships from being deleted, so it's probably safer to use this than a SQL script.

    This is found under Tools | Utilities | Inventory | Remove Bins.

    Also, make sure you don't have any existing stock counts (started or not) in the system when you run this Utility.  If an item-bin combo is deleted by the Utility, but then you open up an existing stock count that has this item-bin relationship already defined, it will recreate the relationship.  

    David

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans