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

    • What are POS-Only Sales Reports?

        The POS-Only Sales Reports will show all sales captured from the Point of Sale (POS) and if those sales were assigned to items or recipes.  We recommend users utilize this report to ensure all of their products being sold are assigned to items in ...

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

    • 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

    • Yellow Dog/Resort Suite Integration Overview

      This document will provide an overview of the Yellow Dog Resort Suite Integration Integration Approach This is a two-way file exchange integration – we pull sales and push items Sales – pulls sales from a CSV file Summary: will provide sales as a ...

    • Yellow Dog/Spa Soft Integration Overview

      This document will provide an overview of the Yellow Dog Spa Soft Integration Integration Approach This is a 2Way integration – pulling sales and pushing items Sales – pulled in from the Spa Soft API Multiple RVCs are support per Yellow Dog store ...

    • How To: Create Interface Codes for Spa Soft

      This document will review creating new interface codes for the Spa Soft Integration in Yellow Dog Software Overview If additional Department, Class, Division, Cuserdef1, Cuserdef2, Cuserdef3, PMS Posting IDs need to be added to items in Yellow Dog ...

    • Yellow Dog/Brink Integration Overview

      This document will provide an overview of the Yellow Dog Brink Integration Integration Approach This is a 1Way Integration – pulling sales only Sales – pulled in from the Brink API Mapping Recipes For ingredients to be depleted from inventory, all ...

    • Best Practices for Collecting Inventory Accounts During Business Hours

      This document will provide recommendations for clients who must count during business hours. Yellow Dogs best practice for performing a physical inventory is to capture counts outside of business hours, however; Yellow Dog understands that there are ...