Hi All
I am hoping someone can assist or advise me urgently.
I am trying to generate a report via excel with a connection that has been estbalished to the SQL database for the sage evolution.
The report i am looking to generate is a sales detailed report with the following data elements:
Customer names, invoice #, Line #, Cat no, qty, line selling prices, line cost, invoice dates and if possible the items detail sold with cost and selling price
Generally most would have been achievable via the sales master report with BIC but we do not have this module and our client is not prepared to purchase it at this stage so trying to find a work around.
Any assistance is appreciative.
