Migrate from Alpha-E GSoft-POS to Acumatica

GSoft customer records map directly to Acumatica Customer entities. GSTIN moves to the GST Details tab; ContactName maps to Acumatica's Contact record attached to the Customer. GSoft's customer code becomes Acumatica's CustomerCD; GSoft's opening balance becomes a beginning balance document in Acumatica's AR register.

GSoft vendor records map to Acumatica Vendor entities with the vendor code used as VendorCD. The GSTIN from GSoft is written to the Vendor's GST Details tab for India GST compliance. PAN numbers and TDS deduction rate fields from GSoft transfer to Acumatica's Vendor tax settings. Additional vendor attributes such as payment terms and credit limits are mapped to corresponding Vendor fields or preserved as custom fields if no direct Acumatica equivalent exists.

GSoft item records map to Acumatica InventoryItem with ItemCD as the key. GSoft's barcode number maps to the Manufacturer's Item Nbr field for barcode scanning in Acumatica's PO and SO screens. InventoryItem Type (Stock / Non-Stock / Service) is inferred from GSoft item category.

GSoft item-wise rate masters map to Acumatica SalesPrice records keyed by CustomerClass and InventoryItem. GSoft's multiple price lists — such as retail, wholesale, and MRP tiers — become separate SalesPrice records with appropriate PriceCode assignments in Acumatica's Pricing Engine. Each price list from GSoft is translated into a corresponding price schedule with effective dates and customer-specific or class-level targeting preserved during migration.

GSoft item category groups map to Acumatica Item Class entities with each Item Class defining default tax category and posting settings. GSoft's GST rate group is translated to an Acumatica Tax Category ID during migration. The item category hierarchy from GSoft is preserved as nested Item Classes in Acumatica, maintaining the same grouping logic for inventory reporting and pricing rules.

GSoft sales bills migrate as Acumatica ARInvoice documents. Original GSoft bill number is stored in Acumatica's ReferenceNbr field. GSoft bill date becomes ARInvoice DocDate. Line items with item code, quantity, and rate map to Acumatica's ARTran grid. Open unpaid bills migrate with a status of Open; paid bills migrate as historical records.

GSoft purchase bills migrate as Acumatica APInvoice documents using the same ReferenceNbr and DocDate mapping pattern as sales invoices. The VendorGSTIN is linked from the mapped Vendor record. Unpaid purchase bills retain their open status in the Acumatica AP register, while paid bills are migrated as closed historical documents. Line items map to APTran with item code, quantity, and rate preserved.

GSoft customer receipts migrate as Acumatica ARPayment documents. The linked ARInvoice is matched by the GSoft invoice reference number stored in Acumatica's ReferenceNbr field. Receipt date and amount are preserved from the source; the payment method (cash, cheque, UPI) maps to the corresponding Acumatica CashAccount. Each ARPayment is applied to the matched ARInvoice through Acumatica's payment application feature.

GSoft day-close cash reports do not map to a native Acumatica entity. We migrate the net cash total as a Summary record in a custom CashRecon table, preserving GSoft's branch-wise day-close figures for audit purposes. The detail line items (individual receipts) are migrated separately as ARPayment records.

GSoft loyalty schemes (points per ₹100, tier-based discounts, happy-hour pricing) have no Acumatica native equivalent. We export the scheme definitions — point value, tier thresholds, validity period — as a structured reference document for your Acumatica admin to configure in Acumatica's Rewards module or custom fields. Historical point balances are preserved as a reference field on Customer records.

GSoft salesman records map to Acumatica Employee entities. Commission rate from GSoft is preserved as a custom field on Employee since Acumatica's base Employee does not have a native commission rate field. Salesman-wise sales reports in GSoft can be rebuilt from Acumatica's Salesperson dimension on ARInvoice.

GSoft's chain store branches map to Acumatica Branch entities for financial reporting and Warehouse entities for inventory. Each GSoft branch code becomes an Acumatica BranchCD and a corresponding WarehouseCD. Branch-level stock figures from GSoft are loaded into Acumatica's SiteInventory table.

GSoft barcode prefixes and item-barcode mappings map to the Manufacturer's Item Nbr field on Acumatica InventoryItem. GSoft's barcode prefix scheme (used for label generation) is noted as a custom field; barcode label formatting must be rebuilt in Acumatica's label printing setup.