Asset Balances

SEarlam66

Member
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
 

collonfox

Member
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/wwwthreads/showflat.pl?Cat=&Board=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/
 

ahb

Member
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)
 
Top