Help with PR185 TAPE File (TPR185) Format?

Greetings all,

We are attempting to use the automatic reconciliation job (PR185) to reconcile the payroll bank account. The TAPE file we receive from the bank is in CSV format. I changed the columns and data to fit the format as outlined in the manual. I upload the file without file extension and ran PR185 but from the error log I can tell that the file was not read correctly. I also tried using a space delimited file, also without file extension, with the same results.

Anyone using PR185 care to share their file format/layout. Thanks in advance for any help.

-Ky

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Comments

deanna-plant

We use the PR165 for loading the bank reconciliation file. File is named Tpr165 with no file extension and resides in the %lawdir%prodworkTpr165 folder. Sending you a dummied up sample of what the records look like.

[View:/cfs-file/__key/communityserver-discussions-components-files/18/Tpr165.txt:320:240]

unknown

We also use the PR165, without issue. Fixed width format that is achievable via Excel.

unknown

Thanks, Deanna. Would it be possible to get some column headings so I know what I'm looking at?

unknown

Hi MaryBeth. I know that it's possible what I am asking is for a little more detail on how to achieve it. Thanks.

deanna-plant

Sending your the TAPE file layout (workdef). SERIAL-NBR is the Payment Number

[View:/cfs-file/__key/communityserver-discussions-components-files/18/workdef.docx:320:240]

unknown

Thanks Deanna. That's what's in the manual and what I tried but whenever I load the file its not reading correct. The amounts are all off by the same amount.

Do you use decimals in you amounts field?

unknown

Here is a sample file. End users will copy/paste data from the bank and then provide the output (fixed length) to IT to ftp to the server (users do not have ftp access). Note that you'll want to tweak the file to match the output from your bank so that users do not need to massage the data every time. This may not be perfect, but it works for us. If you need assistance with the formulas, send me your contact info and I can call you.

[View:/cfs-file/__key/communityserver-discussions-components-files/18/UploadPrepTemplate_2D00_TDBANK_5F00_v10.xlsx:320:240]

Here's the KB with the specs. Note: "include two decimal places" means: $10.93 = 1093; $10.9 = 1090; $10 = 1000. Do not include the actual decimal point in the file.

[View:/cfs-file/__key/communityserver-discussions-components-files/18/TPR165_5F00_v10_5F00_file_5F00_layout_5F00_info.pdf:320:240]

Cloudsuite PLM for Process Monthly User Group Meeting_January 2024.zip

Copyright © 2025 Infor. All rights reserved.