Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sudhir Mahajran]

?Hi All,

Below is the scenerio that i am runnign through.
My customer has a subscription based business where revenue must be recognized over a period of 12 months.

1. All customer sales order are created out of D365 in some third party tool.
2. All customer payment is being processed out of D365 in some third party tool.

Requirement

1. All the sales invoice needs to be brought to D365.
2. All the payment needs to be posted to defered revenue account whcih is acomplished by the item posting profile. Item is set to post revenue to defered revenue instead of Revenue

Revenue Recognition process

1. We are bringing all sales order invocie daily into D365 by batch job
2. We are bringing all payment to D365 by batch job.
3. We will recogninze revenue on the last working day of every month and post them with future date for the next 12 month.

Key challenges.
1. How can we settle customer payemnt with invoice with batch job. Has anyone went through this process if it is possible?

Please advise.

Thank you

Sudhir

——————————
[Sudhir] [Maharjan] [srmaharjan@hotmail.com]
[AX Consultant]
Lawrenceville NJ
——————————

[Patrick Hodo]

Hi, Sudhir

Are you looking for a product-based solution or a technical-coding solution?  Since you are importing both the invoices and the payment into Dynamics 365, it sounds like you are mostly looking for a technical solution to settle payments against invoices.  Can you clarify?

——————————
Patrick Hodo
Chief Technical Officer
Red Maple
boerne TX
——————————
——————————————-

[Sudhir Mahajran]

Hi Patrik,

I am looking into technical or out of box solution for this. Since we are bringing sales order invocie and payment, I am looking for a way to settle them in D365.

Please advise.
thank you

sudhir

?

——————————
[Sudhir] [Maharjan] [srmaharjan@hotmail.com]
[AX Consultant]
[SAGlobal]
Lawrenceville NJ
——————————
——————————————-

[Patrick Hodo]

If that is the case, I would look at MCRCustPaymTotals.settlePayments to see how it would be done.

——————————
Patrick Hodo
Chief Technical Officer
Red Maple
boerne TX
——————————
——————————————-

[Sudhir Mahajran]

Hi PAtrick,

I am not able to see this data entity.

Thank you

Sudhir

——————————
[Sudhir] [Maharjan] [srmaharjan@hotmail.com]
[AX Consultant]
[SAGlobal]
Lawrenceville NJ
——————————
——————————————-

[Patrick Hodo]

Hi, Sudhir

It is not a data entity.  It is a class.

——————————
Patrick Hodo
Chief Technical Officer
Red Maple
boerne TX
——————————
——————————————-

[Zvika Rimalt]

1. One simple way to get customer receipts (payments) to settle against invoices is to turn on the auto-settlement (through an AR parameter, and a checkbox on the posting profile on both the sales invoice and the payment.

This tend to be a bit “brute force” as you only have limited control about which payment settles with what invoice, but it works well in many scenarios.

2. In current project we used LogicApps scripts to interface into D365, and I believe that script was able to also perform the settlement – this was more specific (since we wanted to payment to be settled with one specific invoice out of all the other existing invoices of that customer)

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-