D365 Finance & Operations and Dynamics AX Forum

​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
------------------------------

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
------------------------------

Original Message:
Sent: Jul 29, 2019 03:27 PM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

​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
------------------------------

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
------------------------------

Original Message:
Sent: Jul 30, 2019 11:14 AM
From: Patrick Hodo
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 29, 2019 03:27 PM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

​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
------------------------------

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
------------------------------

Original Message:
Sent: Jul 30, 2019 11:49 AM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 30, 2019 11:14 AM
From: Patrick Hodo
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 29, 2019 03:27 PM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

​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
------------------------------

Hi PAtrick,

I am not able to see this data entity.


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

Original Message:
Sent: Jul 30, 2019 12:15 PM
From: Patrick Hodo
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 30, 2019 11:49 AM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 30, 2019 11:14 AM
From: Patrick Hodo
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 29, 2019 03:27 PM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

​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
------------------------------

Hi, Sudhir

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

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

Original Message:
Sent: Jul 30, 2019 01:47 PM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

Hi PAtrick,

I am not able to see this data entity.

Thank you

Sudhir

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

Original Message:
Sent: Jul 30, 2019 12:15 PM
From: Patrick Hodo
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 30, 2019 11:49 AM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 30, 2019 11:14 AM
From: Patrick Hodo
Subject: Customer Payment Settlement by batch in D365

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

Original Message:
Sent: Jul 29, 2019 03:27 PM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

​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
------------------------------

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
------------------------------

Original Message:
Sent: Jul 29, 2019 03:27 PM
From: Sudhir Mahajran
Subject: Customer Payment Settlement by batch in D365

​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
------------------------------