Information Systems:Problems
ASW Messages Mocha
- PL/480B* Accounting period closing 4/23/14 15:03:08 FSR82001
Period to be closed. 1411 DECEMBER
F8=Execute
Transactions (in SROBTR) that are not updated exist in period to close.
Make note of the program name; in this example, FSR820.
Put your cursor over the message, hold down ALT, and press F1.
Additional Message Information
Message ID . . . . . . : GF82012 Severity . . . . . . . : 00
Message type . . . . . : Information
Date sent . . . . . . : 04/23/14 Time sent . . . . . . : 15:04:28
Message . . . . : Transactions (in SROBTR) that are not updated exist in
period to close.
Press Enter to continue.
F3=Exit F6=Print F9=Display message details
F10=Display messages in job log F12=Cancel F21=Select assistance level
Make note of the message ID (GF82012).
GUI
Make note of the program name; in this example, FSR820.
Click on the question mark to the right of the message.
Make note of the message number (GF82012). Look Up Reason Message was Issued
Sign onto to ASW so that your library list is correct. On the command line, key in WRKOBJ and the program name; in this case FSR820, and press enter.
Work with Objects
Type options, press Enter.
2=Edit authority 3=Copy 4=Delete 5=Display authority 7=Rename
8=Display description 13=Change description
Opt Object Type Library Attribute Text
__ FSR820 *PGM U480AP RPGLE G/L Close accounting period
__ FSR820 *PGM A454AP RPGLE G/L Close accounting period
__ FSR820 *PGM A453AP RPGLE G/L Close accounting period
__ FSR820 *PGM A450AP RPGLE G/L Close accounting period
Parameters for options 5, 7 and 13 or command
===>
F3=Exit F4=Prompt F5=Refresh F9=Retrieve F11=Display names and types
F12=Cancel F16=Repeat position to F17=Position to F24=More keys
If the program is in more than one library, they are displayed in library list sequence. This program is in the libraries for ASW versions 4.50, 4.53, 4.54, and U.S. version 4.80. The one at the top of the list is the one that will be run.
Key in WRKMBRPDM and press F4 to prompt.
Work with Members Using PDM (WRKMBRPDM)
Type choices, press Enter.
File . . . . . . . . . . . . . . > QRPGLESRC *PRV, name
Library . . . . . . . . . . . > U480AP *PRV, name, *LIBL, *CURLIB
Member . . . . . . . . . . . . . > FSR820 *ALL, name, *generic*...
Member type . . . . . . . . . . *ALL *ALL, type, *generic*...
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
Fill in the highlighted values and press enter.
Work with Members Using PDM BART
File . . . . . . QRPGLESRC
Library . . . . U480AP Position to . . . . .
Type options, press Enter.
2=Edit 3=Copy 4=Delete 5=Display 6=Print 7=Rename
8=Display description 9=Save 13=Change text 14=Compile 15=Create module...
Opt Member Type Text
5 FSR820 RPGLE G/L Close accounting period
Parameters or command
===> F3=Exit F4=Prompt F5=Refresh F6=Create F9=Retrieve F10=Command entry F23=More options F24=More keys This is a subsetted list. +
Key 5 to display in front of the program, and press enter.
Columns . . . : 6 100 Browse U480AP/QRPGLESRC
SEU==> f gf82012 _ FSR820
FMT H HKeywords++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Comments++
*************** Beginning of data ********************************************
0001.00 H* Restructed program in release 4.00 0002.00 H/TITLE Close accounting period 0003.00 F**************************************************************** 0004.00 F* P R O G R A M D E S C R I P T I O N ** 0005.00 F**************************************************************** 0006.00 F* ** 0007.00 F* The program attempts to close the period after the last ** 0008.00 F* closed period as defined on the G/L control file. ** 0009.00 F* ** 0010.00 F* The last closed period for a voucher type is also ** 0011.00 F* update if less than the period being closed. ** 0012.00 F* ** 0013.00 F* For the final period close the balance for trade ** 0014.00 F* accounts will be checked. If the balance is not zero ** 0015.00 F* the final period close can not be performed. ** 0016.00 F* ** 0017.00 F**************************************************************** 0018.00 F* This program is written by IBS R&D ** 0019.00 F****************************************************************
F3=Exit F5=Refresh F9=Retrieve F10=Cursor F11=Toggle F12=Cancel
F16=Repeat find F24=More keys
On the top line, key in ‘F’ for find, space, and the message ID; in this case GF82012, and press F16. The line that issued this message will position to the top of the screen. Press Page Up to see the code leading up to this.
Columns . . . : 6 100 Browse U480AP/QRPGLESRC SEU==> FSR820 FMT C CL0N01Factor1+++++++Opcode&ExtFactor2+++++++Result++++++++Len++D+HiLoEq...... 0612.00 C END 0613.00 C* 0614.00 C ENDDO 0615.00 C* 0616.00 C END 0617.00 C* 0618.00 C READ TRAA 92 0619.00 C ENDDO 0620.00 C* 0621.00 C* Transactions for closing period still exist in BTR 0622.00 C* 0623.00 C MOVE XXCLPE KKPERI 0624.00 C* 0625.00 C KK3BTR SETGT SR3BTR 0626.00 C READP SR3BTR 92 0627.00 C* 0628.00 C *IN92 IFEQ *OFF 0629.00 C MOVE *ON *IN01 0630.00 C MOVE 'E' XMSG51 0631.00 C MOVE 'GF82012' MSGID
F3=Exit F5=Refresh F9=Retrieve F10=Cursor F11=Toggle F12=Cancel
F16=Repeat find F24=More keys
You can see by the comment (shown in red), that the problem is that transactions exist in file SROBTR (most physical file names start with SRO). In this case, the message text told you that; but it usually doesn’t. Record Lock (Unable to Allocate a Record)
The iSeries will not allow two users to update the same record at the same time. It does this by checking for record locks. This means, that when one job has read a record in update mode, another job cannot also read that same record in update mode (they can, however, read it in input, or inquiry, mode). Although this protects the integrity of the database, it does not work well operationally.
The system will wait, to give the previous update a chance to complete, before going into a system error. The length of time it will wait is part of the file description. Unless it is manually changed, it will be 60 seconds. The user get the message ‘Unable to allocate a record in file SRBPRG (R C G D F)’, and will have to decide on an action. The options are –
- Retry - Cancel - Go to next program cycle (this was useful with the style of programming that -used the RPG cycle, but the current method doesn’t) - cancel with system Dump - cancel with Full formatted dump
The correct way to get out of a lock error is to have the program (or user) holding the record release it, and retry. Cancelling (which can potentially be damaging) is the default, and so will happen if the user presses Enter without keying an option, When a user gets this error, and calls for assistance, find them in WRKACTJOB (work with active jobs) then get them to key in ‘R’ for retry. The following process will only work while the job is in LCKW (lock wait) – which only lasts for 60 seconds – so you may have to get them to retry a couple of times.
When you find the job, use option 5 – Work with Job.
Work with Active Jobs BART
06/02/15 11:55:57
CPU %: 28.0 Elapsed time: 00:01:13 Active jobs: 562
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
8=Work with spooled files 13=Disconnect ...
Current
Opt Subsystem/Job User Type CPU % Function Status
__ QPADEV000L SHANNONM INT .0 PGM-UNITY DSPW
__ +SHEILA1 SHEILAV INT .4 CMD-WRKACTJOB RUN
__ +SHEILA2 SHEILAV INT .0 CMD-WRKQRY DSPW
__ +SHEILA3 SHEILAV INT .0 CMD-WRKQRY DSPW
__ QPADEV001B SIMONL INT .0 PGM-RFSIGNON DSPW
__ QPADEV001C SIMONL INT .0 PGM-RFSIGNON DSPW
5 QPADEV0017 SIMONL INT .0 PGM-RFSIGNON LCKW
__ RFTER0014A SIMONL INT .0 PGM-RFSIGNON DSPW
__ +QPADEV002M SIONYA INT .0 PGM-ASGC800 DSPW
More...
Parameters or command
===>
F3=Exit F5=Refresh F7=Find F10=Restart statistics
F11=Display elapsed data F12=Cancel F23=More options F24=More keys
Then use option 12 – Work with locks.
Work with Job Locks
System: BART
Job: QPADEV0017 User: SIMONL Number: 247851
Job status: ACTIVE
Type options, press Enter.
5=Work with job member locks 8=Work with object locks
Object Member ASP
Opt Object Library Type Lock Status Locks Device
_ ANBBAL UP1480BFVA *FILE-LGL *SHRRD HELD YES
_ ANBBGD UP1480BFVA *FILE-LGL *SHRRD HELD YES
_ ANBBLD UP1480BFVA *FILE-LGL *SHRRD HELD YES
_ ANBBOB UP1480BFVA *FILE-LGL *SHRRD HELD YES
_ ANBBTD UP1480BFVA *FILE-LGL *SHRRD HELD YES
_ ANBBUC UP1480BFVA *FILE-LGL *SHRRD HELD YES
_ ANBNOTCT UP1480BFVA *FILE-LGL *SHRRD HELD YES
_ ANBNOTHN UP1480BFVA *FILE-LGL *SHRRD HELD YES
_ ANBNOTRL UP1480BFVA *FILE-LGL *SHRRD HELD YES
More...
F3=Exit F5=Refresh F10=Display job record locks F11=Display thread data
F12=Cancel F16=Job menu
Press F10 to display record locks. Remember; if there is not a file in status ‘Wait’ get the user to retry again.
Display Job Record Locks
System: BART
Job: QPADEV0017 User: SIMONL Number: 247851
Position to . . . . . . . .
Library . . . . . . . . . .
Type options, press Enter.
5=Display member record locks
Record
Option File Library Member Number Status
5 SROPRG UP1480BFVA SROPRG 51029 WAIT
_ SROORPPL UP1480BFVA SROORPPL 2018688 HELD
F3=Exit F5=Refresh F12=Cancel F16=Job menu
Use option 5 on the file in status wait to display the record locks.
Display Member Record Locks
System: BART
File . . . . . . . . : SROPRG Member . . . . . . . : SROPRG
Library . . . . . : UP1480BFVA
Record Lock
Number Job User Number Status Type
51029 QPADEV0027 VIVIANL 248104 HELD UPDATE
QPADEV0017 SIMONL 247851 WAIT UPDATE
Press Enter to continue.
F3=Exit F5=Refresh F12=Cancel
This screen shows you that Vivian has a hold on the record in SROPRG (item file) that Simon is waiting for. It could mean that she is in the middle of an update, or that she did do an update, and the program didn’t release the record (ie – she started and update, then cancelled). She may have to sign off to release the record.
ASW has programmed another, more user friendly, way of dealing with record locks. For example, when a user goes into ‘work with sales orders’ and edits an order, a flag is set on the header record. If a second user tries to open that same sales order, they will get a message saying that the requested order is in use – no long wait, and no system error. When the first user exits the order, the flag is cleared.
A problem arises if the session is ended while a user has an order open in update mode – the order header is stilled flagged as in use, but the user is no longer editing it. There are two ways of correcting this. If the user realizes this has happened, they can edit the same order again, and exit properly (this must be done under the same user ID). This will clear the in user flag. The other way is to change the order header record (SRBSOH) using EZVIEW or DFU (data file utility). DFU should always be used with extreme care – it does no validation, so will allow uncontrolled changes or deletions to any file; with no record of who did what when.
Help Does Not Work
Symptoms – when the help key, or ALT-F1, is pressed, the display flashes but returns to the current screen. Sometimes, the session locks.
Correction – go to User Profile Table Maintenance, and press F8 – Maintain General HELP options. This screen should display ->
- PS/480B* User profile HELP options table 10/29/04 16:16:34 ASGD9621
------------------------------------------------------------------------------
User profile........ *ALL
Command............. *DFT
Host name........... *DFT
Domain name......... *DFT
Port................ *DFT
Web name............ *DFT
Sub folder name..... *DFT
Document extention.. *DFT
Language............
This is correct; it means no entries have been done. If it does not look like this, and says ‘F10 – Copy record’ on the bottom, then a record has been added. Press F11 twice to delete it, and return to these defaults.
If this isn’t the problem, do a DSPJOBLOG and see if this message is there.
Additional Message Information
Message ID . . . . . . : IWS4010 Severity . . . . . . . : 40
Message type . . . . . : Escape
Date sent . . . . . . : 09/29/05 Time sent . . . . . . : 14:03:20
Message . . . . : Client Access/400 Organizer is already active for device
SHEILAV2.
Cause . . . . . : Attempting to start Client Access/400 Organizer when it is
already active for the device.
Recovery . . . : If you get this message when Client Access Organizer has
not been started, it is possible that the organizer function did not end
properly. Vary the device off and on again from another display device
connected to the same system and try to start the organizer function again.
Press Enter to continue.
F3=Exit F6=Print F9=Display message details F12=Cancel F21=Select assistance level
Batch Jobs not Running
Users may report that ‘invoices not printing’, ‘PO’s not printing’, or something else not printing. This could be a problem with a printer, or it could be that the jobs that produce the printouts aren’t running.
Key in WRKACTJOB SBS(QBATCH) and press enter to see which batch jobs are running.
Work with Active Jobs BART
10/14/14 09:28:07
CPU %: .0 Elapsed time: 00:00:00 Active jobs: 546
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
8=Work with spooled files 13=Disconnect ...
Current
Opt Subsystem/Job User Type CPU % Function Status
QBATCH QSYS SBS .0 DEQW
RUNQRY SHEILAV BCH .0 PGM-ASGC900 RUN
PUR_ORDER SCOTTZ BCH .0 PGM-ASGC900 RUN
UPD_UD_SST SHEILAV BCH 25.1 PGM-ASGC900 RUN
Parameters or command
===> F3=Exit F5=Refresh F7=Find F10=Restart statistics F11=Display elapsed data F12=Cancel F23=More options F24=More keys
If one (or two) of these jobs have a status of ‘MSGW’ they are waiting for a response, and will sit there, holding up other jobs until they are answered. If they are running, check to see if they are long running jobs – which may or may not indicate a problem. Use option 5 ‘Work with’, then 1 ‘Display job status attributes’.
Display Job Status Attributes
System: BART
Job: EXODUS User: CATPULTADM Number: 903849
Status of job . . . . . . . . . . . . . . . : ACTIVE
Current user profile . . . . . . . . . . . : CATPULTADM
Job user identity . . . . . . . . . . . . . : CATPULTADM
Set by . . . . . . . . . . . . . . . . . : *DEFAULT
Entered system:
Date . . . . . . . . . . . . . . . . . . : 10/12/14
Time . . . . . . . . . . . . . . . . . . : 08:59:22
Started:
Date . . . . . . . . . . . . . . . . . . : 10/12/14
Time . . . . . . . . . . . . . . . . . . : 08:59:22
Subsystem . . . . . . . . . . . . . . . . . : QCMN
Subsystem pool ID . . . . . . . . . . . . : 1
Type of job . . . . . . . . . . . . . . . . : CMNEVK
Special environment . . . . . . . . . . . . : *NONE
Program return code . . . . . . . . . . . . : 0
More...
Press Enter to continue.
F3=Exit F5=Refresh F12=Cancel F16=Job menu
Look at the ‘started’ date and time; not ‘entered system’ (if they are different, this job sat in the job queue waiting its turn to run).
Then look to see what jobs are waiting to run; WRKJOBQ QBATCH* and press enter.
Work with All Job Queues
Type options, press Enter.
2=Change 3=Hold 4=Delete 5=Work with 6=Release
8=Work with job schedule entries 9=Description 14=Clear
Opt Queue Library Jobs Subsystem Status
__ QBATCH QGPL 0 QBATCH RLS
__ QBATCH1 QGPL 0 QBATCH RLS
__ QBATCH2 QGPL 0 QBATCH RLS
__ QBATCH3 QGPL 0 QBATCH RLS
Command
===> F3=Exit F4=Prompt F5=Refresh F12=Cancel F24=More keys
QBATCH – User jobs run from here. Two jobs can run at a time.
QBATCH1 – InfoManager jobs run from here.
QBATCH2 – Overnight jobs run from here.
QBATCH3 – Some long running user jobs have been moved to here.
QBATCH1, 2, and 3 have been created so that long running jobs will not hold up user production. If you discover another long running user job that should be moved to QBATCH3, see the section ‘Change the Job Queue for an ASW Program’.
If there are two long programs running, and jobs are piling up in job queue QBATCH, they can be manually moved to a different queue to run immediately. On the ‘Work with All Job Queues’ screen, key in option 5 ‘Work with’ for QBATCH, and press enter. (The following shot is just an illustration – it’s not QBATCH, as there are no jobs currently waiting.)
Work with Job Queue
Queue: EMAIMPPRD Library: UNIPHARMIT Status: RLS/SBS
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release
Opt Job User Number Priority Status
_ EMAIOPPRD EODJOB 897910 5 RLS
_ EMAIOPPRD QPGMR 903179 5 RLS
_ EMAIOPPRD QPGMR 903223 5 RLS
_ EMAIOPPRD EODJOB 903464 5 RLS
_ EMAIOPPRD EODJOB 903472 5 RLS
_ EMAIOPPRD EODJOB 906865 5 RLS
_ EMAIOPPRD EODJOB 906882 5 RLS
_ EMAIOPPRD EODJOB 912257 5 RLS
_ EMAIOPPRD EODJOB 912274 5 RLS
Parameters for options 2, 3 or command
===>
F3=Exit F4=Prompt F6=Submit job F12=Cancel F21=Subsystem
F22=Work with job schedule entries F24=More keys
The job name will give you an idea of what the job does. Run purchase orders and invoices first, as there are users waiting for them (they probably reported this problem). Try not to start any more long running programs. To change the job queue (and start the program running) key option 2 ‘Change’ in front of the job, then press enter and F10.
Change Job (CHGJOB)
Type choices, press Enter.
Job name . . . . . . . . . . . . > EMAIOPPRD Name, *
User . . . . . . . . . . . . . > EODJOB Name
Number . . . . . . . . . . . . > 897910 000000-999999
Job priority (on JOBQ) . . . . . 5 0-9, *SAME
Output priority (on OUTQ) . . . 5 1-9, *SAME
Print device . . . . . . . . . . PRT01 Name, *SAME, *USRPRF...
Output queue . . . . . . . . . . QPRINT Name, *SAME, *USRPRF, *DEV...
Library . . . . . . . . . . . QGPL Name, *LIBL, *CURLIB
Run priority . . . . . . . . . . *SAME 1-99, *SAME
Additional Parameters
Job queue . . . . . . . . . . . EMAIMPPRD Name, *SAME
Library . . . . . . . . . . . UNIPHARMIT Name, *LIBL, *CURLIB
Print text . . . . . . . . . . . *BLANK__________________________
More...
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
Change the ‘Job queue’ to QS36EVOKE, clear the ‘Library’, then press enter. QS36EVOKE is a job queue that will release an unlimited number of jobs to run, so keep a watch on the QBATCH subsystem (in work with active jobs) to make sure that one job finishes before you release another. Finance Cannot Close Period
Check SROBTR and SROOVF. If an update does not complete properly, sometimes orphaned transactions are left behind.
For example, we have a custom system to receive transactions from the bank and post them to the store’s accounts receivable (see Bank EDI). Sometimes this leaves transactions in SROOVF. We can’t do anything but manually delete them, and do a journal entry.
- I can see only one place where this could be happening, but I haven’t figured out why. BERUP075 (BED -- Post A/R payment G/L corrections to ASW) calls GCFC851 (Interface accounting transfer), which calls GCFR851 (Interface accounting transaction transfer). If field &GRIW is returned as blank, FMC050 (G/L update transactions and balances) is not run. **
- Nancy seems to have found the problem and a solution. We have changed the job queue QBATCH to run two jobs at a time. If Nancy waits until one card type (Visa, Master Card, etc) completes before starting the next, the problem doesn’t seem to happen. **
A/R Reconciliation not in Balance
The first thing to find out is when it went out of balance. We have a copy of the A/R Reconciliation for every period end. To see them, on a command line key in WRKOUTQ FINANCE/FIN* and press enter. Page down through the older periods, until you get to the more recent ones.
Work with All Output Queues
Type options, press Enter.
2=Change 3=Hold 4=Delete 5=Work with 6=Release 8=Description
9=Work with Writers 14=Clear
Opt Queue Library Files Writer Status
__ FIN201505 FINANCE 11 RLS
__ FIN201506 FINANCE 11 RLS
__ FIN201507 FINANCE 11 RLS
__ FIN201508 FINANCE 11 RLS
__ FIN201509 FINANCE 11 RLS
__ FIN201510 FINANCE 11 RLS
__ FIN201511 FINANCE 11 RLS
5 FIN201512 FINANCE 11 RLS
__ FIN201601 FINANCE 11 RLS
__ FIN201602 FINANCE 11 RLS
Command
===>
F3=Exit F4=Prompt F5=Refresh F12=Cancel F24=More keys
Use option 5 to see the spool files.
Work with Output Queue
Queue: FIN201512 Library: FINANCE Status: RLS
Type options, press Enter.
1=Send 2=Change 3=Hold 4=Delete 5=Display 6=Release 7=Messages
8=Attributes 9=Work with printing status
Opt File User User Data Sts Pages Copies Form Type Pty
_ GCFP231 FINADMIN RDY 92 1 *STD 5
_ GCFP233 FINADMIN RDY 185 1 *STD 5
_ GCFP235 FINADMIN RDY 199 1 *STD 5
5 FSR297P FINADMIN RDY 2 1 *STD 5
_ FSR297P FINADMIN RDY 2 1 *STD 5
_ FKR041P FINADMIN RDY 2 1 *STD 5
_ QPQUPRFIL FINADMIN RDY 81 1 *STD 5
_ QPQUPRFIL FINADMIN RDY 10 1 *STD 5
_ DMR606P FINADMIN RDY 911 1 *STD 5
More...
Parameters for options 1, 2, 3 or command
===>
F3=Exit F11=View 2 F12=Cancel F20=Writers F22=Printers
F24=More keys
The first ‘FSR297P’ is the A/R reconciliation (the second is A/P). Use option 5 to display it. Do this on several periods until you find the first one that has a difference. In this case, it is 201501.
Display Spooled File
File . . . . . : FSR297P Page/Line 1/4
Control . . . . . Columns 1 - 130
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2....+....3....+....4....+....5...
*VA/480B* A/R RECONCILIATION LIST 3/01/14 3:45:05 FSR297P
Page 1
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Selection
Main Grou Subg Cost Pro
From account number. all all all all all
To account number...
Account number mask.
Period.............. 1501
Details............. N
Remarks............. SHEILAV
*VA/480B* A/R RECONCILIATION LIST 3/01/14 3:45:05 FSR297P
Page 2
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
A/R A M O U N T A/R A M O U N T G/L A M O U N T G/L A M O U N T G/L A M O U N T D I F F E R E N C E
Main Grou Subg Temporary interrupt(a) Balance amount (b) Temporary interrupt(c) Balance amount (d) Journal Maintenance(e) Diff ((a+b)-(c+d+e))
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
120000 4,452,168.26 4,452,160.94 7.32
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Grand total 4,452,168.26 4,452,160.94 7.32
*** End of list ***
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
Follow the instructions in ‘ASW Analyser / Rebuild / Rebuild System Base Levels’. This should be done on a Saturday, as it is not a good idea to rebuild Analyser while transactions are trying to update it.
Cannot Use A/P Payment Proposal
If you get a message saying that a previous step is still processing, and you know that it isn’t (make sure it isn’t in the job queued waiting for its turn to run, or in error while running) –
Using instructions in Technical / DFU – Data File Utility, edit file SROCTLSO (A/P Payment proposals control) in library UP1480BFVA, to clear the WSID field. There will probably only be one record in the file. Journal in Error
Sometimes a journal does not automatically post to the G/L. It could be because something is wrong with an individual entry, or because something in it does not balance (to zero). You can tell which, by going into ‘work with journals in error’, and looking at the journal.
*VA/480B* Journal maintenance 1/22/15 09:22:36 FSR11001
Select journal
-------------------------------------------------------------------------------
Year Journal Transaction type User Date
5 15 8953 A/P batch invoices EDIUSER 1/21/15
------------------------------------------------------------------------------
Year Journal User
__ _____ __________
Select the journal to see the transactions.
*VA/480B* Journal maintenance - A/P invoices 1/22/15 09:23:57 FSR12101
Invalid transactions
-------------------------------------------------------------------------------
Accounting year..... 15 Journal number...... 8953
-------------------------------------------------------------------------------
Dt Doc no Supplier no Name Amount
5 EIN 66442 21948 MERCK CANADA INC. *
F8=Valid transactions
If there are no ‘invalid transactions’, the journal is out of balance (see the section ‘Out of Balance’ to correct this). If there is, select one to see, and correct, the details.
*VA/480B* Journal maintenance - A/P invoices 1/22/15 09:25:49 FSR12104
-------------------------------------------------------------------------------
Accounting year..... 15 Journal number...... 8953
-------------------------------------------------------------------------------
Supplier number..... 21948 Supplier invoice no. 7178018779
Document type....... EIN Voucher type........ 33
Document number..... 66442 Voucher number...... 3302554
Document date....... 012115 Voucher date........ 012115
Due date............ Accounting period... 1512
Transaction amount.. 4869.97 Transaction currency CAD
System amount....... _______________
Primary amount...... Primary currency.... CAD
VAT amount.......... 14.470- Turnover amount..... ____________
Exchange rate period M
Exchange rate level. M Cost centre......... _______
Exchange rate time.. 001501 Import code......... 1
Terms of payment.... Supplier bank....... ___
Bank reference no... _______________________________
Text................ __________________________
Supplier inv date... 012115 Reception date...... 012215
Attestor............ NO ATTESTO Approved for payment N
Payment mode........ Payment stop code... __
VAT must have same sign as transaction if entered
This is a problem with the EDI data received (document type EIN is an EDI invoice). The correction is to take the minus sign off of the VAT (European terminology for tax). Then go to the section ‘Manually Post Batch’)’ Out of Balance – Sales Tax
If there are no invalid transactions, press F3 to see the totals.
*VA/480B* Journal maintenance - G/L postings 8/20/15 08:39:53 FSR11105
-------------------------------------------------------------------------------
Accounting year..... 16 Journal number...... 5166
Journal date........ 8/19/15
-------------------------------------------------------------------------------
Per Vt Vou no Debit Credit Difference
1607 80 8000167 1644464.71 1644469.71 5.00-
-------------------------------------------------------------------------------
Forced update....... N
So far, we have had two different reasons for a journal to be out of balance; when the tax status has been changed, or when processing credit card transactions has failed.
Base ASW (at least the version modified for the US) has different levels of tax (state, county, etc) but they all add to one bucket – both when they print on the invoice, and add to the G/L. We need to keep provincial and federal taxes separate. We have modified DMR343 (invoice generation) to recalculate the individual sales taxes. Very occasionally, when it does this, it does not agree with total tax amount previously calculated by ASW. Which means the detail taxes that print on the bottom of the invoice, and the journal entries created, do not add up to the invoice total. This happens so rarely, and the program is so complex, that I have been fixing the symptoms rather than fixing the source of the problem.
To find out which invoice has the problem, go to System Management / Query Manager / Run a Query Request. Run FINJERROR.
Display Spooled File
File . . . . . : QPQUPRFIL Page/Line 1/24
Control . . . . . Columns 1 - 130
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+.
QUERY NAME . . . . . JOURNERR2
LIBRARY NAME . . . . XX2480BP
FILE LIBRARY MEMBER FORMAT
JETOTAL QTEMP JETOTAL JETOTAL
DATE . . . . . . . . 12/02/14
TIME . . . . . . . . 12:56:40
show out of balance document 12/02/14 12:56:40 PAGE 1
Docu Doc no Amount
type
INV 7711150 5.00-
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
You can reprint this invoice to see what it’s done. Typically, the modifications have calculated a tax when base ASW didn’t. To fix it, use the instructions in Technical / DFU – Data File Utility on file UZIVLIL3 in library UP1480BFVA.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : UZIVLIR File . . . . : UZIVLIL3
IVINV#: 7711150 IVINVL: _____
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Key in the invoice number, and press enter. Press page down until you see the incorrect tax amount.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : UZIVLIR File . . . . : UZIVLIL3
IVINV#: 7711150 IVINVL: 1
IVUNI#: 2286388 IVPLNO: _________
IVORNO: 3230094 IVORLN: 10
IVIDAT: 20141201 IVDUED: 20141225
IVTYPP: 1 IVINYR: 2014
IVTRMS: Z80 IVTRSO: ORD
IVITEM: 02002657
IVTAX1: 5000 IVTAX2: _______________
IVTAX3: IVTAX4: _______________
IVTAX5: IVDIAM: _______________
IVDIPC: UZADBY: ANGELAC
UZADCE: 20 UZADYR: 14
UZADMO: 12 UZADDY: 1
UZADTI: 84423 UZUPBY: _______
UZUPCE: UZUPYR: __
UZUPMO: UZUPDY: __
UZUPTI: ______
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Remove the sales tax, and press enter to update the file. You can reprint the invoice, and it will be correct.
But the journal entries created are still out of balance. To know how to fix them, you will have to see what was generated.
On an ASW command line, key in WRKQRY and press enter.
Work with Queries
Type choices, press Enter.
Option . . . . . . 1 1=Create, 2=Change, 3=Copy, 4=Delete
5=Display, 6=Print definition
8=Run in batch, 9=Run
Query . . . . . . . Name, F4 for list
Library . . . . . QTEMP Name, *LIBL, F4 for list
F3=Exit F4=Prompt F5=Refresh F12=Cancel
Key in option 1, and press enter.
Define the Query
Query . . . . . . : Option . . . . . : CREATE
Library . . . . : QTEMP CCSID . . . . . . : 65535
Type options, press Enter. Press F21 to select all.
1=Select
Opt Query Definition Option
1 Specify file selections
_ Define result fields
1 Select and sequence fields
1 Select records
_ Select sort fields
_ Select collating sequence
_ Specify report column formatting
_ Select report summary functions
_ Define report breaks
_ Select output type and output form
_ Specify processing options
F3=Exit F5=Report F12=Cancel
F13=Layout F18=Files F21=Select all
Select these three options, and press enter.
Specify File Selections
Type choices, press Enter. Press F9 to specify an additional
file selection.
File . . . . . . . . . sroovf Name, F4 for list
Library . . . . . . UP1480BFVA Name, *LIBL, F4 for list
Member . . . . . . . . *FIRST Name, *FIRST, F4 for list
Format . . . . . . . . *FIRST Name, *FIRST, F4 for list
F3=Exit F4=Prompt F5=Report F9=Add file
F12=Cancel F13=Layout F24=More keys
Key in file SROOVF and library UP1480BFVA, then press enter twice.
Select and Sequence Fields
Type sequence number (0-9999) for the names of up to 500 fields to
appear in the report, press Enter.
Seq Field Text Len Dec
1 OVDIM1 Account part 1 20
1 OVDOTY Document type 3
1 OVIDNO Document number 7 0
1 OVDODT Document date 8 0
1 OVLAMO Amount system currency 17 3
1 OVTEXT Description 30
OVGRIW Group id/work station 10
OVTYP1 Type 1 1
OVTYP2 Type 2 1
OVSTAT Status 1
OVDIM2 Account part 2 20
OVDIM3 Account part 3 20
More...
F3=Exit F5=Report F11=Display names only F12=Cancel
F13=Layout F20=Renumber F21=Select all F24=More keys
Select these six fields, and press enter twice.
Select Records
Type comparisons, press Enter. Specify OR to start each new group.
Tests: EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...
AND/OR Field Test Value (Field, Number, 'Characters', or ...)
OVIDNO EQ 7711150________________________
____ _______________ _____ _______________________________
____ _______________ _____ _______________________________
____ _______________ _____ _______________________________
____ _______________ _____ _______________________________
_____________________________________________________________________________________
Field Text Len Dec
OVDIM1 Account part 1 20
OVDOTY Document type 3
OVIDNO Document number 7 0
OVDODT Document date 8 0
OVAMTR Amount transaction currency 17 3
More...
F3=Exit F5=Report F9=Insert F11=Display names only
F12=Cancel F13=Layout F20=Reorganize F24=More keys
Key in this ‘field’ and ‘test’, and the invoice number. Press F5 to see the report.
Display Report
Report width . . . . . : 98
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...
Account part 1 Docu Doc no Doc Am trans curr Description
type date
000001 122000 INV 7711150 20141201 5.000- Gross sales 840
000002 210700 INV 7711150 20141201 7.000- Gross sales 840
000003 900000 INV 7711150 20141201 100.000- Gross sales 840
000004 122500 INV 7711150 20141201 5.000- GST payable 960
000005 120000 INV 7711150 20141201 112.000 NANOOSE MEDICINE CT INV7711150
****** ******** End of report ********
The line in red is the one that should not have been generated. This example is for an invoice that accounting did; the PST and GST were done manually using fictitious items. They should not have been generated automatically.
*VA/480B* Invoice enquiry 2/10/15 11:35:07 DMR12106
-------------------------------------------------------------------------------
Invoice number...... 7711150 Date................ 12/01/14
-------------------------------------------------------------------------------
Invoice customer.... 11305 Customer............ 11305
Name.... NANOOSE MEDICINE CENTRE Del addr NANOOSE MEDICINE CENTRE
Order number........ 3230094 Order date.......... 12/01/14
-------------------------------------------------------------------------------
Line Wh Item/Unit Qty S.unit Del dat Price P.unt Amount
1 MAI 02002657 500 FLYERS (MC) - DEC/15
1 EA 12/01/14 100.00 EA 100.00
2 MAI 02081263 GST
1 EA 12/01/14 5.00 EA 5.00
3 MAI 02000065 PST
1 EA 12/01/14 7.00 EA 7.00
F6=View controls F7=Create invoice copy
Do a forced update of this journal (see the section ‘Manually Post Batch), which will bring it into balance by adding a 5.00 debit to account 730200 ‘Out of Balance’.
Then you will need to do a manual entry to correct this.
Debit 5.00 122500 GST - collected Credit 5.00 730200 Out of Balance
Out of Balance – Debit / Credit Card Transactions
Transactions through the debit / credit card machines in our shareholder stores come to us; we then apply them against the stores’ accounts receivable.
See ‘Bank EDI / Bank EDI Does Not Post / To Post Manually’ for an explanation of what happened.
The user will get the message –
Work with Messages
System: BART
Messages in: NANCYN
Type options below, then press Enter.
5=Display details and reply
Opt Message
From . . : NANCYN 04/14/15 10:25:44
No error was found in A/R payment journal 1844 (year 16), so update will
proceed
From . . : NANCYN 04/14/15 10:24:59
G/L transaction journal 1845 (year 16) is in error, no update will be
performed
From . . : NANCYN 04/14/15 10:24:57
Job 965499/NANCYN/AR_PAYMBAT completed normally on 04/14/15 at 10:24:07.
No error was found in G/L transaction journal 1843 (year 16), so update
will proceed
From . . : NANCYN 04/14/15 10:24:07
No error was found in A/R payment journal 1843 (year 16), so update will
More...
F1=Help F3=Exit F5=Refresh F12=Cancel F17=Top F18=Bottom
F21=Select assistance level F22=Display list details
To find out which voucher has the problem, go to System Management / Query Manager / Run a Query Request. Run FINJERROR.
Display Spooled File
File . . . . . : QPQUPRFIL Page/Line 1/24
Control . . . . . Columns 1 - 130
Find . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+.
QUERY NAME . . . . . JOURNERR2
LIBRARY NAME . . . . XX2480BP
FILE LIBRARY MEMBER FORMAT
JETOTAL QTEMP JETOTAL JETOTAL
DATE . . . . . . . . 04/14/15
TIME . . . . . . . . 14:19:20
show out of balance document
04/14/15 14:19:20 PAGE 1
Docu Doc no Amount
type
GLC 7500250 2796.94-
* * * E N D O F R E P O R T * * *
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
Do the same query on SROOVF that is in the section ‘Out of Balance – Sales Tax’, except add a sort by description (OVTEXT).
Display Report
Report width . . . . . : 98
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...
Account part 1 Docu Doc no Doc Am trans curr Description
type date
000001 100100 GLC 7500250 20150414 2,021.680 Account correction: AMX
000002 730200 GLC 7500250 20150410 -2,796.940 Account correction: AMX
000003 730200 GLC 7500250 20150414 -2,021.680 Account correction: AMX
000004 100400 GLC 7500250 20150410 56,141.720 Account correction: DBT
000005 100400 GLC 7500250 20150414 61,011.190 Account correction: DBT
000006 730200 GLC 7500250 20150410 -56,141.720 Account correction: DBT
000007 730200 GLC 7500250 20150414 -61,011.190 Account correction: DBT
000008 100400 GLC 7500250 20150410 34,967.920 Account correction: MC
000009 100400 GLC 7500250 20150414 90,784.410 Account correction: MC
000010 730200 GLC 7500250 20150410 -34,967.920 Account correction: MC
000011 730200 GLC 7500250 20150414 -90,784.410 Account correction: MC
000012 100400 GLC 7500250 20150410 76,631.900 Account correction: VIS
000013 100400 GLC 7500250 20150414 160,622.210 Account correction: VIS
000014 730200 GLC 7500250 20150410 -76,631.900 Account correction: VIS
000014 730200 GLC 7500250 20150414 -160,622.210 Account correction: VIS
****** ******** End of report ********
You can see by the document dates that this includes two sets of bank EDI transactions; one on Apr 10, and the other on Apr 14. For each date, each card type has a pair of transactions; debit the bank (100100 or 100400), and credit the out of balance account (730200; in this case used for temporary postings). You can see that the second line does not have the corresponding debit to the bank.
Force the out of balance journal to post – not as FINADMIN – to put the out of balance amount to 730200. (See ‘Problems / Finance / Journal in Error / Manually Post Batch’ for instructions.) Then manually transfer from 730200 to the correct bank. Entry Generated Incorrectly
G/L entries are automatically generated by sales, receiving, and transactions in the warehouse. To see how this is done, look at the section ‘Generated Journal Entries’.
*VA/480B* Journal maintenance - G/L postings 2/10/15 11:40:01 FSR11104
-------------------------------------------------------------------------------
Accounting year..... 16 Journal number...... 185
-------------------------------------------------------------------------------
Main Grou Subg Cost Pro
______ ____ ____ ____ ___
Accounting period... 1601 Translation period..
Voucher date........ 020615 Document date....... 020515
Voucher type........ 83 Document type....... GLB
Voucher number...... 8300004 Document number..... 8183924
Transaction amount.. 21.42
Quantity............ 1.000
Quantity code.......
Transaction currency CAD
System amount....... 21.42
VAT amount..........
VAT am trans curr...
Text................ Stk val fict.item 903
VAT handling code... USST
System identity..... G/L
Account for Main must be entered +
This is from PO 8183924; so find a line on it for 21.42.
*VA/480B* Purchase order enquiry 2/10/15 11:46:14 DMR11904
Order lines
-------------------------------------------------------------------------------
Supplier.... 24277 AURO PHARMA Order value.
Order type.. BE Price Variance - charge t Ord val CAD
Order number 8183924
-------------------------------------------------------------------------------
Line Whs Item/Unit Quantity Disp dat Price P.unt Discount Sts
10 RET 02396737 AURO-GABAPENTIN 300MG CAPSULES
EA 5.00 02/04/15 25.30 60
20 RET 02396711 AURO-CYCLOBENZAPRINE 10MG TABS
EA 2.00 02/04/15 37.27 60
40 RET 02362598 AURO-MIRTAZAPINE OD 15MG TABS
EA 5.00 02/04/15 2.93 60
50 RET 02362606 AURO-MIRTAZAPINE OD 30MG TABS
EA 5.00 02/04/15 7.44 60
60 RET 02362614 AURO-MIRTAZAPINE OD 45MG TABS
EA 20.00 02/04/15 8.78 60
70 RET 02001832 VENDOR DISCOUNT
EA 1- 02/04/15 21.42 60
F6=View Controls F7=Print F8=Addresses F9=Header
Transaction types 903 (stock value fictitious item) uses the account group to build the journal entry. Most of them have been left blank, so that the G/L numbers can be manually keyed into the journal. This is easier, as the user can decide exactly where they want the entry to go; instead of having to configure every possible entry in Transaction Types, and the user knowing all of them.
Normally, Nancy has to correct this. If she is unavailable, key account number 210100 into ‘Main’, and manually post the batch. Provide the details to Nancy, so she can adjust it when she can. Do not leave it until she is available, as it will delay the update of the G/L even more. Manually Post batch
Very important – if you are posting a journal that is out of balance, do NOT sign in as FINADMIN! That is a special profile that will NOT create a balancing entry first – it will post the journal as out of balance, and will put the G/L out of balance. Only do this if you are trying to correct the G/L when it is already out of balance!
Look at the details of the journal that is in error. There should be no invalid transactions.
*VA/480B* Journal maintenance - A/P invoices 1/22/15 09:42:31 FSR12101
Invalid transactions
-------------------------------------------------------------------------------
Accounting year..... 15 Journal number...... 8953
-------------------------------------------------------------------------------
Dt Doc no Supplier no Name Amount
-------------------------------------------------------------------------------
F8=Valid transactions
Press F3.
- VA/480B* Journal maintenance 1/22/15 09:45:14 FSR11004
Update prompt
-------------------------------------------------------------------------------
Year/Journal number. 15 8953 A/P batch invoices
-------------------------------------------------------------------------------
Printer queue....... PRT01
Number of copies.... 1
Hold on spool file.. N
F12=Journal selection
Press enter to update. Go back to a command line, and key in DSPMSG and press enter. When the update has completed, you will see something like -
Work with Messages
System: BART
Messages for: SHEILAV
Type options below, then press Enter.
5=Display details and reply
Opt Message
Messages needing a reply
(No messages available)
Messages not needing a reply
_ Job 494208/SHEILAV/AP_INV_BAT completed normally on 01/22/15 at
09:46:28.
_ No error was found in G/L transaction journal 8953 (year 15), so update
will proceed
From . . : SHEILAV 01/22/15 09:46:28
_ No error was found in A/P invoice journal 8953 (year 15), so update will
proceed
From . . : SHEILAV 01/22/15 09:46:28
Bottom
F1=Help F3=Exit F5=Refresh F6=Display system operator messages
F12=Cancel F17=Top F18=Bottom F24=More keys
This shows that the post has completed properly. If you go back into ‘work with journals in error’ there will be nothing there. G/L Balances do Not Roll Over
From the scheduler, job ENDOFMONTH (program EOM) runs at 3:15AM on the first of every month. It calls UNIPHARMIT / EOMASW, which does a period roll over for every company. This is the command which retrieves the parameters, and the command that runs the roll over program. (Note that PAID is ‘parameter ID’.)
RTVASWPAR PGM(ASGC032) PAID(MONTHROLL) USER(*ALL)
EXCASWPGM PGM(ASGC032) PARM(Y) DTA('N +
NNY *DEVTYPE +
N
To see the parameters, find this record in file SROLPA -
Program User id Parameter Description LPUSR1
ID
ASGC032 *ALL MONTHROLL Roll all companies ACCFICIUI1I2I3PLUCVA
To see the effects of this, on a command line key in GO GLSET and press enter. Select option 2 – Work with G/L control file.
*CF/480B* G/L control file maintenance 3/20/15 09:03:48 GDMD0911
-------------------------------------------------------------------------------
Period name End date
Actual year/period.. 1602 FEBRUARY 022815
MARCH 033115
Last closed period.. 1513 APRIL 043015
First stored period. 0508 MAY 053115
JUNE 063015
JULY 073115
AUGUST 083115
SEPTEMBER 093015
OCTOBER 103115
NOVEMBER 113015
No of normal periods 12 DECEMBER 123115
Total no of periods. 13 JANUARY 013116
YEAR END 043016
‘Actual year / period’ is moved forward every time a period roll over is performed.
Although when you are in G/L Transaction Inquiry, it might look like the opening balances for the year have not been created, it may be that the Analyser summary levels are incorrect. A quick way of testing this, is to use query to look at the opening balances in Analyser. (See the section Programming / Query – SQL User Interface for detailed instructions.) Read files ANOSTK (keys) and ANOBOB (opening balances) matched on KESUTA eq BOSUTA, and KEREFK eq BOREFK. Define a result field of BODAOB + BOCAOB. Select records where BOYEAR eq the current fiscal year, and KEMK01 EQ some G/L account, for example ‘100200’ (CIBC – Operating Line).
When you run this query, you should see something like –
Display Report
Report width . . . . . : 917
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7..
BAL Lvl Key
cod 01
000001 497.40- 008 100200
000002 497.40- 002 100200
000003 497.40- 013 100200
000004 497.40- 006 100200
000005 497.40- 003 100200
000006 497.40- 004 100200
000007 497.40- 007 100200
000008 497.40- 009 100200
000009 497.40- 001 100200
000010 497.40- 014 100200
000011 497.40- 005 100200
000012 63,951.4000 A11 100200
000013 63,951.4000 A12 100200
****** ******** End of report ********
F3=Exit F12=Cancel F19=Left F20=Right F24=More keys
G/L Transaction Inquiry shows the balance for this account at 201512 as being 63951.50, which means the amounts showing for A11 and A12 (system base levels) are correct , and all the summary levels are wrong. This means they have to be rebuilt. For instructions, see the section ASW Analyser / Rebuild Custom Summary Level.
If you run the same query after the rebuilds, all the amounts should all be the same.
Display Report
Report width . . . . . : 917
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7..
BAL Lvl Key
cod 01
000001 63,951.4000 008 100200
000002 63,951.4000 002 100200
000003 63,951.4000 013 100200
000004 63,951.4000 006 100200
000005 63,951.4000 003 100200
000006 63,951.4000 004 100200
000007 63,951.4000 007 100200
000008 63,951.4000 009 100200
000009 63,951.4000 001 100200
000010 63,951.4000 014 100200
000011 63,951.4000 005 100200
000012 63,951.4000 A11 100200
000013 63,951.4000 A12 100200
****** ******** End of report ********
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80 Cash Book not In Balance
It can be out of balance in two ways; the ‘open’ amount not equal to the total of the open transactions, or the ‘balance’ not equal to the bank balance in the G/L. Open Amount not In Balance
- VA/480B* Work with Cash Book reconciliation 8/13/08 15:58:08 FSR46001
Open transactions
Bank: 002 CIBC - Chequing Account (US) Open...... 10429.60-
Reconciled 106436.62
Balance... 96007.02
2=Change 5=Display 6=Related documents 7=Connected entries
8=Reconcile 9=Unreconcile 10=G/L transactions
Bank Dt Doc date Rscd Transaction ref. Open amount Curr B
002 CHQ 07/28/08 AP 235 969.60- USD
002 CHQ 07/30/08 AP 236 3500.00- USD
002 CHQ 08/06/08 AP 237 5960.00- USD
Bottom
Bank Dt Doc date Rscd Transaction ref. Open amount Open
002 Y
F1=Info F8=Move cursor
On a command line in ASW, key in GO CBACC and press enter. Select the option ‘Rebuild Cash Book Bank balances from transactions’.
Cash Book Not Equal to G/L
Use a query to find each periods total from the cash book transaction file, and compare each to the G/L.
- File name is SROCBA
- Select CABKCO as the bank number, and CACTTP as ‘ 1’ or ‘ 4’ (note those leading spaces)
- Sort on CAPERI accounting period
- Accumulate total of CASCTR bank amount in system currency
- Break on change in CAPERI accounting period
In ASW, go into G/L Transaction Enquiry.
- For the bank account, key each period into both the from and to period, and press enter to display those transactions
- Press F10 to display the total of the selected transactions.
- Compare each period to the query report.
- For the opening balance, select a period range from blank to one before the first period listed in the query report.
- Nancy can adjust the opening balance of the cash book (so far, that is what has always been incorrect). Cannot Close Cash Book Batch
On a command line in ASW, key in GO CASHBOOK and press enter. Select option ‘Work with Cash Book reconciliation’. Key in bank number, and page down until you get to the transaction.
*VA/480B* Work with Cash Book reconciliation 4/07/15 12:18:25 FSR46001
Open transactions
-------------------------------------------------------------------------------
Bank: 001 CIBC - Chequing Account (Cdn) Open...... 1969626.82-
Reconciled 116652750.67
Balance... 114683123.85
-------------------------------------------------------------------------------
2=Change 5=Display 6=Related documents 7=Connected entries
8=Reconcile 9=Unreconcile 10=G/L transactions
Bank Dt Doc date Rscd Transaction ref. Open amount Curr B
__ 001 CHQ 04/07/15 AP 70561 784.44- CAD
__ 001 CHQ 04/07/15 AP 70562 18900.79- CAD
__ 001 CHQ 04/07/15 AP 70563 1856.29- CAD
__ 001 EFT 03/02/15 AR05 201601P2 00000 425716.44- CAD *
__ 001 EFT 04/02/15 AP 8318745 01587 7396.53- CAD
__ 001 EFT 04/02/15 AP 8318746 01587 3158.45- CAD
__ 001 EFT 04/02/15 AP 8318747 01587 1194.96- CAD
__ 001 EFT 04/02/15 AP 8318748 01587 1101.74- CAD
More...
Bank Dt Doc date Rscd Transaction ref. Open amount Open
001 ___ ______ ____ _________________________________ ____________ Y
F1=Info F8=Move cursor
The asterisk on the right means that the batch is open – the program determines this because the voucher fields on this transaction are blank. In this case, there is another problem. This transaction was created by ARREFT60, which reads the EFT work file created from A/R statements, totals it, and gets the journal and voucher information from the A/R transaction file.
In this case, that information was not available in SRODTA while ARREFT60 was running. (I don’t know why). So get it from there now. In A/R transaction inquiry, lookup the document type and document date of the cash book transaction.
*VA/480B* A/R transactions and balance enquiry 4/07/15 13:54:59 FKR01610
-------------------------------------------------------------------------------
Sequence A/D
Debtor number....... __ _
_
Document type....... __ _
Document number..... __ _
Document date....... 1 D
Due date............ __ _
Transaction currency __ _
Selection
Debtor number....... ___________
Document type....... 1 EFT ___ ___ ___ ___ ___
Document number..... _ _______ _______ _______ _______ _______ _______
Document date....... 1 030215 ______ ______ ______ ______ ______
Due date............ _ ______ ______ ______ ______ ______ ______
A/R group........... _ __ __ __ __ __ __
Transaction currency _ ____ ____ ____ ____ ____ ____
Transaction amount.. _________________ - _________________
Settled items....... Y Open items.......... Y
F2=Print F6=Customer F7=Balances F8=Agreements F9=Statistics F10=Template
Look at the detail of any of the transactions shown.
*VA/480B* A/R transactions and balance enquiry 4/07/15 14:01:48 FKR01607
-------------------------------------------------------------------------------
Debtor number....... 10136 CATES MEDICINE CTR Cred limit 300000
-------------------------------------------------------------------------------
Document type....... EFT Voucher type........ 27
Document number..... 8317261 Voucher number...... 2700012
Document date....... 03/02/15 Voucher date........ 03/02/15
Due date............ 03/02/15 Period.............. 1602
Year/Journal number. 16 / 743 Batch number........
Text................ Statement Period 201601P2
Transaction currency CAD Primary currency.... CAD
Original amount..... 15695.06 Original amount..... 15695.06
Remaining amount.... Remaining amount....
Exchange rate....... 1.0000000 Exch rate period.... M 1503
A/R group........... 1
Interest stop code.. Payment stop code...
Reminder stop code.. Payment mode........
User................ NANCYN Last maint date.....
F2=G/L transactions info F6=Customer F7=Balances F8=Agreements
F9=Statistics F10=Text
Use DFU on file SR6CBA to add journal number, voucher type, voucher number, and voucher type to the cash book transaction.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : CBA File . . . . : SR6CBA
Bank company: 001
Transaction reference: 201601P2
Ref no: 23763324
Cash Book Data type: 1
Stat: Y
NCR acc ref: 3
Syst id: 2
Statement number:
Batch no:
Journal no: 743
Acc per: 201602
Doc date: 20150302
Docu type: EFT
Doc no: 8317280
Value date: 20150302
Vt: 27
Vou no: 2700012
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Press enter to see the rest of the record.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : CBA File . . . . : SR6CBA
Vou dte: 20150302
Transaction text: EFT from A/R Statements
Bank Currency: CAD
Bank Amount: 425716440-
Bank Amount Sys curr: 425716440-
Bank Open amount: 425716440-
Bank Open amount sys curr: 425716440-
Exch rate per: 3
Exch rate lvl: M
Exch rate time: 201503
Exch rate trans: 10000000
Cash Book Reason Code: AR05
Crt dte: 20150302
Time: 104751
User id: NANCYN
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Change Document Date
Depending on the type of transaction, use DFU on –
SR6CBA – Cash Book SR14DTA – Accounts Receivable SR14LTA – Accounts Payable Rounding Error in Goods Receiving File
A small amount, due to rounding, can be left in SROGRT but the complete quantity has already been matched. The only I know of to fix this, is to clear it with DFU (use file SR15GRT). Unmatched Purchase Orders Not in Balance
Unmatched purchase orders are in SROGRT, with a remaining amount. As part of month end, a query report is generated of this file, with sub totals by purchase order type. These sub totals can be compared to the corresponding G/L accounts to make sure they are in balance.
G/L account Purchase order type2 210050 MO Manual Order 210300 RT Return to Vendor 210500 CS Car Stock 210625 BE Price Variance – charge to H/O 210625 PV Price Variance – charge to Rep 210625 QV Quantity Variance 210675 PC Prairie Supply Co-op Credit (no longer used) 210675 PS Prairie Supply Co-op (no longer used) 220000 PE EDI Purchase Order 220000 PO Regular Purchase Order 220000 RO Rush Order 220000 XF Reference Purchase Order 220050 RE Receiving Error
If they are not in balance, the problem could be a timing issue. Receiving or invoicing can be done after the period end – which is after the report has been printed.
(Note that these examples are for regular PO types, that post to 220000.)
To check for this, run a query on file SROLOGGL, looking for any transactions for the previous period (or earlier), that were entered after the unmatched PO query report was run. Note that two checks have to be done. One for the day following, after 6:29AM – which is after the end of day processing has completed; and the other for any time after.
LGDIM1 EQ '220000' AND LGYYPP LE 201312 AND LGCDAT GT 20130201 OR LGDIM1 EQ '220000' AND LGYYPP LE 201312 AND LGCDAT EQ 20130201 AND LGCRTI GT 062900
This example looks for any transactions for the period just ended, that were entered after the report was printed.
Total LGSAMO, and compare to the difference.
Also look the other way; transactions done before the period end, but posted to a later period.
If it does not match, more digging has to be done. Run these queries (from library XX2480BP) to build a file of all purchase orders for which the total posted to the G/L does not agree with the remaining amount on SROGRT.
SROGRT is a balance file; not a transaction file, so you must restore it from the period end tape.
UNMATB02 – Extract purchase order transactions by document number.
Change this to include G/L transaction up the closing period.
UNMATB03 – Extract purchase order transactions by the PO number in the text
Change this to include G/L transaction up the closing period. The PO in the text can be different than the transaction number, if PO’s are matched against each other.
UNMATB04 – Summarized extracted G/L transactions by PO and G/L number
UNMATB05 – Build work file to use in join
UNMATB06A to UNMATM06F – Build separate file for each G/L number
UNMATB07 – Merge all these separate file together into one file, with separate columns for each G/L number
UNMATB08 – Summarized received and remaining amounts on SROGRT (goods receiving) by PO
Change this to read the version of SROGRT you have restored.
UNMATB09 – Build a version of the PO header file with a character PO number field
This is needed because that is what the PO number extracted from the G/L text field is.
UNMATB10 – Consolidate all files
Run RPG program XX2480BP/UNMATPO to add to this file, any PO numbers that have been matched together.
Download SHEILA2/ POCONS2 to Excel. The total difference between the G/L (SROLOGGL) and the unmatched PO (SROGRT) should match the amount you are looking for.
- taking into account that you will have to manually remove transactions done after the unmatched PO report was generated.
Note – Since we went live, there have been about 1304 unmatched PO’s.
182 Received before go live; invoiced after
1068 Debit Notes that no longer go into 220000. They are out of balance by the fictitious item used to charge tax.
495 RT 436 QV 105 PV
32 BE
1073 records for a total of -30324.33
22 Adjustments
Which leaves only about 32 PO’s that didn’t balance. Five times the receiving transactions went into the G/L twice. Six times invoicing did both a debit and a credit to 220000. Seven times there was a fictitious item on the PO (some should have been type MO). For the rest, the invoice amount didn’t agree with the amount received. The last time that happened was November 2006, so perhaps processes have been changed?
Once there is a known point at which this is in balance, you only have to investigate things after that date. ** When you have the unmatched purchase orders in balance, update the last in balance date, so that you will have fewer PO’s to manually balance next year. **
In balance at 2013Feb01.
Balanced at 2013Dec31, but corrections for system outage on Dec 16 were put into 201412, as 201411 was closed. See unmatched PO 201411.xlsx for details Problem with EFT Batch
Accounts Payable - RPG program EFRUP011 reads records from ASW payment proposal files and creates CIBC EFT interface transactions.
Accounts Receivable – RPG program ARREFT40 is called from ‘View Statement Control Periods’ to read records created by the statement run and create CIBC EFT interface transactions.
These transactions are sent to CIBC via their Business Banking web site.
1 01000 01000332370152291386 0010009001016512 uniPHARM CAD 5 7001386 08/17015237 6C 0002120700037311 000147216812293/1607P1 BALANCED HEALTH INTEGR 6C 00048024008600426726 000081617610164/1607P1 CLINIC DRUG STORE 6C 00049352009700646887 000060041710292/1607P1 FRONT STREET PHARMACY 6C 0003023201050798 000025661411286/1607P1 GLOVER'S MEDICINE CENT 6C 0004918605209049 000024437312305/1607P1 LONGEVITY COMPOUNDING 6C 0001098901036867 000016364010699/1607P1 PEOPLES DRUG MART #175 6C 001610690201834001 000000514411706/1607P1 PHARMASAVE #027 6C 0002920800006211 000077974312169/1607P1 PRESCRIPTION HEALTH ST 6C 0010029208821216 000267932611044/1607P1 SUNNYSIDE EVERGREEN PH 6C 0003028801056639 000099383111306/1607P1 SURLANG MEDICINE CENTR 6C 0001098901027581 000035411310684/1607P1 TOFINO PHARMACY 6C 0001321701006913 000195974411105/1607P1 VICTORIA COMPOUNDING P 6C 0001083801029021 000080552711112/1607P1 VITA VIE PHARMACY 6C 0010005209602011 000292013711124/1607P1 WEST END MEDICINE CENT 6C 0002913890015113 000277018711566/1607P1 WESTWINDS PHARMACY LTD 77000000150000000000 000016821140 9000001000015
Batch number – This sequential number ensures that no batches are missing, or posted twice.
Date – Format is month / day, then Julian.
Transaction Amount – D/C for debit or credit. The amount on the trailer must be equal to the total of the transactions.
If Nancy realises, after the file has been sent, that is something wrong, she can delete it from the bank, edit it on her PC, and resend it. But she must increment the sequential number in the file, then I.T. must also increment the control file. To do that, go to Unity / Start uniPharm Extensions / VA Company / Work with UWD IT Tools / FTP Connections.
To change the number for A/P, select ‘A/P FTP Configuration’. Press page down to see the record.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : EFCONFR File . . . . : EFCONFP
*RECNBR: 1 Next Create No: 2173
CIBC Originator #: 0100043801 EFT Tx Type: 460
Originator Short Name: uniPHARM
Originator Long Name: uniPHARM Wholesale Drugs Ltd.
Sett Inst ID: 010 Sett Branch Transit: 16512
Settlement Account: 0090010
CIBC EFT Data Folder: EFT____________________________________________________
OMS footer line 1: Please be advised that with the electronic funds transfe
r (EFT) run
OMS footer line 2: above, the following invoices/credit notes will be settl
ed. Please
OMS footer line 3: direct any questions or concerns to Nancy Ng at 604.276.
5202 or
OMS footer line 4: nancyn@unipharm.com.
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Change the ‘Next Create No.’ to the next available sequential number. Press enter to update, then F3 and enter to exit.
To change the number for A/R, select either ‘Statement CAD EDI Config’ or ‘Statement USD EDI Config’. Press page down to see the record.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : EFARCONFR File . . . . : EFARCONFP
*RECNBR: 1
Next Create No: 1388
CIBC DR Originator #: 0100023576
CIBC CR Originator #: 0100033237
EFT Tx Type: 700
Originator Short Name: uniPHARM
Originator Long Name: uniPHARM Wholesale Drugs Ltd.
Sett Inst ID: 010
Sett Branch Transit: 16512
Settlement Account: 0090010
CIBC EFT Data Folder: EFT
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Change the ‘Next Create No.’ to the next available sequential number. Press enter to update, then F3 and enter to exit. Cannot Add to Standing Order
Program FMR205 allows user to add, change, and delete records in a standing order. Every time a record is added, it is given the next sequential record number; the numbers from deleted records are not reused. This field (in file SRODTGI) is only 3 digits, so once 999 records have been added, records start being overwritten. The only option is to stop using this group, and create another one. FIN03KFMG Does not Balance to FIN03
Use Query to look at records in ANOSTK that have
KESUTA = A11 KEMK01 = 730200
Look at field KEMK14. It should be MISC for all records. If it is not, it must be changed.
When an out of balance journal is forced to update, it creates a balancing record into the out of balance account, or 730200. When this transaction is added to ANOBAL, for some reason it does not set the proper keys.
Account number 730200 is set up in the chart of accounts to have a second summary identity of MISC, so why is it updated to a summary ID of blank?
Use DFU or EZVIEW on file AN1STK to make the key fields (11 to 14) the same as the other records that match this account number (parts 1 to 6). Rebuild the ‘KPMG statement section’
Only ASW administrators can do this, so sign on as FINADMIN.
On a command line in ASW, key in GO GLPER and press enter. Select the option ‘Rebuild summary identities’.
*VA/480B* G/L summary identity rebuild 5/26/15 18:25:09 FMR22201
-------------------------------------------------------------------------------
Summary identity Changed Summary identity Changed
Statement Section... N
Cost Center Group 1. N
Cost Center Group 2. N
KPMG stmt section... N
NO SUMMARY IDENTITY HAVE BEEN CHANGED
THIS JOB WILL BE CANCELLED
If this process will not run, because no changes have been made, you can force it by setting the changed flag to ‘Y’ in G/L Control File Maintenance.
Key in GO GLSET and press enter. Select the option ‘Work with G/L control file’.
Press Enter until this screen shows.
*VA/480B* G/L control file maintenance 5/26/15 18:27:42 GDMD0922
-------------------------------------------------------------------------------
Related to
account part Changed
Summary id part 1... Statement Section 1 N
Summary id part 2... Cost Center Group 1 4 N
Summary id part 3... Cost Center Group 2 4 N
Summary id part 4... KPMG stmt section 1 N
F7=Translate
Change the column ‘Changed’ to Y for the section you want to rebuild (in this case ‘KPMG stmt section’), then go back to ‘Rebuild Summary Identities’.
Check results by running the report. Go to ASW / business reporting / work with reports. Print (option 6) FIN03-KPMG for the appropriate year and period . Buyers Cannot Inactivate an Item in a Warehouse
Use DFU to look at the item in file SRBSRO.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : SRO File . . . . : SRBSRO
Item: 00465112
Whse: MAI
Opt. no: ___
Def. ID: ________
Stat: _
Stock zone: O1
Bin loc 1: _______
Bin loc 2: _______
Qty on hnd: ______________
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
Notice that all the current quantity fields are empty. Press enter to see more.
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: 73
Qty iss YTD: 4000
Qty iss LY: 86000
Date: ________
Rec YTD: _____
Rec LY: 6
Qty rec YTD: _______________
Qty rec LY: 60000
Rec dte: 20141217
Ret YTD: ______
Ret LY: ______
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
We are only concerned with the top three quantities on this screen. ‘Quantity delivered not invoiced’ is (I think) a work field left over from an invoicing problem. As long as the other current quantities are zero, this can be removed.
Sales Orders
When IOP or HotLine create sales orders, first temporary orders are added to the ‘Copy sales order’ files. They are assigned temporary order numbers which is in the 9000000 range, copied into the regular sales order files, then given regular sales order numbers, and are deleted from the copy sales order files.
SROCSH Copy sales order / order header SROCSA Copy sales order/order address SROCSP Copy sales order/item lines SROCSPRS Copy sales order replacement/substitute item info
- This file is not cleared as part of the copy process, but as part of the month end purge. SROCSPRF Copy sales order/item lines, references
-This file has a lot or records in it, but doesn’t seem to be affecting anything SROCSHRF Copy sales order / order header, references
5,000 per week, which mean it should take about 4 years to reuse the same temporary numbers (?) Sales Order is Being Used by Another User
When a sales order is opened in update mode, the header is flagged as being in use. If it is not actually in use, it means that some function did not end properly, so did not reset this flag.
Reset it manually by using the instructions in Technical / DFU – Date File Utility on file SRBSOH in library UP1480BFVA.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : ORSHE File . . . . : SRBSOH
Ord no: 3220950
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Key in the sales order number that is flagged as being in use, and press enter twice.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : ORSHE File . . . . : SRBSOH
WSID: HAMZAS
Dsp addr pnl cde: N Dsp hdr pnl cde: N
Cred stat: WRK hld ord:
WRK stp ord: T of paym: Z80
Description: AR Net 10 days
Cred days: 10 T of del: FOB
Description: Free on Board
M of trpt: NRA
Description: No Route Assigned
Freight fee: ____________
Postage: ____________
Ins fee: ____________
Adm fee: ____________
Inv fee: ____________
Ord line: 300 Whse: MAI
Disp time: 20141113
Cust group: SH
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Clear the user name (or this could be a workstation name) from WSID, and press enter until the order number prompt appears again.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : ORSHE File . . . . : SRBSOH
Ord no: _______
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Press F3 to exit.
End Data Entry
Number of records processed
Added . . . . . : 0
Changed . . . . : 1
Deleted . . . . : 0
Type choice, press Enter.
End data entry . . . . . . . Y Y=Yes, N=No
F3=Exit F12=Cancel
Make sure this screen shows that you have changed a record, then press enter. Otherwise press F12 to try again. Sales Order Picking Order Already Allocated to Another Picker
If a picker deallocates a pick batch, it does not become available to another picker. For two reasons –
- PLDETL is a custom file which is not updated by this process
- WHOSUD, which is a base ASW file, is not updated by this process.
In order to make this batch available for another picker to allocate, go into file WH1SUD to clear field SDBAID (batch number), and into file PLDETL1 to clear fields PLBAID (RF batch number) and PLINSS (RF batch status). Pickers Can’t Get Batch, Even Though Some are There Symptom
A picker tries to create a new picking batch, and gets a message that says ‘No batches found. <<See supervisor>>’. When the supervisor looks into pick list status, or warehouse status, there are orders still waiting to be picked. Source of the Message
The program RFHR512 ‘Work with R/F instructions - select shipments’ uses SQL to select the next eligible pick list. If it then finds something wrong with it, it does not go back to get the next pick list. (Henry K2 has looked into this program, and determined that it would be very difficult for us to modify it. If this continues to be a problem, we would have to discuss it with Stanley of IBS.) Why Pick List is Invalid
- Pick List Partially Assigned to a Batch
When a picker selects a pick list, and it creates a batch, four data files are affected.
The following two files are created when an order is dropped for picking. When a picker selects them, the batch number is added. WHOSUH Suggestion header WHOSUD Suggestion detail
The next two files have records added to them when a batch is created. RFORFC R/F Control File a record is added RFORFI R/F Instruction File record is added for each item on pick
If this process is interrupted and the batch information is not put into all files, RFHR512 will not be able to properly deal with it.
As RFORFI seems to be the last file updated, the problem is that the batch does not exist in it. To correct it, delete the batch from RFORFC, and remove the batch number and instruction status from this pick list in WHOSUD. (Do NOT delete the records.) Remove the batch number from PLDETLP, and change the status to 0.
- Item on Pick List does not have Warehouse Management set on
Look for an item on WHOSUD with SDWHMG not equal to ‘Y’ (there are some old records from 2005). Activate warehouse management for this item (ASW may not allow it, but WebSmart will), and change this field.
- Next Pick List for Requested Zone Group is for Wrong Warehouse
In ‘Pick List Status’, set the filters to the zone group and the other warehouse. Change the priority of this pick list to 90 so it becomes last on the list instead of first.
This can happen when the only stock available in CGY is stuck on a gun – zone 99 is in zone group GENERAL. To correct this, use the green screen location movements to put the stock in the correct location. Use the instructions in Technical / DFU – Data File Utility to change the zone/ location in WHOSUD, and the zone group in PLDETL. Change the priority of the pick list back to what it was (probably 50).
- Next Pick List for Requested Zone Group was Manually Set to Completed
If ‘RF Batch Status’ (field PLINSS on file PLDETL) is manually set to 40, or completed, an ‘RF Batch Number‘ (field PLBAID) must also be entered – 1 will work. RF Gun is hung while picking order
There are many reasons for this to happen – problems with RF hardware, file locks, two pickers getting the same pick list, software error (there are some problems that occasionally cause the programs to loop)….. - Complete Batch (Still Shows for Picker)
After the RF gun has been reset or the job on the i cancelled, the original picker should sign on again. Go into the same zone again, and go into ‘picking’. If the batch with the problem still shows, select it. There may be messages that will allow the picker to continue, so try to ‘enter’ through them. - Confirm Pick (Batch no Longer Shows for Picker)
If the batch doesn’t still show, try to reconfirm the pick batch (this does not have to be done by the original user). This process will try to continue where it left off. See Technical / Post Pick Processing for details on this.
- if you are not on a gun, go to menu RFH, and select option 4 - Process R/F instructions.
- if you are not in the correct warehouse use F8 to change the warehouse, and select a resource (99 and your user name).
- select option ‘Get new zone group’ and pick any zone group.
- select option ‘Picking’ and press F11 to reconfirm pick batch.
- Enter (or scan) the pick list number.
- Depending on where the problem occurred, you may get this screen (or the upper left hand portion)
- PL/480B* Pick list confirmation 11/16/09 13:09:08 DMR33001
Pick list number.... Pick consolidation..
Dispatch date....... 111609
- Press enter.
- Also depending on where the problem occurred, you may get the normal confirmation screens.
This should complete the post picking process. - Batch Complete, but Invoice not Generated
Go to warehouse picking menu, and select option 2 Pick List Status. Find the pick list and look at the detail. (If an invoice number shows, you have a different problem.) Make note of the sales order number.
Go to ASW menu SALES and select option 1 Work with sales orders. Find the right sales order. If it is status 45 (ready for invoicing) you have to submit it to the direct programs.
Use option 6 (lines), then option 2 (changes) for any line. Press Enter, F12, F5. The order should either go away, or go to status 20 or 30 (if there are more lines that have not yet been picked).
There should now be an invoice number in the detail in Pick List Status, and the batch should be gone from RF1RFI. Cannot do ‘Confirm Sales Order Pick Lists’ from Menu ‘DISPAT’
Program WMR910 displays message WM91004 ‘Pick list cannot be confirmed, R/F instruction batch 5525038 is open’.
Edit WHBSUD (by ‘P’ and pick list #) to change ‘instruction status’ to 40. RF gun is hung (Items Locked in Location 88 PACKING)
The warehouse location occupancy file (WHOLOP) does not like having two records for the same item in the same location. This can be a problem if two pickers complete two orders that have the same item, at just the same time. The process moves the items into location 88 PACKING, and it is possible that one pick will grab the record that was put there by the other.
One pick will end normally, the other will hang.
Go into ‘Location Balance Inquiry’, and look at location MAI 88 PACKING. Normally there should be nothing here, as items only pass through momentarily as the pick is being completed. If there is something here, refresh the screen to see if it stays. If it does, make note of the number, as this item is the problem.
1. Location movement – manually move an item Before taking the file editing option below, try using the programs: -- The physical location of an item does not match what the system says: ASW 2. Supply chain processes 4. Warehouse 4. Inventory handling tasks 3. Enter location movements Enter warehouse, item, quantity, from zone and location, to zone and location
OR
2. File editing option Go to the warehouse Picking menu, ‘Work With RF Dispatching’ or ASW, ‘Work With RF Instructions’. Press F1 to shift info, filter on TYP = PCK, and press enter.
You should know which person is having the problem, so use option 5 – details to find the batch containing the item stuck in 88 PACKING. Make note of the batch number, the pick / reference number and the order number (for printing).
Go to warehouse Enquiries menu, ‘RF Batch Analysis’ to look at the batch and get the order number.
PLDETLL1 (pick list details) -- change PLINSS (status) to 40 – complete. ** Note that whenever manually setting this file to complete, also make sure that there is a batch number (PLBAID). If this field is blank, the RF picking process will continue to select this pick list. **
Continue with the section ‘Delete RF Batch’.
If the invoice doesn’t print
ASW 2. Supply chain processes 4. Warehouse 2. Dispatch tasks 4. Confirm Sales Order Pick Lists Key in Pick list number and press Enter.
- VA/480B* Pick list confirmation 3/17/06 15:59:12 DMR33001
------------------------------------------------------------------------------
Pick list number.... 5474616
Pick consolidation.. _______
Dispatch date....... 031706
Warning! some lines do not have a batch number
All the picked quantities should be shown. To change the status of the sales order from 30 to 45, F8 to take suggested qty or F9 to accept as is. Normally, take F8. On next screen, BL should be ‘N’. Keep entering to get out.
- VA/480B* Location confirmation 3/17/06 16:03:14 WMR91001
Pick
------------------------------------------------------------------------------
List number 5474616 Warehouse MAI
------------------------------------------------------------------------------
Line Item Sugg. qty
Batch Actual qty Zn Location PA SN
1 02058204 1.00
____
2 00762856 2.00
2.00 88 PACKING
3 00181057 2.00
2.00 88 PACKING
4 00517102 2.00
2.00 88 PACKING
5 00660548 1.00
1.00 88 PACKING
Line
F1=Change batch,loc. F8=Blank; sugg. qty F9=Blank; zero F10=Order
Anomaly: If 4.Confirm sales order pick lists will not allow F8 because “Batch open in RF instruction file” – use the instructions in Technical / DFU – Data File Utility on file WHBSUD to change SDINSS (sts) to 40=complete, enter quantity for wanted product, F9=zeros for the rest, < enter > out.
Kick-start invoice printing
ASW 2. Supply chain processes 2. Sales 1. Work with sales orders. Beside the order #, enter 6 for Lines, then 2 to change any line. Enter, F12 to exit. F5 to refresh. Status should have changed from 30 to 45, or if already sts 45, the invoice should have printed.
If this does not work, use the instructions in Technical / DFU – Data File Utility on file SRBSOH to change ‘Dir Inv’ (direct invoicing) to ‘N’, and ‘Btch Inv’ (batch invoicing) to ‘Y’. Then use option 13 in ‘Work With Sales Orders’ to produce an invoice.
If anything is still wrong, GO JOBDIR / 3. Work with DIRECT JOB log / F8 Status of the pick list is ‘being picked’, so this order cannot be completed.
Change the status (PLINSS) in file PLDETL from 15 to 00. This will allow the same picker to get back in.
To allow another picker, the batch will have to be cleared. Delete this warehouse/batch from the RF files – see section ‘Delete RF Batch’. Status of the pick list is ‘being picked’, but needs to be cancelled
(because the order has been re-entered)
The batch will have to be cleared. see section ‘Delete RF Batch’.
Change the status of the pick list to ‘fully complete’. Change the status field in PLDETL1 to 40. The batch number field must not be empty. If it is, change it to 1.
Zero receive the order in ASW (supply chain processing / warehouse / dispatch tasks / confirm sales order pick lists). If you get the message ‘Pick list cannot be confirmed, R/F instruction batch 9999999 is open’, remove the batch number from these records in file WHBSUD. (Type is P for picking). Picker Cannot Switch Warehouse and Select Resource
Check in ‘Resource Allocation Table Maintenance’. If the user is in the original warehouse twice, one must be deleted. Check the one left to make sure the user is still active in all zones. Go into the ‘resource’; all zones except ‘GC’ should be active. Activate a zone by selecting it. If it can’t be selected, the only option is F7 to activate all. The person still won’t be able to pick gift cards because they are in a locked cabinet.
A bug in the program to create a warehouse user added two records to this file for MAI; instead of one for MAI and one for RET. Order is Status 30 in ASW, But Not in Pick Lists Symptom
In ‘work with sales orders’ in ASW, the order shows status 30 (pick list), but it cannot be found in ‘pick list status’. Also, this order is ‘in use by another user’. Problem
Process to create a pick list started, but did not complete. Solution
Look at the order lines, and press F1 – Shift Info, to see the line status. Look at the detail of a line that is at status 30. If there is not a pick list number (in the lower right hand corner) this line is a problem. Use the instructions in Technical / DFU – Data File Utility on file WHBSOL (sales order lines) to change the line stat from 30 to 20. Also, in WHBSOH (sales order headers), change the order status from 30 to 20, and clear out the workstation ID. Use option 12 to generate a pick list for this order. Two Pickers get Same Pick List
This will work fine until it is time to generate the invoice; then both RF guns will freeze. If this happens when no-one in I.T. is available to fix this, the warehouse can ship one set of items to the customer, with a note saying the invoice will follow, put the second set back on the shelf, and send available information to I.T. Best would be the pick list or order number; at the very least customer number, and at least one item number. The program running on each RF gun needs to be cancelled by I.T. If not available, the guns can be put aside, and the end of day will do it. In that case. The pickers will have to sign on with an alternate user ID.
The items picked but not invoiced will be in location 88 PACKING. To find this, on a command line key in WRKQRY and press enter.
Work with Queries
Type choices, press Enter.
Option . . . . . . 1 1=Create, 2=Change, 3=Copy, 4=Delete
5=Display, 6=Print definition
8=Run in batch, 9=Run
Query . . . . . . . Name, F4 for list
Library . . . . . XX2480BP Name, *LIBL, F4 for list
F3=Exit F4=Prompt F5=Refresh F12=Cancel
Key in option 1 to create a query, and press enter.
Define the Query
Query . . . . . . : Option . . . . . : CREATE
Library . . . . : XX2480BP CCSID . . . . . . : 65535
Type options, press Enter. Press F21 to select all.
1=Select
Opt Query Definition Option
1 Specify file selections
Define result fields
Select and sequence fields
1 Select records
Select sort fields
Select collating sequence
Specify report column formatting
Select report summary functions
Define report breaks
Select output type and output form
Specify processing options
F3=Exit F5=Report F12=Cancel
F13=Layout F18=Files F21=Select all
Use option 1 to select ‘Specify file selections’ and ‘Select records’, and press enter.
Specify File Selections
Type choices, press Enter. Press F9 to specify an additional
file selection.
File . . . . . . . . . wholop Name, F4 for list
Library . . . . . . UP1480BFVA Name, *LIBL, F4 for list
Member . . . . . . . . *FIRST Name, *FIRST, F4 for list
Format . . . . . . . . *FIRST Name, *FIRST, F4 for list
F3=Exit F4=Prompt F5=Report F9=Add file
F12=Cancel F13=Layout F24=More keys
Key in file WHOLOP and library UP1480BFVA, and press enter twice.
Select Records
Type comparisons, press Enter. Specify OR to start each new group.
Tests: EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...
AND/OR Field Test Value (Field, Number, 'Characters', or ...)
LPLCID EQ 'PACKING'_____________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
Field Text Len Dec
LPSROM Warehouse number 3
LPLZON Location zone 2
LPLCID Location ID 8
LPPRDC Item 35
LPBATC Batch 13
More...
F3=Exit F5=Report F9=Insert F11=Display names only
F12=Cancel F13=Layout F20=Reorganize F24=More keys
Key in LPLCID (which is the location ID) EQ ‘PACKING’, and press F5 to see the results.
Display Report
Report width . . . . . : 314
Position to line . . . . . CHTG6J Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11
Whse Location Location ID Item Batch First Oldest Quantity in
zone put away reception location
date date
000001 MAI 88 PACKING 02430197 20141015 20141015 2.000
000002 MAI 88 PACKING 00527978 20120410 20141007 2.000
000003 MAI 88 PACKING 02202927 20120629 20141020 2.000
000004 MAI 88 PACKING 02281996 20140603 20140917 2.000
000005 MAI 88 PACKING 02202539 20131011 20140911 2.000
000006 MAI 88 PACKING 02377695 20130218 20140813 1.000
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
It is best to do this in the morning before the pickers start working, so that only items on the pick list that has a problem will show here. Items go into this location when the picker picks the last item on the pick list, and go out when the invoice is generated.
Next find the pick list, and see the actual item quantities. Go to the warehouse Picking and Shipping Menu, and selection option 2.
11/14/14 09:26:30 uniPHARM -- PRODUCTION PLRIQ040/LISTCTL
PLZ - Pick List Status PRODUCTION 1.00
Display Order Field Test Value
MAIN By Priority, Sched Dte, S __________ ____ _________________
Limit to: AND __________ ____ _________________
Date Range AND __________ ____ _________________
CU NOV 12 14 12:01 AM NOV 14 14 9:26 AM
Carr Stat Zone Group Del Locn Order Handler Customer Whs Item #
3220950 02377695
DT=Details
SD=Shipping Documents S #
Carr Zone Group Del Locn Schedule Pr h Lin STAT DESC CUST DESC
DT ATL OTC/HABA INTOWN NOV 14 14 8:05 AM 50 Y 6 fully comp SURLANG ME
F21=Srcn Reset
F3=Exit F5=Refresh F8=More Info F12=Previous F24=Srcn Save
In this case, we know the order number. As there can be multiple pick lists for one sales order, also key in one of the item numbers. Also change the date range to be sure the pick list will be included. Use option DT to see the details.
11/14/14 09:33:11 uniPHARM -- PRODUCTION PLRIU045/LISTCTL
PLZ - Pick List Details PRODUCTION 1.00
Pick List Batch Consol PL# Customer
3520488 5792627 11306 SURLANG MEDICINE CENTRE PHARM.
Warehouse Zone Group Order No
MAI OTC/HABA 3220950 105-19475 FRASER HWY
Del Locn Share? # Lines Invoice SURREY
INTOWN Y 6 BC V3S 6K7
Order Date Cutoff
Priority Scheduled Carrier THU NOV 13 2014 THU 9:05 PM
50 ATL Atlas Courier Pickup Date Added
Scheduled Pickup Status 8:05 AM NOV 13 14 12:11 PM
NOV 14 14 8:05 AM COMPLETED Atlas Courier
O/H P
Line Zone/Locn Qty UOM Item Desription Item # Qty k
10 O1 C133 1 EA IBUPROFEN 400MG CAPLETS 02377695 80 Y
20 O1 K042 1 EA SPECTRO JEL CLEANSER FRAG FREE 02430197 18 Y
100 O1 K121 1 EA NIZORAL SHAMPOO ANTI DANDRUFF 00527978 578 Y
220 O1 N420 1 EA VITAMIN D3 1000IU TAB BIOMEDIC 02202927 182 Y
250 O1 P210 1 EA FERROUS GLUCONATE 300MG TABLET 02281996 387 Y
260 O1 R161 1 EA ACETAMINOPHEN 500MG EX STR TAB 02202539 138 Y
F3=Exit
F5=Refresh F9=Show UPC F10=Show Size F12=Previous
Notice that these are the same items as are in the PACKING location, but all except for the first one are in PACKING twice. This could mean that it was only picked once. Check this by looking at transaction history.
On a command line within ASW, key in 80 and press enter.
- VA/480B* Enquiries 11/14/14 14:30:10 ASGD0101
-------------------------------------------------------------------------------
Template............ FIN Financial related
-------------------------------------------------------------------------------
F13 Balances and budgets
F14 G/L transactions
F15 Cash Book bank balances
F16 A/R balance/stat/agreem/trans
F17 Sales orders
F18 A/P balance/stat/agreem/trans
F19 Purchase orders
F20 Inventory transactions
F21 Goods receptions
F22 Account file
F23 Names
F24 Enquiries
F8=Change template
Press F24 to search list of available inquiries.
- VA/480B* Enquiry program selection 11/14/14 14:31:03 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 11/14/14 14:42:05 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 14:45:40 WMR16001
-------------------------------------------------------------------------------
Date Whs Zn Location Item Trans. Qty.
Date Whs Zn Location Item
MAI 02377695_______________________
F1=Shift info
Key in MAI and the item, then press enter. Press page up to get to the most recent transactions.
- VA/480B* Location transaction enquiry 14:45:40 WMR16001
Date Whs Zn Location Item Trans. Qty.
_ 11/12/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00 1 11/13/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 99 SHAROND 02377695 IBUPROFEN 400MG CAPLETS 1.00 _ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 99 SHAROND 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00 1 11/13/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 99 HAMZAS 02377695 IBUPROFEN 400MG CAPLETS 1.00 _ 11/13/14 MAI 99 HAMZAS 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00 1 11/13/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 99 THIDAN 02377695 IBUPROFEN 400MG CAPLETS 1.00 _ 11/13/14 MAI 99 THIDAN 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00 _ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00- 1 11/13/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 99 THIDAN 02377695 IBUPROFEN 400MG CAPLETS 1.00 _ 11/13/14 MAI 99 THIDAN 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00 _ 11/13/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/14/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/14/14 MAI O1 C133 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/14/14 MAI 99 SHAROND 02377695 IBUPROFEN 400MG CAPLETS 1.00 _ 11/14/14 MAI 99 SHAROND 02377695 IBUPROFEN 400MG CAPLETS 1.00- _ 11/14/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00 _ 11/14/14 MAI 88 PACKING 02377695 IBUPROFEN 400MG CAPLETS 1.00-
Date Whs Zn Location Item
MAI 02377695
F1=Shift info
Look at every transaction where the picker has taken something from the shelf.
- VA/480B* Location transaction enquiry 14:55:31 WMR16003
-------------------------------------------------------------------------------
Warehouse........... MAI Main Warehouse
Zone................ O1 OTC
Location ID......... C133
Item................ 02377695
IBUPROFEN 400MG CAPLETS
Batch............... Order reference.....
NCC number..........
Transit balance..... N
Awaiting QC......... N Awaiting costs...... N
Loc qty before...... 141.00
Transaction qty..... 1.00-
Loc qty after....... 140.00
Inventory event..... RPK1
Description......... R/F Pick from
Order number........ 3520488
Order line number... 1
Date................ 11/13/14
Time................ 17:20:30
User................ HAMZAS
Look at the ‘order number’; which for this type of transaction is actually the pick list number. It is only in one of the pick transactions for the day the problem occurred, therefore one picker picked all six lines, and the other picker only picked five. The question is, how many items were shipped to the customer, and how many were put back on the shelf. To find out, compare the quantity that is actually on the shelf, to what the computer says is in that location (the location balance; not the warehouse balance). If they agree, the item in PACKING was shipped to the customer and should be invoiced. If the shelf is over by 1, it should be transferred back to the shelf.
Go to the ASW warehouse dispatch task menu (GO DISPAT), and select option 4 Confirm sales order pick list.
- VA/480B* Pick list confirmation 11/14/14 10:45:33 DMR33001
-------------------------------------------------------------------------------
Pick list number.... 3520488
Pick consolidation.. _______
Dispatch date....... 111414
Key in the pick list number, and press enter
- VA/480B* Location confirmation 11/14/14 10:46:30 WMR91001
Pick
-------------------------------------------------------------------------------
List number 3520488 Warehouse MAI
-------------------------------------------------------------------------------
Line Item Sugg. qty
Batch Actual qty Zn Location PA SN +
1 02377695 1.00
1.00 88 PACKING
2 02430197 1.00
2.00 88 PACKING
3 00527978 1.00
2.00 88 PACKING
4 02202927 1.00
2.00 88 PACKING
5 02281996 1.00
2.00 88 PACKING
6 02202539 1.00
2.00 88 PACKING
-------------------------------------------------------------------------------
Line
F1=Change batch,loc. F8=Blank; sugg. qty F9=Blank; zero F10=Order
The ‘actual quantities’ do not agree with the ordered quantities, so have to be corrected. This is where you can change the quantity for the first item to match what was actually shipped.
- VA/480B* Location confirmation 11/14/14 11:09:02 WMR91001
Pick
-------------------------------------------------------------------------------
List number 3520488 Warehouse MAI
-------------------------------------------------------------------------------
Line Item Sugg. qty
Batch Actual qty Zn Location PA SN +
1 02377695 1.00
1.00 88 PACKING
2 02430197 1.00
1.00 88 PACKING
3 00527978 1.00
1.00 88 PACKING
4 02202927 1.00
1.00 88 PACKING
5 02281996 1.00
1.00 88 PACKING
6 02202539 1.00
1.00 88 PACKING
-------------------------------------------------------------------------------
Line
F1=Change batch,loc. F8=Blank; sugg. qty F9=Blank; zero F10=Order
You can key in the correct quantities (to agree with the pick list) and press either F8 or F9, or I think F10 will fix them.
- VA/480B* Pick list confirmation 11/14/14 11:10:41 DMR33004
-------------------------------------------------------------------------------
Pick list number.... 3520488
Customer............ 11306 SURLANG MEDICINE CENTRE PHARM.
-------------------------------------------------------------------------------
Line Unit Qty ord Qty dsp Bch/SN Bl P
Order Item Goods type Commodity code
1 EA 1.00 1.00 N
3220950 00527978
2 EA 1.00 1.00 N
3220950 02430197
3 EA 1.00 1.00 N
3220950 02202927
4 EA 1.00 1.00 N
3220950 02202539
5 EA 1.00 1.00 N
3220950 02281996
6 EA 1.00 1.00 N
3220950 02377695
-------------------------------------------------------------------------------
F1=Shift info
Double check that the quantity dispatched matches the quantity ordered, and that back log is ‘N’, then press enter.
- VA/480B* Pick list confirmation 11/14/14 11:11:18 DMR33008
-------------------------------------------------------------------------------
Pick list number.... 3520488
Customer............ 11306 SURLANG MEDICINE CENTRE PHARM.
TOD................. FOB Free on Board
MOT................. NRA No Route Assigned
-------------------------------------------------------------------------------
Order Type Freight Postage Insurance Ins % Admin fee Inv fee
3220950 WO __________ __________ _________ ______ __________ _________
F1=Goods marking and curr
Press enter again.
The sales order will now be in status 45 ‘ready to invoice’. The green screen pick list confirmation does not cause the ASW direct jobs to process this order, so we will have to do it. Go to the ASW sales tasks menu (GO SALES), and select option 1 Work with sales orders. Then key in the sales order number, and press enter.
*VA/480B* Work with sales orders 11/14/14 11:12:28 DMR30001
Header view
-------------------------------------------------------------------------------
1=Add 2=Change 3=Copy 4=Delete 5=Display 6=Lines 7=Text 8=Addresses
11=Order confirmation 12=Pick list 13=Invoicing
Order Customer Handler St OT Ord.date Order value
6 3220950 11306 SURLANG MEDI EDISO 45 WO 11/13/14 34.59
__ 3220934 12287 OUTREACH PHA EDISO 20 WF 11/13/14 102.37
__ 3220932 10481 MACDONALD'S EDISO 20 WF 11/13/14 83.57
__ 3220911 10814 PRATT'S COMP ROYF 20 SP 11/13/14 55.62
__ 3220904 12271 SUMMERLAND M EDISO 20 WF 11/13/14 59.40
__ 3220893 12175 PHARMASAVE # CHERYLC 20 SP 11/13/14 182.58
__ 3220870 11787 ROBIN'S PHAR EDISO 20 WF 11/13/14 1.24
__ 3220857 10418 KERRISDALE P EDISO 20 WF 11/13/14 23.96
__ 3220854 10418 KERRISDALE P NORMAM 20 SP 11/13/14 6.14
__ 3220810 11934 20/20 PHARMA EDISO 20 WF 11/13/14 43.23
__ 3220801 11087 UNIPHARM WHO FELIXP 30 IN 11/13/14 2261.64
More...
Order Customer Handler St OT Ord date
3220950 ____________ __________ __ __ ______
F1=Shift info F2=Item view F7=Repeat F8=Move cursor F10=More options
F11=View controls
Key in option 6 to see the lines. Key in option 2 Change for one of the items on the pick list, then press enter until you are back to the sales order header view. Press F5 to refresh; the sales order should no longer show, as the direct jobs will have invoiced it, and changed it to status 60.
Go back to the query display of items in location PACKING.
Display Report
Report width . . . . . : 314
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11
Whse Location Location ID Item Batch First Oldest Quantity in
zone put away reception location
date date
000001 MAI 88 PACKING 02430197 20141015 20141015 1.000
000002 MAI 88 PACKING 00527978 20120410 20141007 1.000
000003 MAI 88 PACKING 02202927 20120629 20141020 1.000
000004 MAI 88 PACKING 02281996 20140603 20140917 1.000
000005 MAI 88 PACKING 02202539 20131011 20140911 1.000
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
We are left with the duplicate picking – which may or may not including item 02377695; depending on whether or not you confirmed shipment of it.
Go into either location balance inquiry –
- VA/480B* Location balance enquiry 11/14/14 11:50:12 WMR15001
-------------------------------------------------------------------------------
Whs Zone Location Batch Tr QC AC Hld Unit On hand
Item
MAI * O1 K042 EA 18
02430197 SPECTRO JEL CLEANSER FRAG
MAI 88 PACKING EA 1
02430197 SPECTRO JEL CLEANSER FRAG
Whs Zone Location Batch Item NCC
MAI 02430197
Order ref Hld
F1=Shift info
Or item display in InfoNet –
Items have to be transferred from PACKING back to the shelf locations. Go to ASW inventory handling tasks (GO INVHAN), and select option 3 Enter location movements.
- VA/480B* Location movements entry 11/14/14 11:57:42 WMR71001
-------------------------------------------------------------------------------
Whs Item Batch Quantity
MAI 02430197 1.00
From zone/location 88 PACKING To zone/location O1 K042
MAI 00527978 1.00
From zone/location 88 PACKING To zone/location O1 K121
MAI 02202927 1.00
From zone/location 88 PACKING To zone/location O1 N420
MAI 02281996 1.00
From zone/location 88 PACKING To zone/location O1 P210
-------------------------------------------------------------------------------
Wh Item Batch Quantity
MAI 02202539 1
F.Zone F.Location T.Zone T.Location NCC no Tr Hld Order ref Line
88 PACKING O1 R161 N N _______ _____
Transfer all items from packing to the shelf location (picking not overflow) you see in either location balance inquiry or InfoNet. Refresh the screen after each transfer to check accuracy. When you are done, go back to the query display of items in location PACKING – there should be none; or perhaps just current activity. Picker Cannot Get Pick List (Batch # is 1)
In an effort to prevent two pickers from getting the same pick list, I changed RFHR512 to reserve a pick list by putting 1 into the batch number (this program uses a zero batch number to identify picks lists that have not been started). Very rarely, for some reason the program does not select the list reserved in this way; so the ‘1’ has to be manually removed from the batch number. Use DFU on file PLDETL1 to do this. Although this seems to be happening more often than two pickers getting the same pick list, it is much, much easier to fix. Invoices do Not Print
Inventory type sales orders are set to have invoices generated automatically, or ‘directly’. This means that when orders have been picked and set to status 45 – ready for invoicing, the direct jobs (DPRQx_VA in subsystem UP1480BS) will generate the invoice. The invoice goes into out queue JFPIPE, which is connected to the JetForms server (Lucy), which will print the formatted invoice to the requested printer.
Accounting sales order types are set to have invoices generated upon request, or ‘batch, from the ‘Work with Sales Orders’ menu option. Note that sales order types set to invoice ‘direct’ cannot be invoiced manually.
Usually this problem starts with a picker not getting an invoice. Get the pick list number, and lookup the sales order number.
In Unity Extensions –
50 – Warehouse Menu
1 – Picking Menu 2 – Pick List Status
In the upper right corner, key in field ‘PICK LIST’, test ‘EQ’ and value of the problem pick list number. If necessary, change the date range to cover the time of this list.
10/15/07 11:41:03 uniPHARM -- PRODUCTION PLRIQ040/LISTCTL
PLZ - Pick List Status PRODUCTION 1.00
Display Order Field Test Value
MAIN By Priority, Sched Dte, S PICK LIST EQ 6139676
Limit to: AND
Date Range AND
CU OCT 10 07 12:01 AM OCT 15 07 11:41 AM
Carr Stat Zone Group Del Locn Order Handler Customer Whs Item #
DT=Details
SD=Shipping Documents S #
Carr Zone Group Del Locn Schedule Pr h Lin STAT DESC CUST DESC
ATL PHARM INTOWN OCT 13 07 11:00 AM 1 Y 73 fully comp HOLLYBURN
* END *
F21=Srcn Reset
F3=Exit F5=Refresh F8=More Info F12=Previous F24=Srcn Save
Use option ‘DT’ to get the sales order number.
10/15/07 11:47:34 uniPHARM -- PRODUCTION PLRIU045/LISTCTL
PLZ - Pick List Details PRODUCTION 1.00
Pick List Batch Customer
6139676 1511278 10357 HOLLYBURN MEDICINE CENTRE PHAR
Warehouse Zone Group Order No 575 16th STREET
MAI PHARM 1529354
Del Locn Share? # Lines Invoice WEST VANCOUVER
INTOWN Y 73 BC V7V 4Y1
Order Date Cutoff
Priority Scheduled Carrier FRI OCT 12 2007 SAT 11:00 AM
01 ATL Atlas Courier Pickup Date Added
Scheduled Pickup Status 11:00 AM OCT 12 7 5:29 PM
OCT 13 07 11:00 AM COMPLETED Atlas Courier
O/H P
Line Zone/Locn Qty UOM Item Desription Size Qty k
30 RX A031 1 EA AVAPRO 150MG TABLETS 76 Y
40 RX A133 3 EA VIAGRA 100MG TABLETS 900 Y
50 RX A225 1 EA VIAGRA 50MG TABLETS 19 Y
60 RX A325 1 EA PMS-DICLOFENAC 50MG TABS 21 Y
F3=Exit
F5=Refresh F9=Show UPC F10=Show Item # F12=Previous
Notice that although this pick list is ‘fully completed’ there is no invoice number showing.
Go into ‘Work with sales orders’ and find this one. Look at the status of the lines on this pick list (F1 will show this). Note that a single sales order can be multiple pick lists and invoices, so go into the detail to be sure you are looking at items on the pick list in question.
Sales Orders Still in Status 30 – Waiting for Picking
If the items are in status 30, closing the picking did not update the sales order.
In ASW -
2 – Supply chain processing 4 – Warehouse 2 – Dispatch tasks 4 – Confirm sales order pick lists
Key in the pick list number and press enter.
- VA/480B* Location confirmation 10/15/07 11:33:52 WMR91001
Pick
List number 6139676 Warehouse MAI
Line Item Sugg. qty
Batch Actual qty Zn Location PA SN +
1 00911933 1.00
88 PACKING
2 00140848 3.00
88 PACKING
3 00140830 1.00
88 PACKING
4 00910232 1.00
88 PACKING
5 00069203 1.00
88 PACKING
6 02081446 2.00
88 PACKING
Line
F1=Change batch,loc. F8=Blank; sugg. qty F9=Blank; zero F10=Order
Notice that the location of all these items says ’88 PACKING’. This means that although the picker did everything correctly, this order got ‘stuck in packing’. One of the things that may cause this is two pickers moving the same item into packing at the same time.
Press F8 ‘Set Blank to Suggested Quantity’, and press enter twice.
Go back to ‘Work With Sales Orders’, and look at the status of these items. They should be status 45 – ready for invoicing.
Sales Orders in Status 45 – Ready for Invoicing
If the items are in status 45, the picked quantities have been updated, but not yet invoiced. Option 13 will invoice an accounting sales order. To invoice an inventory sales order, use option 6 and enter to display the lines. In front of any line that is status 45, use option 2 and press enter twice. Press F12. The status should be changed to 60. If it is, the sales order (or these items if there are multiple pick lists) will not be shown on this screen – you would have to go to sales order inquiry, or invoice inquiry to see for sure.
If this has still not invoiced, check the direct jobs.
Key in GO JOBDIR
- VA/480B* Direct Job Control Tasks 1/10/06 12:48:25 JOBDIR
Select one of the following: Application SoftWare
Release: XX1:480
1. Start all DIRECT JOBS in ASW
2. End all DIRECT JOBS in ASW
3. Work with DIRECT JOB log
4. Work with items
5. Start all MDC DIRECT JOBS in ASW
7. Work with MDC DIRECT JOB log
9. Start FREIGHT MONITOR JOB in ASW
10. End FREIGHT MONITOR JOB in ASW
Selection or command (C) IBS 1989-2002
===>
F3=Exit F4=Prompt F9=Retrieve F12=Cancel
F13=Information Assistant F16=AS/400 main menu
Option 3. Work with DIRECT JOB log.
- VA/480B* DIRECT JOB log maintenance 1/10/06 12:49:24 DSR9201
------------------------------------------------------------------------------
Trans Return
Type Order no Transaction data code Data queue
------------------------------------------------------------------------------
Trans type
F8=Rst DIRECT JOB for all rec
There should be no records shown here. If there are, it means that either the data queues or the direct jobs are stalled. F8 will reset the job queue.
If the invoices still do not generate, do option 2 - End all DIRECT JOBS in ASW, wait for it to complete, then do option 1 - Start all DIRECT JOBS in ASW.
If invoices still do not generate, the process might have to be jump started. To do this, have the warehouse pick and invoice another order. This may also complete any invoices that are stuck in the generation process.
Sales Orders in Status 60 – But no Invoice
Check to see if the invoice is stuck in the out queue.
Key in WRKOUTQ JF*
Work with All Output Queues
Type options, press Enter.
2=Change 3=Hold 4=Delete 5=Work with 6=Release 8=Description
9=Work with Writers 14=Clear
Opt Queue Library Files Writer Status
JFHOLD QUSRSYS 21 HLD
JFPIPE QUSRSYS 465 JFPIPE RLS
JFSTMTS QUSRSYS 0 JFSTMTS RLS
Bottom
Command
===>
F3=Exit F4=Prompt F5=Refresh F12=Cancel F24=More keys
JFHOLD is used for forms generated in the test system. Anything in here has to be manually moved into JFPIPE before it will print
JFSTMTS is used for statements only, to be able to manually control printing and distribution.
JFPIPE is connected to the Jet Forms server. Anything going into this queue will be printed unless it is at status HELD. If writer JFPIPE is not shown, key a ‘2’ in the option column, and press Enter until this screen is displayed again – this should start the writer. If the status is ‘Hold’, use option ‘6’ to change it to ‘Release’.
An easy way to tell if invoices are going to Jet Forms, is to use option 3 to temporarily hold JFPIPE so you can see the files. Don’t forget to restart this queue with option 6 when you are done.
Jet Forms server not printing invoices
Ask Network/Systems Administrator. Pick List in ‘General’ with no Warehouse
As the warehouse comes from a sales order line, this pick list has no lines. For some reason we have not been able to figure out, occasionally a promo order will generate a pick list with no lines. Use options PL then DT to find the sales order number, and confirm that this is indeed the problem. Then use DFU on PLDETL1 to put in a batch number (PLBAID) – perhaps something like ‘5’ so it is obvious it was done manually (not ‘1’; as that is used for something else), and change status (PLINSS) to 40.
4/02/15 14:38:51 uniPHARM -- PRODUCTION PLRIQ030/LISTCTL
PLZ - Warehouse Status PRODUCTION 1.00
Display Order Field Test Value
GROUP by Warehouse, Zone Group
Limit to: AND
Carr Sched Carr Zone Group Customer AND
Date Range Batch Status Share? Order Whse
CU MAR 27 15 1:15 PM APR 02 15 1:15 PM EQ
PL=Pick Lists
Not In
Warehouse Zone Group Started Progress Completed Total
PL GENERAL 1 0 0 1
__ MAI CANDY 0 0 120 120
__ MAI CARD/VALU 0 0 5 5
__ MAI DANGEROUS 0 0 7 7
__ MAI HHCMEZZ 0 0 732 732
__ MAI LARGEDOWN 0 0 361 361
__ MAI LARGEUP 0 0 368 368
__ MAI MISC 0 0 2 2
__ MAI NARC 0 0 613 613 +
F21=Srcn Reset
F3=Exit F5=Refresh F12=Previous F24=Srcn Save
Purchase Order (PO) Receiving Problems No Valid Lines for RF Receiving, or Lines at Status 30
When this message is received while trying to do RF receiving on a PO with open lines, it means those lines are in the wrong status. They are in status 30 (reception note has been printed, which is the first step for green screen receiving), when they should be 20 (printed) or 25 (confirmed).
It is not normal for an inventory PO to be in this status – somebody has done something wrong. To change the status of the line back to status 20, it has to be zero received and back ordered.
Go to PO inquiry, and look at the line to get the reception note number. Note that this does not show in work with purchase orders, only purchase order inquiry.
- VA/480B* Purchase order enquiry 9/10/14 14:22:43 DMR11907
Detailed order line 1
-------------------------------------------------------------------------------
Supplier.... 20409 BOWERS MEDICAL SUPPLY Order value. 145.05
Order type.. PO Regular Purchase Order Ord val CAD 145.05
Order number 8178055
-------------------------------------------------------------------------------
Line 90 Orig status. 10 Act status.. 30
Item........ 00685651
MESORB ABSORBENT PAD
Supp item cd SANC677701
Warehouse... MAI Purch unit.. EA Rec note. 4308432
Contract no. Promised dat 09/03/14 Rec line.... 1
Primary qty. 5.00 Request date 09/03/14 Backlog..... Y
Order qty... 5.00 Disp date... 09/03/14 Backlogged.. N
Received qty Arrival date 09/07/14 Prev rec qty
Approved qty Rec date.... Trpt time... 4
Prc unit qty 5.00 Price unit.. EA FOC......... N
Price....... 29.01 Price code..
Order disc.. Y Disc amount. Currency.... CAD
Discount %..
Shipment mrk BASE Notify del.. N
F6=Pre-accounting F8=Addresses F9=Header
Then go to ‘Supply chain processes’ / ‘Warehouse’ / ‘Reception tasks’ / ‘Confirm purchase order reception notes’.
- VA/480B* Reception note confirmation 9/10/14 14:23:49 DMR53001
-------------------------------------------------------------------------------
Reception note...... 4308432
Reception date...... 091014
Transport note......
Actual dispatch date
Key in the reception note number and press enter.
- VA/480B* Location confirmation 9/10/14 14:24:23 WMR91001
Put-Away
-------------------------------------------------------------------------------
List number 4308432 Warehouse MAI
-------------------------------------------------------------------------------
Line Item Sugg. qty
Batch Disp date Zn Location PA SN +
1 00685651 5.00
090314 N2 C029
-------------------------------------------------------------------------------
Line
F1=Change batch,loc. F8=Blank; sugg. qty F9=Blank; zero F10=Order
The line(s) for that reception note will show. To do a zero receipt, press F9.
- VA/480B* Reception note confirmation 9/10/14 14:25:06 DMR53002
-------------------------------------------------------------------------------
Order number 8178055 Reception note 4308432
Supplier 20409 BOWERS MEDICAL SUPPLY Order type PO
-------------------------------------------------------------------------------
Line Item Qty ord. Qty rec. B/S B R
Order Description Disp date Unit Bin loc
1 00685651 5.00 0.00 Y
8178055 MESORB ABSORBENT PAD 090314 EA
F1=Create shipment F7=Discrete costs
Make sure that the line is set to back order, and press enter again. The effect of this is that the line will change from status 30 to 20. If you were to do this for a partial quantity instead of zero, the line would be changed to status 60, and a new line for the balance will be created, as status 30. Cannot Close Inbound Shipment - No Receiving Lines for Shipment
The receiving process is –
1 – scan the barcode of the shipment ID (which is the PO number, followed by a letter – A is first receipt, B is second, etc)
2 – scan the bar code of the PO number
3 – scan all the items received, and enter each quantity
3 – close the shipment, which will apply the receipts against the PO and close the line (status 60), and make the products available to be picked (change the held flag on WHOLOP (Location occupancy) from ‘Y’ to ‘N’.
It is possible for the receiver to go back to step two for another purchase order without doing step 1 to change the shipment ID. This will combine multiple PO’s in a single shipment. The shipment ID for the second PO will not close as there will be no lines – they will close when the original shipment is closed. This won’t cause any problems; other than perhaps timing if you really want to close one PO without the other.
On the command line, key in WRKQRY and press enter.
Work with Queries
Type choices, press Enter.
Option . . . . . . 1 1=Create, 2=Change, 3=Copy, 4=Delete
5=Display, 6=Print definition
8=Run in batch, 9=Run
Query . . . . . . . Name, F4 for list
Library . . . . . qtemp Name, *LIBL, F4 for list
F3=Exit F4=Prompt F5=Refresh F12=Cancel
(C) COPYRIGHT IBM CORP. 1988
Key in option ‘1’ and library ‘QTEMP’, and press enter again.
Define the Query
Query . . . . . . : Option . . . . . : CREATE
Library . . . . : QTEMP CCSID . . . . . . : 65535
Type options, press Enter. Press F21 to select all.
1=Select
Opt Query Definition Option
1 Specify file selections
_ Define result fields
_ Select and sequence fields
1 Select records
_ Select sort fields
_ Select collating sequence
_ Specify report column formatting
_ Select report summary functions
_ Define report breaks
_ Select output type and output form
_ Specify processing options
F3=Exit F5=Report F12=Cancel
F13=Layout F18=Files F21=Select all
Key option ‘1’ for ‘Specify file selections’ and ‘select records’, and press enter.
Specify File Selections
Type choices, press Enter. Press F9 to specify an additional
file selection.
File . . . . . . . . . srolcl Name, F4 for list
Library . . . . . . UP1480BFVA Name, *LIBL, F4 for list
Member . . . . . . . . *FIRST Name, *FIRST, F4 for list
Format . . . . . . . . *FIRST Name, *FIRST, F4 for list
F3=Exit F4=Prompt F5=Report F9=Add file
F12=Cancel F13=Layout F24=More keys
Key in ‘SROLCL’ (Shipment Lines) for file and ‘UP1480BFVA’ for library, and press enter twice.
Select Records
Type comparisons, press Enter. Specify OR to start each new group.
Tests: EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...
AND/OR Field Test Value (Field, Number, 'Characters', or ...)
CLORNO EQ 8178286_______________________
____ ________________ _____ ______________________________
____ ________________ _____ ______________________________
____ ________________ _____ ______________________________
____ ________________ _____ ______________________________
____ ________________ _____ ______________________________
Bottom
Field Text Len Dec
CLSHPS Shipping Status 2 0
CLSHIP Shipment ID 17
CLSHPA Shipping agent 11
CLORNO Order number 7 0
CLLINE Order line number 5 0
More...
F3=Exit F5=Report F9=Insert F11=Display names only
F12=Cancel F13=Layout F20=Reorganize F24=More keys
Key in ‘CLORNO EQ’ then the PO with the problem, and press F5.
Display Report
Report width . . . . . : 333
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11....+...12.
Shp Shipment ID Shipping Ord no Ord Supplier no Shpmt Item Qty
Sts agent line Line stock un
000001 60 8172890N 8178286 40 20130 500 00359489 10.0
000002 60 8172890N 8178286 260 20130 500 02107167 4.0
000003 60 8172890N 8178286 270 20130 500 02107175 5.0
000004 60 8172890N 8178286 290 20130 500 02113538 3.0
****** ******** End of report ********
Bottom
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
This shows that four lines for purchase order 8178286 were received under shipment 8172890N. The PO lines will be flagged as received when that shipment is closed. ‘Shp Sts’ of ‘60’ means that it has been closed.
To exit Query, press F3 until you see
Exit this Query
Type choices, press Enter.
Save definition . . . N Y=Yes, N=No
Run option . . . . . . 3 1=Run interactively
2=Run in batch
3=Do not run
For a saved definition:
Query . . . . . . . __________ Name
Library . . . . . QTEMP Name, F4 for list
Text . . . . . . . . __________________________________________________
Authority . . . . . *LIBCRTAUT *LIBCRTAUT, authorization list name,
*CHANGE, *ALL, *EXCLUDE, *USE
F4=Prompt F5=Report F12=Cancel F13=Layout
F14=Define the query
Make sure ‘Save definition’ is ‘N’ and ‘Run option’ is ‘3’, and press enter twice. It is not worthwhile to save this query as by this time you need it again, you will have forgotten where it is and what it’s called. It would be much faster to just create it again. Cannot Close Inbound Shipment - Shipment in Use
When an RF receiver starts working on a shipment, a record is added to UROLCU (Inbound shipment receiving RF users). When they are finished, that record is deleted.
If the process does not end properly, that record is left in the file, and the shipment will not be able to be closed. The message ‘The shipment is being used by RF receivers’ will be displayed.
- VA/480B* Work with inbound shipments 9/16/14 16:07:44 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 8178391 MAI 8178391 30 N
_ 8178410B MAI 8178410 10 N
_ 8178425 MAI 8178425 10 N
Bottom
Shipment ID Ship agent Whs
8178391
F7=Repeat F8=Move cursor F10=More options
The shipment is being used by RF receivers
On the warehouse receiving menu, ‘Shipments in Use Inquiry’ will display all records in UROLCU.
Display Report
Query . . . : XX2480BP/PLZQY180 Report width . . . . . : 55
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+
Shipment User Date/time
000001 8178391 EDMUNDY 2014-09-16-08.23.31.583000
****** ******** End of report ********
Bottom
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
Make sure that the receiver indicated as working on this shipment actually isn’t, then use the instructions in Technical / DFU – Data File Utility to remove the record from UROLCU.
Press page down until you see the record for the PO that won’t close.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : LCUU File . . . . : UROLCU
*RECNBR: 5
Shipment ID: 8178391
Shipping agent:
User id: EDMUNDY
Timestamp: 2014-09-16-08.23.31.583000
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Press F23 (upper shift F11) twice to delete. Cannot Close Inbound Shipment - Purchase Order Locked by Another User
Use the instructions in Technical / DFU – Data File Utility on file SRBPOH in library UP1480BFVA.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : ORPHE File . . . . : SRBPOH
Production order: N
Ord no: 8178391
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Key in ‘N’ for production order, the PO number, and press enter.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : ORPHE File . . . . : SRBPOH
Production order: N
Ord no: 8178391
Stat: _
Type: P
Ord tpe: PE
Ord dte: 20140910
Supplier no: 20233
Supplier reference: ______________
Order reference: __________
Hand: STUR
Lang: EN
Backl Y/N: Y
Ord disc: _____
Text no: ___
Hold order Y/N: N
WSID: *RF_RECEIV
Dsp addr pnl cde: N
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
If there is anything in the WSID field, clear it. Press enter 7 times, or page down once, to update the record. 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, look at the status field in file SROLCL for the purchase order.
On the command line, key in WRKQRY and press enter.
Work with Queries
Type choices, press Enter.
Option . . . . . . 1 1=Create, 2=Change, 3=Copy, 4=Delete
5=Display, 6=Print definition
8=Run in batch, 9=Run
Query . . . . . . . ¬¬¬__________ Name, F4 for list
Library . . . . . QTEMP Name, *LIBL, F4 for list
F3=Exit F4=Prompt F5=Refresh F12=Cancel
(C) COPYRIGHT IBM CORP. 1988
Key in option 1=Create and press enter.
Define the Query
Query . . . . . . : Option . . . . . : CREATE
Library . . . . : QTEMP CCSID . . . . . . : 65535
Type options, press Enter. Press F21 to select all.
1=Select
Opt Query Definition Option
1 Specify file selections
_ Define result fields
_ Select and sequence fields
1 Select records
_ Select sort fields
_ Select collating sequence
_ Specify report column formatting
_ Select report summary functions
_ Define report breaks
_ Select output type and output form
_ Specify processing options
F3=Exit F5=Report F12=Cancel
F13=Layout F18=Files F21=Select all
‘Specify file selections’ has automatically selected as this is a new query. Also select ‘Select records’.
Specify File Selections
Type choices, press Enter. Press F9 to specify an additional
file selection.
File . . . . . . . . . srolcl Name, F4 for list
Library . . . . . . UP1480BFVA Name, *LIBL, F4 for list
Member . . . . . . . . *FIRST Name, *FIRST, F4 for list
Format . . . . . . . . *FIRST Name, *FIRST, F4 for list
F3=Exit F4=Prompt F5=Report F9=Add file
F12=Cancel F13=Layout F24=More keys
Key in file name SROLCL and library UP1480BFVA and press enter twice.
Select Records
Type comparisons, press Enter. Specify OR to start each new group.
Tests: EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...
AND/OR Field Test Value (Field, Number, 'Characters', or ...)
CLORNO EQ 8179597________________________
____ _______________ _____ _______________________________
____ _______________ _____ _______________________________
____ _______________ _____ _______________________________
____ _______________ _____ _______________________________
____ _______________ _____ _______________________________
Bottom
Field Text Len Dec
CLSHPS Shipping Status 2 0
CLSHIP Shipment ID 17
CLSHPA Shipping agent 11
CLORNO Order number 7 0
CLLINE Order line number 5 0
More...
F3=Exit F5=Report F9=Insert F11=Display names only
F12=Cancel F13=Layout F20=Reorganize F24=More keys
Key in CLORNO EQ and then the purchase order number in question. Then press F5.
Display Report
Report width . . . . . : 333
Position to line . . . . . Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11
Shp Shipment ID Shipping Ord no Ord Supplier 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
More...
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 the instructions in Technical / DFU – Data File Utility on file SRBLCH to change the status from 60 to 30, and close again.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : LCH File . . . . : SRBLCH
Shipment ID: 8179597___________
Shipping agent: _____________
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Key in the Shipment ID from the query list, and press enter.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : LCH File . . . . : SRBLCH
Shipment ID: 8179597
Shipping agent:
Shp Sts: 30
Supplier no:
Description: 8179597
Whse: MAI
Hand: GORDIEL
Crt dte: 20141022
User id: GORDIEL
P l no: 4311238
Goods Reception Program: USRR842
All Req Y/N: N
Upd Req Y/N: N
Await Cost Check: N
Rec Pro Y/N: N
Total Lines: 17
Qty: 70000
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
The Ship status should be 60; change it to 30, and press enter twice.
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) is updated, but WHOLOP (location balance file) is not. WHOLOP is updated when the shipment is reclosed, 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 DFU can. Use the instructions in Technical / DFU – Data File Utility on file SRBSRO in library UP1480BFVA.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : SRO File . . . . : SRBSRO
Item: 02215663____________________________
Whse: MAI
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Key in the item number and warehouse, and press enter.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : SRO File . . . . : SRBSRO
Item: 02215663_____________________________
Whse: MAI
Opt. no: ___
Def. ID: _______
Stat: _
Stock zone: H1
Bin loc 1: _______
Bin loc 2: _______
Qty on hnd: 2000
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
Correct the ‘quantity on hand value. 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). Zero Receive
Try to receive through Work With Purchase Orders.
- Option 6, work with lines.
- Option 14, receive lines.
- Change quantity to zero (actually key in zero – don’t just blank out field).
- To actually cancel the line (as opposed to changing the status), change the backlog flag to ‘N’.
This will only work if no other receiving has been started on this line; ie it is on neither a reception note nor an inbound shipment. If this line is on a closed inbound shipment, the ‘shipment ID’ field will be filled in, and you will get a message saying the line is at an incorrect status. Change the shipment ID; ie add XX to the end, and press enter. Continue with zero receipt.
Try to receive through Confirm Purchase Order Reception Notes
- Use purchase order inquiry to find the reception note for this PO line.
- Go to Supply Chain Processing/Warehouse/Reception Tasks/Confirm purchase order reception notes.
- Key in the reception note number and press enter.
- Make sure the received quantity says zero, and press F9, enter.
- To actually cancel the line (as opposed to changing the status), change the backlog flag to ‘N’.
If this PO line is on an inbound shipment which is already at status 60, another shipment will have to be created with this line, in order to zero receive it.
- or change the status in SROLCL from 60 to 30
- get out of work with purchase orders before doing this **
- Go to Supply Chain Processing/Warehouse/Reception Tasks/Work with inbound shipments.
- Option 1 to add a shipment.
- Shipment ID will be the PO number followed by A, B, or whatever letter is required to get a unique ID. Description will be the PO number, warehouse MAI, and landed costs required N.
- Option 1 to add a line.
- Option 1 to select the PO line, F9 and enter to add it.
Try again to receive through Work With Purchase Orders.
- Option 6, work with lines.
- Option 14, receive lines.
- Key in the shipment ID (just created)
- Change quantity to zero (actually key in zero – don’t just blank out field).
- Press enter twice to get past warning.
- Change backlog to N and press enter. Replenishment
Replenishment batches are assigned to resources REP01 to REP25. An RF user can only access one of these batches if that resource is allocated to them. To see this, on a command line in ASW, key in 81 and press enter.
*VA/480B* Table maintenance program selection 9/16/15 12:47:26 ASGD0181
-------------------------------------------------------------------------------
Appl Table
_ AAC Locations
_ RFH Resource allocations
_ RFH Staging locations
_ WHM Location groups
_ WHM Location sizes
- WHM Location types
_ WHM Location unit of measures
_ WHM Locations
-------------------------------------------------------------------------------
Appl Search argument
___ location
Key ‘location’ as the search argument, and press enter. Select ‘Resource Allocations’.
*VA/480B* Resource allocation table maintenance 9/16/15 12:49:48 RFHD0271
-------------------------------------------------------------------------------
_ Whs Resource Handler Description Act user
_ MAI 88 REP01 AARONT
_ MAI 88 REP01 AARRONE
_ MAI 88 REP01 ABDIE
_ MAI 88 REP01 ADAMB
_ MAI 88 REP01 ADAMP
_ MAI 88 REP01 ADECCOA
_ MAI 88 REP01 ADECCOP
_ MAI 88 REP01 ADECCOSA
_ MAI 88 REP01 ADECCOSU
_ MAI 88 REP01 ADRIAND
_ MAI 88 REP01 ADRIANG
_ MAI 88 REP01 ADRIENNED
_ MAI 88 REP01 ADRIENNK
_ MAI 88 REP01 AGNESC
_ MAI 88 REP01 AHMEDA
-------------------------------------------------------------------------------
Whs Resource Handler Search argument
MAI 88 REP01 __________
Position to MAI 88 REP01. If the user is not there, from a command line, key in ADDPICK and press F4 to prompt.
Add Picker to Replenishment (ADDPICK)
Type choices, press Enter.
Picker . . . . . . . . . . . . . JOHNS Character value
Warehouse . . . . . . . . . . . MAI Character value
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
This is the user profile, in upper case, not the user’s name. Press enter to add the user to the resource allocations. PutAway Handler in Resource Allocation Table More Than Once
*PL/480B* Resource allocation table maintenance 3/26/15 10:38:06 RFHD0271
-------------------------------------------------------------------------------
Whs Resource Handler Description Act user
_ MAI 99 THIDAN THIDAN AD Thida Naw THIDAN
_ MAI 99 THIRUA THIRUA AD Thiru Aru THIRUA
_ MAI 99 THOMASB THOMASB AD Thomas Bousquet THOMASB
_ MAI 99 THOMASB THOMASB AD Thomas Bousquet THOMASB
_ MAI 99 THOMASC THOMASC AD Thomas Chung THOMASC
_ MAI 99 THORT THORT AD Thor Thomson THORT
_ MAI 99 TIFFANYO TIFFANYO AD Tiffany Ounpuu TIFFANYO
_ MAI 99 TIFFANYW TIFFANYW Tiffany Wong TIFFANYW
_ MAI 99 TINAL TINAL AD Tina Lo TINAL
_ MAI 99 TINGZ TINGZ
_ MAI 99 TOMB TOMB AD Tom Bui TOMB
_ MAI 99 TOMC TOMC AD Tom Chotwanwirach TOMC
_ MAI 99 TOMH TOMH AD Tom Ho TOMH
-------------------------------------------------------------------------------
Whs Resource Handler Search argument
___ __ ________ __________ ___________________________
Both of these duplicate records have an ‘active user’, which means they cannot be deleted. Use DFU to remove it from both of the records in file RFBCTLRS.
Select one of the duplicates, and make note of the zone restrictions. You may have to page down to see them all.
*PL/480B* Resource allocation table maintenance 3/26/15 10:41:03 RFHD0275
Zone restrictions
-------------------------------------------------------------------------------
Warehouse........... MAI Main Warehouse
Resource............ 99 THOMASB AD Thomas Bousquet
Handler............. THOMASB AD Thomas Bousquet
-------------------------------------------------------------------------------
Zone Description Active
A1 Health and Beauty Aids Y
A2 Health and Beauty Aids Y
CA 90's Mezzanine Candy Y
CP Computer Cage Y
DG Dangerous Goods Y
F1 Flow Racks Y
F2 Flow Racks Upstairs Y
GC Giftg card/ valuables N
HT Hidden Treasures Y
H1 Health Care Mezzanine Y
H2 Home Health Care Large Items Y
H3 Home Health Care Bulk MEZZ Y
MS Miscellaneous Y
NZ Precursor Y
N1 Large Down/90's Y
N2 Large Up/ Mezz Y
O1 OTC Y
PR Promo Area Y
RE returns inside cage Y
RF Fridge Items Y
RS Special Fridge Items Y
RX Upstairs Pharmaceuticals Y
R1 Zone R1 Y
R2 Zone R2 Y
R3 Promo receiving Y
R8 Zone R8 Y
SP Special Order Products Y
TO Gift card/valuables Y
TR Zone TR Y
WA Water Y
XX Narcotics Y
XY Pharm. in Narcotics Cage Y
XZ Precursors Y
ZA HABA Overflow Y
ZD Dangerous Goods Overflow Y
ZF Flowracks Overflow Y
ZG Gift Card Overflow N
ZH Home Healthcare Overflow Y
ZM Miscellaneous Overflow Y
ZO OTC Overflow Y
ZR Pharmaceutical Overflow Y
ZT Tobacco Overflow Y
ZX Narcotics Overflow Y
ZZ Putaway zone Y
Z1 Warehouse 1 Overstock Location Y
Z2 Warehouse 2 Overstock Location Y
Z3 Warehouse 2 Pushback Racking Y
Z4 Zone Z4 Y
Z5 Mezzanine Overstock Y
88 Miscellaneous locations Y
99 Resources Y
Zone
__
F7=Activate all F8=Deactivate all F10=Copy
Press F11 twice to delete (this is a hidden option – you just have to know it’s there). If it won’t allow it, you haven’t cleared the active user.
The zone restrictions will also have been deleted, so need to be re-activated.
- PL/480B* Resource allocation table maintenance 3/26/15 13:13:09 RFHD0275
Zone restrictions
-------------------------------------------------------------------------------
Warehouse........... MAI Main Warehouse
Resource............ 99 THOMASB AD Thomas Bousquet
Handler............. THOMASB AD Thomas Bousquet
-------------------------------------------------------------------------------
Zone Description Active
1 A1 Health and Beauty Aids N
1 A2 Health and Beauty Aids N
1 CA 90's Mezzanine Candy N
1 CP Computer Cage N
1 DG Dangerous Goods N
1 F1 Flow Racks N
1 F2 Flow Racks Upstairs N
GC Giftg card/ valuables N
1 HT Hidden Treasures N
1 H1 Health Care Mezzanine N
1 H2 Home Health Care Large Items N
More...
Zone
__
F7=Activate all F8=Deactivate all F10=Copy
Person Cannot do Return to Stock from Return Warehouse
Key in 81 on a command line within ASW.
- VA/480B* Table maintenance program selection 11/06/14 08:55:49 ASGD0181
Appl Table _ AAC Account codes _ AAC Acquisition accounts _ AAC Acquisition types _ AAC Asset account groups _ AAC Asset number series _ AAC Asset type & groups _ AAC Depreciation modules _ AAC Depreciation rules _ AAC Depreciation types _ AAC Disposal types _ AAC G/L transaction types _ AAC Indexes _ AAC Insurance companies _ AAC Insurance policies _ AAC Investment budgets
Appl Search argument
___ location______________________________
Key ‘location’ into search argument and press enter.
- VA/480B* Table maintenance program selection 11/06/14 08:55:49 ASGD0181
Appl Table _ AAC Locations _ RFH Resource allocations _ RFH Staging locations _ WHM Location groups _ WHM Location sizes _ WHM Location types _ WHM Location unit of measures 1 WHM Locations
Appl Search argument
___ ____________________________________
Select WHM Locations and press enter.
- VA/480B* Location table maintenance 11/06/14 08:57:31 WMR00201
_ Whs Zn Location C Size Type S.c Pic Item _ CGY BU A0103 STDC 100 00901033 _ CGY BU A0105 STDC 100 02252781 _ CGY BU A0107 STDC 100 02164077 _ CGY BU A0109 STDC 100 02343523 _ CGY BU A0111 STDC 100 _ CGY BU A0113 STDC 100 _ CGY BU A0115 STDC 100 _ CGY BU A0117 STDC 100 _ CGY BU A0119 STDC 100 _ CGY BU A0121 STDC 100 _ CGY BU A0123 STDC 100 _ CGY BU A0209 STDC 100 _ CGY BU A0211 STDC 100 _ CGY BU A0213 STDC 100 _ CGY BU A0215 STDC 100 ------------------------------------------------------------------------------- Whs Zn Location RET 99 KISHANP
Key in ‘ RET’, ‘99’, the person’s user ID, and press enter. If they are not there, add them. Select an existing person with RET 99.
- PL/480B* Location table maintenance 11/06/14 09:10:09 WMR00204
Warehouse........... RET Returns Warehouse
Zone................ 99 resources
Location............ KUSHK
Description......... AD Kush Kaur Stk take N
Item................ PA label N
Location size....... RESRC Auto put away....... N
Location type....... Movability.......... 30
Stock category...... Location group......
Multiple items...... Y Multiple put away... Y
Pick priority....... 800 Put away priority... 800
Pick sequence....... 0 Put away sequence... 0
Replenishment lvl %. .00 Put away level %.... .00
RF replenishment.... N RF repl from priorit 0 0
Utilised capacity %. Allocated capacity %
AVG utilisa. loc %.. AVG utilisa. res %..
Free capacity....... 9999999999.999 Last stock take date
Stock take code..... Repl. list/line.....
Stock take list..... First reserved trans
Last transaction.... 11/18/10 Creation date....... 01/16/09
F10=Copy record
Press F10 to copy this record.
*PL/480B* Location table maintenance 11/06/14 09:10:09 WMR00204
Location copy
-------------------------------------------------------------------------------
Warehouse........... RET Returns Warehouse
Zone................ 99 resources
Location............ KISHANP
Description......... AD Kishan Parmar Stk take N
Item................ PA label N
Location size....... RESRC Auto put away....... N
Location type....... Movability.......... 30
Stock category...... Location group...... ______
Multiple items...... Y Multiple put away... Y
Pick priority....... 800 Put away priority... 800
Pick sequence....... 0 Put away sequence... 0
Replenishment lvl %. .00 Put away level %.... .00
RF replenishment.... N RF repl from priorit 0 0
Utilised capacity %. Allocated capacity %
AVG utilisa. loc %.. AVG utilisa. res %..
Free capacity....... Last stock take date
Stock take code..... Repl. list/line.....
Stock take list..... First reserved trans
Last transaction.... Creation date....... 11/06/14
Key in the user ID and the name of the person you are adding. Note that although you are adding them to the ‘Location Table’, they are defined as a resource.
Go back to ‘Table maintenance program selection’ and select ‘RFH Resource Allocations’.
- VA/480B* Table maintenance program selection 11/06/14 08:55:49 ASGD0181
Appl Table _ AAC Locations 1 RFH Resource allocations _ RFH Staging locations _ WHM Location groups _ WHM Location sizes _ WHM Location types _ WHM Location unit of measures _ WHM Locations
Appl Search argument
___ _________________________________
Key in ‘ RET’, ‘99’, the person’s user ID, and press enter.
- VA/480B* Resource allocation table maintenance 11/06/14 08:59:28 RFHD0271
Whs Resource Handler Description Act user
_ RET 99 KITC KITC _ RET 99 KRISTYL KRISTYL AD Kristy Long _ RET 99 KULBIRS KULBIRS AD Kulbir Singh _ RET 99 KULWANTM KULWANTM AD Kulwant Mangat _ RET 99 KULWINDE KULWINDERB AD Kulwinder Beesla _ RET 99 KUSHK KUSHK AD Kush Kaur _ RET 99 KYLEC KYLEC AD Kyle Chan _ RET 99 KYLEH KYLEH AD Kyle Hicks _ RET 99 LAURIEG LAURIEG _ RET 99 LAVINGIA LAVINGIAS _ RET 99 LEONARDO LEONARDOC AD Leonardo Cuisson _ RET 99 LEWISJ LEWISJ _ RET 99 LIANGZ LIANGZ John Liang Zhang _ RET 99 LINDENP LINDENP AD Linden Picken _ RET 99 LIZJ LIZJ -------------------------------------------------------------------------------
Whs Resource Handler Search argument
RET 99 KISHANP __________ _____________________________________
If they are not there, add them. Select an existing person with RET 99, and press F10 to copy.
- PL/480B* Resource allocation table maintenance 11/06/14 10:29:24 RFHD0274
Resource copy
-------------------------------------------------------------------------------
Warehouse........... RET Returns Warehouse
Resource............ 99 KISHANP
Handler............. KISHANP
Key in the user ID for resource and handler, and press enter.
*PL/480B* Resource allocation table maintenance 11/06/14 10:35:01 RFHD0275
Zone restrictions
-------------------------------------------------------------------------------
Warehouse........... RET Returns Warehouse
Resource............ 99 KISHANP AD Kishan Parmar
Handler............. KISHANP AD Kishan Parmar
-------------------------------------------------------------------------------
Zone Description Active
_ RE Returns N
_ RN Returns in narcotics cage N
_ RX Returns N
_ TR Returns N
_ 88 Miscellaneous locations N
_ 99 resources N
Zone
__
F7=Activate all F8=Deactivate all F10=Copy
Press F7 to give the user access to all zones in the returns warehouse. Items on Put Away list Cannot be Found
A warehouse supervisor may report that an item on the put away list cannot be found. The most likely reason is that an order dropped for picking after the shipment was closed (which makes items available to sell by removing the hold flag in WHOLOP-location occupancy), but before the item was put into the picking location. In ASW, there is not a way to make a location ineligible for picking; that would solve this problem.
Run the list from Unity / Start uniPHARM Extensions / VA Company / Warehouse Menu / Receiving Menu / Pallet Contents (any of the four).
Display Report
Query . . . : XX2480BP/PLZQY140 Report width . . . . . : 138
Position to line . . . . . 14 Shift to column . . . . . .
Line ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11
Licence Item Whs Qty P/O P/O Receive Putaway Putaway Receive
Line Location Location Label Date
5000152466 02405744 SCENTUALS CALMING LAVENDER MAI 12 EA 8180494 40 R3-PR00 A2-J045 4001591092 2014-11-19 5000153531 02408706 CARDIOVIVA (FOR CHOLESTROL) MAI 24 EA 8181688 10 R1-O100 O1-F343 4001599560 2014-12-11 5000153548 02472538 MATTRESS PROTECTOR CONTOUR MAI 20 EA 8182317 350 R2-A200 ZZ-ZREC 4001607411 2015-01-08 5000153548 02472538 MATTRESS PROTECTOR CONTOUR MAI 14 EA 8182317 350 R1-A200 A2-R510 4001607410 2015-01-08 5000154019 00189126 MATTRESS PROTECTOR CONTOUR MAI 4 EA 8182317 20 R1-A200 A2-R540 4001607412 2015-01-08 5000154292 02393601 CAPS SNAP CAP 30/40/60DR MAI 10 CA 8182511 170 R1-N200 N2-A113 4001607205 2015-01-07 5000154449 00345603 TONGUE DEPRESSOR SENIOR MAI 20 EA 8182317 50 R2-N200 ZZ-ZREC 4001607423 2015-01-08 5000154449 00927897 UNDERPAD QUILTED WHITE MED MAI 6 EA 8182317 200 R2-N200 ZZ-ZREC 4001607409 2015-01-08 5000154450 00405811 GRAB BAR CHROME KNURLED MAI 1 EA 8182317 80 R1-N200 N2-F133 4001607429 2015-01-08 5000154450 00927897 UNDERPAD QUILTED WHITE MED MAI 8 EA 8182317 200 R1-N200 N2-B018 4001607408 2015-01-08 5000154450 00927996 URINAL FEMALE MAI 2 EA 8182317 210 R1-N200 N2-D307 4001607407 2015-01-08 5000154450 00928192 GRAB BAR CHROME KNURLED MAI 4 EA 8182317 230 R1-N200 N2-B524 4001607420 2015-01-08 5000154450 02312239 QUAD POD ADJ. CANE HUGO MAI 6 EA 8182317 340 R1-N200 N2-E231 4001607427 2015-01-08 5000154521 00295188 WALKER FOLDING ADULT BRONZE MAI 3 EA 8182317 30 R1-N100 N1-L105 4001607425 2015-01-08 5000154522 00184168 ORTHO CANE ALUMINUM ADJ. MAI 2 EA 8182317 10 R8-RUSH N2-H021 4001607414 2015-01-08
F3=Exit F12=Cancel F19=Left F20=Right F21=Split F22=Width 80
This list shows two very old items, one for the previous day, and the rest for the current day. Set your defaults to show stock availability, and go into InfoNet / Maintenance & Lists / Items.
Item 02405744 shows zero onhand and 12 reserved in location R3 PR00. This means that an order was dropped, and picked from this location before it was put away. Delete this record from WH1LOP – as the onhand is zero, this will have no effect. Then proceed to ‘complete the putaway’. It may have been partially picked – in that case change the reserved quantity to zero, and move using the green screen.
Item 02408706 shows no onhand and no locations for MAI, so proceed to ‘complete the putaway’.
Item 02393601 shows that 10 are still in location R1 N200, and 47 are in N2 A113. I looked, and there really are 47 at the location. So this one goes back to the warehouse, as there actually are 10 – somewhere – that need to be put away. Complete the Putaway
Use the instructions in Technical / DFU – Data File Utility on file URBPAL in library UP1480BFVA.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : PALU File . . . . : URBPAL
Production order: N
Ord no: 8180494
Ord line: 40
Generated from B=Bulk G=Rec note/QC note: _
Generated from Bulk suggestion Recep/QC note no: _______
Bulk/rec/QC note line number: _____
Put away label number: ___________
Batch: ______________
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Key in ‘N’, and the PO and lines numbers from the list, and press enter. As you have not keyed in the entire key, the record will not be found, and you will get the message ‘Record not found in file URBPAL in library UP1480BFVA’. But you will be positioned to that point in the file, so page down will get you to that record.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : PALU File . . . . : URBPAL
Production order: N
Ord no: 8180494
Ord line: 40
Generated from B=Bulk G=Rec note/QC note: G
Generated from Bulk suggestion Recep/QC note no: 4313089
Bulk/rec/QC note line number: 1
Put away label number: 4001591092
Batch: ______________
Bulk/rec/QC note sub line number: _____
Put away label line number: 10
Whse: MAI
Put away zone: R3
Put away from loc: PR00
Item: 02405744
Batch number: ___________
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Make sure that that this is the correct record be proceeding.
Press enter twice to display these fields.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : PALU File . . . . : URBPAL
RF batch date: ________
RF batch time: ______
Held balance Y/N: Y
Order ref. number: 8180494
Order ref. line: 40
RF Put away license plate number: 5000152466
PAL/LIC attached timestamp: __________________________
Creation timestamp: 2014-11-19-10.45.07.131000
RF batch status: C
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
‘RF batch status’ will be blank; change it to upper C and press enter.
Check the putaway list to make sure this now shows as completed. RF Batches Delete RF Batch
If an RF user cannot process a batch, or it gets stuck, they process as much of it as they can, then get IT to delete the batch. Note that history will be lost, as it does not go into the log files.
The files are –
RF1RFI (RF instructions) -- delete the applicable RF transactions (there will probably be two – one for the source and one for the destination).
RFBRFC (RF batches) -- delete the applicable RF batch.
RFBRID (RF instruction details) -- delete the applicable transaction.
Use the instructions in Technical / DFU – Data File Utility to change these files.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : RFI File . . . . : RF1RFI
Whse: MAI
Batch number: 5802034
Seq ovr rde: ____
Seq ins typ: _
Seq typ ovr: ____
Seq ovr rde: __
Seq put seq: __________
Seq for zone: __
Sequence location ID: ________
Sequence for item: ___________________________________
Sequence for batch: ____________
Instruction number: __________________
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Key in the warehouse (must be in upper case), and the batch number (must be right adjusted in the field), and press enter. As only a partial key has been entered (which means values were not keyed for every field on the screen), you will see ‘Record not found in file RF1RFI in library UP1480BFVA’. But you are now positioned to the correct place in the file, so press page down to see the next record.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : RFI File . . . . : RF1RFI
Whse: MAI
Batch number: 5802034
Seq ovr rde: ____
Seq ins typ: 1
Seq typ ovr: ____
Seq ovr rde: __
Seq put seq: __________
Seq for zone: H1
Sequence location ID: L437
Sequence for item: 02337277
Sequence for batch: _______________
Instruction number: 32673745
Ins typ: 1
Instruction status: 40
Pck put typ: 7
Pick instruction number: _________________
Item: 02337277
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Press F23 (uppershift F11) twice to delete the record. Press page down to see the next record. If it is for the same batch, delete it too. Continue until the batch number changes.
Repeat the same process for RFBRFC (RF batches), and RFBRID (RF instruction details).