What should I do about my effective date & time if my POS Sync only sends a sales file once a day?

What should I do about my effective date & time if my POS Sync only sends a sales file once a day?

Effective Date & Time - How should I set it?

                                    

Reminders:

Effective Date & Time:

This is the date and time your on-hand counts will be applied to your system as of. In other words, you are telling Yellow Dog, as of X date and time we had X amount of product on hand.

Closeout Date:

Once a full physical has been completed, the closeout date will update to match the effective date. This puts a hard close to the period and prevents any backdating to occur prior to the Physical.

Setting the correct effective date and time will ensure that on-hands update correctly once a physical is complete and guarantees that sales will be processed the following day without issue, especially if your location only receives sales once a day. To determine the correct effective date and time you will first need to confirm whether your sales report hourly, or as a ‘roll-up’ at midnight. 

Roll-up Locations:

Examples of this are Simphony 2 & Resort Suite. If you are uncertain about how your sales are received, reach out to the helpdesk for assistance.  

Your POS provides all sales once a day at approx. midnight, and the sales for that day will be listed as happening at 12am. These locations should set the Effective Date and time to 11:59pm. This will update your closeout date to the date that you counted. For example, if counts were collected in the evening of 18th, or the morning of the 19th prior to opening the effective date should be set to 11:59pm of the 18th. This will update the closeout to the 18th. When Sales come in at 12am on the 20th for the day prior (the 19th) they will be pulled in and processed appropriately. If the close out date updates to the 19th, those sales will not be able to be processed when they come, because the system will see it as attempting to backdate prior to the closeout date.

Hourly Locations:

Your locations receive sales hourly, and your effective date and time should be set to match when your counts were collected.



 





    • Related Articles

    • Reporting Explained: Sales By Day

      Business Need: This report is helpful for users who want a summary of sales by location over a period. How it Works: A Sales>By Item report shows a summary of sales for your stores in Yellow Dog. Generating the Report: Go to the Standard Reports ...

    • What is Closeout Date?

      System Closeout Date You can define a global closeout date that will prohibit any back-dating of manual adjustments, manual sales, purchasing documents and physicals from going past this date. It should be moved forward as you close out the month or ...

    • Troubleshooting: Missing Event Sales

      This article helps you identify and resolve issues when sales are missing from an event in Yellow Dog Inventory. It’s intended for Concession clients who utilize the Stand Sheet module to run events. Causes Sales Processing Sales have not been ...

    • Reporting Explained Sale By Hour of Day

      Business Need: This report is helpful for users who want a report to show sales organized by hour of day that the sale occurred. How it Works: A Sales>By Hour of Day report shows a summary of sales organized by the hour that the sale occurred. This ...

    • What is the Re-Assign Sales feature and how do I configure it?

      Re-Assign Sales - similar to Auto Transfer gives users the ability to have sales from one location, moved to appear under a secondary location. An example use case of this could be a primary location with a satellite kiosk location. While the kiosk ...

    • Recent Articles

    • Feature Overview: Client ID

      What is a Client ID? The Client ID is a unique identifier assigned to each Yellow Dog Inventory system. Who is it for? The Client ID will be used by any user that will access a Yellow Dog mobile or web app. What is it used for? A Client ID is ...

    • Feature Overview: Password Recovery

      What is Password Recovery? Password Recovery is a built-in feature that allows Yellow Dog users to securely reset their login credentials independently by answering predefined security questions. This self-service option reduces the need for ...

    • 377 Food & Beverage Webinar

      Curious about Yellow Dog Inventory version 377? New features, smarter workflows—watch the 377 Webinar now! Want to join the live webinar? We're hosting the 377 Food & Beverage Webinar weekly. Click HERE to sign up.

    • Feature Overview: Retail Price Fields

      Yellow Dog offers 3 different retail price fields (Default Retail, Current Retail, Starting Retail) in the item editor to provide different retail price tracking functions. Where: Item Editor > Retail Details tab Who: Retail users who manage retail ...

    • Yellow Dog/Silverware Integration Overview

      This document will provide an overview of the Yellow Dog Silverware Integration Integration Approach This can be setup as a 2Way – Push items and Pull sales or a 1Way – Pull sales Sales – Pulled from the Silverware API Codes – Pulled from the ...