Hey guys, I found a post where emre has shown a report that should do this, but it seems as the report does not really work, and I tried to use part of code from it but its not giving me the right display.
I see so thats a known limitation with the way that feature works we need to rewrite it one sec you need to replace the first parameter with a script to get warehouse from sql.
Hey guys, I didnt want to open a new topic since we are still very close on the same idea.
My question is, is there a way to subtract entries from a Specific Transaction Type?
Here is an example:
[ARMAZEM para COZINHA:3,2, 2,1, 2]
>Name|Target|Quantity|Unit|Amount
{REPORT INVENTORY TRANSACTION DETAILS:
T.Name,
T.Target,
T.Quantity.Sum,
T.Unit,
T.TotalPrice.Sum:(ITT=Transferencia Armazem para Cozinha)
}
[Compra para Armazem:3,2, 2,1, 2]
>Name|Target|Quantity|Unit|Amount
{REPORT INVENTORY TRANSACTION DETAILS:
T.Name,
T.Target,
T.Quantity.Sum,
T.Unit,
T.TotalPrice.Sum:(ITT=Compra para Armazem)
}
That works, and shows transactions only of a specific type as specified in (ITT=Name) … now is there a way for me to add something like:
(ITT=Name) subtract (ITT=Other Name) ???
In the sample above I would like to get:
(ITT=Compra para Armazem) - (ITT=Transferencia Armazem para Cozinha)
Possible? No? If it is possible then we would have a report that shows you warehouse purchases minus items that were transferred to other warehouses and you’d also see the document total price (costs of items), and that would be awesome!
There are several expressions there for different columns, here is one of them, which produces a value that is the Count of Cash (Sum) minus the starting Float value for USD (this is using values set in Task Types, but the idea is the same:
