![]() T3.OnHand – SUM(t0.InQty – t0.OutQty) + t1.countqty AS Calculation T1.Counted, – SUM(t0.InQty – t0.OutQty) + t1.CountQty AS Difference, SELECT distinct t0.ItemCode, T0.Dscription, t0.Warehouse, SUM(t0.InQty – t0.OutQty) AS, t1.CountQty, t3.OnHand , *SELECT 1 FROM OINM T0 WHERE T0.DocDate = ‘’ */ *SELECT 1 FROM OWHS T1 WHERE T1.whscode = ‘’ */ So, you can use this query that applicable for SAP B1 9.0 and higher version: It won’t give result because it is for SAP B1 8.82 and lower version Tracking the item that cause the error message. After that, you adjust the negative stock in warehouse after the inventory posting.Ģ. It means that you allow the negative stock in the system. You can do that by clearing the tick in the Block Negative Inventory By field. There are two solutions for these issues:ġ. See the error message that marked with black box.Īfter checking all of columns, you want to add the inventory posting but you can’t and receive the error message: When opening the inventory posting, here is the error message: Whilst in inventory posting of SAP B1 9.0, you will receive an error once you open the inventory posting and if you reconcile the inventory posting. ![]() Quantity falls in negative inventory + Which Item Similar issue has ever been occurred in the SAP B1 8.82 and lower version. ![]() Just to sharing the solution for the in-whse qty is negative issue when opening the inventory posting of SAP B1 9.0 and quantity falls into negative when adding the inventory posting of SAP B1 9.0. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |