Data loss after Journal Voucher Posting

system · April 5, 2011, 2:19am

Hi Friends;

Eagerly waiting for a solution for the below problem.

Regards

Sreejith J

________________________________
From: Sreejith Jaganathan <sreesvantagedoubts@...>
To: vantage@yahoogroups.com
Sent: Mon, April 4, 2011 12:20:49 PM
Subject: Re: [Vantage] Data loss after Journal Voucher Posting

Hi Friends;

As a solution for the doubt raised by me I tried doing the below procedure but I

was not successful. Kindly please help me to sort out the issue

01. Customized the Journal Entry Transaction. Created a text field to enter the
JV Reference number. Assigned the datasource as GLJRNHED.CHARACTER01

02. Created a method directive GLJournalEntry.Update

03. Created a new PRE-PROCESSING

CONDITION is - the GLJrnHed.Character01 field of the changed row is not equal to

the "" value

ACTION is set the GLJrnDtl.Character01 field of the changed row to the
"ttGLJrnHed.Character01" value

After setting the above said when I did the Journal Entry I found that the
Reference number I am mentioning on the GLJRNHED.CHARACTER01 is not getting
written to GLJrnDtl.Character01.

I tried the same with POST-PROCESSING also bu the result was the same.

I hope that I had been clear to explain my problem. Any help for the above would

be highly appreciable.

Regards

Sreejith J

________________________________
From: Ephraim Feldman <effgroups@...>
To: vantage@yahoogroups.com
Sent: Tue, March 29, 2011 6:43:23 PM
Subject: Re: [Vantage] Data loss after Journal Voucher Posting

Here is the description of the table in data dictionary:

GLJrnHed
General Ledger Journal Entry Header. This is Parent file to the GLJrnDtl.
These records are only created/used by the G/L journal entry programs. They
are deleted during the posting process.

so i guess no choice but to store them in GLJrnldtl

Ephraim

On Tue, Mar 29, 2011 at 10:25 AM, Sreejith Jaganathan <
sreesvantagedoubts@...> wrote:

>
>
> First of all I would like to thank Mr. Ephraim Feldman and Ms. Linda to
> answer
> my query.
>
> Initially the key field property was set as FALSE. After receiving your
> mail I
> changed it and tested the transaction but still I didn't find the posting
> being
> done for the value entered in the customized field.
>
> I am also trying the way suggested by Mr. Ephraim Feldman. Hope to get
> thru. If
> there is any easy way then please do let me know.
>
> Regards
>
> Sreejith J
>
> ________________________________
> From: Linda Lowney <llowney@...>
> To: vantage@yahoogroups.com
> Sent: Tue, March 29, 2011 5:49:12 PM
> Subject: RE: [Vantage] Data loss after Journal Voucher Posting
>
>
> Did you set the Key Field property to true?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Sreejith Jaganathan
> Sent: Tuesday, March 29, 2011 8:06 AM
> To: Vantage Group
> Subject: [Vantage] Data loss after Journal Voucher Posting
>
> Hi Friends;
>
> Any help for the below said. The help is required very badly.
>
> Regards
>
> Sreejith J
>
> Hello Friends;
>
> I am facing a problem with JV Postings. Let me explain what I did
>
> I customized the JV Entry form. I created a new label (Text on the label
> is [ACC
>
> REF NUMBER]) and a text box. The data source for the text box was given
> as
> GLJournalHed and the data field as CHARACTER01.
>
> When the data entry is done in the JE transaction I observed that the
> data
> entered in the customized field is correctly getting stored but after
> the
> posting I am not able to find the data entered by me in the customized
> field.
>
> I was not able to trace out where the data has gone. Could any body
> please let
> me know what to do in order to track down the data or get it posted
> correctly
> with all the data entered initially.
>
> Regards
>
> Sreejith J
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · March 29, 2011, 6:24am

Hello Friends;

I am facing a problem with JV Postings. Let me explain what I did

I customized the JV Entry form. I created a new label (Text on the label is [ACC
REF NUMBER]) and a text box. The data source for the text box was given as
GLJournalHed and the data field as CHARACTER01.

When the data entry is done in the JE transaction I observed that the data
entered in the customized field is correctly getting stored but after the
posting I am not able to find the data entered by me in the customized field.

I was not able to trace out where the data has gone. Could any body please let
me know what to do in order to track down the data or get it posted correctly
with all the data entered initially.

Regards

Sreejith J

[Non-text portions of this message have been removed]

system · March 29, 2011, 8:06am

Hi Friends;

Any help for the below said. The help is required very badly.

Regards

Sreejith J

Hello Friends;

I am facing a problem with JV Postings. Let me explain what I did

I customized the JV Entry form. I created a new label (Text on the label is [ACC

REF NUMBER]) and a text box. The data source for the text box was given as
GLJournalHed and the data field as CHARACTER01.

When the data entry is done in the JE transaction I observed that the data
entered in the customized field is correctly getting stored but after the
posting I am not able to find the data entered by me in the customized field.

I was not able to trace out where the data has gone. Could any body please let
me know what to do in order to track down the data or get it posted correctly
with all the data entered initially.

Regards

Sreejith J

[Non-text portions of this message have been removed]

system · March 29, 2011, 8:55am

Hi.

As far as I know the journalhead table is only used temporarily till the posting.
So if you want something stored it has to be on the journaldetail table.

You can have it on the header and with bpm copy it to every line but the header ultimately gets deleted.

HTH
Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: Sreejith Jaganathan <sreesvantagedoubts@...>
Sender: vantage@yahoogroups.com
Date: Tue, 29 Mar 2011 05:06:09
To: Vantage Group<vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Data loss after Journal Voucher Posting

Hi Friends;

Any help for the below said. The help is required very badly.

Regards

Sreejith J

Hello Friends;

I am facing a problem with JV Postings. Let me explain what I did

I customized the JV Entry form. I created a new label (Text on the label is [ACC

REF NUMBER]) and a text box. The data source for the text box was given as
GLJournalHed and the data field as CHARACTER01.

When the data entry is done in the JE transaction I observed that the data
entered in the customized field is correctly getting stored but after the
posting I am not able to find the data entered by me in the customized field.

I was not able to trace out where the data has gone. Could any body please let
me know what to do in order to track down the data or get it posted correctly
with all the data entered initially.

Regards

Sreejith J

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · March 29, 2011, 9:47am

Did you set the Key Field property to true?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sreejith Jaganathan
Sent: Tuesday, March 29, 2011 8:06 AM
To: Vantage Group
Subject: [Vantage] Data loss after Journal Voucher Posting

Hi Friends;

Any help for the below said. The help is required very badly.

Regards

Sreejith J

Hello Friends;

I am facing a problem with JV Postings. Let me explain what I did

I customized the JV Entry form. I created a new label (Text on the label
is [ACC

REF NUMBER]) and a text box. The data source for the text box was given
as
GLJournalHed and the data field as CHARACTER01.

When the data entry is done in the JE transaction I observed that the
data
entered in the customized field is correctly getting stored but after
the
posting I am not able to find the data entered by me in the customized
field.

I was not able to trace out where the data has gone. Could any body
please let
me know what to do in order to track down the data or get it posted
correctly
with all the data entered initially.

Regards

Sreejith J

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · March 29, 2011, 10:25am

First of all I would like to thank Mr. Ephraim Feldman and Ms. Linda to answer
my query.

Initially the key field property was set as FALSE. After receiving your mail I
changed it and tested the transaction but still I didn't find the posting being
done for the value entered in the customized field.

I am also trying the way suggested by Mr. Ephraim Feldman. Hope to get thru. If
there is any easy way then please do let me know.

Regards

Sreejith J

________________________________
From: Linda Lowney <llowney@...>
To: vantage@yahoogroups.com
Sent: Tue, March 29, 2011 5:49:12 PM
Subject: RE: [Vantage] Data loss after Journal Voucher Posting

Did you set the Key Field property to true?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sreejith Jaganathan
Sent: Tuesday, March 29, 2011 8:06 AM
To: Vantage Group
Subject: [Vantage] Data loss after Journal Voucher Posting

Hi Friends;

Any help for the below said. The help is required very badly.

Regards

Sreejith J

Hello Friends;

I am facing a problem with JV Postings. Let me explain what I did

I customized the JV Entry form. I created a new label (Text on the label
is [ACC

REF NUMBER]) and a text box. The data source for the text box was given
as
GLJournalHed and the data field as CHARACTER01.

When the data entry is done in the JE transaction I observed that the
data
entered in the customized field is correctly getting stored but after
the
posting I am not able to find the data entered by me in the customized
field.

I was not able to trace out where the data has gone. Could any body
please let
me know what to do in order to track down the data or get it posted
correctly
with all the data entered initially.

Regards

Sreejith J

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · March 29, 2011, 10:43am

Here is the description of the table in data dictionary:

GLJrnHed
General Ledger Journal Entry Header. This is Parent file to the GLJrnDtl.
These records are only created/used by the G/L journal entry programs. They
are deleted during the posting process.

so i guess no choice but to store them in GLJrnldtl

Ephraim

On Tue, Mar 29, 2011 at 10:25 AM, Sreejith Jaganathan <
sreesvantagedoubts@...> wrote:

>
>
> First of all I would like to thank Mr. Ephraim Feldman and Ms. Linda to
> answer
> my query.
>
> Initially the key field property was set as FALSE. After receiving your
> mail I
> changed it and tested the transaction but still I didn't find the posting
> being
> done for the value entered in the customized field.
>
> I am also trying the way suggested by Mr. Ephraim Feldman. Hope to get
> thru. If
> there is any easy way then please do let me know.
>
> Regards
>
> Sreejith J
>
> ________________________________
> From: Linda Lowney <llowney@...>
> To: vantage@yahoogroups.com
> Sent: Tue, March 29, 2011 5:49:12 PM
> Subject: RE: [Vantage] Data loss after Journal Voucher Posting
>
>
> Did you set the Key Field property to true?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Sreejith Jaganathan
> Sent: Tuesday, March 29, 2011 8:06 AM
> To: Vantage Group
> Subject: [Vantage] Data loss after Journal Voucher Posting
>
> Hi Friends;
>
> Any help for the below said. The help is required very badly.
>
> Regards
>
> Sreejith J
>
> Hello Friends;
>
> I am facing a problem with JV Postings. Let me explain what I did
>
> I customized the JV Entry form. I created a new label (Text on the label
> is [ACC
>
> REF NUMBER]) and a text box. The data source for the text box was given
> as
> GLJournalHed and the data field as CHARACTER01.
>
> When the data entry is done in the JE transaction I observed that the
> data
> entered in the customized field is correctly getting stored but after
> the
> posting I am not able to find the data entered by me in the customized
> field.
>
> I was not able to trace out where the data has gone. Could any body
> please let
> me know what to do in order to track down the data or get it posted
> correctly
> with all the data entered initially.
>
> Regards
>
> Sreejith J
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

system · March 29, 2011, 10:57am

Hi Further to this, if you can get the data into the GLJrnHedExt

This is the deescription for it.

General Ledger Journal Entry Header Extension. This is an extension file to the GLJrnHed to hold header level information such as text and source of the journal entry. This will serve as a Parent file to the GLJrnDtl. These records are created/used by the G/L Journal Entry and the Multi-Company Journal programs. Unlike the GLJrnHed, GLJrnHedExt is not deleted during the posting process.

Hope this helps

Mark

--- In vantage@yahoogroups.com, Ephraim Feldman <effgroups@...> wrote:
>
> Here is the description of the table in data dictionary:
>
> GLJrnHed
> General Ledger Journal Entry Header. This is Parent file to the GLJrnDtl.
> These records are only created/used by the G/L journal entry programs. They
> are deleted during the posting process.
>
> so i guess no choice but to store them in GLJrnldtl
>
> Ephraim
>
>
>
>
> On Tue, Mar 29, 2011 at 10:25 AM, Sreejith Jaganathan <
> sreesvantagedoubts@...> wrote:
>
> >
> >
> > First of all I would like to thank Mr. Ephraim Feldman and Ms. Linda to
> > answer
> > my query.
> >
> > Initially the key field property was set as FALSE. After receiving your
> > mail I
> > changed it and tested the transaction but still I didn't find the posting
> > being
> > done for the value entered in the customized field.
> >
> > I am also trying the way suggested by Mr. Ephraim Feldman. Hope to get
> > thru. If
> > there is any easy way then please do let me know.
> >
> > Regards
> >
> > Sreejith J
> >
> > ________________________________
> > From: Linda Lowney <llowney@...>
> > To: vantage@yahoogroups.com
> > Sent: Tue, March 29, 2011 5:49:12 PM
> > Subject: RE: [Vantage] Data loss after Journal Voucher Posting
> >
> >
> > Did you set the Key Field property to true?
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of Sreejith Jaganathan
> > Sent: Tuesday, March 29, 2011 8:06 AM
> > To: Vantage Group
> > Subject: [Vantage] Data loss after Journal Voucher Posting
> >
> > Hi Friends;
> >
> > Any help for the below said. The help is required very badly.
> >
> > Regards
> >
> > Sreejith J
> >
> > Hello Friends;
> >
> > I am facing a problem with JV Postings. Let me explain what I did
> >
> > I customized the JV Entry form. I created a new label (Text on the label
> > is [ACC
> >
> > REF NUMBER]) and a text box. The data source for the text box was given
> > as
> > GLJournalHed and the data field as CHARACTER01.
> >
> > When the data entry is done in the JE transaction I observed that the
> > data
> > entered in the customized field is correctly getting stored but after
> > the
> > posting I am not able to find the data entered by me in the customized
> > field.
> >
> > I was not able to trace out where the data has gone. Could any body
> > please let
> > me know what to do in order to track down the data or get it posted
> > correctly
> > with all the data entered initially.
> >
> > Regards
> >
> > Sreejith J
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

system · April 4, 2011, 4:21am

Hi Friends;

As a solution for the doubt raised by me I tried doing the below procedure but I
was not successful. Kindly please help me to sort out the issue

01. Customized the Journal Entry Transaction. Created a text field to enter the
JV Reference number. Assigned the datasource as GLJRNHED.CHARACTER01

02. Created a method directive GLJournalEntry.Update

03. Created a new PRE-PROCESSING

CONDITION is - the GLJrnHed.Character01 field of the changed row is not equal to
the "" value

ACTION is set the GLJrnDtl.Character01 field of the changed row to the
"ttGLJrnHed.Character01" value

After setting the above said when I did the Journal Entry I found that the
Reference number I am mentioning on the GLJRNHED.CHARACTER01 is not getting
written to GLJrnDtl.Character01.

I tried the same with POST-PROCESSING also bu the result was the same.

I hope that I had been clear to explain my problem. Any help for the above would
be highly appreciable.

Regards

Sreejith J

________________________________
From: Ephraim Feldman <effgroups@...>
To: vantage@yahoogroups.com
Sent: Tue, March 29, 2011 6:43:23 PM
Subject: Re: [Vantage] Data loss after Journal Voucher Posting

Here is the description of the table in data dictionary:

GLJrnHed
General Ledger Journal Entry Header. This is Parent file to the GLJrnDtl.
These records are only created/used by the G/L journal entry programs. They
are deleted during the posting process.

so i guess no choice but to store them in GLJrnldtl

Ephraim

On Tue, Mar 29, 2011 at 10:25 AM, Sreejith Jaganathan <
sreesvantagedoubts@...> wrote:

>
>
> First of all I would like to thank Mr. Ephraim Feldman and Ms. Linda to
> answer
> my query.
>
> Initially the key field property was set as FALSE. After receiving your
> mail I
> changed it and tested the transaction but still I didn't find the posting
> being
> done for the value entered in the customized field.
>
> I am also trying the way suggested by Mr. Ephraim Feldman. Hope to get
> thru. If
> there is any easy way then please do let me know.
>
> Regards
>
> Sreejith J
>
> ________________________________
> From: Linda Lowney <llowney@...>
> To: vantage@yahoogroups.com
> Sent: Tue, March 29, 2011 5:49:12 PM
> Subject: RE: [Vantage] Data loss after Journal Voucher Posting
>
>
> Did you set the Key Field property to true?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Sreejith Jaganathan
> Sent: Tuesday, March 29, 2011 8:06 AM
> To: Vantage Group
> Subject: [Vantage] Data loss after Journal Voucher Posting
>
> Hi Friends;
>
> Any help for the below said. The help is required very badly.
>
> Regards
>
> Sreejith J
>
> Hello Friends;
>
> I am facing a problem with JV Postings. Let me explain what I did
>
> I customized the JV Entry form. I created a new label (Text on the label
> is [ACC
>
> REF NUMBER]) and a text box. The data source for the text box was given
> as
> GLJournalHed and the data field as CHARACTER01.
>
> When the data entry is done in the JE transaction I observed that the
> data
> entered in the customized field is correctly getting stored but after
> the
> posting I am not able to find the data entered by me in the customized
> field.
>
> I was not able to trace out where the data has gone. Could any body
> please let
> me know what to do in order to track down the data or get it posted
> correctly
> with all the data entered initially.
>
> Regards
>
> Sreejith J
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]