Why not just make use of the inventrans (and probably inventtransposting records)? Take a look at the update tab page that has the info you need
_____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Khalil Rehman Sent: 14 February 2009 21:56 To: Knowlege Village Subject: RE: [Axapta-Knowledge-Village] Packing Slip & Invoice Details in Account Recievables Module Dear Maryann actually i was asking about Sales Order Packing Slip and Invoice Details. is there any report for Sales which can show me the Sale Order #, Packing Slip and Invoice Details against that Sales Order. means i want to know how many Packing Slip and Invoice made against particular Sales Order. and which Inoice Made against Packing Slip. regards. <http://graphics.hotmail.com/i.p.emrose.gif> KHALIL UR REHMAN <http://graphics.hotmail.com/i.p.emrose.gif> _____ To: Axapta-Knowledge-Village@yahoogroups.com From: maryann.h...@gmail.com Date: Sat, 14 Feb 2009 03:02:56 -0700 Subject: Re: [Axapta-Knowledge-Village] Packing Slip & Invoice Details in Account Recievables Module I presume you are asking about purchase matching not sales matching. In AX 2009, by the way, you can do matching of PO, Packing Slip and Invoice in the standard product. Since you say AX 4.0, you would need to do the matching yourself. Ax uses journals to keep the packing slip and invoice records. The header for the vendor packing slip journal is named VendPackingSlipJour and the lines of the packing slip are in VendPackingSlipTrans. A siimilar naming convention is used for invoices. The header table is VendInvoiceJour and the lines are VendInvoiceTrans. Be sure to match transactions via the field named InventTransId - do not use LineNum which may not match between packing slip and invoice. On Fri, Feb 13, 2009 at 11:46 PM, Khalil Rehman <khalilrehman5@ <mailto:khalilrehm...@hotmail.com> hotmail.com> wrote: > Dear All, > > i want to know that is there any Report which can show us Packing Slip > Reference with Invoice No in one report in Ax 4.0. also if not available > then in which table i can found the Packing Slip with Invoice No Details. > > this is urgent please. > > regards. > > Khalil > > > KHALIL UR REHMAN > > > > ________________________________ > What can you do with the new Windows Live? Find out > > _____ What can you do with the new Windows Live? Find out <http://www.microsoft.com/windows/windowslive/default.aspx>