Update Access database when saving Sales Order

Question

Hello, I'm a little new to Odoo and I'm working on an integration between Odoo 14 and a legacy system that uses Access 97.  Our plan is to get away from this Access system completely.
I'm trying to execute some Python code that will insert data from a Sales Order into multiple tables in the Access database.
Would I use a Server Action or Automated Action for this?  I'm having a little trouble figuring out how the Server Action works so it will run on create.
Can someone point me in the right dir

Mehjabin Farsana · Answer

Hi,
You can design the system as follows:
* run a scheduled action that runs in specific time interval
* call a function from this scheduled action, which will fetch the data from legacy system and create records in odoo
You can follow above pattern or:
* from the legacy system side
* on creation or updation of records there, you can trigger an action in odoo via xml rpc to create records in odoo
Thanks

Related Posts	Odpovědi	Zobrazení
Transform Quotations to sales orders or invoices in a bulk action sales.order	3 úno 25	1640
Orden de venta borrada por error sales.order	1 pro 24	1831
How to create a subsection in the product order line and make the main section sum the total of the subsections in Odoo? Vyřešeno sales.order	2 bře 24	2183
Managing orders from repeat customers Vyřešeno sales.order	2 bře 24	2704
Sales order from customer order. sales.order	0 zář 23	1329

This question has been flagged

Enjoying the discussion? Don't just read, join in!