Could not add a database field in the new PLD report..

[Former Member]

Hi All,

Am working on a PLD report and am not able to add a Databse field on the Report.

I want to add a new field on my Report which should fetch the Field Tax Amount from the table AR invoice tax amount per document....

when i add the new database field the drop down for tables does not display the desired table....

Can any one help me on this....

Thanx in advance

Manish Chaudhary

[Former Member · Accepted solution]

Hello Manish,

For view all tables in PLD you must proceed as following:

Press TAB key (and keep it pressed)

Then click on drop down for tables.

Vanessa

[Former Member · Accepted solution]

Sorry! I mean ALT key

(not TAB)

[Former Member · Accepted solution]

Hi Venessa,

I tried ur suggestion and it worked,

Thanx a Lot.

Manish

[Former Member]

Hi Manish

In the AR Invoice window, you can make the Tax Amount (LC) visible, and then by using the cursor and (view>system information) you will note that it is a system variable (on my version -variable 103). So in your layout you can add a field of type variable and have this amount display in your layout.

Hoping this will help you.

Regards

Daan

[Former Member]

Hi Manish

From which window (eg invoice, cred Note etc) are you doing the PLD?

Regards

Daan

[Former Member]

Hi Daan

I am doing the PLD for AR Invoices...

Regards

Manish

[former_member186095]

Hello,

here is some thread links relate to your problem :

1.

2.

Rgds,

[former_member583013]

Manish,

There are a lot of messages similar to your situation already posted on this Forum.

Please search the following message Subjects and you could find some info. FYI, there is no straight and easy solution to this situation due to limitation in PLD.

<b>Calculate Tax breakup in PLD</b>

<b>PLD Problem</b>

Suda