Share
Reportis there a limit on the number of assets you can import to the FA module?
Categories:
You’re offline. This is a read only version of the page.
5
is there a limit on the number of assets you can import to the FA module?
Oh OK - so it sounds like we are OK from a system limitation perspective. We are considering moving tax to GP as well - I would assume having an additional book ID would not have any impact? My guess is records for each would be housed in different tables?
30k assets is definitely on the higher end of the number of assets i have seen. Really the limit is the amount of time it takes to process depreciation\ FA to GL posting when you have a huge number of assets.
Eventually one could theoretically hit the max int value for FA00902's FINANCIALINDX column (each distribution line against\ an asset book is logged in this table) but even assuming a high end of 2000 distributions over the life of an asset (for example if all assets need a bunch of resets ran against it) it would still take over a million asset\book combinations to hit SQLs max int value of 2147483647 for the column, even then if you hit that number it would potentially just roll over to -2147483647 and start counting up from there like it can sometimes do with sequence numbers on big GL\PM\RM transactions.
and we also import hundreds of assets at a time w/ no issues - just wondering if any system limitation on total # assets - but sounds like there is not
we are using the import/export tool - we have approx. 30K now - we reached a 32K limitation w/ a different software we currently use for tax, which made me curious if there was any sort of limitation w/ GP (which we are currently using for book)
Fixed assets include property, plant, and equipment (PP&E) and are recorded on the balance sheet with that classification.
Hello Tabitha,
I have seen environments with 10's or thousands of assets and there is not a limit on the number you can have.
For importing assets, are you importing with the import\export tool or IM\EConnect? I have seen both import hundreds at a time without issue.
#1
Abhilash Warrier
565
#2
Martin Dráb
536
Most Valuable Professional
#3
André Arnaud de Cal...
402
Super User 2025 Season 1
All responses (
Answers (
