cancel
Showing results for 
Search instead for 
Did you mean: 

B1WS/DI API How to get list of invoices for BP

Former Member
0 Kudos
139

Can anyone point me in the right direction.

I am looking to understand how to get a list of invoices for a BP (I have the cardcode id).

Then how would I get invoice items for each invoice.

I cannot see how it is done

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

What kind of output do you expect to get?

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon,

Basic info about the invoice - ref number, total amount, date etc, and then possibly allow the user to drill down and view the order items which make up the invoice.

This is part of a web based interface built using the B1WS webservices.

I can see that I could query the OINV table directly with SQL and then get the docnum but I am trying to keep to using the API (which is provided by the B1WS) rather than direct SQL.

Former Member
0 Kudos

To display them on the WEB, I do believe SQL query would be one of the most efficient ways.

Former Member
0 Kudos

Thanks for you help.

Is there not a way to get a list of invoices for a BP via the DI API?

I just want to check before I go ahead and use SQL to get the list.

Former Member
0 Kudos

By DI API, you still need to run SQL I believe.

Former Member
0 Kudos

Ok, then it will have to do

thanks.

Answers (0)