Journal Audit/Export

From NEOSYS User Support Wiki
Revision as of 14:01, 20 May 2014 by Nikhil (talk | contribs)
Jump to navigationJump to search
Journal Audit

Action

List

Choosing this option gives a list of posted journals along with details like Journal type, posted batch no. Period, user who saved the batch, date and time of saving the batch, number of vouchers in the batch, number of lines in the batch and voucher numbers in each of the batches listed.

Print

Choosing this option prints the entire list of posted batches that was selected according to the filters. The format of the printout is similar to a journal entry printout.

Export xls

Choosing this option exports the posted voucher data into an Excel spreadsheet (xls file) with the headers of each column. The spreadsheet contains list of vouchers with all details related to vouchers like voucher type, batch no, period, date, control account, account name, Client code, Brand code, Media type etc.

xls (no header)

Choosing this option gives a similar report as the Export xls option except that in this spreadsheet, the headers will be missing.

Company

Company in Finance>Settings is chosen automatically. User can manually enter the company code or use the search icon to choose from list of existing companies to filter unposted batches by a single company. Only one company can be selected at a time.

Journal Type

Choice to view posted journals of a particular journal type e.g. Media Invoices, Purchase Invoices etc. or All journal types

Period

Two fields to enter the starting period and stopping period to filter the results. Same period entered in both fields filters unposted batches for that single period. Leaving this filter blank checks for all available periods.

OR Batch No.

Use a starting batch number and a stopping batch number to filter the results. Either this OR the period filter will be used depending on if the fields are empty or not. If batch no. filter is entered then it takes preference over period filter entered.

VAT/Tax items only

Breaks(for print)

This filter applies to the Print option

  1. Per batch: Vouchers selected as per the filters will be printed as per their batch. They will be separated by journal type if there are more than one journal types chosen in the filter.
  2. Continuous: Vouchers selected as per the filters will be printed continuously. They will be separated by journal type if there are more than one journal types chosen in the filter.