on 10-11-2007 7:17 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.