cancel
Showing results for 
Search instead for 
Did you mean: 

AR Invoice docentry run time system information in sap b1

Former Member
0 Kudos

Hi..

I have create 3 udf in ar invoice row level calculate BED AND HEDU AND EDU different udf

I want sum of this value in header level udf

so please give me docentry system information like docentry=$[$. . ]

what value I enter 

Accepted Solutions (0)

Answers (4)

Answers (4)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Have you checked my reply? Same thing tested and it is working only adding the document. Why do you want total before adding?

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

hi nagarajan,

I checked u reply but I want value in run time

in my case bond amount calculate in exice amount so please possible at run time value

Former Member
0 Kudos

hi

dear all

runtime value is not working error is internal error

my FMS Quarry is 

SELECT  SUM(CAST(T1. $[$38.U_BED]) AS int)) +  SUM(CAST(T1. $[$38.[U_HEDU] AS int))+ SUM(CAST(T1. $[$38.[U_EDU] AS int)) FROM OINV T0

INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE t0.docentry =$[OINV.docentry]

former_member197621
Active Contributor
0 Kudos

Hi Sanjay,

Try this ,

SELECT  SUM(CAST($[$38.U_BED]) AS int)) +  SUM(CAST($[$38.[U_HEDU] AS int))+ SUM(CAST($[$38.[U_EDU] AS int))

Former Member
0 Kudos

Hi prasanna

this FMS Quarry is not working

former_member197621
Active Contributor
0 Kudos

Hi Sanjay,

Try this , if any error throws tell me the error description

SELECT  SUM(CAST($[$38.U_BED] AS numeric)) + SUM(CAST($[$38.U_HEDU] AS numeric)) + SUM(CAST($[$38.U_EDU] AS numeric))

Former Member
0 Kudos

Hi prasanna,

I try it but error is internal error

former_member197621
Active Contributor
0 Kudos

Hi Sanjay,

Pls post the full screen short , so that i can easily troubleshoot.

Former Member
0 Kudos

hi prasanna,

I want run time total in header level of exice amount of row level

former_member197621
Active Contributor
0 Kudos

Hi Sanjay,

If you want Row level Value in Header level you have to set Auto refresh. If you click Shift + F2 it will throw internal error but if you try in auto refresh it will work.

For example set auto refresh in document total or some fields which they will enter finally.

Former Member
0 Kudos

hi prasanna

thanks for replay

I try this also but error is same data cannot display error is internal error display

Former Member
0 Kudos

Hi Sanjay,

try this

Select

(SELECT $[$38.U_BED])+

(SELECT $[$38.U_HEDU])+

(SELECT $[$38.U_EDU])

regards,

Raviraj

former_member197621
Active Contributor
0 Kudos

Hi Sanjay,

Before Add the document you can't manipulate the UDF using docentry. You have to use the FMS as per Raviraj suggested.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this FMS:

SELECT T1.[U_BED] + T1.[U_HEDU] + T1.[U_EDU] FROM OINV T0
INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE t0.docentry =
$[OINV.docentry]

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

HI

nagarajan thanks for replay

below FMS is run but adding invoice then after click manually then value come

I want to value run time

it is possible

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Tried in different way. Not able to get run time add. So alternatively you can same FMS.

SELECT t1.itemcode, T1.[U_BED] + T1.[U_HEDU] + T1.[U_EDU] FROM OINV T0

INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE t0.docentry =

$[OINV.docentry]

Thanks & Regards,

Nagarajan