Skip to Content

Reg: A/R Invoice, Last Invoice price should be displayed in UDF

Dear All,

My Client asking below scenario. Kindly advise me how to do this..

In A/R Invoice, we need to create one UDF field at the row level, in that last Invoice Price should be displayed..

I have created UDF filed at row level.. Now i wanted to display last invoice price for that particular item..

can anyone help me to do this....

Thanks..

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Aug 24, 2016 at 06:25 AM

    Hi

    try this SQL query:

    select top(1) T1.Price from inv1 T1 inner join OINV T0 on T0.docentry = T1.DocEntry where t1.ItemCode = $[$38.1.0] order by T0.docdate desc

    Kind regards.

    Agustín Marcos Cividanes

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2016 at 06:13 AM

    Hi Logesan,

    You cannot fetch data in row level for UDF fields but you can put FMS query over there and all previous invoices you will get.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2016 at 06:19 AM

    Hi Logesan,

    You don't need to open UDF for that.

    When you select the item on A/R Invoice after that rigth click on your mouse and select the Last Prices.

    It shows the last prices of item.And you can select the BP and document type. An


    LastPrice_item.png (24.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Thanks for your response.. Sales Department manager wants to see at the row level only, they wanted to check the Current Sales Invoice price and Last Invoice price at the time of approval, is there any way to pull that price at row level?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.