Skip to Content
author's profile photo Former Member
Former Member

Template for G\L account opening balance

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Feb 19, 2008 at 10:20 AM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

    • 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,

  • author's profile photo Former Member
    Former Member
    Posted on Feb 19, 2008 at 07:54 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 29, 2008 at 11:45 AM

    Thanks

    Its working fine with the above mentioned solutions

    swapnil

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.