Invoice items awaiting COS postings Dialog
Table Of Contents
The Invoice Items Awaiting Cost of Sales Posting screen is used when Defer Cost of Sales is enabled in Khaos Control.
When Cost of Sales is deferred, Khaos Control does not automatically post stock costs to your nominal accounts and Profit & Loss (P&L) when a sales invoice is issued. Instead, the posting can be reviewed and processed later, giving you the opportunity to:
- Review Cost of Sales values before they are posted.
- Check stock valuations.
- Adjust stock values or overhead costs if required.
- Ensure financial postings are accurate before they affect your accounts.
For information about enabling deferred Cost of Sales, see Defer Cost of Sales.
To learn how to generate this report, see How To: Generate and Analyse the Deferred Cost of Sales Report.
To learn how to post deferred Cost of Sales transactions, see How To: Post a Deferred Cost of Sales.
Accessing the Screen
Open the report from the Accounts Other Actions Menu.
The screen contains:
- Filters and options at the top
- A detailed transaction grid
- A right-click context menu for managing and adjusting Cost of Sales values
Filters and Options
Date From and Date To
Select the date range for the report.
Note:
The Date From field is only used when the report is not restricted to non-posted items.
The Date From field is only used when the report is not restricted to non-posted items.
Show Non-Posted
Default: Ticked
When selected, the report displays only invoice items that have not yet been posted to the accounts.
Hide Excluded
Default: Ticked
When selected, any items marked as excluded are hidden from the grid.
Notes
- If you exclude items using the context menu, the grid does not refresh automatically.
- To refresh the view, untick and re-tick Hide Excluded.
- Excluded items appear with a purple background when this option is unticked.
Understanding the Grid
The grid shows invoice items waiting for Cost of Sales posting.
Sales Invoice Details
These columns display information about the original sales document.
Inv. Code
Displays the invoice document type.
Common prefixes include:
- SI = Sales Invoice
- CN = Credit Note
Inv. Date
The date of the invoice or credit note.
Sk Code
The stock code of the item issued.
Sk Desc
The stock description of the item issued.
Qty
The quantity sold or credited.
This value is always displayed as a positive number. The transaction type is determined by the invoice type:
- Sales Invoice: Stock leaves the business and credits the stock nominal.
- Credit Note: Stock returns and debits the stock nominal.
Individual Stock Item Value
These columns display the unit Cost of Sales values for each stock item.
Issued Sk COS
The stock value per unit at the time the item was issued.
Current Sk COS
The current stock value per unit.
Unit COS Diff
Shows the difference between the original stock value and the current stock value.
Calculation:
Issued Sk COS - Current Sk COS = Unit COS Diff
Invoice Stock Value Totals
These values show the total Cost of Sales impact for the invoice line.
Issued Sk COS
The original Cost of Sales value based on the stock value at the time of issue.
Calculation:
Quantity × Issued Sk COS
If Deferred Cost of Sales was not enabled, this would typically be the value posted automatically.
Current Sk COS
The current Cost of Sales value based on today's stock value.
Calculation:
Quantity × Current Sk COS
This value is normally used when posting deferred Cost of Sales.
Invoice COS Diff
Shows the difference between the original and current total stock values.
Calculation:
Issued Sk COS Total - Current Sk COS Total = Invoice COS Diff
This figure indicates how much the Cost of Sales value has changed since the item was originally invoiced.
It can also help identify whether a correcting journal may be required if you intend to work from the original stock valuation.
Sk COS Post
This is the actual value that will be posted to the Stock - COS nominal account.
The value is calculated using either:
- The stock value at the time of issue, or
- The current stock value
The method used depends on the Use Issued Stock Value setting in:
Value
Displays the net value that will be journalled from:
- Stock
- To Stock - COS
during the deferred Cost of Sales posting process.
Unposted Purchase Invoices
PInvoices
Displays the number of unposted purchase invoices containing the stock item.
This can help identify items where costs may still be changing and may be worth reviewing before posting Cost of Sales.
Context Menu Options
Right-click within the grid to access additional actions.
Colour Legend
Displays a colour key showing how different lines will behave when posted.
Exclude Selected Items
Excludes the selected rows from the report totals.
Excluded lines appear with a purple background.
This is useful when you want to delay posting specific items while continuing with the remaining transactions.
Include Selected Items
Reverses a previous exclusion and returns the selected items to the report totals.
Change Selected Stock Value Source
Use this option to change how Cost of Sales is calculated for the selected items.
Issued Invoice Stock Value
Posts Cost of Sales using the stock value that existed when the item was originally invoiced.
This is the default behaviour when Use Issued Stock Value is enabled in:
Current Stock Value
Posts Cost of Sales using the current stock value.
This is the default behaviour when Use Issued Stock Value is not enabled.
Manual Unit Value
Allows you to enter a custom Cost of Sales value for the selected items.
This overrides all other Cost of Sales calculation methods for those rows.
Default
Resets selected lines back to the system default defined by the Use Issued Stock Value setting.
Clear Selection
Removes the current row selection from the grid in a single action.
Tips
- Review items with large Invoice COS Diff values before posting.
- Check unposted purchase invoices if stock values appear incorrect.
- Use exclusions to hold back specific transactions without delaying the entire posting process.
- If stock costs have changed significantly since invoicing, consider whether a manual adjustment or journal is required before posting.