Reports & analytics

Follow DepartmentRequests and DepartmentRequestLines by company, facility, department, product and requested service date. Keep requested/approved/allocated/transferred/actually used/cancelled/remaining scope disjoint, using actual source links rather than assuming transfer equals use. Requisitions are a distinct purchasing intent, and current stock is not added to request history. Active claims, shortages, changed instructions and uncertain delivery remain explicit. Repeated request versions or source deliveries do not create another department requirement. Different product units remain separate; incomplete source coverage is unknown rather than a zero requirement.

Report current InventoryPositions and StockLayers at their actual company/facility/location/product/leaf-portion grain, with reservations, applicable dates and every active SupplyHolds. Aggregate lot/portion ancestors and historical movements provide lineage only. Staged stock, exclusive issued WIP, same-company transit and intercompany seller-owned transit remain distinct populations. At evidenced intercompany destination acceptance, ownership changes once; an incomplete local accounting posting appears as a reconciliation gap without presenting the same goods as available to both companies. Pending buyer custody is separate from owned buyer inventory. Units, current carrying and known-zero versus missing evidence retain their meaning.

Relate the frozen WorkOrders/BOMs/routing/output standard to accepted actual material use, compatible loss, time and attributable remaining WIP. Terminal ProductionCompletions alone contribute finished output, standard value and the signed actual-WIP difference. Intermediate operation progress and later eligibility release do not add another output. Included normal/packaging loss and separately relieved scrap retain mutually exclusive cost allocation; unused return consumes remaining original issue sources. Preserve per-ingredient units, accepted person/operation time and actual source cost. Report current held output, nonzero variance decisions and technical/financial close obligations without treating unknown cost as zero.

Compare independently approved PurchaseOrderLines with actual arrivals, accepted/rejected/pending ReceiptAcceptances, supplier returns and bounded BillMatches. Cumulative amendments preserve performed and matched history. Commercial quantity/net/tax and receipt standard/current carrying retain distinct sources; a bill is not another receipt. For intercompany purchases, classify the same buyer-local sources by their paired identity and destination-acceptance title, rather than adding another purchase population. Actual held-but-owned acceptance differs from refusal before acquisition. Outstanding counterpart and matching differences retain company, product unit, transaction currency and cutoff.

Follow accepted SalesAllocations through active claims, actual title-transferred quantity/net/tax, returned or resolved history, eligible billing and remaining obligation. Local external goods use their actual selected handover title; intercompany goods use the reviewed destination acceptance and seller transit before that point. Pick, dispatch under destination title, later delivery confirmation, invoice and cash do not each create a new sale/stock event. Keep intercompany as a classification of seller-local orders/invoices, not additive revenue. Preserve final quantity and monetary remainders; cancellation, credit or a failed retry cannot revive fulfilled original entitlement.

Compare IntercompanyOrders and exact IntercompanyOrderLines across independently approved seller/buyer revisions, titles, current ownership and IntercompanyDocumentAllocations. Use each shared physical/economic source once, retaining forward versus reciprocal return direction and actual custody/acceptance timestamps. Common transaction quantity/net agreements can reconcile while seller issue carrying, buyer standard/variance, tax basis and functional currencies differ. Separate each company's local committed, pending, rejected and uncertain result; missing peer evidence is not an assumed failure or success. A partially posted pair cannot make physically transferred quantity available again. Corrections retain their own delta identities and original successful results. This comparative report is not a consolidated ledger.

Follow IntercompanySettlements and IntercompanySettlementAllocations against the buyer's actual local Payments/allocations and seller's actual CashReceipts/applications. Retain the original document debt and each bank event's date, source identity, currency/current carrying, fees and required approval. Outgoing instruction, actual debit, incoming receipt and debt application remain distinct states. Compare common agreed gross obligation with independently evidenced actual net movements, explaining fee/FX/timing differences without creating a third cash event or consuming either local source twice. Unknown receipt remains pending; returned or partially applied money preserves its own correction lineage. No automatic netting, pooling or cross-company write-off is inferred.

Age exact remaining posted local invoice/bill obligations by original party, company, document currency, due date and declared report cutoff, after eligible actual credits/applications/settlements and with held or uncertain claims separately visible. Intercompany receivables/payables are identifiable within those same local documents, not another additive balance from the pairing tables. Preserve customer credit/unapplied cash and supplier credit/prepayment as separate source populations instead of negative spendable debt. Transaction currencies are not summed as one number; functional carrying and allocated prior unrealized FX reconcile at the same cutoff. A counterpart's payment instruction does not settle the seller's original invoice.

Sum actual posted DepartmentUseLines carrying relief and source-owned assembly or other explicitly allocated operating expense by company/facility/department and posting period, with actual use dates available separately. Internal requests, transfers, stock still held, production intermediate observations and intercompany bridge rows are not additional expense. Actual performer, authorized recorder and executor remain distinct evidence. Where a department received purchased or assembled stock, its consumption removes the exact current source carrying once; original acquisition or production cost must not be expensed again through a derived join. Missing assignment or valuation stays an exception, and each permitted comparison retains compatible currency and scope.

Build separate legal-company statements from posted balanced JournalEntries/JournalLines for explicit period/currency/cutoff, reconciling AR/AP, inventory/transit, GRNI, exclusive WIP, actual bank/unapplied/credit sources, tax and approved FX/corrections. Intercompany tags classify the actual local trade accounts; pairing records and peer journals are comparison evidence rather than extra local postings. Separate physical title timing from delayed counterpart/accounting recovery, showing unreconciled effects and required close blockers. Opening detail accompanies one opening GL and never recreates historical recognition. Statements do not imply group consolidation, automatic transfer-profit elimination or healthcare statutory reporting.