RE: Change Custom Field on Closed Invoice

Hi, do you know if it’s possible to update a custom field on an invoice that’s in a closed period?

I’ve got a workflow setting a custom field with the date an invoice is paid. It’s a non-GL impacting change. But if the accounting period is closed, I can’t update the field. Anyone know a way around this?

mmascitto Beginner Asked on April 28, 2020 in Accounting.
Add Comment
1 Answers

The SuiteAnswers topic Accounting Period Close talk about that

“When a period that has been locked has the Allow Non-G/L Changes box checked, users can make changes to posting transactions if the changes do not affect the general ledger. Users must have the Setup permission Allow Non G/L Changes to make such changes. Users with the Override Period Restrictions permission can make changes to posting transaction, whether the changes impact the general ledger or not, in a period that has been locked to transactions.

If users who do not have the Override Period Restrictions permission must make changes to posting transactions that impact the general ledger, transactions must be unlocked for the period. You cannot unlock transactions for a closed period. You must first reopen the period. “

Rookie Answered on April 28, 2020.

Thanks for the reply. The strange thing is I’m using the administrator role. I would think it would have the Override Period Restrictions permission, which apparently would let me set this field.

on April 28, 2020.

I’m having this same problem. The field is one that should not be impacting the G/L, but I keep getting the same error. I have permission to override restrictions, and to post non-G/L changes.

 

Did you ever find a solution?

on March 15, 2021.

Check to see if the date is different than the posting period. Is yes, follow the steps from the below SuiteAnswers article.

To Resolve Notice “The G/L impact of a transaction in a closed period cannot be changed.” When Editing Invoice in Closed Period with Non-G/L Changes

Published 03/19/2020 05:38 PM   |    Updated 07/22/2020 02:35 PM   |    Answer Id: 91582

Applies To

Product:  NetSuite 2020.1

Scenario

Edit Invoice in a Closed Period. They update the a Custom Transaction Line (Non-GL Impacting change) then click Save. They received a notice “The G/L impact of a transaction in a closed period cannot be changed.”

Example:

 

  • Invoice Date = 11/09/2019
  • Invoice Posting Period = Oct 2019
  • Setup > Accounting > Accounting Preferences > General tab > Allow Transaction Date Outside of Posting Period = Disallow

Mismatch of Date and Posting Period causes the error, as this affected by the Accounting Preference and has a GL Impact.

 

Solution

  1. Go to Setup Accounting Accounting Preferences
  2. Go to General tab, Allow Transaction Date Outside of Posting Period: Select Allow
  3. Click Save
  4. Update the Invoice and perform the change on the Custom Transaction Line

on March 23, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.