I have a customer that has the SAGE 300 Web API setup.
One of the requirements from the customer is to get data from a web form and update the AR Customer and also update the EFT Customer.
I wanted to do everything via Web API but apparently, the Web API does not provide an endpoint to update the EFT Customer.
Is there another way to update the EFT Customer?
1- Can I update the EFT Customer via SQL? Wich tables are involved? Or there is some business logic on the application layer that is updating multiple tables based on the EFT Customer?
2- If I create two new optional fields in the AR Customer. Does Sage 300 offer an internal workflow to update the EFT Customer based on an update event in AR Customers?