Hi There,
Does anyone know what Type & TypeID columns referring to in DailySales table in HQ ? I have customization guide but there is no details about that columns.
Thanks, Arthur
- posted
14 years ago
DailySales Table
Loading thread data ...
- Vote on answer
- posted
14 years ago
Hi Arthur - my understanding of the Daily Sales table is that it gets populated by some internal function that groups based on supplier, cashier, etc. Here are some old notes I found on what the Daily Sales Type refer to:
1: Supplier 2: Category 3: Department 4: Register 5: Cashier 6: Sales Rep-- the TypeID may refer to the batch that's feeding the info (ie batch.batchnumber or batch.id.
H> Hi There,
- Vote on answer
- posted
14 years ago
spot on ! I've just checked the type=3 and its exactly as you saying ... the TypeID refers to Department.ID in that case.
Thanks a lot, Arthur