Price ovverride/ discount repoort

hi Robert, The users inputs are not trackable however when users change price to anything else it appear to be discount so you have 2 fields in TransactionEntry table one with Price and one with FullPrice. Now you can make report and filter all the data where Price FullPrice this will give you output with information from which registers and users has done that.

But!!!! one thing how you will track the the discount price comes automatically in this situation you will have hard time finding that it is happen automatically. If you not discount schemes or other stuff then the option one will work for you.

"Robert" wrote:

In the detailed sales report, use show/hide columns and make the "Price Source" field visible. I don't remember the exact values that are possible, but there should be one that indicates a manual price change. You can get a little more exact by creating Reason Codes and requiring them for discounts. These are also available in the Detailed Sales Report, IIRC, as "Discont Reason Code"

Glenn Adams Tiber Creek C> How can i generate a report that would show all the items that had a price

Hi Robert

Please follow the attach report and copy to C:\Program Files\Microsoft Retail Management System\Headquarters\Reports

after that go to detail sales report and run you will find one line for discount line.

I hoppe if this help you

Mohammed Own

Hi Robert

Please follow the attach report and copy to C:\Program Files\Microsoft Retail Management System\Headquarters\Reports

after that go to detail sales report and run you will find one line for discount line.

I hoppe if this help you

Mohammed Own

begin 666 Sales - Detailed Sales Report.qrp M+R\M+2T@4F5P;W)T(%-U;6UA

Robert, You should really be using a newsreader like Outlook Express to view the newsgroup. That way when somebody takes the time to upload an attachment for you, you can actually use it. Instead of asking the person to go further out of their way and email it to you. Some of us won't email any attachments, we post it to the newsgroup so everyone can use it. Craig