PM Transaction import with 2 Purchasing Distributions using Integration Manager

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I'm using 2 source files and grouping buy invoice number on the header. The distributions source file has 2 purchasing distributions (6) and 1 payables distibution (2) per invoice. I cannot get both purchasing distributions to populate.

Does anyone know what I could be doing wrong?

Thanks,

Donnette

*This post is locked for comments

All responses (9)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

Glad to hear, thanks for the update!
Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

Hi AB!

The record set on distributions option's source was header record. I changed it and now I have a successful integration.

THANK YOU!

Donnette
Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

Well that is interesting! On the Options tab, do you have "Use Source Recordset" selected?

Did you have both debits and credits as positive when you separated them out and just selected "Use Source Field"? When you Refresh Columns, what are the datatypes?
Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

I've tried separating the debits and credits as well in the source file. Both formats resulted in the same data import problem.
Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

Attaching screens shots of the source preview header then distributions and the mapping.
Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

Can you send a screenshot of the Source Preview and then the mapping (are you telling IM to determine if positive/negative or do you have separate debit and credit fields)?
Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

Sorting the distribution and accounts worked for populating the the distributions, but now the monetary values for purchasing distributions will not populate.

Any ideas what I need to do next?
Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

1) On thing for sure is you should group by invoice number and vendor id.

2) Pass the entry in Dynamics GP directly and review the entries created by dynamics GP in company table Pm10100 (distribution) and PM10000 (header) and compare with the source file.

3) refer to pmtransctiontype msdn.microsoft.com/.../ff623798.aspx for more info...

Cheers!

Sanjay
Community Member Microsoft Employee on at

Like (0)

Report

RE: PM Transaction import with 2 Purchasing Distributions using Integration Manager

I ran into this issue before and was able to get the distributions imported after setting up a sort, on the distribution source, by Account ASC then Distribution Type DESC - might have to adjust for your accounts but the type 6 account should be imported first.