Welcome to the Sage 50 Canada 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.
Would anyone be able to tell me which table in the Sage 50 CA data schema contains the vacation pay rate (i.e. 4%, 6% etc.) for an employee (and the name of the column)? I am unable to locate this information through the data dictionary. Thank you.
Hi Nick_Alpha,
Yes, the next invoice number is stored in tCompShr.lInvNum
lInvNum Number FT_LONG 4 Next invoice number
lNxtPONum Number FT_LONG 4 Next purchase order number
lNxtSONum Number FT_LONG 4 Next sales order number
lNxtRcNum Number…