it's still an issue with the reports as shown above
Thanks

We do have a lot of customers where we ask for down payments before we order/ship equipment. Therefore the new updated version of prepayment is working much better for us now. Having said that - there are still issues with the Customer Information (Account Receivable) after&during the transaction.

https://ibb.co/8rqcnfk
https://ibb.co/zs6DywB
https://ibb.co/dQYt0xG

Those are the final reports - after a full transaction.

The initial - PrePayment Invoice is adding the <false> amount to the database!
https://ibb.co/rsCcYmN

instead of 'only showing' $200 -> the complete amount is posted.
This causes all the other reports to show the wrong information.

From a General Ledger point of view - everything works as expected.

I was wondering if someone would be able to fix this issue - then 'prepayment' would work 100%.

Thanks for all your support

but why would you use prepayment method for Cash sales ?

1. Open a sales order with prepayment payment option and populate with items / QTYs.
2. Set "Pre-Payment Required:" to the desired partial amount, then click place order.
3. Go to Sales -> Payments and receive the payment for the order. NOTE: By default, if you click "ALL" it will populate the "This Allocation" field with the payment for the entire order. This is fine if the customer prepays 100%. You will need to manually enter a lower value in "This Allocation" field if they paid less.
4. Click "Add Payment"
5. Sales -> Delivery Against Sales Orders, click on the dispatch arrow on the far right of the order, and "Process dispatch" on the delivery note page.
6. Sales -> Invoice Prepaid Orders. Click the Prepayment Invoice icon on the far right of the order to be invoiced. Next page should be the Prepayment or Final Invoice Entry page, and it will show the original prepayment, which will be the value to be invoiced. Process Invoice. Now view this invoice. It correctly shows the prepayment allocated to it. Now print this invoice. It correctly prints the invoice and shows that this a PREPAYMENT INVOICE, which is ONLY FOR THE VALUE OF THE PREPAYMENT.

Here is the tricky part and where the bug is: You need to issue a final invoice for the remainder of the payment.

7. Sales -> Invoice Prepaid Orders. Click the Prepayment Invoice icon on the far right of the same order as above to be invoiced. By default, the payment terms will still be prepaid. If you attempt to process this invoice, you will get this error: "There are no non-invoiced payments for this order. If you want to issue the final invoice, select delayed or cash payment terms." This is actually correct, now the final invoice cannot be prepaid because the customer will be posted paying. So, select one of the delayed payment terms. Now the magic happens, you will see next to "Invoiced here:" the correct value left to be invoiced. Process this invoice. It should now read "FINAL INVOICE", and will be for the correct balance owed by the customer.
8. Entry customer payment for this invoice ->enter the payment and additional payment.

@ Janusz, this is where the bug comes in. Instead of the final invoice reporting in the customer account as the balance on the invoice, it reports THE ENTIRE INVOICE AMOUNT and makes it look like the customer still owes money.

going to sales -> Allocate Customer Payments or Credit Notes, then check "show settled items" then click on allocate.. doesn't work for me on a new installation.

what works is using Sales -> Customer Allocation Inquiry, select the customer then check the box to show settled items.
after that clicking on the dollar logo would fix the problem.. the customer balance and statement would show the correct value.. but a new problem is created.

The amount that you settled in the Customer Allocation Inquiry will appear as negative value in the Aged Customer Analysis since the customer payment is duplicated for some reason.

Please check your Aged Customer Analysis report.
https://ibb.co/cPsatQ

Though it appears your issue was created by the previous bug. I am not able to duplicate your condition on my system on a new sales order after the fix. However, that account still nets out to zero. Can you print out the statement to verify?

How to reallocate it after the final invoice ??
whenever i do this the outstand value in the customer balance increases when it should show 0.

I have tested it with prepaid customer orders and it works beautifully, the payment becomes allocated automatically to the final invoice. So the fix is only required for the prepaid supplier purchase orders.

That's some good work you've done there, your efforts are appreciated.

Upon further testing, this is what I have found (which may also answer you @Alaa). When you process the prepaid order and invoice it, the payment does not become immediately allocated to the final invoice. HOWEVER, you can re-allocate it to the invoice. There is still a minor bug though: unlike last time where you could not re-allocate it, now you can, but the payment does not show up as unallocated, it actually shows up in the settled items in green (even though it points to nothing). When you select the payment from this list you can allocate it to the invoice.

I request a better fix so that the payment should be automatically allocated to the final invoice. This will settle this matter for good.

Thanks for the fast action,
i just replaced the folders that have been updated with the old ones in my installation...
which means that includes, purchase, sales and lang folders have been updated with the fix..

following the same steps mentioned in post #6, i can confirm that the customer payments made after the final invoice has been issued is appearing in the allocated as it should...

But we got a little problem left..
The total and grand total still show the amount that has been paid by the customer after the final invoice has been issued ..
in short.. the customer payment amount appears under the allocated field but its not calculated in the total and grand total..

please check attached image.
https://ibb.co/mD5oV5

Regarding issue reported in post #11, once prepayment order is partially invoiced, it can no longer be edited. This is because for orders maintained in prepayment mode in fact partial payment is invoiced, not delivery. This is necessary to keep the invoice amount intact during whole payment process till final invoice.
Thank you for reporting the bugs.
Janusz