511 Maintain Products at Warehouses – Trade feature

Purpose & Benefits
This function is available if the Trade option has been enabled. Click the browse button next to Multiple Locations/Warehouses in the Product record. It allows you to maintain certain data in the Warehouse Product records. A page of records is displayed at a time allowing updates to multiple records simultaneously, like in a spreadsheet, for extra ease of use.

On loading, the Maintain Product at Warehouse form displays any existing Product Warehouse records for each Warehouse at which a Product record has been created:

The greyed out columns are automatically maintained by the system, but in the grid you can edit the Min Qty value, i.e. the minimum in-stock quantity before re-ordering to replenish, and the Order Qty value, i.e. the minimum quantity to purchase when (re-)ordering.

To ‘drill-down’ and edit a record in more detail, if you are using the ‘ Trade‘ option to control stock at multiple locations, hover the mouse over the desired product’s code (the mouse pointer changes to a  ) and click once to bring up the Maintain Product Warehouse form (see below).

In the example we selected the HEED warehouse to drill down to. The form displays the full details of the selected Warehouse Product record as shown below.

You will note that the individual Warehouse Product record has its own NL Account details. This allows you to do ‘per Warehouse’ analysis of your accounts if you need to.