Finance | Project Operations, Human Resources, ...

How to get opening balance for a month

(0) Share

Report

Posted on by josephsilvester

165

Hi All,

Could someone help me how to get opening balance for a month?

Thanks,

Silvester

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Ramit Paul 22,799 Most Valuable Professional on at

Like (0)

Report

Hi,

Kindly go to general ledger- Inquires and reports- trail balance- run the trial balance- check your required main account- see the opening balance.

Please let us know if this helps or provide more info.

Was this reply helpful? Yes No
josephsilvester 165 on at

Like (0)

Report

Hi,

Iam checking through postman and would like to get the balance using any Entities . Currently Iam able to retrieve transactions. But it do not have opening Balance.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi joseph,

The opening balance is defined on the period that you select.

If you select for example the period 1st September to 30 September then the opening balance is made of the accumulated transactions up the 1st September.

In case you select a different period then this principle is applied likewise.

If you plan to do the calculation of opening balances outside of D365FO then be careful about a couple of things, such as the nature of the account - P&L accounts do not have an beginning of the year opening balance - the period selected and alike.

Best regards,

Ludwig

Was this reply helpful? Yes No
josephsilvester 165 on at

Like (0)

Report

Hi Ludwig,

Thanks for the replay. If Iam using 1st September to 30 September is it possible to get the closing balance of August such that I can add that to September balance using any Entity ?

Thanks,

Silvester

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Silvester,

It's not possible to get such kind of data through entity. I recommend to take a look at oData action or web service.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Silvester,

Unfortunately, this is not possible.

I also think that oData is not really an option because it is most probably too slow for the volume of data that you record. Also, we don't have an entity for exporting accounting related posting data.

Is the use of the financial reporter an option?

This tool has all features available to calculate opening balances as you like.

Have you tried that tool?

Best regards,

Ludwig

Was this reply helpful? Yes No
josephsilvester 165 on at

Like (0)

Report

Hi Sergei,

Can you please post a sample how to use OData for this.

Thanks,

Silvester

Was this reply helpful? Yes No
josephsilvester 165 on at

Like (0)

Report

Hi Ludwig,

I want get the balance using my script.

Thanks,

Silvester

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (1)

Report
Hi Silvester,

For oData action you will need to create a new method on the entity (please note that CoC doesn't work in this case and you need to use existing entity you have access to or to create a new entity just to store oData action). To be honest, I'm not sure about the response message size limitation, but there are are some limitations for the request message.

[ Hookable(false), SysODataActionAttribute("MyOdataAction", false), ] public static str myOdataAction(..parameters..) { // do some code based on parameter return ..result you want }

Sometimes it's much easier to implement web service instead of OData, as oData action has few limitations, and web service can be consumed as JSON service.

For web-service examples, you can check the Service\Services node in Application Explored in VS.

docs.microsoft.com/.../odata

docs.microsoft.com/.../custom-services

Was this reply helpful? Yes No
josephsilvester 165 on at

Like (0)

Report

Hi Sergei,

I want to use OData to get the Balance as Updating code for each client is not feasible. My plan is if I can get the opening balance of a month I can add that to the sum of credit and debit.

Thanks,

Silvester

Was this reply helpful? Yes No