Sage 200 direct database interactions

[Simon Collings]

Hi,

I would like some guidance on the Sage 200 database setup please, the API does not do enough CRUD functionality that I need.

Essentially I need to be able to mimic the actions you can do via the Sage 200 UI, via code.

For example, I need to be able to update a sales order item and change its allocation from one warehouse to another before marking it as despatched.

This is just one example, but it is not possible from what I can find online in the documentation.

I am a developer with direct database access to Sage 200, I can easily query the database and get information out, such as available stock across warehouses, but when it comes to updating data, I need some documentation on what tables/cols need to be updated so that I don't cause any corruptions further down the line.

Surely there must be documentation on how the application interacts with the database - I have emailed the developer support email but I have had nothing back.

Thanks

Simon

[Nigel Smith]

You may wish to contact [email protected] and ask about becoming a sage 200 developer (this will allow use of the Sage 200 SDK)