Maaf mas Kid, Jd malu sepertinya attachmentnya ada yg salah, terlampir sumber data dan hasil dlm excel yg diinginkan salam sodik |
AKHMAD Page: 1
S T O C K M O V E M E N T D E T A I L R E P O R T B Y
P R O D U C T
I N
O U T
---------------------------------------------------------------------------
---------------------------------------------------------------------------
WH D A T E SYS BATCH REF/DOC CUSTOMER/SUPPLIER MRN/CUST
PO/PRIMARY # LN# BEG.BAL. PURCH RET GOODS WH TRNSF PROD TRNSF
MANUFACT ADJUST STOCK TAKE SALES RET GOODS WH TRNSF PROD TRNSF
REQN ADJUST STOCK TAKE BALANCE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
P R O D U C T # 3 2 7 9 / 2 4 0 3 2 7 9 - K G
02 04/09/2020 000482885 00055697 XXXX YYYY, PT PO 14638 VDR 20140
001 480
480
---------- ---------- ---------- ---------- ---------- ----------
---------- ---------- ---------- ---------- ---------- ---------- ----------
---------- ---------- ----------
TOTAL PRODUCT
----> 0 480
480
TOTAL IN
DRUMS ---> 0.00 2.00
2.00
P R O D U C T # 3 9 3 5 / 1 2 0 0 3 9 3 5 - K G
02 02/09/2020 000482737 00055661 AAA BBB, PT PO 14622 VDR 20140 001
1,200 4,800
6,000
02 04/09/2020 000482883 00055695 AAA BBB, PT, PO 14622 VDR 20140
001 6,000 7,200
13,200
02 07/09/2020 000482969 00055718 AAA BBB, PT, PO 14642 VDR 20140
001 13,200 1,200
14,400
---------- ---------- ---------- ---------- ---------- ----------
---------- ---------- ---------- ---------- ---------- ---------- ----------
---------- ---------- ----------
TOTAL PRODUCT
----> 1,200 13,200
14,400
TOTAL IN
DRUMS ---> 1.00 11.00
12.00
hasil setelah di proses dgn power query.xlsx
Description: MS-Excel 2007 spreadsheet
On 2 Oct 2020, at 13.11, 'Mr. Kid' [email protected] [belajar-excel] <[email protected]> wrote:
|
