Enable Bins Error

[Former Member]

When I try to enable bins for one warehouse I get the following response: 

"You cannot enable bin locations; close associated inventory counting documents and pick lists associated with the warehouse"

All Pick Lists are closed.  Is there a SQL statement to run to find the other documents that are preventing this process?

Thanks,

Rob

[Former Member · Accepted solution]

The issue was a partially shipped picklist.  Found from the SQL SELECT * FROM OPKL WHERE OPKL.Status <> 'C'

This must return no rows for the warehouse in question.

[Former Member · Accepted solution]

Hi Thanks for sharing the solution.

[Abid_Hussain]

HI,

Execute following query with your warehouse code and close all output Pick List then active BIN of there is not inventory open  counting documents.

SELECT distinct t0."AbsEntry"
FROM OPKL T0
LEFT JOIN PKL1 T1 ON T0."AbsEntry" = T1."AbsEntry"
LEFT JOIN ORDR T2 ON T1."OrderEntry" = T2."DocEntry"
LEFT JOIN RDR1 T3 ON T2."DocEntry" = T3."DocEntry"
WHERE T0."Status" <> 'C'
and t3."WhsCode" = 'warehouse_code';

replace "warehouse_code" with your your warehouse code.

regards 

Abid  

[Former Member]

Hi,

     did you close the Inventory Counting document??? under

Menu, choose >Inventory >Inventory Transactions >Inventory Counting Transactions > Inventory Counting

Check if there is any document which is using that warehouse and close that if it is there.

Regards,

Manish

[Former Member]

Thanks Manish,

But there are no documents in that location.  ANything else?

[Former Member]

Also  Check  the Inventory Posting document under the same path

Menu, choose >Inventory >Inventory Transactions >Inventory Counting Transactions >Inventory Posting

Regards,

Manish

[Former Member]

Thanks again, but no documents there either.