Error message: quantity falls into negative inventory (dln1.itemcode)

Exceptionally, a scanner operation generates the following error message:

Possible Cause 1

The warehouse manager has not completed the Cycle counting process by booking the goods into stock after correcting.

Solution

The Cycle counting process can be completed by booking the goods into stock using the “Update” button.

Possible Cause 2

This error can also be generated as of differences between Standard SAP stock and Produmex WMS stock. If the setup of the SQL stored procedure: dbo.SBO_SP_TransactionNotification is not done according to the Boyum documentation, this may probably cause many differences.

If you find any differences between Standard SAP stock and Produmex WMS stock, please send a support request to the Boyum IT Support Center. Please note that this support request might be classified as a premium service (consultancy services).

Following queries can be used to detect these differences. Likewise, the Hana sql statements are included.

1.1. Query for detection stock differences (1) - MS SQL

select OINM.*, PMX_INVD.*

from OINM

LEFT OUTER JOIN PMX_INVD on OINM.CreatedBy = PMX_INVD.DocEntry

LEFT OUTER JOIN OWHS on OINM.Warehouse = OWHS.WhsCode

where PMX_INVD.DocEntry is null and OWHS.U_PMX_IMBP = 'Y'

1.2. Query for detection stock differences (2) – MS SQL

select *

, COALESCE(SAP."qty", 0) - COALESCE(PMX."quantity", 0) AS MissingQuantityInPMX

from

(

select OITW."WhsCode", OITW."ItemCode", COALESCE((OIBT."Quantity"), ("OnHand")) as "qty", OIBT."BatchNum" , OIBT."InDate"

from OITW

left join OIBT on OIBT."WhsCode" = OITW."WhsCode" and OIBT."ItemCode" = OITW."ItemCode"

where COALESCE((OIBT."Quantity"), ("OnHand")) > 0

) AS SAP

full JOIN

(

select PMX_OSWH."SboWhsCode", PMX_INVT."ItemCode", SUM(PMX_INVT."Quantity") as "quantity", PMX_ITRI."BatchNumber", PMX_ITRI."CreateDate"

FROM PMX_INVT

inner join PMX_OSEL on PMX_OSEL."Code" = PMX_INVT."StorLocCode"

inner join PMX_OSWH on PMX_OSEL."PmxWhsCode" = PMX_OSWH."Code"

left join PMX_ITRI on PMX_ITRI."InternalKey" = PMX_INVT."ItemTransactionalInfoKey"

group by PMX_OSWH."SboWhsCode", PMX_INVT."ItemCode", PMX_ITRI."BatchNumber",PMX_ITRI."CreateDate"

)

AS PMX

on PMX."SboWhsCode" = SAP."WhsCode"

and COALESCE(PMX."BatchNumber", '') = COALESCE(SAP."BatchNum", '')

--and PMX.BatchNumber = SAP.BatchNum

and PMX."ItemCode" = SAP."ItemCode"

where COALESCE(SAP."qty", 0) <> COALESCE(PMX."quantity", 0)

1.3. Query for detection stock differences (1) – Hana SQL

SELECT OINM.*, PMX_INVD.* FROM "OINM"

LEFT OUTER JOIN "PMX_INVD" ON OINM."CreatedBy" = PMX_INVD."DocEntry"

LEFT OUTER JOIN "OWHS" ON OINM."Warehouse" = OWHS."WhsCode" WHERE PMX_INVD."DocEntry" IS NULL AND OWHS."U_PMX_IMBP" = 'Y'

1.4. Query for detection stock differences (2) – Hana SQL