Integration Manager PM Distributions

(0) Share

Report

Posted on by Community Member

I'm creating an integration with a SQL data source to populate a PM transaction. Using a VB field script, I'm specifying a certain distribution account, and is working. My problem is populating the second pay type distribution which will always be the checkbook account.

I've watched examples of creating a header source, and a detail source which makes sense to me, but my data source is only one line per transaction. I'd like to somehow hardcode the second distribution account into every transaction.

Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Mariano Gomez 26,225 on at

Like (0)

Report

RE: Integration Manager PM Distributions

Furthermore, you don't need the field script with the Select...Case statements in VBScript. There's a field mapping capability in IM which I highly encourage you to explore. It's easier to map a new value than to have to change the script each time.

Also, as a courtesy to the folks who help you out, if their response proved to be the answer to your question, please mark it as such.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Integration Manager PM Distributions

That did it. Thank you for sharing your expertise.

Was this reply helpful? Yes No
Verified answer

26P2ER 1,775 on at

Like (0)

Report

RE: Integration Manager PM Distributions

Hello - Under destination mapping, What do you have for the distribution type? Can you try switching it to say constantant and pick "PURCH".

Make sure your rule is default-nonimported.

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Integration Manager PM Distributions

This sounds like it should work but doesn't.

I'll try to be a bit more clear:

I am always specifying (1) distribution account based on another field of data in a VB script which looks like this:

sShopID = Left(SourceFields("shopID"),8)

Select Case sShopID

Case "ACT-BXTR"

sAcct = "5405023130000"

Case "ACT-BKTR"

sAcct = "5405023230000"

Case "ACT-OPTM", "ACT-CASM"

sAcct = "5405023040000"

Case else

sAcct = "None"

end Select

CurrentField.Value = sAcct

The problem is, the balancing distribution line item, which will always be the default checkbook account is missing from the transaction so the line is imported with warnings.

Was this reply helpful? Yes No
Suggested answer

26P2ER 1,775 on at

Like (0)

Report

RE: Integration Manager PM Distributions

Hello GoBrien11

Under the mapping for distributions |Options make sure your choice is default-nonimported for the rule as illustrated below

The rule should read Default-nonimported.

Hope this helps

Was this reply helpful? Yes No