Hello,
It's been a challenge importing Fixed Asset Master data.
I have tried import through
1. "Fixed Assets" Entity
2. "Fixed Assets V2 entity" Entity.
I have 2 Environments. Cloud version is 10.0.19 and VHD is 10.0.17.
The issues I'm getting are these:
1. On VHD the Import job in data management runs successfully showing all records inserted but in FA master form none of those records are shown. The Fixed Asset Group numbers in number sequence also gets utilized. Note: The HotFix which is mentioned in other posts to resolve this, is not applicable after Version10.0.17 onwards.
2. On cloud I'm getting this error while trying to update the 2 records I have already created manually:
Results. Cannot execute the required database operation.
The SQL database has issued an error.
Object Server Azure:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]UPDATE is not allowed because the statement
updates view "ASSETFIXEDASSETV2ENTITY" which participates in a join and has an INSTEAD OF UPDATE
trigger.
So I have couple of questions:
1. Is there a good blog or video that takes through the importing process. Because, GL, AP etc. imports were smooth. But FA is just too annoying.
2. Which entity do I have to use "Fixed Assets" or "Fixed Assets V2 Entity". What's the difference here?
Appreciate any tips.
Best Regards,
