07-03-2013 04:40 AM
How do I get the Sage50 customer account number to show in ACt as a field that I can then search on?
I want to write a plugin to post appointments against companies using their Sage 50 account number.
07-05-2013 03:22 AM
Anybody know anything at all about this subject???
For a product that is supposed to have been owned by Sage until a couple of months ago, there doesnt seem to be much integration between the two products (Sage ERP and ACT)..
Alternatively, does anybody know anything about getting data out of Sage50 via Sdata?
07-07-2013 08:43 AM - edited 07-07-2013 07:42 PM
I have never used sData with Sage50 but they have a forum which may be helpful....
Here is a thread regarding updating a field in act!.
Once your data is updated in the act! DB it will be searchable. Here iis another thread...
To create an activity check out this thread...
Hope this helps
07-08-2013 04:33 AM
thank you very much for that, but unfortunately I already know about inserting and updating standard and obvious data within ACT.
re the link to the SAGE forum, I cant do the work within the Sage arena because it needs the sage SDK and a good few years of practice to get things working.
No I just need to know about the standard off the tools menu function in ACT called Accounting Integration.
When a scheduled Sync between ACT and the 'Back Office' (or whatever ACT now calls it) has happened, WHERE is the data held.
I just cant find any reference to the Sage Account Reference anywhere within ACT. However, ACT will display a screen with this data on it but I cant find it in the SDK or the raw tables anywhere.
Can you help me please?
07-08-2013 06:39 AM
07-08-2013 11:50 PM - edited 07-08-2013 11:53 PM
Jim is correct, there's nothing in the ACT SDK that exposes anything to do with the Accounts integration.
"Alternatively, does anybody know anything about getting data out of Sage50 via Sdata?"
Try this forum for help with Sdata: https://sdata.sage.com/SDataForum/Default.aspx
07-17-2013 08:07 AM - edited 07-17-2013 09:33 AM
We have integrated with several Sage Accounting products.
Sage 50 US [ http://datapluscrmsolutions.com/sage/sage50us ]
Sage 50 CA [ http://datapluscrmsolutions.com/sage/sage50ca ]
With this integration, you get the customer account number, and a wealth of information from the accounting program in ACT fields, and in an additional tab for data mining invoices, payments, jobs, credits etc. ACT! user does not have to have the accounting application installed locally.