Hello,
This is going to be a little tricky without being able to see all the data.
The records that are showing in the window are held in three tables if they are saved in this window. FA00902, FA00905 and the FA15000 table. Neither of these tables actually hold the Asset ID. What they hold that links to the Asset ID is the AssetIndex column.
The AssetIndex value can be used to link back to the FA00100 table which is what is going to hold the Asset ID.
When you add an asset, or depreciate an Asset, the record gets added to the FA00902 table. when run the GL Posting Routing, it created a records in the FA00902 and the FA15000 table that is associated the record in the FA00902. It will also update the column GLINTBTCHNUM with the Batch ID from the GL Post window.
Since we do not hold the Assetid itself in these table, I am assuming this pull the Asset Id from the FA00100 table which is really the only table that would be used in in this process that has this column.
Before any messing with the FA00902, FA00905 and/or FA15000, we need to understand that if these table become out of synch, you will start to get error during depreciation and other fa processes and is really difficult to fix. I do not suggest you mess with any of these tables in SQL unless you fully understand what ramifications can occur. Any actions taken on these tables by anyone, are solely responsible for any said ramifications that occur.
Testing this, if I set my Assetindex to blank or zero in the FA00902 and FA00905, it does change how my AssetID displays in the GL Posting window, however, it does not show as Asset No Found. Honestly, I am not sure this would be a valid message. The message is broken English. I would expect Asset Not Found.
My suggestion would be to look and see if you possibly have an asset that is call Asset No Found and why it is showing this just to be sure its really not the Asset ID.
If you do not find one, I would determine how the Asset was deleted because you can't just delete the Asset General Information. You can delete the Book. Deleting the book would delete the FA00902 but I still am unable to get the Asset No Found.
If the Asset was deleted using the Delete Asset Utility the record out of the FA00902. Any records already created in the FA00905 would still be there so if you had records in the GL Posting window saved, those would be remaining. Again though, mine does not show Asset No Found.
As you re-added the asset, could be a conflict between Asset Index if you used the same name. Further data analysis would be needed.
If you need help digging into this further, I would suggest contacting your Partner or Microsoft so the data can be analyzed further. If you do not have both, you can certainly look for a party to help.
The information is provided As-is. Any steps taken by the information, are owned by the person taking the steps as the above is informational only.
Brandon
Share
Report
All responses (
Answers (
413
