hello to all, how can I create Item sale report like the image below
but in custom report
This is the syntax for the report in V5. This will not work properly in v4 but it wont be long before we see v5. Right now there is not a syntax that can build that report you would need to use sql.
[Group Sales by Amount:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum}
>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum}
[Group Sales by Quantity:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Percent.desc,O.Quantity.Sum}
>Total||{REPORT ORDER DETAILS:O.Quantity.Sum}
[Sales:2, 1, 1]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.desc,O.ExactTotal.desc}Thanks for the reply
we are looking forward to using V5
I think the V5 will have many fantastic functions.
in your opinion, do you think it’s time to say goodbye to V3 and puts it in the trophy cabinet as many of us did with V2?
I say this because of the multi-language support
I think the biggest reason to still continue to use the V3 is simply the language support.
will be that with the arrival of Amazing V5, the Fantastic V4 will win the mult-language support?
How do I change the decimal?
example:
correct
Quantity = 1
Total = 2,300.00
wrong
Quantity = 1.000
Total = 2300.00000
[Venda Total Item Grupo):10,3,1, 1, 1,1]
Produto|Quant|Total|
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity,O.Total,}
I think we may see multi language again. I would say it is a safe bet to let v3 go.
that must be regional settings making those large decimals.
Sorry this is bad information look at my last post.
Dear this is certainly great news for us on V4. Thanks for the Tip
about my problem of decimals, already reviewed the regional configurations and they are perfect
I was trying some alterations and got success, but only in TotalAmount.
the same is not true with the quantities.
which will be the problem?`
[Vendas Geral:1,1,3,1, 1,]
>Factura|Fornecedor|Produto|[L]Quant|[L]Total|
{REPORT ORDER DETAILS:T.TicketNumber,O.ItemGroup,O.MenuItemName,O.Quantity,T.TotalAmount,}
I change = O.Total,} for T.TotalAmount,}
its worked but not for Quantity
Try this
[Vendas Geral:1,1,3,1, 1,]
>Factura|Fornecedor|Produto|Quant|Total
{REPORT ORDER DETAILS:T.TicketNumber,O.ItemGroup,O.MenuItemName,=N([O.Quantity]),T.TotalAmount}
Your original report would work as this:
[Venda Total Item Grupo:10,3,1, 1, 1,1]
Produto|Quant|Total|
{REPORT ORDER DETAILS:O.MenuItemName,=N([O.Quantity]),=F([O.Total])}yes! works perfect now, but …
we can change the space in the first digit format?
Something like:
wrong
113850,00
Correct Perfect
113.850,00
this also worked out
113 850,00
you can see the difference between the primary space and the following digit?
this is possible
I do not think that is possible. Your using comma as the decimal separator in regional settings?
This all regional correct parameters
So your using comma for decimal seperator so 113850,00 would be 113850.00 otherwise. If your wanting it to show as 113.850,00 so you would need to set . as the digit grouping symbol it looks like you have a blank set atm.
yes I will try to change the digit grouping symbol
Set this to .
But even then it will not insert the separator there. We would need to format it . give me a big to look up the syntax
[Vendas Geral:1,1,3, 1, 2,]
>Factura|Fornecedor|Produto|Quant|Total
{REPORT ORDER DETAILS:T.TicketNumber,O.ItemGroup,O.MenuItemName,=N([O.Quantity]),T.TotalAmount}
>|||Total Geral
|||Descontos|[=F(TN('{ACCOUNT DEBIT TOTAL:Desconto}'),'#,#0.00')] AKZ
|||SubTotal|[=F(TN('{ACCOUNT CREDIT TOTAL:Vendas}'),'#,#0.00')] AKZ
|||TOTAL|{ACCOUNT TOTAL:Contas de Pagamento} AKZ
[Resumo:3, 2]
>Pagos|
Dinheiro|[=F(TN('{ACCOUNT TRANSACTION TOTAL:Pagamento Transação:Dinheiro}'),'#,#0.00')] AKZ
Cartão de Crédito|[=F(TN('{ACCOUNT TRANSACTION TOTAL:Pagamento Transação:Cartão de Crédito}'),'#,#0.00')] AKZ
Conta Corrente|[=F(TN('{ACCOUNT TOTAL:Contas de Clientes}'),'#,#0.00')] AKZ
Total|[=F(TN('{ACCOUNT TRANSACTION TOTAL:Pagamento Transação:Contas de Pagamento}')+TN('{ACCOUNT TOTAL:Cliente Accounts}'),'#,#0.00')] AKZ
[Vendas:3, 2]
>Resumo de Vendas
Vendas|[=F(TN('{ACCOUNT CREDIT TOTAL:Vendas}'),'#,#0.00')] AKZ
Taxa Serviço|[=F(TN('{ACCOUNT CREDIT TOTAL:Taxa Serviço}'),'#,#0.00')] AKZ
Descontos|[=F(TN('{ACCOUNT DEBIT TOTAL:Desconto}'),'#,#0.00')] AKZ
Total|[=F(TN('{ACCOUNT CREDIT TOTAL:Venda}')+TN('{ACCOUNT CREDIT TOTAL:Taxa Serviço}')-TN('{ACCOUNT DEBIT TOTAL:Desconto}'),'#,#0.00')]AKZA quick idea. Did you tried this?
=C([T.TotalAmount])
1 Like
Perfect work!
Thanks
