Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Specialize job cost invoice with vendor name listed next to items on invocie

Posted By Stewart Schow over 4 years ago

Updated from Sage 100 Standard to Sage 100 Premium. Need to supply vendor name on job cost invoice. for customer. JC_InvoivoWrk only supplies Vendor id and Division id. How best to link JC_InvoiceWrk to Vendor File to get Vendor name in database

Sage100Reports over 4 years ago

Link the APDivisionNo and the VendorNo fields from the JC_InvoiceWrk table to the AP_Vendor table. Make sure you do a left outer join so you do not loose lines that don't contain a vendor. You could also do a subreport instead.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Kevin M over 4 years ago

When dealing with work table reports, it is always better to use a UDF instead of linking tables in the report... assuming the business object exists for the field you wish to add.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 100

Specialize job cost invoice with vendor name listed next to items on invocie

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING