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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Can you split an Accou...
Microsoft Dynamics AX (Archived)

Can you split an Accounts Receivable between multiple natural accounts per customer?

(0) ShareShare
ReportReport
Posted on by Tim Meyer 180

Need some advice on configuration of AX 2012. For our customers, there is a fee based on each line item. For each line item a certain amount of the fee needs to be tracked under different natural accounts.  So for example, if Customer A buys Item 1 for $200 we need to track in AR that $195 is for account 1234 and then remaining $5 is for account 5678.  The invoice to the customer however would only show a line item for $200.  Its almost like having multiple ARs per customer (which you can't have, can you).  Any pointers?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Joris dG Profile Picture
    Joris dG 17,775 on at
    Re: Can you split an Accounts Receivable between multiple natural accounts per customer?

    If you cannot find a functional way out of this and are forced to customize AX, keep this in mind:

    Customizing transaction logic is always risky and requires lots of testing, and puts you on track for trouble on future upgrades including service packs. Technically, what you are wanting to do can be done, but it will just show up wrong on an invoice. Consider the possibility of doing the transactions the way AX works, but modify the report to total them back up the way you want. Far less risky and no business logic modification, just a report change. Of course it may put a burden on order entry or other reporting requirements. But something to think about.

  • Tim Meyer Profile Picture
    Tim Meyer 180 on at
    Re: Can you split an Accounts Receivable between multiple natural accounts per customer?

    Thanks Joris.  This is one way we are investigating handling it.  Book the AR the way it is received in AX but during reporting or export to corporate book system (Oracle) do the splits.

    Any idea if posting definitions might be a solution?

  • Joris dG Profile Picture
    Joris dG 17,775 on at
    Re: Can you split an Accounts Receivable between multiple natural accounts per customer?

    I don't think what you're trying to do is exactly possible with standard functionality. I would inquire again about the exact reason this is being done, it may give some insights. For example, is the reason that there is a standard freight charge in the standard item's price and they want to book that separate? If so, should you do an automatic miscellaneous charge instead of having it as part of the item's standard price? There are always a ton of ways to approach a problem, so I would go back to the original requirement, why does this need to be split out, and take it from there. Perhaps there should be two items instead of just one and maybe that's what you should focus on, etc, etc....

  • Khaled Alloud Profile Picture
    Khaled Alloud 3,658 on at
    RE: Can you split an Accounts Receivable between multiple natural accounts per customer?

    Hello Tim,

    Please advice if the issue is not solved. You may use Ledger allocation rule functionality for your request.

    regards,

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans