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

    • 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 ...

    • What are Manual Sales Entries?

      Manual Sales Entry Manual Sales Entry allows you to create simple, basic sales transactions using your inventory items without going to your POS. This can be useful for offsite sales, like a food truck in the example below.   Choose the Store you ...

    • Recent Articles

    • FAQs: Watchdog Report

      This article addresses frequently asked questions related to the Watchdog Report in Yellow Dog Inventory. General Questions Q: What is the Watchdog Report? A: The Watchdog Report scans your Yellow Dog database for errors and inconsistencies that ...

    • Feature Overview: Watchdog Report

      The Watchdog Report in Yellow Dog Inventory helps identify data issues that may affect inventory accuracy. Where: The Watchdog report is located under Home > Watchdog or can be found under your saved reports 201 – ALR – CHECK Watchdog When: Use this ...

    • How To: Use the Watchdog Report

      The Watchdog Report in Yellow Dog Inventory helps identify data issues that may affect inventory accuracy. Why It Matters: Reviewing and resolving issues identified in the Watchdog report regularly—especially before physical inventory— allow you to ...

    • Troubleshooting: Event Not Started

      This article explains what to do if your forgot to start your event. It is intended for Concession clients who manage events through the Stand Sheets module. Issue Event was not started on time. Solution Adjust your event’s Start Date/Time to the ...

    • Invoice Staging Features

      Main Page Overview <br> Right-Hand Buttons Bottom Buttons Learn more by checking out the Invoice Staging Guide Previous : Invoice Staging Workflows