Microsoft Dynamics GP 2016 - Payables Credit Card Payment

POSTING PROCESS:

When posting the checkrun, the below will happen:

1.  The vendor's invoices will be offset by a payment record created, and both will move to history as normal.

Note:  If you select the Payment record and drill back on the DOCUMENT NUMBER link, you will see the 'credit card' payment method. 

2. The system will then look to see what Vendor ID is linked to the Card name used in the batch (See Credit Card setup screenprint above), and create open invoices on this credit card vendor (one for each vendor payment in GP 2018/GP18.).  The vendor ID is displayed in the Transaction description field for each open invoice created.  (The values of A1 and A2 are the sample vendor names used in this illustration.) 

Note: In GP versions prior to March 2016, the system created one lump-sum invoice on the credit card vendor for all the vendor payments in the cc batch.   In the March 2016 path release, an enhancement was made to add the Vendor ID and voucher number (for the vendor payment record) to the Transaction description line and create one invoice per cc vendor per payment created.  This means if 10 vendors were paid in the credit card batch, then 10 payment records are created on the vendors to apply to the invoices and move to history and also 10 individual invoices are created on the cc vendor. 

3.  Now when you generate a checkrun to pay the credit card vendor, the payment to the credit card vendor will update the Checkbook ID in Bank Rec for the lump sum payment made. 

4.  If you need any reporting by Vendor name for the credit card batch, you would need to use custom reporting. Here are a few other ideas to get reporting by vendor name: 

                    a.  Create a Smartlist on the PM30200 PM Transaction history table, and restrict to the Audit trail code of the batch.  Export the results to Excel and sort it however you want.

                    b. The Transaction History Detail report has a sort by Vendor ID (but not by Vendor name) if that is acceptable.  Go to Reports | Purchasing | History.  Select the Transaction history detail report and click NEW.  Name it.  Set the report options as needed including, the sort by to Vendor ID, and the Range by Audit trail code and insert in the TRXSORCE from the posting journal. 

------------------------------------------------

NOTE:  Vendors set up for EFT payment processing may not pull into the credit card batch.  This is by design, as it is assumed that a vendor would use one or the other payment type and not both.  (To get their invoices to pull into a credit card type batch, you could remove the vendor's EFT banking information (SY06000) and then they will pull.)

RESOURCES: