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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0030430
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajorhave not tried2015-07-27 09:592018-01-19 14:38
ReporterpsanjuanView Statuspublic 
Assigned ToTriage Omni OMS 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0030430: No price correction adjustment is created whenever a receipt is not created from an invoice but from the order related.

DescriptionNo price correction adjustment is created whenever a receipt is not created from an invoice but from the order related, regardless corresponding purchase invoice has a product price change.
Steps To ReproduceIn F&B International, verify that Costing Background process an Price Correction process are both scheduled, and there is a Costing Rule setup for F&B US under "Average" costing method algorithm.

Go to product window and create a new product with below setup:
Organization = F&B US
Search key and Name = A
Product type = Item
Stocked checkbox = selected
Go to price tab and create a new record:
Select "Other services" purchase price list and enter a unit/list price = 25.00

Go to purchase order window and create a new one for F&B US and Product "A" dated on "current date".
Enter 580.00 units of Product A.
Complete and Book the order.

Go to purchase invoice window and create a new one for F&B US dated on "current date" + 3 days.
Use the option "Create Lines From" process button and select the order just created.
Complete and post the invoice.


Go to the Goods Receipt window and create a new one for F&B US dated on "current date" + 6 days.
Use the option "Create Lines From" process button and select the order just created.
Receipt 80 units.

Complete and post the receipt once costing background process has been executed, therefore receipt transaction cost has been already calculated.

Go to product window, search by product "A" and realize that the cost of the transaction (80 units * 25 = 2000) and the cost of the product (25) are calculated.

Go to the purchase invoice window and update the actual price to 20.
For doing that you need to unpost the invoice, reactivate it, change the price to 20 and complete and post once again the invoice. Keep the same invoice accounting date.

Make sure that the purchase price correction has been executed.

Go to product window and realize that the cost of the transaction has been adjusted. There is a cost adjustment line for an amount of -400.

That is correct.

Go now to the Goods Receipt window and create a new one for F&B US dated on "current date" + 6 days.
Use the option "Create Lines From" process button and select the order just created.
Receipt 500 units.

Complete and post the receipt once costing background process has been executed, therefore receipt transaction cost has been already calculated.

Go to product window, costing tab. Realize that the cost of the product has not been recalculated to 20 but to 24.3103345 which is not correct.

Besides that the cost of the second receipt transaction has not been recalculated. No cost adjustment has been created.


On the other hand, if second good receipt is created from the invoice (not from the order) both product cost and transaction cost are correctly calculated as the corresponding cost adjustment is then created.

Proposed SolutionPrice correction cost adjustment should have been created regardless second goods receipt is not created from the invoice but from the order, because finally the invoice related has a price correction.

Actual product cost should have been recalculated to 20
Actual transaction cost should have been recalculated to 2500 = (500*25 -500 *20)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0037275 newnonofrancisco Matched Invoice records for already invoiced order lines are only created the first time except in GR-Create Lines From Invoice 

-  Notes
(0079081)
psanjuan (manager)
2015-07-27 14:06
edited on: 2015-07-27 14:07

 Issue changed to "Defect" and "Procurement Management" Category, because:

- there is only one matched invoice document created for Product "A" that relates 80 units goods receipt with the purchase invoice.

- The creation of the second goods receipt from the order, does not generate a match invoice document that relates goods receipt and invoice, therefore no cost adjustment is created.

Having said that, this is not a cost adjustment related design defect but a defect on the procurement area.
(0101799)
ngarcia (developer)
2018-01-19 14:38

 When a purchase order is already invoiced, the goods receipt should be created from the invoice, that is, using 'Goods Receipt - Create Lines From' process and selecting the invoice, not the order

- Issue History
Date Modified Username Field Change
2015-07-27 09:59 psanjuan New Issue
2015-07-27 09:59 psanjuan Assigned To => Triage Finance
2015-07-27 09:59 psanjuan Modules => Core
2015-07-27 09:59 psanjuan Triggers an Emergency Pack => No
2015-07-27 10:19 psanjuan Steps to Reproduce Updated View Revisions
2015-07-27 10:36 psanjuan Steps to Reproduce Updated View Revisions
2015-07-27 10:51 psanjuan Steps to Reproduce Updated View Revisions
2015-07-27 10:51 psanjuan Proposed Solution updated
2015-07-27 10:53 psanjuan Summary No price correction adjustment is created whenever a receipt is not created from the invoice but the order => No price correction adjustment is created whenever a receipt is not created from the invoice but the order related.
2015-07-27 10:53 psanjuan Description Updated View Revisions
2015-07-27 10:53 psanjuan Steps to Reproduce Updated View Revisions
2015-07-27 11:56 psanjuan Summary No price correction adjustment is created whenever a receipt is not created from the invoice but the order related. => No price correction adjustment is created whenever a receipt is not created from an invoice but from the order related.
2015-07-27 11:56 psanjuan Description Updated View Revisions
2015-07-27 12:01 RenateNieuwkoop Issue Monitored: RenateNieuwkoop
2015-07-27 14:06 psanjuan Note Added: 0079081
2015-07-27 14:06 psanjuan Category 04. Warehouse management => 03. Procurement management
2015-07-27 14:06 psanjuan Type design defect => defect
2015-07-27 14:07 psanjuan Note Edited: 0079081 View Revisions
2017-11-14 13:54 ngarcia Relationship added related to 0037275
2017-11-14 13:55 ngarcia Issue Monitored: ngarcia
2018-01-19 14:38 ngarcia Note Added: 0101799

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker