Journal Audit/Export - Revision history

Joel: /* OR Batch No. */

2018-08-02T05:27:50Z

OR Batch No.

← Older revision		Revision as of 05:27, 2 August 2018
Line 18:		Line 18:

	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]]		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]]
	===OR Batch No.===		===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)===

Arvind at 12:30, 26 May 2016

2016-05-26T12:30:17Z

← Older revision		Revision as of 12:30, 26 May 2016
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]]
	===OR Batch No.===		===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.		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.

Arvind: Arvind moved page Journal Audit/Printout to Journal Audit/Export: Change in NEOSYS menu

2016-05-26T11:01:58Z

Arvind moved page Journal Audit/Printout to Journal Audit/Export: Change in NEOSYS menu

← Older revision	Revision as of 11:01, 26 May 2016
(No difference)

Ruku: /* Export Voucher Lines */

2016-04-21T05:45:45Z

Export Voucher Lines

← Older revision		Revision as of 05:45, 21 April 2016
Line 27:		Line 27:
	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''': ~~Export~~ all lines of the vouchers selected as per the above filters.		*'''All''': Exports all lines of the vouchers selected as per the above filters.
	*'''First line only''': ~~Export~~ 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.		*'''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.

Arvind at 13:15, 20 April 2016

2016-04-20T13:15:06Z

← Older revision		Revision as of 13:15, 20 April 2016
Line 13:		Line 13:
	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.		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		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===		===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.
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. The vouchers will be separated by journal type if ~~<b>~~All~~</b> is selected~~		This filter applies to the Print option. The vouchers will be separated by journal type if the Journal Type selected is "All".

	~~#<b>~~Per batch~~</b>~~: Vouchers selected as per the filters will be printed as per their batch.		*'''Per batch''': 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.		*'''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''': Export all lines of the vouchers selected as per the above filters.
			*'''First line only''': Export 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.

Nikhil at 10:31, 26 May 2014

2014-05-26T10:31:19Z

← Older revision		Revision as of 10:31, 26 May 2014
Line 3:		Line 3:
	===Action===		===Action===
	====List====		====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.		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====
	~~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.		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====
	~~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.		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)====
	~~Choosing this~~ option gives a similar report as the Export xls option except that in this spreadsheet, the headers will be missing.		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. ~~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.		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~~. They will be separated by journal type if there are more than one journal types chosen in the filter~~.
	#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~~.		#<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.

Nikhil at 14:01, 20 May 2014

2014-05-20T14:01:31Z

← Older revision		Revision as of 14:01, 20 May 2014
Line 1:		Line 1:
	[[file:journalaudit.jpg\|center\|frame\|Journal Audit]]		[[file:journalaudit.jpg\|center\|frame\|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 <b>All</b> 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
			#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.
			#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.

Vineet at 13:40, 18 January 2012

2012-01-18T13:40:19Z

← Older revision		Revision as of 13:40, 18 January 2012
Line 1:		Line 1:
	[[file:journalaudit.jpg\|center\|frame\|Journal ~~Entry/Query~~]]		[[file:journalaudit.jpg\|center\|frame\|Journal Audit]]

Vineet: Created page with 'Journal Entry/Query'

2012-01-18T13:31:06Z

Created page with 'center|frame|Journal Entry/Query'

New page

[[file:journalaudit.jpg|center|frame|Journal Entry/Query]]