Uploading Supply (Inventory on Purchase Order)

If you are an Amazon Integration or CSV user, updating current open purchase orders (Supply) is necessary for accurate purchasing recommendations.

QuickBooks Integrated Users:

Your open purchase orders are automatically updated from QuickBooks with each sync. It is important to keep your purchase orders up to date in QuickBooks in order to receive accurate purchasing recommendations in ForecastRx. The "Open Qty" column will reflect inventory on order that has not arrived yet. If this information is not accurate, please update your POs in QuickBooks or contact ForecastRx Support if the information in QuickBooks does not match ForecastRx. 

Amazon Integration and CSV Users:

If you are using ForecastRx to receive purchasing recommendations, it is important to upload your current purchase orders and make sure they are up to date before reviewing your purchasing recommendations.

This may sound like a time-consuming task, but it is only necessary to update your purchase orders when you would like to review purchasing recommendations. For example, if you use ForecastRx purchasing recommendations to create orders monthly, the Supply only needs to be updated once, before creating a new PO. 

Supply will not affect your demand forecast or your Amazon restock from warehouse recommendations. 

How to Upload Supply:

First, navigate to Manage Company > Supply. Supply is entered per SKU (Item Name), for each purchase order (PO). For example, if Item A is on two purchase orders (Order 1 and Order 2), you will need a row for Order 1 - Item A and another row for Order 2 - Item A. 

You will need to enter the Item Name and PO number/identifier, the date the PO was issued (PO Date) and the PO expected arrival date (Receive Date), as well as the Order Qty (total units on order) and Open Qty (outstanding units/not yet received).

Open Qty is important because this is the number of units that will factor into the purchasing recommendations. Open Qty and Order Qty should be equal when uploading a new PO. Over time as units begin to be received, you will reduce the Open Qty until it is fully received, and then you will delete the data from ForecastRx.

You can enter individual rows of Supply for each item by selecting "Add New" and entering the required information, or you can upload a .csv file with the required information. 

We recommend uploading a .csv file of each open PO. If any columns of data required in ForecastRx are missing from your PO, add them to your .csv before uploading.

For more information on how to upload files in ForecastRx, click here. 

If you would like to schedule a meeting with a member of the team—let us know, we are here to help!