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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027705
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 03. Procurement managementmajoralways2014-09-29 12:322017-11-14 11:47
ReporterpsanjuanView Statuspublic 
Assigned Tononofrancisco 
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

0027705: No matched invoice in case of booking an invoice prior to the receipt

DescriptionNo matched invoice in case of booking an invoice prior to the receipt
Steps To ReproduceGo to purchase order and create a new order by entering below data:

Organization: F&B Us
BP: Be Soft Drinker
Date: 29/09/2014
Product: Cherry Cola
Ordered Quantity: 1000

Book the order. Let say order number is 1000110

Go to purchase invoice and create a new invoice dated on 30/09/2014 for F&B US and Be Soft Drinker BP. Use the process button "Create lines from" and select the order 1000110.

Complete and post the invoice. Let say invoice number is 10000563.

Go to Goods Receipts window and create a new receipt dated on 10/10/2014 (movement date) for F&B US and Be Soft Drinker BP. Use the process button "Create Lines From" and select the order 1000110. Select the line and receive only 80 units. Enter a Storage Bin. Press OK.
Complete and Post the receipt.
Posting would look like:
Debit: Inventory Asset 44 (80 units *0,55 )
Credit: Goods Received and not invoiced 44

Go to Goods Receipt window and create a new receipt dated on 20/10/2014 (movement date). Use the process button "Create Lines From" and select the order 1000110. Select the line and receive remaining 920 units. Enter a Storage Bin. Press OK.
Complete and Post the receipt.
Posting would look like:
Debit: Inventory Asset 506 (920 units *0,55 )
Credit: Goods Received and not invoiced 506

Go to goods receipts window and create a new receipt dated on 25/10/2014 (movement date). Use the process button "Create Lines From". This time select the invoice 10000563.

Realize that a quantity of 920 unit remains pending to be received. See image attached.


Proposed SolutionReceipts created from the order should be linked to the invoice, if the invoice is linked to the order. Therefore in our example there is nothing pending to be received.
TagsNo tags attached.
Attached Filespng file icon issue_27705.png [^] (28,229 bytes) 2014-09-29 12:53

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0031313 closedTriage Omni OMS Matched Invoice records are created in the Create Lines process (selecting order lines) but not in Pending Goods Receipt process 

-  Notes
(0100510)
dmiguelez (developer)
2017-11-14 11:47

 Moved to design defect:

We have M_InOutLine_ID reference in C_InvoiceLine which can hold information for a single Goods Receipt Line only. In the scenario reported we have multiple M_InoutLine_ID for a single C_InvoiceLine_ID. At the time of first partial Goods Receipt we mark Invoice Line ID with first M_InoutLine Reference and only for this record Match Invoice record is created and other are skipped.

Fixing this issue would require a deep refactor in the code and in the way to store the relationships between invoice lines and shipment lines.

Moved to design defect.


While trying to fix this Issue, several solutions were proposed, but nono of them was correct, also, some things were noted:

* Proposal: Create the MatchInvoice in the CreateFrom process. This is not correct. The MatchInvoice shold be created when completing the Document.
  If it is created with the process, it might happen that the user changes the data of the Goods Receipt Line before completing the Document.
  In this case the MatchInvoice record does not reflect the changes
* Note: CreateFrom_Shipment_data.xsql. Query updateInvoiceOrder. This is not correct
  Example: Create a Purchase Order of 5 Units. Create two Purchase Invoices of 3 and 2 units against the Purchase Order. Both Invoice Lines are related to the Order Line.
           Create a Goods Receipt of 1 unit. Following the logic of the query, this reception line is linked to both Invoice Lines. That is not correct.
           Also, it does not fully complete either line, so it is not possible to create a new relationshipt again

- Issue History
Date Modified Username Field Change
2014-09-29 12:32 psanjuan New Issue
2014-09-29 12:32 psanjuan Assigned To => dmiguelez
2014-09-29 12:32 psanjuan Modules => Core
2014-09-29 12:32 psanjuan Triggers an Emergency Pack => No
2014-09-29 12:39 psanjuan Steps to Reproduce Updated View Revisions
2014-09-29 12:53 psanjuan Steps to Reproduce Updated View Revisions
2014-09-29 12:53 psanjuan Proposed Solution updated
2014-09-29 12:53 psanjuan File Added: issue_27705.png
2014-09-29 12:54 psanjuan Proposed Solution updated
2015-10-30 13:11 ngarcia Relationship added related to 0031313
2017-11-10 10:17 ngarcia Resolution time => 1512082800
2017-11-10 10:17 ngarcia Issue Monitored: networkb
2017-11-10 10:18 ngarcia Assigned To dmiguelez => Triage Finance
2017-11-10 11:00 ngarcia Resolution time 1512082800 =>
2017-11-10 13:15 dmiguelez Assigned To Triage Finance => nonofrancisco
2017-11-14 11:47 dmiguelez Note Added: 0100510
2017-11-14 11:47 dmiguelez Type defect => design defect

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker