Cannot Deactivate Warehouse (unreleased transactions)

Is there possibly an inventory count sheet that is not completed? I had the same issue once, and support helped me find that it was a count sheet which doesn’t give you the transaction details in the error.

@meagan59 i just looked, there are no Physical Count Sheets open...all completed…

This is technically a ‘virtual’ warehouse.   Not sure we’ve ever transferred to or from it. 

k2

Any related transactions open on Release IN Documents IN501000? Not sure how you could limit that to a single warehouse

The InRegister table is pretty easy to access - you might try to copy the Issues IN3020PL or Receipts IN3010PL GI and change some conditions like INRegister.Status and INSite.SiteCD to match (does not equal “Released” / equals “PRINTQUEUE” 

Hi @K2a 

Please import the below Generic inquiry into your system,

The below GI gives you the details of IN documents in Balanced status with warehouse details,

Please review and clear the balanced status document

@kyle90 - there are only 2 rows on the Release IN Documents screen and I looked into each one, neither related to the PRINTQUEUE warehouse.

@manikantad18 thank you, I tried your GI and it brings up 0 rows.  Shouldn’t it have at least brought up the 2 rows from the Release IN Documents?!

Have you tried to recalculate inventory IN505000?? 

@kyle90 yes, did that before I checked both the screen and the GI noted above.

k2

What is the status of release IN documents you have?? 

My GI will give you the balanced documents only,

Thanks

balanced:

Stumps me - probably time for a ticket

Only other thought; I know when we upgraded from 2020 R2 we had a number of “released” transactions stuck in a balanced state. They weren’t showing on the GI before the upgrade but popped up as soon as we sandboxed 2021 R2. We opened a ticket and Acumatica fixed the “underlying data.” They said it was related to AC-195724:

If a user created and saved a transfer on the Scan and Transfer (IN304020) form in one window, released the same transfer on the IN Transfers (IN304000) form in another window, and then clicked Save in the first window again, the system updated the released transfer, which led to data inconsistencies.
Similar issues occurred for documents created on the Pick, Pack, and Ship (SO302020) and Receive and Put Away (PO302020) forms.

We weren’t actually using the Scan and Transfer or Pick, Pack and Ship screens, but I assumed it might have happened via two browser tabs in a similar manner. If I remember correctly, the transaction status said balanced, but the items in the transactions were actually released, so it probably wouldn’t have shown on the INRegister, but they did still appear as balanced in the GIs. 

I am having the same issue. After modifying the inquiry above a bit, I have it showing all the records who are in play (there are only 5 open records), but NONE of them point to the warehouse I can’t close. I have also manually checked the following areas:

• Sales Orders & Shipments
• Purchase Orders
• IN Receipts
• IN Issues
• IN Adjustments
• Kit Assemblies
• Journal Transactions

Nothing is open that points to this warehouse. The Warehouse has been unused for over a year now. Anyone know how the system decides there is a pending transaction? I feel like it has to know and the error it returns is just not helpful. I would have hoped for a Doctype and ID in the error result.

Any help would be greatly appreciated.