InforPOS 1-Way File Exchange
Overview
Yellow Dog's 1-way interface with InforPOS pulls sales transactions from InforPOS to deplete inventory.
Sync Approach
Yellow Dog Inventory will pull sales from a .csv file from a FTP location provided by Infor.
Sync Frequency
This sync can be scheduled to run at any frequency, however it will only pull in sales when a file is provided.
Requirements
POS Partner
Infor will need to configure the export of Sales files and provide the FTP location with login credentials that Yellow Dog will need to access.
Responsibilities
Client
The client will need to provide the Infor Locations IDs and how they match the store(s) created in Yellow Dog.
POS Partner
TBD
Yellow Dog
TBD
Data Exchange
Sales Data
| InforPOS Field | Yellow Dog Field |
|---|---|
| LocationID | Revenue Center Code |
| SaleDate_Closed | CheckClosed |
| EmployeeID | EmployeeNumber |
| LastName,FirstName | EmployeeName |
| CheckID | TransactionNumber |
| LinkTo | Not a field in YD, but is used to determine which line items Modifiers, Discounts and Voids are assigned to |
| ShareID | Not a field in YD, but used in conjunction with LinkTo field as another ID for line items |
| TrnType | Not a field in YD, but used to determine how to tried the Line (i.e. Sale, Void, Tender, Tax) |
| TrnTypeDetail | DiscountDescription when discount, Tax/Tender description when Tax/Tender lines |
| ItemID | Item Number and SKU |
| ItemDesc | Item Description (also used for Tenders and Tax Description when that Transaction type) |
| UnitPrice | ItemRetail/ItemDiscount |
| SalesQTY | Quantity |
Workflows - Where Performed
| Workflow | InforPOS | Yellow Dog |
|---|---|---|
| Create Menu Item | Only Done in Infor | |
| Create Modifiers | Only Done in Infor | |
| Modifier Assignment to Items | Only Done in Infor | |
| Screen Placement for items | Only Done in Infor | |
| Discount Setup | Only Done in Infor | |
| Discount Assignment | Only Done in Infor | |
| Tax Setup | Only Done in Infor | |
| Tax Assignment | Only Done in Infor | |
Additional Information
The integration with InforPOS supports multiple LocationIDs per store in Yellow Dog.
Limitations
Transaction Line Number is always “0” in the Sales file provided so this will always default to “0” in Yellow Dog
