x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 104 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
Natalie Abbott

Prepayments

SUGGESTED
Posted By

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

  • 0
    SUGGESTED

    Hi Natalie,

    I'm unsure if you are using Sage 200 Standard or Sage 200 Professional  but there is a prepayments feature in both versions which will post the monthly journals between the two nominal accounts if the total value and monthly value are known at the time of entering the first transaction. There is further information in the links below around this.

    Sage 200 Standard Prepayments

    Sage 200 Professional Prepayments

    This wouldn't help in determining which invoices require prepayment unfortunately, the way this is currently done by adding a narrative may be the quickest way. However, you could potentially make use of Transaction Analysis Codes if not using already to mark as being prepayment then run a report to pick up only these invoices in the criteria of the report. There may be a report which already includes Transaction Analysis Codes as an option in criteria but may require an amendment to the report otherwise. There is information around these codes in the help files below.

    Sage 200 Standard Transaction Analysis Codes

    Sage 200 Professional Transaction Analysis Codes

     Kind regards,

*Community Hub is the new name for Sage City