Prepayment Allocation Issue (Page 1 of 2)

If a dissociation is attempted when the final payment is made, can it then be re-allocated and satisfy the issue?

If you dissociate the payment from the sales order, you cannot make delivery on it.

if you check the following image https://ibb.co/cq9GyQ

it shows the customer balance report for a customer, who bought one item for 1250, using the prepayment method mentioned in this wiki article
https://frontaccounting.com/fawiki/index.php?n=Help.CustomerPaymentEntry?setlang=en

Here is how to produce the bug ..
1- Create a new sales order entry and select  Prepayment payment "in my case the sales order total was 1250$".
2- Using the customer payment, we added the amount of 250$ "the prepaid value"
3- Convert sales order to delivery.
4- prepayment entry --> Final Invoice Entry

Now the payment you make after this wouldn't be subtracted from the outstanding , instead it would show as negative value in allocated.

@joe: any way forward?

Meanwhile, I strongly suggest that people refrain using this feature for now, it is doing strange things after the invoice is made.

Those issues just has been fixed in stable branch:
https://sourceforge.net/p/frontaccounting/git/ci/f11b39846d81bd043490ba9596224b859e47467c/

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

Janusz-

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.

@Dynamic

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.

What are your steps for creating a new prepayment sales from A to Z please ?
maybe i am not doing it the right way.

@Alaa, I was testing with 100% prepayment, there is no bug with that. BUT, your test was with partial prepayment, and you are right, THERE IS A BUG IN THE FINAL INVOICE with partial prepayment. Here is how to duplicate that bug:

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.

@Dynamic
Thanks.. couldn't have said it better myself.

but why would you use prepayment method for Cash sales ?

Has anyone looked into this bug yet? It's still unresolved for partial prepayments.