Relationship between purchase, purchase, return, sales, return, and cost

 

Relationship between purchase, purchase, return, sales, return, and cost

 

Business \ Parameters	Cost	Same price	Warehouse receiving/picking
Procurement	Modify	Modify	Warehouse receiving
Purchase and return	Do not modify	Modify + "original cost" Field	Warehouse picking
Sales	Do not modify	Modify	Warehouse picking
Sales return	Modify	Modify	Warehouse receiving

 

Data Testing

 

Purchasing the same type of product

Business \ Parameters	Warehouse	Warehouse B	A Cost	B Cost	Same price	Quantity
Original	0	0	0	0	0	0
Procurement	10*$100	10*$300	$100 (10)	$300 (10)	$ (200)	20
Procurement	10*$200	-----------	$150 (20)	$300 (10)	$200	30
Purchase and return	10*$100	-----------	$150 (10)	$300 (10)	$225	20
Sales	5*$200	-----------	$150 (5)	$300 (10)	$250	15
Sales return	5*$200	-----------	$175 (10)	$300 (10)	$237.5	20

 

Warehouse picking/warehouse receiving

warehouse picking	purchase return	spare parts sales	spares report loss	spare parts forwarding	spare parts merging	spare parts lending (** not counted as Warehouse picking **)
warehouse receiving	purchasing spare parts	sales return	--------	spare parts forwarding	spare parts merging	repair of bad parts (into the repair warehouse)