I would like to figure out what departments RMS uses to get the department totals in a Batch when the Z Reports is taken at the close of the day.
I'm trying to create a Crystal Report and not sure what tables to link.
What tables does RMS use to get Department Totals in Z Report?
Jan 26, 2006
1 Replies
Batch -> Transaction -> TransactionEntry -> Item -> Department
You could look at the detailed sales report to get most of the joins for this - I don't think that Detailed Sales includes Batch, but it might; it definately includes Register, which may come through Batch...
Easiest thing to do would be to add Batch.Number to detailed sales report if it isn't already there, then filter by batch and group by department...
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required