Validation like committed qty not greather than available qty SAP Business one

[nikunjmehta2290]

Dear all,

Need to develop validation into Inventory transfer request like Total committed quantity is not greeter then total available quantity from all the warehouse.  SAP is not allowed to create the inventory transfer request document if committed quantity from all warehouse is exceed from sum of available quantity.

All warehouse available quantity is 100.   SAP is not allowed to make 101 quantity inventory transfer request document. 

SAP Business One

Regards,

Nikunj 

[Yadharthavel]

Hi @nikunjmehta2290 ,

SELECT * FROM OWTQ T0
INNER JOIN WTQ1 T1 ON T0."DocEntry" = T1."DocEntry"
LEFT JOIN OITW T2 ON T1."ItemCode" = T2."ItemCode" WHERE T2."IsCommited" < T2."OnHand"

[nikunjmehta2290]

I need to set validation for same.

[Yadharthavel]

Yes if you can manage the parameter sounds good otherwise let me know will share you with parameter