Views Reply Votes
Gabriel Camarena
Gabriel
 7
Supplier Schedule order with Supplier Price List using incorrect price
306
3
0 (0 Votes)
Posted: Jun 09, 2017   
Votes
Phill Norrey
Phill
 856
Replied 

Believe it or not the system is working as QAD designed it.  Now that does not mean their logic is correct but it is working as designed.

The part that is missing from your question is what the actual DELIVERY schedule was.

Supplier schedules do not use the receipt quantity to calculate the price of the material.

If a price list is defined for the item (type "p") the supplier schedule will use that price list.  The process uses the quantity on the schedule (5.5.3.3) to determine the cost of the purchase.  The purchase receipt is processed against an effective date.

The program uses the effective date to decide which release (5.5.3.3) should be used.  The release quantity is considered as the quantity to apply as the minimum quantity of the order.

To help explain this further look at the example below.

Let us assume we have a type “P” Price list with three break points:

Min Qty                Price
     10                30.00
     20                20.00
     30                10.00

And we have a released  (5.5.3.1)  schedule as follows:
Date             Quantity      F/P
07/13/17         20.0          P
07/20/17         10.0          P
07/27/17         30.0          P
 
The price of the material depends on both the effective date of the receipt and the schedule quantity.

Materials received during the first week (07/13/17) will cost $20.00 since the expected quantity for the week is twenty units.  Once twenty units have been received, the pricing of the material will be based upon the expected receipts for the next bucked quantity.  Ten units are expected for the second week (07/20/17), therefore all receipts will cost $30.00.  The $30.00 cost will remain in effect until the cumulative received exceeds thirty units.  Once this threshold is passed, the costs for the materials will be based upon the next bucketed demand (30 units), the cost for the units will be $10.00.

Programmatically, the process is handled by comparing the schedule cumulative quantity (schd_cum_qty) and the cumulative quantity received (cumulative quantity plus receipt being processed).  The price table quantity is the first instance whereby the schedule quantity exceeds the receipt quantity.

+1 (1 Vote)
Replied: Jul 05, 2017
Votes
Raymond Chin Kwie Joe
Raymond
 897
Replied 
@Phil. Extensive explanantion, good to know. I wondered if the "What-if" inquiry (1.10.1.13) will also show these numbers, If "yes" then this tool will also help users (inlcuding me) to see which price lists are selected.
0 (0 Votes)
Replied: Sep 04, 2017
Votes
Phill Norrey
Phill
 856
Replied 

Sorry Raymond.  1.10.1.13 will not work.  When QAD added their new pricing system in for S/O (1.10.1.1) they moved the old version to menu 1.10.2.1.  This old version is used for Schedules and Purchasing.  The new version which has the what uses a best pricing formula which is why they have the what if inquiry.

The key difference between them is the PO and schedule price lists link to the order via a price list name.  But the new version uses "nodes" so you can have many different pricelists linked to the same part/customer if you need it.  The biggest disadvantage of the new version is because it always uses best pricing you can sometimes have a difficulty if you have a new customer and you want to charge them a higher price.  If it happens to have the settings in such a way that it can link to another node combination you have to "remove" the lower options manually.

0 (0 Votes)
Replied: Sep 05, 2017
Forums
All
Forum Help
Help Using Forums