There's a limit of nine UNIONs in a single query, according to the Hacker's Guide™ to Visual FoxPro® 6.0. To get around this limit split your select in two

SELECT * FROM csrOpenSum ;
UNION ;
SELECT * FROM csrInvoiceSum ;
INTO CURSOR crsTemp1

SELECT * FROM crsTemp1 ;
UNION ;
SELECT * FROM csrTransferInSum ;
UNION ;
SELECT * FROM csrTransferOutSum ;
UNION ;
SELECT * FROM csrHisRunOutSum ;
UNION ;
SELECT * FROM csrLogFileLPSum ;
UNION ;
SELECT * FROM csrAdjAddSum ;
UNION ;
SELECT * FROM csrAdjMinusSum ;
UNION ;
SELECT * FROM csrSalesSum ;
UNION ;
SELECT * FROM csrReturnSum ;
UNION ;
SELECT * FROM csrCNSum ;
INTO CURSOR csrTotalSum