Custom Report / Z Type

Jun 05, 2007 5 Replies
J

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?


Vote
Twitter Facebook LinkedIn
A

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.

Vote
Twitter Facebook LinkedIn
K

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

Vote
Twitter Facebook LinkedIn
M

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

Vote
Twitter Facebook LinkedIn
A

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

Vote
Twitter Facebook LinkedIn
J

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.

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required