Query data when create PO direct delivery from Sales order in AX 2012

(1) Share

Report

Posted on by Shinji Hoang

237

Dear Experts,

I want to create SQL query to get data sales order(SO, packing slip, invoice), purchase order(PO, product receipt, invoice) when I create PO direct delivery from sales order.

Get information:

SalesId, ItemId, Sales Qty, Sales Amount, PurchId, ItemId, Purch Qty, Purch Amount, Packing slip number, Product receipt number, Delivery date, Cust Invoice Id, Cust Invoice Qty, Cust Invoice Amount, Vendor Invoice Id, Vendor Invoice Qty, Vendor Invoice Amount.

Could you please advice me?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Rustem Galiamov 8,072 on at

Like (1)

Report

RE: Query data when create PO direct delivery from Sales order in AX 2012

Hi Sacramento!

To achieve this you need to use SalesTable, SalesLine, PurchTable, PurchLine, CustPackingSlipJour, VendPackingSlipJour, CustInvoiceJour, CustInvoiceTrans, VendInvoiceJour, VendInvoiceTrans tables.

When you create PO from SO, the SO and PO are linked by lines (InventRefId and InventRefTransId fields).

Was this reply helpful? Yes No