Skip to main content
Map data from Sage200
Updated over a year ago

Primary Vendor

The vendor with pref = Yes is the Primary vendor

Lead time

Minimum Order

If populated, orders for this item calculated by AGR will be automatically constrained to be at least this quantity.

Purchase price

Mapped from the Last Order Price, the Purchase price is useful, for example, for automatically constraining orders to a minimum purchase value.

Original Item No

Base unit of measure

The Base unit of measure is mapped from the Stock unit in Sage200, and is the unit of measure that AGR records and displays stock transactions, and all calculations are carried out at that level.

Note

The Base unit in AGR is not mapped from the Base unit in Sage200, as the term has different meaning in the two systems respectively. Base unit in AGR is equivalent to the Stock unit in Sage200.


Read more on the differences between Base unit and stock unit in the Sage200 product help manual.

Purchase unit of measure

Sage200 does not have a way of registering the default purchase unit for an item, so AGR will generate purchase orders in the stock unit.

Minimum order

If populated, orders for this item calculated by AGR will be automatically constrained to be at least this quantity.

Stock units

Stock units for each location is read from the column Qty in Stock in Sage200. Depending on your location setup in AGR, stock from multiple locations might be aggregated into a single location in AGR.

Undelivered

Reorder point

When using the Min/max order methodology, AGR will suggest an order for an item when the stock units are below the Reorder point.


This is mapped from the Re-order column under the Locations tab in Stock list in Sage200.

Actual sale

Sales history from Sage 200 is read from stock movement in the Stock Item History of type "Out - SOP". The sales history is displayed in the Item Card and, unless overridden by a sales history adjustment, is used to calculate the statistical forecast.


โ€‹

Did this answer your question?