You can set an item individual price for a specific customer (customers). To do this, you need to create the file customer_product_data.xml with the fields customer_code, product_code, price. Here is the example of the file customer_product_data.xml for a customer with code 4 and an item with code 12:
<?xml version="1.0" encoding="windows-1251"?>
<table name="customer_product_data">
<schema>
<field name="customer_code" type="TEXT KEY" />
<field name="product_code" type="TEXT KEY" />
<field name="price" type="REAL" />
</schema>
<data>
<record>
<f>4</f>
<f>12</f>
<f>17.50</f>
</record>
</data>
</table>
The table for selecting items in the «Request» document will look like this:
The individual price now has the highest priority over any other category of prices established for this customer. You can change it by selecting another category of prices in a document «Details», or manually tapping «Price» in the Quantity dialog box. To return an individual price, you can either delete the record from a document, or set its quantity as 0, and then enter a desired quantity again.
The same way you can add any field containing any item individual parameter for any customer. For example, if you want the information on the quantity of goods from a customer's previous «Request», your file customer_product_data.xml should look like this:
<?xml version="1.0" encoding="windows-1251"?>
<table name="customer_product_data">
<schema>
<field name="customer_code" type="TEXT KEY" />
<field name="product_code" type="TEXT KEY" />
<field name="price" type="REAL" />
<field name="preorder_count" type="REAL" />
</schema>
<data>
<record>
<f>4</f>
<f>12</f>
<f>17.50</f>
<f>6</f>
</record>
</data>
</table>
This is the result on your screen.
|