Sales Financial Date Logic in Nexsyis
This document explains how Nexsyis determines the financial (GL) date for sales transactions and how this impacts sales reporting.
1. Overview
Your company chooses whether the sales financial date is based on the Completed date or the Delivered date.
This setting controls how Nexsyis assigns dates to sales and cost-of-sales transactions.
2. Folder Invoice Date
-
A folder is invoiced when you deliver the vehicle or invoice the estimate.
-
At that time, Nexsyis records the Folder Invoice Date
-
Field:
Contact.InvoiceDate
-
3. Folder Financial Date
-
Nexsyis also creates a Folder Financial Date
-
Field:
Contact.ARGLDate
-
Labeled Sales / Cost of Sales Date in some screens.
-
-
Default behavior:
-
The Folder Financial Date matches the Folder Invoice Date.
-
-
Closed period exception:
-
If the financial period is closed when the invoice is created, the Folder Financial Date is set to the first day of the next open period.
-
4. Additional Invoices on the Same Folder
-
Any new invoices for the folder use the original Folder Invoice Date as their invoice date.
-
The AR Invoice GL Date follows standard Nexsyis GL logic:
-
Equals the invoice date unless that period is closed.
-
If closed, it is set to the first day of the next open period.
-
5. Impact on Sales Reporting
Sales reports include folders that may have:
-
Been completed/delivered in a prior date range, but
-
Had supplements added after a month was closed.
In these cases, only the net difference from the supplements is recorded in the selected reporting period for Sales.
This ensures financial statements reflect updated revenue when additional charges are made after the original delivery month.