Sage 300

Accpac version 5.3B I am using Crystal reports to extract invoice history. The tables used are OEORDH and OEORDD (order header and order detail). In OEORDH the ""COMPLETE"" field is ""5"" on all of the extracted records, INVNUMBER is ""***NEW***"" on all of the extracted records, and ORDTOTAL is ""0.00"" on all of the extracted records. Why isn't there an invoice number? Why does INVNUMBER have the ***NEW*** value? I need an invoice number.

Doug - You get the invoices from OEINVH and OEINVD (header/detail) among other tables. The oeinvh table does contain the ORDNUMBER field which is the same in the OEORDH table.