Lookup the default invoice number

Question

Hello All 
 Is there away to lookup the default invoice number using a ODBC query? This has to work on Quantum 2010. 
 Thank you, 
 Nick

RandyW · Accepted Answer

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 FT_LONG 4 Next receipt number 
 lNxtDpNum Number FT_LONG 4 Next deposit number 
 lNxtMBNum Number FT_LONG 4 Next other payments number 
 I hope that helps, please flag this as the answer if it was what you were looking for. 
 Randy

Sage 50 Canada

Lookup the default invoice number

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING