Users reached out to me because they are experienc...
# administration
c
Users reached out to me because they are experiencing an odd issue with a process they follow. They are trying to clear out old unapplied payments, but for some of them we are getting a GL impact error The standard process for them is to create a payment in the current period and apply an old unapplied payment against an invoice. In this case it's an Apr 2021 payment against a Feb 2021 invoice, but they get the error "The G/L impact of a transaction in a closed period cannot be changed." I tested it in sandbox and get the same error, but went and tested against a Dec 2021 Payment and a Oct 2021 invoice and it worked just fine. All the periods are closed and it's the same customer so I don't know why there is a difference.
j
Shot in the dark here, but do you have the "Allow non-GL changes" option selected for some periods, but not others?
c
Yes that's on. I thought the same and it was off for those periods. However when i tested it again it still failed
I am going to reach out to Netsuite but it's almost certain that they are going to have to take this offline and call me later
j
Yep, only other thing I would check on is if it's trying to change the date/period upon saving, or if you can get it working through the pay bills function rather than editing the transactions themselves. Also maybe if you have any scripts/workflows running that might be messing with period and/or impact?
r
Are these bills non-functional currency? If your functional currency is USD and the bill/payment is not USD, a realized gain will generate if the FX rate between the two isn't the same. Could be that.
k
there is a GL impact in the process you are doing. You cannot “clear” it, you can only create journals in the current period because “clearing” has GL impact. There is no error, it works as it supposed to.
c
I guess we are confused so why it works for some payments/invs in closed periods but not others. They said this is the process they have been following for years.
If I use a payment from Feb 2022 I can save the payment. But if I pick the Apr 2021 it errors out
Both periods are closed and the payments are identical other than amount and period