First let me say am new to NAV but not new to software design. I think I know the answer.
Let’s say I have a .Net program that makes order entry/PO and so on. I want to export data from this database to the NAV database. Can I just write a SQL Trigger to do this(when a new order entry/PO is made), or do I need to something else in NAV.
Create staging tables and use your code to populate those tables. Then write C/AL code to create orders based on the data in those tables.