Thursday, January 4, 2024

Active Document Tables

 I was trying to enable attachments to General journal lines yesterday and ran into a real challenge finding the correct table to add to the Active Document Tables, until I realized you have to search the 2nd "Table name" column to find the Journal lines table.  Also, note that the "Reference table ID" value is not the same across different environments.





Another thing I learned - the +New button in document attachment isn't enabled until the General journal line is saved.

Always learning something new, no matter how long I've been at this!


Thursday, July 2, 2020

Fun with Financial Reporter - @ANY in Reporting Tree

Something else learned along the way last week . . .
1. The @ANY value, which is typically assigned only to the summary level, enables the reporting tree to be used for all companies. However, all child nodes must have a company assigned to them for the roll-up to work.

2. You can have multiple companies defined in Financial Reporter. If you select the company code @ANY, the FR default company is used to generate reports.
I had always assumed that @ANY also rolls all dimensions across all Companies up to the summary level as well - like below. But that is not the case.

Attached image - No description set

The Branch dimension in the example needs to be accompanied by a Company value on the line.

Attached image - No description set

This will roll the cross-company Branch results up to the summary level but the config in the previous image will not.


More fun with Fixed Assets . . . Part II - Mid month (15th of month) Convention

If you're using the Mid month (15th of month) Depreciation convention, there's a bug where if you edit the Remaining periods value, the asset will never fully depreciate. The final half month depreciation is left as NBV at the end of the asset life. Supposedly a fix is being investigated . . .

Attached image - No description set


More fun with Fixed Assets . . . Part I - Negative Depreciation

F&O wants to produce negative depreciation for 6 of the 12 months remaining, then make up the remainder of the depreciation in the last 6 months. This is a newly imported asset that we've updated the remaining periods on after it was acquired and after a Depreciation journal for accumulated depreciation as of 4/30/2020 was posted.

Attached image - No description set

Attached image - No description set

I did some testing on this and it seems F&O wants to depreciate based on the Service life for the remainder of the acquisition year, then switches to the balance of Remaining periods for final year. Very odd and probably a bug . . . 

Tuesday, June 23, 2020

Fixed Asset Depreciation Proposal Producing Inconsistent Results

D365 F&O, PU 34.  Fixed asset depreciation proposal was working inconsistently across assets in the same company, and across companies as well. Some assets in one company were depreciating, while others weren't. Likewise, assets were depreciating normally in some companies and not others.

After a couple hours of troubleshooting, discovered the cause was the Depreciation profile Calendar setting set to Fiscal/Period instead of Calendar/Month. Setting to Calendar/Month resolved the issue.


Tuesday, September 17, 2019

Processing a Customer Refund directly from Customer Payments Journal

I just learned this in the past week.  Did you know you can issue a Customer Refund without creating a Vendor and an AP Voucher?  It's true - you can process a payment to a Customer in the Customer Payment journal, exactly the same way as processing a Vendor payment in the Vendor payment journal.  Thanks to my friend Kingsley Abu for opening my eyes.

Check (pun intended) it out!


Wednesday, January 16, 2019

How to Change the 'Person' Associated with a User

Needed to change the Person associated with a User and discovered that if you select Maintain versions in the Users menu bar, you can edit the Expiration date on the record.


Set the date to a day previous to today's date, Save.


The Person field is cleared and you can select a different value.