Dynamics GP Payables Management Scheduled Payments Notes

Dynamics GP Payables Management Scheduled Payments Notes

In Payables Management module you can implement Scheduled Payment, if you are willing to pay for something with installments, leasing contract, for example. In SP entry form you can pick Original Document Number, which would be Vendor Invoice. 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)

POST COMMENT

Incorporating the Perfect RPO for your Talent Management Systems Understanding the document management version control in a better way Managements,definition of managements How to Get a Hospitality Management Diploma or Certificate through Hospitality Management Courses Debt management: How does the plan work? Knowledge Management Get a 360 Degree View Loans For Bad Credit - Finance For Management Of Credit History How To Learn Content Management System with Easy Anger Management to help Manage Anger Effective Time Management Techniques and Strategies A Tens Machine Can Assist with Pain Management Law Practice Management How To Determine Your Fees What Do Pay Per Click Management Companies Do?