GL Account balance upload

[Former Member]

Hi all,

How we can upload G/L account Balance from client's existing system to SAP B1.

Thanks,

Neetu

[Former Member · Accepted solution]

Hi Neetu,

Firstly, you need to create Initial upload account in your Client's chart of account.

Now to import the G/L balance into SAP B1. To access this window, choose Administration --> System Initialization --> Opening Balances ---> G/L Accounts Opening Balance.

Here, you choose respective drawer like Asset or Liability for upload or you select all of them.

Thanks & Regareds,

Abhishek

[Former Member]

Is it possible to import G/L Accounts and Account balannce through DTW or any other method,..

Thanks,

Neetu

[Former Member]

Hi

When you open 'Administration -> System Initialization -> Opening Balances -> G/L Accounts Opening Balance' and load the opening balances for G/L , SAP inturn creates Journal Entries to transfer credit or debit amounts from a specified opening balance account to one or more G/L accounts.

So you can use the Journal Entry Templates available in the following folder to load opening balances thro DTW:

C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oJournalEntries

[Former Member]

Hi,

How we can upload customer and vendor balance.

Thanks,

Neetu

[Former Member]

Hi Neetu,

It's same as G/L balance upload. You can find BP balance upload just below the G/L balance upload access path.

In this also, you can select all vendor & customer or one at a time.

To access this window, choose Administration --> System Initialization --> Opening Balances --> Business Partners Opening Balance.

Regards,

Abhishek

[former_member583013]

The G/L Account balances can be imported / entered.

If you choose to import using DTW, then they could be imported as Journal Entries.

If you are entering the same within SAP B1, then use the Opening Balances (System Initialization > Opening Balance)

Customer and Vendor balances usually are brought in as open AR and AP transactions which make up the Cust and Vend balances.

Inventory could be importing using the StockTaking templates

[former_member583013]

Neetu,

Please take a look at this