Page 1 of 1

Report design - item not appearing

Posted: 18 Feb 2015, 11:06
by Caterpillar
Good morning. I am using SL50 V 11. I have amended a Sales by Product report (in Invoice Reports), to include the "Unit Cost" of an item. I have managed to do this, and the data is appearing on the report when I run it, but when I export the data in .csv to Excel to manipuulate it, the Unit Cost data has disappeared. Would you be able to help at all? Thank you.

Re: Report design - item not appearing

Posted: 18 Feb 2015, 12:20
by brucedenney
Attach the layout to a post and I will have a look.

Why use a report though?

It would be neater to just pull the information from Sage into Excel with ODBC, you open the workbook, set your parameters, refresh and it is done.