How To: Understand the difference between Issued date and Sales Invoice date

Sales Summary Overview associated pages pages icon Sales Summary Overview pages icon Sales Summary "How Tos"
Accounts associated pages pages icon Accounts Overview pages icon Accounts "How Tos"

Page approved.



It is important to understand the difference between the Issued date and the date the Sales Invoice was created as this affects the information returned in Sales Summary and in the Accounts.

  • The Issued Date is the date the Sales Order was Issued, i.e. moved from Issue to Issued in the Sales Invoice Manager.
  • The Invoice Date is the date can be based on one of the following options in [ System Values | Invoice Management ] and that will be used to update the accounts:
    • Invoice Print Date: the date the invoice was printed in the Sales Invoice Manager.
    • SOrder Delivery Date: the date the order was despatched.
    • SOrder Created Date: the date the invoice was created.
    • Confirmed Ship Date: is the date that the shipment was confirmed, i.e. when the order is moved from the Awaiting Shipping grid to the lower Shipped grid in the Shipping dialog.

The following scenario shows how the different dates are used and displayed in Khaos Control.

A sales order that has the following dates:

  • Order - 25 November 2021
  • Delivery - 26 November 2021
  • Invoice 'printed' - 29 November 2021
  • Shipment Confirmed Date 30 November 2021
  • Issue - 30 November 2021

The Invoice date will therefore be based on the option you have selected in Invoice Date Basis in System Values, in this example it is the date the invoice was printed.

Accounts

In the Accounts area of the system the Invoice Date, in this case 29th November 2021, is used as can be seen below.

P&L

For Month 9 the information for the sale is displayed in the area on the right with the Invoice date.

The P&L showing the example for the difference between Issued date and Sales Invoice date.

Trial Balance and Nominals

Both the Trial Balance and the Nominal popup use the Invoice date:

The Trial Balance showing the example for the difference between Issued date and Sales Invoice date.

The related journal popup showing the example for the difference between Issued date and Sales Invoice date.

VAT Return

For the month of September 2021 the VAT Return will show the sales information as it is based on the Invoice date.

Vat Return example for the difference between Issued date and Sales Invoice date.

Sales Summary

Sales Summary can be configured so that different dates can be used:

  • Issue Date
  • Delivery Date
  • Invoice Date

The information returned will depend on the date range and the type of date selected in the F4 Filter Set as shown below for the sales order scenario described above. This affects how you compare the results in Sales Summary with your P&L; the Invoice date should be used, see How To: Compare Profit and Loss Sales Nominals with Sales Summary.

Date filter date range 1 September 2014 to 30 September 2014

Date Range Filter selected...
Is the information for the order displayed?
Issue Date  red cross 
Delivery Date  green tick 
Invoice Date  green tick 

Date filter date range 01 October 2014 to 31 October 2014

Date Range Filter selected...
Is the information for the order displayed?
Issue Date  green tick 
Delivery Date  red cross 
Invoice Date  red cross 

See Also

Visit KhaosWikiX at https://support.khaoscontrol.com/wiki_kcx/ to see the following:

Contact the Khaos Team