Information Systems:Electronic Invoices
We can build a data file for stores to update their purchase orders on their POS system. The file contains order lines that were cancelled, partially shipped, and fully shipped.
Go to Unity / Start uniPharm Extensions / VA Company (PRODUCTION) / Work with UWD IT Tools / FTP Connections / Invoice FTP Configuration.
This calls DFU on file INVFTPP. This file is used when invoicing, to connect to the FTP server, and download a list of products shipped. Stores can use this to update the purchase orders and stock levels on their POS.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : INVFTPR File . . . . : INVFTPP
Partner: 10789
Order Source: EDI-KROLL
Description: Pharmasave #255
FTP Server: ftp.unipharm.com
FTP User ID: ftporders
FTP Password: **********
FTP Directory: 10789/kinvoices
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : INVFTPR File . . . . : INVFTPP
Partner: 10789
Order Source: _________
Description: Pharmasave #255
FTP Server: ftp.unipharm.com
FTP User ID: ftporders
FTP Password: **********
FTP Directory: 10789/invoices
This file tells which stores want to receive invoice data, for which type of orders (blank means any), and where on our FTP server to put them. In the above example, Kroll orders are put into a different folder than all the others. This store has two different POS systems, each one needing to pick up its own invoices.
You can resend an invoice, or send an invoice that was created before the store was added to this file, by going into invoice inquiry, pressing F7=Create Invoice Copy, and keying in ‘Y’ for ‘FTP’.
Under special circumstances, for example opening a new store, they may want to get invoices for Web Orders to load into their point of sale system to update their inventory. Make sure there is an ‘invoice FTP Configuration’ record set up for them, with a blank order source (you may have to blank it out; if so make sure to put it back when this is complete). Go into invoice inquiry, and for each invoice, press F7=Create Invoice Copy, and key in ‘Y’ for ‘FTP’.
DMR344 (Invoice Printout) will check to see if the store wants this file (this program just checks to see if the store want invoices; it does not check by order source; that is done in INVRUP200), and if so, will call INVCUP200, which submits INVCUP200A, which calls INVRUP200.
This program checks to see if this order type should have an invoice FTP’ed. To see which ones do, look at the elements in UWD Tables UX FTPSOTYPES. Notice that these order types are for product sales; accounting charges, adjustments, and returns are excluded.
6/10/15 12:18:03 uniPHARM -- PRODUCTION TBRUP001/HEADER
CSU -- Show Table Entries CSU Release 6.0
UX FTPSOTYPES TABLE Table Library: RCSUTILPRD
UniPHARM Extensions Type
Sales Order Types to FTP Invoices U USER CONTROLLED
Start Display at Display Order
N By Element Name
2=Update 4=Cancel 5=Display A=Audit Info
Element Description/Data Sort
_ EO Y
_ EP Y
_ FO Y
_ OR Y
_ PR Y
_ RO Y
_ SO Y
_ SP Y
_ WF Y
_ WO Y
_ WP Y
F5=Refresh F6=Add new elements F12=Previous
It then looks at the ‘Invoice FTP Configuration’ file to see if the store wants invoices for orders from this source (ie Kroll, TRI). To see this file, go to Unity / Start uniPHARM Extensions / VA Company / Work with UWD IT Tools / FTP Connections / Invoice FTP Configuration.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : INVFTPR File . . . . : INVFTPP
Partner: 12331
Order Source: EDI-KROLL
Description: Everwell Pharmacy Kroll
FTP Server: ftp.unipharm.com
FTP User ID: ftporders
FTP Password: visionit525
FTP Directory: 12331/invoices
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
In this example, this store’s invoices for Kroll orders are placed into 12331/invoices. This can be the only record for this store, in which case no other invoices are sent. Or there can be another record (or even multiple records) with a different order source and FTP directory, or there can be a record with a blank order source, and different FTP directory; in which case all other invoices will be sent there. Program INVRUP200 will try to match by source before it looks for a blank one.
‘Handler’ on the order or invoice is used to indicate where the order source.
P.O.S. Handler ARI EDI-ARI TRI-RX EDI-TRIRX TRI-POS EDI-TRIPOS Positec EDI-POSITE Kroll EDI-KROLL Simplicity EDI-SIMPLI Miscellaneous X12 EDI-X12