Information Systems:ASW (Application SoftWare) by IBS (International Business Systems)
ASW (Application SoftWare) is IBS (International Business Systems) distribution & supply chain software.
Login credentials for the Iptor Knowledge Portal. Iptor is the new name for IBS. https://knowledgeportal.iptor.com/knowledgeportal/
- Username: jeremym@unipharm.com
- Password: 2004UWDasw4.8
The base ASW programs are in library A450AP (release 4.50). Then each release level has its own library containing objects that were changed; A452AP, A453AP, and A454AP. (What is CVT454AP?) Then modifications were made to run in the US; U480AP, U480BP, and UP1480BP. uniPHARM's modifications, and additional programs, are in XX2480BP.
Companies
Multiple companies can be defined in ASW. They will each have a separate data library; UP1480BVxx, where xx is the company code.
code short name company name AC *AC/480B* Adjustment Company CF *CF/480B* UWD & MC Charitable Foundation IC *IC/450B* uniCAP Investments IU *IU/450B* Investment Consolidation I1 *I1/450B* 0896756 BC Ltd. (Andreen's MC) I2 *I2/450B* Summerland Ventures Inc I3 *I3/450B* 0902658 BC Ltd. PL *PL/480B* uniPHARM Archive PR *PR/480B* ASW Base Company (PR) UC *UC/450B* uniPHARM Consolidation VA *VA/480B* uniPHARM Wholesale Drugs Ltd.
I1, I2, and I3 are pharmacies that IC (uniCAP Investments) owned. All four are consolidated, or added, into IU.
PL is for the test or development environment.
PR was an empty environment that we used as a template when we were testing conversion before we went live.
IU, and VA are consolidated together into UC. If any adjustments to UC are required, they are made into AC; which is then consolidated into UC.
Direct Jobs
Much of the order handling is handled by the ASW ‘DIRECT’ jobs, which are started up the first time an ASW job runs, and stay running until ended by the over night processing. They run in subsystem UP1480BS. A separate set is started up for each company. ‘VA’ in the job name is the company that they are processing.
Work with Active Jobs BART
06/24/15 10:33:40
CPU %: .0 Elapsed time: 00:00:00 Active jobs: 516
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
__ UP1480BS QSYS SBS .0 DEQW
__ AMTRDR_VAA ASW4OWN BCH .0 PGM-ASGC900 DEQW
__ AMTRDR_VAT ASW4OWN BCH .0 PGM-ASGC900 DEQW
__ AMTRDR_VAT ASW4OWN BCH .0 PGM-ASGC900 DEQW
__ DPRQ1_VA ASW4OWN BCH .0 PGM-ASGC900 DEQW
__ DPRQ2_VA ASW4OWN BCH .0 PGM-ASGC900 DEQW
__ DPRQ3_VA ASW4OWN BCH .0 PGM-ASGC900 DEQW
__ ORDFLOW_VA ASW4OWN BCH .0 PGM-ASGC900 DEQW
Bottom
Parameters or command
===> __________________________________________________
F3=Exit F5=Refresh F7=Find F10=Restart statistics
F11=Display elapsed data F12=Cancel F23=More options F24=More keys
In the past, we had an issue on Saturdays – because we were closed, the direct jobs were not started at all. Sales orders received electronically were not dropping for picking, which meant stock was not being allocated. We fixed this by starting up the direct jobs in the programs that bring systems back up after the end of day processing.
Whenever a program (with a few exceptions) touches either a sales order or a purchase order, the direct programs will look at it to decide if they should do any processing for it. The order type is checked to see if any direct action is required, for the status the order is in.
Document printout Batch Direct Order confirmation.. N N Pick list........... N Y Transport note...... N N Invoice............. N Y Cash receipt........ N
This is the setup of Sales Order Type ‘EO’ (Electronic Order). It means that it will automatically go from status 10 (entered) to 30 (pick list printed, or as we say ‘dropped to the warehouse for picking’), and from status 40 (pick confirmed) or 45 (ready to invoice) to 60 (invoiced).
Sometimes we see a sales order that should be processed by the direct jobs, in status 45. In order to get it to invoice, the direct jobs have to be nudged into looking at the line. Do this by going into it in ‘Work with Sales Orders’, and changing it. (This program has been modified so you cannot actually make any changes, but by going through the motions, you tell the direct jobs to look at it).
If an invoice still won't print, you can see if it is still in the data queue.
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 10/23/15 08:50:09 DSR9201 ------------------------------------------------------------------------------ Trans Return Type Order no Transaction data code Data queue ------------------------------------------------------------------------------ Trans type _ IN 3216907 ASWDTAQ1 _ IN 3216908 ASWDTAQ1 _ IN 3216909 ASWDTAQ1 _ IN 3216910 ASWDTAQ1 _ IN 3218365 ASWDTAQ1 _ IN 3233188 ASWDTAQ1 _ IN 3260246 ASWDTAQ1 _ IN 3279012 ASWDTAQ1 _ IN 3303762 ASWDTAQ1 _ IN 3325788 ASWDTAQ1 _ IN 3349510 ASWDTAQ1 _ IN 3355697 ASWDTAQ1 _ IN 3367080 ASWDTAQ1 ------------------------------------------------------------------------------ F8=Rst DIRECT JOB for all rec
You can look at the details.
*VA/480B* DIRECT JOB log maintenance 10/23/15 08:56:05 DSR9204
-------------------------------------------------------------------------------
Transaction type.... IN
Order number........ 3367080
Transaction data....
EODJOB
User................ EODJOB
Call from program... DMR386
Creation date....... 091015
Creation time....... 2:02:28
Return code.........
Data queue.......... ASWDTAQ1
F8=Rst DIRECT JOB for record
There should be no records shown here. If there are, and they are current, it means that either the data queues or the direct jobs are stalled. F8 will reset the job queue. If the records are all old (as they are in this example) it means that ASW could not process the document. In this example, all of these are COOP or VEDI bills that had problems. These sales orders are generated by a Miscellaneous Billing.
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.