|
Posted by PRJ on July 23, 2006, 4:06 pm
Please log in for more thread options Thanks much again, but re the discount reason code report: What I get with
those paarmeters is a report showing all the discounted transactions, by
department, with the discounted sale amount and the units sold (each
transaction on a separate line.... which is annoying - totals would be
great). There is no reason code showing anywhere in this report.
I apologize for being so needy, but I am really quite frustrated by all this.
Thanks again.
??????????????
--
WineGuy
"Teester" wrote:
> Wineguy
>
> Our system is set up so that the reason codes are the same as the reason
> descriptions (they don't necessarily have to be numbers), so it works
> fine for me. I don't think you can get the reason descriptions from a
> standard report, so you would probably need a custom report done with
> SQL to pull the correct info from the database. You can group the sales
> by discount code so at least all the transactions with the same code are
> listed together.
>
> Regarding your second question, if I understand correctly, I would have
> thought Total Sales >= 0 AND OnHand >= 0 should give all items (as long
> as no stock levels have strayed below 0 and no returns brought the total
> sales below 0) and you could select Total Sales and OnHand columns in
> the report and sort by whichever one. I haven't had a chance to try and
> see, though. I have noticed that it can't seem to sort Total Sales
> properly at all, but I'm not sure if it's the program's fault or mine.
>
> Hope this helps a bit,
> Teester
>
> On 19/07/2006 02:55, PRJ wrote:
> > That's a lot of help. So, now I have a report that shows all the
> > transactions that have a reason code. But, It doesn't tell me whatthe reason
> > codes were. Wouldn't I want to be able to examine the impact on my margin of
> > discounts by type? I tried checking the box for discount reason code in the
> > 'show/hide columns' function, but apparently the reasons aren't generated,
> > only the raw numbers in the transactions.
> >
> > Second questions: Is there a way to get sales reports to show BOTH total
> > sales and On Hand quantities in the same report? When I request total sales
> >> =0 AND on hand >=0 I only get the sales, not the on hand. I have had to
> > generate one report for sales, and a separate one for on hand.
> >
> > Thanks again.
> >
> >
> >
> > "Teester" rote:
> >
> >> Wineguy,
> >>
> >> When you add the 'Discount Reason Code' part to the query, you are
> >> actually adding 'Discount Reason Code' = " " (blank), so the query is
> >> finding all transactions in the date range which have a discount code,
> >> but where the code is blank. I'd say that you could probably set up a
> >> discount codes with the code " ", but I can't think why anyone would
> >> want to. It'd just be confusing. Maybe RMS wouldn't allow that anyway
> >> (I've never tried), but that doesn't seem to stop the reports from
> >> looking for it. So, the statement should be:
> >>
> >> Date Sold = x to y
> >> AND Discount Reason Code <> (is not equal to) " " (blank)
> >>
> >> This should give you all the items with discount reason codes, except
> >> those where it is " " i.e. all of them.
> >>
> >> As far as I know there is no easy way to get a report with individual
> >> daily sales in a month. It should be possible to create a load of
> >> filter columns in the .qrp file itself (it's just a text file so you can
> >> edit it with notepad or similar) I've tried that for a monthly sales in
> >> a year report (sales of each item in jan, feb, mar etc in separate
> >> columns). It works, but there are a few limitations.
> >>
> >> Hope this helps,
> >> Teester
> >>
> >> On 15/07/2006 19:37, PRJ wrote:
> >>> Thanks for that. It does help, especially the part where the expressions
> >>> need to be repeated.
> >>>
> >>> But, If you would....... if I want a report of sales, for a specific time
> >>> block, showing discounts by reason code...... I would think I should change
> >>> the date range to the one I want, then ADD 'discount reason code' to get all
> >>> sales that showed a discount reason code. What comes up is a blank screen.
> >>> I re-do it adding Department = not assigned, and Description = 'not
> >>> assigned', but still get nothing at all. I add 'Quantity Sold = greater
> >>> than 0, but still get nothing at all. Must be something I'm not
> >>> understanding?
> >>>
> >>> Also..... If you would..... There are many date parameters to extract sales
> >>> but they are all 'inclusive' (you get cummulative sales from date A thru date
> >>> B). Is there a way to get sales for each individual day within a time block?
> >>> ie- daily sales for each day in a month?
> >>>
> >>> WineGuy
> >>>
> >>>
> >>> "Teester" wrote:
> >>>
> >>>> Whoops, just realised the HTML doesn't show up properly on the Microsoft
> >>>> board. Sorry about that. Here's the plain text version:
> >>>>
> >>>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap