Dynamics GP Payroll Integration to Payables

We just upgraded to GP 2018 R2.  Fairly uneventful, except for the nooks and cranny's (always gotta watch for them.)  One area that blindsided us was Payroll Integration to Payables (PIP.)

In our previous GP versions (we came from GP 2015 R2) PIP worked for computer checks (of course), but also for manual checks.  As we processed payroll in the new version it became increasingly clear that PIP no longer worked for manual checks.  WTF?

There is not a lot about PIP online, but I found a reference in the GP docs about manual checks not being supported.  I don't know if that's new and they took the feature away or what but it sure doesn't sit right.

Well, being the happy Dex developer I am this just means more work for me.  So off to school we go trying to figure out how to make PIP work for manual checks.

Don't get me wrong PIP is still an external dictionary and would be no fun to hack.  I'm going to spool my own code to make this happen.  And that starts with a whole lot of reverse engineering.

The first issue is where's the data?  Well the GP SDK won't help as PIP is in a separate dictionary.  Opening that DIC file in Dex shows the following tables:

PIP00400 contains the vendors and the next PIP number that will be assigned to PIP transactions.
PIP40100 stores the setup information from the Payroll Vendor Setup window.

I am focusing on PIP40100 now as that contains reference to payroll history in UPR30300 that will contain the manual checks I need to post.  In that table is a column entitled APR_PR_VendorRecordType that I have deduced to contain the following values.

1=Fed Tax
2=State Tax
3=Local Tax
4=Company Deduct
5=Employee Deduct
6=Company Benefit
7=Employee Benefit

Those will point me to the PYRLRTYP values in UPR30300.  It looks like data that posts to payables is summarized by check date.  I'll have more information as I get deeper into the process but wanted to seed this in case someone else was curious.