+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Development (https://discussions.corebos.org/forumdisplay.php?fid=18)
+--- Forum: coreBOS Development (https://discussions.corebos.org/forumdisplay.php?fid=4)
+--- Thread: Background of the financial fields (/showthread.php?tid=1874)
Background of the financial fields - Guido1982 - 07-26-2020
Since I'm working on a module that will introduce a new inventorydetails block and will also implement the now 'standard' financial fields that live on the stock inventory modules. I will use the master-detail businessmap definition as described in the wiki, but to be able to do so I would like to know the purpose, unit (%, currency or just no.) and exact formula for each of the following fields:
- pl_gross_total
- pl_dto_line
- pl_dto_global
- pl_dto_total
- pl_net_total
- pl_sh_total
- pl_sh_tax
- pl_adjustment
- pl_grand_total
- sum_nettotal
RE: Background of the financial fields - joebordes - 07-26-2020
can you share what you are trying to do? what are you trying to solve?
RE: Background of the financial fields - joebordes - 07-26-2020
https://corebos.com/documentation/doku.php?id=en:inventorymodules
do you need more information that what is on that page?
RE: Background of the financial fields - Guido1982 - 07-26-2020
(07-26-2020, 01:53 PM)joebordes Wrote: https://corebos.com/documentation/doku.php?id=en:inventorymodules
do you need more information that what is on that page?
Seems like exactly what I was looking for after breezing over. I want to implement my idlines block, where the equivalents of these fields live. So I want to make sure the same calculation is performed on those representations. Not sure how I want to do it but wanted to make sure I have the correct information/background so that we're all on the same page.
RE: Background of the financial fields - Guido1982 - 07-27-2020
I think there's a double field in the wiki:
- Tax totals: a field with the sum of all taxes applied for each tax active
- Total tax: the sum of all taxes applied
RE: Background of the financial fields - joebordes - 07-27-2020
fixed. thanks!
RE: Background of the financial fields - Guido1982 - 08-03-2020
One thing I don't get is:
- Net before global discount: gross total minus individual line discounts
- Net total (after global discount): gross total minus total discounts
Shouldn't the net total, after global discount be the net total before global discount, minus the global discount? Now it speaks of the gross total, without taking the line discounts into consideration.
RE: Background of the financial fields - joebordes - 08-27-2020
the wording is probably not the best, but you are correct, let me try to explain
before global discount is the gross total minus the individual LINE discounts
after global discount is the gross total minus ALL (total sum of all) discounts which should equal "before global discount" minus the "global discount" (as you say)
better?
RE: Background of the financial fields - Guido1982 - 08-28-2020
Yeah so it's just the gross total minus all available discounts, be that line discounts or global ones. That seems correct.