cancel
Showing results for 
Search instead for 
Did you mean: 

How can I know the mapping information (INV1 => JDT1)??

Former Member
0 Kudos

Hi all

(SBO 8.82 PL07)

I beleive we can know which Journal Entry Row is the result of this AR Invoice Line,

But I cannot find JDT1.DocEntry and JDT1.LineNum in INV1.

Does anyone know how can I get this mapping inforation (INV1 => JDT1) ?

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

There is no one-to-one link between JDT1 AND INV1. Only OJDT and OINV is one-to-one relationship.

You may check on Header level to understand more.

Thanks,

Gordon

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Kennedy & Gordon

Thank you for your quick replies.

I understood there is no way to find mapping information in line level.

Thank you.

KennedyT21
Active Contributor
0 Kudos

HI seiichi yamada ,

Try with This query how i linked.

select * from OINV t1

inner join INV1 t2 on t2.DocEntry=t1.DocEntry

inner join JDT1 t3 on t3.TransId=t1.TransId

Regards

Kennedy