PM Transaction import with 2 Purchasing Distributions using Integration Manager

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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)?

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Attaching screens shots of the source preview header then distributions and the mapping.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried separating the debits and credits as well in the source file. Both formats resulted in the same data import problem.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Glad to hear, thanks for the update!

Was this reply helpful? Yes No