Hi,
I am trying to export the following information out of Actinic 10 into a spreadsheet without having to buy an add on or get someone to write a bespoke report for me. Any help or ideas as to how I do this would be greatly appreciated.
- Date Ordered
- Customer Name
- Order Number
- Total Value of Order
- VAT amount
If I use the <operations><reports selection><sales> option in Actinic and it doesn't give what I need. The closest I have got to achieving the result is highlighting the all the orders and then selecting the <export> tab......but the information seems to duplicate each customers record and the information I need is split over various files (Order file, Person file, Order Line File, Payments). For some reason the person file duplicates each order as well apart from a field called the 'CONTACT ID'
Sorry to go on......
I am trying to export the following information out of Actinic 10 into a spreadsheet without having to buy an add on or get someone to write a bespoke report for me. Any help or ideas as to how I do this would be greatly appreciated.
- Date Ordered
- Customer Name
- Order Number
- Total Value of Order
- VAT amount
If I use the <operations><reports selection><sales> option in Actinic and it doesn't give what I need. The closest I have got to achieving the result is highlighting the all the orders and then selecting the <export> tab......but the information seems to duplicate each customers record and the information I need is split over various files (Order file, Person file, Order Line File, Payments). For some reason the person file duplicates each order as well apart from a field called the 'CONTACT ID'
Sorry to go on......