JE creation using B0900049

[velasj]

Hi list,

I'm writing a UBE to create Journal Entries into F0911 using B0900049
business function, and I wonder if any of you out there has done something
like this before? I'd appreciate any advice on how and when to use the Begin
Document, Edit Document and End Document. So far I have not been succesful
creating an F0911 record.

Thanks,

Jorge
(610) 341-8213
1-800-341-1606 ext.8213
[email protected]

OW XE AS400

 

[KSmithCPA]

I know the developers out there will frown at this suggestion, but here it is anyway. I assume you already have a report created that you wish to turn into a JE. Why not just dump it into excel and import into the P0911 JE program? Unless it's huge, it should only take a min or two.

Just a suggestion. Peace.

Ken

XE SP 16
Win2000/Oracle 8.1.6.

 

[tom_brown]

Hi Jorge,

I have coded a similar report recently and toyed with the idea of using the
master business functions to perform the inserts to F0911. It took me about
3 seconds to decide to utilise the Z1 processing. That is, I simply
inserted F0911Z1 records from my UBE - only about 9-10 fields require entry,
and these are well documented, and then at the end of my UBE I called the Z1
batch processor.

It worked well, and I had no sleepless nights.

hope this helps.

Tom Brown

 

[Gergely_Pongracz]

Hi!
I created such a report recently.
Place an Open Batch call into your Initialize Section Event.
If you allow proof mode don't call this function but assign something like '999999' for your batch number variable
You should create a level break header and footer if you want to use multiple documents within the batch - the header and footer should correspond to your document levels.
Insert a Begin Doc into the lb header do section
Insert two Edit Line calls into your detail section's Do section with the two account numbers, reversed sign JE Amounts, etc...
Depending on error flags, etc insert an End Document or in case of errors a Clear Work File call into your level break footer Do Section Event (If you want Edit Doc or Summarize Document functionality, place it here too)
Close the Batch in your detail section's End Section event.

Performing these you need to set a lot of flags, try understanding them from the parameter notes (they are quite useful), or see how they are used in R31802 (this is the best JE batch I know) - I did so.

If you need any more help for example parts of the code feel free to contact me personally.
Regards:
Gergely Pongrácz
Synergon, Hungary
[email protected]