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, it } from "vitest";
import {
CUSTOMER_DEPOSIT_APPLIED_DESCRIPTION,
CUSTOMER_DEPOSIT_DESCRIPTION
} from "./accounting-posting.ts";
import {
buildPaymentJournal,
type PaymentJournalApplicationInput
} from "./build-payment-journal.ts";
import { round } from "./precision.ts";
type Input = Parameters<typeof buildPaymentJournal>[0];
type AccountClass = "Asset" | "Liability" | "Expense" | "Revenue";
const base = (overrides: Partial<Input> = {}): Input => ({
paymentId: "payment",
companyId: "company",
isAR: true,
cashIn: true,
totalAmount: 0,
exchangeRate: 1,
bankAccount: "bank",
journalLineReference: "reference",
applications: [],
newOnAccountBase: 0,
accounts: {
controlAccountId: "today-control",
discountAccountId: "discount",
writeOffAccountId: "writeoff",
fxGainAccountId: "fxgain",
fxLossAccountId: "fxloss"
},
...overrides
});
const amountOf = (
result: ReturnType<typeof buildPaymentJournal>,
accountId: string
) => result.lines.find((line) => line.accountId === accountId)?.amount;
// Decode storage independently by account class: a natural-signed sum or the
// builder's own running total cannot prove GL balance once a liability is in
// the entry.
const decodedDebitTotal = (
result: ReturnType<typeof buildPaymentJournal>,
classes: Record<string, AccountClass>
) =>
round(
result.lines.reduce((sum, line) => {
const accountClass = classes[line.accountId];
if (!accountClass)
throw new Error(`Unexpected account ${line.accountId}`);
return (
sum +
(accountClass === "Asset" || accountClass === "Expense"
? line.amount
: -line.amount)
);
}, 0)
);
it.each([true, false])(
"multiple target rates preserve per-invoice relief, signed FX and GL balance (isAR=%s)",
(isAR) => {
// Document cash 88 + 55 is worth base 143 at the payment's rate of 1.
// Target A: 88 / 1.1 = 80 principal + 15 discount + 5 write-off = 100.
// Target B: 55 / 0.8 = 68.75 principal + 3 discount + 2 write-off = 73.75.
// AR realizes +8 and -13.75 (net loss 5.75); AP has the opposite.
const target = (id: string) => ({
targetSalesInvoiceId: isAR ? id : null,
targetPurchaseInvoiceId: isAR ? null : id,
targetControlAccountId: `control-${id}`,
sourceExchangeRate: 1,
sourcePaymentId: null
});
const applications: PaymentJournalApplicationInput[] = [
{
...target("a"),
targetExchangeRate: 1.1,
sourceAmount: 88,
appliedAmount: 80,
discountAmount: 15,
writeOffAmount: 5,
fxGainLossAmount: isAR ? 8 : -8
},
{
...target("b"),
targetExchangeRate: 0.8,
sourceAmount: 55,
appliedAmount: 68.75,
discountAmount: 3,
writeOffAmount: 2,
fxGainLossAmount: isAR ? -13.75 : 13.75
}
];
const result = buildPaymentJournal(
base({ isAR, cashIn: isAR, totalAmount: 143, applications })
);
const linesFor = (id: string) =>
result.lines
.filter((line) => line.documentLineReference === id)
.map((line) => [line.accountId, line.amount]);
// Natural-balance storage decreases both AR assets and AP liabilities;
// each invoice is relieved on its ORIGINAL control account.
expect(linesFor("a")).toEqual(
expect.arrayContaining([
["control-a", -100],
["discount", isAR ? 15 : -15],
["writeoff", 5]
])
);
expect(linesFor("b")).toEqual(
expect.arrayContaining([
["control-b", -73.75],
["discount", isAR ? 3 : -3],
["writeoff", 2]
])
);
expect(amountOf(result, "bank")).toEqual(isAR ? 143 : -143);
expect(result.totalFxImpact).toEqual(isAR ? -5.75 : 5.75);
expect(amountOf(result, isAR ? "fxloss" : "fxgain")).toEqual(5.75);
expect(amountOf(result, "today-control")).toBeUndefined();
const control = isAR ? "Asset" : "Liability";
expect(
decodedDebitTotal(result, {
bank: "Asset",
"control-a": control,
"control-b": control,
discount: "Expense",
writeoff: isAR ? "Expense" : "Revenue",
fxgain: "Revenue",
fxloss: "Expense"
})
).toEqual(0);
expect(result.signedDebitTotal).toEqual(0);
}
);
// A customer DEPOSIT — a Receipt referencing a sales order or rental agreement
// — is the customer's money held against that document. Its unapplied cash is
// a liability on the prepayment account (2110), never on-account receivable
// credit; applying it later releases 2110 against the invoice; and a
// Disbursement carrying the same reference refunds it from 2110.
const depositClasses: Record<string, AccountClass> = {
bank: "Asset",
prepayment: "Liability",
"original-control": "Asset",
"today-control": "Asset"
};
it("deposit receipt holds its unapplied cash on the prepayment account, not receivables", () => {
const result = buildPaymentJournal(
base({
totalAmount: 3000,
newOnAccountBase: 3000,
isDeposit: true,
depositAccountId: "prepayment"
})
);
expect(amountOf(result, "bank")).toEqual(3000);
// A credit to a liability is stored positive: 3,000 owed back to the customer.
expect(
result.lines.find((line) => line.accountId === "prepayment")
).toMatchObject({ amount: 3000, description: CUSTOMER_DEPOSIT_DESCRIPTION });
expect(amountOf(result, "today-control")).toBeUndefined();
expect(decodedDebitTotal(result, depositClasses)).toEqual(0);
expect(result.signedDebitTotal).toEqual(0);
});
it("applying a deposit to an invoice releases the prepayment account against receivables", () => {
// A zero-cash receipt funded by the posted deposit (sourcePaymentId), with
// the source marked as a deposit on the prepayment account.
const result = buildPaymentJournal(
base({
paymentId: "application",
applications: [
{
targetSalesInvoiceId: "invoice",
targetControlAccountId: "original-control",
sourcePaymentId: "deposit",
sourceControlAccountId: "prepayment",
sourceIsDeposit: true,
sourceAmount: 500,
appliedAmount: 500,
discountAmount: 0,
writeOffAmount: 0,
targetExchangeRate: 1,
sourceExchangeRate: 1,
fxGainLossAmount: 0
}
],
isDeposit: false,
depositAccountId: "prepayment"
})
);
// A debit to a liability is stored negative: 500 less owed back.
expect(
result.lines.find((line) => line.accountId === "prepayment")
).toMatchObject({
amount: -500,
description: CUSTOMER_DEPOSIT_APPLIED_DESCRIPTION
});
expect(amountOf(result, "original-control")).toEqual(-500);
expect(amountOf(result, "bank")).toBeUndefined();
expect(amountOf(result, "today-control")).toBeUndefined();
expect(decodedDebitTotal(result, depositClasses)).toEqual(0);
expect(result.signedDebitTotal).toEqual(0);
});
it("refunding a deposit is a customer Disbursement that debits the prepayment account", () => {
const result = buildPaymentJournal(
base({
cashIn: false,
totalAmount: 2500,
newOnAccountBase: 2500,
isDeposit: true,
depositAccountId: "prepayment"
})
);
expect(amountOf(result, "bank")).toEqual(-2500);
expect(
result.lines.find((line) => line.accountId === "prepayment")
).toMatchObject({ amount: -2500, description: CUSTOMER_DEPOSIT_DESCRIPTION });
// Never restored to receivables: the customer was not owed on account.
expect(amountOf(result, "today-control")).toBeUndefined();
expect(decodedDebitTotal(result, depositClasses)).toEqual(0);
expect(result.signedDebitTotal).toEqual(0);
});
it("a receipt without a document reference keeps its remainder on receivables", () => {
const result = buildPaymentJournal(
base({
totalAmount: 3000,
newOnAccountBase: 3000,
isDeposit: false,
depositAccountId: "prepayment"
})
);
expect(amountOf(result, "today-control")).toEqual(-3000);
expect(amountOf(result, "prepayment")).toBeUndefined();
expect(decodedDebitTotal(result, depositClasses)).toEqual(0);
});
it("a deposit refuses to post without a prepayment account", () => {
expect(() =>
buildPaymentJournal(
base({
totalAmount: 3000,
newOnAccountBase: 3000,
isDeposit: true,
depositAccountId: null
})
)
).toThrow(CUSTOMER_DEPOSIT_DESCRIPTION);
});