Unposted Journals: Difference between revisions
No edit summary |
|||
Line 12: | Line 12: | ||
This option exports the unposted voucher data into an Excel spreadsheet (xls file) with the headers of each column. | This option exports the unposted voucher data into an Excel spreadsheet (xls file) with the headers of each column. | ||
====xls (no header)==== | ====xls (no header)==== | ||
This option gives a similar report as the Export xls option except that in | This option gives a similar report as the Export xls option except that column headers are not present in the spreadsheet. | ||
===Company=== | ===Company=== |
Revision as of 11:23, 21 April 2016
Action
List
This option gives a list of the batches that are unposted along with details like Journal type, unposted 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 unposted batches selected according to the filter. The format of the printout is similar to a journal entry printout.
Validate
This option validates each journal entry selected according to the filter. It checks why a particular batch is unposted and provides validation messages e.g. amounts don’t balance, doesn’t have an intercompany account, OK to post etc.
Post
This option checks if the unposted journals are OK to post and posts them (Action of posting is irreversible and can only by reversed with a reversing journal) if found OK to post. It lists the batches that were posted or not posted along with validation messages e.g. Batch number A-PUR-13 has been posted ok (no errors found), Batch number A-PUR-4-U cannot be posted because of the following errors etc.
Export xls
This option exports the unposted voucher data into an Excel spreadsheet (xls file) with the headers of each column.
xls (no header)
This option gives a similar report as the Export xls option except that column headers are not present in the spreadsheet.
Company
Company in Finance>Settings is chosen automatically. Enter the company code manually 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 unposted 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 Numbers
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.
Export Voucher Lines
Same function as the "Export Voucher Lines" option in the Journal Audit/Printout screen.