Good afternoon!

Has anyone had success with creating payroll transactions using eConnect?  We are trying to use the taCreatePayrollBatchHeaderInsert and  taCreateComputerCheckLineInsert nodes to accomplish this.  The Payroll Batch Header record is working properly but we're confused on the Computer Check Line columns:

• UPRTRXCD (UPR Transaction Code):  This column is required but doesn't explain what should be entered here.  Any ideas?

• TRXHRUNT (Transaction Hours/Units):  This column is required if we pass in certain pay codes.  However, we can't determine where to pass in the pay code.  (There's no "PAYCODE" field that we can find.)

For reference, the MSDN XML Node Reference page is located at http://msdn2.microsoft.com/en-us/library/aa973977.aspx.  We're using eConnect version 9.0

Any help will be greatly appreciated.  Thanks!!!

Joe Cogan
Real Time Intelligence, Inc.

Joe:

I found this under taCreateManualCheckLineInsert:

UPRTRXCD

UPR transaction code; this element is optional if passing any of the transaction types listed, but users must pass a valid transaction code on any transaction type not listed:

4=Federal tax;

5=FICA Social Security tax;

6=FICA Medicare tax;

11=FICA Social Security/tips;

12=FICA Medicare/tips;

13=Federal tax/tips;

14=Uncollected FICA Social Security;

15=Uncollected FICA Medicare

Maybe that'll work.  

The way that I deal with this issue is to do the transaction that I want to in GP manually, and trace it using SQL Profiler to see the tables involved. In this case, I think that it's the UPR10308. Look in there and get the code, and use that.

Does this help?

Thanks Steve!

 I think I'll have to profile the transaction as you suggested.  The only thing that I'm concerned with is the fact that the eConnect payroll transactions don't seem to be closely coupled with the existing SQL tables.  With SOP Invoices, it's very close to 1:1.  (I also have to admit that I have a much better understanding of invoice transactions than payroll transactions!)

Thanks again for your help.  When I get it working, I'll post the transactions on this forum to follow up.

 Joe Cogan

Hi,

  I am too working on Payroll eConnect 9.0 for Manual checks , When I check my XML file its show right.

but through eConnect its Inserting any Data sometime that Data is not avaialable in XML and one Record is inserting 4-5 time.

I don't know how can I solve the problem. any Help on this it will be great

Thanking you.

Sandip Jadhav