Integration Manager

(0) Share

Report

Posted on by Smason

495

Is there a way to use integraton manager and create one invoice/Vendor voucher with multiple lines of distribution. Right now the way that we use IM we create an invoice for each distribution line item. We would like to get to the point where we can use it to enter some of our invoices that have 10+ lines of distribution without bogging down our vendor detail with so many invoices. Thanks for your help on this. By the way we are integration into Dynamics GP 2010

Steve Mason

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Yes. You will need to have a data source that contains the payables header information and then another that contains the ditributions. You will use the document number as the linking field. When you create the integration when it comes to the distributions you will click the options tab and tell it to use 'Record Source' and point to the data source containing the distributions.

Was this reply helpful? Yes No
Smason 495 on at

Like (0)

Report

Okay So I have created my Header Source and my Distribution Source. In the Query Relationships I connected the two by the document number. Is it in the destination mapping that would tell IM that this is one invoice with multiple distributions? If so I cannot find where this might be at.

Steve

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You should make sure to "group by" doc number on the header record. That should do it.

Was this reply helpful? Yes No
Smason 495 on at

Like (0)

Report

Okay I have gotten it to work for the most part. I have a document that has 27 lines of distribution. I get a completed voucher that is perfect, although IM is still trying to integrate all of the lines as its own invoice. Is there a way to stop this from happening?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I haven't had to look at an integration like this in a while. On the Distribution source, try grouping on every column that you want. My fault - that's what I meant to type earlier.

IE, if there's an doc number, account number, description, dr, cr, distribution type, etc. you should have a grouping on each of these.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Typically the payables header consist of the doc number, vendor id, doc date and amount. You then have the distributions in a second data source and link on the document number. You define your two data sources and in the first one you will group on the doc number, vendor id, doccdate and amount as they will all be unique. Then your second source will be the detail which will consist of the doc number, gl account, debit and credit amounts. On the distribution portion you will change the option to use Record Source so it grabs each distribution line. So you need the grouping plus the two data sources and you should not get each distribution on a separate line.

Was this reply helpful? Yes No
Verified answer

Bill Campbell 12 on at

Like (0)

Report

If your data source is a single physical file or table which contains all the necessary data to make both the header and the detail required for the entry of the Voucher / Invoice. What we have done in this case is we have created a filter on the Doc Number - something that is unique for each record - and we call that IM Source the Header. Then we create a second source - without filter - that is then linked to the Header by the Doc Number.

When you then go to the Destination Mapping, you use the Header to create, you got it the Header componant and then use the Detail Source when you complete the mapping to the Distribution section of the IM.

We have been sucessful in getting this configuration to work for us many times and we would be happy to assist you as needed.

Was this reply helpful? Yes No
Smason 495 on at

Like (0)

Report

OK so I have been able to create my Integrations for 1 invoice with multiple distributions. What I did was to create a header row in the data file with the distributions rows underneath this. I then put in a filter on the header source that eliminated all of the distribution lines. I then put a filter on the Distribution sounce that eliminiated the header row in the file. Thank you for your help with this.

The next thing that I am working on is trying to figure out if there is a way to have an integration file that has multiple invoices with multiple distributions for each one. Does anyone know if this is possible?

Thank You,

Steve Mason

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

You simply need to group on the invoice number. You will have the invoice number in both files and link on this field. From what you have said the integration you have should work as long as you group and then link on the invoice number field.

Was this reply helpful? Yes No
Verified answer

Bill Campbell 12 on at

Like (0)

Report

When we encountered the unfiltered nature of the data for the first time in IM, we added a SEQUENCE number (Counter Column) to that data. So, when the Invoice number changed, the counter resets to 1. We also made sure that the account number on line one was the AR or AP control and therefore the account that should represent the full amount of the transaction. In this case ALL invoice headers are filtered by the number 1. So your header would only have 1's in that column. Why I mention this is that in 'filtering' the header for the single line works, you do not want to filter the 'detail' - as the header line is in fact really just another line of distribution.

As noted by Richard, as long as you are sorting and linking on the Invoice Number you should not have any issues. Remember that if you sort and group the header on one column or the other, then you will want to be sure to sort the detail on the same column - makes it easier to read on screen. Regardless of sorting, the linking ( I believe ) is the key to the integration.

Was this reply helpful? Yes No