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 ?
F.
51 05/02/2022 03:59:19 pm
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
52 04/30/2022 12:09:56 pm
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
Leads to new problems - new screenshots added 'after_new_corrections_' in https://cloud.fiftyonetielt.be/index.php/s/Agnmt3Arm59Y2JW
F.
53 04/30/2022 09:09:50 am
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
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))
F.
54 04/29/2022 04:43:18 pm
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
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.
55 04/29/2022 07:22:04 am
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
That would be great ! Thanks for the efforts !
F.
56 04/29/2022 12:50:07 am
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
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.
57 04/28/2022 06:35:03 pm
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
Wrong 'Charges' also in /sales/inquiry/customer_inquiry.php? (Heading)
F.
58 04/28/2022 06:07:25 pm
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
AND in every case (reports 101, 102, 108 and 115), when an invoice is made against the partial prepayment, not the amount of the invoice, but the amount of the whole order gets debeted in the balance !
This is very wrong !
F.
59 04/28/2022 03:52:40 pm
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
Ok, i understand, for every (partial) payment it is possible to make a (partial) salesinvoice.
But that leeds me to another problem : payments are not viewed in /sales/inquiry/sales_orders_view.php?PrepaidOrders=Yes
So, you can't see witch rows have (partial) payments ... ALL prepayment-orders are presented, even when no payment(s) are booked ...
How can you know witch rows have to be invoiced ?
F.
60 04/28/2022 02:46:48 pm
Re: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
Of course, but what if de prepayment-order is only partialy paid ? Only when de prepayment-order is fully paid, i will make the delivery and the salesinvoice ...
I agree that prepayment-orders should not be there in balances, but allocated prepayments against prepayment-orders should not be there too (and now they are, resulting in wrong balances).
F.
61 04/26/2022 06:45:12 pm
Topic: reports 101, 102, 108, 115 and PREpayments (22 replies, posted in Report Bugs here)
Hi,
Allocated PREpayments are in SQL-selections of reports 101, 102, 108 and 115, but the (partial) prepaid prepayment-ORDER is NOT.
This gives wrong balances and 'wrong' total credit-amounts in these reports (more credit than debit).
I think its better not to have allocated PREpayments in these SQL-selections, but if they are, the prepayment-ORDER should be there too.
F.
62 04/22/2022 07:41:49 am
Re: Select deliveries on dimensions (4 replies, posted in Dimensions)
Deliveries don't have GL-bookings and the intention is to batch deliveries in an invoice, but only select the deliveries of a dimension.
F.
63 04/16/2022 06:59:55 am
Re: email invoice always says invoice 0 from company (7 replies, posted in Accounts Receivable)
I had the same problem en changed the '%d' by '%s'.
F.
64 04/11/2022 09:11:41 am
Re: Journal Entry - Cursor skips through dimension field (5 replies, posted in Report Bugs here)
Hi,
In version 2.4.11 and when using Chrome, i don't have that skipping cursor, but i agree, once enabled, dimensions should be made 'mandatory' (so you can't skip it).
Regards
F.
65 04/09/2022 08:01:47 pm
Topic: Coding bug in inventory_db.inc (1 replies, posted in Report Bugs here)
line : $subject = _("Stocks below Re-Order Level at " . $loc['location_name']);
Should be : $subject = _("Stocks below Re-Order Level at ") . $loc['location_name'];
Otherwise translation won't work.
F.
66 04/07/2022 05:46:41 pm
Topic: Ref of contact isn't copied to the delivery- or invoicedetails (0 replies, posted in Report Bugs here)
Hi,
The information from contacts, as name, address, phone, shippingcompany, is copied to the details of a order, delivery or invoice, but the (default)contactreference is not.
F.
67 04/07/2022 05:23:08 pm
Re: How to use TIME as a quantity for items ? (4 replies, posted in Items and Inventory)
Ofcourse, but that is not so nice.
It seems to me in this case an item should have two qty's (and two prices too), one for hours en one for minutes (with a ':' in between would be nice).
Timemeasurement is not exotic, is it ?
Any hope this will hapen in coredevelopment ?
Thanks,
F.
68 04/04/2022 02:47:47 pm
Topic: How to use TIME as a quantity for items ? (4 replies, posted in Items and Inventory)
Hi,
I want to 'sell' items by timeduration, eg 1 hour and 22 minutes of work (1:22).
How do i do that ?
thanks,
F.
69 04/01/2022 11:22:50 pm
Topic: Select deliveries on dimensions (4 replies, posted in Dimensions)
Hi,
Deliveries have dimensions, but how can i select deliveries on dimension(s) in sales_deliveries_view.php (and batch-invoice them/customer) ?
So, i just want to search for deliveries per dimension.
Could somebody share some code ?
Thanks,
F.
70 03/24/2022 07:08:33 am
Re: Bank account transfers don't have dimensions (5 replies, posted in Report Bugs here)
Tested and seems to be solved !
Thanks Joe,
F.
71 03/22/2022 08:35:16 pm
Re: Bank account transfers don't have dimensions (5 replies, posted in Report Bugs here)
Ofcourse Joe I use Journal Entries (and Quick Entries) for bankaccounttransfers now.
In the meantime, a warning should be made in place for other users using dimensions NOT to use the 'Bank account transfers'-link for booking banktransfers as this results in bad values on Banking GL accounts if selections are made on dimensions in reports/balances.
Thanks for your efforts !
F.
72 03/20/2022 11:16:13 am
Topic: Bank account transfers don't have dimensions (5 replies, posted in Report Bugs here)
Hi,
Don't know if this is realy a bug, but 'Bank account transfers' should have dimensions.
Now, as 'Bank account transfers' have no dimensions, al selections on dimensions in reports/balances gives wrong values on Banking GL accounts.
F.
73 03/15/2022 08:51:45 pm
Topic: Top 5 dimensions is not sorted right (1 replies, posted in Report Bugs here)
Screenshot shows it all :
https://cloud.fiftyonetielt.be/index.php/s/GXY4cgTJ4AnBxkA
F.
74 03/15/2022 07:36:21 pm
Re: SalesDashboard Aging total =/= Aged Costumer Analisys (4 replies, posted in Report Bugs here)
Thanks Joe, but now i see another problem : the 'Total Customers Aged Analysis'-graph in SalesDashboard now shows the values if allocated entries are shown. Before, the values were these without allocated shown. Could that be changed ?
Idem dito for the 'Total Suppliers Aged Analysis'-graph. Values should be without allocated entries.
75 03/14/2022 07:32:07 pm
Topic: SalesDashboard Aging total =/= Aged Costumer Analisys (4 replies, posted in Report Bugs here)
Screenshot says it all :
https://cloud.fiftyonetielt.be/index.php/s/oWKGgN3Z7D4YHfT
I think it has something to do with memorial bookings/journal entries.
F.