on 08-06-2012 2:35 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kennedy & Gordon
Thank you for your quick replies.
I understood there is no way to find mapping information in line level.
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.