Skip to main content

Posts

Featured

Microsoft Dynamics GP throw SQL : Find differences between Bin QTY & all site QTYs

To be sure that your quantity is correct. You need to check from time to time if there are any differences between quantities for the same item in multiple tables. Item Quantity Master (IV00102) Item Site Bin Master (IV00112) This case applies only if you are using (Enable Multiple Bins) By using a SQL query  --------------------------------------------- SELECT * , ( All_Available - BIN_All_Available ) [Diff] FROM ( SELECT RTRIM(ITEMNMBR) ITEMNMBR, SUM (QTYONHND) QTYONHND, SUM (ATYALLOC) ATYALLOC, SUM (QTYONHND - ATYALLOC) SUM_Available, ( SELECT (QTYONHND - ATYALLOC) FROM IV00102 A WHERE A.ITEMNMBR = IV00102.ITEMNMBR AND LOCNCODE = '' ) [All_Available], ISNULL(( SELECT SUM (QUANTITY - ATYALLOC) FROM IV00112 B WHERE

Latest Posts

Microsoft Dynamics GP - How many user in each user class

How to solve 0xe0434352 in Visual studio 2017 & 2019?

How to register a DLL file to windows?

Microsoft Dynamics GP - SQL View for Unposted(SOP10200) & Posted(SOP30300) SOP Documents Details

Hello & Welcome