Sage 200 Technical Tips

Sage 200 Technical Tips

In this month's "technical tip" we are focusing on the productivity tool Excelerator.  This provides a means for batch import of data to Sage 200 from Excel and also the extracting of data, editing and posting back to Excel - so a bi-directional data update tool.  Standard Excel functionality is available to extract, update and manipulate data - whilst the Sage 200 data validations rules are applied when posting data.

Read more: Sage 200 Technical Tip - March - Updating Sage 200 using Excel

In this month's "technical tip" we are focusing on Nominal Ledger and reversing the effect of a prepayment. If you have set up a prepayment for an expense and created the related deferred postings which are waiting to update the nominal ledger when the accounting periods are opened.  You then realise this is a mistake and want cancel the effect of the prepayment – you can’t just delete these waiting postings.

Read more: Sage 200 Technical Tip - February - Reversing the effect of a prepayment