I have been trying to create a report that shows not only the GL information but links to the Vendor data and pulls the Vendor name. Can anyone please tell me what linking data and tables to use? I can't seem to figure out what Purchases / Vendor tables to use in conjunction with the GL Entries table. Thanks for your help ahead of time.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Michel,
If you are using NAV, the vendor number is stored in the Source No. field of the G/L Entry table. Once you have that, you should be able to get the vendor name from the Vendor table. The Source No. field is pretty cool. It holds a bunch of different kinds of information depending on the type of transaction. For instance, when the Source Type field is "Customer", the Source No. field contains a customer number. If the Source Type field contains "Vendor" then the Source No. field is a vendor number.
I hope this helps! -
Jet Reports Historic Posts Hi Michel,
If you are using NAV, the vendor number is stored in the Source No. field of the G/L Entry table. Once you have that, you should be able to get the vendor name from the Vendor table. The Source No. field is pretty cool. It holds a bunch of different kinds of information depending on the type of transaction. For instance, when the Source Type field is "Customer", the Source No. field contains a customer number. If the Source Type field contains "Vendor" then the Source No. field is a vendor number.
I hope this helps!
I think this is not entirely true: if you post double entries in two lines (i.e. one line for debit and another line for credit) this information is not stored in the Source No. field. You have to post the double entry on a single line (i.e. debit and enter credit as balancing account).
It's a bit tricky to make this work but you may have to link somehow with the Vendor Ledger entries table… -
Jet Reports Historic Posts You basically need to know
1) Entry came from AP (Source Type is Vendor)
2) Transaction Number
You can then use the transaction number to get to vendor Ledger and pull back vendor no and then master for Name etc. Generally the Source No. is the vendor number although I have seen this be incorrect ( It's an internal user issue here with a specific dataport not Navision as far as I know)
Please sign in to leave a comment.