Share
Report
240Hello Dynamics Community!
We are using Dynamics GP2018 and integrating from a cloud application with API Boomi using eConnect. We are integrating Timesheets, using the PATimesheets xml, pre and post procedures in eConnect. The timesheets can be weekly and monthly.
The data is being inserted, but there's an issue. If we use multiple different PATSNO numbers, all 5 lines for the week time lines are inserted into the PA10001 table, but it replicates the data 5 times over in PA10000 and the PA10003 from the Header insert. If we use one PATSNO, just one line for the day of the week is inserted into the PA10001 table for the Line insert, not all 5 lines for each day of the week, and the PA10000 and PA10003 Header insert tables then correctly inserts just the one data record summarized amounts.
How is this issue resolved to get all 5 lines inserted for each day in PA10001, and get just the one record line in PA10000 and PA10003 with the stored procedures in eConnect? Do the stored procedures SQL scripts need to be altered to accommodate for this? If so, what would be the SQL script modification be to correctly insert the records on all three tables?
Thank you in advance for your assistance!
Diane
All responses (
Answers (
