Notifications
Announcements
No record found.
I'm trying to enable Multiple bins for a client that is starting to use the inventory module. However when attempting to enable multiple bins, this warning comes up.
I've asked the end users to post all transactions but this message persists. Is there a SQL script that I can run to determine the exact transactions that are causing this message?
Jason
You can likely see the information in SmartList > Sales > Sales Transactions. Search for Document Type = Invoice and Document Status = Unposted.
You can also run Check Links on Sales Work to see if that finds any pieces out there.
Thanks for this suggestion. I have looked in both the Sales transcation and receivables transaction smartlists and there are no unposted documents.
I've also run check links on the Sales module with no changes. There must be a stored procedure that is running and checking on unposted transactions,
I was hoping I could find what that is looking at specifically as I believe all transactions are posted correctly.
SELECT * from SOP10100 on the company database will show everything unposted. You could filter it for just SOPTYPE=3 but I wonder if you may have other document types (like fulfillment orders) that may be giving you the message.
Here is the How To document on Multibin that is very helpful:
learn.microsoft.com/.../how-to-set-up-multiple-bins
Thanks again for your suggestion here. I've looked at this table in SSMS and it's empty. They actually do not use SOP at all. I've confirmed that SOP30200 is also empty.
They use RM, and I've double checked the RM10201 and RM10301 as well, again, tables are empty.
Does enabling multiple bins have anything to do with the purchase side? They do have open Payables transactions in the PM10000 table.
How do they invoice for inventory then? If it is the Invoicing module and not Sales Order Processing module, you need to check the IVC tables. (I am not a fan of the Invoicing module so I am not comfortable sharing SQL information on it but there should be a SmartList for it. I disabled the module for all of our clients/internal machines so I don't see it in my SmartList.)
P.S. There is no inventory related to PM or RM tables/transactions.
Thanks for your help on this! I was able to review the IVC tables (specifically IVC10100 and IVC30101). There were transcations in the work table that had already made it to history, but for some reason did not get removed from work. Once I removed those records and the IVC10100 was empty, I was able to enable multiple bins.
Excellent. I'm hoping you are just testing Multi-Bin prior to going live. With Multi-Bin being an advanced feature released long after Invoicing's more robust replacement Sales Order Processing module, I wonder how much testing was done on the module when Multi-Bin was released. Hopefully someone from Support will chime in with more information.
Hello Lisa,
I was not here before Multi-bin but I know you cannot use multi-bin when you are using the older Invoicing module. This is why it forces you to post all unposted invoices. You need to use the Sales Order Processing module with Multibin.
Thank you, Becky, for confirming what I thought may be the case.
[There cannot be any unposted invoices in SOP either. I believe it is because the "bin" that was used when the invoice was created may not exist after multi-bin is activated. I recommend assigning all items to a Default Bin before activating to avoid the AUTOCREATE bin being used to hold the post-activation inventory.]
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 659 Most Valuable Professional
André Arnaud de Cal... 533 Super User 2025 Season 2
Sohaib Cheema 289 User Group Leader
