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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Account number for transaction type Sales order revenue does not exist - Reported from company accounts KPL

(0) ShareShare
ReportReport
Posted on by

I am trying to generate invoice from sales order and got the following error:

Sales order: XO_060B
Voucher SIV_00001281
Account number for transaction type Sales order revenue does not exist.
Reported from company accounts KPL
Posting has been cancelled.
An error occurred during update

I have seen that there are others who asked this question, but I followed the steps by Mahmoud Hakim and the Sales Order tab in Inventory Management > Setup > Posting > Posting already has the Revenue section with items, so that can't be the cause.

I am still a new user, please give patient and detailed instructions.

I also don't know what is the correct filter to use for this post, please advise.

I have the same question (0)
  • Suggested answer
    Ramit Paul Profile Picture
    22,797 Most Valuable Professional on at
    RE: Account number for transaction type Sales order revenue does not exist - Reported from company accounts KPL

    Hi,

    Please check your posting setup for revenue in sales order, and make sure the customer you are using that customer group is setup there with the item you are selecting.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Account number for transaction type Sales order revenue does not exist - Reported from company accounts KPL

    Hello Jun Ting Ho,

    Is the account that is used in the revenue section included in your CoA and not set inactive?

    Is this revenue account part of your account structures?

    Is your sales order probably related to an intercompany transaction and if this is the case, is the intercompany configuration of your accounts complete?

    Would be great if you could check those things.

    Many thanks and best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    299,249 Super User 2025 Season 2 on at
    RE: Account number for transaction type Sales order revenue does not exist - Reported from company accounts KPL

    Hi Jun Ting Ho,

    Can you share how you did setup the ledger account for the posting profile? Is it having a combination for specific customers, customer groups, item, item groups or is the account valid for all customers and all items?

  • Community Member Profile Picture
    on at
    RE: Account number for transaction type Sales order revenue does not exist - Reported from company accounts KPL
    [quote user="Ramit Paul"]

    Hi,

    Please check your posting setup for revenue in sales order, and make sure the customer you are using that customer group is setup there with the item you are selecting.

    [/quote]

    [quote user="Ludwig Reinhard"]

    Hello Jun Ting Ho,

    Is the account that is used in the revenue section included in your CoA and not set inactive?

    Is this revenue account part of your account structures?

    Is your sales order probably related to an intercompany transaction and if this is the case, is the intercompany configuration of your accounts complete?

    Would be great if you could check those things.

    Many thanks and best regards,

    Ludwig

    [/quote]

    [quote]

    Hi Jun Ting Ho,

    Can you share how you did setup the ledger account for the posting profile? Is it having a combination for specific customers, customer groups, item, item groups or is the account valid for all customers and all items?

    [/quote]

    Apologies Mr Ramit and Andre and Dr Ludwig, I am quite new to D365 F&O and was more-or-less thrown into the deep end without a formal beginner's tutorial and therefore don't understand a lot of these terms I'm seeing here:

    • Posting setup for revenue in sales order
    • customer group
    • CoA
    • account structures
    • intercompany transaction and configuration
    • ledger account for the posting profile

    May I know where to find them and what to do with them?

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    299,249 Super User 2025 Season 2 on at
    RE: Account number for transaction type Sales order revenue does not exist - Reported from company accounts KPL

    Hi Jun Ting Ho,

    I would suggest to first get training before you implement the system. On the top of this forum, you can find a 'Resources' menu with links to learning, blog, videos and TechTalks. The learning resources has some training for configuring the application.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Account number for transaction type Sales order revenue does not exist - Reported from company accounts KPL

    Hi Jun Ting Ho,

    Agree with Andre. Please check out the docs and learning sites first before trying to make a change to the system.

    Otherwise, things can end up in a mess.

    The following sites should give you a kick start:

    docs.microsoft.com/.../

    docs.microsoft.com/.../

    Best regards,

    Ludwig

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,157

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 883 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 674 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans