Question about Serial No. handling in Axapta

harold

I have a question about how serial numbers are implemented in Axapta.

I work with Attain and in Attain the serial numbers are stored in the Item Ledger Entry Table. One line is created for each serial number. When I did a test of creating a Sales Order with 1 item x Qty 20,000 and then generate serial numbers for these items, the result of posting the sales order is approximately 40 MB of database usage (there are other reasons for this growth such as variances and dimensions - but the main growth is caused by 20,000 item ledger entry lines being created for each item/serial number).

This also severely impacts Attains Serial Number Item tracking screen. After a few hundred thousand serial numbers have been generated, the screen to select/input serial numbers in Sales/Purchase orders will take a long time to open.

How does Axapta handle serial numbers? is it similar to Attain? and would result in large database growth also?

Thanks in advance for any help.

Harold