web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Project invoice Credit...
Microsoft Dynamics AX (Archived)

Project invoice Credit note

(0) ShareShare
ReportReport
Posted on by Johan_K

HI I have a customer that have an issue when they trying to post a credit note for a project invoice.

AX is taking the exchange rate from the date when the original invoice was posted on account 3010.

But when posting to account 1510 AX takes  the exchange rate from 2017-08-31.

Please have a look below on the error message.

It would be great if someone had some input into this issue.

Prerequisites

2017-06-30 Project invoice proposal created and project invoice posted. With exchange rate of 9,6

2017-07-31 Exchange rate re-calculation Exchange rate = 9,5

2017-08-31 Exchange rate re-calculation Exchange rate = 9,4

2017-09-14 Credit of the project invoice posted the 30:th of june

 

Project contract ID: XXXX

Voucher XXX

The transactions on voucher XXX do not balance as per 2017-09-14. (accounting currency: 250.2 - reporting currency: 250.2)

Voucher transactions

Voucher XXXX , date 2017-09-14, account 3010-XXX-XXX--XXX-, transaction currency amount 1 050, accounting currency amount 10080, reporting currency amount 10080, currency EUR, text  = Exchange rate: 9.6

Voucher XXXX, date 2017-09-14, account 3010-XXX-XXX--XXX-, transaction currency amount 201,00, accounting currency amount 1 929,6, reporting currency amount 1929,6 currency EUR, text

Voucher XXXX, date 2017-09-14, account 1510-, transaction currency amount -1 251,00, accounting currency amount -11 759,4 , reporting currency amount -11 864,36, currency EUR, text

Posting has been canceled.

 

 

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Johan_K,

    What is account 3010 and what is account 1510 used for?

    Can you share the posting types that have been used when the original invoice was created?

    Can you also let us know where and how you created the credit note?

    In addition, can you share the AX2012 Version you are operating on? (cu8, 9, 10, ...)

    Many thanks and best regards,

    Ludwig

  • Johan_K Profile Picture
    Johan_K on at

    Hi Ludwig, They have AX 2012 R3 CU 10.

    The 1510 is the summary account for accounts receivable, 3010 is the invoiced revenue set up on the project group.

    The original invoice was created from the project module and was regarding subscriptions. First they create an invoice proposal and then thy post the invoice so no strange things there.

    When they credited the invoice they marked the transactions that should be credited, and after that they created an invoice proposal to continue post the credit invoice.

    The postingsetup for the projectgroup is as follows.

    Revenue Accounts:

    Invoiced revenue 3010
    Accrued revenue -subscription 3913
    wip subscription  2970

    Ant then they have the 1510 as the accounts receivable account on the customer posting profile.

    You can see the voucher posting below I hope the picture got quite small:).

    2017_2D00_09_2D00_21.png

    I got some more information the customer told me that they have never had this issue with a sales order invoice.

    Regards Johan

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Johan,

    Maybe you can create a workaround to overcome this issue by establishing a fixed rate

    agreement at the project contract level. Have you tried making use of this feature?

    Other than that and provided that you can replicate the issue, I would suggest to contact the MS support. There have been a couple of hotfixes issued with cu11, cu12 and cu13 and you might be able to get it fixed through one of those hotfixes.

    Best regards,

    Ludwig

  • Johan_K Profile Picture
    Johan_K on at

    Hi,

    thanks for a quick reply, no I haven't used the fixed rate option. How do I do that?

    Regards Johan

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Johan,

    In the project contract that is linked to your project you can find a fixed rate agreement button where a fixed exchange rate can be specified. Not sure if this fixes your issue but it might be worth testing.

    Best regards,

    Ludwig

  • Johan_K Profile Picture
    Johan_K on at

    Hi,

    I will definitely try this option.

    Regards Johan

  • Johan_K Profile Picture
    Johan_K on at

    The solution with the fixed rate work.

    Many thanks:).

    Regards Johan

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans