D365 Business Central True Value Compatible POS
Microsoft Dynamics 365 Business Central provides True Value hardware dealers with an integrated ERP and True Value compatible POS environment for supplier item data, tiered pricing, UPC maintenance, purchasing, SFTP order uploads, MRI invoices, RDC balances, daily POS reporting and weekly inventory reporting. True Value EZConnect files remain operational as the supplier-specific EDI platform, while Business Central controls the True Value catalog and other supplier inventory, purchasing, pricing, customer transactions and financials. View the Hardware Store POS System Comparison for Independent Hardware, Lumber & Building Material Supply Dealers.
Retail True Value Catalog Updates
What this delivers
- Complete True Value tiered item data from the all-item load and weekly item maintenance files
- Automatic updates for item descriptions, vendor and manufacturer references, primary UPCs, packaging, Policy A, assortment, Core, e-commerce, discontinued-item and RDC ETA fields
- Reduces manual item creation and maintenance
- Keeps stocked, non-stocked, substitute, referral and discontinued item information current
- Gives cashiers and buyers dependable True Value item data inside Business Central
Retail True Value Catalog Item File Maintenance
What this delivers
- Processes SPEC40 weekly tiered item adds, changes and deletes
- Maintains True Value department, class, subclass, brand, model, image ID, assortment, break-pack and unit-of-measure attributes
- Keeps the Business Central item master aligned with True Value maintenance
- Supports tiered item relationships and change controls without duplicate entry
Retail True Value Catalog Item Images and Long Descriptions
What this delivers
- Processes DS057 full supplementary item data and DS057W weekly changes
- Associates True Value item picture IDs and Fine Line long descriptions with catalog items
- Improves product lookup and catalog presentation
- Supports richer ERP, POS and e-commerce item records without manually rekeying descriptions
Retail True Value Dealer POS Data Upload
What this delivers
- Creates the DS090 daily POS extract and control file for True Value Data Capture and True Value Rewards
- Includes transaction, member, rewards, house-account, tax, price, cost, margin, department, class, subclass, register and cashier fields
- Supports required True Value reporting with record-count integrity controls
- Eliminates duplicate preparation of daily POS transaction files
Retail True Value Catalog Fine Line Classification
What this delivers
- Processes DS009 weekly replacement files for True Value Department, Class and Subclass descriptions
- Maintains the Fine Line hierarchy in ascending department, class and subclass sequence
- Provides cleaner reporting, merchandising and item filtering
- Keeps True Value classification language available in Business Central
Retail True Value Dealer Order Upload
What this delivers
- Creates DS020 fixed-width SFTP member orders for warehouse, paint, Policy A claims and events
- Supports member-assigned purchase-order references, ship windows, assortments, price overrides and True Value special quantity codes
- Moves approved Business Central purchase orders into the True Value order format
- Reduces manual portal entry and preserves store order references
Retail True Value Dealer MRI Warehouse Invoice
What this delivers
- Downloads DS013 Combination Stock Invoice/Relay MRI files throughout the day
- Processes quantities, member cost, line extensions, fill codes, substitutions, suggested retail, UPCs, packs, Policy A, payment dates, departmental totals and freight
- Supports receiving, cost updates and invoice reconciliation in Business Central
- Provides visibility into filled, partial, substituted, ship-later and unfilled lines
True Value Catalog E-Commerce and BOPIS
What this delivers
Visit Shopify E-Commerce page for features and pricing - Uses True Value item, image, description, UPC, pricing and availability data maintained in Business Central
- Business Central can serve as the controlled product and inventory source for connected commerce channels
- Allows store-owned products, services and other suppliers to be managed with the True Value catalog
- Keeps online item data tied to the same ERP records used by purchasing and POS
True Value Dealer Tiered Price Maintenance
What this delivers
- Processes SPEC41 weekly member price maintenance and SPEC46 all-item tiered pricing
- Supports national cost, four member-cost tiers, promotional and special pricing, direct-ship tiers, suggested retail, variable retail, e-commerce retail and wholesale or fractional UOM pricing
- Supports controlled review of cost, retail and margin changes
- Uses Variable Retail Price when supplied, otherwise True Value Suggested Retail, according to the specification
Retail True Value Catalog Unit of Measure
What this delivers
- Maintains retail and wholesale units of measure, multipliers, tier quantities, pack quantities and full-pack restrictions
- Supports wholesale and fractional variable retail prices and their corresponding UOM codes
- Helps prevent cost and retail errors when items are purchased and sold in different units
- Supports hardware items sold by each, pack, spool, foot or other configured units
Retail True Value Dealer Direct and Relay Invoice Detail
What this delivers
- Processes MRI order types for regular warehouse, Central Ship, paint, promotions, events, online retail, Relay and other documented True Value order categories
- Captures statement number, payment date, AR amount, relay type, freight, merchandise and adjustment totals
- Improves accounts-payable support and purchase-document reconciliation
- Preserves True Value invoice and payment references in Business Central
True Value Warehouse RDC Balances
What this delivers
- Downloads DS012 daily RDC balance files for the member’s assigned RDC
- Shows source location and quantity when fulfillment comes from the assigned RDC, a hub RDC, Central Ship or True Value manufacturing
- Helps buyers answer availability questions and make purchasing decisions
- An item absent from the assigned RDC file is identified by the specification as unavailable from the assigned RDC and the listed alternate locations
Retail True Value Catalog UPC Maintenance
What this delivers
- Processes DS063 weekly All-UPC loads and DS062 weekly UPC adds, changes and deletes
- Maintains primary indicators, effective dates, model numbers and validated UPC-A retail-pack codes
- Improves scanning accuracy at POS
- Helps prevent duplicate, blank, zero or invalid-check-digit UPC records from entering the store item file
True Value Data Capture Inventory Upload
What this delivers
- Creates SPEC97 weekly Saturday inventory control and detail files
- Includes all active store items, including zero and negative on-hand quantities, plus retail price, replacement and average cost, sales history, location, on-order quantity, reorder point, pack and secondary UPC data
- Supports True Value Data Capture inventory reporting directly from Business Central
- Uses a control record count to support file integrity
True Value Data Capture Inventory Upload
What this delivers
- Creates SPEC97 weekly Saturday inventory control and detail files
- Includes all active store items, including zero and negative on-hand quantities, plus retail price, replacement and average cost, sales history, location, on-order quantity, reorder point, pack and secondary UPC data
- Supports True Value Data Capture inventory reporting directly from Business Central
- Uses a control record count to support file integrity
How Microsoft Dynamics 365 Business Central Compares to Other Software
View Business Central vs Other non-Microsoft systems
The Big Picture for True Value Hardware Dealers
- True Value EZConnect remains the supplier data exchange for item, price, UPC, RDC balance, order, invoice, POS and inventory files.
- Microsoft Dynamics 365 Business Central remains the operational control system for purchasing, receiving, inventory, pricing, POS, customer accounts and financial management.
- True Value EDI capabilities are included in Business Central True Value EDI, using supplier-specific fixed-width files and SFTP workflows.
- System Solutions LLC has documented True Value integration experience, including the True Value Gold Standard since 2010.