Re: [Web-erp-users] can't print invoice

[Phil D. <ph...@du...>]

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
>