What tables does RMS use to get Department Totals in Z Report?

Posted by fabiano on January 26, 2006, 9:39 am

Please log in for more thread options

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.

Posted by Glenn Adams [MVP - Retail Mgmt on January 26, 2006, 12:06 pm

Please log in for more thread options

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...

--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

>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.