View source for Information Systems:ASW (Application SoftWare) by IBS (International Business Systems)

ASW ('''A'''pplication '''S'''oft'''W'''are) is IBS ('''I'''nternational '''B'''usiness '''S'''ystems) 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 [[Company consolidation|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.

[[Category:ASW: Overview]]