D365 Business Central ACE Compatible POS

What this delivers

• ACE item maintenance workflows designed around hotsheet processing and API-based item changes
• Support for HSeitmPG item hotsheet SKU changes with pagination
• Ability to recognize ACE item change logic for EHTS and ERTL style records when mapping from former xRoads file concepts
• Controlled processing based on a stored Last Run Date/Time, updated only after data has been downloaded and processed

Why it matters

• Eliminates manual item creation and cleanup
• Prevents outdated or mismatched ACE item data
• Supports daily API review and processing discipline
• Allows ACE dealer staff to keep item records aligned with ACE data without giving up Business Central control

What this delivers

• Maintains item descriptions and related ACE item details in Business Central
• Supports ACE department, commodity group, merchandise class, manufacturer, and buyer data concepts
• Supports ACE SKU and UPC maintenance using ACE hotsheet or API data where available

Why it matters

• Improves item search and item maintenance accuracy inside the POS and ERP
• Gives ACE dealers cleaner reporting, purchasing, and inventory management
• Reduces the need to manually source, verify, and re-key ACE item information

What this delivers

• Supports ACE store-side POS data concepts such as Customer, ISPU, Inventory, POSLog, and RetailStore files where ACE requires or accepts store-side data
• Allows customer account, in-store pickup availability, inventory, transaction log, tender, line item, and store metadata concepts to be planned as part of an ACE Compatible POS architecture
• Separates modern ACE API-based hotsheet downloads from any remaining SFTP or xRoads-style file submission requirements

Why it matters

• Keeps your store aligned with ACE operational and reporting expectations
• Reduces duplicate work between POS, inventory, and supplier reporting
• Preserves the ACE data language used by existing RMS-era or file-based workflows

What this delivers

• Uses ACE item departments, item commodity groups, and item merchandise classes inside the Business Central item master
• Supports ACE item manufacturers and buyer information where available from the ACE API
• Helps align ACE retail data with Business Central reporting and purchasing controls

Why it matters

• Provides cleaner reporting, better merchandising, and more accurate filtering for purchasing and POS
• Helps ACE dealers analyze margin, inventory, purchasing, and sales by meaningful ACE classifications

What this delivers

• Supports HSpohdrPG Purchase Order Header record data with pagination
• Supports HSpodtlPG Purchase Order Detail record data with pagination
• Allows purchase order review, receiving, matching, and vendor document handling to remain in Business Central

Why it matters

• Improves visibility into ACE purchase order activity
• Reduces duplicate entry and helps connect purchasing activity to inventory and accounting
• Helps buyers and receivers work from the same Business Central transaction history

What this delivers

• Supports HSeinvPG invoice hotsheet data with pagination
• Allows ACE invoice data to be reviewed and processed into Business Central purchasing, receiving, inventory, and accounts payable workflows
• Gives ACE dealers a controlled path for invoice-related cost updates and vendor document review

Why it matters

• Streamlines receiving and invoicing
• Helps maintain accurate inventory and costing
• Reduces manual invoice entry and reconciliation work

What this delivers

• With Microsoft’s free Shopify connector, ACE dealers can sell store items, services, and supplier items through Shopify when those items are available in Business Central
• ISPU inventory concepts can be considered as part of the ACE dealer design for online pickup availability
• Business Central can remain the store system for item, inventory, pricing, and customer workflows while Shopify handles modern eCommerce presentation
• Use the easiest tools in the e-commerce industry to showcase your brand

Why it matters

• Your store can be hosted by a leading eCommerce provider while Business Central remains the business control system
• Your items, services, and special pricing strategy can be managed from the ERP side
• ACE dealers can plan BOPIS and online visibility around store inventory and supplier data availability

Visit Shopify E-Commerce page for features and pricing

What this delivers

• ACE retail change, brand name change, and consumer unit change flags can be reviewed before item data affects store records
• Staff can:
• Review cost and retail changes
• Analyze margin impact
• Validate rounding behavior
• Print shelf and bin labels before prices go live

Why it matters

• Prevents surprise prices at the register
• Keeps ACE Compatible POS pricing and shelf labels in sync
• Maintains pricing discipline and customer trust
• Eliminates manual ACE login and keystroking changes

What this delivers

• Supports items purchased in one unit and sold in another
• Maintains pricing alignment when supplier costs change
• Works naturally with POS unit prompts and pricing rules

Why it matters

• Critical for hardware, lumber, fasteners, pipe, and bulk items
• Prevents margin erosion caused by unit mismatches
• Improves POS speed and accuracy

What this delivers

• ACE invoices can be received into Business Central workflows:
• Accounts payable creation and item quantity updates
• Accurate item cost updates directly into Business Central
• Visibility into freight, tax, quantity, and costing adjustments where provided in the invoice data
• Supports investigation of rounding or tax differences when needed

Why it matters

• Ensures last-direct cost stays accurate
• Feeds pricing and margin tools correctly
• Reduces reconciliation and accounting discrepancies

What this delivers

• Supports ACE inventory and ISPU data concepts when store availability or supplier availability must be shared or reviewed
• Supports purchasing decisions, special-order commitments, customer availability questions, and online pickup planning

Why it matters

• Improves customer service
• Reduces backorders and surprises
• Increases buyer confidence

What this delivers

• Supports HSpromohdrPG Promotion Header hotsheet data with pagination
• Supports HSpromodtlPG Promotion Detail hotsheet data with pagination
• Allows ACE promotion information to be reviewed and applied through Business Central controls

Why it matters

• Ensures promotions are executed accurately at POS
• Helps purchasing align with current ACE promotional programs
• Eliminates repetitive ACE login searching for promotions, ordering, and quoting

What this delivers

• Supports promotion-related header and detail data for special buy planning
• Helps buyers validate pricing, quantities, and promotion timing through Business Central workflows

Why it matters

• Gives visibility into special deal purchases
• Helps validate costs and plan inventory around promotions
• Connects promotional buying to inventory, purchasing, and POS execution

• ACE remains the authoritative source for ACE catalog, item maintenance, hotsheet data, API products, store-approved access, invoice data, purchase order data, promotional data, UPC data, and store-related requirements
• Free Shopify connection gives you a world class ACE dealer website that can include your other products and services
• Microsoft Dynamics 365 Business Central remains your control system for:
• Pricing approvals
• Margin protection
• ACE Compatible POS accuracy
• Operational discipline
• This integration is built from real store experience, not theory, so it supports how your team actually works every day
• View the Hardware Store ERP and Lumber and Building Material Store ERP pages to get the big picture
• Lumber and Building Material Dealer ERP
• Hardware Store ERP

• View Business Central vs Other non-Microsoft systems
  • Epicor vs Business Central
  • Paladin POS vs Business Central
  • Rundoo POS vs Business Central