Information Systems:Electronic Invoices - Revision history

Jeremym at 21:53, 17 June 2016

2016-06-17T21:53:45Z

Sheilav at 21:24, 30 November 2015

2015-11-30T21:24:59Z

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

2015-11-23T20:56:18Z

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

New page

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’.

← Older revision		Revision as of 21:53, 17 June 2016
Line 91:		Line 91:
	Simplicity EDI-SIMPLI		Simplicity EDI-SIMPLI
	Miscellaneous X12 EDI-X12		Miscellaneous X12 EDI-X12
		+
		+	[[Category:ASW: Sales]]

← Older revision		Revision as of 21:24, 30 November 2015
Line 32:		Line 32:

	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’.		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