Journal Audit/Export: Difference between revisions
No edit summary |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 16: | Line 16: | ||
===Period=== | ===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. | 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. | ||
=== | |||
If the journal type chosen is Recurring Journals, then the whole year must be chosen as period, i.e. period 1 to 12. See [[Finance_FAQ#Why_do_I_get_.22No_Journals_Found.22_when_using_Journal_Audit.2FExport_for_Recurring_Journals|Using Journal Audit/Export for recurring journals]] | |||
===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. | 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=== | ===VAT/Tax items only=== | ||
===Breaks(for print)=== | ===Breaks(for print)=== | ||
| Line 27: | Line 30: | ||
This filter applies to the "Export xls" and "xls (no header)" options. | This filter applies to the "Export xls" and "xls (no header)" options. | ||
*'''All''': | *'''All''': Exports all lines of the vouchers selected as per the above filters. | ||
*'''First line only''': | *'''First line only''': Exports only the first line of each voucher selected as per the above filters. This is useful when you want to export invoices for example and do not want to show all the debits and credits to other accounts. | ||
Latest revision as of 05:27, 2 August 2018
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
Choose to view posted journals of a particular journal type e.g. Media Invoices, Purchase Invoices etc. or choose "All" to view posted journals of 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.
If the journal type chosen is Recurring Journals, then the whole year must be chosen as period, i.e. period 1 to 12. See Using Journal Audit/Export for recurring journals
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 the Journal Type selected is "All".
- 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.
Export Voucher Lines
This filter applies to the "Export xls" and "xls (no header)" options.
- All: Exports all lines of the vouchers selected as per the above filters.
- First line only: Exports only the first line of each voucher selected as per the above filters. This is useful when you want to export invoices for example and do not want to show all the debits and credits to other accounts.
