FrontAccounting forum — reports 101, 102, 108, 115 and PREpayments

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (itronics) — Wed, 22 Jun 2022 19:31:50 +0000

After additional patch bugs seems to be finally fixed.
Thanks for cooperation on fixing the problems.
J.

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (advocaat.pollet) — Thu, 02 Jun 2022 08:49:23 +0000

Dear Itronics,

May I bring this bug back to your attention ?

Especially report 108 is of interest (statements).

However, not only reports are affected by this bug, but also Dashboard Sales and Customer_Inquiry. Also not only prepayments are affected (also totals and aging, in general).

Thanks !

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (advocaat.pollet) — Sat, 14 May 2022 17:52:43 +0000

Hi Itronics,

You can find new screenshots in : https://cloud.fiftyonetielt.be/index.php/s/Gy8ZQ8Kr47rnozE

Rep101 is OK
Rep102 without allocations is OK
Rep102 with allocations is not OK
Rep108 without allocations is not OK : the amount of the prepayment invoice = the amount of the prepayment order (850), but there is only a prepayment-invoice of 250 = partial payment. But totals are correct.
Rep108 with allocations is not OK : idem + Totals are not correct.
Rep115 is OK

Kind regards,
F.

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (itronics) — Thu, 12 May 2022 10:49:23 +0000

Further fixes to this issue are in FA repo.

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (itronics) — Tue, 03 May 2022 09:25:40 +0000

Hi,
Yes, I can confirm there are further changes needed to fix all the issues. This will take me some time, I need to rewrite rep115 code, which is highly unreadable. When I'm ready, I will push the changes to repo, and will send notice here with test request, or just contact you by pm.
J.

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (advocaat.pollet) — Mon, 02 May 2022 15:59:19 +0000

Hi Itronics

Added some more screenshots in link https://cloud.fiftyonetielt.be/index.php/s/Agnmt3Arm59Y2JW

Rep101 gives correct values and totals.

How can I give you some more help to debug this ?

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (advocaat.pollet) — Sat, 30 Apr 2022 12:09:56 +0000

Leads to new problems - new screenshots added 'after_new_corrections_' in https://cloud.fiftyonetielt.be/index.php/s/Agnmt3Arm59Y2JW

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (itronics) — Sat, 30 Apr 2022 11:28:47 +0000

Right, additional fixes has been added. Hope totals works properly now.
Thanks.
J.

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (advocaat.pollet) — Sat, 30 Apr 2022 09:09:50 +0000

rep101 is ok, rep102, 108, 115 are not.

Grand Total is sum over all GL history, including opening balance for selected customer.
Is this the case?

Grand Total in 102 (see screenshots) is the GL history + (Amount of Prepayment-ORDER (850) - Invoiced prepayment (250))

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (itronics) — Sat, 30 Apr 2022 08:31:43 +0000

I'm not sure I understand, let's focus on rep101.
Prepayment order should not be included in this report, only lines for sales invoice (250) and customer payment (250). So, if you have any sum in grand total (600) this should be equal to beginning balance for this customer.
Grand Total is sum over all GL history, including opening balance for selected customer.
Is this the case?
J.

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (advocaat.pollet) — Fri, 29 Apr 2022 16:43:18 +0000

Hi J.,

I made the changes on my installation. This is what I experience :

rep102 : prepaymentorder = 850, payment = 250, invoice = 250 => 600 (850-250) in Grand Total

rep115 : also 600 (850-250) in balance (same customer)

rep108 : if option 'show alloc' is on, also 600 (850-250) in totals due (same customer)

Screenshots :

https://cloud.fiftyonetielt.be/index.php/s/Agnmt3Arm59Y2JW

The extra column on Invoice Prepaid Orders page, 'displaying customer payments allocated but not invoiced yet', works very well !

Thanks,
F.

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (itronics) — Fri, 29 Apr 2022 13:30:57 +0000

Discussed fixes have been pushed to source repo here and here.

Thank you very much for pointing the problem out
J.

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (advocaat.pollet) — Fri, 29 Apr 2022 07:22:04 +0000

That would be great ! Thanks for the efforts !

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (itronics) — Fri, 29 Apr 2022 06:07:34 +0000

Yes, I think so, if this would make prepayments handling easier, why not.
We can add another column on Invoice Prepaid Orders page, displaying customer payments allocated but not invoiced yet (ie content displayed later on Final/Prepayment Invoice form field).

Re: reports 101, 102, 108, 115 and PREpayments

null@example.com (advocaat.pollet) — Fri, 29 Apr 2022 00:50:07 +0000

Hi Itronics,

In 'Invoice Prepaid Orders' fully invoiced orders do not have link for invoicing. You can consider such an order as closed/ fully processed.
On the other hand all not fully processed orders have link to invoicing, and this is ok, because two cases are supported here:
. when you have any customer payments allocated to prepayment order, but not yet invoiced - you can issue prepayment invoice for this payment;
. if you have no customer payment allocated to this order, you can still issue final invoice, changing payment terms for still unpaid part of order, changing payment terms to e.g. delayed payment.
Those two situations are clear when you click on invoicing link: the final invoice have empty 'Payments received' info field (see also invoicing page title which mention both Prepayment and Final invoices).

This is exactly what i meant. You have to click the invoicelink/icon to see if a prepayment is made. If you have a lot of prepayment-orders, that's alot of clicking just to see if a prepayment is made ...

Is it possible to see the prepayments in the rows before clicking the invoicelink/icon ?

Kind regards,
F.