Showing posts with label D365. Show all posts
Showing posts with label D365. Show all posts

Thursday, March 25, 2021

D365 Finance & Operations : Clearing cache to refresh the data in tables and forms

 Recently we came across a problem where the data in the tables is not getting refreshed with the updated data (especially in master tables such as Customers, Vendors, items etc.,) . This normally happens when you have a large implementation and there are more than 10 AOS. Since D365 FO is a web based ERP it uses techniques for data caching to retrieve the data faster.


To overcome this problem, open a new tab in the browser (in the same browser where you FO instance is open) and type the below url (replace the underlined portion with your FO url). Once this is done, the caching issue should be resolved.

https://<D365FO url>/?mi=SysclassRunner&cls=SysFlushData

Thursday, January 31, 2019


Automatic allocations from GL in D365

Most of you are aware of Allocation rules in AX 2012/ Dynamics 365. Instead of an allocation journal at the month/ period end, it can be automated in the system to allocate a specific percentage across GL accounts and Dimension segments. An allocation rule can be setup and attached right in the Main account setup itself.
For example, All the audit related expenses are debited to ‘Audit expense’ in the normal accounting process and it needs a re-allocation to ‘Audit-Tax’ and ‘Audit-Financial’ based on some criteria. Instead of manual re-allocation or running allocation at month-end it can be setup to allocate simultaneously.

Add Legal entity overrides in the Main account form for the Company in discussion




Flag Allocation check box on Legal entity overrides
Once flagged Allocation terms button on the ribbon above it will get enabled



Click on Allocation terms to create allocation rule:
You will see

-        Percentage of allocation
-        Source criteria setup and
-        Destination criteria setup






To continue with the example, allocate to Audit expense to 70% to Audit-Financial and 30% to Audit-Tax.

70% to Audit-Financial



30% to Audit-Tax




Close the form to complete setup.

Post a transaction to see the postings
Post an amount of $1000 to Audit expense



Verify the voucher after posting. It posts to the above account and then allocates within the same voucher. See the allocations 70% to Audit-Financial and 30% to Audit-Tax



Sunday, January 13, 2019

How to attach files/ documents after posting Journal (General, Invoice, Payments and Expense) in Dynamics 365 (D365)

General functionality available in Dynamics 365 (D365):

D365 provides a feature to attach documents of various business types when a journal is created from any module. Click on the paper clip button as shown below to open attachments work space

Attachments option is available as long as the journal is not posted



Once the journal is posted, New button in attachments form gets disabled



Most of the business will require to attach documents even after posting journals for Audit purposes. In order to do this, respective journal tables have to be enabled in Active documents tables. Follow the steps to enable journals for attachments even after posting

1. Navigate to Organization and administration > Document management > Active document tables, Click to add required table names in the list. Table names for journals are
            a. LedgerJournalTable
            b. LedgerJournalTrans


2. Flag "Always enabled" check box


Once the setup is complete, Attachments get enabled even after posting journals