C/Front and triggers in tables

bhuber

Can you use C/Front to build records in a Journal such as the Payroll Journal and if so, can you call table triggers such as OnValidate? IF not, any suggestions on how to fill a Journal such as the Payroll Journal without using a physical file interface.

Luc_VanDyck

You can't execute triggers using C/FRONT.

I suggest you fill up a temporary table in Navision with the information for your posting. And then create a Period Activity in Navision, to transfer that data to the actual Journal table. That way, you can use all the validation/triggers from the database. Eventually, you can modify codeunit 1, so the data gets automatically transferred when someone logs in.

mv

Like Luc suggest, the best option might be to transfer data into new tables in Navision and use a periodic activity in Navision to validate from there.

However, I beliveve the Login-trigger in codeunit 1 should be used with caution. While this trigger is in progress for 1 user, no other users can login meanwhile. If the trigger is modified, one should be sure that the code will still complete (and complete quickly) in all cases. This might not be the case with a dataport.