Payables Batch Transaction List report repeats block of transactions

(0) Share

Report

Posted on by Matthew Strong

Need some help here:

We have modified the Payables Batch Transaction List Report in our GP 2013 to add 1 field (Vendor Terms) and change the sort order of the report to Alpha by Vendor. (The reason for editing the report was to assist with a project we are developing that uses GP Integration Manager to import our payables invoices from another SQL backend (our ERP system) into GP Payables.)

Since editing this report, we are encountering an issue where blocks of transactions are being repeated within the report. For example, a block of 5 transactions from one vendor will repeat several times within the report, causing the report's bottom-line totals to be incorrect. The same report may contain a second (, third or more) block of repeated transactions from other vendors as well. The actual payables entries within GP is NOT repeated, so the issue is definitely limited only to the report itself. Additionally, we have the same issue occur in this report when performing manual payables entries AND when importing our payables using Integration Manager.
As the blocks of repeated entries are not limited to one vendor, I don't believe the issue is being caused by something about a specific vendor.

From what I know about SQL queries, I can speculate that this type of repetition can be caused by using an incorrect join when pulling data from various tables. Since we added the vendor terms to the report, I am guessing that whatever join is being used may be causing some rows to repeat when the report is rendered.

Is this something that someone else has perhaps run into in the past?
Does anyone know which stored procedure is being called when this report is run? I would like to try to manually run this report's SP (if possible) and see if we can isolate where the repetition is coming from.

Any other insight or advise would be helpful...

Much appreciate the assistance,
Thank you all in advance,

*This post is locked for comments

All responses (5)

Answers (1)

Matthew Strong 70 on at

Like (0)

Report

RE: Payables Batch Transaction List report repeats block of transactions

Absolutely, just waiting for our acct. dept. to confirm in practice that the fix is successful.
L Vail 65,271 on at

Like (0)

Report

RE: Payables Batch Transaction List report repeats block of transactions

Hi Matthew,

I hope this works well for you. If it does work, please mark your question as answered. This marking will let folks know it's been resolved, and it saves time for those looking for questions to answer. They won't spend time with questions already answered. Also, I get credit for an answer :), and that makes me happy <grin>.

Kind regards,

Leslie
Matthew Strong 70 on at

Like (0)

Report

RE: Payables Batch Transaction List report repeats block of transactions

Leslie,

Thank you for the insight. We've applied some of your sorting suggestions (specifically adding a 2nd field in the Sort By dialogue).

So far we have tested this by re-running a report based on test data that was reliably recreating the problematic results and it looks like everything is now being displayed correctly. We will be deploying the updated customization to our production environment today and testing with actual batches over the next day or so.

Much appreciate the rapid response and valuable insight.

Thank you,
Verified answer

L Vail 65,271 on at

Like (0)

Report

RE: Payables Batch Transaction List report repeats block of transactions

Hi again,

Here's what my screens look like:

The voucher number in the sort comes from the PM Trx Header. You'll need to change the existing Voucher number break field.

Here's the Header Options window of the Voucher Number Header:

I hope this helps.

Kind regards,

Leslie
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Payables Batch Transaction List report repeats block of transactions

Hi,

I need just a little more information, but I just modified my report and it worked fine. I think.

1. Are you getting the Terms ID field from the PM Transaction WORK table?

2. Are you putting it in H2?

3. Did you include the Voucher Number in your sort?

4. Did you change the break field in H2 to be the Voucher Number field you included in the sort?

5. Did you add any additional tables to the report?

Please post back and let us know what the outcome was.

Kind regards,

Leslie