I would like is there way that we can import the PM Invoice Payment using Integration Mangaer
Announcements
I would like is there way that we can import the PM Invoice Payment using Integration Mangaer
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.
Found in another post that payment is not possible www.gpug.com/.../viewthread
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
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
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
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.
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
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
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
Martin Dráb
601
Most Valuable Professional
Abhilash Warrier
416
Adis
384
Super User 2025 Season 1