Information Systems:Electronic Customer Invoices
We can put an invoice file on our FTP server, for stores’ P.O.S. systems to pick up, and update their files.
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