Menu
▾
▴
Re: [Web-erp-users] can't print invoice
|
From: Daintree F. <p.d...@xt...> - 2003-03-21 08:05:40
|
Hi Henry, I can see that invoices have been created using shipper 10. I guess this must be the default shipping company set up in config.php - if the shipper 10 has been deleted then this leaves a problem no invoices can print. Perhaps there should be some check on this on printing invoices. Will fix this in the next release. I entered a shipping company 10 and the invoices now print fine. Thanks for pointing out the problem. Regards Phil ----- Original Message ----- From: "Henry Lin" <he...@Li...> To: <ph...@du...> Cc: <web...@li...> Sent: Friday, March 21, 2003 5:46 PM Subject: Re: [Web-erp-users] can't print invoice > 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 > > > > > > ------------------------------------------------------- > 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 |
