Hello,
Trying to deactivate a warehouse and it gives us the Unreleased Transaction error.
Can’t seem to find any transactions related to this warehouse. any ideas?
Thanks in advance!
Hello,
Trying to deactivate a warehouse and it gives us the Unreleased Transaction error.
Can’t seem to find any transactions related to this warehouse. any ideas?
Thanks in advance!
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.
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
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
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.
This is technically a ‘virtual’ warehouse. Not sure we’ve ever transferred to or from it.
k2
Have you tried to recalculate inventory IN505000??
k2
What is the status of release IN documents you have??
My GI will give you the balanced documents only,
Thanks
balanced:
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:
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.