[Easy to fly] The latest price of the specified condition

Demand:

Leading department	Suppliers	Product number	Name	Specifications	Actual Unit Price	Original Unit Price	Purchase Quantity	Price Variance	Amount difference
Nuclear price single-header custom field purtl.udf01

Description

1. Supplier, product number, name, specification, actual unit price, purchase quantity to take the data of purchasing order

2. Original unit Price = original unit price in the current effective date of the nuclear price list

3. Price difference = Actual Unit Price-original unit price

4. Amount difference = Price difference * Purchase Quantity

An example is provided:

March 16 A purchase record: Supplier A, a purchase quantity 500, the purchase price 5 yuan, the purchase amount =500*5=2500 yuan

Condition 1: February 15 has a nuclear price list, supplier A, a nuclear price is 4 yuan, the original unit price is 6 yuan Effective date is February 15.

Result 1:

Suppliers	Product number	Name	Specifications	Actual Unit Price	Original Unit Price	Purchase Quantity	Price Variance	Amount difference
A	A			5	6	500	-1	-500

Condition 2:

February 15, a nuclear price list, supplier A, a nuclear price is 4 yuan, the original unit price is 6 yuan Effective date is February 15.

March 15, a nuclear price list, supplier A, a nuclear price is 5 yuan, the original unit price is 4 yuan Effective date is March 15.

Result 2:

Vendor	Product no	Name	Specification / td>	Actual price	Original price	Purchase quantity	Price difference	amount difference
A	A			5