The Inventory Census entity is a complex document entity, used to support Item Inventories.

It is constructed from the following physical tables: dbInventoryCensus, dbBusinessDocument and the dbBusinessDocument_ProductLine table.


*Note: This area of the ERP has changed dramatically in v3.3 351

It now supports all kinds of Inventories - a specific date, a set of Items etc.

How well it will function in the real world, must be seen - but it has a lot of versatility ...


Of course the system still has System Objects, that support Inventories with transactions, so its up to the developer to choose.

But we are quickly moving to this new model.


For obvious reasons, this entity is NOT automatically posted, when it is added to the system - we wanted to let the inventory job to be able to last many days.


The state entities have been removed from v3 and the inventory census functionality is now supported by the dbInventoryCensus table ..


Simple Diagram of the Inventory Census Entity

* the above diagram is NOT complete - for more information see the database schema



For more information see the specific BPs and especially the BP_Product_Balance for more information.

Don't hesitate to post any questions about this area in the forums - we are aware of its "strange" design ...