Document Number for Cash Receipt empty using Integration Manager

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I'm Integrating Cash Receipts using Integration Manager. The integration is set up to write back the status of each integration to an internal DB. I'd like to be able to write the Document Number (Receipt) as well, but when I try to query DestinationFields("Receipt") in VBA Script of AfterDocument, it comes up empty. The Receipt field is set to Default, and all the receipts integrated into GP do have the Receipt numbers of the form PYMNTxxxxxxx. How can I get this number in the integration?

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Document Number for Cash Receipt empty using Integration Manager

Hi Leslie,

Thanks for the answer. Since there's no way to read the Receipt from the IM, I decided to just make up my own receipt numbers and use them instead of the default. I'm going for the simplest solution here. If user modifies that number in GP, the link will be broken, but for now I can just instruct the users not to do that (it's a very small team). In the future I'll write more code to follow each document more closely from the GP tables directly.
Verified answer

L Vail 65,271 on at

Like (0)

Report

RE: Document Number for Cash Receipt empty using Integration Manager

Hi,

I think you'll need to query the table. I don't think IM knows what the receipt number is going to be. I believe it's assigned when receipt writes to the table. However, even though it has been imported, it can still be modified or deleted before it is posted. Do you have a way to update your private table in the event something like that happens?

Kind regards,

Leslie