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

How to import Segmentation Chart of Account in DTW?

Hi Experts,

In OACT template, I dont see any Segment0, Segment1, Segment2... in the excel sheet. How can I import segmented GL Accounts into the system via DTW?

Thanks!

Warmest Regards,

Chinho

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2010 at 02:14 AM

    You should have a column called "formatcode"> In this you upload the natural account with the segments with no spaces e.g.

    11000ADMIN00 will be seen as 11000-ADMIN-00. The system will create the _sys codes on upload

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2010 at 02:39 AM

    Dear Lim,

    The first step is to define the account segmentation and segmentation category. For end user of B1 2007A and above, You can use the template available in the ...\Data Transfer Workbench\Templates\Templates\Administration\Setup\Financials.

    After finishing in segment0, segment1, etc setup using dtw, you can now import the Segmented GL account code. The template is available in the folder ...\Data Transfer Workbench\Templates\Templates\Financials\Chart of Accounts.

    The template samples for setup and COA segment are available in the folder ...\Data Transfer Workbench\Templates\Data Preparation Examples\10. Testcase...

    The GL account code is entered in the column formatcode and father account key. The format code is use e.g.

    Fatheraccountkey formatcode

    100000000000000 10.00.000.00

    10.00.000.00 11.00.000.00

    11.00.000.00 11.10.000.00

    11.10.000.00 11.10.001.00/AG/RTL/A

    11.10.000.00 11.10.002.00/AG/RTL/A

    11.10.000.00 11.10.003.00/AG/RTL/A

    11.10.000.00 11.10.004.00/AG/RTL/A

    In the above sample, the segments are AG, RTL and A.

    have a nice try

    JimM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2010 at 01:41 PM

    But you need to use the _SYS code to import this, as Jimmy says, thou is required the _SYS code for segmented accounts

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2010 at 06:17 PM

    Hi Chinho,

    How's your DTW goes? FormatCode is all your need to import Segmentation Chart of Account.

    Thanks,

    Gordon

    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.