The Price Checking function allows items price to be shown in Purchase Line according to Purchase Price List.

The button "Recalculate Price" allows users to recalculate the price per unit & discount if additional purchase lines are added / modified after the purchase order created from "Requisition Worksheet".

E.g. Item HAER.LX165T2R, purchase >=1000 Qty, will get $2000/unit instead of $2400 and additional 5% line discount.


Case example:

#Description

1, Multiple Sales Order with Sales Order Line for Item HAER.LX165T2R.

Qty = 100, 400, 500. Total = 1000

Sales Order it ready to run the Requisition Worksheet for purchasing process.

2, Go to Requisition Worksheets

Select "Calculate Plan"

3, Fill the information for the requisition worksheet to calculate the worksheets line in order to carry out the plan and create a Purchase Order.

(1) Starting Date & Ending Date - the date range of the goods it expected to receive.  

The date range filter to according to the "Supplier ETA Date) in Sales Order Line.

(2) Item Information.

*User can specify the Item by input the Item Brand or Item No., Danger Goods, Items it has specific Licenses or Regulation.


Click "OK" if done.

4, The requisition worksheet lines will show the quantity (according to the Sales Line) & price (according to the purchase line list)

Click "Carry Out Action Message" to create a Purchase Order by gathering these line.

5, After creating, the Requisition Worksheet will be blank and all lines will be removed.

Uut from the Requisition Worksheet and search "Purchase Order" to find the latest PO created.

The system will recalculate the total quantity and revise the price & discount in the Purchase Line.

System will based on the total quantity to set a default unit cost & line discount according to the Purchase Price List.

Therefore, the Purchase Order shows $2000 instead of $2400/unit. And will have 5% line discount.

If users adjusted / removed some Purchase Line, the price & discount will be adjusted by system automatically.

E.g. The pictures show that user add an additional line for 200QTY therefore total >= 1000. Cost will be automaticallyu adjusted to $2000 and 5% line discount is granted.






When users removed the line, they need to click "Recalculate Price" otherwise the price & discount will not be updated.






After recalculated, correct price & discount will be shown.


*Please be aware that the "Reserved Quantity" to be auto-updated if reducing the order quantity but not increasing.

*User can click the "Recalculate Price" button to reset the adjustment (if have adjusted the price / line discount by users)

  • No labels