News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Query data when create...

Microsoft Dynamics AX (Archived)

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

(1) Share

Report

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

All responses Img

All responses (1)

Answers Img

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).

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans