How to add a brand column in sales report?

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date How to add a brand column in sales report? Ramzey 03-29-2006  RE: How to add a brand column in sales report? Terrible To 03-29-2006  RE: How to add a brand column in sales report? Silverpaper 03-29-2006  RE: How to add a brand column in sales report? Silverpaper 03-29-2006
Posted by Ramzey on March 29, 2006, 3:12 am Please log in for more thread options I want to see detail on brands column on detail sales report. How can dis be added? Posted by Terrible Tom on March 29, 2006, 11:53 am Please log in for more thread options It's not exactly pretty, but here's what we did: I used SubDescription1 for brand, then ran a query to append ", SubDescription1" to my Description field. You could also add SubDescription1 to the receipt. You could probably use another query to populate SubDescription1 with the SupplierName, but the two are not always the same. HTH, Tom -- The worst words in business: "We''ve always done it that way" -- Stop Fishing for eMail. "Ramzey" wrote: > I want to see detail on brands column on detail sales report. > How can dis be added? Posted by Silverpaper on March 29, 2006, 5:32 pm Please log in for more thread options NitroSell has a tool called the Product Attri bute manager that allows you to add any field you want to RMS. The tool is intended to use in conjunction with their web store integration to create item fields that can be mapped back to be rendered on the site. You can however use this tool to create the field, and then they have a toolbar option 'generate reports' that parses any field you create there back into your RMS reports. for more info email todd.jensen@nitrosell.com "Ramzey" wrote: > I want to see detail on brands column on detail sales report. > How can dis be added? Posted by Silverpaper on March 29, 2006, 5:35 pm Please log in for more thread options NitroSell has a tool that allows you to create any field you want to further describe your products (such as 'ingredients', 'season,' etc.). The tool is intended to work with the web store solution they provide - basically you can create whatever item detail you want and then those fields can be mapped back to the site to render the appropriate information to the online consumer. The tool could be used for this purpose however, and there is a function in the tool that updates RMS reports with the fields you create there. Those fields are not only rendered in the output of the report, but they are also filter and sort options as well of course. If you need more info, contact todd.jensen@nitrosell.com "Ramzey" wrote: > I want to see detail on brands column on detail sales report. > How can dis be added? Similar Threads Posted Query optimization advice for custom 12-column sales detail report May 10, 2006, 6:48 pm Batch Table Sales Column June 20, 2007, 5:41 pm HandHeld Brand Cordless Barcode Scanner...... September 12, 2006, 9:45 pm Add more column in existing report November 3, 2009, 9:47 am Changing Report Column Font December 17, 2006, 2:47 am Print report column in bild December 10, 2007, 7:26 pm Discrepancies between Detailed Sales Report and Summary Sales Repo August 30, 2006, 12:37 pm Error Total sales report hour sales August 14, 2006, 3:19 pm Department Sales Report (Tax Included in Sales) is wrong February 29, 2008, 6:44 pm Adding % of total sales to a sales report April 11, 2006, 6:36 pm