Help Center

Lightspeed R Series Inventory and Receiving Variances

Keith Autio
Keith Autio
  • Updated
RetailORBIT®
POWERED BY MANAGEMENT ONE
Lightspeed R Series Inventory and Receiving Variances

If your receiving in Retail ORBIT doesn't match Lightspeed, the Received Date on your purchase orders is usually the reason.

SYMPTOM

You see inventory differences when you run an Inventory Variance Report (for example, beginning-of-month inventory plus transactions doesn't equal current inventory), or when you compare receiving between Lightspeed and Retail ORBIT.

Why it happens

Lightspeed Retail uses a single purchase order (PO) for both On Order and Receiving. Unless the PO is handled carefully, that can create reporting differences.

  • When a PO is marked Finished, Lightspeed sends everything received on it to Retail ORBIT.
  • The Received Date decides when that receiving data is sent.
  • If the Received Date doesn't match the date you mark the PO Finished, the receiving may not be captured in Retail ORBIT for the right period.

If you receive a PO over more than one month, you may see monthly variances unless it's handled correctly.

How to keep receiving accurate

BEFORE YOU MARK A PO FINISHED

Check that the Received Date is today's date, the date you're finishing it. If it still shows an earlier receiving date, change it manually.

Lightspeed updates the Received Date automatically each time you receive items. If you mark the PO Finished on a later day without updating the date, Retail ORBIT won't pick up that PO when it syncs.

Examples

DONE RIGHT
Finished on the Received Date
  • PO total: $1,000
  • $700 received Jan 15 (Received Date = Jan 15)
  • $200 received Feb 5 (Received Date = Feb 5)
  • The last $100 won't arrive, so the PO is marked Finished on Feb 5
Result: Retail ORBIT receives $900 of receiving on Feb 5. Nothing shows for January.
WATCH OUT
Received Date not updated
  • PO total: $1,000
  • $700 received Jan 15 (Received Date = Jan 15)
  • $200 received Feb 5 (Received Date = Feb 5)
  • The last $100 won't arrive, so the PO is marked Finished on Feb 8, but the Received Date still says Feb 5
Result: Retail ORBIT receives no receiving data at all, not for January, Feb 5 or Feb 8.

Tips

  • Always check the Received Date before you finish a PO.
  • If you receive over several months, expect monthly variances unless you finish each PO within the month and set the correct Received Date.
Questions? Reach out to your retail coach or email support@retailorbit.com.
       

Was this article helpful?

2 out of 2 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.