Will those 1326 accounts be hitting the AP lock? H...
# accountingn
Netsuite Tragic
04/02/2021, 9:41 PMWill those 1326 accounts be hitting the AP lock? Has this usually posted as expected on closed AP?
n
NS User
04/03/2021, 2:32 AMThank you. Yes, 1326 accounts are hitting AP lock. We had a override period close permission in the role, but that is been removed last night and the issue started
NS User
04/03/2021, 2:32 AMI am looking for some solution where the custom role should not have this permission and the accounting team should be able to post even the AP is locked
NS User
04/03/2021, 2:34 AMIs there a way to lock a particular account from posting?
NS User
04/03/2021, 2:37 AMHere is little background. We push invoices from coupa to Netsuite for every 15 mins. So accounting team locks AP during the period close and post a manual JEs for the invoices that are not pushed over to netsuite.
NS User
04/03/2021, 2:39 AMas part of this, they lock AP for not posting any transactions to one particular AP account.
NS User
04/03/2021, 2:40 AMi want to understand what is the industry standard for this kind of process or issue
k
Karina
04/03/2021, 5:01 PM@NS User - you do not want to post any manual journals into the main AP account so that reporting integrity would be observed and you would have details supporting your total amounts on BS. that’s why locking AP and posting journals are not connected as far as NetSuite considers it. Same goes for AR account postings
n
NS User
04/04/2021, 8:15 PMThanks Karina for your immediate response. Could please explain more in detail? My team wants to lock AP and still they want to post manual JEs for that current period. Ex: we lock March and then post manual JEs for the same March period. That is when we receive the error “G/L impact of a transaction in a close period cannot be changed.”
k
Karina
04/05/2021, 3:55 PM@NS User - you can post any journal entries after locking AP transactions - except for posting into your AP account(s) used in your AP module. Usually AP accruals are posted into different GL account, for example
n
NS User
04/05/2021, 5:43 PMOk, got it. Thank you very much with your prompt response.
NS User
04/05/2021, 5:53 PMAs i mentioned above, we lock AP as part of the period close activity and then post manual JEs for the bills that are not created/missed from coupa invoice integration. So when we try to post those manual JE that are posting into AP accounts is when it is throwing the error. It seems a standard error only, but I would like to know if there is a solution to fix our problem. Any suggestions/advise can be greatly helpful. Thank you very much
k
Karina
04/05/2021, 6:21 PMThese journals you mention are for accrued AP. Other companies, in fact vast majority of them never use the same account for AP accruals as they do for AP posting invoices. This is done to keep reporting (AP Aging) integrity. I suggest using different account for AP accruals from your regular AP account where you post your actual invoices
n
NS User
04/05/2021, 6:28 PMok, 👍
NS User
04/05/2021, 6:29 PMif we use a different AP account for posting these accrued AP then would it not be locked when we lock AP?