Transactions with inventory (QOH) products cant be dated earlier than the Inventory Start Date for the product

Introduction

QuickBooks Online only allows selling items, if the order came after the product's inventory start date. If you sell an item before the date, QuickBooks will fail to create the item.

How does Connex assign the inventory start date?

By default, Connex assigns new products with a start date of January 1st of this year. If the order date is greater than the inventory start date, Connex will assign an inventory start date six months prior to the order date.

If Connex assigns this date, then why do I receive this error?

Likely, you entered the products by hand into QuickBooks. You set the start date to the day of entry:
adj_date.jpg

How do I change the inventory start date of existing items?

Here are the steps:

  1. Login to QuickBooks Online.
  2. Click the gear box and click products and services.
  3. To the right of the product, click the down arrow.
  4. Click run report: 
    run_report.jpg
  5. Click the first entry:
     start_entry.jpg
  6. Change the as of date to May 1st.
  7. Click save.

Next, resync the sale:

  1. Go to the my connections page.
  2. Expand manually sync an existing connection.
  3. Enter the order number.
  4. Click submit.

 

Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.