Information Systems:Electronic Customer Invoices - Revision history

Sheilav: Blanked the page

2015-11-30T21:25:26Z

Blanked the page

Sheilav: Created page with "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..."

2015-10-26T19:44:55Z

Created page with "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..."

New page

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

← Older revision		Revision as of 21:25, 30 November 2015
Line 1:		Line 1:
−	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