Hello,
I am building an automated solution to integrate contracts/projects/budgets into dyn gp 2018.3. I'm using smartconnect. I am able to integrate most of the data from MySQL into GP - except the Project_Acct_Employee_Rate table data?
I located a custom procedure in the requester folder located here: C:\Program Files (x86)\Microsoft Dynamics\eConnect 16.0\Custom Procedures\Requester\Project_Acct_Employee_Rate.sql.
My question is: Can I set the requesterTRX flag to 1 on one of the taPre psa sprocs and pass the data via a smartconnect global variable into this Project_Acct_Employee_Rate.sql - to create one employee rate table for each project I create? or separately to create the each employee rate table?