Copy F0911 records whith Changed Ledger Type

[Zoltan_Gyimesi]

Hi JDEList,

I really hope that somebody can help me.

I would like (have)to copy F0911 records whith Changed Ledger Type and I really hate to create 104 variable and map them into a FetchSingle and map again into an Insert file i/o statement.

Is there any suggestion how can I do it in an other way?

I tried to create a NER BSFN and mapping only the primary key fields + 3 other and hoped that I can figure out easily how to modify the generated C source replacing the data structure of the Insert with the data structure of the FetchSingle to accomplish this task.
Unfortunately I wasn't able to solve my problem this way because the C source handles quite differently the FetchSingle and the Insert statement.

Please, help.

Thanks in advance!

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[BBritain]

Just a thought............Could you do a table copy to a junk environment, delete the records you don't want, change the ledger type, and then have CNC guys do an append to table back to the original environment?

Ben again

 

[BBritain]

Here's another wild idea. Create a Find/Browse which will filter all the records you want, have the Copy Button exit to a Fix/Inspect where on Post Dialog is Initialized you reset the record type (make sure all the key fields have the 'Do Not Clear on Add' option set). Set the Find/Browse grid for multi-select and Copy ER set for Repeat for Grid. You would then Highlight all the grid rows, Click Copy and then hold the Enter key (or Ctrl-O) down for a few years (to ok in the Fix/Inspect). This just might save you from having to map all those fields.

Ben again

 

[pcaenaro]

Zoltan,

just a thought: you could use F0911Z1 to store your new
entries, and then process it to generate you actual entries
in F0911, this way, you don't have to create variables,
except for the LT.

hope this helps

Cheers

Philippe



One World B7333 SP16 AS400

 

[franck_blettner]

You can use a table conversion to do that. But I think the process time of
this batch will be very long if you have many record.

Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 63
E-mail : [email protected]

Current Version : OneWorld B7332 Oracle, RS600
Work on :
Oneworld B7321, B7331, B7332, XE
Platform, UNIX, AS400, NT
Database : Oracle, SQL, DB2


-----Message d'origine-----
De : [email protected] [mailto[email protected]]De la
part de Zoltan_Gyimesi
Envoyé : lundi 28 janvier 2002 21:33
À : [email protected]
Objet : Copy F0911 records whith Changed Ledger Type


Hi JDEList,

I really hope that somebody can help me.

I would like (have)to copy F0911 records whith Changed Ledger Type and I
really hate to create 104 variable and map them into a FetchSingle and map
again into an Insert file i/o statement.

Is there any suggestion how can I do it in an other way?

I tried to create a NER BSFN and mapping only the primary key fields + 3
other and hoped that I can figure out easily how to modify the generated C
source replacing the data structure of the Insert with the data structure of
the FetchSingle to accomplish this task.
Unfortunately I wasn't able to solve my problem this way because the C
source handles quite differently the FetchSingle and the Insert statement.

Please, help.

Thanks in advance!

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
--------------------------
Visit the forum to view this thread at:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=27485
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE Developers mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+



Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 48
E-mail : [email protected]

 

[tombrown]

Zoltan

You could use a table convertor with F0911 as you output and input table. This would save you having to create the variables youself since the data structures are available automatically.

Tom Brown

 

[Zoltan_Gyimesi]

Hi JDEList,

First I would like to thank the answers, hints to Ben, Philippe, Franck and Tom.

I do not know the suggested F0911Z1 solution but I am afraid that it also doesn't fit to my current needs as the others also do not.

I will describe briefly my problem:

We would like to have Date Sensitive Balances (Cost) in Fixed Assets for all Ledger Type, not only for AA.
It seems so that the best solution could be to create a copy of all effected F0911 records in R12800 "Post G/L Entries to Assets UBE" for all F1202 of the effected Asset changing the Ledger Type to the Ledger Type of F1202 (of course, except for AA). This means, that I have to do it for each run of R12800, so the Table Copy solution is really is not a real solution. We also do not want to make the process more complicated for the end users.

I also already considered the Table Conversion solution.
Of course, running TC for each single F0911 record is not a solution.
My thought was to create a work table and place just the key field in it and run the TC only once from R12800 based on the worktable records. I also do not really like this solution, because the "copy" will be happened far from the original F0911 action (error handling!), further it requires to manage a new worktable (selective purge, concurrent runnnings, etc.) and it means also more ERs.

My other idea was to add a conditional section to R12800 and set up the Database Output feature for this section where I have also the fine "Map the Same" option, and call this section for each effected F0911 record setting up the selection properly. The problem with this solution is also the error handling (and I never tried this method and do not know, could it work at all).

After UPDATE2 I had serious problems to retrofit our custom mods on R12855 (see SAR# 5737108), so I do want to minimize the changes on the UBE preventing/minimizing this retrofitting problems for the future.

After a lot consideration, now I am on to use the "hated" solution encapsulated it into Business Function(s).

Of course, any further suggestion, hint will be highly appreciated.

Thanks to all of you again!

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[peter_hamilton]

Zoltan,
it can be done easily in "C".

Just read in the F0911 record, change the Key, and write it out again.

Don't use a NER "c" code as an example, use a pure JDE "c" program to copy the code from, as it's relatively a striaght forward thing.

Cheers,


Peter Hamilton
B7332 SP14, Windows NT, Unix

 

[Zoltan_Gyimesi]

Peter,

Thanks for your reply!

1.) Have you already done something similar (Copy Record in C)?
2.) Can you point to "a pure JDE "c" program to copy the code from"?

I want to use the JDE APIs to manipulate the records.
Do I have to use JDB_FetchKeyed and JDB_InserTable?
Do their require Open and Close?
How can I handle the possible errors?

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[peter_hamilton]

Yeah, done it in "C" before using JDE Api's.
An example can be found in b4301450.

Cheers,


Peter Hamilton
B7332 SP14, Windows NT, Unix