...
Table of Contents
| Table of Contents | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Overview
| Info |
|---|
This document version applies to FlowAP Version 3.2.0 and later releases. |
As part of NetSuite’s core processes, existing transactions are locked and restricted for editing, while new transactions cannot be created for any locked or closed period. FlowAP’s conversion process creates a transaction based on the date specified in the XML. Meanwhile, FlowAP’s approval process edits the transaction’s date based on necessity due to system limitations. Due to this, there are instances where the XML’s date falls under an already locked and/or closed period. This page details how FlowAP handles these scenarios and how NetSuite’s configuration regarding date-period mismatch handling plays a key part in this.
NetSuite Preferences
NetSuite has three main preference options that define how date-period mismatch is handled: Allow Transaction Date Outside of Posting Period, Default Posting Period When Transaction Date in Closed Period, and Allow Inventory Transactions Dated Outside the Posting Period. This section will discuss each option and how it affects the overall system behavior.
All three preference options are found through Setup > Accounting > Accounting Preferences.
Allow Transaction Date Outside of Posting Period
This preference is the main setting for handling date-period mismatch. It is a global preference that affects all subsidiaries and all transactions within the system. the following are the available options for this preference:
...
| Note |
|---|
If Allow Transaction Date Outside of Posting Period is set to Disallow, the Default Posting Period When Transaction Date in Closed Period and Allow Inventory Transactions Dated Outside the Posting Period preferences are disabled. |
Default Posting Period When Transaction Date in Closed Period
This preference determines the defaulted period value in cases where a transaction is dated on a closed period.
Current Period - This option is selected to post backdated transactions from a closed accounting period to the current period. This setting is the default.
First Open Period - This option is selected to post backdated transactions from a closed accounting period to the first open accounting period.
Allow Inventory Transactions Dated Outside the Posting Period
This preference determines whether date-period mismatches are allowed for inventory-related transactions.
Check this box to allow dating a transaction outside the posting period.
Clear this box to prevent dating a transaction outside the posting period.
FlowAP Subsidiary Setup
Alongside the NetSuite preferences, three main settings must be configured to properly define the desired behavior whenever a transaction is dated on a closed period: Move Transaction Date When (Conversion), Move Transaction Date When (Approval), and Move Transaction Date To.
General Preference
Move Transaction Date To
This setting is shared between Flow Conversion and Flow Approval. The value of this field dictates the final transaction date in case a transaction is dated on a closed period. Note that the behavior for the conversion occurs upon the creation of the record, while the behavior for the approval occurs each time an approval or a rejection is performed. Lastly, this setting only applies when Move Transaction Date When (Conversion) or Move Transaction Date When (Approval) IS NOT Never.
...
First Day of Current Period - This option takes the first day of the current period and uses it as the transaction date. The current period refers to the posting period of today’s date.
First Day of Earliest Open Period - This option takes the earliest open period and uses the first day of that period as the transaction date.
Conversion Preferences
Move Transaction Date When (Conversion)
This setting is specific to Flow Conversion. This dictates when the transaction date will be moved to a date other than what is indicated in the inbound e-document or FlowAP document during conversion.
Period is Closed - This option requires moving transaction dates if the transaction is dated in a closed period.
Period is A/P Locked - This option requires moving transaction dates if the transaction is dated in a locked period.
Never - This option determines that dates should not be moved. DO NOT USE this option if Allow Transaction Date Outside of Posting Period is set to Disallow.
Approval Preferences
Move Transaction Date When (Approval)
This setting is specific to Flow Approval. This dictates when the transaction date will be moved to a different date.
Date-Period Mismatch Allowed & Transaction Date Period is Closed - Use this option if the transaction date should be moved only when Allow Transaction Date Outside of Posting Period is set to Allow or Warn and the transaction date falls on a Closed period.
Date-Period Mismatch Allowed & Transaction Date Period is A/P Locked - Use this option if the transaction date should be moved only when Allow Transaction Date Outside of Posting Period is set to Allow or Warn and the transaction date falls on a Locked period.
Date-Period Mismatch Disallowed & Transaction Date Period is Closed - Use this option if the transaction date should be moved only when Allow Transaction Date Outside of Posting Period is set to Disallow and the transaction date falls on a Closed period.
Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked - Use this option if the transaction date should be moved only when Allow Transaction Date Outside of Posting Period is set to Disallow and the transaction date falls on a Locked period.
Never - This option determines that dates should not be moved. DO NOT USE this option if Allow Transaction Date Outside of Posting Period is set to Disallow.
Known Use Cases
Conversion
Allow Transaction Date Outside of Posting Period | Default Posting Period When Transaction Date in Closed Period | Allow Inventory Transactions Dated Outside the Posting Period | Move Transaction Date When (Conversion) | Move Transaction Date To | Expected Behavior |
|---|---|---|---|---|---|
Allow/Warn | Current Period | Checked | Period is Closed | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is closed. |
Allow/Warn | Current Period | Cleared | Period is Closed | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is closed. If transaction is inventory-related, transaction date movement will fail. |
Allow/Warn | First Open Period | Checked | Period is Closed | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is closed. |
Allow/Warn | First Open Period | Cleared | Period is Closed | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is closed. If transaction is inventory-related, transaction date movement will fail. |
Allow/Warn | Current Period | Checked | Period is Closed | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is closed. |
Allow/Warn | Current Period | Cleared | Period is Closed | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is closed. If transaction is inventory-related, transaction date movement will fail. |
Allow/Warn | First Open Period | Checked | Period is Closed | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is closed. |
Allow/Warn | First Open Period | Cleared | Period is Closed | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is closed. If transaction is inventory-related, transaction date movement will fail. |
Allow/Warn | Current Period | Checked | Period is A/P Locked | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is locked. |
Allow/Warn | Current Period | Cleared | Period is A/P Locked | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is locked. If transaction is inventory-related, transaction date movement will fail. |
Allow/Warn | First Open Period | Checked | Period is A/P Locked | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is locked. |
Allow/Warn | First Open Period | Cleared | Period is A/P Locked | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is locked. If transaction is inventory-related, transaction date movement will fail. |
Allow/Warn | Current Period | Checked | Period is A/P Locked | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is locked. |
Allow/Warn | Current Period | Cleared | Period is A/P Locked | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is locked. If transaction is inventory-related, transaction date movement will fail. |
Allow/Warn | First Open Period | Checked | Period is A/P Locked | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is locked. |
Allow/Warn | First Open Period | Cleared | Period is A/P Locked | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is locked. If transaction is inventory-related, transaction date movement will fail. |
Allow/Warn | Current Period | Checked | Never | First Day of Current Period | No movement of transaction dates. |
Allow/Warn | Current Period | Cleared | Never | First Day of Current Period | No movement of transaction dates. |
Allow/Warn | First Open Period | Checked | Never | First Day of Current Period | No movement of transaction dates. |
Allow/Warn | First Open Period | Cleared | Never | First Day of Current Period | No movement of transaction dates. |
Allow/Warn | Current Period | Checked | Never | First Day of Earliest Open Period | No movement of transaction dates. |
Allow/Warn | Current Period | Cleared | Never | First Day of Earliest Open Period | No movement of transaction dates. |
Allow/Warn | First Open Period | Checked | Never | First Day of Earliest Open Period | No movement of transaction dates. |
Allow/Warn | First Open Period | Cleared | Never | First Day of Earliest Open Period | No movement of transaction dates. |
Disallow | Current Period | Checked | Period is Closed | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is closed. |
Disallow | Current Period | Cleared | Period is Closed | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is closed. If transaction is inventory-related, transaction date movement will fail. |
Disallow | First Open Period | Checked | Period is Closed | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is closed. |
Disallow | First Open Period | Cleared | Period is Closed | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is closed. If transaction is inventory-related, transaction date movement will fail. |
Disallow | Current Period | Checked | Period is Closed | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is closed. |
Disallow | Current Period | Cleared | Period is Closed | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is closed. If transaction is inventory-related, transaction date movement will fail. |
Disallow | First Open Period | Checked | Period is Closed | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is closed. |
Disallow | First Open Period | Cleared | Period is Closed | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is closed. If transaction is inventory-related, transaction date movement will fail. |
Disallow | Current Period | Checked | Period is A/P Locked | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is locked. |
Disallow | Current Period | Cleared | Period is A/P Locked | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is locked. If transaction is inventory-related, transaction date movement will fail. |
Disallow | First Open Period | Checked | Period is A/P Locked | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is locked. |
Disallow | First Open Period | Cleared | Period is A/P Locked | First Day of Current Period | Transaction Date is moved to the first day of the current period if the posting period is locked. If transaction is inventory-related, transaction date movement will fail. |
Disallow | Current Period | Checked | Period is A/P Locked | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is locked. |
Disallow | Current Period | Cleared | Period is A/P Locked | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is locked. If transaction is inventory-related, transaction date movement will fail. |
Disallow | First Open Period | Checked | Period is A/P Locked | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is locked. |
Disallow | First Open Period | Cleared | Period is A/P Locked | First Day of Earliest Open Period | Transaction Date is moved to the first day of the earliest open period if the posting period is locked. If transaction is inventory-related, transaction date movement will fail. |
Disallow | Current Period | Checked | Never | First Day of Current Period | Not allowed. Cannot save the transaction. |
Disallow | Current Period | Cleared | Never | First Day of Current Period | Not allowed. Cannot save the transaction. |
Disallow | First Open Period | Checked | Never | First Day of Current Period | Not allowed. Cannot save the transaction. |
Disallow | First Open Period | Cleared | Never | First Day of Current Period | Not allowed. Cannot save the transaction. |
Disallow | Current Period | Checked | Never | First Day of Earliest Open Period | Not allowed. Cannot save the transaction. |
Disallow | Current Period | Cleared | Never | First Day of Earliest Open Period | Not allowed. Cannot save the transaction. |
Disallow | First Open Period | Checked | Never | First Day of Earliest Open Period | Not allowed. Cannot save the transaction. |
Disallow | First Open Period | Cleared | Never | First Day of Earliest Open Period | Not allowed. Cannot save the transaction. |
Approval
Valid Use Cases
The latest version of this functionality supports the following scenarios.
Transaction Date Period | Allow Transaction Date Outside of Posting Period | Default Posting Period When Transaction Date in Closed Period |
|---|
Allow Inventory Transactions Dated Outside the Posting Period
Move Transaction Date When (Approval) | Move Transaction Date To | Expected Behavior | |
|---|---|---|---|
| 1 | Closed | Allow/Warn | Current Period |
Checked
Date-Period Mismatch Allowed & Transaction Date Period is |
A/P Locked | First Day of Current Period |
Move Date |
to First Day of Current Period | |||
| 2 | Closed | Allow/Warn | Current Period |
Cleared
Date-Period Mismatch Allowed & Transaction Date Period is |
A/P Locked | First Day of |
Earliest Open Period |
Move Date |
to First Day of Earliest Open Period | ||
| 3 | Closed | Allow/Warn |
Current Period |
Date-Period Mismatch Allowed & Transaction Date Period is Closed | First Day of Current Period |
Move Date |
Allow/Warn
First Open Period
Cleared
to First Day of Current Period | |||||
| 4 | Closed | Allow/Warn | Current Period | Date-Period Mismatch Allowed & Transaction Date Period is Closed | First Day of |
Earliest Open Period |
Move Date |
to First Day of Earliest Open Period | ||
| 5 | Closed | Allow/Warn |
First Open Period |
Checked
Date-Period Mismatch Allowed & Transaction Date Period is |
A/P Locked | First Day of |
Current Period |
Move Date |
to First Day of Current Period | ||
| 6 | Closed | Allow/Warn |
First Open Period |
Cleared
Date-Period Mismatch Allowed & Transaction Date Period is |
A/P Locked | First Day of Earliest Open Period |
Move Date |
to First Day of Earliest Open Period | |||
| 7 | Closed | Allow/Warn | First Open Period |
Date-Period Mismatch Allowed & Transaction Date Period is Closed | First Day of |
Current Period |
Move Date |
to First Day of Current Period | |||
| 8 | Closed | Allow/Warn | First Open Period |
Cleared
Date-Period Mismatch Allowed & Transaction Date Period is Closed | First Day of Earliest Open Period |
Move Date |
If transaction is inventory-related, transaction date movement will fail.
Allow/Warn
Current Period
to First Day of Earliest Open Period | ||||
| 9 | Closed | Disallow | Current Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is A/P Locked | First Day of Current Period |
Move Date |
Allow/Warn
to First Day of Current Period |
Cleared
| 10 | Closed | Disallow | Current Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is A/P Locked | First Day of |
Earliest Open Period |
Move Date |
If transaction is inventory-related, transaction date movement will fail.
Allow/Warn
First Open Period
Checked
to First Day of Earliest Open Period | ||||
| 11 | Closed | Disallow | Current Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is |
Closed | First Day of Current Period |
Move Date |
Allow/Warn
First Open Period
Cleared
to First Day of Current Period | ||||
| 12 | Closed | Disallow | Current Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is |
Closed | First Day of |
Earliest Open Period |
Move Date |
If transaction is inventory-related, transaction date movement will fail.
Allow/Warn
Current Period
to First Day of Earliest Open Period | ||||
| 13 | Closed | Disallow | First Open Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is A/P Locked | First Day of |
Current Period |
Move Date |
Allow/Warn
Current Period
Cleared
to First Day of Current Period | ||||
| 14 | Closed | Disallow | First Open Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is A/P Locked | First Day of Earliest Open Period |
Move Date |
If transaction is inventory-related, transaction date movement will fail.
Allow/Warnto First Day of Earliest Open Period | |||
| 15 | Closed | Disallow | First Open Period |
Date-Period Mismatch Disallowed & Transaction Date Period is Closed | First Day of Current Period | Move Date to First Day of Current Period | ||
| 16 | Closed | Disallow | First Open Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is |
Closed | First Day of Earliest Open Period |
Move Date |
to First Day of Earliest Open Period | ||
| 17 | Locked | Allow/Warn |
Current Period |
Cleared
Date-Period Mismatch Allowed & Transaction Date Period is A/P Locked | First Day of |
Current Period |
Transaction Date is moved to the first day of the earliest open period if the posting period is locked.
Move Date to First Day of Current Period | |||
| 18 | Locked | Allow/Warn | Current Period |
Checked
Date-Period Mismatch |
Allowed & Transaction Date Period is |
A/P Locked | First Day of |
Earliest Open Period |
Move Date to First Day of Earliest Open Period | ||
| 19 | Locked | Allow/Warn |
First Open Period |
Cleared
Date-Period Mismatch |
Allowed & Transaction Date Period is |
A/P Locked | First Day of Current Period |
Move Date to First Day of Current Period | |||
| 20 | Locked | Allow/Warn | First Open Period |
Checked
Date-Period Mismatch |
Allowed & Transaction Date Period is |
A/P Locked | First Day of |
Allow/Warn
First Open Period
Cleared
Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Move Date to First Day of Earliest Open Period | ||||
| 21 | Locked | Disallow | Current Period | Date-Period Mismatch Disallowed & Transaction Date Period is |
A/P Locked | First Day of Current Period |
Setting mismatch. No movement of transaction dates.
Move Date to First Day of Current Period | |||
| 22 | Locked | Disallow | Current Period |
Checked
Date-Period Mismatch Disallowed & Transaction Date Period is |
Allow/Warn
Current Period
Cleared
A/P Locked | First Day of Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Move Date to First Day of Earliest Open Period | ||||
| 23 | Locked | Disallow | First Open Period | Date-Period Mismatch Disallowed & Transaction Date Period is |
A/P Locked | First Day of |
Current Period |
Setting mismatch. No movement of transaction dates.
Move Date to First Day of Current Period | |||
| 24 | Locked | Disallow | First Open Period |
Date-Period Mismatch Disallowed & Transaction Date Period is |
A/P Locked | First Day of Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Allow/Warn
First Open Period
Cleared
Date-Period Mismatch Disallowed & Transaction Date Period is Closed
First Day of Earliest Open Period
Setting mismatch. No movement of transaction dates.
Allow/Warn
Current Period
Checked
Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked
First Day of Current Period
Setting mismatch. No movement of transaction dates.
Allow/Warn
Current Period
Cleared
Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked
First Day of Current Period
Setting mismatch. No movement of transaction dates.
Allow/Warn
First Open Period
Checked
Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked
First Day of Current Period
Setting mismatch. No movement of transaction dates.
Allow/Warn
First Open Period
Cleared
Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked
First Day of Current Period
Setting mismatch. No movement of transaction dates.
Allow/Warn
Current Period
Checked
Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked
First Day of Earliest Open Period
Setting mismatch. No movement of transaction dates.
Allow/Warn
Current Period
Cleared
Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked
Move Date to First Day of Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Allow/Warn
First Open Period
Checked
Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked
First Day of Earliest Open Period
Setting mismatch. No movement of transaction dates.
Allow/Warn
First Open Period
Cleared
Invalid Use Cases
Expected Error Scenarios
Due to system limitations, the following scenarios would result in an error. In these use cases, the dates must be moved to proceed. A change in the configuration is required to continue the rest of the process.
Transaction Date Period | Allow Transaction Date Outside of Posting Period | Default Posting Period When Transaction Date in Closed Period | Move Transaction Date When (Approval) | Move Transaction Date To | Expected Behavior | |
|---|---|---|---|---|---|---|
| 1 | Closed | Disallow | Current Period | Never | First Day of Current Period | Error is prompted. Date must be moved. |
| 2 | Closed | Disallow | Current Period | Never | First Day of Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Allow/Warn
Current Period
Error is prompted. Date must be moved. | |||||
| 3 | Closed | Disallow | First Open Period | Never | First Day of Current Period |
No movement of transaction dates.
Allow/Warn
Current Period
Error is prompted. Date must be moved. | |||||
| 4 | Closed | Disallow | First Open Period | Never | First Day of |
No movement of transaction dates.
Allow/Warn
First Open Period
Checked
Never
First Day of Current Period
No movement of transaction dates.
Allow/Warn
First Open Period
Cleared
Never
Earliest Open Period | Error is prompted. Date must be moved. | ||||
| 5 | Locked | Disallow | Current Period | Date-Period Mismatch Disallowed & Transaction Date Period is Closed | First Day of Current Period |
No movement of transaction dates.
Error is prompted. Date must be moved. | |||
| 6 | Locked | Disallow | Current Period |
Checked
Never
Date-Period Mismatch Disallowed & Transaction Date Period is Closed | First Day of Earliest Open Period |
No movement of transaction dates.
Error is prompted. Date must be moved. | |||
| 7 | Locked | Disallow | Current Period |
Never | First Day of |
No movement of transaction dates.
Allow/Warn
First Open Period
Checked
Current Period | Error is prompted. Date must be moved. | ||||
| 8 | Locked | Disallow | Current Period | Never | First Day of Earliest Open Period |
No movement of transaction dates.
Error is prompted. Date must be moved. | |||
| 9 | Locked | Disallow | First Open Period |
Cleared
Never
Date-Period Mismatch Disallowed & Transaction Date Period is Closed | First Day of |
No movement of transaction dates.
Disallow
Current Period
Checked
Current Period | Error is prompted. Date must be moved. | |||
| 10 | Locked | Disallow | First Open Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is Closed | First Day of |
Earliest Open Period |
Error is prompted. Date must be moved. | ||
| 11 | Locked | Disallow |
First Open Period |
Cleared
Never | First Day of Current Period | Error is prompted. Date must be moved. | |||
| 12 | Locked | Disallow | First Open Period | Never | First Day of |
Setting mismatch. No movement of transaction dates.
Disallow
First Open Period
Checked
Date-Period Mismatch Allowed & Transaction Date Period is Closed
First Day of Current Period
Setting mismatch. No movement of transaction dates.
Disallow
First Open Period
Cleared
Earliest Open Period | Error is prompted. Date must be moved. |
Configuration Error Scenarios
The following scenarios would result in an error due to a mismatch in the configuration. Please make sure to align the configuration between the NetSuite standard preference, Allow Transaction Date Outside of Posting Period, and the FlowAP Subsidiary Setup preference, Move Transaction Date When (Approval).
Transaction Date Period | Allow Transaction Date Outside of Posting Period | Default Posting Period When Transaction Date in Closed Period | Move Transaction Date When (Approval) | Move Transaction Date To | Expected Behavior | |
|---|---|---|---|---|---|---|
| 1 | Closed | Allow/Warn | Current Period | Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked | First Day of Current Period |
Setting mismatch. No movement of transaction dates.
Configuration error prompt displayed. | |||
| 2 | Closed | Allow/Warn | Current Period |
Checked
Date-Period Mismatch |
Disallowed & Transaction Date Period is |
A/P Locked | First Day of Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Configuration error prompt displayed. | |||
| 3 | Closed | Allow/Warn | Current Period |
Date-Period Mismatch |
Disallowed & Transaction Date Period is Closed | First Day of |
Disallow
First Open Period
Current Period |
Setting mismatch. No movement of transaction dates.
Configuration error prompt displayed. | ||||
| 4 | Closed | Allow/Warn | Current Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is Closed | First Day of Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Configuration error prompt displayed. | |||
| 5 | Closed | Allow/Warn | First Open Period |
Cleared
Date-Period Mismatch |
Disallowed & Transaction Date Period is |
A/P Locked | First Day of |
Current Period |
Setting mismatch. No movement of transaction dates.
Disallow
Current Period
Checked
Configuration error prompt displayed. | ||||
| 6 | Closed | Allow/Warn | First Open Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is A/P Locked | First Day of |
Disallow
Current Period
Cleared
Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Configuration error prompt displayed. | ||||
| 7 | Closed | Allow/Warn | First Open Period | Date-Period Mismatch |
Disallowed & Transaction Date Period is |
Closed | First Day of Current Period |
Setting mismatch. No movement of transaction dates.
Configuration error prompt displayed. | |||
| 8 | Closed | Allow/Warn | First Open Period |
Checked
Date-Period Mismatch |
Disallowed & Transaction Date Period is |
Closed | First Day of |
Earliest Open Period |
Configuration error prompt displayed. | ||
| 9 | Closed | Disallow |
Current Period |
Date-Period Mismatch Allowed & Transaction Date Period is A/P Locked | First Day of Current Period |
Configuration error prompt displayed. | |||
| 10 | Closed | Disallow | Current Period |
Date-Period Mismatch Allowed & Transaction Date Period is A/P Locked | First Day of Earliest Open Period |
Setting mismatch. No movement of transaction dates.
Configuration error prompt displayed. | |||
| 11 | Closed | Disallow | Current Period |
Cleared
Date-Period Mismatch Allowed & Transaction Date Period is |
Closed | First Day of |
Current Period |
Configuration error prompt displayed. | ||
| 12 | Closed | Disallow |
Current Period |
Date-Period Mismatch Allowed & Transaction Date Period is |
Closed | First Day of Earliest Open Period |
Configuration error prompt displayed. | |||
| 13 | Closed | Disallow | First Open Period |
Cleared
Date-Period Mismatch Allowed & Transaction Date Period is A/P Locked | First Day of |
Current Period |
Configuration error prompt displayed. | ||
| 14 | Closed | Disallow |
First Open Period |
Date-Period Mismatch |
Allowed & Transaction Date Period is |
A/P Locked | First Day of |
Transaction Date is moved to the first day of the current period if the posting period is closed.
Disallow
Current Period
Cleared
Earliest Open Period | Configuration error prompt displayed. | |||
| 15 | Closed | Disallow | First Open Period | Date-Period Mismatch |
Allowed & Transaction Date Period is Closed | First Day of Current Period |
Transaction Date is moved to the first day of the current period if the posting period is closed.
Configuration error prompt displayed. | |||
| 16 | Closed | Disallow | First Open Period |
Checked
Date-Period Mismatch |
Allowed & Transaction Date Period is Closed | First Day of |
Transaction Date is moved to the first day of the current period if the posting period is closed.
Disallow
First Open Period
Earliest Open Period | Configuration error prompt displayed. | |||
| 17 | Locked | Allow/Warn | Current Period | Date-Period Mismatch Disallowed & Transaction Date Period is |
Disallow
Current Period
A/P Locked | First Day of Current Period |
Transaction Date is moved to the first day of the current period if the posting period is closed.
If transaction is inventory-related, transaction date movement will fail.
Configuration error prompt displayed. | ||||
| 18 | Locked | Allow/Warn | Current Period | Date-Period Mismatch Disallowed & Transaction Date Period is |
A/P Locked | First Day of Earliest Open Period | Configuration error prompt displayed. | ||
| 19 | Locked | Allow/Warn | Current Period | Date-Period Mismatch Disallowed & Transaction Date |
Disallow
Current Period
Period is Closed | First Day of Current Period | Configuration error prompt displayed. | ||||
| 20 | Locked | Allow/Warn | Current Period | Date-Period Mismatch Disallowed & Transaction Date Period is Closed | First Day of Earliest Open Period | Configuration error prompt displayed. |
| 21 | Locked | Allow/Warn | First Open Period | Date-Period Mismatch Disallowed & Transaction Date |
If transaction is inventory-related, transaction date movement will fail.
DisallowPeriod is A/P Locked | First Day of Current Period | Configuration error prompt displayed. | |
| 22 | Locked | Allow/Warn | First Open Period |
Date-Period Mismatch Disallowed & Transaction Date Period |
is A/P Locked | First Day of Earliest Open Period |
Transaction Date is moved to the first day of the earliest open period if the posting period is closed.
Configuration error prompt displayed. | |||
| 23 | Locked | Allow/Warn | First Open Period |
Date-Period Mismatch Disallowed & Transaction Date Period is Closed | First Day of |
Transaction Date is moved to the first day of the earliest open period if the posting period is closed.
If transaction is inventory-related, transaction date movement will fail.
Disallow
Current Period
Checked
Current Period | Configuration error prompt displayed. | |||
| 24 | Locked | Allow/Warn | First Open Period | Date-Period Mismatch Disallowed & Transaction Date Period is |
Closed | First Day of |
Transaction Date is moved to the first day of the current period if the posting period is locked.
Earliest Open Period | Configuration error prompt displayed. | ||
| 25 | Locked | Disallow | Current Period |
Cleared
Date-Period Mismatch |
Disallow
First Open Period
Checked
Allowed & Transaction Date Period is A/P Locked | First Day of Current Period |
Transaction Date is moved to the first day of the current period if the posting period is locked.
If transaction is inventory-related, transaction date movement will fail.
Configuration error prompt displayed. | ||||
| 26 | Locked | Disallow | Current Period | Date-Period Mismatch |
Allowed & Transaction Date Period is A/P Locked | First Day of |
Transaction Date is moved to the first day of the current period if the posting period is locked.
Disallow
First Open Period
Cleared
Earliest Open Period | Configuration error prompt displayed. | |||
| 27 | Locked | Disallow | Current Period | Date-Period Mismatch |
Allowed & Transaction Date Period is |
Closed | First Day of Current Period |
Transaction Date is moved to the first day of the current period if the posting period is locked.
If transaction is inventory-related, transaction date movement will fail.
Configuration error prompt displayed. | |||
| 28 | Locked | Disallow | Current Period |
Checked
Date-Period Mismatch |
Allowed & Transaction Date Period is |
Closed | First Day of Earliest Open Period | Configuration error prompt displayed. | ||
| 29 | Locked | Disallow | First Open Period | Date-Period Mismatch Allowed & Transaction Date |
Disallow
Current Period
Cleared
Period is A/P Locked | First Day of Current Period | Configuration error prompt displayed. | ||
| 30 | Locked | Disallow | First Open Period | Date-Period Mismatch |
Allowed & Transaction Date Period is A/P Locked | First Day of Earliest Open Period |
Transaction Date is moved to the first day of the earliest open period if the posting period is locked.
Configuration error prompt displayed. | |||
| 31 | Locked | Disallow | First Open Period |
Checked
Date-Period Mismatch |
Allowed & Transaction Date Period is |
Closed | First Day of |
Transaction Date is moved to the first day of the earliest open period if the posting period is locked.
Current Period | Configuration error prompt displayed. | ||
| 32 | Locked | Disallow | First Open Period |
Date-Period Mismatch |
Allowed & Transaction Date Period is |
Disallow
Current Period
Checked
Closed | First Day of Earliest Open Period |
Transaction Date is moved to the first day of the earliest open period if the posting period is locked.
If transaction is inventory-related, transaction date movement will fail.
Configuration error prompt displayed. |
System Standard Use Cases
The following scenarios are expected to defer to the system’s standard behavior.
Transaction Date Period | Allow Transaction Date Outside of Posting Period | Default Posting Period When Transaction Date in Closed Period | Move Transaction Date When (Approval) | Move Transaction Date To | Expected Behavior | |
|---|---|---|---|---|---|---|
| 1 | Closed | Allow/Warn | Current Period | Never | First Day of Current Period |
Not allowed. Cannot save the transaction.
System Standard. Move Period to Current Period. | |||
| 2 | Closed | Allow/Warn | Current Period |
Never | First Day of |
Disallow
First Open Period
Cleared
Earliest Open Period |
Not allowed. Cannot save the transaction.
Disallow
First Open Period
Checked
Never
First Day of Current Period
Not allowed. Cannot save the transaction.
System Standard. Move Period to Current Period. | |||||
| 3 | Locked | Allow/Warn | Current Period | Date-Period Mismatch Allowed & Transaction Date Period is Closed | First Day of Current Period |
Not allowed. Cannot save the transaction.
System Standard. Move Period to Current Period. | |||
| 4 | Locked | Allow/Warn | Current Period |
Checked
Date-Period Mismatch Allowed & Transaction Date Period is Closed | First Day of Earliest Open Period |
Not allowed. Cannot save the transaction.
System Standard. Move Period to Current Period. | |||
| 5 | Locked | Allow/Warn | Current Period |
Never | First Day of |
Disallow
First Open Period
Checked
Current Period |
Not allowed. Cannot save the transaction.
System Standard. Move Period to Current Period. | |||||
| 6 | Locked | Allow/Warn | Current Period | Never | First Day of Earliest Open Period |
Not allowed. Cannot save the transaction.
Disallow
First Open Period
Cleared
Never
First Day of Earliest Open Period
System Standard. Move Period to Current Period. |
...
Send an email to support@staria.com for questions or concerns regarding this topic.