Overview

Yellow Dog's 2-Way integration with InforPOS pulls codes and sales data while pushing item data to Infor using their API v1.

Sync Approach

This interface contains one element:

  • Yellow Dog’s SyncYdiWithInforApi that pulls item codes and sales data while pushing newly created and updated item detail to Infor using their API.

Sync Frequency

This sync can be scheduled to run at any frequency but will be schedule to run hourly by default.

Configuration

This integration supports multitple instances of Infor per Yellow Dog database but requires a separate sync per Infor instance. Stores in Yellow Dog cannot be shared across multiple instances.

This integration also supports multiple RVCs per Yellow Dog Store.

Requirements

Client

The client will need to have an order placed with Infor to get the project kicked off and the necessary configuration needs provided to Yellow Dog.

POS Partner

Infor will need to provide an Infor API Url, Company ID and Store IDs as they related to stores in Yellow Dog.

Responsibilities

Client

The client will need to provide the following detail during implementation:

  • Store in Yellow Dog to be the interface store for each instance

  • Whether items are pushed to Company or Store

  • Which YD Value to be used as the Product Name

  • Which YD Value to be used as the Product Description

Data Exchange

Codes Pull

Item Data

All items in InforPOS are treated as single items including Yellow Dog Matrices and Parent/Child Items.

InforPOS FieldYellow Dog Field
Product IDItem Number
Product IDInforAPIProductID
CPGInterface: InforAPICPG
Category IDInterface: InforAPICategoryID
RestrictedInterface: InforAPIRestricted
WeightedInterface: InforAPIWeighted
InforPOS FieldYellow Dog Field
Menu ItemProduct Name set in Configure Tab
Item DescripitonProduct Description set in Configure Tab
SKUSKU
PriceRetail 1
CostDefault Vendor
SizeDimesnion 1
CPGInterface: InforAPICPG
Category IDInterface: InforAPICategoryId
RestrictedInterface: InforAPIRestricted
WeightedInterface: InforAPIWeighted
UPCsUPCs
EnabledActive

In order for an item to push to InforPOS the following must be configured:

  • Publish=Yes

  • Available to Store

  • Has Retail

  • Is not POS Blocked

  • Is Active

  • Is not removed/delted

Sales Data

InforPOS FieldYellow Dog Field
orderId-CheckIdTranscation Number
orderLineItemIdTransaction Line Number
Closed DateCheck Closed
orderLineItems.productIdItem Number
orderLineItems.productNameItem Description
orderLineItems.PriceItem Retail
orderLineItems.discounts.valueItem Discount
orderLineItems.QuantityQuantity Sold
orderPlacedbyEmployee Name

Workflows - Where Performed

WorkflowInforPOS Yellow Dog
Create Menu ItemOnly Done in Infor
Create Retail ItemDone in Yellow Dog
Create ModifiersOnly Done in Infor
Modifier Assignment to ItemsOnly Done in Infor
Screen Placement for itemsOnly Done in Infor
Discount SetupOnly Done in Infor
Discount AssignmentOnly Done in Infor
Tax SetupOnly Done in Infor
Tax AssignmentOnly Done in Infor
Create CPGOnly Done in Infor
Assign CPGDone In Yellow Dog
Create Category IDOnly Done in Infor
Assign Category IDDone In Yellow Dog

Additional Information

Limitations

  1. Weighted Items are not supported in Infor’s API and will always be set to false.

  2. Cost sent from Yellow Dog is rounded in Infor’s UI to 2 decimal places

  3. The ability to update “enabled” is not supported in Infor’s API so we will only send items that are Enabled

  4. Revenue and taxes are not supported

  5. Split checks present mulitples of the same item on the same check in Infor’s API and cannot be pulled accurately.

  6. Store Groups configuration is not supported. Yellow Dog can only push to either a Company or Store level.

  7. SKUs can not be modified after being created in InforPOS or it will cause a duplicate item to be created.

  8. There is a timezone discrepancy in the Infor’s API so currently sales are being pulled from SFTP (6/29/2022)

  9. Description has a 50 character limit in Infor (2/24/2023)