Goods Received not Invoiced
From the Period End window:
For the Purchase Ledger, the Good Received not Invoiced icon enables you to display a list of outstanding Purchase orders. The transactions in this list exclude future posted values and only show Home value.
For the Sales Ledger, 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
Purchase Ledger
If the System option to Update Stock to Nominal has been selected in the Stock Options:
Price and Text lines will be loaded into the list flagged as YES.
Stock lines will be flagged NO and cannot be changed to YES, the Nominal Ledger will already have been updated for these items.
If Update Stock to Nominal is not selected:
Stock, Price and Text lines will be loaded into the list and flagged as YES for processing.
The Stock Type is shown to ensure that Price and Text lines are easy to identify.
You can exclude the Price and Text 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.