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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027509
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2014-08-29 14:182014-10-02 08:54
ReporterpsanjuanView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision72175c27ab99
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

0027509: Matched Invoice posting is not correct if the purchase invoice is posted prior to the good receipt/s

DescriptionMatched Invoice posting is not correct if the purchase invoice is posted prior to the good receipt/s
Steps To ReproduceIn F&B International Group Client, navigate to Product window.
Create a new record and set:
Organization F&B US. Product Name "Costing A". Tax Category: Exempt.
Navigate to Price window, select "Be Soft Drinker Price List" and enter 25 as Unit and List prices.

Navigate to Purchase Order window and create a new record. Order date: 27/08/2014. Organization: F&B US
BP: Be Soft Drinker. Navigate to Lines and select Costing D product, enter 580 as ordered quantity. Book the order.

Navigate to Purchase Invoice window and create a new record. Invoice date and Accounting date: 30/08/2014. Enter Be soft Drinker BP and press "Create Lines From" button, select the order above.
Complete and Post the invoice. Posting would look like:

14.500 product expense - Account Payables 14.500 (580 * 25)

Navigate to Goods Receipt window and create a new record. Select F&B US organization and Be Soft..business partner.
Movement date/Accounting Date: 02/09/2014. Press the button Create Lines From. Select the order and in the field quantity modify to 80. Enter a Storage Bin. and press OK.
Complete.

Run the costing background process so this transaction is cost calculated therefore it can be post.
Post the receipt. Posting would look like:

2.000 Product Asset - Goods Receipt not invoiced 2.000 (80*25)

Navigate to Matched Invoices window and search by product: Costing D. Post the transaction. Posting would look like:

2.000 Goods Receipt not invoiced
12.500 Invoice Price difference - Product Expense 14.500

Above posting is not ok as it takes by granted that all units have been included in the Goods Receipt and that is not the case.








Proposed SolutionCorrect posting should be:

2.000 Goods Receipt not invoiced - Product Expense 2.000

Rest of goods receipts should also be related to the invoice, therefore every time that a new receipt is completed and post the corresponding posting is properly done.

Above can be done if the new goods receipt is created by using the process button "Create Lines From" and then selecting the Invoice.

In our example new goods receipt posting would look like:

12.500 Product asset - Goods Receipt and not invoiced 12.500

In our example if we navigate once again to the Matched Invoices window, we will realize that there is a new transaction for Costing A product. Posting looks like:

12.500 Goods receipt not invoiced
2.000 price difference - product expense 14.500

Once more above posting is not correct.

Correct one should be:

12.500 Goods Receipt not invoiced - Product Expense 12.500
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0070627)
hgbot (developer)
2014-10-01 18:45

 Repository: erp/devel/pi
Changeset: 72175c27ab9942c791e98e92eff97b9810dfb667
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Sep 25 10:19:09 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/72175c27ab9942c791e98e92eff97b9810dfb667 [^]

Fixes bug 27509: Matched Invoice posting is not correct...

---
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv.java
---
(0070646)
psanjuan (manager)
2014-10-02 08:54
edited on: 2014-10-02 08:56

 fixed and working.

Please see document attached

https://docs.google.com/a/openbravo.com/spreadsheets/d/1Ilm1oct0vH4iKFlI1I0VbmYM-r8fdo1moK02jd2Zigg/edit#gid=1025660841 [^]

Products:
Costing DDD
Costing V91

- Issue History
Date Modified Username Field Change
2014-08-29 14:18 psanjuan New Issue
2014-08-29 14:18 psanjuan Assigned To => dmiguelez
2014-08-29 14:18 psanjuan Modules => Core
2014-08-29 14:18 psanjuan Triggers an Emergency Pack => No
2014-08-29 14:35 psanjuan Steps to Reproduce Updated View Revisions
2014-08-29 14:36 psanjuan Steps to Reproduce Updated View Revisions
2014-08-29 14:39 psanjuan Steps to Reproduce Updated View Revisions
2014-08-29 14:39 psanjuan Proposed Solution updated
2014-08-29 14:47 psanjuan Steps to Reproduce Updated View Revisions
2014-08-29 14:47 psanjuan Proposed Solution updated
2014-08-29 14:51 psanjuan Proposed Solution updated
2014-08-29 14:53 psanjuan Proposed Solution updated
2014-08-29 14:55 psanjuan Steps to Reproduce Updated View Revisions
2014-08-29 14:55 psanjuan Proposed Solution updated
2014-08-29 14:58 psanjuan Proposed Solution updated
2014-08-29 14:59 psanjuan Proposed Solution updated
2014-08-29 15:00 psanjuan Proposed Solution updated
2014-10-01 18:45 hgbot Checkin
2014-10-01 18:45 hgbot Note Added: 0070627
2014-10-01 18:45 hgbot Status new => resolved
2014-10-01 18:45 hgbot Resolution open => fixed
2014-10-01 18:45 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/72175c27ab9942c791e98e92eff97b9810dfb667 [^]
2014-10-02 08:54 psanjuan Note Added: 0070646
2014-10-02 08:54 psanjuan Status resolved => closed
2014-10-02 08:56 psanjuan Note Edited: 0070646 View Revisions

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker