OBVL table used in query SAP Business One

[nikunjmehta2290]

Dear all,

I have one query report using OBVL. Report output is showing some negative value into column. Need tp understand the logic of why the use of OBVL table.

For information purpose, I have attached that entire joins details.

OBVL."InvValue" AND OBVL."CogsValue" -> Column used for which purpose.

FROM OBVL T7

INNER JOIN OILM T9 ON T7."ILMEntry"=T9."MessageID"  AND T7."ItemCode"=T9."ItemCode" AND T7."DocType"=T9."TransType"
LEFT JOIN OITL T2 on T2."ItemCode" =T7."ItemCode" AND T7."ITLEntry"=T2."LogEntry" and T2."DocEntry" = T7."DocEntry"  and  T2."DocType"=T7."DocType" and T2."DocLine"=T7."DocLineNum"    

LEFT JOIN IBT1_LINK T0 on T0."ItemCode" =T2."ItemCode" and T0."WhsCode" = T2."LocCode" AND T0."BatchNum"=T7."DistNumber" 

AND T0."BaseEntry" = T2."DocEntry"  AND T0."BaseType"=T2."DocType" and T0."BaseLinNum"=T2."DocLine" AND T0."LogEntry"=T2."LogEntry"

LEFT JOIN OWHS T1 ON T9."LocCode" = T1."WhsCode"

LEFT JOIN OBPL T6 ON T6."BPLId"=T1."BPLid" 

LEFT JOIN OITM T3 ON T7."ItemCode" = T3."ItemCode"

LEFT join OITB t4 on t3."ItmsGrpCod"=t4."ItmsGrpCod"

LEFT join OBTN t5 on T7."DistNumber"=t5."DistNumber" and T7."ItemCode"=T5."ItemCode" 


Regards,
Nikunj

[nikunjmehta2290]

This joins caluclates the real time value or showing the log information only?