Global Accounts Receivable Aging 10+ legal entities

  • Global Accounts Receivable Aging 10+ legal entities

    Posted by DSC Communities on February 7, 2020 at 10:25 am
    • Terra Rollins

      Member

      February 7, 2020 at 10:25 AM

      Hello, is there a way to run a “Global Accounts Receivable Aging” for 10+ legal entities all at once?

      ——————————
      Terra Rollins
      Controller
      Augeo Affinity Marketing
      St. Paul MN
      ——————————

    • Mark Schurmann

      Member

      February 10, 2020 at 10:09 AM

      The process to age your accounts receivable will allow you to select multiple legal entities on the parameters screen.Ā  You should schedule this to run nightly so that your aging is always current.Ā  I believe if you select multiple legal entities, D365 will create separate batch jobs for each legal entity.Ā Ā 

      If you are talking about a global aging report.Ā  I would suggest exporting the customer and account receivable aging data entities to a BYOD database.Ā  That will provide the aging data for all legal entities in a single table.Ā  From there you can create a report in Excel or tool of your choice.Ā  Unless you customize the account receivable aging data entity to be cross-company, you will have to create and schedule a batch job to export the aging data for each legal entity that you are interested in.

      ——————————
      Mark Schurmann
      Accounting Systems Manager
      Automobile Protection Corp
      Norcross GA
      ——————————
      ——————————————-

    • Gary Gong

      Member

      February 10, 2020 at 4:37 PM

      The periodic task: Age Customer Balances is set to run for each legal entity. But you can set a batch job to run each legal entity of AR customer balances at the end of day while no one is using the system each night so that you have the latest Customer Balance Aging Snap shot for the next day. This is one time setup for each legal entity for all of your companies.
      Credit and Collections>>Periodic tasks>Age Customer balances. Click Parameter you will see the Company Range tab where one current legal entity is checked. Go to the tab Run in the background and check Batch Processing and go the Recurrences to set up your daily routnines.
      Hope this will help!

      ——————————
      Gary Gong
      Independent Solution Architect for Dynamics 365 Finance and Operations
      ORLANDO FL
      ——————————
      ——————————————-

    DSC Communities replied 6 years, 3 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Global Accounts Receivable Aging 10+ legal entities’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!