Sage Woe

[jamoor]

In sage MMS (ARRGH) we have an account for each invoice address, this is the customers invoice address, we alter the delivery address depending on which part of their organisation ordered it, however this poses a problem when you want to see which part of the organisation has spent how much!

Any ideas if this can be achieved (i called tech support but they said they will call back tomorrow)

Edited by jamoor on Wednesday 30th January 19:14

[rwoodward]

you'll need to create a custom report to pull this information out - you should be able to use something like Crystal Reports to look at the orders table, and total the value of the order. If you group the transactions by the Delivery Postcode then they should lump the different offices together.

Hope this helps, feel free to drop me a line if you want any further information.

Ross

_
Ross Woodward
NE Solutiond Ltd
<Making IT Easy>
01207 565950
[e-mail]
Sage Line 50 Development Centre