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.
// Runs against the local database (SUPABASE_DB_URL); skipped without one.
// A nonconformance scrap, an inventory count, a stock correction and a stock
// quantity CSV import, before and after the
// company's accounting cutover: Provisional with no period before it, Posted
// in the period of the posting date after it.
import {
alwaysPostFixture,
expectPostedJournals,
expectProvisionalJournals,
type Fixture,
journalLinesOf,
newJournals,
seed,
stampCutover,
stockPart,
USER,
unwrap
} from "./fixtures/always-post";
import type { Database } from "@carbon/database";
import { databaseTest } from "./fixtures/local-database";
import type { SupabaseClient } from "@supabase/supabase-js";
import { expect } from "vitest";
import {
postInventoryCount,
postStockMovementCorrection
} from "../../app/modules/inventory/inventory.service";
import { postNonconformance } from "../../app/modules/quality/quality.service";
import {
importStockQuantities,
invokePosting
} from "../../app/modules/shared/shared.service";
/** A nonconformance at the fixture's location. */
async function nonConformance(f: Fixture, key: string): Promise<string> {
const id = `${f.prefix}-ncr-${key}`;
await seed(f, async (trx) => {
const type = await trx
.insertInto("nonConformanceType")
.values({
name: `${f.prefix} damage ${key}`,
companyId: f.companyId,
createdBy: USER
})
.returning("id")
.executeTakeFirstOrThrow();
await trx
.insertInto("nonConformance")
.values({
id,
nonConformanceId: `NCR-${key}`,
name: "Damaged brackets",
source: "Internal",
locationId: f.locationId,
nonConformanceTypeId: type.id,
openDate: f.today,
companyId: f.companyId,
createdBy: USER
})
.execute();
});
return id;
}
/** Scraps two parts on the nonconformance. */
async function scrapOnNonConformance(f: Fixture, documentId: string) {
return newJournals(f, async () =>
unwrap(
await invokePosting(
f.service,
"post-nonconformance",
{
documentType: "Non-Conformance",
documentId,
movements: [
{ itemId: f.partId, locationId: f.locationId, quantity: -2 }
]
},
postNonconformance
)
)
);
}
/** A Pending count of the part with a snapshot of 0 and 3 counted. */
async function pendingCount(f: Fixture, key: string): Promise<string> {
const id = `${f.prefix}-count-${key}`;
await seed(f, async (trx) => {
await trx
.insertInto("inventoryCount")
.values({
id,
inventoryCountId: `IC-${key}`,
locationId: f.locationId,
status: "Pending",
companyId: f.companyId,
createdBy: USER
})
.execute();
await trx
.insertInto("inventoryCountLine")
.values({
inventoryCountId: id,
itemId: f.partId,
locationId: f.locationId,
systemQuantity: 0,
countedQuantity: 3,
companyId: f.companyId,
createdBy: USER
})
.execute();
});
return id;
}
databaseTest(
"a nonconformance scrap writes a Provisional journal before the cutover and a Posted one after it",
async () => {
const f = await alwaysPostFixture();
try {
await stockPart(f, 10);
const before = await nonConformance(f, "1");
const provisional = await scrapOnNonConformance(f, before);
await expectProvisionalJournals(f, provisional, "Non-Conformance");
expect(await journalLinesOf(f, provisional)).toEqual([
{
accountId: f.account("inventory"),
amount: -20,
accountDefaultRole: null,
documentType: "Non-Conformance"
},
{
accountId: f.account("scrap"),
amount: 20,
accountDefaultRole: null,
documentType: "Non-Conformance"
}
]);
const periodId = await stampCutover(f);
const after = await nonConformance(f, "2");
const posted = await scrapOnNonConformance(f, after);
await expectPostedJournals(f, posted, "Non-Conformance", periodId);
} finally {
await f.cleanup();
}
}
);
databaseTest(
"a nonconformance scrap with no scrap account default posts to the variance account before the cutover",
async () => {
const f = await alwaysPostFixture();
try {
await f.db
.updateTable("accountDefault")
.set({ scrapAccount: null })
.where("companyId", "=", f.companyId)
.execute();
await stockPart(f, 10);
const journals = await scrapOnNonConformance(
f,
await nonConformance(f, "1")
);
await expectProvisionalJournals(f, journals, "Non-Conformance");
expect(await journalLinesOf(f, journals)).toEqual([
{
accountId: f.account("adjustment-variance"),
amount: 20,
accountDefaultRole: null,
documentType: "Non-Conformance"
},
{
accountId: f.account("inventory"),
amount: -20,
accountDefaultRole: null,
documentType: "Non-Conformance"
}
]);
} finally {
await f.cleanup();
}
}
);
databaseTest(
"an inventory count writes a Provisional journal before the cutover and a Posted one after it",
async () => {
const f = await alwaysPostFixture();
try {
const before = await pendingCount(f, "1");
const provisional = await newJournals(f, async () =>
unwrap(
await invokePosting(
f.service,
"post-inventory-count",
{ inventoryCountId: before },
postInventoryCount
)
)
);
await expectProvisionalJournals(f, provisional, "Inventory Adjustment");
const periodId = await stampCutover(f);
const after = await pendingCount(f, "2");
const posted = await newJournals(f, async () =>
unwrap(
await invokePosting(
f.service,
"post-inventory-count",
{ inventoryCountId: after },
postInventoryCount
)
)
);
await expectPostedJournals(f, posted, "Inventory Adjustment", periodId);
} finally {
await f.cleanup();
}
}
);
/** The latest positive adjustment of the part. */
async function latestPositiveAdjustment(f: Fixture): Promise<string> {
const row = await f.db
.selectFrom("itemLedger")
.select("id")
.where("companyId", "=", f.companyId)
.where("itemId", "=", f.partId)
.where("entryType", "=", "Positive Adjmt.")
.where("correctionOfItemLedgerId", "is", null)
.orderBy("entryNumber", "desc")
.executeTakeFirstOrThrow();
return row.id;
}
/** Imports 3 of the part as opening stock. */
async function importThree(f: Fixture) {
const summary = {
inserted: 0,
updated: 0,
errors: [] as { row: number; reason: string }[],
skipped: [] as { row: number; reason: string }[]
};
await importStockQuantities(
f.db,
// The stock importer never reads its Supabase client.
undefined as unknown as SupabaseClient<Database>,
{
table: "inventoryQuantity",
mappedRecords: [
{
readableId: `${f.prefix}-PART`,
locationId: f.locationId,
quantity: "3"
}
],
companyId: f.companyId,
userId: USER,
summary
}
);
expect(summary.errors).toEqual([]);
expect(summary.skipped).toEqual([]);
}
databaseTest(
"a stock movement correction writes a Provisional journal before the cutover and a Posted one after it",
async () => {
const f = await alwaysPostFixture();
try {
// A positive adjustment of 5 that should have been 6.
await stockPart(f, 5);
const before = await latestPositiveAdjustment(f);
const provisional = await newJournals(f, async () =>
unwrap(
await invokePosting(
f.service,
"correct-stock-movement",
{ itemLedgerId: before, correctedQuantity: 6 },
postStockMovementCorrection
)
)
);
await expectProvisionalJournals(f, provisional, "Inventory Adjustment");
const periodId = await stampCutover(f);
await stockPart(f, 5);
const after = await latestPositiveAdjustment(f);
expect(after).not.toBe(before);
const posted = await newJournals(f, async () =>
unwrap(
await invokePosting(
f.service,
"correct-stock-movement",
{ itemLedgerId: after, correctedQuantity: 6 },
postStockMovementCorrection
)
)
);
await expectPostedJournals(f, posted, "Inventory Adjustment", periodId);
} finally {
await f.cleanup();
}
}
);
databaseTest(
"a stock quantity CSV import writes a Provisional journal before the cutover and a Posted one after it",
async () => {
const f = await alwaysPostFixture();
try {
const provisional = await newJournals(f, () => importThree(f));
await expectProvisionalJournals(f, provisional, "Inventory Adjustment");
const periodId = await stampCutover(f);
const posted = await newJournals(f, () => importThree(f));
await expectPostedJournals(f, posted, "Inventory Adjustment", periodId);
} finally {
await f.cleanup();
}
}
);