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 <
[email protected]> 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/