Hi all

I am new to Sugar, i needed to update - on a regular basis - some custom fields
i obtain the data from our ERP and then update some fields in the accounts
(example: Total Sales per month - 12 Custom fields JAN to DEC for each account)


Each day i query the ERP, obtain the sales values so far for all customers and update the data in the Custom fields

either by directly updating the MySQL DB or using some script

What is the best way to acomplish this?

thanks
Best regards