Bill of Materials Item Limit

[siteseer]

We are creating a bill of materials for assembly. We can add upto 90 line items in the BOM, but when we go to enter another and hit the add button, nothing happens.

is there a limit on the number of line items in a BOM ??

has anyone else had any other similiar problems ?

thanks

rjd

[riscniaga]

yes, there is a limit to the number of parts in the bom.

an alternative solution is to break up your bom into 2 or 3 sub-assemblies.

[siteseer]

thanks.


we've broken it into pieces.

does anyone know how to change this limit ?
ie .. the number of items in a Bill Of Material(bom)

does anyone know why peachtree would pick such an arbitrary limit ?

this seems really, really dumb.

rjd

[Robert Walraven]

In a relational database you would create a separate table for assembly components and join it to the main item table with the item index. Thus with a relational database you could have as many components as you want.

Peachtree's database is not relational. Their line item records are fixed length and each record contains all information about a line item, including the components that make it up if it is an assembly. The line item records contain space for 100 components, but since the records are fixed length, that number is hard-wired into the structure. Thus it is not possible to increase the number of components that make an assembly beyond 100.

I seem to remember when we were playing around with this that the number of components that Peachtree would accept was a little less than 100. (Just because they have allocated space in the record for 100 doesn't mean that their code is designed to work with that many. )

Bob Walraven
Architect of PawCom

[siteseer]

thanks very much