The VFA map is printed without data

0

I made changes to the map used to print VFA by adding the Movimentos table to see the vendor's CBL account in the headers. And when the record of a VFA does not create a record in the Movimentos table of the database the map is printed without data.

I linked the Movimentos and CabecCompras tables through the fields (NumDoc, TypeDoc, Series, and Entity).

Account in the document header is printed ({Movimentos.Conta}) .

Can you help me figure out what I'm doing to be having that sff result? Thank you.

    
asked by anonymous 01.08.2018 / 15:13

1 answer

1

I've already got a solution to the challenge, when I added the Movements table, I had to indicate which connection types for the fields (Document, DocDoc, Entity and Series) with Right Outer join and Not Inforced options checked, when the Moves table that does not have the VFA record should be ignored.

    
02.08.2018 / 10:27