We have some modified code in the
LedgerVoucherTrans.createLedgerTrans class that parses a txt field
in the LedgerJournalTrans table into fields added to the LedgerTrans
table.  Just prior to populating the LedgerTrans fields, the
following code is executed and LedgerTrans is populated with the
value in transtxt1:

select LedgerJournalTrans where LedgerJournalTrans.voucher ==
LedgerTrans.voucher;
transtxt1 = LedgerJournalTrans.Txt2;

The problem that occurs is when Txt2 is parsed the first line is
used to populate each record rather than each line being evaluated. 
So on the transactions where the Txt2 values change, LedgerTrans is
populated with only one of the values.  For example:
LedgerJournalTrans  record 1    Txt2=aaabbbccc
LedgerJournalTrans  record 2    Txt2=aaacccbbb
LedgerTrans            record 1  Field1=aaa Field2=bbb Field3=ccc
LedgerTrans            record 2  Field2=aaa Field2=bbb s/b ccc
Field3=ccc  s/b bbb

Can anyone suggest how to get the posting process parse each line
individually rather than by voucher?  I've tried changing the code
to joing the tables by documentnum rather than voucher but all that
does is not populate the fields in LedgerTrans at all.

Thanks,
Rick




Yahoo! Groups Links

Reply via email to