A/P Check Posting - Foreign & Domestic values - Where are they populated?

I'm working on an IDO Extension Class to allow us to send a text file to our bank as we are looking to have them print our checks for us. So far, I've been able to pull almost all the needed information out of the SLGlbanks, SLAptrxps, SLVendors and SLVendaddrs IDOs. However, my Net/Gross/Discount values are incorrect. When I look at the RPT_Ap01FRISp, it appears that the values I need are being put into a temp table called tt_checks. Looking at lines ~819-846 I can see the calculations I need to perform, but when I run my code the temp table is obviously not populated. Does anyone know where/how this table gets populated so I can perform the calculations myself?

Also, if anyone has any experience in creating the text files for banks for EFT I'd be interested in talking with you. Thanks!

Find more posts tagged with

Syteline Development

Accepted answers

All comments

Stephen Cena

The current plan we have for implementing this is to convert our accounting process to use Wire Transfers. This will allow CSI to perform all the financial actions required, but not print the checks. I then add a Form for the users to create the required check file to send to the bank.

Legacy Contributor

So, for our banking requirements regarding A/P Checks, we use a Positive Pay process. I took the Bank Reconciliation Report, made a DataView that matches the format requirements, and the user sends it to Excel in order to be "uploaded" to the banks PP system website. We have not had any problems with these totals not lining up to the checks or anything of the nature you describe. Have you tried this avenue already?

Stephen Cena

Part of my problem is I'm not terribly familiar with accounting practices (I am working with the Accounting Dept for assistance as needed). The format the bank wants the file in is 'proprietary' so a Dataview won't work in this case as it would take too much effort to massage the data into the format.

However, I'm looking at the Bank Reconciliation Report, and the output is very close to what I need. The problem still remains that I can't get the Net, Gross and Discount amounts from that data.

IGUG Application 2020.doc

Legacy Contributor

Did you check the A/P Payment transactions (aptrxp)? I think that information, plus the cross-referenced information in the related Voucher record(s) will give you the details.

I'm assuming you are getting the actual check amounts from glbank and are now looking for the check detail.

Stephen Cena

That's where I was looking initially. If my current code is correct, my discount and net values are correct but I don't seem to be getting the right gross one. I can't tell if it's stored or calculated. When I looked at the code, I can see it calculated which is why I assumed that's what I needed to do. I would much rather just pull it out of the IDO if I could.

Copyright © 2025 Infor. All rights reserved.