Information Systems:ASW Warehouse Balances - Discrepancies
Every night, the totals of the warehouse/item file (SROSRO) are compared to the totals in the warehouse/item/location file (WHOLOP).
To check this, look in the end of day reports (wrksplf eodjob). Page down until you get to the held reports (Sts = HLD). Look for file WMR251P. Two of these are produced every night; one for MAI and one for RET. If the number of pages is 1, there are no discrepancies, and you can delete the file.
Display Spooled File
File . . . . . : WMR251P Page/Line 1/6
Control . . . . . B Columns 1 - 130
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Selection
Differences only.... Y
Warehouse........... RET
Item................ all
Remarks............. SHEILAV
*VA/480B* L O C A T I O N B A L A N C E I N T E G R I T Y 6/05/14 8:46:17 WMR251P
Page 2
- - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Warehouse RET Returns Warehouse
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
ASW-DIS BATCH ASW-WHM
Item / Description On hand On hand Difference On hand Difference Stock category
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
00665083 PMS-FLUOXETINE 10MG CAPSULES
Warehouse....... 41.28 ----------- ----------- 47.28 6.00 On Hand
02094803 ALTACE HCT 5/25MG TABLETS
Warehouse....... 4.17 ----------- ----------- 3.17 1.00- On Hand
*** End of list ***
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
If there is a difference, it must be corrected. The problems are mostly in RET, with three usual causes.
A - Cancelling a return sales order (which removes the quantity from the location it was added to) after the product has been moved to a different location. The original location will go negative; which will cause it to be removed from WHOLOP.
B - Cancelling the session (X’ing out) while creating a credit note from a hot line incident. This will update SROSRO but not WHOLOP, and leave a temporary order in SROITR.
C - Sometimes temporary orders are left in SROCSH & SROCSP. (Hmm. I think this may be related to the previous point.) When that temporary number is used again, the old items are included with the new order when WHOLOP and WHOLTR are updated (I think only these two files are affected).
Reason B - Cancelling the session (X’ing out) while creating a credit note from a hot line incident. This will update SROSRO but not WHOLOP, and leave a temporary order in SROITR.
Follow the instructions in Technical / DFU – Data File Utility for file SRBITR in library UP1480BFVA.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : ITR File . . . . : SRBITR
Inventory event code: SOC
Ord no: 9000000
Ord line: _____
Non-Conf. Cert. No.: _______
Batch: ____________
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Key SOC for ‘Inventory event code’ and 9000000 for ‘Ord no’, then press enter and page down.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : ITR File . . . . : SRBITR
Inventory event code: SOC
Ord no: 9981273
Ord line: 10
Non-Conf. Cert. No.: _______
Batch: _____________
Stat: _ Inv tran type: 800
Item: 02094803
Whse: RET
Qty: 1000
Description: Sales order, credit
Date: 20140604
Subm time: 152115 Sum trns: _
Transit deliv. Y/N: N
P l no: _______
P L line no: _____
Pick cons. no: _______
Shipm. no: _______
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
If the record shown is inventory code SOC, has an order number greater than 9000000, is dated yesterday or before, and is for an item on the Location Balance Integrity report, It has to be corrected.
On another session, start DFU for file SRBSRO in library UP1480BFVA. Key in the item number and warehouse from file SRBITR and press enter.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : SRO File . . . . : SRBSRO
Item: 02094803
Whse: RET
Opt. no: ___
Def. ID: _______
Stat: _
Stock zone: RE
Bin loc 1: _______
Bin loc 2: _______
Qty on hnd: 4170
Tr stck on hnd: _______________
Qty on P O: _______________
Qty on ret ord: _______________
Qty on S O: _______________
Qty on P L: _______________
Qty on trnst P O: _______________
Qty on trnst S O: _______________
Qty on trnst P L: _______________
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
The quantity on hand must be reduced by the quantity on SRBITR. This field has 3 decimals positions, but the decimal point does not show. 4170 is actually 4.170. In this this case change it to 3170 (4.170 – 1.000), and press enter.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : SRO File . . . . : SRBSRO
Qty del not inv: 1000-
Tr qty del not inv: ________________
Qty on supply orders: ________________
Min qty: ________________
Disp qty: ________________
Iss YTD: 2
Iss LY: 9
Qty iss YTD: 2000-
Qty iss LY: 9490-
Date: ________
Rec YTD: _____
Rec LY: _____
Qty rec YTD: ________________
Qty rec LY: ________________
Rec dte: ________
Ret YTD: _____
Ret LY: 5
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
We also have to add 1 to the quantity delivered but not invoiced. In this case change it to 0 (-1000 + 1000), and press enter 5 times to get to the end of the record.
• Also delete this temporary order number from SROCSH and SROCSP
Now you can go back to SRBITR and press F23 twice to delete the record. Now all four warehouse files are in balance for this item. (SROITR – Inventory transactions, SROSRO – Warehouse balance, WHOLTR – Location transactions, and WHOLOP – Location occupancy.)
Continue this process for all records in SRBITR with inventory code SOC, order number greater than 9000000, and dated yesterday or before. As you correct items, mark them on the Location Balance Integrity report so you will if there are still items out of balance after you correct everything on the incomplete temporary orders.
Reason A - Cancelling a return sales order (which removes the quantity from the location it was added to) after the product has been moved to a different location. The original location will go negative; which will cause it to be removed from WHOLOP.
To see this, go into location transaction inquiry. On a command line within ASW, key in 80 and press enter, then press F24.
*VA/480B* Enquiry program selection 6/06/14 15:45:11 ASGD0121
-------------------------------------------------------------------------------
Application Enquiry program
_ AAC Account codes
_ AAC Acquisition accounts
_ AAC Acquisition types
_ AAC Acquisition wait file
_ AAC Asset account groups
_ AAC Asset balances
_ AAC Asset comments
_ AAC Asset number series
_ AAC Asset type & groups
_ AAC Assets
_ AAC AC control file
_ AAC Depreciation modules
_ AAC Depreciation rules
-------------------------------------------------------------------------------
Application Search argument
___ transactions
Search fields
__________ __________ __________ __________ __________ __________
F7=Display template
Key in a search argument of transactions and press enter.
- VA/480B* Enquiry program selection 6/06/14 15:45:11 ASGD0121
-------------------------------------------------------------------------------
Application Enquiry program
_ DIS Inventory transactions
_ DIS Stock take transactions
_ FIN G/L transactions
_ GEN Nature of transactions
1 WHM Location transactions
-------------------------------------------------------------------------------
Application Search argument
___ ______________________________
Search fields
__________ __________ __________ __________ __________ __________
F7=Display template
Select ‘Location transactions’, and press enter.
- VA/480B* Location transaction enquiry 15:48:47 WMR16001
-------------------------------------------------------------------------------
Date Whs Zn Location Item Trans. Qty.
_ 03/25/14 RET 88 MAI-RETN 00665083 PMS-FLUOXETINE 10MG CAPSUL 39.00
_ 03/25/14 RET 88 MAI-RETN 00665083 PMS-FLUOXETINE 10MG CAPSUL 39.00-
_ 03/25/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 39.00
_ 04/09/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 1.00
_ 05/05/14 RET 88 MAI-RSTK 00665083 PMS-FLUOXETINE 10MG CAPSUL 2.00
_ 05/07/14 RET 88 MAI-RSTK 00665083 PMS-FLUOXETINE 10MG CAPSUL 2.00-
_ 05/07/14 RET 99 BRYANZ 00665083 PMS-FLUOXETINE 10MG CAPSUL 2.00
_ 05/07/14 RET 99 BRYANZ 00665083 PMS-FLUOXETINE 10MG CAPSUL 2.00-
_ 05/15/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 0.25
_ 05/28/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 1.00
_ 06/02/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 0.18
_ 06/03/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 4.00
_ 06/05/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 1.00
_ 06/05/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 1.00
_ 06/06/14 RET RE A417 00665083 PMS-FLUOXETINE 10MG CAPSUL 40.00-
-------------------------------------------------------------------------------
Date Whs Zn Location Item
______ RET __ ________ 00665083
F1=Shift info
Key in the warehouse and item from the report, press enter, then press page back to get the most recent transactions.