Inbound Purchase Order Acknowledgment Report modification

We have been asked to modify this report by adding the Buyer Name as a filter selection. I have created a new IDO Extension Class that calls the current method (Rpt_InboundPOAcknowledgmentSp) and then read the idocollection and filter the data with the Buyer Name. The problem we are having is that this method has the column name "RowSeq" a total of 3 times due to merging the 3 temporary data tables in the method. We keep getting the error "A column named 'RowSeq' already belongs to this DataTable". Does anyone have any suggestion how to get around this issue?

[View:/cfs-file/__key/communityserver-discussions-components-files/78/error-message.txt:320:240]

Find more posts tagged with

General Discussions

Accepted answers

EricWorcester

Me and another team member figured out a solution to this issue. We created the RowSeq2 and RowSeq3 fields, added them to the IDO, changed the duplicate field names in the IDO method, and changed the Stored Procedure to use those new fields names instead.

All comments

Rene Bottern

Are you sending Field "RowSeq" in the XML?

EricWorcester

No, I am reading the idocollection to get the PO Number from the PO Acknowledgment to get the Buyer Name from the Purchase Order and see if it passes the new Buyer Name filter.

EricWorcester

Copyright © 2025 Infor. All rights reserved.