Information Systems:Inbound Shipment Closed, but P.O. Lines Still in Status 30
When an inbound shipment is closed, the statuses on files SROLCH ‘Shipment Header’ and SROLCL ‘Shipment Lines’ are changed to 60, and the purchase order files are updated.
If the purchase order has not been completely received, it could mean the process was interrupted (perhaps a record lock on the purchase order detail file). To check this, use query (No don't use query, use SQL -norwizzle (talk)) to look at the status field in file SROLCL for records with field CLORNO equal to the purchase order.
Display Report
Report width . . . . . : 333
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
Shp Shipment ID Shipping Ord no Ord Supp no Shpmt Item Qty
Sts agent line Line stock un
000001 60 8179597 8179597 10 23913 500 02212207 1.0
000002 60 8179597 8179597 20 23913 500 02468072 1.0
000003 60 8179597 8179597 30 23913 500 00243774 6.0
000004 60 8179597 8179597 40 23913 500 00243790 12.0
000005 60 8179597 8179597 50 23913 500 00243873 4.0
000006 60 8179597 8179597 60 23913 500 00243949 2.0
000007 60 8179597 8179597 70 23913 500 00392662 5.0
000008 60 8179597 8179597 80 23913 500 02119808 2.0
000009 60 8179597 8179597 90 23913 500 02190775 4.0
000010 60 8179597 8179597 100 23913 500 02197721 6.0
000011 60 8179597 8179597 110 23913 500 02215663 2.0
000012 30 8179597 8179597 120 23913 500 02215689 2.0
000013 30 8179597 8179597 130 23913 500 02215762 2.0
000014 30 8179597 8179597 140 23913 500 02257871 2.0
000015 30 8179597 8179597 150 23913 500 02323897 6.0
000016 30 8179597 8179597 160 23913 500 02349942 12.0
000017 30 8179597 8179597 170 23913 500 02468650 1.0
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
The two things to look for here are that the ‘shipment ID’ and the ‘shipment status’ is the same for all lines. If the ID’s are not all the same, try closing that other shipment. If the ID’s are all the same, but the status’ aren’t (like the above example – first lines are 60, and the rest are 30) it means that the process of closing the inbound shipment was interrupted.
The receiver most likely got the message ‘unable to allocate record’, and just pressed enter to get by it. This would have cancelled the process. What they should have done, was find out who was in the PO, had them get out, then pressed R for retry.
Make note of the last item with status 60 and the first item with status 30 – one of them may have to be corrected. Use Information Systems:DFU on file SRBLCH in library UP1480BFVA to change the shipment status (Shp Sts)from 60 to 30, then close the shipment again.
On a command line within ASW, key in GO RECEP and press enter.
*VA/480B* Reception Tasks 10/23/14 11:28:40 RECEP
Select one of the following: Application SoftWare
Release: XX1:480
1. Work with inbound shipments
2. Receive replenishment line
4. Confirm purchase order reception notes
5. Print quality control notes
6. Confirm quality control notes
8. Create put away from bulk suggestion
9. Confirm put away suggestion
Selection or command (C) IBS 1989-2002
===> 1__________________________________________________________
F3=Exit F4=Prompt F9=Retrieve F12=Cancel
F13=Information Assistant F16=System main menu
Key in 1 (Work with inbound shipments) and press enter.
*VA/480B* Work with inbound shipments 10/23/14 11:30:25 DIR66001
Headers
-------------------------------------------------------------------------------
1=Add 2=Change 3=Copy 4=Delete 5=Display 6=Lines 7=Costs 8=Receipts
9=Close receipts 10=Book 11=Create rec note 12=Alloc costs 13=Tracking
__ Shipment ID Ship agent Whs Description Sts CC
9 8179597 MAI 8179597 30 N
__ 8179605 MAI 8179605 10 N
__ 8179623 MAI 8179623 10 N
__ 8179629B MAI 8179629 10 N
__ 8179649 MAI 8179649 10 N
__ 8179660E MAI 8179660 10 N
__ 8179663B MAI 8179663 10 N
__ 8179663C MAI 8179663 10 N
__ 8179667 MAI 8179667 10 N
__ 8179670 MAI 8179670 10 N
__ 8179672 MAI 8179672 30 N
__ 8179691 MAI 8179691 30 N
More...
Shipment ID Ship agent Whs
8179597__________ ____________ ___
F7=Repeat F8=Move cursor F10=More options
Key in the shipment ID, and press enter. Then use option 9 to close the shipment again. The status (on the right hand side) should now say 60.
For the two items around the interruption (last one with status 60 and the first with status 30), check that the warehouse balances and the location balances agree (InfoNet / Maintenance / Items). If they don’t, correct them. The last one with status 60 is usually incorrect; file SROSRO (warehouse balance file) had been updated the first time, but WHOLOP (location balance file) had not. The second time the shipment is closed, WHOLOP is updated, but unfortunately so is SROSRO.
(I went to the location in the warehouse, and there are two there. I also ran a total of the warehouse transaction file (SROITR) and it was also 2.)
ASW cannot be used to correct this imbalance; but Information Systems:DFU can.
Correct the ‘quantity on hand' value on file SRBSRO in library UP1480BFVA to match the totals in the locations. Although the decimal point does not show, there are three decimal positions. So ‘2’ is entered as ‘2000’. Press enter until the item and warehouse prompt is shown.
Now when you look at stock availability in InfoNet, the warehouse balance should agree with the location balance(s).