In the workperiod report there is a section that groups by O.ItemGroup. How can I modify the report to list just certain groups. I would like to group all my taxable items in one report and untaxed items in another report. The report below gives me all groups.
[Group Sales by Amount:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True)}
Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True)}
Any help would be appreciated. Thank you.
Not sure how personally, might be tricky as although tax is based on orders it is as far as I understand a ticket level detail.
We can report the amount of tax on an order report, ie;
{REPORT ORDER DETAILS:O.ExactTotal.Sum,TX.VAT:(ODI=True)}
Replacing VAT with your tax name.
But not sure how this can be aplied to only show taxable items.
Obvously reporting tax amount with order group will show amount of tax but not sure on how you might achive a tax breakdown on this
Does this not work?
{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) && TX.VAT>0}
That works and I figured out how to do what I needed. In Pennsylvania food is taxed by the restaurant but alcohol is taxed when it is purchased. I just divided up the Item Sales Report into 2 reports, one with taxed items and one with non-taxed items. Trying to save the bookkeeper a calculation.
Thank you for the reply.
Hi,
What does the flag ODI=True do? I do not see anything in the documentation on this.
Thanks,
ODI = Order Decrease Inventory.
In most case mean void orders