Open Forum

 View Only
  • 1.  Payments Integration

    Posted Dec 11, 2021 09:18 PM

     Hi,

          I want to Integrate Payments to Vendor .What should  I have to use ? Either Payable Transaction Entry or Payable Manual Payment Entry window ?

    Can someone Explain what is the different between these two Windows.



    ------------------------------
    Noob Gamer
    KaryaTech
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Payments Integration

    TOP CONTRIBUTOR
    Posted Dec 13, 2021 09:13 AM

    Using very OLD SCHOOL example, you typed check to pay the vendor for invoices.  Then you have to enter the manual check to apply to an invoice in Great Plains.  Or, more modern, you paid an invoice with your credit card on the vendor's website.  Then you have to enter the payment to the invoice in Great Plains. 

    With the other you are selecting invoices, by one or more ways in Great Plains and writing the checks from the software. 

    When you use the term "integrate" payments what is that to you?  Are you using third party software outside Great Plains to pay invoices?



    ------------------------------
    Thomas Hill
    Staff Accountant
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Payments Integration

    Posted Dec 13, 2021 12:58 PM
    Hi Thomas,
              I need to Create both Cash Receipts and Payments and I those Those Payment and Receipts should be applied .Which Window suits for this .The source is csv file ,I need to Using Econnect since I have lots of Records and what should I need to do for this ?

    ------------------------------
    Noob Gamer
    Tech
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Payments Integration

    Posted Dec 13, 2021 01:09 PM
    Hi Thomas ,
             I have a Payment Records in CSV File . I need to create those Payments in GP . That is the reason I have used the word 'Integrate'

    ------------------------------
    Noob Gamer
    Tech
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Payments Integration

    TOP CONTRIBUTOR
    Posted Dec 13, 2021 03:07 PM

    There is some confusion, on my part.  Are talking both about payments from Payables to Vendors, as well as payments from Customers to Cash Receipts?

    I understand you want to integrate.  I integrate our monthly invoices from our Data Center in the Sale Module.  All of the integrating I do is with Integration Manager.  I understand eConnect may make things easier.  

    Have you talked with eConnect for sample files for integrating payments?  In Integration Manager there is a sample for Cash Receipts.  It posts the cash to the customer.  But it looks like the applying of the payment to the invoice is manual.  That is where eConnect may go a step further.

    Integration Manager uses two files to capture the information, a Header file and a Distribution file.  Both would be CSV files.  Depending on what is in your CSV file, one file may work for both.  It is that way for when I Integrate payable invoices.



    ------------------------------
    Thomas Hill
    Staff Accountant
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Payments Integration

    Posted Dec 13, 2021 05:01 PM
    Hi Thomas ,
                This helps me a lot, I have Understood the process regarding Receipts using Integration Manager.
    But how do you Integrate Payments with the help of Integration Manger I count not find the Destination for Manual Payments

    ------------------------------
    Noob Gamer
    Tech
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Payments Integration

    TOP CONTRIBUTOR
    Posted Dec 14, 2021 09:21 AM

    When you say you want to integrate manual payments, are these payments for invoices that are not yet in Great Plains?  So you would want to integrate the invoices as having been paid already?  

    Or are these payments you made off-system for invoices that are already in Great Plains?

    Integration Manager has samples for uploading invoices, which can include payment information.  I am not sure about putting in manual payments only.  From the sample, it seems that it would be possible.  Applying the manual payments to existing invoices would still need to be done manually.



    ------------------------------
    Thomas Hill
    Staff Accountant
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Payments Integration

    GPUG ALL STAR
    Posted Dec 13, 2021 09:32 AM
    Do you want to build an integration to automatically do these or are you just wondering how to enter payables manually?  It is very useful to know how to enter payables through the window prior to building an integration, but if you are looking at the integration route, I can assist you if you'd like.  I've built dozens of ETL transformations for integrating information into and out of Dynamics GP.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    GPUG All-Star
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: Payments Integration

    Posted Dec 13, 2021 01:00 PM
    Hi Blair Christensen,
                        I have got Lot of Payments to be created and Applied .What method should I Have to use to do so ?


    ------------------------------
    Noob Gamer
    Tech
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 10.  RE: Payments Integration

    GPUG ALL STAR
    Posted Dec 13, 2021 02:16 PM
    Integrations are nice for handling volume.  Are you trying to process Payables (to vendors) or Receivables (from customers)?  I know its easy to get them mixed up..

    For Vendor Payables, the key information required by the integrations (regardless of tooling) includes the following:
    Voucher Number
    Batch ID (I usually hard code this)
    Document Date (Voucher Date)
    Vendor Number
    Currency ID (I usually hard code this)
    Document Number

    For Receivables, the key information is the following:
    Document Type (usually hard-coded to Invoice)
    Document Number
    Batch ID (I usually hard code this)
    Document Date
    Customer ID
    Currency ID (I usually hard code this)

    These are bare minimums - there is a lot more information you may supply.

    I'd start by making sure you can get all this information into the same place, whether that be on a .csv or in a database table (my preference).  Start by identifying the source of the information and how you can handle it.  Figure out how you're going to transform that original source into what you need (ETL), including supplementing with other data sources and manual entry.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    GPUG All-Star
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role