Openbravo Issue Tracking System - Openbravo ERP
Then a Payment is made to that order, and then canceled.
When creating a Sales Invoice from that order, a positive Payment Schedule Detail line is created in the database, wich is not supposed to happen.
Go to Sales Management || Transactions || Sales order:
Click New and select:
“Business Partner”: Type CUSA and press enter key. Customer A should be showed instead.
“Transaction Document”: Standard Order
“Payment Method”: 2.1 (Spain)
“Payment Terms”: 90 days
“Invoice Terms”: Immediate
Move to Lines. Click new and select:
“Product”: Type FGA and press enter key. Final good A should be showed instead.
“Order Quantity”: - 500
Click the “Book” button. Click OK.
Partial Payment of one Order
Go to Financial Management || Receivables & Payables || Transactions || Payment In:
Click New and select:
“Received From”: Type CUSA and press enter key. Customer A should be showed instead.
“Payment Method”: 2.1 (Spain)
“Amount”: -200.00
Then click the “Add Details” button.
In the pop-up select:
“Transaction Type”: Orders
And then make sure that the line with:
“Sales Order No.”: The order created before.
Click the “Process” button and then OK.
Click on the “Reactivate” button. In the selector box select “Void” and click OK.
Create the Sales invoice.
Go to Sales Management || Transactions || Sales invoice:
Click New and select:
“Business Partner”: Type CUSA and press enter key. Customer A should be showed instead.
“Payment Method”: 2.1 (Spain)
“Payment Terms”: 90 days
Click on the button “Create Lines From”:
In the order combo box select the order created before.
Mark all the records that appear in the grid and press OK.
Click the “Complete” button. Click OK.
A wrong Payment Schedule Detail is created in the database.
This query can help to watch it:
SELECT PSD.FIN_PAYMENT_SCHEDULEDETAIL_ID, PSD.CREATED, PSD.UPDATED, PSD.AMOUNT, PS.AMOUNT, PSD.ISCANCELED
FROM FIN_PAYMENT_SCHEDULEDETAIL PSD LEFT JOIN FIN_PAYMENT_SCHEDULE PS ON PS.FIN_PAYMENT_SCHEDULE_ID=PSD.FIN_PAYMENT_SCHEDULE_INVOICE
WHERE PS.C_INVOICE_ID = (
SELECT C_INVOICE_ID
FROM C_INVOICE
WHERE DOCUMENTNO LIKE '[InvoiceDocNo]'
)
AND PSD.ISCANCELED <> 'Y'
;
A line with +200.00 appears and it should have not existed in the first place.
One consecuence of this is:
Go to Sales Financial Management || Receivables & Payables || Transactions || Payment In:
Click New and select:
“Received From”: Type CUSA and press enter key. Customer A should be showed instead.
“Payment Method”: 2.1 (Spain)
“Amount”: -200.00
Then click the “Add Details” button.
In the pop-up select:
“Transaction Type”: Invoices
And then make sure that the line with:
“Sales Invoice No.”: The invoice created before.
Click the “Process” button and then OK.
Click on the “Reactivate” button. In the selector box select “Void” and click OK.
An error appears, it can be watched in the screenshot attached.
Pantallazo-4.png (96,439) 2012-03-06 16:33https://issues.openbravo.com/file_download.php?file_id=5059&type=bug