Migrate from Alpha-E GSoft-POS to Epicor Prophet 21

GSoft-POS Items with barcode, SKU, MRP, size/color variant structure map to Epicor Part records with alternate codes (UPC/EAN) and Lot/Serial control enabled as needed. We map the GSoft-POS barcode as Part.PartNum or a PartXrefAlt record. Size and color variants that are separate Items in GSoft-POS become separate Part records in Epicor, or are consolidated under a configurable part with Site-specific stocking if the customer prefers variant-level tracking. MRP from GSoft-POS becomes Standard Cost or List Price on Epicor PartCost and PartPrice.

GSoft-POS Customer records with contact details, GSTIN, outstanding balance, and purchase history map to Epicor Customer. The GSTIN migrates as Customer.TaxID and is validated against the GST portal format before insert. Outstanding balance becomes an open AR amount and is applied against the opening balance journal entry in the GL. Customer-specific pricing rules from GSoft-POS migrate to Epicor CustPriceGrp records.

GSoft-POS Vendor records with supplier name, contact, GSTIN, and payment terms map to Epicor Supplier. GSTIN migrates as Supplier.TaxID. Payment terms from GSoft-POS (such as credit days) map to Epicor Terms records. Purchase history from GSoft-POS becomes open PO history in Epicor Supplier.

GSoft-POS GST-compliant sales invoices with item-level detail, tax breakup, GSTIN of counterparty, and payment status map to Epicor AR Invoice. Each line item maps to InvcDtl with the GSoft-POS tax rate mapped to Epicor TaxDtl by HSNSAC code. Invoice-to-payment linkage (whether paid, partially paid, or outstanding) is preserved. We flag invoices with status = open for AR reconciliation against the GSoft-POS outstanding balance.

GSoft-POS purchase invoices map to Epicor AP Invoice with line-level detail, vendor GSTIN, and tax rate mapped by HSNSAC code to Epicor TaxDtl. Pending or received quantities from GSoft-POS PO receipt records feed into Epicor ReceiptDtl against the matched PO.

GSoft-POS purchase orders with vendor, items ordered, quantities, rates, and taxes map to Epicor PO Header and PODetail. Pending quantities vs received quantities are reconciled so that open POs remain actionable in Epicor after migration. Line-level taxes map via HSNSAC code to Epicor TaxDtl.

GSoft-POS payment records linking invoices to cash or bank receipts map to Epicor CashHead (AR receipts) or AP Payment records. We resolve the payment-to-invoice linkage using the GSoft-POS reference fields and map the payment method (cash, bank, card) to the corresponding Epicor payment type. Field naming differences between GSoft-POS payment types and Epicor pay types are resolved at scoping.

GSoft-POS multi-location branch data is dispersed across branch-level databases or shared tables with no single export. We write branch-specific extraction queries per location, consolidating branch-wise sales, stock, and financial data into a unified dataset. Each GSoft-POS branch becomes a separate Epicor Site/Warehouse with its own location code, address, and inventory positions. Central ledger entries from GSoft-POS are mapped to the Epicor GL with site reference preserved. Branch-level GSTIN (if each branch files separately) migrates as a Site-level Tax ID.

GSoft-POS loyalty scheme records with member ID, points balance, and redemption history map to Epicor Customer records with custom fields for loyalty points (loyalty_points_balance__c), enrollment date, and tier. Custom loyalty field structures in GSoft-POS require field-by-field mapping to the Epicor Customer schema. Points redemption history migrates as a separate table or CSV for the customer's admin to reconfigure in Epicor's loyalty module or a third-party loyalty integration. Active loyalty tier rules and promo scheme conditions do not migrate as logic; they are documented for rebuild.

GSoft-POS gift voucher and coupon code records migrate as a gift card balance record in Epicor (Part with type = GiftCard or a custom gift card table). The current balance and issue date transfer; active promo rules (happy-hour pricing, discount tiers, promotional periods) are documented in the automation inventory and are not migrated as executable logic. The customer's admin configures Epicor Promotion Codes or a loyalty add-on post-migration.

GSoft-POS chart of accounts, ledger balances, and trial balance map to Epicor GL Account and GL Jnl Head records. Opening balance at the point of transition requires reconciliation because GSoft-POS fiscal year boundaries and year-closing conventions differ from Epicor's accounting calendar. We compute the delta between GSoft-POS closing balances and Epicor opening balances and generate a balancing journal entry. Year-closing entries (carry-forward of P&L to retained earnings) are flagged for the customer's accountant to verify.

We extract the underlying invoice data that feeds GSoft-POS GSTR reports as line-item detail in the AR/AP invoice migration. The GSTR filing status does not transfer because GST portal filings are submitted against the portal's own record. The customer must re-file or reconcile GSTR-1, GSTR-2, and GSTR-3B directly in the GST portal post-migration using the imported invoice data as the source of truth. We provide a GSTR-ready CSV export as part of the handoff package.

GSoft-POS point-of-sale transaction lines (item, quantity, discount, tax, payment method, salesman) map to Epicor Sales Order and AR Invoice records. Multiple daily POS receipts are consolidated into daily or batch Sales Orders in Epicor depending on the customer's reporting requirements. Salesman assignments from GSoft-POS map to Epicor OrderDtl.UserChar1 or a custom field for commission tracking.

GSoft-POS branch-level stock positions (quantity on hand by item by location) map to Epicor PartBin records per Site. Current on-hand quantities are inserted as opening balances; we do not replay the full transaction history (which can be voluminous). Stock value from GSoft-POS reconciles against Epicor's calculated on-hand value at standard or average cost. Stock aging and non-moving stock reports from GSoft-POS are documented as reference data for the customer's inventory team.