AR invoice PLD reflects base Sales Order Value

[Former Member]

Dear All,

In AR invoice PLD I need a field in which the base document total value comes. For example a Sales Order is made for 2 Items unit price USD 500 each Amouting for USD 1000 ( Sales Order Total Value ). Based on this sales order partial AR invoice is booked for 1 item USD 500.

Now I want fields in the AR invoice PLD which shows me as :

Total Order Value which is USD 1000

Current Invoice Value USD 500

Balance Invoice Value USD 500 ( which will come by total order value - current AR invoice )

Can anyone please help me how to solve this issue as it is required immediately.

Regards,

Kawish

[Former Member]

Dear Khwaish,

In PLD, you already have the field holding the "Partial AR Invoice value" (A)

Create another database field on the PLD and link it to show the SO Value. (B)

Now create a formula field to show A-B (C)

Therefore you should have -

(B) Base SO Value - USD 1000

(A) Partial AR Invoice Value - USD 500

(C) Balance Value - USD 500

Cheers,

Gautam

[Former Member]

Dear Gautam,

Thanks for your reply but can you please let me know in AR Invoice PLD from where can I get Base Sales Order Value. Can you tell me the field or table name.

I could not understand by your line - Create another database field on the PLD and link it to show the SO Value. (B)

Hope you understand my point.

Regards,

Kawish

[Former Member]

Kawish,

1. You can hold ALT and click the database dropdown to show all tables. After that you can select the table ORDR and the DocTotal field to show document total.

If this does not give you the correct answer, i suggest you create a UDF on the AR invoice and provide it a FMS to read document total screen variable of the SO form.

Thereafter you can use this UDF on the AR PLD normally and do normal calculations.

2. My meaning adding a new field, I meant to drag and drop and new field from the toolbar above to the PLD. In the properties window > Content tab - you should set the source type as Database to use the internal tables and their fields.

to do a formula, drag another field and change the source type to formula.

I suggest, you go through the PLD e-learning sessions to enhance your knowledge about basic PLD functions.