Hello all.
Hi, hope this makes sense.
I know that a lot of data can be exported to Excel in reports, but we want to export Product Discount data, and I can't see how.
There is a discount tab on the Product Record window, which when opened has separate tabs available.
We've got one each for websales, workshop, retail and trade.
It would help if we could export or run a report to get this data.
Effectively, it would be a report listing each product, it's cost price, it's retail price and then the data for each discount tab for each level of discount (there is only one level of discount used).
Does anyone know if there's a standard report to show the stock list to including the discounts per product?. It would surely be too big a job to run a report per product to get the discount data, but I can't see any discount reports.
Thanks.
Alex.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Reports to show Discounts per product
- brucedenney
- Site Admin
- Posts: 4629
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Reports to show Discounts per product
I doubt very much that there is a standard report.
However
It would be fairly easy to add the extra fields onto an existing report run to a csv file and use that.
There are a lot of fields there to be exported, each table has multiple breaks and multiple discount rates.
I would do an odbc linked spreadsheet like the attached
However
It would be fairly easy to add the extra fields onto an existing report run to a csv file and use that.
There are a lot of fields there to be exported, each table has multiple breaks and multiple discount rates.
I would do an odbc linked spreadsheet like the attached
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Reports to show Discounts per product
Ok, thanks for that, but I have no idea how to use it.
I'll have a play.
I'll have a play.
- brucedenney
- Site Admin
- Posts: 4629
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Reports to show Discounts per product
open the sheet and enable macros and external data access if prompted, On the sage control tab, enter the version number you use, path to sage data, a valid username and a valid password. Press the go button.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 11 guests