Importing JE

[Former Member]

Hi,

When are Importing JE's Through DTW it's Coming Origin in

Header JE Here i need Put a OB for Opening Balance. whcih

field i want to enter in template. i tried this fields 1.TransType i

given -2, 2.Details for G/L Accounts Opening Balance. and i

was given OriginalJournal also -2 plz which field i want choose

to get a OB in origin.

Regds,

samapth kumar devunuri.

Teamwork is the ability to work together toward a common vision

[former_member186095]

Sampath,

Create 2 UDFs in the JE header, one for OB and one for -2, if you want to import opening balance using DTW template JE.

Anyway, if it is for G/L opening balance import/migration, you could use COA template. Prior to import, create UDF in the OACT (accounting) to store the opening balance value when you are importing it using COA template. Then assign a FMS in the G/L account opening balance to capture the UDF value into the opening balance column.

Rgds,

[lorna_real]

Hello Samapth,

I have looked at the Data Migration and Opening Balances Implementation Guide.pdf in this link:

https://websmp205.sap-ag.de/~sapidb/011000358700002763252005E.pdf

When G/L Account Balances are loaded via DTW using the Import Journal Entry function, the Origin in the journal entry will be recorded as manual journal entry (column Original Journal in OJDT = 30) not as opening balance (column Original Journal in OJDT =.-2). Please refer to page 17/22 of the document.

When the opening balance is imported in the Administration -> System Initialisation -> Opening Balances -> G/L Accounts Opening Balance, the Origin of an opening balance journal will be u2018OBu2019 and the journal number will be u2018-2u2019. This helps you identify/differentiate the sources of the journal entries.

I hope the above helps.

Regards,

Lorna Real