How to check if customer invoice is paid in ByD via OData

[mathiasmueller-aico]

Dear SAP community,

I have a problem finding the correct Business Object name and field while configuring an OData service in SAP ByDesign.

I’m trying to check whether the client’s invoice is open or cleared. I found this article, but it didn’t help me much:https://community.sap.com/t5/technology-q-a/how-to-check-if-customer-invoice-is-paid-in-byd-via-webs...

I’m not sure which Business Object (BO) it should be. Has anyone else encountered this issue before?

To make things clearer, I’m including some screenshots below showing the exact location where the status is displayed.

In the OData Configuration Tool, I tried to select the BO name CustomerInvoice, but it doesn’t seem to be the correct one.

Can someone please assist me with this?

Best wishes!

   

[may_thitsaoo]

Hello,

BO should be TradeReceivablesPayablesRegister.
But you can use Reporting OData.

Go to Business Analytics - Design Reports WOC.
Select [Accounts Receivable - Line Items] report.
Click [Build OData Queries].
Select Attributes and Filters as you want.
Then you can create OData query service.

Ref : OData for SAP Business ByDesign Analytics 

Hope this helps.

Regards,

May

[mathiasmueller-aico]

Hi May,

[mathiasmueller-aico]

Hi May, thank you for the reply! The report itself is working and I am getting the Status field. When I try to build the Query, every single time I receive 0 results 😞

[mathiasmueller-aico]

Hi May, thank you for the reply! The report itself is working and I am getting the Status field. When I try to build the Query, every single time I receive 0 results :(. As far as I understand and also see in metadata, there are some mandatory filters, but in the UI I do not see them listed so I may filter based on them. I am pretty confused.

[may_thitsaoo]

Hello,

Yes, you need some filter prameters.

Here is the sample Odata query which works in our test tenant. 

(please update parameter values with your system real data)

https://my12345.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RPFINGLAU08_Q0001QueryResults?$select=CGLACCT,CCINHUUID,CIM_OP_IT_STAT,TIM_OP_IT_STAT,CACC_DOC_UUID_C&$filter=(CCOMPANY_UUID eq 'XXXXX')and (PARA_FISCYEARPER eq 2024010) and (PARA_SETOFBKS eq 'XXXXX')&$format=json

Regards,

May