1. Home
  2. Point-Of-Sale Software
  3. Custom Report / Z Type

Custom Report / Z Type

I need a custom report that gives me information by date in a Z-report type format. The first column would be batch and/or closing date. Then the next columns I need are:

COGS Deposits made Deposits redeemed Sales (net of discounts and returns, pre-tax) Paid on account Paid to account Tax collected Over/short total Closing total (for each temder type, so multiple columns) Paid out total

I checked out the Z report that is floating around out there. It is a good start, but I can't seem to modify it to suit my needs. Any help?

Reply to
Jason
Loading thread data ...

The Combined/All Z Reports that I found on the

formatting link
site comes pretty close except it doesn't list the closing totals for each tender type.

Hope this helps, if you find a better one please let me know as I would be interested in this as well.

Reply to
Alex

Jason, Jean Holland

formatting link
wrote a similar custom report for me 6 or 7 months ago, I cannot remember the exact cost, but I think it was about $150.00. She did a little tweaking of the report at my request.

Kinnard

K> I need a custom report that gives me information by date in a Z-report type

Reply to
Kinnard

Hello Janson,

We can write a custom report for your requirements, if you are interested please drop a email to me.

Regards, Manick ERP Soluti> I need a custom report that gives me information by date in a Z-report type

Reply to
manick

Hi Jason,

There is already one report called Register Analysis Report under Utiltiites> Crystal Report > RegAnaly.def run it , it has the information you are requesting, also you can customized this report by your own.

H> I need a custom report that gives me information by date in a Z-report type

Reply to
Akber Alwani

This is an excellent start, however it does not show closing amounts for each tender type. I need this because some tender types (credit cards) are deposited to different bank accounts, so my journal entry is different.

What I would really like is a report from HQ for all stores. The BATCH table has almost everthing I need except the closing totals (by tender) and the over/short. I would just do a SQL query to get the information, but I can't figure out the joins to get all of the information I need in table format.

Reply to
Jason

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.