Anyone who can help, Some of the challenges I have is not understanding or not able to find references to some of the tables in Store Ops//HQ. I have read Partner Article 862575 and 935586, and they help a little.
I consider the tables relating to sales are important considering the dollar reporting that I have to do from Store Ops/HQ.
- Which table does the Z report get the data from? I believe it is the TenderTotals and DailySales. I checked them - and I hope I am right.
- What does the 'shift' and 'count' columns mean in the TenderTotals table?
- I have two registers in a store, so I have two batch numbers, which I used in my queries. I received different total results when I run queries against the different tables. Some SQL samples are:
select batchnumber, sum([Close]) from TenderTotals where batchnumber=X /Y group by batchnumber
select * from dailysales where type=4 and convert(varchar(10),Date,120)='filter by date for that batch' (I add up the amount from RegX & Y)
select sales, SalesPlusTax from Batch where batchnumber in (X,Y)
Does anyone has a reference that I can get? Thanks. AT