cancel
Showing results for 
Search instead for 
Did you mean: 

price

Former Member
0 Kudos

Dear All,

Is it possible to display price column value in GRPO or PO in the A/P invoice udf ? the user want to know the old price (in GRPO or PO) in the A/P invoice because there are always different price when invoicing them.

Rajh

Accepted Solutions (1)

Accepted Solutions (1)

former_member186095
Active Contributor
0 Kudos

Hi,

I am not clear with your question ? Do you want to display price in a GRPO document in an A/P invoice ? does it means the price is changed in the A/P invoice ?

try to consider this query :



SELECT t0.price FROM [dbo].[PDN1]  
T0 INNER JOIN OPDN T1 ON T0.docentry = T1.docentry 
INNER JOIN OCRD T2 ON T1.cardcode = T2.cardcode  
WHERE t2.cardcode = $[$4.1.0] and t0.itemcode = $[$38.1.0]

Let me know if not works

Rgds,

Former Member
0 Kudos

Tks a lot for your answer. It works.

Rajh

Answers (3)

Answers (3)

former_member187989
Active Contributor
0 Kudos

Raj,

Save query in query manager in a category.

Use below query in UDF & apply formatted search

search by query option,click refresh regularly,

select when exiting alterd column,select unit price,

select refresh regularly.

SELECT $[$38.17.NUMBER]

Jeyakanthan

former_member187989
Active Contributor
0 Kudos

raj,

Create a UDF in GRPO at row level and then apply

formatted search in UDF to capture unit price in it.

While creating ap invoice from grpo you

can compare old & new prices.

Jeyakanthan

Former Member
0 Kudos

While entering the 'PO' or 'GRN' right click on the 'Unit Price' column and select 'Last Prices report' which may be helpful.