Template for G\L account opening balance

[Former Member]

Hi

which is the DTW template for importing G\L account and BP

opening balance.

Are there any default columns that need to be set ?

Regards

swapnil

[former_member186095 · Accepted solution]

Hi,

Just use JE template, oInvoice and oPurchaseInvoice.

What version are you using ?

The default column is record key, linenum, account code, G/L account code and cardcode, etc

let me know your template design before upload

Rgds,

[Former Member · Accepted solution]

Hi

I m using SAP B One 2005 B (7.40.243) SP :00 Pl: 05

These are the fields in JE template

RecordKey LineNum AccountCode AdditionalReference

BaseSum ContraAccount CostingCode Credit Debit

DueDate FCCredit FCCurrency FCDebit GrossValue

LineMemo ProjectCode Reference1 Reference2

ReferenceDate1 ReferenceDate2 ShortName

SystemBaseAmount SystemVatAmount TaxDate

TaxGroup VatAmount VatDate VatLine

Is account code to be treated as G\L account code...?

out of the above mentioned fields which are mandatory for importing ?

can u please explain with help of example

Regards

swapnil

[former_member186095 · Accepted solution]

I am using :

in header:

RecordKey JdtNum AutoVAT DueDate Indicator Memo ProjectCode Reference2 ReferenceDate Reference Series StampTax StornoDate TaxDate

1 tNO 20070207 Transaksi 1 tNO 20070207

2 tNO 20070207 Transaksi 2 tNO 20070207

3 tNO 20070207 Transaksi 3 tNO 20070207

and in line:

RecordKey LineNum AccountCode AdditionalReference BaseSum ContraAccount CostingCode Credit Debit

1 0 130010 161010 1000

1 1 161010 130010 1000

2 0 133000 161010 200

2 1 161010 133000 200

3 0 130110 161015 500

3 1 161015 130110 500

Rgds,

[Former Member]

Thanks

Its working fine with the above mentioned solutions

swapnil

[former_member583013]

Swapnil,

For BP Balances import you will use the oDocuments and oDocument_Lines template available in the respective folders of DTW.

Example: oInvoices for AR Invoices (You would usually import them as Service Invoices so as not to impact inventory)

For Opening GL balance, You would use Journal Entry templates as shown by Jimmy.

Let me know if you need more details

Suda

[Former Member]

Hi

This is what i understood from Jimmy example correct me if i am wrong.

In header.........

Recordkey ......Autovat.......Duedate...........Projectcode......

Reference2........Stamptax........Taxdate

1....tNO....20070207............Transaksi........1.....tNO...............

200070207

I m not sure about last 3 fields(reference2..Stamptax..Taxdate)

In line.................

Recordkey.......LineNum.......Accountcode....Contraaccount......Credit......Debit

1.....0.....130010....161010.........1000

1.....1.....161010.....130010........1000

Is this what i have to do for importing..??

Please do confirm the header items mentioned

swapnil

[former_member583013]

JE Header

RecordKey......AutoVAT....DueDate......ReferenceDate......StampTax.....StornoDate.....TaxDate.......UseAutoStorno......VatDate

1......................tNO.........20070101......20070101..............tNO.............20070101......20070101..........tNO................20070101

JE Lines

RecordKey........LineNum.......AccountCode....BaseSum .......ContraAccount..................Debit...........Credit......VatLine

1.........................0..................*********..........22.50............***************..................16.25............0..............tNO

1.........................1..................*********..........22.50...........***************....................6.25............ 0..............tNO

1.........................2..................*********..........22.50...........***************.....................0.............22.50...........tNO

[Former Member]

Hi suda

i m getting following error in JE header

Atleast one amount is required in the document rows Application-defined or object-defined

swapnil

Edited by: SWAPNIL PATIL on Feb 21, 2008 11:06 AM

[former_member583013]

I think I missed the BaseSum column in the JE Lines.

I have updated my previous message showing this column.

You enter the column total in this column

Suda