Update Opening Balance & Inventory

Epicor ERP 10
1

Dear Experts, Could you please suggest how to update the opening balances and inventory.

We did the below mentioned activities

  1. New Company Created.
  2. Opening balance already uploaded for January 2019.
  3. Inventory uploaded upto January 2019.
  4. We do not did any transaction till date.

how to update the uploaded Opening Balance & Inventory upto 31st May.

2

So you loaded the Inventory and the GL balances is for Jan. 31st and with no transaction to date.
You could reverse out the number from Jan. 31st and import the new balances. This would be easier from an audit trail versus entering in the change in the balances.

1 Like
3

@LarsonSolutions, Please suggest how would we reverse the number from Jan. 31st.

4

When you load the inventory - put in a negative quantity adjust for the change.
For the GL balances - enter in a credit to reverse a debit and a debit to reverse a credit.

5

Could you please provide the Inventory upload format. For GL balanaces we did same as per mentioned.