0033026: Outstanding amount pending to be settle in the order while booking a prepayment

Description

Outstanding amount pending to be settle in the order while booking a prepayment

Steps To Reproduce

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.

Proposed Solution

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.

Tags

No tags attached.

Attached Files

Payment_Details_Issue32914.ods [^] (49,272 bytes) 2016-05-23 15:15

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0032914

closed

aferraz

Wrong payment status as well payment in details when partially paying a Reversed Sales Invoice

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

Issue History
Date Modified	Username	Field	Change
2016-05-23 13:10	psanjuan	New Issue
2016-05-23 13:10	psanjuan	Assigned To	=> Triage Finance
2016-05-23 13:10	psanjuan	Modules	=> Advanced Payables and Receivables Mngmt
2016-05-23 13:10	psanjuan	Triggers an Emergency Pack	=> No
2016-05-23 15:04	psanjuan	Summary	tbd => Outstanding amount pending to be settle in the order while booking a prepayment
2016-05-23 15:04	psanjuan	Description Updated	View Revisions
2016-05-23 15:04	psanjuan	Steps to Reproduce Updated	View Revisions
2016-05-23 15:14	psanjuan	Steps to Reproduce Updated	View Revisions
2016-05-23 15:14	psanjuan	Proposed Solution updated
2016-05-23 15:14	psanjuan	Relationship added	related to 0032914
2016-05-23 15:15	psanjuan	Note Added: 0086667
2016-05-23 15:15	psanjuan	File Added: Payment_Details_Issue32914.ods
2016-05-23 15:16	psanjuan	Steps to Reproduce Updated	View Revisions