存货查账语句（Inventory audit statement）.docVIP

存货查账语句（Inventory audit statement） First, check the beginning of the data can be on the final balance Compare the savings and storage statistics and the balance sheet at the beginning and end. Two, the current review of the amount of - first, dont check them, see which ones dont amount to them, and then use the word odd numbers to write the pens one by one --1 single statistics, INV SELECT SUM (LA013*LA005 amount * out, leave), LA006 (single), FROM, INVLA, INNER, JOIN, INVMB, ON, MB001=LA001 (item number) INNER, JOIN, CMSMC, ON, MC001 (warehouse number), =LA009 warehouse LEFT, JOIN, INVMA, ON, MA002 (item number, class number) =MB005 (item No. 1) WHERE, LA004 (date), AND, LA004 AND, MA004 (inventory accounting), =140301, AND, MC004 (warehouse nature), =1 GROUP BY LA006 ORDER BY LA006 Single statistics: SELECT, SUM (LA013*LA005), LA006, FROM, INVLA, INNER, JOIN,, INVMB, ON, MB001=LA001 INNER, JOIN, CMSMC, ON, MC001=LA009 LEFT, JOIN, INVMA, ON, MA002=MB005 WHERE, LA004 AND, LA004 AND, MA004=140301, AND, MC004=1 GROUP BY LA006 ORDER BY LA006 - odd numbers: SELECT, SUM (LA013*LA005), LA006, LA007, FROM, INVLA, INNER, JOIN,, INVMB, ON, MB001=LA001 INNER, JOIN, CMSMC, ON, MC001=LA009 LEFT, JOIN, INVMA, ON, MA002=MB005 WHERE, LA004 AND, LA004 AND, MA004=140301, AND, MC004=1, LA006=1720, AND GROUP, BY, LA006, LA007 ORDER, BY, LA006, LA007 --2 single statistics, AJS SELECT SUM (TB007*TB004 currency amount * lending type), TB013 single FROM AJSTA, INNER JOIN AJSTB ON TA001 (manuscript batch number), =TB001, AND, TA002 (serial number), =TB002 WHERE TA006 document date AND, TA006 AND, TB005, subject number =1211 GROUP, BY, TB013 single ORDER BY TB013 - mono: SELECT, SUM (TB007*TB004), TB013, FROM, AJSTA INNER, JOIN, AJSTB, ON, TA001=TB001, AND, TA002=TB002 WHERE, TA006 AND, TA006 AND, TB005=140301 GROUP BY TB013 ORDER BY TB013 - odd numbers: SELECT, SUM (TB007*TB004), TB013, TB0