Fixing wrongly selected accounts for items in QuickBooks Online

1. Introduction

It sometimes happens that, when you are entering an item in ERPAG (in most cases during the initial setup or data import), you mistakenly select the wrong account.
Usually, such oversight is noticed much later, so it may seem that the correction will be complicated.
The best way to explain this is through an example.

2. Correction in QuickBooks Online

The foundation of QuickBooks Online is a relational database, which means that by changing some of the data, the change also affects most of the account entries connected to that data.
In our example, we had a Purchase Order in ERPAG, as it is shown in the screenshot below.

And we synced that PO with QuickBooks Online:
We got the Bill with its transactions:
We subsequently noticed that the account was incorrect. It was supposed to be ‘’Inventory Final Products’’. In order to resolve the problem in the QuickBooks Online item setup, we changed the account to the appropriate one.
After the change, the results in QuickBooks Online are appropriate.
This way, we’ve solved the problem, but this solution is not very practical if we have a lot of similar issues that should be resolved – changing the accounts one by one changing would take forever.
Since our primary goal is practical implementation, the best solution is to make changes through ERPAG.
3. Correction through ERPAG 
There are two ways to make adjustments to an item in ERPAG.
  • Individually, in the item setup:
  • Through the bulk action, for multiple items at once:
After setting up the account in product and services, all you need to do is to activate “Accounts (Update)” in the sync section.
And that’s it!
ERPAG will check all items in QuickBooks (that have SKUs identical to the ones in ERPAG), and set up their accounts in QuickBooks Online according to the ones that were chosen in ERPAG.
read more:

Start NOW

Read More

Related Posts

How Great Inventory Software Can Help Fight Inflation

In today's rapidly fluctuating economy, businesses face the daunting challenge of fighting inflation. Rising costs can erode profits and disrupt operations, making it essential to adopt strategies that mitigate these impacts. One powerful tool in this battle is...

read more
​ERPAG API – Xero OAuth 2.0 authorization

​ERPAG API – Xero OAuth 2.0 authorization

In this instruction blog, we will describe how to create OAuth 2.0 API keys on your Xero account. These API keys are necessary in order to make API calls from ERPAG via Blockly scripts. The instructions show how the process itself currently looks. If in the meantime...

read more