Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.
TypeScript ai-agentsbill-of-materialserpinventory-managementleanmanufacturingmanufacturing-execution-systemmcp-servermesmrpopen-source-erppostgresqlproduction-planningqmsquality-management-systemreact-routerself-hostedsupabasetraceabilitytypescript
// SPDX-License-Identifier: AGPL-3.0-only
// Carbon (github.com/crbnos/carbon). Modified or adapted versions of this file,
// including ports, remain AGPLv3; serving them over a network requires releasing their source.
import { EPSILON, round } from "@carbon/database/precision";
import type { Violation } from "./rules";
export type OverReceiptReceiptLine = {
lineId: string | null;
receivedQuantity: number | null;
conversionFactor: number | null;
};
export type OverReceiptPurchaseOrderLine = {
id: string;
purchaseQuantity: number | null;
quantityReceived: number | null;
itemReadableId?: string | null;
};
/**
* Receipt lines are in inventory units; purchase order lines are in purchase
* units. Incoming quantity is converted with `receivedQuantity /
* conversionFactor` (the same math post-receipt uses when advancing
* `quantityReceived`) before comparing against the ordered quantity. Returns
* `severity: "warn"` violations so the post action's acknowledge flow lets the
* user confirm and proceed.
*/
export function getOverReceiptViolations(
receiptLines: OverReceiptReceiptLine[],
purchaseOrderLines: OverReceiptPurchaseOrderLine[]
): { violations: Violation[]; ruleNames: Record<string, string> } {
const incomingByLine = new Map<string, number>();
for (const line of receiptLines) {
if (!line.lineId) continue;
const quantityInPurchaseUnits =
(line.receivedQuantity ?? 0) / (line.conversionFactor || 1);
incomingByLine.set(
line.lineId,
(incomingByLine.get(line.lineId) ?? 0) + quantityInPurchaseUnits
);
}
const violations: Violation[] = [];
const ruleNames: Record<string, string> = {};
for (const poLine of purchaseOrderLines) {
const incoming = incomingByLine.get(poLine.id);
if (!incoming || incoming <= 0) continue;
const ordered = poLine.purchaseQuantity ?? 0;
const alreadyReceived = poLine.quantityReceived ?? 0;
const total = alreadyReceived + incoming;
// Small tolerance so float artifacts from unit conversion don't flag an
// exact receipt as over.
if (total > ordered + EPSILON) {
const ruleId = `over-receipt:${poLine.id}`;
violations.push({
ruleId,
severity: "warn",
message: `${poLine.itemReadableId ?? "Line"}: receiving ${round(
incoming
)} would bring the total received to ${round(total)} of ${round(
ordered
)} ordered`
});
ruleNames[ruleId] = "Over Receipt";
}
}
return { violations, ruleNames };
}