Announcements
is there a limit on the number of assets you can import to the FA module?
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.
Fixed assets include property, plant, and equipment (PP&E) and are recorded on the balance sheet with that classification.
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)
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
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.
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?
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 676
Abhilash Warrier 633 Super User 2026 Season 1
André Arnaud de Cal... 624 Super User 2026 Season 1
