# Lumina ERP Docs > Practical ERP, data and automation guides for distributors and manufacturers, deepest in Epicor Prophet 21 and Kinetic, with most guides useful on any ERP, published by Lumina ERP, LLC, an ERP consultancy in Houston, Texas. Only pages that have passed editorial review are listed here. Corrections: support@lumina-erp.com Every page is also available as Markdown at the same address with a .md extension. Epicor, Prophet 21, P21 and DynaChange are trademarks or registered trademarks of Epicor Software Corporation registered in the United States and other countries. Kinetic is a trademark of Epicor Software Corporation. Lumina ERP is an independent consultancy and is not affiliated with, sponsored by or endorsed by Epicor. ## General - [About these docs](https://docs.lumina-erp.com/about.md): Who writes the Lumina ERP Docs, how we keep them independent and accurate, what we will never publish and how to report an error. - [Distribution operations](https://docs.lumina-erp.com/distribution.md): The numbers a wholesale distributor runs on, explained with formulas, worked examples and calculators that work with data from any ERP system. - [Epicor Kinetic guides](https://docs.lumina-erp.com/epicor-kinetic.md): Practical guides to Epicor Kinetic queries, the REST v2 API and where custom business logic belongs, written for administrators and developers. - [ERP projects](https://docs.lumina-erp.com/erp-projects.md): Checklists and decision guides for the big ERP projects in a distribution business, from choosing a system to go-live cutover, month-end close and upgrades. - [Vendors and partners](https://docs.lumina-erp.com/first-and-third-parties.md): How companies decide what to do themselves and what to hand to other businesses, and how to choose, contract, secure, manage and leave those outside partners. - [ERP guides for distributors and manufacturers](https://docs.lumina-erp.com/index.md): Practical ERP, data and automation guides for distributors and manufacturers, deepest in Epicor Prophet 21 and Kinetic, with most guides useful on any ERP. - [Prophet 21 guides](https://docs.lumina-erp.com/prophet-21.md): How Epicor Prophet 21 software is put together, and how to extend, report on, import into and integrate with it without creating upgrade debt. - [Reference](https://docs.lumina-erp.com/reference.md): Lookup pages for ERP and distribution work, including a glossary, a KPI formula sheet, a Prophet 21 and Kinetic comparison and troubleshooting tables. - [Reporting](https://docs.lumina-erp.com/reporting.md): How to build ERP reports people trust: read-only SQL patterns, Crystal Reports techniques and dashboard design for Prophet 21, Kinetic or any ERP. ## Prophet 21 - [DynaChange Rules, Designer, a report or an integration?](https://docs.lumina-erp.com/prophet-21/choosing-dynachange-or-integration.md): A decision guide for Prophet 21 change requests. Match the request to the lightest tool that solves it, and know what each option costs you at upgrade time. - [Custom transactional forms with Crystal Reports](https://docs.lumina-erp.com/prophet-21/custom-crystal-forms.md): The custom-copy pattern for Prophet 21 transactional forms, how to make form changes that survive upgrades and how to test them before customers see them. - [How a Prophet 21 system fits together](https://docs.lumina-erp.com/prophet-21/how-p21-fits-together.md): A conceptual map of a Prophet 21 installation, from the SQL Server database and middleware tier to the clients, background services and hosting. - [Prophet 21 integration options, and how to choose](https://docs.lumina-erp.com/prophet-21/integration-options.md): How to connect Prophet 21 with other systems through APIs, file imports, database reads or middleware, and the questions that decide between them. - [Planning a Prophet 21 data import](https://docs.lumina-erp.com/prophet-21/planning-a-data-import.md): Plan a Prophet 21 data load you can trust, with dependency order, rehearsal loads in a non-production copy and reconciliation that decides when it is done. - [Reading Prophet 21 data with SQL, safely](https://docs.lumina-erp.com/prophet-21/reading-p21-data-with-sql.md): Query a Prophet 21 database without risking data or slowing users, with a read-only login, locking on a busy ERP and short starter queries on orders and items. - [SQL Server care for an on-premises ERP database](https://docs.lumina-erp.com/prophet-21/sql-server-care-for-an-erp-database.md): A working checklist for the SQL Server under an on-premises ERP such as Prophet 21 software, from backups and restore tests to memory, tempdb and patching. ## Epicor Kinetic - [BAQ fundamentals, and the calculated-field mistakes that make totals wrong](https://docs.lumina-erp.com/epicor-kinetic/baq-fundamentals.md): How Kinetic Business Activity Queries are built, why query grain decides whether totals are right and the calculated-field mistakes behind wrong BAQ reports. - [Building useful Kinetic dashboards on BAQs](https://docs.lumina-erp.com/epicor-kinetic/dashboards-from-baqs.md): Design Epicor Kinetic dashboards people trust, from the question and the BAQ behind each grid to parameters, security, performance, testing and governance. - [Epicor Functions, BPMs or customizations?](https://docs.lumina-erp.com/epicor-kinetic/functions-bpms-customizations.md): Decide where custom logic belongs in Epicor Kinetic, whether a BPM directive, an Epicor Function or an Application Studio layer, and what each is for. - [Calling the Kinetic REST v2 API](https://docs.lumina-erp.com/epicor-kinetic/rest-v2-api.md): Kinetic REST v2 in practice, covering the URL shape, API keys, how $filter and $expand behave, why child collections come back empty and paging. ## Distribution operations - [ABC analysis and cycle counting](https://docs.lumina-erp.com/distribution/abc-analysis-and-cycle-counting.md): Rank items by annual usage value, set ABC cutoffs, add XYZ demand classes and run a cycle count program that raises inventory record accuracy. - [The cash conversion cycle](https://docs.lumina-erp.com/distribution/cash-conversion-cycle.md): How DSO, DIO and DPO combine into the cash conversion cycle, why distributors fund the gap before customers pay and what early-pay discounts cost. - [Credit card fees and surcharges](https://docs.lumina-erp.com/distribution/credit-card-fees-and-surcharges.md): What card acceptance costs a B2B distributor, how enhanced card data lowers it and how to choose between absorbing, surcharging and discounting. - [Demand forecasting basics for distributors](https://docs.lumina-erp.com/distribution/demand-forecasting-basics.md): Moving averages, weighted averages and exponential smoothing by item and location, plus seasonal and lumpy demand and how to measure forecast error. - [EDI for distributors](https://docs.lumina-erp.com/distribution/edi-for-distributors.md): The X12 documents a distributor exchanges most, VANs versus AS2 versus APIs, partner onboarding, ASN and label chargebacks and how EDI lands in the ERP. - [Fill rate, OTIF and backorder rate](https://docs.lumina-erp.com/distribution/fill-rate-and-otif.md): Line, unit and order fill rates, what on-time in-full measures, why trading partners define it differently and how fill rate relates to service level. - [Inventory adjustments and shrink](https://docs.lumina-erp.com/distribution/inventory-adjustments-and-shrink.md): The inventory adjustments a distributor posts, reason codes and approvals, the ledger impact, how to measure shrink and lower of cost and net realizable value. - [Inventory turns, days on hand and GMROI](https://docs.lumina-erp.com/distribution/inventory-turns-and-gmroi.md): How to calculate and read inventory turns, days on hand, the Census inventory-to-sales ratio and GMROI, with worked examples and the ways each misleads. - [Landed cost, freight terms and Incoterms](https://docs.lumina-erp.com/distribution/landed-cost-and-freight-terms.md): What landed cost includes, four ways to spread freight across receipt lines, how late freight bills skew margin and what FOB terms and Incoterms 2020 decide. - [Lot and serial traceability](https://docs.lumina-erp.com/distribution/lot-and-serial-traceability.md): Lot versus serial tracking, forward and backward traces, the data to capture at receipt and shipment, a mock recall drill and the FDA food traceability rule. - [Pricing and margin in distribution](https://docs.lumina-erp.com/distribution/pricing-and-margin.md): Margin versus markup, the pricing methods distributors use, where pricing leaks margin and how invoice margin differs from pocket margin, with examples. - [Returns and RMAs](https://docs.lumina-erp.com/distribution/returns-and-rmas.md): How a distributor runs return merchandise authorizations, from reason codes and restocking fees to inspection, vendor returns and effects on margin. - [Safety stock, reorder point and EOQ](https://docs.lumina-erp.com/distribution/safety-stock-reorder-point-eoq.md): How the reorder point, safety stock for demand and lead-time variability, service-level z values and EOQ fit together, and why EOQ is only a starting point. - [Sales tax for distributors](https://docs.lumina-erp.com/distribution/sales-tax-for-distributors.md): How US sales and use tax works for a wholesale distributor, covering resale certificates, economic nexus after Wayfair, sourcing, drop ships and tax engines. - [Units of measure and packaging levels](https://docs.lumina-erp.com/distribution/units-of-measure.md): How base, purchasing, stocking, selling and pricing units relate, where conversion factors go wrong and how GS1 identifiers and NIST handbooks fit in. - [Vendor rebates and special pricing](https://docs.lumina-erp.com/distribution/vendor-rebates-and-special-pricing.md): How supplier rebates, special pricing agreements and ship-and-debit claims work for distributors, and how to claim, reconcile and accrue them correctly. - [Wholesale distribution at a glance](https://docs.lumina-erp.com/distribution/wholesale-distribution-at-a-glance.md): What wholesale distribution is, how NAICS sector 42 is organized, its size in Census and BLS data, how distributors make money and why the ERP is central. ## ERP projects - [Choosing an ERP for distribution](https://docs.lumina-erp.com/erp-projects/choosing-an-erp-for-distribution.md): How a wholesale distributor should evaluate ERP systems: distribution capabilities, deployment models, total cost, partners, scripted demos and scoring. - [ERP upgrade checklist](https://docs.lumina-erp.com/erp-projects/erp-upgrade-checklist.md): A checklist for an ERP version upgrade, from inventorying customizations and reading release notes to regression testing, rollback and post-upgrade checks. - [ERP go-live cutover checklist](https://docs.lumina-erp.com/erp-projects/go-live-cutover-checklist.md): Phase-by-phase checklist for moving a distributor onto a new ERP, from the final rehearsal through cutover weekend, the go/no-go call and 30 days of hypercare. - [Month-end close for distributors](https://docs.lumina-erp.com/erp-projects/month-end-close-for-distributors.md): The month-end close sequence for a wholesale distributor, from shipping and receiving cutoff through inventory, rebate and freight accruals, to the KPI review. - [ERP security roles and access reviews](https://docs.lumina-erp.com/erp-projects/security-roles-and-access-reviews.md): Checklist for ERP role design, segregation of duties in distribution, quarterly access reviews, joiners, movers and leavers, shared accounts and audit logs. ## Reporting - [Crystal Reports techniques for ERP reports](https://docs.lumina-erp.com/reporting/crystal-reports-techniques.md): SAP Crystal Reports techniques for ERP reports: record selection that reaches SQL, commands, subreports, shared variables, totals, prompts and deployment. - [Designing an operations dashboard for a distributor](https://docs.lumina-erp.com/reporting/designing-an-operations-dashboard.md): Which KPIs a distributor should watch daily, weekly and monthly, the design mistakes that get a dashboard ignored and how to set targets and drill-downs. - [T-SQL patterns for ERP reporting](https://docs.lumina-erp.com/reporting/tsql-patterns-for-erp-reporting.md): Read-only SQL Server patterns for ERP reports: aging buckets, running totals, top N, calendar gaps, pivots, latest rows, fan-out, date filters and locking. ## Vendors and partners - [Build, buy or partner](https://docs.lumina-erp.com/first-and-third-parties/build-buy-or-partner.md): Decide whether to do a job yourself, buy a product or hire a service, using core versus context, five-year total cost of ownership and a weighted matrix. - [Choosing a vendor](https://docs.lumina-erp.com/first-and-third-parties/choosing-a-vendor.md): A step-by-step vendor selection process, from must-haves and a long list through RFPs, scripted demos, reference calls, pilots, scoring and negotiation. - [Contracts, SLAs and data rights](https://docs.lumina-erp.com/first-and-third-parties/contracts-slas-and-data-rights.md): What each vendor contract document covers, the clauses that decide cost, risk and your exit, why service credits are small and which terms to negotiate first. - [ERP add-ons and independent software vendors](https://docs.lumina-erp.com/first-and-third-parties/erp-add-ons-and-isvs.md): When to use a native ERP feature, a third-party add-on, a custom extension or a connected system, what to check before buying and how to handle upgrades. - [First party and third party, explained](https://docs.lumina-erp.com/first-and-third-parties/first-party-and-third-party-explained.md): What first, third and fourth party mean for suppliers, software, data, support and cloud, and why the label decides who is accountable when something breaks. - [Fourth parties and concentration risk](https://docs.lumina-erp.com/first-and-third-parties/fourth-parties-and-concentration-risk.md): How your vendors' vendors and shared dependencies can stop your business, with public incidents, a dependency mapping method and a tabletop exercise outline. - [Choosing and working with implementation partners and consultants](https://docs.lumina-erp.com/first-and-third-parties/implementation-partners-and-consultants.md): How to pick the right kind of ERP partner or consultant, choose a pricing model, write a statement of work and finish the work owning your system. - [Leaving a vendor](https://docs.lumina-erp.com/first-and-third-parties/leaving-a-vendor.md): How to exit a vendor cleanly, from planning at signature through notice, data extraction, parallel running, revoking access and data destruction. - [Lessons from other industries](https://docs.lumina-erp.com/first-and-third-parties/lessons-from-other-industries.md): How banking, healthcare, automotive, retail, cloud, government, defense, food and pharma manage third parties, and which practices a distributor can borrow. - [Logistics providers, 3PLs and carriers](https://docs.lumina-erp.com/first-and-third-parties/logistics-providers-and-3pls.md): How in-house logistics compares with 3PLs and 4PLs, what carriers, brokers and forwarders do, how 3PLs price and where integration and liability gaps sit. - [Managing vendors after go-live](https://docs.lumina-erp.com/first-and-third-parties/managing-vendors-after-go-live.md): How to run vendors after the contract is signed, with named owners, a vendor register, tiering, business reviews, KPIs, a renewal calendar and invoice audits. - [Outsourced business services](https://docs.lumina-erp.com/first-and-third-parties/outsourced-business-services.md): What distributors commonly outsource, from accounting and payroll to IT, hosting, collections and staffing, and what must stay in house for each service. - [Security and data sharing with vendors](https://docs.lumina-erp.com/first-and-third-parties/security-and-data-sharing-with-vendors.md): How to judge a vendor's security evidence (SOC reports, ISO 27001, questionnaires) and control what you share, from vendor access and API keys to breaches. - [Selling through others, and being someone else's third party](https://docs.lumina-erp.com/first-and-third-parties/selling-through-others.md): How distributors sell through reps, buying groups, marketplaces, drop ship and punchout, handle chargebacks and prepare for customer vendor risk reviews. - [The third-party landscape for distributors](https://docs.lumina-erp.com/first-and-third-parties/the-third-party-landscape-for-distributors.md): Map of the outside businesses a wholesale distributor relies on, what data each touches, what breaks when it fails, typical contracts and what to ask. - [Third-party risk management for mid-sized companies](https://docs.lumina-erp.com/first-and-third-parties/third-party-risk-management.md): How to run third-party risk management at a 50 to 500 person distributor, scaling the bank regulators' lifecycle and NIST CSF 2.0 to what you can sustain. - [Vendor due diligence checklist](https://docs.lumina-erp.com/first-and-third-parties/vendor-due-diligence-checklist.md): A due diligence checklist for choosing a vendor, grouped from financial health and security to insurance, exit rights and pricing, and scaled by tier. ## Reference - [Glossary of ERP and distribution terms](https://docs.lumina-erp.com/reference/glossary.md): Plain-language definitions of the Prophet 21, Epicor Kinetic and wholesale distribution terms used in these docs, from BAQ and DynaChange to GMROI. - [Distribution KPI formula sheet](https://docs.lumina-erp.com/reference/kpi-formulas.md): Every distribution metric used across these docs on one page, with its formula, its unit, which way is better and a link to the full guide and calculator. - [Prophet 21 and Epicor Kinetic compared](https://docs.lumina-erp.com/reference/prophet-21-and-kinetic-compared.md): How Prophet 21 and Epicor Kinetic software line up concept by concept, for people who know one and need the other, and for leaders weighing where each fits. - [Troubleshooting symptom index](https://docs.lumina-erp.com/reference/troubleshooting.md): A symptom index for Prophet 21, Epicor Kinetic and distribution metrics. Find what you are seeing, the usual cause and the guide section that explains the fix. ## Related - [Lumina ERP](https://lumina-erp.com): services, field notes and contact.