Hello everyone,
I am trying to enroll employees to benefits using the eConnect.CreateTransactionEntityAsync() method call. My XML looks something like this:
<?xml version="1.0" encoding="UTF-16"?>
-<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
-<UPRCreateEmployeeBenefitType>
<eConnectProcessInfo xsi:nil="true"/>
<taRequesterTrxDisabler_Items xsi:nil="true"/>
-<taCreateEmployeeBenefit>
<EMPLOYID>Employee_Id_Here</EMPLOYID>
<BENEFIT>Benefit_Id_Here</BENEFIT>
<BNFBEGDT>6/1/2021</BNFBEGDT>
</taCreateEmployeeBenefit>
<taCreateEmployeeBenefitBasedOnPayDedCodes_Items xsi:nil="true"/>
</UPRCreateEmployeeBenefitType>
</eConnect>
This creates the employee and the benefit successfully, and I am able to verify the record was created in table UPR00600 (Payroll Benefit Master). After the eConnect call, I need to update the employee/employer cost by overriding table [BE010130] (HR Benefit Master). The problem is that the record for my Employee with the benefit does not show up in table BE010130, and therefore I am unable to update the cost for the benefit programmatically.
I found that going into reconcile human resources -> and triggering the update benefit enrollment, the employee that was created actually pops up in table BE010130, so that also verifies that at least my request actually goes through, at least partially.
Using SQL Server Profiler, I was able to trace all the stored procedures that GP runs when I trigger the update benefit enrollment reconcile, but even after running most of the stored (manually, not through GP) procs that involve my employee and my benefit code, it still does not show up in the HR Benefit Master table.
If anyone knows what I am missing, either if I should be sending a different XML, missing some stored procs, or even a way to programmatically trigger a reconcile, please let me know.