Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ruth Entwistle]

#NAV2017?

Item Ledger Entries has all the data we need except linking the customer or vendor name to sales or purchase documents.
Is there a different table that would have those fields or a way to link the information? 
We have Jet Basics but Jet Reports is on order! Perhaps in Jet Reports this is possible but not in Jet Basics??

——————————
Ruth Entwistle
Customs Broker/Vendor Relations
Heron Point Seafood
Newmarket NH
——————————

[Lewis Rosenberg]

For Entry Type=SALES the SOURCE NO. will be the Customer Number and for Entry Type=PURCHASE, the SOURCE NO. field will contain the Vendor No.
With the Customer No. you can retrieve the Customer Name from table 18 (Customer) and with the Vendor No. you can retrieve the Vendor Name from table 23 (Vendor).

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
————————————————————————
BCUG/NAVUG All-Star
BCUG/NAVUG Board of Advisors, Chairperson
BCUG/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————

NAVUG/D365BC-User Group Focus
May 18-19, 2019
Denver, Colorado
——————————
——————————————-

[Ruth Entwistle]

Thank you! 
Works! The only issue is that I get both a customer and vendor name at times for say a sales order.  
I’m assuming that is because I cannot (without the paid version) check the box that says Include Item Entry Rows – Only when customer found.

——————————
Ruth Entwistle
Customs Broker/Vendor Relations
Heron Point Seafood
Newmarket NH
——————————
——————————————-