File Upload and AP Report Instructions Upload Data
General Info / Sample Reports Abacus AccountEdge Accpac Adagio Agresso Bellamy Blackbaud Colleague (by Ellucian) Comvida FMS Distrib-u-tec Dynamics (see Great Plains or Sparkrock) Epicor/Eclipse Explorer Great Plains JD Edwards MAIS aka Progress aka Concord Masterworks Munisoft Muniware MYOB (Mind Your Own Business) Navision Netsuite by Oracle Oracle Financials Ormed Pacific Rim PeopleSoft PowerSchool/SRB/TSC/atrieveERP ProfitMaster Canada / Acceco / Transaxion Prosoft Gemini Quickbooks Sage SAP SDS (School District Software) Simply Accounting Sparkrock / MS Dynamics Steel Plus by Bayern Syteline Timberline Vadim Xero

MASTERWORKS

We have two sets of instructions, the first is the easiest and comes from Craig at Masterworks: You may have to be in the AP Module to do this;

  • Go to File -> Export
  • Select Export Paid Invoice File

This will export two files to your Masterworks Temp directory, which is most likely: C:\MW\Temp. Find the two files entitled: APPINVDT.DBF and APPINVDT.CDX

The DBF is the main file we need.

Second (less preferred) instructions, go to Accounts Payable->reports->paid invoices->by tax code; choose tax code, in this particular case, no gst claimed was 00, which gave all items no gst claimed on. We want to see ALL Tax Codes, not just 00's