Here is the report
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
https://fr-auto.1box.link/app/report/desiner/15/view/?filter_storagemove_datefrom=2023-02-28&filter_storagemove_dateto=2023-02-28&filter_order_productionstoragenameid%5B%5D=4&filter_order_moveloggruopby=category&ok=Filter
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
here is the setting
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
I have sold 1 item and it shows 50
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
but if you enter the order
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
https://fr-auto.1box.link/18651/?delete=3272
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
then 100 is indicated but writes 50 in the report
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
that is, it takes not by the sale operation, but by the number of goods in the order
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
My task is to make sure that the goods that are returned are not taken into account in the calculation of the margin. That is, you just need to ignore it, but now I can’t do it with formulas. Since, for example, if I indicate in the formula [margin per unit] x [quantity minus the reserve], then anyway it takes into account not sales operations, but the number of goods in the order
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
Can this be fixed somehow?
[file]19349[/file]
[file]19350[/file]
[file]19351[/file]
that is, it takes not by the sale operation, but by the number of goods in the order
My task is to make sure that the goods that are returned are not taken into account in the calculation of the margin. That is, you just need to ignore it, but now I can’t do it with formulas. Since, for example, if I indicate in the formula [margin per unit] x [quantity minus the reserve], then anyway it takes into account not sales operations, but the number of goods in the order
it is necessary that the average value be calculated by the number of sales, and not by the number of goods in the order
it is necessary that the average value be calculated by the number of sales, and not by the number of goods in the order
[file]19352[/file]
[file]19352[/file]
that is, it is necessary that if I have 5 products they have 100 UAH
so that it writes not 100, but 500
is it possible to do this?
That is, the sum of the additional field of the process product, and not their average value
so even the field is called that)
[file]19408[/file]
[file]19408[/file]
that is, it is necessary that if I have 5 products they have 100 UAH
[file]19408[/file]
so that it writes not 100, but 500
[file]19408[/file]
is it possible to do this?
[file]19408[/file]
That is, the sum of the additional field of the process product, and not their average value
[file]19408[/file]
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Donate
You don't have enough funds in your account Top up