Skip to main content


STOCK CLOSING SQL SCRIPT

select * from [LMC2014-15].dbo.stock_rep ORDER BY 1
select * from [LMC2015-16].dbo.item ORDER BY 1


UPDATE  [LMC2015-16].dbo.item SET [LMC2015-16].dbo.item.OPEN_QTY=0

 UPDATE A
 SET A.open_qty = B.Qty_in_hand
 FROM [LMC2015-16].dbo.item A, [LMC2014-15].dbo.stock_rep B
 WHERE A.item_CODE = B.item_code

UPDATE  [LMC2015-16].dbo.item SET [LMC2015-16].dbo.item.AMOUNT=[LMC2015-16].dbo.item.OPEN_QTY * [LMC2015-16].dbo.item.COST_RATE

Comments

Post a Comment

Popular posts from this blog

Distribution Management Software

Inventory & Financial Management System for Distribution Business CREATE & DEFINE: Area Sale Office Customer Supplier Main Products Group Products Product Specification Chart of Account Heads Sale Office Targets MAINTAIN TRANSACTIONS & RECORDS : Sale Order Sale Invoice Sale Voucher Purchase Order Purchase Invoice Purchase Voucher Cash Received Voucher Cash Payment Voucher Bank Payment Voucher Bank Received Voucher Journal Voucher Cheque Book Record  ( Cleared & Uncleared ) REPORTS : ORDER PRINT, INVOICE PRINT, VOUCHER PRINT, INVENTORY REPORTS, ACCOUNTING REPORTS, ETC
1 comment
Read more

VUE JS INSTALLATION

PROBLEM / ERROR npm WARN invalid config registry="" npm WARN invalid config Must be a full url with 'http://' npm WARN invalid config registry="" npm WARN invalid config Must be a full url with 'http://' SOLUTION / FIX I resolve this problem by running the following command on dos / command line npm config rm proxy npm config rm https-proxy  
1 comment
Read more