James Allman | JA Technology Solutions LLC

Site Index

A visual index of every page, tool, article, and demo. Click any card to jump straight to the page.

Every page, tool, article, and demo on this site is shown below with its auto-generated share card. Click any card to jump to the page. Use the Share button to grab a link to drop into a post or message.

Home

Software development, systems integration, and cross-platform consulting

I'm an independent software developer, systems architect, and cross-platform consultant, working across IBM i, Linux, Windows, mobile devices, the web, and cloud services. I help businesses support, modernize, integrate, and build the software their operations run on, whether that means strengthening a system that has run for years or building something new alongside it.

Page

Services for IBM i, Linux, and Windows systems

I support, migrate, modernize, integrate, and extend the systems an operation actually runs on: an IBM i ERP, a Linux server hosting the nightly reporting, a Windows app the back office cannot do without, and the connections between them. The work keeps what already runs maintainable and connected rather than replacing it for its own sake.

Page

Custom reporting for operational and management decisions

Reporting drives operations, visibility, accountability, and decision-making. I provide custom reporting services for organizations that need better outputs, reporting automation, and practical reporting improvements across legacy and modern systems.

Page

Legacy system migration that protects what works

Migration is rarely just a technical conversion. Long-lived systems contain years of business rules, reporting logic, integration behavior, and custom workflows. I help organizations move to better platforms while preserving the behavior their operations depend on.

Page

Modernization that builds on what you have

Modernization does not mean starting over. It means making existing systems more maintainable, more capable, and better connected, without the risk of a wholesale replacement.

Page

System integration that connects your business

Most business environments rely on multiple systems exchanging data across operations, finance, warehousing, retail, and reporting. I help organizations connect those systems reliably, through practical, supportable data flow.

Page

Custom applications for the work no package fits

If the way your business runs a process doesn't match any product you can buy, and you've patched the gap with a spreadsheet, a manual rekeying step, or an export-and-reimport ritual someone redoes every week, that gap is what custom software is for. I design and build applications that fit how your operation actually works, on IBM i, Linux, Windows/.NET, and the web.

Page

ETL and data pipelines that move your business forward

Every time data moves between systems (whether it is a one-time migration or a process that runs every night) there is an ETL pipeline behind it. I build the ones that work reliably and the ones that replace the ones that do not.

Page

Database development for the systems your business depends on

Databases are the foundation of every enterprise application. I design, develop, migrate, and optimize databases across DB2, SQL Server, PostgreSQL, Informix, Microsoft Access, and other platforms, with a focus on reliability, performance, and long-term maintainability.

Page

EDI that keeps your trading partners connected

Electronic Data Interchange is the backbone of automated business-to-business transactions: purchase orders, invoices, advance ship notices, and more. I develop, support, and troubleshoot EDI systems for organizations where reliable data exchange with trading partners is critical to operations.

Page

IBM i consulting, support, reporting, and modernization

If your business still runs on an IBM i, the platform you may know as the AS/400 or iSeries, and the RPG has grown undocumented and risky to change, a vendor is quoting a multi-year rip-and-replace you are not sure you need, and the green screens work fine but no new hire wants to learn them, that is the work I do. I provide independent IBM i consulting: support, reporting, integration, troubleshooting, and a modernization path that fits the business rather than a rewrite for its own sake.

Page

Linux application development and infrastructure architecture

Linux is the foundation of modern enterprise infrastructure. I build applications, design deployment architectures, and integrate Linux-based platforms with existing business systems, including IBM i, Windows, and cloud environments.

Page

Microsoft and Windows platform development

From C# and .NET application development to Excel and VBA automation, Access databases, SQL Server, and banking integrations, I build and maintain the Microsoft-based tools that business operations and finance departments depend on.

Page

Cloud architecture and deployment for modern business systems

Cloud is not a destination. It is an architecture. I design and build cloud deployments that are reliable, cost-effective, and practical for the systems your business depends on, whether that means serverless functions, containerized applications, or hybrid architectures that bridge cloud and on-premises.

Page

Grocery retail merchandising system support, reporting, and modernization

I support and extend grocery merchandising platforms, including Grocers Support Systems (GSS), a platform I actively develop for, and similar retail management software. That covers support, enhancement, reporting, integration, and modernization planning.

Page

IBM i and IT consulting for Guam and the Marianas

If you run an AS/400 or IBM i system in Guam and your support options have thinned out (local IBM i expertise has dwindled, and mainland vendors quote you a 15-hour time difference before they quote you a rate), that is the gap I fill. I have supported organizations in Guam since 1995 and lived on the island for several years.

Page

GSS: Grocers Support Systems

Grocers Support Systems (GSS) is a grocery retail merchandising platform built on IBM AS/400 (IBM i). The system manages centralized retail pricing and cost control for supermarket chains and communicates with point-of-sale devices across all store locations. GSS serves chains ranging from a handful of stores to over a hundred, with the core platform, the Scan Support and Merchandising System (SSMS), acting as the central database and host for all merchandising, inventory, and financial operations.

Page

Custom applications for programmable handheld barcode scanners and mobile data terminals

Handheld barcode scanners and mobile data terminals run some of the most operationally critical software in a warehouse or store. I build custom applications for programmable handhelds (Symbol, Motorola, and Zebra Technologies device lineages) with direct integration to the backend systems they feed.

Page

Custom software for Zebra handheld barcode scanners and mobile computers

Zebra Technologies mobile computers are the dominant handheld platform in warehouse, distribution, and retail environments. I build custom applications for Zebra handhelds (and the secure backend services they connect to) with production experience spanning the full Symbol → Motorola → Zebra device lineage.

Page

Industry experience grounded in real operational systems

I work with organizations across industries whose systems support real operational workflows, with particular depth in grocery retail, warehousing, and the finance and accounting operations that support them.

Page

Insights

Technical perspectives on systems, modernization, integration, and the platforms that businesses depend on.

Page

See It In Action

See what modernization looks like: edit real data and watch it come to life.

Page

Free Tools

Practical tools for developers, IT professionals, and business systems teams. Everything runs in your browser: no signup, no uploads, no data leaves your machine.

Page

About James Allman

I am an independent software developer, systems architect, and cross-platform consultant. From strategy through delivery, I help businesses support, modernize, integrate, and build the software their operations run on, across IBM i, Linux, Windows, mobile devices, the web, and cloud services.

Page

How I Work

Whether your organization is a large enterprise or a focused operation with critical business systems, here is how I work, what to expect, and answers to the questions prospective clients ask most often.

Page

Engagement Models & Pricing

Engagements are structured around the work, not forced into a single billing model. Four models cover most situations. The right one depends on what you need: a one-off question, a defined deliverable, ongoing capacity, or embedded senior expertise for a major initiative.

Page

Contact

Send a message, schedule a call, or pick up the phone, whichever you prefer. I help with support, migration, modernization, integration, custom development, and reporting across IBM i, Linux, and Windows systems.

Page

Schedule a Call

Book a phone call to discuss your project, ask questions, or explore how I can help. No obligation, no sales pitch, just a straightforward conversation.

Page

How This Site Was Built

This site is a working example of the kind of practical, maintainable, and well-engineered software I build for clients. Here is what it is made of and why.

Page

Privacy Policy

JA Technology Solutions LLC respects your privacy. This policy explains what information is collected through this website and how it is used.

Page

Terms of Use

Plain-language terms for using this website and the free tools it offers. Consulting engagements are covered separately by a written agreement.

Page

Shipping, freight, and logistics operations integration and custom development

If your operation generates bills of lading, allocates landed cost across multi-line import shipments, or moves freight data between a TMS, an ERP, and a carrier's systems, you know how much of that data movement is still manual. Rekeying a PRO number from a carrier website into an ERP, re-entering a customs entry into a landed-cost spreadsheet, or re-classifying freight because the NMFC class on the BOL doesn't match the carrier's assessment: these are integration problems, and they're solvable.

Page

Joining the JA Technology Solutions Teams Workspace

Welcome. JA Technology Solutions uses Microsoft Teams as the primary workspace for client collaboration: chat, calls, file sharing, and ongoing project work. This page walks you through joining and getting comfortable with the basics.

Tool Category

Data & Finance Tools

Banking, accounting, healthcare, payments, and EDI file formats.

Tool Category

Retail & POS Tools

Barcodes, POS files, retail math, and fiscal calendars.

Tool Category

Grocery & Fresh Departments Tools

Meat, produce, deli, bakery, seafood, and floral department math and operations.

Tool Category

Shipping & Logistics Tools

Freight estimation, container loading, route optimization, and trade compliance.

Tool Category

Inventory & Warehouse Tools

Reorder planning, cycle counting, warehouse slotting, and cost allocation.

Tool Category

Networking Tools

Subnet math, MAC vendor lookup, email authentication, and WHOIS.

Tool Category

Development Tools

Format converters, encoders, hashes, regex, JWT, SQL, and more.

Tool Category

IBM i & Mainframe Tools

EBCDIC, packed decimal, COBOL copybook, DDS, BMS, and fixed-width.

Tool

QuickBooks Explorer

Explore and create QuickBooks Desktop QB IIF and QuickBooks Online CSV files. Parse, validate, convert, and generate, all in your browser.

Tool

BAI2 File Explorer

Parse BAI2 bank statement files into structured views with type code lookup, transaction details, a duplicate Bank Reference # audit, and CSV export.

Tool

NACHA/ACH File Explorer

Parse ACH payment files into readable records. View entries, totals, and export to CSV or JSON.

Tool

Positive Pay Generator

Generate Positive Pay fraud prevention files from check data. Chase, BofA, Wells Fargo, and generic formats.

Tool

BAI2 File Generator

Generate BAI2 bank statement test files with configurable accounts, transactions, and auto-calculated control totals.

Tool

OFX/QFX Explorer

Parse OFX and QFX bank statement files. Separate transactions by account in multi-account files, view balances, and export to CSV.

Tool

SWIFT MT Explorer

Parse SWIFT MT financial messages (MT103, MT940, MT700). Block structure, field lookup, and transaction tables.

Tool

Business Day Calculator

Count business days between dates or add/subtract business days. Includes US holiday awareness and payment term shortcuts.

Tool

Depreciation Calculator

Calculate asset depreciation schedules using straight-line, declining balance, sum-of-years-digits, or MACRS methods.

Tool

Check Digit Validator

Validate and calculate check digits for UPC, EAN, credit cards (Luhn), and ABA routing numbers.

Tool

Barcode Explorer

Generate, scan, and decode barcodes in 15+ formats. Camera scanning, image upload, batch detection, and CSV export.

Tool

Margin & Markup Calculator

Convert between margin %, markup %, cost, and selling price. Includes profit calculation and reference table.

Tool

Retail Fiscal Calendar (4-5-4)

Map any date to its NRF 4-5-4 retail fiscal year, quarter, period, and week number.

Tool

EOQ Calculator

Compute the Economic Order Quantity that minimizes total annual inventory cost.

Tool

Safety Stock Calculator

Calculate safety stock and reorder point from demand and lead-time variability at any service level.

Tool

ABC Analysis Tool

Upload SKUs with annual value and get Pareto-sorted A/B/C tiers with CSV and Excel export.

Tool

Shipment Cost Allocator

Allocate shared freight, duty, and fees across PO lines by weight, volume, value, or equal basis.

Tool

Pallet Pattern Generator

Generate and compare pallet stacking patterns (column, interlock, pinwheel, mixed orientation) with mixed-SKU layer packing and multi-SKU layer stacking.

Tool

Reorder Point Dashboard

Combine EOQ, safety stock, and reorder point across your SKU portfolio with CSV upload and below-ROP alerts.

Tool

Cycle Count Planner

Generate ABC-driven cycle count schedules with configurable frequencies, daily capacity, and working days.

Tool

Warehouse Slotting Simulator

Assign SKU slot positions by pick velocity with hot/warm/cold zones and golden-zone scoring.

Tool

HS/HTS Tariff Code Lookup

Search Harmonized System (HS) and US HTS tariff codes at the 4-digit heading and 6-digit subheading level.

Tool

NMFC Freight Class Estimator

Calculate density in lb/cu ft and get a density-based LTL freight class estimate.

Tool

Pallet & Container Calculator

Calculate cases per pallet and pallets per container with weight and cube utilization checks.

Tool

Route & Stop Optimizer

Optimize delivery stop order with interactive map visualization. Nearest-neighbor + 2-opt heuristic for up to 500 stops.

Tool

Dimensional Weight Calculator

Compare dimensional weight across UPS, FedEx, and USPS with billable weight analysis.

Tool

Freight Rate Estimator

Estimate LTL, parcel, and truckload freight costs with class-based rates, dimensional weight, and accessorials.

Tool

Shipping Box Calculator

Find the optimal box size from standard carrier catalogs based on your item dimensions and weight.

Tool

Bill of Lading Generator

Generate a standard straight bill of lading with shipper, consignee, commodity lines, and print-ready output.

Tool

Container Loading Planner

Pack mixed pallets into containers with first-fit-decreasing bin packing, stacking, and weight checks.

Tool

Pallet Label Generator

Generate 4×6 GS1 pallet labels with SSCC-18 barcodes, ship-to, PO, gross weight, and case count, print single or batch.

Tool

Landed Cost Calculator

Compute per-unit landed cost with freight, duty, insurance, and fees: single SKU or multi-line shipment.

Tool

SIL File Explorer

Parse SIL (Standard Interchange Language) files into structured tables with CSV and JSON export.

Tool

EDI File Parser

Upload or paste any EDI file, parsed into labeled segments with export to CSV, JSON, and SIL.

Tool

EDI 810 Invoice Builder

Enter invoice details, paste a CSV, or import from QuickBooks. Download a valid X12 EDI 810 invoice ready to submit to a trading partner.

Tool

EDI 850 Purchase Order Builder

Enter PO details, paste a CSV, or import from QuickBooks. Download a valid X12 EDI 850 purchase order ready to send to a supplier.

Tool

EDI 856 Advance Ship Notice Builder

Build a valid X12 EDI 856 advance ship notice: nested HL shipment/order/item loops, carrier and BOL details, and one-click pre-fill from a prior 850.

Tool

EDI 997 Functional Acknowledgment Builder

Paste any inbound X12 document. The tool lists each transaction set so you can mark it accepted or rejected, then download a valid 997 ready to transmit.

Tool

EDI 855 Purchase Order Acknowledgment Builder

Paste the inbound 850. The tool pre-fills every line as accepted, then you mark the ones that change quantity, price, or ship date, or reject the ones you can't fulfill.

Tool

EDI 820 Remittance Advice Builder

Tell the payee which invoices you're paying. Load 810s to populate invoice entries, set action codes and amounts, and download a valid 820.

Tool

EDI 852 Product Activity Builder

Report sell-through and on-hand quantities per item, with an optional per-store SDQ breakdown, and download a valid X12 852 ready to send.

Tool

EDI 875 Grocery Products PO Builder

Enter grocery PO details and line items with case UPCs. Download a valid UCS X12 875 grocery products purchase order ready to send.

Tool

EDI 880 Grocery Products Invoice Builder

Enter grocery invoice details and line items with case UPCs. Totals compute automatically. Download a valid UCS X12 880 ready to submit.

Tool

X12 Segment Reference

Searchable EDI X12 segment and element dictionary with 43 segments, 27 transaction sets, and qualifier codes.

Tool

HL7 Message Explorer

Parse HL7 v2.x healthcare messages with segment descriptions, field labels, and message type identification.

Tool

FHIR Resource Explorer

Parse HL7 FHIR JSON resources with resource-specific rendering. Supports Patient, Observation, Bundle, and more.

Tool

ISO 8583 Explorer

Parse ISO 8583 payment card messages with MTI breakdown, bitmap visualization, and data element parsing.

Tool

CSV & Delimited Text Converter: CSV, TSV, Pipe, Excel

Convert CSV, TSV, pipe-delimited, custom-delimiter text, and Excel files into CSV, TSV, pipe, JSON, JSONL, Excel, YAML, XML, Markdown table, HTML table, or SQL INSERT statements.

Tool

IBM i Date Format Converter

Convert IBM i / AS400 dates between CYYMMDD, Julian, and the *ISO family, single values or whole columns, with RPG, COBOL, and SQL source for each conversion.

Tool

IBM i Message ID Lookup

Decode IBM i and AS/400 message IDs (CPF, MCH, RNX, SQL, and more): category, message file, the on-system DSPMSGD command, and a link to IBM documentation.

Tool

IBM i System Reference Code Lookup

Decode IBM i and AS/400 system reference codes (SRCs): classify by type (A, B, C, D), see where to find them in the Product Activity Log, and link to IBM's reference-code list.

Tool

EBCDIC to ASCII Converter

Convert between EBCDIC and ASCII for IBM i, AS400, and mainframe systems. Fixed-length records, line ending options, CP037 reference.

Tool

Character Encoding Reference

Compare ASCII, Windows-1252, ISO-8859-1, and EBCDIC CP037 in a searchable 0–255 table. Look up any character or code point, see its byte representation in every encoding and UTF-8/16/32, and transcode between encodings. Decode legacy DBCS bytes (Shift-JIS, GBK, Big5, EUC-JP, EUC-KR).

Tool

Packed Decimal / COMP-3 Converter

Decode and encode packed decimal (COMP-3), zoned decimal, and trailing overpunch for IBM i and mainframe systems.

Tool

DDS Screen Explorer

Paste IBM i DDS display file source and see the screen rendered with authentic 5250 green-screen and modern preview.

Tool

DDS to SQL / SQL to DDS Converter

Convert between IBM i DDS physical file definitions and SQL CREATE TABLE statements in both directions.

Tool

BMS Screen Explorer

Paste mainframe BMS (CICS/3270) screen definitions and see the screen rendered with green-screen and modern preview.

Tool

COBOL Copybook Explorer

Explore COBOL copybook structures with interactive tree view, field layout, SQL conversion, JSON Schema generation, sample data decoding, and visual hex ruler.

Tool

Fixed-Width ↔ CSV

Convert between fixed-width text files and CSV. Editable column definitions with name, start, and length.

Tool

Data Diff & Compare

Compare two datasets with key-field joining. Supports CSV, TSV, JSON, XML, YAML, and Excel with automatic dot-notation flattening for nested structures.

Tool

File Compare & Merge

Compare two text or code files with line-level diff and intra-line word/character highlighting. Side-by-side, unified, and inline views. JSON structural mode. Unified-patch export and apply.

Tool

Data Profiler

Profile CSV data with column-level statistics, value distribution charts, quality matrix, and drill-down column detail.

Tool

Parquet File Explorer

View and explore Apache Parquet files entirely in your browser. See schema and metadata, browse data with filtering, export to CSV/JSON/Excel, or convert files to Parquet.

Tool

JSON ↔ CSV

Convert between JSON and CSV formats. Paste, upload, or load sample data. Download or copy the result.

Tool

XML ↔ JSON Converter

Convert between XML and JSON formats. Handles attributes, CDATA, arrays, and nested elements.

Tool

YAML ↔ JSON Converter

Convert between YAML and JSON formats. Handles multiline strings, anchors, and flow syntax.

Tool

XML Formatter

Format, pretty-print, minify, and validate XML with syntax highlighting and well-formedness checking.

Tool

SQL Formatter

Pretty-print SQL queries with proper indentation and keyword uppercasing. Supports common SQL dialects.

Tool

Regex Tester & Builder

Test regex patterns with real-time match highlighting. Built-in pattern builder and syntax reference.

Tool

JWT Explorer

Decode, inspect, and build JWTs. View claims, check expiration, and create HMAC-signed tokens.

Tool

Cron Expression Builder

Build and decode cron expressions visually. 12 presets, 5-field editor, and human-readable descriptions.

Tool

Base64 Encode/Decode

Encode text to Base64 or decode Base64 to text. Supports UTF-8.

Tool

Hash Generator

Generate SHA-256, SHA-384, SHA-512, and SHA-1 hashes from text or an uploaded file using Web Crypto.

Tool

Timestamp Converter

Convert Unix epoch timestamps to human-readable dates and back. Timezone support.

Tool

UUID Generator

Generate v4 UUIDs. Single or bulk generation up to 100. Copy individual or all.

Tool

URL Encode/Decode

Percent-encode or decode URLs and query parameters. Component and full-URL modes.

Tool

Color Converter

Convert between Hex, RGB, and HSL color formats. Live preview swatch and ready-to-use CSS output.

Tool

JSON Converter

Convert JSON arrays of objects to CSV, Excel, XML, YAML, and 7 other formats.

Tool

Excel Converter

Convert Excel workbooks to CSV, JSON, XML, and 8 other formats. Multi-sheet picker, Force Text columns.

Tool

XML Converter

Extract repeating-element data from XML and convert to CSV, Excel, JSON, and 8 other formats.

Tool

YAML Converter

Convert YAML (array of objects, or a top-level mapping containing one) to CSV, Excel, JSON, and 8 other formats.

Tool

HTML Table Converter

Extract HTML <table> data and convert it to CSV, Excel, JSON, and 8 other formats.

Tool

SQL INSERT Converter

Extract rows from SQL INSERT statements and convert them to CSV, Excel, JSON, and 8 other formats.

Tool

Markdown Table Converter

Convert GitHub Flavored Markdown tables to CSV, Excel, JSON, and 8 other formats.

Tool

Markdown Preview

Live side-by-side markdown editor and rendered preview. Supports headers, lists, code, links, and more.

Tool

Subnet Calculator

Calculate network ranges, masks, host counts, and CIDR notation for IPv4 subnets.

Tool

IPv6 Subnet Calculator

Calculate IPv6 prefixes, expanded and compressed notation, network and host portions, and total addresses.

Tool

IP Address Converter

Convert IPv4 addresses between dotted, decimal, hex, octal, and binary representations.

Tool

CIDR Range & Overlap Tool

Detect overlaps between CIDR blocks, merge adjacent ranges, and check IP containment.

Tool

MAC Address Tool

Format, validate, and look up vendor for MAC addresses across all common notations.

Tool

Email Auth Checker

Check SPF, DMARC, DKIM, MX, and BIMI records for any domain in one place.

Tool

WHOIS Lookup

Look up domain and IP ownership using the modern RDAP protocol: registrar, expiry, name servers, ASN.

Tool

DNS Lookup

Query any DNS record type (A, AAAA, MX, TXT, NS, SOA, CAA, SRV, PTR) directly from your browser.

Tool

DNS Propagation Check

Query Cloudflare, Google, OpenDNS, and NextDNS in parallel and flag any resolver whose answer differs from the majority.

Tool

Reverse DNS + FCrDNS Checker

Look up the PTR record for an IP and verify the round-trip (FCrDNS), important for mail server reputation.

Tool

DNSBL Check

Check an IPv4 address against 12 public DNS blacklists in parallel and see exactly which lists flagged it.

Tool

ASN Lookup

Look up ASN, AS name, announced prefix, country, and registry for any IPv4 or IPv6 address.

Tool

HTTP Header Inspector

Fetch any URL and see its response headers, redirect chain, and a full security-header audit (HSTS, CSP, X-Frame-Options, and more).

Tool

SSL Certificate Checker

Check HTTPS reachability and certificate history for any hostname via Certificate Transparency logs.

Tool

IBAN Validator

Validate IBAN check digits and decode country and BBAN structure using the ISO 13616 mod-97 algorithm.

Tool

Amortization Calculator

Calculate loan amortization schedules with monthly payment, principal/interest breakdown, and extra payment analysis.

Tool

MICR Line Decoder

Parse the MICR E-13B line from a check to extract routing number, account number, check number, and amount.

Tool

Card Number Validator

Validate card numbers with the Luhn algorithm and detect card network from prefix ranges.

Tool

Connection String Builder

Build JDBC, ADO.NET, and ODBC connection strings with a browsable property reference for 8 database platforms and 18 drivers.

Tool

CSV SQL Query Tool

Upload CSV, Excel, or Parquet files and query them with real SQL, joins across files included, or ask a question in plain English and review the generated SQL.

Tool

CSV to SQL Generator

Convert CSV data to SQL CREATE TABLE and INSERT statements with automatic type detection and dialect-specific output.

Tool

GS1 Application Identifier Parser

Parse GS1-128 and DataMatrix Application Identifier strings into structured, human-readable fields with validation.

Tool

WSDL/SOAP Explorer

Parse WSDL 1.1 files and explore SOAP services, operations, bindings, messages, and inline XSD types.

Tool

XSD/XML Schema Explorer

Parse XML Schema (XSD) files and explore element hierarchies, complex and simple types, restrictions, and generate sample XML.

Tool

JSON Schema Validator

Validate JSON documents against JSON Schema definitions with detailed error reporting and skeleton generation.

Tool

Meat Cutting Test Calculator

Calculate cutting test yields, cost allocation, and pass/fail against target yields for beef, pork, and poultry primals.

Tool

Shrink & Waste Calculator

Calculate inventory shrink, known waste, COGS, and gross profit by department with industry benchmark comparison.

Tool

Bakery Scaling & Yield Calculator

Scale baking formulas with bakers' percentages, work back from finished-product targets, and account for baking loss.

Tool

Produce Shrink & Rotation Calculator

Track produce lot aging by category shelf life, project shrink, and time markdowns optimally, lot-by-lot, not dollar totals.

Tool

Deli Prepared Foods Recipe-to-Retail Calculator

Roll up ingredient costs with yields, add labor and packaging, and price prepared foods to a target margin.

Tool

Seafood Case-Pack & Yield Calculator

Calculate whole-fish-to-fillet yield by species, factor ice and packaging, and cost the saleable pound.

Tool

Floral Department Turn & Freshness Calculator

Count stems from wholesale receipts, compose bouquets, track vase life, and time markdowns on aging floral inventory.

Tool

Multi-Vendor Receiving Dock Scheduler

Schedule vendor deliveries by dock capacity, truck cube, and time window. Resolves conflicts and produces a daily schedule.

Tool

Price-Per-Unit Comparator

Compare product prices normalized to a common unit across weight, volume, or count. Find the best value instantly.

Tool

PLU Code Lookup

Search all IFPS produce PLU codes by number or commodity name with organic code conversion and category filters.

Tool

Case Pack / Inner Pack Calculator

Calculate order quantities, days of supply, reorder points, and shelf facings from case pack and movement data.

Tool

POS Item File Audit Checker

Compare a POS item export against the host item file and flag price, cost, and description mismatches by UPC.

Tool

Vendor Cost Change Impact Calculator

See how a vendor case cost change affects unit cost, margin, and GP%, and the retail that restores your original margin.

Tool

Retail Price Point & Rounding Calculator

Turn unit cost and target GP% into a retail price, round it to .x9, .x5, or .99 endings, and see the actual margin.

Tool

Mix & Match Multiple Pricing Calculator

Price 3 for $5 multiples: effective unit price, the per-unit penny split the POS rings, GP%, and margin per group.

Tool

Markdown & Promotion Planner

Compare weekly GP$ at regular vs promo price, see the total margin impact, and find the breakeven sales lift.

Tool

Date Code & Julian Date Decoder

Decode 3, 4, and 5-digit Julian date codes into calendar dates, or calculate sell-by and use-by dates from a pack date.

Tool

GMROI & Inventory Turns Calculator

Calculate GMROI, inventory turns, days of supply, and sell-through from sales, margin, and average inventory.

Tool

ACH Return Code Lookup

Look up Nacha ACH return reason codes (R01 to R85) and notification of change codes: what each means, who returns it, and the return window.

Tool

BAI2 Type Code Reference

Search BAI2 type codes from the BAI file specification: balance status codes, credit codes, and debit codes, with plain-language descriptions.

Tool

UPC-E to UPC-A & GTIN Converter

Convert between UPC-E, UPC-A, GTIN-13, and GTIN-14 forms of the same product code, with check digits computed and validated.

Tool

Tracking Number Format Identifier

Identify which carrier format a tracking number matches and validate its check digit where the algorithm is published.

Tool

Incoterms 2020 Reference & Comparison

Browse all 11 Incoterms 2020 rules, compare any two side by side, and see the classic responsibility matrix for risk, freight, duty, and insurance.

Tool

FIFO / LIFO / Average Cost Calculator

Calculate COGS and ending inventory under FIFO, LIFO, and perpetual weighted average from a transaction ledger, with per-sale cost layer breakdowns.

Tool

Department Labor Scheduler

Calculate weekly labor hours and budgets by department from sales forecasts, labor targets, and hourly rates.

Tool

Shelf Label Generator

Generate retail shelf labels with barcodes, unit pricing, sale and produce templates, and batch Avery sheet printing.

Tool

Large Sign Generator

Create professional sale signs, endcap headers, and department markers with custom fonts, colors, layouts, and paper sizes.

Tool

Nutrition Facts Label Generator

Build a print-ready Nutrition Facts panel in the current FDA format, with automatic %Daily Value and FDA rounding from the values you enter.

Tool

Random-Weight UPC (Type 2) Decoder

Decode variable-measure UPC-A barcodes (number system 2) used on random-weight grocery items: item number, embedded price or weight, and check digits.

Tool

GS1 Coupon Decoder (DataBar / AI 8110)

Decode GS1 DataBar Expanded coupons carried under Application Identifier 8110 into structured, human-readable fields.

Tool

EDI 894/895 DSD Delivery/Return Explorer

Decode X12 EDI 894 and 895 DSD delivery/return documents into a readable summary: header, parties, line items, totals, plus raw segments and CSV export.

Tool

DEX/UCS File Explorer

Decode a DEX/UCS direct-store-delivery file: the DXS/DXE application envelope plus the embedded 894/895 delivery and return records.

Tool

WIC APL File Explorer

Parse a state WIC APL (Approved Product List) file into a readable table of eWIC-authorized items, with a category summary and CSV/Excel export.

Article

DDS to SQL: Modernizing IBM i Database Definitions

Most IBM i databases were defined with DDS. Moving that definition to SQL DDL is one of the most concrete, low-risk steps in a modernization effort, and it unlocks capabilities DDS cannot provide.

$The Math Behind Inventory Decisions share card$

Article

The Math Behind Inventory Decisions

EOQ, safety stock, and reorder point are standard supply chain formulas. Here is what each calculates, what it assumes, and where real inventory breaks the model.

Article

Warehouse Slotting: Putting the Right SKU in the Right Spot

Most of the labor in an order-pick operation is travel. Slotting controls where each SKU lives in the warehouse, and getting it right means pickers walk less on every order.

Article

Reading DSD Deliveries: DEX, EDI 894, and 895

Direct store delivery hands you the same delivery record two ways: at the dock as DEX, and over the wire as EDI 894/895. Here is what is inside each, and how to read it.

Article

Inventory Valuation: Where the Numbers in Your ERP Come From

Two companies can buy the same goods, sell the same units, and report different cost of goods sold. The difference is a configuration choice called the cost flow assumption, and most people running reports against it could not say which one their system uses.

Article

What an Imported Case Really Costs

The vendor invoice is the most visible number in an import and the least sufficient one. Between the factory and your shelf sit freight, insurance, duty, brokerage, and a three-letter term that decides who pays for each. The margin you think an item earns depends on getting all of it into the unit cost.

Article

Teaching the AS/400 to Talk to the Outside World

To move files between an AS/400 and the modem-driven, serial world it was never built for, I wrote the protocols, the asynchronous layer beneath them, and a send-and-expect layer to automate the exchange. The same job, connecting systems that were not meant to talk, is most of integration work today.

Article

The AS/400 Machine Interface, and Why IBM i Endures

To build native Xmodem and Ymodem file transfer for the AS/400, I dropped to the machine interface for fast CRC routines, before C was common on the platform. What that low level reveals about why IBM i still runs today.

Article

IBM i: The Platform Decision-Makers Should Understand

A practical overview for business leaders evaluating, maintaining, or modernizing IBM i environments.

Article

ETL: The Invisible Backbone of Enterprise Data

How data actually moves between the systems your business depends on, and what goes wrong when it is not done well.

Article

EDI 101: What Business Leaders Need to Know

A plain-language guide to Electronic Data Interchange: what it is, why it matters, and how to tell when it's not working the way it should.

Article

Linux: The Foundation Your Business Already Depends On

Why the platform that runs most of the internet matters for your business, and what goes wrong when it is not managed well.

Article

Understanding BAI2 Files: A Guide for Treasury and IT Teams

Everything you need to know about the banking industry's standard cash reporting format: from file structure to automation.

Article

HL7 vs FHIR: What You Need to Know

A practical guide to healthcare data exchange standards: what works, what's changing, and how to make smart integration decisions.

Article

RPG: The Language Behind Your Business Logic

What decision-makers need to know about the programming language that powers their IBM i applications.

Article

When Your Spreadsheet Should Have Been a Database

Why the most dangerous application in your organization might be the one nobody thinks of as software.

Article

EBCDIC and ASCII: A Practical Guide to Mainframe Data Conversion

What EBCDIC is, how it differs from ASCII, where conversions go wrong, and how to handle real-world mainframe data with confidence.

Article

POS Item File Sync: Keeping Stores in Sync with the Host

Why multi-store POS item files drift, what automated audit reports reveal, and how synchronization keeps every register accurate.

Article

Automating Enterprise Firewall Deployment: Lessons From the Field

Why mass firewall rollouts need the same rigor as software releases, and what vendor APIs make possible.

Article

ISO 8583 Explained: How Payment Card Messages Work

The international standard behind every card swipe, dip, and tap, and what developers need to know about it.

Article

RPG Modernization: Options Beyond Java Migration

The migration question is more nuanced than vendors suggest. Here are the real options, tradeoffs, and a practical framework for deciding.

Article

Microsoft Access, Excel, and VBA: The Tools Your Finance Team Depends On

What decision-makers need to know about the Microsoft tools that quietly run critical business processes.

Article

Data Migration Testing: Why Record-Level Comparison Matters

Row counts match. Reports look right. But until you compare every record field by field, you don't know what the migration actually did to your data.

Article

Building Handheld Scanner Applications That Last a Decade

From Symbol and Motorola to Zebra: what makes a programmable handheld application survive decades of continuous production use.

Article

EDI X12: What's Inside an 850, 810, and 856

A developer-level walkthrough of the three transaction sets at the center of every EDI trading relationship — and the segments that trip people up.

Article

Java: The Enterprise Language That Keeps Delivering

Why the platform that powers enterprise software across every industry remains one of the most practical choices for business applications.

Article

Off-the-Shelf vs Custom Software: When Standard Falls Short

Why the software that works for everyone may not work well enough for the processes that set your business apart.

Article

Retail Shrink: The Operational Controls That Actually Work

Why inventory loss keeps climbing, where the real exposure is, and what practical technology and process changes reduce it.

Article

EDI Compliance Mandates: What Retailers Expect and How to Deliver

The wave of tightened EDI requirements from major retailers, the chargebacks that follow non-compliance, and the practical steps that prevent them.

Article

PCI DSS 4.0: Practical Compliance for Smaller Businesses

The March 2025 deadline has passed. Here is what changed, what matters most, and how smaller businesses can get compliant without enterprise budgets.

Article

AI in Enterprise: Practical Patterns Beyond the Hype

What AI integration actually looks like in business systems, where it delivers real value, and how to tell the difference between substance and spectacle.

Article

Integrating Itasca Magic CGO with a Regional Grocery Chain

What it takes to connect Upshop Inventory 360 to the host merchandising platform, warehouse, and perpetual inventory for a growing multi-store operation.

Article

ENCOR (ISS45) Enhanced Promotions: A Field Guide for Grocery and Retail Technology Leaders

What the platform supports, the promotional patterns it makes possible, and how to bring more of them to life across your fleet.

Article

ENCOR (ISS45) Transaction Log Analytics: Sales, Shrink, and Fraud Detection

What's inside the log, the patterns it reveals when parsed, and how to surface them across your fleet.

$Grocery Fresh Departments: The Math That Moves Margin share card$

Article

Grocery Fresh Departments: The Math That Moves Margin

Six operational tools for meat, produce, deli, bakery, seafood, and floral, and why small percentage shifts in these departments outsize their share of sales.

Article

Comparing Data Files: Choosing the Right Tool

How to pick between record-level and line-level comparison, and get messy spreadsheets into a shape the tools can actually read.

Article

Data Profiling: Know Your Data Before You Move It

What profiling reveals about a dataset, the surprises it catches, and why it is the first step in any migration, integration, or reporting project.

Article

Understanding OFX and QFX Bank Statement Files

Banks export all your accounts into one file. Most accounting and ERP systems import one cash account at a time. Here is what is inside an OFX or QFX file, and why splitting it by account is the step that keeps your books accurate.

Article

Building EDI X12 Documents: A Supplier's Guide

Reading an 850 purchase order is one skill. Building the 855, 856, 810, and 997 that close the loop is another. Here is what outbound EDI looks like from the supplier side, and where it breaks.

Article

Packed Decimal and COMP-3: Reading Mainframe Numbers Correctly

The numeric fields in an IBM i or mainframe flat file look like garbage until you understand that two digits share every byte, the decimal point is nowhere in the file, and the sign lives in the last nibble. Get any of those three things wrong and your ETL produces numbers that are plausible enough to pass a casual inspection.

Article

Reading COBOL Copybooks: The Map Behind Mainframe Record Layouts

A mainframe flat file is just bytes. The COBOL copybook is the map that says where each field is, what type it holds, and how many decimal places the number carries. This article covers the copybook syntax you encounter most often and what it means for an ETL, migration, or integration developer parsing those bytes.

Article

How ACH Payments Work: Inside a NACHA File

Every payroll run, vendor payment, and recurring debit rides the ACH network as a fixed-width 94-character file. Here is what is inside it, how the record hierarchy fits together, and what happens when an entry comes back.

Article

Retail Price Accuracy: Preventing Shelf-vs-Scan Errors

In multi-store retail, three systems must agree on every price: the shelf tag, the POS register, and the host merchandising system. When they drift apart, the consequences land on the customer, the margin, and the inspector.

Article

Multi-Vendor Receiving: From the Dock to Accounts Payable

A store or distribution center takes dozens of vendors a day, each arriving on a different schedule by a different path. Getting the goods in is the easy part. Getting the receipt data into AP and the item file without rekeying it is the integration problem.

Demo

Business Intelligence Dashboard

Edit live data, analyze with grouping and filters, and visualize across multiple chart types.

Demo

EDI Made Useful

See raw EDI purchase orders and invoices parsed into readable documents and usable data formats.

Demo

Modernization in Action

Walk three real green-screen programs, then see the single modern view that does the same work.

Share cards are regenerated at build time from the site content. Showing 231 of 231.