Skip to Content
0
Former Member
Jul 01, 2009 at 10:17 AM

How to copy account description in service document description line

40 Views

The AP & AP services document consists of description line for user to type something. Can it be setup like choose relevant GL account will display the account description on the description line?

I tried to used the following query. But it doesn't work. The reason is the format code with segmentation account did not have '-' in between the nature account & segment.

SELECT T0.[AcctName] FROM OACT T0 WHERE T0.[FormatCode] =$[OACT.FormatCode]

Any other idea?

May i know how to copy the GL description into services description line besides using UDF(user define field)?

Thanks in advance

Regards,

Eric Tan