Transaction validation added the functionality to look at closed fiscal periods in Validation store and allow you to edit the validated fields when the fiscal period is closed with Excel Add-in for Edit and Audit

10.0.7 added the functionality to look at closed fiscal periods in Validation store transactions and Office Add in will allow you to look at the validation errors and edit the fields with an issue and publish the edited fields back to the Transaction validation failures form

 NOTE:  There is no mass edit in Validation Transaction Failures.  Mass edit must be done at the Statement level.

Transactions created for today are in HQ

Put November period on hold

Run validation

Workspace > Retail store financials > Transaction validation failures

Select a transaction and validation errors:

The transaction business date 11/8/2019 is associated to a closed fiscal period.

click Office Add in, and then click Edit selected transaction.

Open in Excel > Edit selected transaction

Open Excel and sign in.  The first time you log in you may need to select "Trust this add-in"

Change date to an open period

In the Excel file, you modify the appropriate fields and then upload the data back into Retail Headquarters using the Dynamics Excel Add-in publish functionality. Once published, the changes will be reflected in the system. During publish, no validation is done on changes that users make.

Publish

View Audit trail

Dates for today have changed to December

I did not change the ValidationStatus from Error to Processed

Validate store transactions again

Back to Retail store financials workspace

Transaction dated in December is not in the list

When you calculate the statement, you will receive a message about the transactions that are not validated and they will not be added to the statement.  The transaction that I changed the businessdate and transdate is in the statement.

 Only transaction with the changed date is on the statement

Post the statement and you will receive a message about the remaining 9 transaction with a validation error

Selecting Yes will post the statement without the transactions that have a validation error.  Selecting No will allow you to fix the transactions with the validation error.  You can then recalculate and post.