Overview

The Digital Dining interface provides a two-way interface where new items or item changes can be added automatically to Digital Dining and inventory will be reduced by POS sales.

The Digital Dining 2-Way interface with Yellow Dog Inventory contains two elements:

  1. 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.
  2. 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.

Sync Frequency

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.

Requirements

Yellow Dog Requirements

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.

Prerequisites

The Digital Dining Server must have the following installed:

  • .Net 4.6.2
  • Excel 2010 or higher

Servers

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.

Data Exchange

Exporting Item Data

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:

  • PLU
  • Description
  • Prep Description
  • Price 1 to 5
  • Tax 1 to 4
  • Sale Type
  • Prep Type
  • Price Mode
  • Sales Mode
  • Modifier Mode
  • Qty Mode
  • Menu Course
  • Tare Weight
  • UPC Code ( Max = 12 )
  • Plate Cost
  • Prep Instruction

Importing Sales and Code Data

Importing Sales Data

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.

Importing Code Data

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:

  • Sale Type
  • Prep Type
  • Price Mode
  • Sales Mode
  • Modifier Mode
  • Qty Mode
  • Menu Course
  • POS Windows
  • Modifier Windows

Implementation

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.

Additional Information

Limitations

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.

Support

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. Yellow Dog will work with IBS Midwest once an order from a client has been made. Also, a new order will be needed for any existing client switching from another version of POS.