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 type { Database } from "@carbon/database";
import { distinctItemText } from "@carbon/utils";
export function getLineDescription(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
switch (line?.invoiceLineType) {
case "Fixed Asset":
return (
(line as any)?.assetReadableId ??
(line as any)?.assetName ??
"Fixed Asset"
);
case "Comment":
return line?.description;
default:
return line?.itemReadableId;
}
}
export function getLineDescriptionDetails(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
switch (line?.invoiceLineType) {
case "Fixed Asset":
return line?.description;
case "Comment":
default:
// A service's readable id is its name — don't print it twice.
return distinctItemText(line?.itemReadableId, line?.description) ?? "";
}
}
/**
* The line's list merchandise amount, `quantity × convertedUnitPrice`, before
* the line discount. Documents render in the invoice currency.
*/
export function getLineGrossMerchandise(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
return (line?.quantity ?? 0) * (line?.convertedUnitPrice ?? 0);
}
/**
* The line discount's amount. `discountPercent` is a fraction from 0 to 1 and
* discounts merchandise only — add-ons and shipping are never discounted.
*/
export function getLineDiscount(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
return getLineGrossMerchandise(line) * (line?.discountPercent ?? 0);
}
/** The line's merchandise amount after its discount. */
export function getLineMerchandise(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
return getLineGrossMerchandise(line) - getLineDiscount(line);
}
export function getLineSubtotal(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
return (
getLineMerchandise(line) +
(line?.convertedAddOnCost ?? 0) +
(line?.convertedNonTaxableAddOnCost ?? 0) +
(line?.convertedShippingCost ?? 0)
);
}
/** Tax is charged on the discounted merchandise. */
export function getLineTaxableSubtotal(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
return (
getLineMerchandise(line) +
(line?.convertedAddOnCost ?? 0) +
(line?.convertedShippingCost ?? 0)
);
}
export function getLineTaxesAndFees(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
const taxPercent = line.taxPercent ?? 0;
const tax = getLineTaxableSubtotal(line) * taxPercent;
const fees =
(line.convertedAddOnCost ?? 0) +
(line.convertedNonTaxableAddOnCost ?? 0) +
(line.convertedShippingCost ?? 0);
return tax + fees;
}
export function getLineTotal(
line: Database["public"]["Views"]["salesInvoiceLines"]["Row"]
) {
const taxPercent = line.taxPercent ?? 0;
const tax = getLineTaxableSubtotal(line) * taxPercent;
return getLineSubtotal(line) + tax;
}
export function getTotal(
lines: Database["public"]["Views"]["salesInvoiceLines"]["Row"][],
salesInvoice: Database["public"]["Views"]["salesInvoices"]["Row"],
salesInvoiceShipment: Database["public"]["Tables"]["salesInvoiceShipment"]["Row"]
) {
let total = 0;
lines.forEach((line) => {
total += getLineTotal(line);
});
return (
total +
(salesInvoiceShipment.shippingCost ?? 0) * (salesInvoice.exchangeRate ?? 1)
);
}