cancel
Showing results for 
Search instead for 
Did you mean: 

Offset A/c setup for opening balances import in DTW

Former Member
0 Kudos

Hi All,

I am trying to import opening balances for customers using oInvoices.

There I am using two xls files.

1. Documents

2. Documents_Lines

The Documents_Lines filehas a column named AccountCode, but this the column used for BP GL code.

Where do I set the offset ac code (Suspense A/c code) for offsetting the balance.

I appriciate your time spent on answering this.

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

The AccountCode you will enter here is the Offset Account number. <b>Not the BP G/L.</b>

<b> AccountCode</b>

<b>_SYS00000000336</b>

This _SYS00000000336 is the Account Code of your Offsetting G/L Account.

Let me know if you have further questions.

Suda

Former Member
0 Kudos

Hi Suda,

I have created an offset A/c in Equity drawer under Profit and Loss.

The offset a/c details are 340100 - Suspense Account.

Now can you let me kow the how do I refix the _SYS to the 340100 G/L code.

Answers (2)

Answers (2)

former_member583013
Active Contributor
0 Kudos

Ajit,

So you mean the AcctCode value is 340100. The try to use 340100 in the AcctCode and do not add the _SYS before it.

Thanks

Suda

<b> PS NOTE: Jimmy my name is not 362. I would appreciate if you could maintain some Etiquette in this Forum and not force this to the SDN moderators.</b>

I hope you understand English.

Suda

Former Member
0 Kudos

Hi Suda,

Thanks for your valauable answers.

Now its importing without erprs.

But I would really appriciate if you can help me with this further.

When I look at the journal entries for this particular import the enties are like:

BP A/c Dr 100

Suspense A/c Cr 0

Miscellaneous Expenses 100

I dont know how the Misc. Exp a/c is getting affected, while 100 should be with suspense A/c

Please suggest.

former_member583013
Active Contributor
0 Kudos

If you are saying you are using 340100 in the Account Code field, you would need to replace this with the _SYSxxxx number.

You can get this from the OACT table.

SELECT AcctCode FROM OACT WHERE FORMATCODE = '340100'

the FormatCode column in the OACT table has the G/L number as you see them. You have to the ACCTCODE associated with it.

Suda

Former Member
0 Kudos

Hi Suda,

I tried firing the SQL query and it returns '340100'

I have tried using _SYS340100 in DTW document tempate, but it gives an error.

Error is "No matching records found".

This means its not recognises the _SYS340100 code or the code format I am using is wrong.

Please suggest what exactly should be used.

former_member186095
Active Contributor
0 Kudos

Hello,

I would like to add what 362 points person has said to you.

If you did not use segmented account you do not have to use _sys340100 in DTW template. I will check your requirement and return to this forum

Rgds,

Former Member
0 Kudos

Hi Jimmy,

I am not using Sebmented COA.

Please suggest.

former_member186095
Active Contributor
0 Kudos

Hello,

I suggest to use the account code 340100 but not use sys. so, just try and throw the error message here in this forum so that we could discuss more about it.

Rgds,