Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

PM Invoice Payment import using integration

(0) ShareShare
ReportReport
Posted on by 25

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

Categories:
  • Torey Profile Picture
    5 on at
    RE: PM Invoice Payment import using integration

    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/

  • AkberAli Profile Picture
    25 on at
    RE: PM Invoice Payment import using integration

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

  • AkberAli Profile Picture
    25 on at
    RE: PM Invoice Payment import using integration

    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

  • Robert Yao Profile Picture
    492 on at
    RE: PM Invoice Payment import using integration

    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

  • AkberAli Profile Picture
    25 on at
    RE: PM Invoice Payment import using integration

    pastedimage1637706997088v1.png

    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

    pastedimage1637707172707v3.png

    Is there way we can only load payment of existing voucher 

  • AkberAli Profile Picture
    25 on at
    RE: PM Invoice Payment import using integration

    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.

  • Robert Yao Profile Picture
    492 on at
    RE: PM Invoice Payment import using integration

    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:

    pastedimage1637701552396v1.png

    You need to map those four fields here.

    map the check amount on the header section,

    Rob

  • AkberAli Profile Picture
    25 on at
    RE: PM Invoice Payment import using integration

    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

  • Robert Yao Profile Picture
    492 on at
    RE: PM Invoice Payment import using integration

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans