N/A Invoice details on F0911

wrafafer

wrafafer

Member
I am trying to relate tables F0911 with F7601B and F76101B by using F0911.GLVINV = xxBNNF (invoice number) and F0911.GLAN8 = xxAN8V (supplier code) with the aim to bring invoice details such as SERIES (FHBSER) and INVOICE TYPE (FHDCT), for example. However a few lines do not contain F0911.GLVINV (i.e., I get NULL). Is there any other way to get these invoice details directly on F0911? Or any other way to make a join between F0911 and invoice table?
 

Similar threads

Mikey_R
E9.2 Reconcile Unapplied Cash in F03B11 to F03B14
Replies
2
Views
2K
nairs50
E9.2 Object Usage Tracking - Retention and Exclusions
Replies
3
Views
2K
andymcclure
E9.2 bi publisher create invoice template
Replies
1
Views
2K
hdp123
E9.2 Change Assistant Error for UDOs
Replies
8
Views
591
Seane6
N/A JDE Agreement Quantities relation to Purchase order details F4311
Replies
3
Views
938
DaveWagoner
DaveWagoner
Back
Top