What table stores end of day batch detail for departments

Hi,

I am building a custom application to allow me to use RMS for a wine store and a food store on one database but drop batches into 2 quickbooks files. I need to do this because of the laws of NY state.

We are building a new quickbooks posting application that will post to different qb files based on the register number.

What we cannot figure out is where are the rolled up numbers for department totals stored in the database for each batch.

Can someone help ?

Thank you.

Jason The Greene Grape

Reply to
greenegrape
Loading thread data ...

We do something similar because we run service on one register and retail sales on another, then want to see the breakout.

The batch table will obviously give you your batch totals. Link that to the registers table to see which register it came from. But there is no rolled up numbers by department. To get that, you'll have to look at the Transaction and TransactionEntry tables. The TransactionEntry will have the item sold. Link that to the Item table to get the DepartmentID, and link that to the Department table to get the Department name. (You can skip the last step if the DepartmentID is enough.) Then you can group it by register and department.

"greenegrape" wrote:

Reply to
RickASP

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.