Menu
▾
▴
Re: [Web-erp-users] can't print invoice
|
From: Henry L. <he...@Li...> - 2003-03-21 05:39:53
|
Hi Phil, You can try http://211.20.11.131/phpmyadmin/ and let me know if you need more information. Thanks Henry -- > OK I see the problem but I can't yet see the solution > Could you put phpMyAdmin on your server too or point me to the URL, so I > can try some queires against the database > > Thanks > Phil > > ----- Original Message ----- > From: "Henry Lin" <he...@Li...> > To: <p.d...@xt...> > Cc: <web...@li...>; <he...@Li...> > Sent: Friday, March 21, 2003 4:42 PM > Subject: Re: [Web-erp-users] can't print invoice > > >> Hi Phil, >> >> Thanks your quick response. >> >> Actually, all the invoices can't be printed out (Receivables->print >> Invoices or Credit Notes), but credit notes are OK. >> >> I visit your web-erp demo site on sourceforge and it indeed can print >> out invoice. >> >> Maybe you can try my web-erp demo site and find if anything wrong. >> >> http://211.20.11.131/weberp >> >> >> Thanks a lot >> >> Henry >> >> >> -- >> >> >> > Hi Henry, >> > >> > I would have thought that Chinese PDF should be possible - I guess >> reformating of the invoice may be required though. >> > >> > The problem with the no invoice to print is new to me. Could it be >> that the underlying order has been deleted ? The order header record >> is required to get the delivery address information to print on >> invoices - if it is deleted then the reprint won't work - this is >> probably a bad thing, I will make it so the invoice prints without >> delivery information if the sales order has been deleted/purged in a >> future version. Is the problem isolated to a specific invoice or do >> other invoices not print? >> > >> > Thanks for your feedback - I hope together we can resolve this >> issue. Regards >> > Phil Daintree >> > Logicworks Ltd >> > ----- Original Message ----- >> > From: Henry Lin >> > To: web...@li... >> > Sent: Thursday, March 20, 2003 10:52 PM >> > Subject: [Web-erp-users] can't print invoice >> > >> > >> > 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_ = >> > SalesOrders.OrderNo AND DebtorTrans.Type=10 AND >> DebtorTrans.TransNo=10 AND DebtorTrans.ShipVia=Shippers.Shipper_ID >> AND >> > DebtorTrans.DebtorNo=DebtorsMaster.DebtorNo AND >> > DebtorTrans.DebtorNo=CustBranch.DebtorNo AND >> > DebtorTrans.BranchCode=CustBranch.BranchCode AND >> > CustBranch.Salesman=Salesman.SalesmanCode >> > >> > If I try to print it to PDF document (I install PDFlib and compile >> it >> > wth PHP module ), it shows >> > >> > >> > 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 >> >> >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: Tablet PC. >> Does your code think in ink? You could win a Tablet PC. >> Get a free Tablet PC hat just for playing. What are you waiting for? >> http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en >> _______________________________________________ >> Web-erp-users mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Tablet PC. > Does your code think in ink? You could win a Tablet PC. > Get a free Tablet PC hat just for playing. What are you waiting for? > http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en > _______________________________________________ > Web-erp-users mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
