Hi Accounting-Gurus! I just needed to fix a Vendor Bill that was using the wrong Account Payables Account (the account wasn't available to the transaction subsidiary). Why is it even possible to select one that is not available? Does anyone know how to prevent that/filter the list to only show Accounts that are associated with that Subsidiary?

If the bill is in a closed period you will only be able to change it by opening the period. If that is not an option you will need to credit it off and re-enter the bill with the correct GL Impact. Also, I would look at history on the account. You cannot select any AP account that is not associated with the transaction subsidiary. I would assume the account was changed after the transaction was created.

We are testing in Sandbox, all periods are open. The Account is not associated to the Subsidiary of the transaction but selectable, account was not changed after the transaction was created.

Is the “include children” checkbox (under the subsidiary selector) checked on the account?

No

I am also finding that the AP account does show even if its not available to the sub that is tied to the vendor, but the record errors when you try to save it. I imagine you'd have to create a script to filter the AP Account list to not show the unavailable AP account.

Thanks, at least I know that we're not the only ones observing this. That script should be done by NetSuite, though 😉 If it was a custom field, I could change the filter settings myself...

Yeah I was testing that. Strange behavior for sure. At first I thought it was because I changed an existing AP account to force the subsidiary restriction. So then I created a new one. And the same. I can see all AP Accounts regardless of subsidiary. Training is going to be your friend on that issue.

Thanks for trying to help @Rebecca and @Alex K!

same thing occurs on the item record, you will see all the location on the item but if the location subsidiary mismatch occurs it will error out on the save of the record and you will need to start from scratch, because everything on the item record is deleted.

It's sad that these settings exist for Custom Fields, but standard fields do not support these functions...wish the Voting for Enhancements would actually work here.