PM Invoice Payment import using integration

(0) Share

Report

Posted on by AkberAli

I would like is there way that we can import the PM Invoice Payment using Integration Mangaer

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (9)

Answers (0)

Robert Yao 492 on at

Like (0)

Report

I think you can. Have you checked the sample PM transaction in IM? Do you have any sample that we can take a look?

Rob

Was this reply helpful? Yes No
AkberAli 25 on at

Like (0)

Report

Yes, I have a default sample but does not have any check number kind of thing I tried adding the fields but that does not work.

Doc Type Description Vendor Doc Date Doc Number Purchases Amount Check Amount Account Dist Type Debit Credit

1 Purchase of Equipment BEAUMONT0001 6/1/2017 INV0001 $500 $100 000-1300-01 6 $500 $0

1 Purchase of Equipment BEAUMONT0001 6/1/2017 INV0001 $500 $100 000-2100-00 2 $0 $400

1 Purchase of Equipment BEAUMONT0001 6/1/2017 INV0001 $500 $100 000-1100-00 1 $0 $100

1 Purchase of Computer CENTRALC0001 6/5/2017 INV0002 "$1,200 " $0 000-1300-01 6 "$1,200 " $0

1 Purchase of Computer CENTRALC0001 6/5/2017 INV0002 "$1,200 " $0 000-2100-00 2 $0 "$1,200 "

5 Credit on Bill ADVANCED0001 6/10/2017 CRM0001 $40 $0 000-2100-00 2 $40 $0

5 Credit on Bill ADVANCED0001 6/10/2017 CRM0001 $40 $0 000-1300-01 6 $0 $40

Was this reply helpful? Yes No
Robert Yao 492 on at

Like (0)

Report

This is the sample from IM PM transaction, you need to use distribution type 1 for Cash as your payment and map the Check section in Destination Mapping, see below:

You need to map those four fields here.

map the check amount on the header section,

Rob

Was this reply helpful? Yes No
AkberAli 25 on at

Like (0)

Report

Hi Rob,

Yes, I already did that but seems there is an issue. Thank you for your info.

I am sorting out the license issue as for some reason it says the license is invalid.

Was this reply helpful? Yes No
AkberAli 25 on at

Like (0)

Report

How I deal with voucher part, as I don't want to create the voucher and when I am missing those fields it gives me an error that require fields are not there, and when I put the voucher number I get error that document already exists

Is there way we can only load payment of existing voucher

Was this reply helpful? Yes No
Robert Yao 492 on at

Like (0)

Report

You need to either add a letter in the front of your voucher or remove some front zeros in your file or use default as voucher is a required field. You need to use different range of voucher number based on your payable setup option, otherwise you will receive error when you run the IM.

Rob

Was this reply helpful? Yes No
AkberAli 25 on at

Like (0)

Report

I tried but creating the voucher, do you have a sample map or screenshot how the header looks like.

I have vendor, voucher number, document number , doc amount, batch and Voucher Payment as Check amount

Was this reply helpful? Yes No
AkberAli 25 on at

Like (0)

Report

Found in another post that payment is not possible www.gpug.com/.../viewthread

Was this reply helpful? Yes No
Torey 5 on at

Like (0)

Report

Is it possible to import into the INVOICE ENTRY window in GP 2015? I am not talking SOP Invoices but the Invoice Module? Everything I can find is either SOP or RM transactions. The client is not using SOP as it is overkill for what they are needing. Now I have not tested an import to see if it will go into Invoice, as of yet.

https://www.myccpay.pro/

Was this reply helpful? Yes No