Track Packing Slip To Invoices

(0) Share

Report

Posted on by Community Member

What is the database relationship between AX Packing Slips from Sales & Marketing to Invoices in Accounts Receivable? How do I track which packing slips became which invoices?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

RamK 2,580 on at

Like (0)

Report

Relationship is CustPackingSlipTrans.InvoiceTransRefrecId==CustInvoiceTrans.RecID

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That's not it.

Was this reply helpful? Yes No
Suggested answer

Fredrik Sætre 12,644 on at

Like (1)

Report

CustPackingSlipTrans.InventTransId <--> CustInvoiceTrans.InventTransId

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Since this post lead me down the right bunny trails, I'm hoping that my additional question can be addressed...

When a SO line item has multiple packing slips (e.g., total quantity packed = 4, packing slip 1 on day 1 has quantity = 3 and packing slip 2 on day 2 has quantity 1), and they are invoiced together, how can you see which packing slip they came from? The invoice shows just 1 line for a quantity of 4. The CustPackingSlipTrans.InventTransId is the same even though they are on different packing slips. Attaching data shot from CustPackingSlipTrans.

thanks!

Carol

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Hi mdsj1970,

select custInvoiceTrans where custInvoiceTrans.InventDimId == custPackingSlipTransLoc.InventDimId && custInvoiceTrans.InventTransId == custPackingSlipTransLoc.InventTransId && custInvoiceTrans.Qty == custPackingSlipTransLoc.Qty && custInvoiceTrans.InvoiceDate == custPackingSlipTransLoc.DeliveryDate;

And

Please check this.

Thanks

Suresh

Was this reply helpful? Yes No
Samanth 517 on at

Like (0)

Report

Hi,

If i want to find a customer invoice based on delivery note. how is it possible?

Currently i do it like this. Sales & marketing, inquiries, journals, delivery note.
There I can find the sales order ID and then I can find a invoice number. This is not seamless.

Thanks,

Samanth

Was this reply helpful? Yes No
Suggested answer

makdax2012r3 50 on at

Like (0)

Report

I have written for AP purchase order vender packing slip and invoice view same you can do for sales table in AR.

linking packing slip and invoice table use following join.

left join VendInvoicePackingSlipQuantityMatch Vinvpackqm on Vinvpackqm.PACKINGSLIPSOURCEDOCUMENTLINE =vpst.SOURCEDOCUMENTLINE --and Vinvpackqm.DATAAREAID = pt.DATAAREAID
left join VENDINVOICETRANS vinvt on vinvt.SOURCEDOCUMENTLINE = Vinvpackqm.INVOICESOURCEDOCUMENTLINE

------------------------- and you can also use following relation if you want to show purch line data like qty line number etc. -----------------------------------------

VENDPACKINGSLIPTRANS.INVENTTRANSID = Purchline.INVENTTRANSID

VENDINVOICETRANS.INVENTTRANSID = Purchline.INVENTTRANSID

select pt.PURCHID 'po num',pt.OrderAccount 'vendor code',pt.PURCHNAME'Vendor Name' ,pl.LINENUMBER ,pl.ITEMID,pl.NAME,pl.PURCHQTY,
vpst.PACKINGSLIPID, vpst.QTY 'PACKINGSLIP recv qaty',vinvt.INVOICEID,vinvt.QTY 'inv Qty',vinvt.LINEAMOUNT
from PURCHTABLE pt
inner join PURCHLINE pl on pt.PURCHID = pl.PURCHID and pt.DATAAREAID = pl.DATAAREAID
left join VENDPACKINGSLIPTRANS vpst on vpst.INVENTTRANSID = pl.INVENTTRANSID and vpst.DATAAREAID = pt.DATAAREAID
left join VendInvoicePackingSlipQuantityMatch Vinvpackqm on Vinvpackqm.PACKINGSLIPSOURCEDOCUMENTLINE =vpst.SOURCEDOCUMENTLINE --and Vinvpackqm.DATAAREAID = pt.DATAAREAID
left join VENDINVOICETRANS vinvt on vinvt.SOURCEDOCUMENTLINE = Vinvpackqm.INVOICESOURCEDOCUMENTLINE
where pt.DATAAREAID='USMF' and pt.PURCHSTATUS <>'4' and pt.DOCUMENTSTATE <>'0' and Pt.PURCHID='000021' and vpst.QTY<>0

----------------------------------------- 2nd query---------------------------------

select pt.PURCHID 'po num',pt.OrderAccount 'vendor code',pt.PURCHNAME'Vendor Name' ,pl.LINENUMBER ,pl.ITEMID,pl.NAME,pl.PURCHQTY,
vpst.PACKINGSLIPID, vpst.QTY 'PACKINGSLIP recv qaty',vinvt.INVOICEID,vinvt.QTY 'inv Qty',vinvt.LINEAMOUNT
from PURCHTABLE pt
inner join PURCHLINE pl on pt.PURCHID = pl.PURCHID and pt.DATAAREAID = pl.DATAAREAID
left join VENDPACKINGSLIPTRANS vpst on vpst.INVENTTRANSID = pl.INVENTTRANSID and vpst.DATAAREAID = pt.DATAAREAID --and vpst.ITEMID = pl.ITEMID --and vpst.VENDPACKINGSLIPJOUR= vpsj.RECID and vpst.DATAAREAID = pt.DATAAREAID
left join VENDINVOICETRANS vinvt on vinvt.INVENTTRANSID =pl.INVENTTRANSID and vinvt.DATAAREAID = pt.DATAAREAID -- vinvt.RECID = vpst.InvoiceTransRefRecId

where pt.DATAAREAID='USMF' and pt.PURCHSTATUS <>'4' and pt.DOCUMENTSTATE <>'0' and Pt.PURCHID='000021' and vpst.QTY<>0

Was this reply helpful? Yes No