From: Henry L. <henry@LinuxYes.com> - 2003-03-20 10:36:59
|
Hi, I install web-erp 0.1.5.1 this week on red hat linux 8.0 and it works = well. But I try to print out the invoice, it shows following code: SELECT DebtorTrans.TranDate, DebtorTrans.OvAmount, = DebtorTrans.OvDiscount, DebtorTrans.OvFreight, DebtorTrans.OvGST, = DebtorTrans.Rate, DebtorTrans.InvText, DebtorsMaster.Name, = DebtorsMaster.Address1, DebtorsMaster.Address2, DebtorsMaster.Address3, = DebtorsMaster.Address4, DebtorsMaster.CurrCode, SalesOrders.DeliverTo, = SalesOrders.DelAdd1, SalesOrders.DelAdd2, SalesOrders.DelAdd3, = SalesOrders.CustomerRef, SalesOrders.OrderNo, SalesOrders.OrdDate, = Shippers.ShipperName, CustBranch.BrName, CustBranch.BrAddress1, = CustBranch.BrAddress2, CustBranch.BrAddress3, CustBranch.BrAddress4, = Salesman.SalesmanName, DebtorTrans.DebtorNo FROM DebtorTrans, = DebtorsMaster, CustBranch, SalesOrders, Shippers, Salesman WHERE = DebtorTrans.Order_ =3D SalesOrders.OrderNo AND DebtorTrans.Type=3D10 AND = DebtorTrans.TransNo=3D10 AND DebtorTrans.ShipVia=3DShippers.Shipper_ID = AND DebtorTrans.DebtorNo=3DDebtorsMaster.DebtorNo AND = DebtorTrans.DebtorNo=3DCustBranch.DebtorNo AND = DebtorTrans.BranchCode=3DCustBranch.BranchCode AND = CustBranch.Salesman=3DSalesman.SalesmanCode If I try to print it to PDF document (I install PDFlib and compile it = wth PHP module ), it shows=20 Fatal error: PDFlib error: Empty document in = /var/www/html/web-erp/PrintCustTrans.php on line 205 It seems no invoice document is created. But I use phpmyadmin to check = the records on DebtorTrans, = DebtorsMaster,CustBranch,SalesOrders,Shippers,Salesman and it seems all = right. For comparison, I can print the credit notes without problem (actually, = the PDF document is ok except the Chinese characters can't show on PDF = document) Does anyone have this problem? Any help will be appreciated. Henry |