Good Afternoon

I've been working on sage 200 for some years now, but haven't had the time to gain knowledge on using sage200 to its full capacity.

It would be good to understand how others process their prepayments through sage 200. Currently my organisation produces the prepayment schedule in excel, and how this is created is very manual. Invoices are input from our purchasing officer, if an invoice is required to be prepaid the officer manually writes this in the narrative with the period the invoice covers. 

At M.E the management accountant then runs a transaction report adding any invoices that have a period in the narrative into the prepayment schedule in excel, this creates the journal that is required each month.

My question is does sage200 have the facility to reduce this manual process, but doesn't create any additional work to the purchasing officer? I've tried to have a look round but all I've found is the function to prepay an individual invoice at a time.

Many thanks