Digital Dining Interface
The Digital Dining interface provides both a 1-Way and a 2-way interface where new items or item changes can be added automatically to Digital Dining and inventory will be reduced by POS sales.
The 1-way can provide sales exports for F&B inventory needs.
The 2-way is required for retail inventory needs.
The Digital Dining 2-Way interface with Yellow Dog Inventory contains two elements:
From Yellow Dog, a sync application which will
Provide an output file of any new/changed items,
Process a sales file that Digital Dining will create, and
Process a Digital Dining code file that the IBS Midwest program creates.
From IBS Midwest, a separate application that will
Process the item file produced by the Yellow Dog sync which will add or edit those items in Digital Dining,
Create a Digital Dining code file.
The Yellow Dog sync can be scheduled to run on a frequency of your choosing, although by default, it will be run at the top of every hour during business hours.
The Digital Dining Server must have the following installed:
Excel 2010 or higher
SyncYdiWithDigitalDining.exe must be installed and run from the Digital Dining Server.
Yellow Dog will need to have remote access to this server. We can provide access via our tool called TeamViewer or we can utilize your internal remote access methodology.
Recipes in Yellow Dog must be mapped to the correct POS items in order to report to the right inventory items.
Existing POS items and modifiers may need to be reconfigured so that the proper item is listed in the sales information and can be mapped to reduce the correct inventory items. Yellow Dog can review your setup prior to your acceptance of the proposal to identify what you and your POS team will need to do to allow our inventory system to work properly.
NOTE: Once implemented, all item changes must be made in Yellow Dog Inventory only.
The Yellow Dog sync picks up files to match item and sales data in Digital Dining to items in Yellow Dog. These files are generated by the Codebase Server engine's Programs Interface tool.
ORmmddyy.DBF is the file that contains sales data. This file is generated daily and updated (in real time) per check as items are ordered. (mmddyy) is the day the file was generated.
We also look to DEFREGTT, MNUITMDT, PFTCNTTT, and STFFILDT .DBF and .FPT files for additional, related sales information.
The following item details are sent to the Digital Dining system via IBS's import/export process in the Header sheet of the YDI_IMP.xlsm file:
Price 1 to 5
Tax 1 to 4
UPC Code ( Max = 12 )
In addition to the Header sheet where we write our item data, IBS writes Digital Dining code data to a number of sheets in the YDI_IMP.xlsm file.
The code data we receive includes:
New or changed items only appear in Digital Dining after a system refresh is performed.
An item can have a SKU number and 1 UPC code.
Each party will support their portion of the interface. All initial support can be routed to Yellow Dog who can ascertain if an escalation to IBS Midwest is necessary.
Additional Procedures - Orders
If a client needs a proposal to add this interface, please direct them to Yellow Dog Software. Yellow Dog Software will work with IBS Midwest once an order from a client has been made. A new order will be needed for any existing client switching from another version of Point of Sale.
Each of the two elements will be implemented separately by Yellow Dog and IBS Midwest.
The implementation will begin once your Digital Dining office has confirmed that it can accommodate all of these prerequisites and requirements.