How do I build my own reports?

Modified on Wed, 1 Nov, 2023 at 4:51 PM

Softbase Evolution allows users to build their own reports via all the popular reporting tools such as Microsoft Excel or Microsoft Power BI. Any reporting tool that supports the OData standard can be used. 


Below are the data points currently available via OData. 

You can add the following filter to the end of a URL to return only the top 10 lines of data: ?$top=10 


GL: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/gl


GL Detail: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/gldetail


Customers: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/customer


Equipment: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/equipment


Vendor: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/vendor


Invoice Register: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/invoicereg


Part: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/part


AR Detail: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/ardetail


AP Detail: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/apdetail


WO: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/wo


WO Labor: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/wolabor


WO Misc: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/womisc


WO Parts: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/wopart


WO Quote: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/woquote


WO Equipment: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/woeq


Chart Of Accounts: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/chartofaccount


Equipment PO Detail: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/equipmentpodetail


Misc PO Detail: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/miscpodetail


Order: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/order


Orders Received: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/ordersrecv


Person: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/person


PM: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/pm


PM Name: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/pmname


PM Parts: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/pmpart


PM Secondary: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/pmsecondary


PM Status: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/pmstatus


PO Header: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/poheader


WO Rental: https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/worental

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article