|
Posted by Mickie on January 5, 2007, 6:11 pm
Please log in for more thread options ARG.
Is there no way then?
It was suggested in the very beginning that I set up different tender Types
to track this information. I really need to track the CASHIER to see who
entered the order, etc, s I can't use that. Maybe I can use SALESPERSON to
track the sales?
The tender types actually work with the different ways we sell....like
Amazon, ebay, Website. I use your report to show us what the breakdown in
sales is.
Thanks Jeff....guess I will have to re-think this.
"Jeff @ Check Point Software" wrote:
> Mickie,
>
> You should really re-think what you are doing!
>
> The tender type should have nothing to do with the type of sale or who it was
sold to. You will have nothing but problems doing it this way as you can have
more than 10 ways to pay the bill, then you will have the sale listed 10 times!
;-(
>
> What you should be doing is identify the Internet sales and non-Internet sales
by the cashier. Set up your system with an Internet cashier and all of the rest
of your cashiers.
>
> Then setup you POS to ask for the cashier on start of the sale.
>
> Then your existing and new custom reports will be correct, based on the items,
departments, customers, etc., NOT how it was paid for.
>
> --
>
> Jeff
> Check Point Software
>
> =====================================================
>
> You must be using Outlook Express or some other type of newsgroup reader to
> see and download the file attachment(s). If you are not using a reader, follow
> the link below to setup Outlook Express. Click on "Open with newsreader"
> under the MS Retail Management System on the right.
>
> http://tinyurl.com/75bgz
> =====================================================
>
> OK you Kings of Kode..please help me. I am stumped.
>
> I have several tender types..some are INTERNET orders, some are IN-STORE
> orders. I am trying to create a report that lists every item sold (for a
time
> period), how many sold, how much it actually sold for, and if it was an
> internet or in-store sale.
>
> I have the Tender Detailed report by CheckPoint Software..that works pretty
> well for monthly totals (even though I would LOVE to have the shipping $$
> included in those numbers!!! hint hint)
>
> So I looked at that structure to come up with the following SQL query.
> (ignore the time in the last line..I am trying to get December sales data).
>
> However, there are often TWO tenderEntry.ID number for each transaction
> because one os for the initial tender amount and another is for the change
> given. So I am getting 2 items with costs which will screw up my totals.
>
> How do I do this? Arg...I hate myself!
>
> I just want a list of every item sold, $ paid, and internet or in-store sale
> (I call SaleType). Thats it!
>
> SELECT
> dbo.[Transaction].Time,
> dbo.[Transaction].TransactionNumber, dbo.Item.ItemLookupCode,
> dbo.Item.SubDescription1 AS Brand,
> dbo.Item.Description AS ITEM,
> dbo.TransactionEntry.Quantity AS QTYSOLD,
> dbo.TenderEntry.TenderID,
> CASE WHEN TenderEntry.TenderId < 6 THEN 'IN-STORE' ELSE 'INTERNET' END AS
> SaleType,
> dbo.TenderEntry.Description AS TenderType,
> dbo.TransactionEntry.Price AS SOLDPRICE,
> dbo.TransactionEntry.Price *
> dbo.TransactionEntry.Quantity AS TOTALPRICE
>
> FROM
> dbo.TenderEntry INNER JOIN
> dbo.TransactionEntry ON dbo.TenderEntry.TransactionNumber =
> dbo.TransactionEntry.TransactionNumber INNER JOIN
> dbo.Item ON dbo.TransactionEntry.ItemID = dbo.Item.ID LEFT OUTER JOIN
> dbo.OrderHistory ON dbo.TenderEntry.OrderHistoryID = dbo.OrderHistory.ID
> LEFT OUTER JOIN
> dbo.[Order] ON dbo.OrderHistory.OrderID = dbo.[Order].ID LEFT OUTER JOIN
> dbo.[Transaction] ON dbo.TenderEntry.TransactionNumber =
> dbo.[Transaction].TransactionNumber
>
> WHERE
> (dbo.[Transaction].Time BETWEEN CONVERT(DATETIME, '2006-12-01 00:00:00',
> 102) AND CONVERT(DATETIME, '2006-12-31 00:00:00', 102))
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap