Link between vendor packing slip number and vendor Invoice number-AX 2009

Finance and Operations/AX Technical Forum
1

Hi all,

Is there any way to find/create a link between Purchase Order internal packing slip number and Purchase Order internal invoce number. My requirment is as follows;

PO # Packing Slip # Invoice #

PO-1 GRN-1 PInv-1

PO-1 GRN-2 PInv-1

PO-1 GRN-3 PInv-2

PO-2 GRN-4 Pinv-3

The report is to track vendor dleivery (most of the time it will be partial) and it’s invoice number. Is there any way to link packing slip of a purchase order and purchase order invoice, even if i have partial delivery?

Regards,

2

Hi Ishak,

PO number itself is link here.

Pranav…

3

Hi Pranav,

Thanks for your reply but how I can track invoice against vendor delivery because from VendInvoiceJour/VendInvoiceTrans I can track the purcahse Order number only and same for VendPackingSlipJour/VendPackingSlipTrans
E.g; If we are taking the Packing slip number 'GRN-2’ from above example, it will give Purchase order number as ‘PO-1’ .Against ‘PO-1’ we have 2 invoices and here we have no way to identify the packing slip number.

Regards

4

Hi AX Gurus,

Any other comments???

Regards,

5

Did you find any solution ?

6

Hi Kalil,

The InventTrans table stores both Packing slip Id and Invoice Id from VendPackingslipTrans and VendInvoiceTrans tables.

while select VendtPackingSlipTrans
index hint TransIdIdx
join inventTrans
where vendPackingSlipTrans.InventTransId == vendInvoiceTrans.InventTransId &&
inventTrans.InventTransId == vendPackingSlipTrans.InventTransId &&
inventTrans.PackingSlipId == vendPackingSlipTrans.PackingSlipId &&
inventTrans.InvoiceId == vendInvoiceJour.InvoiceId

Regards,

Raghaav

7

Hi Raghav,

Thanks for your info, it works now…

8

Hi Raghav,

How can i link between vendor packing slip number and vendor Invoice number in ax dynamics 2012,

since the inventTrans not conatain anymore the field inventTransId !

thank you for help.

9

The inventtransid is now stored in table InventtransOrigin, then the recid of this table is stored in inventtrans.