Skip to main content
Solved

Purpose of the UserID field in the AMBomCost table (AM508000 / Cost Roll)

  • July 3, 2026
  • 1 reply
  • 11 views
B
Captain I
Forum|alt.badge.img+2

Hi everyone,

I am currently analyzing the database schema for the Manufacturing Edition, specifically looking at the Cost Roll process (AM508000).

I noticed that the core table used during this process, AMBomCost, includes a UserID field as part of its structure.

Could someone please clarify the exact architectural purpose of this field? Is it used strictly for session-based data isolation to prevent conflicts during concurrent cost rolls by multiple users, or does it serve another specific tracking/auditing purpose within the Manufacturing module?

Any insights into how Acumatica handles data inside AMBomCost during the processing lifecycle would be greatly appreciated.

Best answer by Dipak Nilkanth

Hi ​@bihalivan15,
Yes, your understanding is correct. The UserID in AMBomCost is mainly used to isolate each user's Cost Roll processing data. Since AMBomCost acts as a working table for intermediate calculations, the UserID ensures that multiple users can run Cost Roll at the same time without interfering with each other's data. It's generally not intended for auditing purposes, but rather to maintain separate processing sessions.

1 reply

Dipak Nilkanth
Pro III
Forum|alt.badge.img+14

Hi ​@bihalivan15,
Yes, your understanding is correct. The UserID in AMBomCost is mainly used to isolate each user's Cost Roll processing data. Since AMBomCost acts as a working table for intermediate calculations, the UserID ensures that multiple users can run Cost Roll at the same time without interfering with each other's data. It's generally not intended for auditing purposes, but rather to maintain separate processing sessions.

Dipak Nilkanth || 2X MVP @2025 & 2026 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
    Terms & ConditionsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved