Difference between revisions of "Information Systems:Problems"
Jump to navigation
Jump to search
m |
|||
| (22 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | This is an old page. Sheila used this as the entry point / menu page for all articles related to system problems and how to solve them. The category [[:Category:Troubleshooting | Troubleshooting]] is now used in place of this page, and will contain sub-categories for problems pertaining to various areas. |
||
| + | |||
* [[ASW Messages]] |
* [[ASW Messages]] |
||
| + | * [[Batch Jobs not Running]] |
||
| + | * [[Carrier Interface#Problems|Carrier Interface Problems]] |
||
| + | * [[EDI#EDI Problems|EDI Problems]] |
||
| + | * [[Finance Problems]] |
||
| + | * [[Help Does Not Work]] |
||
| + | * [[Inventory Problems]] |
||
| + | * [[Invoicing Problems]] |
||
| + | * [[Low Order Volume]] |
||
| + | * [[Order Allocation Problems]] |
||
| + | * [[Order Minimums#Problem|Order Minimum Problems]] |
||
| + | * [[Over Night Processing Problems]] |
||
| + | * [[Picking Problems]] |
||
| + | * [[Purchase Order Problems]] |
||
| + | * [[PutAway Problems]] |
||
| + | * [[Receiving Problems]] |
||
* [[Record Lock (Unable to Allocate a Record]] |
* [[Record Lock (Unable to Allocate a Record]] |
||
| − | * [[ |
+ | * [[Replenishment Problems]] |
| − | * [[Batch |
+ | * [[RF Batch Problems]] |
| − | * [[ |
+ | * [[Sales Order Problems]] |
| − | * [[ |
+ | * [[System Messages]] |
| − | * [[ |
+ | * [[WebSmart Problems]] |
| − | * [[Picking]] |
||
| − | * [[Receiving]] |
||
| − | * [[Replenishment]] |
||
| − | * [[PutAway]] |
||
| − | * [[RF Batches]] |
||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | =ASW Messages= |
||
| − | |||
| − | When there is an error message in ASW, the easiest way to deal with it is to find where the error was issued, then work backwards to see what caused it. |
||
| − | |||
| − | The first thing is to find the error code. In this example, the error code does say what the problem is; but it doesn't always. |
||
| − | |||
| − | ==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== |
||
| − | |||
| − | [[File:problems-1.jpg]] |
||
| − | |||
| − | Make note of the program name; in this example, FSR820. |
||
| − | |||
| − | Click on the question mark to the right of the message. |
||
| − | |||
| − | [[File:problems-2.jpg]] |
||
| − | |||
| − | 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 file, library, and member, then 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), 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. |
||
| − | |||
| − | *VA/480B* A/R RECONCILIATION LIST |
||
| − | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - |
||
| − | A/R AMOUNT A/R AMOUNT G/L AMOUNT G/L AMOUNT G/L AMOUNT DIFFERENCE |
||
| − | Main Grou Subg Temp intrupt(a) Balance amt (b) Temp intrupt(c) Balance amt (d) Journal Maint(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 |
||
| − | |||
| − | 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 queue waiting for its turn to run, or in error while running) – |
||
| − | |||
| − | Using instructions in add link to DFU 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. |
||
| + | ==Notes and Suggested Improvements== |
||
| − | Repeat the same process for RFBRFC (RF batches), and RFBRID (RF instruction details). |
||
| + | Please see the following pages that have been created as a result of solving issues listed above. |
||
| + | * [[Questions for Protelo/Sheila]] |
||
| + | * [[Suggestions for routine problems]] |
||
Latest revision as of 15:43, 3 October 2016
This is an old page. Sheila used this as the entry point / menu page for all articles related to system problems and how to solve them. The category Troubleshooting is now used in place of this page, and will contain sub-categories for problems pertaining to various areas.
- ASW Messages
- Batch Jobs not Running
- Carrier Interface Problems
- EDI Problems
- Finance Problems
- Help Does Not Work
- Inventory Problems
- Invoicing Problems
- Low Order Volume
- Order Allocation Problems
- Order Minimum Problems
- Over Night Processing Problems
- Picking Problems
- Purchase Order Problems
- PutAway Problems
- Receiving Problems
- Record Lock (Unable to Allocate a Record
- Replenishment Problems
- RF Batch Problems
- Sales Order Problems
- System Messages
- WebSmart Problems
Notes and Suggested Improvements
Please see the following pages that have been created as a result of solving issues listed above.