Warehouse Limitation

We are testing our new AI Assistant and ran your scenario through it,  You would need a small customization but it can be done...I hope this helps:

📦 Warehouse Capacity Limitation (e.g., setting a max weight per warehouse like 100 KG) is a real-world operational requirement, but Acumatica does not support this natively out of the box — as of 2024 R2 and upcoming 2025 R1 — for weight- or volume-based capacity restriction on warehouse-level.

However, there are feasible ways to implement this functionality, depending on how strict you want enforcement to be.

✅ Goal:

Warn or prevent a warehouse from exceeding a defined total weight capacity (e.g., 100 KG) during:

• Purchase Receipt
• Inventory Transfer
• Sales Return
• Production Receipt

🚫 What Acumatica Cannot Do Natively:

🛠️ Solution Paths

🔹 Option 1: Custom Validation via Customization Project

Best fit for enforcing weight limits per warehouse.

How it works:

1. Add a custom field (UsrWeightCapacity) on the Warehouse screen (IN204000).
2. Create a custom DAC extension on transactions like:
   • PO Receipt (PO302000)
   • Inventory Receipt (IN301000)
3. During receipt line insert/update, calculate:
   • Current weight in warehouse (InventoryItem.BaseItemWeight * QtyOnHand)
   • Plus incoming line weight
4. Compare to UsrWeightCapacity.
5. Show warning or throw exception if exceeded.

💥 This gives a live enforcement rule at transaction time.

🔹 Option 2: Generic Inquiry + Business Event Alert (Soft Monitoring)

If you don’t want to block transactions, you can monitor and alert:

1. Create a Generic Inquiry that:
   • Joins INLocationStatus, InventoryItem, and INSite
   • Sums item weight × quantity for each warehouse
   • Compares against custom field UsrMaxWeight
2. Add a Business Event to trigger when:
   • CurrentWeight > UsrMaxWeight
3. Notify warehouse manager by email or mobile push

🛎️ This gives proactive visibility but doesn’t stop transactions.

🔹 Option 3: Restrict via WMS Pick/Putaway Logic (Advanced)

If you use Acumatica WMS, you can:

• Assign zones or bins by weight capacity
• Add a custom scanning logic to validate during Put Away
• Block bins or locations that are over capacity

📱 Requires customization of the WMS mobile workflow.

📋 Example Implementation: Custom Capacity Check on Receipt

Step 1: Add UsrWeightCapacity field to Warehouse (INSite)

[PXDBDecimal]

[PXUIField(DisplayName = "Max Weight (KG)")]

public virtual decimal? UsrWeightCapacity { get; set; }

public abstract class usrWeightCapacity : PX.Data.BQL.BqlDecimal.Field<usrWeightCapacity> { }

Step 2: On Receipt Line, sum:

decimal currentWeight = ... // total from INLocationStatus

decimal incomingWeight = inventoryItem.BaseItemWeight * receiptLine.BaseQty;

decimal allowedWeight = warehouse.UsrWeightCapacity;

if (currentWeight + incomingWeight > allowedWeight)

{

    throw new PXException("Warehouse capacity exceeded: cannot receive item.");

}

✅ Final Recommendation: