09 February 2012

Weekly Review: Payables Scheduled Payments

 

A relatively new feature in Dynamics GP is the option to take a payables transaction and split it into multiple payments. This is great for things like loans or leases. The entire transaction can be entered into payables and then paid in installments while accounting for interest.

To set this up, click Purchasing in the Navigation List on the left and pick Scheduled Payments. Use the lookup button to select an existing payables transaction to schedule.

Most of the rest of the screen is straightforward with the schedule date, total to pay over time, simple or compound interest, an interest rate and invoice dates.

image

The Calculate button at the bottom will calculate the new payment. The amortization button shows the amortization scheduled.

image

Then there are three accounts at the bottom. Essentially the accounting for this removes the amounts from payables and puts them in another liability account. Processing the scheduled payment move the liability back into payables and applies the interest expense. The accounts (in order) should be your normal payables account, a different liability account since these are no longer immediately payable and an interest expense account.

Click Post to create the schedule.

Use Post Scheduled Payments in Purchasing | Routines to process scheduled payments.

image

Originally Posted by Mark Polino at 3/15/2010 10:00:00 AM