Crediting Expense Report on a Non-A/P Account

Question

Hello NetSuite Support Community,

We recently implemented AirWallex in our company, basically it is a virtual and prepaid bank account. We usually use this for our online subscriptions, which come in as Expense Reports in our NetSuite.

Our issue right now is that, we created the AirWallex account in NetSuite as a Bank type account. When we create Expense Reports, the amount is still being credited into the A/P type account. We also can't select the AirWallex account in the ER, since it is not an A/P account.

Is there some other way we can create an Expense Report that will be credited to the AirWallex account, instead of the A/P account?

Here's the account record for your reference:

Here's the available accounts for ER, which are all A/P type accounts:

The GL Impact that should have been posted to the AirWallex account instead of A/P:

To work around this, we create a Journal Entry that cancels out the transaction posted to the AP account, then transfer it to the AirWallex account.

Micah Timbol-Oracle · Accepted Answer

Hello Jeff Pineda! When you pay the expense report, you can set the account on the bill payment itself that will offset A/P. You wouldn't need to manually create the journal entry anymore.

Katerina Winklerova-Oracle · Accepted Answer

Hello @Jeff Pineda ,

Please, let us know if you have some additional questions regarding this concern.

What I found as well is that we do have created an Enhancement request to use other than AP account for booking the Expense Reports:

89227 Expense Reports > When approved, allow users to select an account other than A/P. i.e., accrued "clearance" account or a prepaid account.

You may vote for this enhancement through SuiteIdeas to increase its points and have it possibly included on NetSuite's future releases.

By marking Yes on the "Did this answer the question?" question, it will tagged this as Accepted Answer. With this, it will also help other members of the community that might encounter the same reported behavior. Thank you very much!