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

Navision

This should generate a proper report:

1. go to AP Batch Manager List
2. select show completed bottom right
3. select post
4. select posted batch control report
5. beside batch no. - enter batch number (ex) AP-JC00089..AP-JC00400 - the batches that are in the date range required.
6. select preview
7. select file - save as HTML (document can be opened in excel if necessary).

Old instructions:

Some Navision users have sent us a report called the Journal Register Report, found under G/L Register.

G/L Register: Source Code: PURCHASES

G/L Register: Journal Register

Not sure if this actually works, but found these instructions somewhere on the internet

The screen below show example financial reports as presented in Navision. The drop down option button in the bottom right hand corner allows the user to export financial reports to Excel.

The screen below shows the resulting financial report in Excel, including an automatic pivot table and field list box to make it easier for end users to create OLAP data cubes, pivot reports, and pivot charts.