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 SL (Archived) / Batch will cause a cos...
Microsoft Dynamics SL (Archived)

Batch will cause a cost to quantity imbalance in itemsite when releasing a Batch

(0) ShareShare
ReportReport
Posted on by DJ Higue

When I try to release an Inventory Adjustment batch, I get the "Batch will cause a cost to quantity imbalance in itemsite" error and the batch will not release. Anybody knows how to resolve this?

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: Batch will cause a cost to quantity imbalance in itemsite when releasing a Batch

    Hi DJ,

    First you could try an run the IN Integrity Check for the inventory item that is causing the error and be sure to  check all the options on the left hand side.  

    Let me know if running the IN Integrity Check resolves the issue.

  • DJ Higue Profile Picture
    DJ Higue on at
    RE: Batch will cause a cost to quantity imbalance in itemsite when releasing a Batch

    Hi Carolyn,

    Thank you for your reply, I tried the IN Integrity Check but it didn't work. Oh, Also the version of SL that I'm using is 7 sp 4.

    DJ

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: Batch will cause a cost to quantity imbalance in itemsite when releasing a Batch

    Hi DJ,

    To help diagnose why a batch won't release, we use a tool called IN_Debug.  You would need access to SQL Server Management Studio.  You can find the instructions and script in KB 871506.  Use the instructions for the IN_Debug section, not the Database Calls instructions.

    The error message most likely identified the inventory id that is causing the issue.  When looking at the results of the IN_Debug, you can compare the Intran for that item to the records in the ItemSite table.  All this information will be in the results after running the IN_Debug.

    Let me know what you find after running the script and I'll try to help.

  • Peter Pino Profile Picture
    Peter Pino on at
    RE: Batch will cause a cost to quantity imbalance in itemsite when releasing a Batch

    Hello Carolyn, I would appreciate if you provide me the script of IN_Debug.

    Looks like KB871506_IN_Debug.sql link doesn´t work or no longer exists.

    Please send me to pinogarciap@hotmail.com

    Thank you very much,

    Peter

  • Community member Profile Picture
    Community member on at
    Batch will cause a cost to quantity imbalance in itemsite when releasing a Batch
    Wondering if anyone was ever able to finds the contents of the IN_Debug.sql script, we have a legacy Dynamics SL 6.5 environment we're responsible for that has issues with some inventory batches not releasing. 

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

Mansi Soni – Community Spotlight

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

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans