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 { expect } from "vitest";
import { databaseTest } from "../fixtures/local-database";
import { chargeFixture } from "../fixtures/post-charge";
import { calculateCOGS } from "../../../app/modules/shared/shared.service";
class Rollback extends Error {}
// A FIFO serial item with a receipt of two units at 100 (the oldest layer)
// and one unit returned to stock at 60 — a fixed asset's net book value.
databaseTest(
"a serial unit returned to stock is relieved from its own cost layer",
async () => {
const f = await chargeFixture();
try {
await f.db
.transaction()
.execute(async (trx) => {
const item = await trx
.insertInto("item")
.values({
readableId: `${f.companyId}-VEH`,
name: "Vehicle",
type: "Part",
itemTrackingType: "Serial",
companyId: f.companyId,
createdBy: "system"
})
.returning("id")
.executeTakeFirstOrThrow();
// An item insert may already have created its cost row.
await trx
.deleteFrom("itemCost")
.where("itemId", "=", item.id)
.execute();
await trx
.insertInto("itemCost")
.values({
itemId: item.id,
costingMethod: "FIFO",
unitCost: 100,
companyId: f.companyId,
createdBy: "system"
})
.execute();
const unit = (readableId: string) =>
trx
.insertInto("trackedEntity")
.values({
readableId,
itemId: item.id,
quantity: 1,
sourceDocument: "Item",
sourceDocumentId: item.id,
companyId: f.companyId,
createdBy: "system"
})
.returning("id")
.executeTakeFirstOrThrow();
const returned = await unit("SN-1");
const received = await unit("SN-2");
const layer = (
postingDate: string,
quantity: number,
cost: number,
trackedEntityId: string | null
) =>
trx
.insertInto("costLedger")
.values({
itemLedgerType: "Purchase",
costLedgerType: "Direct Cost",
adjustment: false,
itemId: item.id,
quantity,
cost,
remainingQuantity: quantity,
postingDate,
trackedEntityId,
companyId: f.companyId
})
.returning("id")
.executeTakeFirstOrThrow();
const receipt = await layer("2026-01-01", 2, 200, null);
const returnLayer = await layer("2026-06-01", 1, 60, returned.id);
const remaining = async (id: string) =>
Number(
(
await trx
.selectFrom("costLedger")
.select("remainingQuantity")
.where("id", "=", id)
.executeTakeFirstOrThrow()
).remainingQuantity
);
// The returned unit leaves at its own 60, not the oldest layer's 100.
const own = await calculateCOGS(trx, {
itemId: item.id,
quantity: 1,
companyId: f.companyId,
trackedEntityIds: [returned.id]
});
expect(own.totalCost).toEqual(60);
expect(await remaining(returnLayer.id)).toEqual(0);
expect(await remaining(receipt.id)).toEqual(2);
// Put the returned layer back: another unit must not eat it.
await trx
.updateTable("costLedger")
.set({ remainingQuantity: 1 })
.where("id", "=", returnLayer.id)
.execute();
const other = await calculateCOGS(trx, {
itemId: item.id,
quantity: 1,
companyId: f.companyId,
trackedEntityIds: [received.id]
});
expect(other.totalCost).toEqual(100);
expect(await remaining(returnLayer.id)).toEqual(1);
// Nor does a consumer that names no unit, until nothing else is left.
const anonymous = await calculateCOGS(trx, {
itemId: item.id,
quantity: 2,
companyId: f.companyId
});
expect(anonymous.totalCost).toEqual(160);
expect(await remaining(returnLayer.id)).toEqual(0);
throw new Rollback();
})
.catch((error) => {
if (!(error instanceof Rollback)) throw error;
});
} finally {
await f.cleanup();
}
}
);