Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Additional data feilds...
Finance forum
Unanswered

Additional data feilds in the AssetTrans Table

(1) ShareShare
ReportReport
Posted on by OS-03071515-0 12
Hi,
 
We have a report setup on Power BI to bring back Fixed Asset Transactions, this looks at the AssetTrans Table.
 
 
In the last week 2 new data fields have been added to the AssetTrans table exported from D365 F&O, this has resulted in issues with the report. The additional data fields added are:
 
"PERIODFROMDATE"
"PERIODTODATE"
 
But I cant see these data fields in the Asset Transaction Form on D365 - My question is what is triggering these changes to the AssetTrans Table, I have checked there was nothing in patch update or quality update.
 
Also how can we keep track of changes to tables?
 
Any help will be appreicated 
 
 
 
 
Categories:
Financial Management
  • Layan Jwei Profile Picture
    Layan Jwei 7,071 Super User 2024 Season 2 on at
    Additional data feilds in the AssetTrans Table
    Hi,
     
    You said after adding those fields, you started having issues with the report, may i know what the issues are? Or do you mean thay u don't want these fields to appear in the report?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,524 Super User 2024 Season 2 on at
    Additional data feilds in the AssetTrans Table
    Hi,
     
    Can you tell how you export the Asset transactions to Power BI? Are you using Export to Data Lake, BYOD, Synapse Link, Fabric link? Do you then export the table directly or details via a data entity?
  • OS-03071515-0 Profile Picture
    OS-03071515-0 12 on at
    Additional data feilds in the AssetTrans Table
    Hi,
     
    Sorry my post was a bit confusing.
     
    Yes we use this table through Power BI & we connect via data entity.
     
    The problem is 2 weeks ago it had 48 data fields, but it now has 50 data fields ("PERIODFROMDATE" "PERIODTODATE") I wanted to know what triggered this additional fields to appear?
  • Waed Ayyad Profile Picture
    Waed Ayyad 5,451 Super User 2024 Season 2 on at
    Additional data feilds in the AssetTrans Table
    Hi,
     
    I'm not sure if I understand you issue correctly, but you use this table through Power BI, do you connect to power BI using data entity? also, when you said you don't see the fields data on Form, do you mean the fields aren't filled? or have not appeared on the form?
     
     
    Thanks,
    Waed Ayyad

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans