Omar takes a shot at SQL code to try to replicate some Fixed Assets History data. The problem is that Fixed Assets doesn’t really keep complete history so getting all of the information is problematic.
Yup , what you have explained is so true , but still you can get them with conditions , I mean first if you summarize the financial for Fixed Assets, this SQL will not work for sure , the thing is i started the script from FA00100 then FA00902 and tried to link the records there to GL20000 by batch number.
It is a problem as you mentioned , but i tested it mainly the second script it is better than nothing i would say.
1 comments:
Hello Mark,
Greetings,
Yup , what you have explained is so true , but still you can get them with conditions , I mean first if you summarize the financial for Fixed Assets, this SQL will not work for sure , the thing is i started the script from FA00100 then FA00902 and tried to link the records there to GL20000 by batch number.
It is a problem as you mentioned , but i tested it mainly the second script it is better than nothing i would say.
Post a Comment