How to Find the PO in Lightspeed with a Future Receiving Date

Symptoms

You’re seeing inventory values at 0 across all classes in Retail Orbit, and the trending is showing 100%. This typically indicates that there is receiving data set in the future in Lightspeed.

Cause

Retail Orbit relies on accurate receiving data from Lightspeed. If a Purchase Order (PO) has a future “received” date, the integration cannot process it correctly, which causes inventory to appear as zero and analytics to misfire.

Resolution: How to Locate and Fix the PO

Follow these steps in Lightspeed to identify and correct any PO with a future receiving date:

1. Log in to Lightspeed

Sign in to your Lightspeed Retail account.

2. Go to the Inventory Section

• From the left-hand menu, click Inventory

  

3. Select “Purchase Orders”

• This will take you to your list of all POs.

   

  

4. Apply Filters

To properly search through your POs:

• Vendor: Select All Vendors

• Location: Select All Locations

• Date Range: Set the range to go 60 days prior to today through 12 months into the future

📅 Example:

If today is June 7, set the range from April 8 of this year to May 31 of next year.

5. Sort by Received Date

• Click the Received column twice to sort by the most recent received dates.

• You should see an up arrow indicating it's sorted with newest dates at the top.

  

6. Identify Future Dates

• Look for any POs with a Received Date greater than today’s date.

• Open each offending PO and correct the Received Date to the accurate past or current date.

What to Do After You Fix the Dates

Once all future-dated POs have been corrected:

1. Email support@retailorbit.com.

2. Mention that the future receiving date(s) have been corrected.

3. Our support team will clear your current data and re-pull the corrected receiving data.

Still Can’t Find the Problem?

If you’re unable to locate the PO with the issue:

• Contact our support team at support@retailorbit.com.

• Include your Lightspeed login credentials and a brief explanation of the issue.

• We’ll investigate and help resolve it for you.