Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0033026Openbravo ERP09. Financial managementpublic2016-05-23 13:102016-05-23 15:16
psanjuan 
Triage Omni OMS 
urgentmajoralways
newopen 
20Professional Appliance
 
 
Advanced Payables and Receivables Mngmt
No
0033026: Outstanding amount pending to be settle in the order while booking a prepayment
Outstanding amount pending to be settle in the order while booking a prepayment
Create a sales order for F&B EspaƱa, Alimentos BP.
Set it as Invoice Terms = Inmediate
Create a line for any product by entering a net unit price = 1.00, ordered quantity = 200, and select any exempt tax.
Remove basic discount if any.
Book the order.
Total Gross Amount = Total Net Amount = 200.00

Add a pre-payment for the order for an amount = 150.00.
Check that sales order payment plan shows below information:
Expected Amount = 200.00
Received Amount = 150.00
Outstanding Amount = 50.00

Go to sales invoice and create a new one by using the option "Create Lines From". Select the full order (200.00)

Go to lines an enter a negative line for any product.
Set net unit price = 1.00. Invoiced quantity = -50 and select any exempt tax.
Complete the invoice.
Total Gross Amount = Total Net Amount = 150.00.

Check that there is a prepayment = 150.00
Check that the Invoice payment plan shows below information:
Expected Amount = 150.00
Received Amount = 150.00
Outstanding Amount = 0.00
which is OK, the invoice is set to Payment Complete = Yes

Go back now to the order and add another payment for 50.00.
Check that order payment plan shows now below information:
Expected Amt= 200.00
Received Amt = 200.00
Outstanding Amt = 0.00

Go back to the order and check that it is not set as payment complete = Yes, there is a remaining amount left to be paid = -50.00

Invoice Payment plan has changed as below:
Expected Amt= 150.00
Received Amt = 200.00
Outstanding Amt = -50.00


same behavior for negative order/invoice and in case the payment is entered once the invoice has been booked.
To be researched but:

Order payment details currently are:
After pre-Payment 1 = 150.00
Expected = 200.00
Received = 150.00

After Payment 2 = 50.00 (booked in the order, once invoice has been created and it is fully paid)
line 1 Expected = 150.00 Received = 150.00
line 2 Expected = 150.00 Received = 50.00

while it should be:
Payment 1 = 150.00
Expected = 200.00
Received = 200.00
therefore after payment 1 there is not a pending amount to be paid for the order as it has been fully included in an invoice that is already paid.
No tags attached.
related to defect 0032914 closed aferraz Wrong payment status as well payment in details when partially paying a Reversed Sales Invoice 
? Payment_Details_Issue32914.ods (49,272) 2016-05-23 15:15
https://issues.openbravo.com/file_download.php?file_id=9436&type=bug
Issue History
2016-05-23 13:10psanjuanNew Issue
2016-05-23 13:10psanjuanAssigned To => Triage Finance
2016-05-23 13:10psanjuanModules => Advanced Payables and Receivables Mngmt
2016-05-23 13:10psanjuanTriggers an Emergency Pack => No
2016-05-23 15:04psanjuanSummarytbd => Outstanding amount pending to be settle in the order while booking a prepayment
2016-05-23 15:04psanjuanDescription Updatedbug_revision_view_page.php?rev_id=12206#r12206
2016-05-23 15:04psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12208#r12208
2016-05-23 15:14psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12209#r12209
2016-05-23 15:14psanjuanProposed Solution updated
2016-05-23 15:14psanjuanRelationship addedrelated to 0032914
2016-05-23 15:15psanjuanNote Added: 0086667
2016-05-23 15:15psanjuanFile Added: Payment_Details_Issue32914.ods
2016-05-23 15:16psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12210#r12210

Notes
(0086667)
psanjuan   
2016-05-23 15:15   
See excel sheet attached. Same behavior but opposite for negative order/invoices.