Skip to Content
avatar image
Former Member

Query to get the value defined on previous document

Hi Experts,

On my AR Invoice, I created a UDF's Previous and Present then created a formatted search in the quantity field to get the difference between Previous and Present value.

Now, I want to automatically capture on my next invoice the present value I input in the previous Invoice.

What is the query for this?

Here's the screenshot of my AR Invoice.

Regards,

Janice

untitled.jpg (52.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 12, 2016 at 05:44 AM

    Hi,

    FMS will only work to capture the current screen information i.e. the active form. Your requirement can not be catered through FMS.

    You can try SPTN.

    Regards

    Pradnya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 14, 2016 at 08:09 AM

    Hi Pradnya,

    Can you help me how to do that?

    Regards,

    Janice

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 14, 2016 at 09:02 AM

    Hi,

    SPTN is written in SQL server at database level under the following path

    Database --> Programmability --> Stored Procedures --> SBO_SP_TransactionNotification.

    You can refer following to gain an insight.

    https://blogs.sap.com/2009/05/22/the-sptransactionnotification-stored-procedure/

    Regards

    Pradnya

    Add comment
    10|10000 characters needed characters exceeded