Sage 200 Standard: Are custom reports able to be accessed via API calls to GET data

[Eddie Chadwick]

Hi there,

 

My current project at work involves creating dashboards within power bi and that in turn involves linking to our companies accounting software sage 200 standard edition. I downloaded the power bi component to link the 2 softwares and have successfully built dashboards off the standard data bought in through the api as well as expanding into the sage 200 api references to bring in Supplier invoices and products.

One major issue I have found though is when reporting on the cost of products purchased it can be inaccurate. This is because the api pulls average buying price of the product as the cost price for sales orders rather than the price paid at purchase order. I wanted to know if there was a way to access a custom report as an end point. By doing this it would enable me to pull the correct purchasing data along side the sales order data. Any suggestions on ways around this would be greatly appreciated. 

 

Regards,

Eddie