Creating a report based on when a sales order was invoiced

We are using AX 3.0. Is there a table that ties the PSV (Project Sales Voucher) to the sales order? I am looking to create a report based on when the sales order was invoiced.

Hi Mike,

the InventTrans table should give you all the information you need. It has the voucher numbers, sales order numbers, project numbers, invoice dates, invoice numbers …and lots of other good stuff… :slight_smile:

Karin Espelage
Independent Dynamics AX consultant
www.max-ax.com

Thanks Karin, I use that table all the time and never realized that was there.