Dynamics GP AP Module Scheduled Payments Notes

Schedule Document Date will be automatically filled in with Original Document General Ledger posting date.  First Invoice document date will be automatically defaulted from the same GL posting date and First Invoice due date will be calculated based on your company payment terms with this specific vendor.  You will need to fill in Schedule Interest rate (annual), number of payments, payment frequency, compound or simple interest, posting accounts.  Then you click Calculate and Amortization table should be available in Payable Amortization Schedule window.  Let’s review some details and procedures:

1. Posting Accounts.  When you post PS credit memo will be automatically created on the amount of the Vendor Invoice minus applied payments (down payment), Account Payable account will be debited (washed off) on the amount of the SP and Payable Offset will be credited on the same amount

2. Batches are not available for SP and you may save individual transaction until further review and posting

3. Post Monthly (or periodic) vendor invoices.  This is done in Purchasing Routines content page, click on Post Scheduled Payments.  Ranges are available by Payment number or Vendor ID, you can use Due Day Cutoff to restrict generation to the recent date only.  When you post Payments Accounts Payable Account is credited on the amount equal the sum of principal and the interest.  Payables Offset is debited on Principal amount and Interest Expense is debited on the amount of the interest.  When you click Post Vendor invoice is created with the transaction type SCHED.  Interesting observation about payment due vendor invoice numbering.  It takes SCH number of the mother document and adds 001, 002 at the end, so you know the relations

4. Voiding SP.  Recommended procedure is to set cutoff date to the future and post all the Payments, then void them one-by-one in Void Open Payables Transactions window – and when all the payments are voided SP is removed from the system.  It is also possible to remove Payments on SQL table level, look at the table description and find PM20400 (header) and PM20401 (lines)

5. Some interesting observations.  There is also SP functionality in Receivable Management module, and what is interesting it is virtually symmetric to the one described in this small paper.  The same procedure is recommended to remove partially posted Payment – generate all of them for the SP and then void – this will take it off the system.  As RM has some specific, SP could be created to Open Item customer type only (not possible for Balance Forward customers).  You do SP in Accounts Receivable, when you are leasing equipment to your customers or if you are in mortgage business

6. Customization considerations.  There are several tools to consider: Microsoft Dexterity, Modifier with VBA.  Typical modified logic scenarios:  you may decide to place an automatic First Document Date restriction (to be something like tree months from the date of Vendor Invoice posting to GL to save on compound interest)

7. If you feel that your concerns are not addressed or your question is not answered, please feel free to contact our office.  Support domestically in the USA, Canada, Mexico and internationally.  This option is possible via Web Sessions, Skype or Phone conferences and direct visits onsite (in the case of the large scale project).  Our consulting team speaks English, Chinese, Portuguese, Spanish, Russian, Filipino.  Feel free to call us 1-866-304-3265, 1-269-605-4904, or email help@efaru.com