cancel
Showing results for 
Search instead for 
Did you mean: 

Customer Invoice Request report

Former Member
0 Kudos

Hello Experts,

I want a report for Customer Invoice Request i.e. For Sales Order, Delivery done but not Invoiced.

Thanks in Advance.

Anant

Accepted Solutions (0)

Answers (2)

Answers (2)

lokesh2
Advisor
Advisor
0 Kudos

Hi Anant,

In some of issues we saw that with the data sources

Customer Invoice Item (CRMCIVIB)

Customer Projects (PROCPIU02)

An inner join was performed on the above mentioned data sources and were able to see both

'invoice id' and 'invoice request id' .

Try it out if this works for you.

Please mark the thread as answered/helpful if this answers your requirement.

Thanks

Lokesh Sharma

Former Member
0 Kudos

Hi lokesh,

I have tried with many ways but not get any solution.

I need exactly the same as Invoice Requests i.e. outbound delivery done but not invoiced.

former_member200567
Active Contributor
0 Kudos

Hi Anant,

How about joining Outbound Delivery Items and Sales Order Item data sources?

You can use Delivery status and Invoicing Status to filter Invoice requests.

Best Regards,

Fred

AnkushPashine
Advisor
Advisor
0 Kudos

Hello Anant,

There is no standard report available for Invoice Request ,but is for Invoice Volume and Invoice Document .

What is your use case to have report for Invoice Request , as Invoice Request is reference to various type of preceding document ?

Still if you want to have report ,please design your own report from 'Business Analytics' work center

as per your requirement .

Hope this help.

Regards,

Ankush.

Former Member
0 Kudos

HI Ankush,

For Sales Orders, i need a report in which Outbound Delivery done but for that deliveries Invoicing is not done.

AnkushPashine
Advisor
Advisor
0 Kudos

Hi Anant,

As mention in my previous note : In Standard there is NO Report available yet for 'Invoice Request'.

- You can design your own report using existing reports(with fields as per your requirement).

- OR you can addres it to Idea Forum on your requirement (if not possible via Designing your own customer report).

Hope this answer.

Regards,

Ankush.