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 —————————— ——————————————-
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
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!