Results 1 to 3 of 3

Thread: Asset Balances

  1. #1
    New Member
    Join Date
    Feb 2001
    Location
    Hong Kong
    Posts
    2

    Asset Balances

    Hi List,

    I'm currently using F1201Z1 to do the asset conversion and am a little confused as to how to use this file to get the asset cost and accumulated depreciation figures into FLAPYC in the F1202 file. I'm sure there must be an easy explanation.

    Those of you that have done this before, please put me out of my misery!

    Thanking you in advance.

    Bluffboy

    OW Xe SP 14.2 Unix & Oracle DB

    Bluffboy

    OW Xe SP 14.2 Unix & Oracle DB

  2. #2

    Re: Asset Balances

    As far as I know the F1201Z1 is for the physical record not the cost
    upload. The cost can be brought in four ways:
    1. open each asset and hand type the costs into beginning balance field
    2. use VBA screen scraping to automate the upload from excel to begin
    balance.
    3. copy and paste the excel cost into a prior year end JE in JDE GL and
    post to GL then FA, close the year in FA and it will be in the FLAPYC.
    Include the asset item # or use the unit number with prefix character
    (/ or *) as a part of the paste to the JE . You have to do a separate
    doc for each ledger type so one for AA one for D1 one for D2. I post
    the offsets to the same cost account so the GL balance doesn't change.
    4. Do a GL Z file upload of the costs and post to GL and then FA

    Collon

    --- SEarlam66 <SEarlam@hk.lfdis.com> wrote:
    > Hi List,
    >
    > I'm currently using F1201Z1 to do the asset conversion and am a
    > little confused as to how to use this file to get the asset cost and
    > accumulated depreciation figures into FLAPYC in the F1202 file. I'm
    > sure there must be an easy explanation.
    >
    > Those of you that have done this before, please put me out of my
    > misery!
    >
    > Thanking you in advance.
    >
    > Bluffboy
    >
    > OW Xe SP 14.2 Unix & Oracle DB
    > --------------------------
    > Visit the forum to view this thread at:
    >
    http://198.144.193.139/cgi-bin/wwwth...OW&Number=7484
    >
    > + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
    > This is the JDEList One World / XE Mailing List.
    > Archives and information on how to SUBSCRIBE, and
    > UNSUBSCRIBE can be found at http://www.JDELIST.com
    > + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
    >


    __________________________________________________
    Do You Yahoo!?
    Get email at your own domain with Yahoo! Mail.
    http://personal.mail.yahoo.com/




  3. #3
    New Member
    Join Date
    Mar 2001
    Posts
    11

    Re: Asset Balances

    I've converted Fixed Assets many times before in both World and One World.
    The - "Z", table will only load the asset master and will create balance records for the cost account for each ledger type that you have declared in the default coding. It will not load an opening balance.
    What you will have to do is to copy the beginning balance application and turn it into a batch process. Be careful because the beginning balance program (P12130), is full of bugs. You also have to cater for - "derived", ledgers and make some allowance for overriding derived ledger balances from your input file (Access file or spread sheet).
    I can send you some code that has been recently developed if you like.
    It's quite complex as it has to allow for assets being loaded and then reversed out.

    In summary - the - "Z", file does not load opening balances.

    (TONY BRADY) (ahb@tpg.com.au)




Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.