Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #29728 All Revisions ] Back to Issue ]
Summary 0029728: Purchase price differences need to be post to a PPV account for products valued at "Standard" cost
Revision 2015-07-02 17:09 by aferraz
Steps To Reproduce Work within an Organization that has an "Standard" Costing rule.

Create a product named "Product Price Correction Standard".
Add a purchase price list and enter a purchase price of 100.00 Unit Price=List Price.
Go to Costing tab and enter a new record.
Starting date: 01/01/2015
ending date 31/12/9999
Cost type: Standard
Cost = 100
Manual = Yes

Create a purchase order for this product of 5 units. Book the order.

Go to Goods Receipt window and create a new receipt for the previous order.
Complete it. Run Costing Background. Post it.

Posting looks like:

500 (3500) Product Asset - Debit
500 (4009) Non-Invoiced Receipts - Credit

Go to Goods Shipment window and ship 1 unit of this product. Complete it. Run Costing Background. Post it.

Posting looks like:
100 (9990) Cost of Goods Sold - Debit
100 (3500) Product Asset - Credit

Go to product window, transaction tab and realize that Goods Receipt transaction cost is 500.00. Goods Shipment transaction cost is 100.00.
This is correct.

Go to purchase invoice window and create a new invoice for a vendor by selecting either the order or the receipt previously created.

Navigate to Lines tab and change the price to 150.00. Complete and post the invoice.

Run Costing Background. Run Price Correction.

Navigate to "Matched Invoice" window and realize that a transaction related to this product is created. Post it.

Matched Invoice posting looks like:

500.00 (4090) Non-Invoiced Receipts - Debit
250.00 (9904) Invoice Price Variance - Debit
750.00 (6000) Product Expense - Credit

A purchase price difference cost adjustment is created for the goods receipt of 25 (5 units x 5€/unit). This purchase price difference now is handle as a cost adjustment which can be posted affecting inventory value/accounting of the product which it is not correct, as the "Standard Cost" of the product remains as 100.00 which is correct.

Purchase Price difference adjustment current posting looks like:

250.00 (35000) Product Asset - Debit
205.00 (99904) Invoice Price Difference - Credit.

This is not correct, product asset account should not be used.

Value Stock Report is also not correct because it shows below info:
Product : Product Price Correction Standard
Quantity: 4
Average Cost : 106.25 (525-100/4) - this is not correct. It should be 100.00
Valuation: 425 (106.25*4) - this is not correct. It should be 400.00
See issue 29731



Revision 2015-04-30 14:29 by psanjuan
Steps To Reproduce Work within an Organization that has an "Standard" Costing rule.

Create a product named "Product Price Correction Standard".
Add a purchase price list and enter a purchase price of 100.00 Unit Price=List Price.
Go to Costing tab and enter a new record.
Starting date: 01/01/2015
ending date 31/12/9999
Cost type: Standard
Cost = 100
Manual = Yes

Create a purchase order for this product of 5 units. Book the order.

Go to Goods Receipt window and create a new receipt for the previous order.
Complete it and Post it.

Posting looks like:

500 (3500) Product Asset - Debit
500 (4009) Non-Invoiced Receipts - Credit

Go to Goods Shipment window and ship 1 unit of this product. Complete and Post it.

Posting looks like:
100 (9990) Cost of Goods Sold - Debit
100 (3500) Product Asset - Credit

Go to product window, transaction tab and realize that Goods Receipt transaction cost is 500.00. Goods Shipment transaction cost is 100.00.
This is correct.

Go to purchase invoice window and create a new invoice for a vendor by selecting either the order or the receipt previously created.

Navigate to Lines tab and change the price to 150.00. Complete and post the invoice.

Navigate to "Matched Invoice" window and realize that a transaction related to this product is created. Post it.

Matched Invoice posting looks like:

500.00 (4090) Non-Invoiced Receipts - Debit
250.00 (9904) Invoice Price Variance - Debit
750.00 (6000) Product Expense - Credit

A purchase price difference cost adjustment is created for the goods receipt of 25 (5 units x 5€/unit). This purchase price difference now is handle as a cost adjustment which can be posted affecting inventory value/accounting of the product which it is not correct, as the "Standard Cost" of the product remains as 100.00 which is correct.

Purchase Price difference adjustment current posting looks like:

250.00 (35000) Product Asset - Debit
205.00 (99904) Invoice Price Difference - Credit.

This is not correct, product asset account should not be used.

Value Stock Report is also not correct because it shows below info:
Product : Product Price Correction Standard
Quantity: 4
Average Cost : 106.25 (525-100/4) - this is not correct. It should be 100.00
Valuation: 425 (106.25*4) - this is not correct. It should be 400.00
See issue 29731



Revision 2015-04-29 12:50 by psanjuan
Steps To Reproduce Work within an Organization that has an "Standard" Costing rule.

Create a product named "Product Price Correction Standard".
Add a purchase price list and enter a purchase price of 100.00 Unit Price=List Price.
Go to Costing tab and enter a new record.
Starting date: 01/01/2015
ending date 31/12/9999
Cost type: Standard
Cost = 100
Manual = Permanent = Yes

Create a purchase order for this product of 5 units. Book the order.

Go to Goods Receipt window and create a new receipt for the previous order.
Complete it and Post it.

Go to Goods Shipment window and ship 1 unit of this product. Complete and Post it.

Go to product window, transaction tab and realize that Goods Receipt transaction cost is 500.00. Goods Shipment transaction cost is 100.00.
This is correct.

Go to purchase invoice window and create a new invoice for a vendor by selecting either the order or the receipt previously created.

Navigate to Lines tab and change the price to 105.00. Complete and post the order.

A purchase price difference is created for the goods receipt of 25 (5 units x 5€/unit). This purchase price difference now is handle as a cost adjustment which can be posted affecting inventory value/accounting of the product which it is not correct, as the "Standard Cost" of the product remains as 100.00 which is correct.

Current posting looks like:

25.00 (35000) Product Asset - Debit
25.00 (99904) Invoice Price Difference - Credit.


This is not correct, product asset account should not be used.

Value Stock Report is also not correct because it shows below info:
Product : Product Price Correction Standard
Quantity: 4
Average Cost : 106.25 (525-100/4) - this is not correct. It should be 100.00
Valuation: 425 (106.25*4) - this is not correct. It should be 400.00
See issue 29731



Revision 2015-04-29 12:49 by psanjuan
Steps To Reproduce Work within an Organization that has an "Standard" Costing rule.

Create a product named "Product Price Correction Standard".
Add a purchase price list and enter a purchase price of 100.00 Unit Price=List Price.
Go to Costing tab and enter a new record.
Starting date: 01/01/2015
ending date 31/12/9999
Cost type: Standard
Cost = 100
Manual = Permanent = Yes

Create a purchase order for this product of 5 units. Book the order.

Go to Goods Receipt window and create a new receipt for the previous order.
Complete it and Post it.

Go to Goods Shipment window and ship 1 unit of this product. Complete and Post it.

Go to product window, transaction tab and realize that Goods Receipt transaction cost is 500.00. Goods Shipment transaction cost is 100.00.
This is correct.

Go to purchase invoice window and create a new invoice for a vendor by selecting either the order or the receipt previously created.

Navigate to Lines tab and change the price to 105.00. Complete and post the order.

A purchase price difference is created for the goods receipt of 25 (5 units x 5€/unit). This purchase price difference now is handle as a cost adjustment which can be posted affecting inventory value/accounting of the product which it is not correct, as the "Standard Cost" of the product remains as 100.00 which is correct.

Current posting looks like:

25.00 (35000) Product Asset - Debit
25.00 (99904) Invoice Price Difference - Credit.


This is not correct, product asset account should not be used.

Value Stock Report is also not correct because it shows below info:
Product : Product Price Correction Standard
Quantity: 4
Average Cost : 106.25 (525-100/4) - this is not correct.

See issue 29731



Revision 2015-04-29 12:43 by psanjuan
Steps To Reproduce Work within an Organization that has an "Standard" Costing rule.

Create a product named "Product Price Correction Standard".
Add a purchase price list and enter a purchase price of 100.00 Unit Price=List Price.
Go to Costing tab and enter a new record.
Starting date: 01/01/2015
ending date 31/12/9999
Cost type: Standard
Cost = 100
Manual = Permanent = Yes

Create a purchase order for this product of 5 units. Book the order.

Go to Goods Receipt window and create a new receipt for the previous order.
Complete it and Post it.

Go to Goods Shipment window and ship 1 unit of this product. Complete and Post it.

Go to product window, transaction tab and realize that Goods Receipt transaction cost is 500.00. Goods Shipment transaction cost is 100.00.
This is correct.

Go to purchase invoice window and create a new invoice for a vendor by selecting either the order or the receipt previously created.

Navigate to Lines tab and change the price to 105.00. Complete and post the order.

A purchase price difference is created for the goods receipt of 25 (5 units x 5€/unit). This purchase price difference now is handle as a cost adjustment which can be posted affecting inventory value/accounting of the product which it is not correct, as the "Standard Cost" of the product remains as 100.00 which is correct.

Current posting looks like:

25.00 (35000) Product Asset - Debit
25.00 (99904) Invoice Price Difference - Credit.


This is not correct, product asset account should not be used.


Revision 2015-04-29 11:58 by psanjuan
Steps To Reproduce to be defined


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker