Skip to Content
0

Query to get the value defined on previous document

Nov 11, 2016 at 03:32 AM

24

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Pradnya S Nov 12, 2016 at 05:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Janice De Umania Nov 14, 2016 at 08:09 AM
0

Hi Pradnya,

Can you help me how to do that?

Regards,

Janice

Share
10 |10000 characters needed characters left characters exceeded
Pradnya S Nov 14, 2016 at 09:02 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded