Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029728 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | major | always | 2015-04-29 09:15 | 2015-08-20 23:16 | |||
| Reporter | psanjuan | View Status | public | |||||
| Assigned To | aferraz | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | b45cf0559789 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.6 | |||
| OS Version | Ubuntu 8.04.1 | Database version | 11.1.0.6.0 | Ant version | 1.7.0 | |||
| Product Version | SCM revision | |||||||
| Review Assigned To | vmromanos | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029728: Purchase price differences need to be post to a PPV account for products valued at "Standard" cost | |||||||
| Description | Purchase price differences need to be post to a PPV account for products valued at "Standard" cost | |||||||
| 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 | |||||||
| Proposed Solution | In the case of products valued at "Standard" cost: (1) Matched Invoice posting can also point to the "Invoice Price Variance" (please check as it seems there is another account do not shown in the UI, named "Product Price Variance" or something similar), therefore Matched Invoice posting would look like shown below: 500.00 (4090) Non-Invoiced Receipts - Debit 250.00 (XXXX) Invoice Price Variance - Debit 750.00 (6000) Product Expense - Credit (2) Purchase price differences must not trigger any cost adjustment, therefore the amount of the Invoice Price Variance account is not moved to the product asset account. Besides that both the "Total Cost" and the "Unit Cost" of the transaction remains the same as the "Trx Original Cost" (Standard Cost * nº units). | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0078563) psanjuan (manager) 2015-06-29 15:44 |
After running this scenario: (1) Matched invoice posting is as described in the proposed solution above. (2) No Cost adjustment is created (3) However the Total Cost and the Unit Cost of the Vendor Receipt transaction has changed to 750.00. This is not correct as it should be 500.00. Please check. |
|
(0078676) psanjuan (manager) 2015-07-06 14:06 edited on: 2015-07-06 14:14 |
Point (3) above verified it is now workig ok. total cost and unit cost of vendor receipt transaction has not changed. Also verified it is working properly while changing the price in the purchase order. No cost adjustment is created. Product Cost does not change, same as total cost/unit cost of the corresponding transaction. Matched invoice posting correct. |
|
(0078680) hgbot (developer) 2015-07-06 15:56 |
Repository: erp/devel/pi Changeset: b45cf0559789653c61099068e3954a76a3bec0b5 Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> Date: Thu Jul 02 15:12:55 2015 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/b45cf0559789653c61099068e3954a76a3bec0b5 [^] Fixes issue 29729 & Fixes issue 29702 & Fixes issue 29728 Cost Adjustments will not be created in transactions calculated with Standard Algorithm. --- M src/org/openbravo/costing/CostingServer.java M src/org/openbravo/costing/PriceDifferenceProcess.java --- |
|
(0079476) hudsonbot (developer) 2015-08-20 23:16 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8c91718397a5 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-04-29 09:15 | psanjuan | New Issue | |
| 2015-04-29 09:15 | psanjuan | Assigned To | => Triage Finance |
| 2015-04-29 09:15 | psanjuan | Modules | => Core |
| 2015-04-29 09:15 | psanjuan | Triggers an Emergency Pack | => No |
| 2015-04-29 11:51 | psanjuan | Relationship added | related to 0029723 |
| 2015-04-29 12:02 | psanjuan | Relationship added | caused by 0029729 |
| 2015-04-29 12:43 | psanjuan | Summary | [Cost Adjutments] - Purchase price differences must be post to a "PPV" instead of an "Asset" account for Standard Cost. => [Cost Adjutments] - Purchase price differences must be post to a "PPV" acount instead of an "Asset" account for Standard Cost. |
| 2015-04-29 12:43 | psanjuan | Description Updated | View Revisions |
| 2015-04-29 12:43 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2015-04-29 12:43 | psanjuan | Proposed Solution updated | |
| 2015-04-29 12:49 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2015-04-29 12:50 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2015-04-30 14:29 | psanjuan | Summary | [Cost Adjutments] - Purchase price differences must be post to a "PPV" acount instead of an "Asset" account for Standard Cost. => Purchase price differences must not trigger a cost adjustment and need to be posted to a PPV account. |
| 2015-04-30 14:29 | psanjuan | Description Updated | View Revisions |
| 2015-04-30 14:29 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2015-04-30 14:29 | psanjuan | Proposed Solution updated | |
| 2015-04-30 14:30 | psanjuan | Summary | Purchase price differences must not trigger a cost adjustment and need to be posted to a PPV account. => Purchase price differences must not trigger a cost adjustment and need to be post to a PPV account. |
| 2015-04-30 14:30 | psanjuan | Description Updated | View Revisions |
| 2015-04-30 14:33 | psanjuan | Summary | Purchase price differences must not trigger a cost adjustment and need to be post to a PPV account. => Purchase price differences must not trigger a cost adjustment and need to be post to a PPV account for products valued at "Stand |
| 2015-04-30 14:33 | psanjuan | Description Updated | View Revisions |
| 2015-05-04 12:30 | dmitry_mezentsev | Relationship replaced | blocks 0029729 |
| 2015-05-29 14:34 | psanjuan | Proposed Solution updated | |
| 2015-05-29 14:34 | psanjuan | Proposed Solution updated | |
| 2015-05-29 14:48 | psanjuan | Summary | Purchase price differences must not trigger a cost adjustment and need to be post to a PPV account for products valued at "Stand => Purchase price differences need to be post to a PPV account for products valued at "Standard" cost |
| 2015-05-29 14:48 | psanjuan | Description Updated | View Revisions |
| 2015-05-29 14:50 | psanjuan | Proposed Solution updated | |
| 2015-06-11 17:35 | aferraz | Assigned To | Triage Finance => aferraz |
| 2015-06-29 15:44 | psanjuan | Note Added: 0078563 | |
| 2015-07-02 17:09 | aferraz | Steps to Reproduce Updated | View Revisions |
| 2015-07-06 14:06 | psanjuan | Note Added: 0078676 | |
| 2015-07-06 14:14 | psanjuan | Note Edited: 0078676 | View Revisions |
| 2015-07-06 15:47 | vmromanos | Status | new => scheduled |
| 2015-07-06 15:56 | hgbot | Checkin | |
| 2015-07-06 15:56 | hgbot | Note Added: 0078680 | |
| 2015-07-06 15:56 | hgbot | Status | scheduled => resolved |
| 2015-07-06 15:56 | hgbot | Resolution | open => fixed |
| 2015-07-06 15:56 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b45cf0559789653c61099068e3954a76a3bec0b5 [^] |
| 2015-07-06 15:58 | vmromanos | Review Assigned To | => vmromanos |
| 2015-07-06 15:58 | vmromanos | Status | resolved => closed |
| 2015-08-20 23:16 | hudsonbot | Checkin | |
| 2015-08-20 23:16 | hudsonbot | Note Added: 0079476 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |