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
DailySales Table
Dec 21, 2009
2 Replies
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,
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required