Outstanding Orders
The Goods Delivered not Invoiced icon enables you to display a list of outstanding Sales orders.
For both ledgers:
Each column can be sorted by clicking on the column heading.
The Date Required column displays the date from the detail line of the Orders.
There is an As at option at the foot of the window, the options are Period End and To Date.
When the window is set to As at - Period End, the display will include the values of orders that have had a delivery made, but not invoiced, as at the current period.
The transaction list will exclude STOCK transactions that have invoice and delivery activity that has been processed after the current period. For example: orders invoiced and completed in a future period; orders where deliveries have been made in a future period and orders with part-deliveries and part-invoicing in future periods.
However, the transaction list will include PRICE & TEXT transactions that have invoice and delivery activity processed after the current period. This is because for Price and Text items there is no delivery history available. Price and Text transactions displayed in the list can be excluded from any further processing by changing the YES to NO.
When the window is set to As at - To Date the display will include orders where deliveries have been made, or order lines completed, after the current period.
The Print icon enables you to produce the O/S Orders report and to post a Reversing Journal to transfer the value of the Outstanding Orders into the Nominal Ledger at the Period End.
Preparing the Journal
Sales Ledger
Stock, Price and Text lines will be loaded into the list flagged as YES regardless of the option to Update Stock to Nominal.
You can exclude transactions from the Journal by changing the YES to NO, and include items by changing NO to YES.
Double click a line to change the flag.
Select multiple lines using Ctrl + Click or Shift + Click.
Subtotal by: From this menu you can select to subtotal the report in various ways. From the Output window, you can select to print the report based on the list as subtotalled, otherwise, the report will be printed without subtotalling.
Press Print to run the report and produce the journal.
From the report Output window, you can:
Print the O/S Orders report.
Before printing:
Select to Print based on list as displayed, this may be required if you have made use of the Subtotal by option.
Select the print output.
Post Reversing Journal to update the Nominal Ledger.
If you are posting a Reversing Journal, you can select to Batch the Journal.
Then you should enter a Voucher Ref.
The double entry for the Journal is left blank for you to define the Debit/Credit Nominal Codes in which the outstanding liability/asset will be accrued.
The printed report will be sub totalled by the YES/NO selections made on the O/S Orders window, so that any Journals posted can be reconciled to the report.