BUG SUM Auto-fill appgini 5.62

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
facos79
Veteran Member
Posts: 115
Joined: 2014-10-29 12:31

BUG SUM Auto-fill appgini 5.62

Post by facos79 » 2017-09-19 21:11

Goodmorning everyone. I have a problem I can not solve and I think it is due to a bug of appgini. I attach the project.
I have a product table with product description and prices.
Then I have a chart for loading and unloading that select by self-fill the products and the price. In this table, I activated the sum of the column with the price. The sum is incorrect. see attached photo.
Probably it's a bug of appgini. How can I fix it?
Thanks in advance



Buongiorno a tutti. Ho un problema che non riesco a risolvere e penso che sia dovuto ad un bug di appgini. Allego il progetto.
Ho una tabella prodotti con la descrizione dei prodotti e i prezzi.
Poi ho una tabella per il carico e lo scarico che seleziona con auto-fill i prodotti ed il prezzo. In questa tabella ho attivato la somma della colonna con il prezzo. La somma non è corretta. vedi foto allegata.
Probabilmente è un bug di appgini. Come posso risolverlo ?
Grazie in anticipo
Attachments
Gestionale.zip
(6.82 KiB) Downloaded 178 times
bug-appgini-5-62-sum-autofill.JPG
bug-appgini-5-62-sum-autofill.JPG (47.13 KiB) Viewed 3033 times

AhmedBR
AppGini Super Hero
AppGini Super Hero
Posts: 327
Joined: 2013-09-19 10:23

Re: BUG SUM Auto-fill appgini 5.62

Post by AhmedBR » 2017-09-20 12:52

The problem is that Appgini SUM the ID of the prices and not the prices itself.

I had a similar problem, here is the work around I use:

1. Leave the price as Null (that is do not reference the other table).
2. Use Left Join (this table + the table that has the price and update the price using ini hook)
This way the sum will work correctly.
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper

facos79
Veteran Member
Posts: 115
Joined: 2014-10-29 12:31

Re: BUG SUM Auto-fill appgini 5.62

Post by facos79 » 2017-09-21 20:58

Grazie :)

Post Reply