Finance | Project Operations, Human Resources, ...

Open product receipt report which is not matched / settled with any PO invoices in D365

(0) Share

Report

Posted on by PujariD365

Hello Experts,

I have a requirement from the customer. They are looking for such a report where system will display below details.

> Only open product receipt numbers (which is not yet matched / settled in any PO invoices).
> Purchase order number where this product receipt is posted.
> Vendor account number against of which this PO is created.

I have checked all standard reports in AP and in Procurement and sourcing module but so far nothing has been identified where I can display all these information. I have checked by adding filter in report generation parameters too but no luck yet!

Is there any standard report or filter available in any report which may be I am overlooking?

Looking forward for your input on this.

N.B. Invoice matching details is not enabled in ERP as agreed with the customer during implementation.

Thanks and regards,

Pujari

I have the same question (0)

All responses (9)

Answers (0)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi PujariD365,

You can create a report using the Excel add-in. The entity purchase order headers and/or lines can be used to retrieve the information.

Another option is considering the development of a custom report

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Pujari,

Have you seen the Accounts payable > Inquiries and reports > Product receipt?

Use advanced filter to join the PO and filter the received status.

Was this reply helpful? Yes No
PujariD365 80 on at

Like (0)

Report

Dear All,

Thank you for your time and response on this.

Hi Mattguo,

I have checked but not getting any option to join the table as you showcased. I am using 10.0.6 and pu30. Which version you are using?

This is what I am getting and no option to add anything like "Purchase order" as you have shown!

Appreciate if you kindly share some more information on this so that I can check further.

Thanks and regards,

Pujari

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Pujari,

Your current selection is Table, so it won't work. Select Vendor product receipts (1 level down) and then "Add table join" will get activated from there you can add another table.

Was this reply helpful? Yes No
PujariD365 80 on at

Like (0)

Report

Hi Satish,

Thanks for the information.

Can you please tell me how can I add / join product receipt amount in that?

Thanks & regards,

Pujari

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Pujari,

Don't see a way to add the amounts on this report. The reports primary data source is vendPackingSlipJour which doesn't store the information. You may be able to add tables but won't be able to add the fields from those tables on the report. You would need some customization to get that information.

Instead of customization, what you should do is start using the inquiry form from AX. it's under procurement & sourcing > Purchase orders received but not invoiced.

Notice that under journals > product receipt is there so user can easily inquire. From a financial perspective, the GL (received postings should give you all the $$ amounts in total). Review your options prior to going down the path of customizations.

Was this reply helpful? Yes No
PujariD365 80 on at

Like (0)

Report

Hi Satish,

Thanks again!

I am actually using D365 with PU30. I am not able to see any such option "Purchase orders received but not invoiced." Could you kindly tell me where I can see that?

I tried by filtering in below area which is actually directing in the All purchase orders form. I further tried by adding column through personalization to display product receipt value but no luck!

Is that the correct path I am checking? Can you please help me here!

Thanks & regards,

Pujari

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

You are doing everything alright here... I reviewed the original question again and it started with you looking for product receipts that didn't get invoiced yet. The screen above is going to show you only the received PO, no receipts. Apologies for confusion. I doubt if something like that exists. The inquiry that you were using above was showing all receipts (the suggestion was to add the PO status). but what if PO is partially received. factor that in while coming up with a solution. What you have above is the best out of the box.

Was this reply helpful? Yes No
PujariD365 80 on at

Like (0)

Report

Hi Satish,

Apology for the confusion from my end too.

Customer actually looking for a report where we have to display the posted product receipt amount which is not yet settled in vendor invoices. But now it seems need to develop either a new report or add an additional column in Product receipts form in inquiries and reporting section.

Anyway... thanks again for your time and effort on this.

Regards,

Pujari

Was this reply helpful? Yes No