Journal Audit/Export: Difference between revisions
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
===Action=== | ===Action=== | ||
====List==== | ====List==== | ||
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==== | ====Print==== | ||
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==== | ====Export xls==== | ||
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)==== | ====xls (no header)==== | ||
This option gives a similar report as the Export xls option except that in this spreadsheet, the headers will be missing. | |||
===Company=== | ===Company=== | ||
Company in Finance>Settings is chosen automatically. | Company in Finance>Settings is chosen automatically. 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=== | ===Journal Type=== | ||
Choice to view posted journals of a particular journal type e.g. Media Invoices, Purchase Invoices etc. or <b>All</b> journal types | Choice to view posted journals of a particular journal type e.g. Media Invoices, Purchase Invoices etc. or <b>All</b> journal types | ||
| Line 20: | Line 20: | ||
===VAT/Tax items only=== | ===VAT/Tax items only=== | ||
===Breaks(for print)=== | ===Breaks(for print)=== | ||
This filter applies to the Print option | This filter applies to the Print option. The vouchers will be separated by journal type if <b>All</b> is selected | ||
#Per batch: Vouchers selected as per the filters will be printed as per their batch | |||
#Continuous: Vouchers selected as per the filters will be printed continuously | #<b>Per batch</b>: Vouchers selected as per the filters will be printed as per their batch. | ||
#<b>Continuous</b>: Vouchers selected as per the filters will be printed continuously. | |||
Revision as of 10:31, 26 May 2014
Action
List
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.
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
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)
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. 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. The vouchers will be separated by journal type if All is selected
- Per batch: Vouchers selected as per the filters will be printed as per their batch.
- Continuous: Vouchers selected as per the filters will be printed continuously.
