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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Incorrect Legal Entity...
Microsoft Dynamics AX (Archived)

Incorrect Legal Entity on Offset Account for Customer Payment Proposal

(0) ShareShare
ReportReport
Posted on by Community Member

We are currently trying to run a payment proposal through the AR module but are seeing issues with the offset company accounts once we have generated the entry through the payment proposal option. 

2017_2D00_06_2D00_27_5F00_11_2D00_08_2D00_28.jpg

Once we run this it generates all the available transactions from all legal entities under the centralized payment. Once it has been pulled into the journal entries everything is correct except the offset company accounts field.

2017_2D00_06_2D00_27_5F00_11_2D00_10_2D00_01.jpg

It is currently populating only the entity in which the proposal is run, when I would expect it to populate to where the transactions is coming from as noted in red. I have tried changing the inter-company account set-ups for these entity between invoice, and payment and it didn't change anything. 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    That's actually a much better idea. The inter company is already a bit of a pain. Thanks for the help. Definitely will look into that a bit more.

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    You could probably modify the customer payment proposal to do what you want.

    But, posting a journal in company accounts 0002 that posts to a main account in company account 0012 and offsets to a main account in 0012 would create a mess of inter-company debits and credits, and probably leave your payment and invoice weakly linked.

    Perhaps another approach is warranted.  Why not build a simple class that accepts all the same parameters (or at least the ones you intend to use), and calls the payment proposal code while looping across all company accounts, and then posts the journals for you, and so on?  Seems like a much cleaner and AX friendly solution to the problem.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Brad Head,

    Thank you for this update.

    What I do not understand though is why you use a payment journal and select invoices for settlement if you want to expense items?

    This does not make sense to me.

    Can you explain a bit more on the process?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    As a company we are limited in our usage of AR. What we found works is using it to expense items from a large sum. Basically what we are looking to do is have both the main and offset dimensions head to the same entity. We currently run this process in every entity. Having the flexibility to run this once for all entities would save us a large amount of time on a weekly basis.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Just wondering whether you already had a look at the following website that describes the setup of centralized customer payments.

    technet.microsoft.com/.../gg243312.aspx

    Probably you have overlooked something ... or you want to do something else?

    In the latter case, it would be great if you could provide some additional information on what you try to achieve.

    Many thanks and best regards,

    Ludwig

  • Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    Typically the offset for an A/R payment journal is an account of type Bank.  It is 100% expected that it should exist only in the current company accounts where the payment proposal is being run, which is what "Centralized A/R" means.  If each invoice offset only to its own company accounts, then nothing about that process warrants "Centralized".

    What is it you are trying to accomplish with this unusual process?

  • Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    Please ignore.

  • Community Member Profile Picture
    Community Member on at

    I won't be able to post this transaction. Currently the 118-421 would fall under the account structure for 0012. If I attempt to post I will receive a validation error.

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

    Hello Brad,

    Have you posted the journal? Ax should generate the transactions for your other legal entity in the background once the journal gets posted. That is, the due to and from transactions will be created then. If you are unsure or have not done it before test this in a demo environment and check the vouchers generated.

    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

News and Announcements

Season of Giving Solutions is Here!

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 December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Volodya Profile Picture

Volodya 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans