Vendor Purchase order received qty entity name

(0) Share

Report

Posted on by Biren

Hi,

I'm trying to connect vendor purchase order with the invoiced quantity in D365 F&O. I want to know entity name where I can see invoiced quantity for the purchase order and balanced quantity for the same purchase order.

For example: purchase order PO123 with purchased quantity 100 unit. Received 40 and remaining quantity 60. I want to know where I can see 40 and 60 in the tables. I want to know entity name in D365 F&O.

Regards,

I have the same question (0)

All responses (17)

Answers (1)

Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this seems a duplicate post,

you could use data entity 'Purchase order lines V2' and also see the information on the line qty on PO header

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this seems a duplicate post,

you could use data entity 'Purchase order lines V2' and also see the information on the line qty on PO header

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this seems a duplicate post,

you could use data entity 'Purchase order lines V2' and also see the information on the line qty on PO header

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this seems a duplicate post,

you could use data entity 'Purchase order lines V2' and also see the information on the line qty on PO header

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this seems a duplicate post,

you could use data entity 'Purchase order lines V2' and also see the information on the line qty on PO header

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this seems a duplicate post, you could use data entity 'Purchase order lines V2' and also see the information on the line qty on PO header

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this seems a duplicate post,

you could use data entity 'Purchase order lines V2' and also see the information on the line qty on PO header

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

this seems a duplicate post,

you could use data entity 'Purchase order lines V2' and also see the information on the line qty on PO header

Was this reply helpful? Yes No
Biren 50 on at

Like (0)

Report

HI Rahul,

Thank you for the response. I don't see balanced quantity or delivered quantity in PO Line V2 and Header data entity. Only Purchased Order Quantity available on these tables.

Regards,

B

Was this reply helpful? Yes No
Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Biren,

I haven't seen an entity yet that would provide what you are looking for. the information is not stored in tables and is calculated dynamically even inside form when displayed.

You may be familiar with purchase line tab which displays open quantity, received, invoiced etc. Actually those are methods written on sales line that fetches data from invoice tables, receiving tables at run time and then display the appropriate values. What's invoiced remains in VendPackingSlipTrans tables only.

Here is what you can do.. best entity would be purchase line. It should have ordered qty, remainInventPhysical. What you can do is do calculation out there and see if that gets you required data. The only problem i see is canceled quantity as that's not tracked anywhere in the system.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Vendor Purchase order received qty entity name

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

Vendor Purchase order received qty entity name

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates