Re: [Web-erp-developers] Re: Web-erp database structure change request

[Daintree F. <p.d...@xt...>]

>I remember wanting to query for which
> invoices are related to a certain sales order, this currently is not
> possible. 

I think we can do this as Paul notes with:

SELECT TransNo FROM DebtorTrans WHERE Order_=$WhateverOrderNo AND Type=10;

> BTW, I just noticed that on Order Invoicing (ConfirmDispatch_Invoice.php)
> the date is not saved properly.

Will look into this later. Thanks

Phil