Hi,
I would suggest having imported in custom tables having the similar structure of Purchase header and Purchase line without any code in any trigger.
Then to import you can use any feature, it should be fast enough but if its something that you will be doing any a process to follow I would suggest using xmlports or a codeunit that you can schedule to run to read files from a folder and import it in nav and then move to processed folder.
After the import is successful another job queue can try to generate purchase invoices from data in custom tables and update the status on the same table if any errors. If records are processed process will delete the records from custom tables.
------------------------------
Saurav Dhyani
ArcherPoint Inc.
Duluth GA
------------------------------
Original Message:
Sent: 12-05-2018 02:13 PM
From: Deanna Hutchins
Subject: Uploading a Purchase Invoice with 300 lines
Hi,
We currently have a few invoices to process that has over 250 lines of coding and looking for options to load data.
The options provided to load the PI lines are:
1) Copy Paste - this is taking a couple hours as lines are validated - is this typical
2) Rapid Start template - this tool is not for end users as it accesses tables directly
3) XML import routine - this is used for specific vendor integrations
Would welcome any thoughts on options to load these large records.
Regards,
Deanna
------------------------------
Deanna Hutchins
Strad Energy Services Ltd
AB
------------------------------