Customer Receivables Aging report

[Former Member]

Hello Gurus,

I just want to know if it possible to modify the Customer Receivables Aging report through SDK. Currently, the report display only 4 columns e.g 0-30, 31-60, 61-90, 90+ depending on the interval specified. I want to add some columns to make it e.g 0-30, 31-60, 61-90, 91-120, 121-150 and so on.... Is this possible?

[Eneveux · Accepted solution]

Gilbert,

You do not have the option using the Business One SDK to modify reports in Business One. If you need to modify or create reports you would need to use the Business One Print Layout Designer or the XL Reporter or a third party application such as Crystal.

HTH,

Eddy

[Former Member · Accepted solution]

Hi Eddy,

Can I use UI API and create the same form like the Customer Receivables Aging report and integrate it with Print Layout Designer? Please help...

[Eneveux · Accepted solution]

Gilbert,

Unfortunately you cannot use the SDK to integrate with the PLD. You would need to use a Crystal Reports, as an example, for any customizations that you need a report for.

Eddy

[Former Member]

Hi,

Actually, if you are using SAP Business One 2005 and depending on the kind of modification you are planning you can use the ReportLayoutService of the DI API to change or create the reports in SBO.

I don't know in depth the Customer Receivables Aging report but if you managed to get the days in a column, you could use a formula to create the columns you need.

-M