Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

Table of Contents
maxLevel6
minLevel1
include
outlinefalse
indent
excludeTable of Contents
styledefault
typelist
printablefalse
class

...

Overview

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.

...

  • 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.

...

  • 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

Closed

A/P Locked

First Day of Current Period

Transaction

Move Date

is moved to the first day of the current period if the posting period is closed.

to First Day of Current Period

2

Closed

Allow/Warn

Current Period

Cleared

Date-Period Mismatch Allowed & Transaction Date Period is

Closed

A/P Locked

First Day of

Current

Earliest Open Period

Transaction

Move 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.

to First Day of Earliest Open Period

3

Closed

Allow/Warn

First Open

Current Period

Checked

Date-Period Mismatch Allowed & Transaction Date Period is Closed

First Day of Current Period

Transaction

Move Date

is moved to the first day of the current period if the posting period is closed.

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

Current

Earliest Open Period

Transaction

Move 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.

to First Day of Earliest Open Period

5

Closed

Allow/Warn

Current

First Open Period

Checked

Date-Period Mismatch Allowed & Transaction Date Period is

Closed

A/P Locked

First Day of

Earliest Open

Current Period

Transaction

Move Date

is moved to the first day of the earliest open period if the posting period is closed.

to First Day of Current Period

6

Closed

Allow/Warn

Current

First Open Period

Cleared

Date-Period Mismatch Allowed & Transaction Date Period is

Closed

A/P Locked

First Day of Earliest Open Period

Transaction

Move 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.

to First Day of Earliest Open Period

7

Closed

Allow/Warn

First Open Period

Checked

Date-Period Mismatch Allowed & Transaction Date Period is Closed

First Day of

Earliest Open

Current Period

Transaction

Move Date

is moved to the first day of the earliest open period if the posting period is closed.

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

Transaction

Move 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

to First Day of Earliest Open Period

9

Closed

Disallow

Current Period

Date-Period Mismatch

Allowed

Disallowed & Transaction Date Period is A/P Locked

First Day of Current Period

Transaction

Move Date

is moved to the first day of the current period if the posting period is locked.

Allow/Warn

to First Day of Current Period

Cleared

10

Closed

Disallow

Current Period

Date-Period Mismatch

Allowed

Disallowed & Transaction Date Period is A/P Locked

First Day of

Current

Earliest Open Period

Transaction

Move 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

to First Day of Earliest Open Period

11

Closed

Disallow

Current Period

Date-Period Mismatch

Allowed

Disallowed & Transaction Date Period is

A/P Locked

Closed

First Day of Current Period

Transaction

Move Date

is moved to the first day of the current period if the posting period is locked.

Allow/Warn

First Open Period

Cleared

to First Day of Current Period

12

Closed

Disallow

Current Period

Date-Period Mismatch

Allowed

Disallowed & Transaction Date Period is

A/P Locked

Closed

First Day of

Current

Earliest Open Period

Transaction

Move 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

to First Day of Earliest Open Period

13

Closed

Disallow

First Open Period

Date-Period Mismatch

Allowed

Disallowed & Transaction Date Period is A/P Locked

First Day of

Earliest Open

Current Period

Transaction

Move Date

is moved to the first day of the earliest open period if the posting period is locked.

Allow/Warn

Current Period

Cleared

to First Day of Current Period

14

Closed

Disallow

First Open Period

Date-Period Mismatch

Allowed

Disallowed & Transaction Date Period is A/P Locked

First Day of Earliest Open Period

Transaction

Move 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

to First Day of Earliest Open Period

15

Closed

Disallow

First Open Period

Checked

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

Allowed

Disallowed & Transaction Date Period is

A/P Locked

Closed

First Day of Earliest Open Period

Transaction

Move Date

is moved to the first day of the earliest open period if the posting period is locked.

to First Day of Earliest Open Period

17

Locked

Allow/Warn

First Open

Current Period

Cleared

Date-Period Mismatch Allowed & Transaction Date Period is A/P Locked

First Day of

Earliest Open If transaction is inventory-related, transaction date movement will fail.

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

Disallowed

Allowed & Transaction Date Period is

Closed

A/P Locked

First Day of

Current

Earliest Open Period

Setting mismatch. No movement of transaction dates.

Move Date to First Day of Earliest Open Period

19

Locked

Allow/Warn

Current

First Open Period

Cleared

Date-Period Mismatch

Disallowed

Allowed & Transaction Date Period is

Closed

A/P Locked

First Day of Current Period

Setting mismatch. No movement of transaction dates.

Move Date to First Day of Current Period

20

Locked

Allow/Warn

First Open Period

Checked

Date-Period Mismatch

Disallowed

Allowed & Transaction Date Period is

Closed

A/P Locked

First Day of

Current

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

ClosedAllow/Warn

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

Closed

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

Closed

A/P Locked

First Day of

Earliest Open Allow/Warn

Current Period

Setting mismatch. No movement of transaction dates.

Move Date to First Day of Current Period

24

Locked

Disallow

First Open Period

Checked

Date-Period Mismatch Disallowed & Transaction Date Period is

Closed

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

Date-Period Mismatch Disallowed & Transaction Date Period is A/P Locked

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

Checked

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

Cleared

Error is prompted. Date must be moved.

4

Closed

Disallow

First Open Period

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

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.

Allow/Warn

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.

Allow/Warn

Error is prompted. Date must be moved.

7

Locked

Disallow

Current Period

Cleared

Never

First Day of

Earliest Open Period

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.

Allow/Warn

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

Earliest Open Period

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

Allowed

Disallowed & Transaction Date Period is Closed

First Day of

Current

Earliest Open Period

Setting mismatch. No movement of transaction dates.

Error is prompted. Date must be moved.

11

Locked

Disallow

Current

First Open Period

Cleared

Date-Period Mismatch Allowed & Transaction Date Period is Closed

Never

First Day of Current Period

Error is prompted. Date must be moved.

12

Locked

Disallow

First Open Period

Never

First Day of

Current Period

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

Date-Period Mismatch Allowed & Transaction Date Period is Closed

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).

Disallow

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

Allowed

Disallowed & Transaction Date Period is

ClosedDisallow

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

Cleared

Date-Period Mismatch

Allowed

Disallowed & Transaction Date Period is Closed

First Day of

Earliest Open

Disallow

First Open Period

Checked

Current Period

Setting mismatch. No movement of transaction dates.

Configuration error prompt displayed.

4

Closed

Allow/Warn

Current Period

Date-Period Mismatch

Allowed Disallow

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

Allowed

Disallowed & Transaction Date Period is

Closed

A/P Locked

First Day of

Earliest Open

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

Allowed

Disallowed & Transaction Date Period is A/P Locked

First Day of

Current

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

Allowed

Disallowed & Transaction Date Period is

A/P LockedDisallow

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

Allowed

Disallowed & Transaction Date Period is

A/P Locked

Closed

First Day of

Current

Earliest Open Period

Setting mismatch. No movement of transaction dates.

Configuration error prompt displayed.

9

Closed

Disallow

First Open

Current Period

Cleared

Date-Period Mismatch Allowed & Transaction Date Period is A/P Locked

First Day of Current Period

Setting mismatch. No movement of transaction dates.

Configuration error prompt displayed.

10

Closed

Disallow

Current Period

Checked

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

A/P Locked

Closed

First Day of

Earliest Open

Current Period

Setting mismatch. No movement of transaction dates.

Configuration error prompt displayed.

12

Closed

Disallow

First Open

Current Period

Checked

Date-Period Mismatch Allowed & Transaction Date Period is

A/P Locked

Closed

First Day of Earliest Open Period

Setting mismatch. No movement of transaction dates.

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

Earliest Open

Current Period

Setting mismatch. No movement of transaction dates.

Configuration error prompt displayed.

14

Closed

Disallow

Current

First Open Period

Checked

Date-Period Mismatch

Disallowed

Allowed & Transaction Date Period is

Closed

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.

Disallow

Current Period

Cleared

Earliest Open Period

Configuration error prompt displayed.

15

Closed

Disallow

First Open Period

Date-Period Mismatch

Disallowed If transaction is inventory-related, transaction date movement will fail.

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

Disallowed

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.

Disallow

First Open Period

Cleared

Earliest Open Period

Configuration error prompt displayed.

17

Locked

Allow/Warn

Current Period

Date-Period Mismatch Disallowed & Transaction Date Period is

Closed

Disallow

Current Period

Checked

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

Closed

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

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 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

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

Period is A/P Locked

First Day of Current Period

Configuration error prompt displayed.

22

Locked

Allow/Warn

First Open Period

Checked

Date-Period Mismatch Disallowed & Transaction Date Period

is ClosedDisallow

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

Cleared

Date-Period Mismatch Disallowed & Transaction Date 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

Current Period

Configuration error prompt displayed.

24

Locked

Allow/Warn

First Open Period

Date-Period Mismatch Disallowed & Transaction Date Period is

A/P Locked

Closed

First Day of

Current Period

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

Disallowed

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

Disallowed

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.

Disallow

First Open Period

Cleared

Earliest Open Period

Configuration error prompt displayed.

27

Locked

Disallow

Current Period

Date-Period Mismatch

Disallowed

Allowed & Transaction Date Period is

A/P Locked

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

Disallowed

Allowed & Transaction Date Period is

A/P Locked

Closed

First Day of Earliest Open Period

Configuration error prompt displayed.

29

Locked

Disallow

First Open Period

Date-Period Mismatch Allowed & 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 Current Period

Configuration error prompt displayed.

30

Locked

Disallow

First Open Period

Date-Period Mismatch

Disallowed If transaction is inventory-related, transaction date movement will fail.

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

Disallowed

Allowed & Transaction Date Period is

A/P Locked

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.

Current Period

Configuration error prompt displayed.

32

Locked

Disallow

First Open Period

Cleared

Date-Period Mismatch

Disallowed

Allowed & Transaction Date Period is

A/P Locked

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.

Disallow

System Standard. Move Period to Current Period.

2

Closed

Allow/Warn

Current Period

Cleared

Never

First Day of

Current

Disallow

First Open Period

Cleared

Never

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.

Disallow

System Standard. Move Period to Current Period.

4

Locked

Allow/Warn

Current Period

Checked

Never

Date-Period Mismatch Allowed & Transaction Date Period is Closed

First Day of Earliest Open Period

Not allowed. Cannot save the transaction.

Disallow

System Standard. Move Period to Current Period.

5

Locked

Allow/Warn

Current Period

Cleared

Never

First Day of

Earliest Open

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

Not allowed. Cannot save the transaction

System Standard. Move Period to Current Period.

...

Send an email to support@staria.com for questions or concerns regarding this topic.