REAL-WORLD PAIN POINTS

I've Debugged Every ERP Problem Listed Below. Here's Exactly How Each One Gets Fixed.

From customer complaints, partner feedback, and 12+ years of hands-on implementations — here are the most common BC and LS Central problems I fix in production, and exactly how each one gets resolved.

🐌

Slow Page Loading

Item Ledger · Value Entries · Posted Documents

!

Pages take 5–30 seconds to load

Root: Too many FlowFields, missing SetLoadFields, heavy OnAfterGetRecord triggers

✓Apply SetLoadFields + remove unused FlowFields + move logic to Codeunit

!

Large lists crash or timeout

Root: Bad query structure, missing SQL indexes, no pagination

✓Replace FindSet loops with Query objects + add targeted SQL indexes

!

Posting routines are very slow

Root: Too many event subscribers, heavy custom logic in posting path, no background sessions

✓Move heavy logic to background sessions + consolidate event subscribers

🔄

Background Session & Job Queue Failures

Scheduled Jobs · Background Processing · Long-Running Tasks

!

Job Queue entries stuck or failing

Root: Session timeouts, missing error handling, deadlocks

✓Add TryFunction + retry logic + proper error logging tables

!

Background sessions deadlock

Root: Competing locks on same tables, no transaction isolation

✓Split long transactions + use SetAutoCalcFields(false) in background context

!

Cost adjustment runs forever

Root: Too many unadjusted entries, missing item ledger indexes

✓Schedule frequent cost adjustment jobs + optimize Item Ledger Entry table

📊

Reporting & Power BI Problems

Account Schedules · Analysis Views · Power BI

!

Account Schedules are not enough

Root: Standard BC reporting too limited for complex financial structures

✓Build custom Power BI semantic model connected to BC APIs + Dataflows

!

Power BI reports show wrong data

Root: Wrong dimension mapping, missing filters, stale ETL

✓Rebuild data model with correct BC API connections + scheduled refresh

!

No consolidated multi-company reporting

Root: Each company separate, no unified data layer

✓Build Azure Synapse or Dataflows consolidation layer for multi-company Power BI

🔧

Extension & Upgrade Problems

AL Extensions · BC Upgrades · Breaking Changes

!

Extensions break after BC upgrade

Root: Deprecated events, hardcoded values, modified base objects

✓Rewrite extensions using event subscribers + remove all hardcoding + sandbox upgrade test

!

Custom code conflicts with Microsoft updates

Root: No clean architecture, business logic in pages/triggers

✓Refactor to layered AL architecture — logic only in Codeunits, no page triggers

👥

Duplicate Master Data

Customers · Vendors · Items

!

Same customer/vendor created multiple times

Root: No duplicate detection rules, no mandatory field validation, no approval workflow

✓Implement duplicate detection + mandatory fields + creation approval workflow

!

Wrong posting groups on customers/vendors

Root: No templates, no validation rules, wrong setup during migration

✓Lock posting groups + use creation templates + validate via data cleanup script

💰

Finance & VAT Problems

VAT Setup · Bank Reconciliation · Currency

!

VAT posting setup is confusing and wrong

Root: Missing VAT posting group combinations, wrong business/product groups assigned

✓Rebuild VAT posting setup with proper matrix + test in sandbox with real transactions

!

Bank reconciliation never balances

Root: Manual bank statements, wrong payment matching, missing entries

✓Enable automatic bank feed import + matching rules + Power BI reconciliation dashboard

!

Wrong currency rounding differences

Root: Currency rounding rules not configured, wrong payment tolerance

✓Set correct currency rounding precision + configure payment tolerance rules

📐

Dimension & Posting Group Errors

Dimensions · Posting Groups · Number Series

!

Wrong dimensions posted — reports useless

Root: No mandatory dimensions, no default dimensions, wrong dimension combinations

✓Set mandatory dimensions + default dimensions + validate combination rules

!

Posting groups wrong — accounts incorrect

Root: Migration mapped wrong accounts, no validation, no approval on changes

✓Full posting group audit + lock changes + require approval for any modifications

📦

Inventory Costing Problems

Cost Adjustment · Stock Mismatch · Item Tracking

!

Cost adjustment takes hours / never finishes

Root: Too many unadjusted entries, wrong costing method, missing indexes

✓Schedule daily adjustment job + optimize Item Ledger + consider switching costing method

!

Stock counts don't match ERP

Root: No warehouse documents, no bin management, manual adjustments without approval

✓Enable warehouse documents + cycle counting + approval workflow for all adjustments

🔗

API & Integration Failures

REST API · OData · Rate Limits

!

API hits 5,000 record limit — sync breaks

Root: No pagination in integration, full-sync instead of delta-sync

✓Implement OData $skiptoken pagination + delta sync using modifiedSince filter

!

Missing fields in standard BC APIs

Root: Standard API pages don't expose all fields needed by integration

✓Build custom API Extension page exposing all required fields

!

Duplicate data created by integration

Root: No idempotency key, no GUID-based deduplication

✓Use GUID as primary key + idempotent POST logic + duplicate check codeunit

⚡

Workflow & Approval Problems

Approval Workflows · Notifications · Routing

!

Approvals stop working after update

Root: Workflow conditions hardcoded, approver substitutes not set, notification failures

✓Rebuild workflows with correct conditions + set substitutes + test email notifications

!

Wrong person gets the approval request

Root: Wrong approval chain, missing user setup, wrong amount limits

✓Audit approval user setup + rebuild chain + test with all scenarios before go-live

🔌

Payment Gateway Integration Issues

Stripe · PayTabs · PayFort · Telr

!

Payments not posting to BC automatically

Root: No auto-posting logic, manual reconciliation only, wrong GL mapping

✓Build auto-posting codeunit with correct GL account mapping + bank reconciliation

!

Duplicate payments in ERP

Root: No idempotency, webhook retries creating multiple postings

✓Add webhook idempotency table + check transaction ID before posting

🛍️

E-commerce Sync Problems

Shopify · WooCommerce · Inventory · Orders

!

Wrong stock shown on website

Root: Inventory not syncing in real-time, wrong item mapping, no committed stock calculation

✓Build real-time inventory webhook + available-to-promise calculation logic

!

Orders not flowing from webshop to BC

Root: API authentication expired, wrong customer mapping, error not surfaced

✓Rebuild order sync with proper error logging + auto-alert on failure + customer matching logic

🐌

Slow POS / POS Freezes

POS Performance · Item Lookup · Transaction Speed

!

POS takes 5+ seconds per transaction

Root: Too many active promotions, large item master, heavy POS UI, no local caching

✓Enable POS caching + reduce promotions + clean item master + simplify POS UI layout

!

Item lookup is very slow

Root: Too many variants, no item categories, missing fast lookup configuration

✓Set up item categories + enable fast lookup + reduce variant complexity

!

POS freezes during promotions

Root: Complex mix & match rules, too many active promotions, wrong promotion priority

✓Audit and reduce active promotions + fix priority rules + test each promotion

🔒

Staff Permission Problems

Unauthorized Discounts · Wrong Access · Voids

!

Cashiers giving unauthorized discounts

Root: Wrong POS permission profile, no discount restriction, no manager override rule

✓Rebuild POS permission profiles + restrict discount function + require manager PIN

!

Staff assigned to wrong store

Root: Wrong store assignment in staff card, wrong permission group mapping

✓Audit all staff cards + fix store assignment + validate permission groups per role

!

Voids and returns not properly controlled

Root: Void/return function not restricted, no manager approval required

✓Set secure void rules + require manager override for returns above threshold

🖨️

Hardware Problems

Printers · Cash Drawers · Scanners · Terminals

!

Receipt printer not printing

Root: Wrong driver, wrong hardware profile, hardware station service stopped

✓Reinstall hardware station + verify drivers + correct hardware profile mapping

!

Payment terminal disconnects mid-transaction

Root: Network instability, wrong EFT connector config, timeout too short

✓Fix network stability + increase EFT timeout + configure offline fallback mode

🍽️

KDS & Hospitality Problems

Kitchen Display · Menu Sync · Order Routing

!

KDS not receiving orders

Root: Wrong kitchen routing setup, network issue, wrong POS connection

✓Fix kitchen routing config + validate POS→KDS connection + test with live order

!

Menu items missing from POS after update

Root: Replication not completed, wrong store mapping, item not in correct menu group

✓Force replication + validate menu group mapping + check item store assignment

🔄

Replication Delays & Failures

LS Data Director · Scheduler Jobs · Store Sync

!

Price changes don't reach POS for hours

Root: Scheduler job overloaded, wrong replication counter, failed job not retried

✓Split replication jobs + fix counters + add real-time price push for critical changes

!

New items don't appear in store POS

Root: Item not assigned to store/store group, replication counter not initialized

✓Fix store group assignment + reset replication counter + force full master data sync

!

Duplicate transactions appear in HQ

Root: Transaction uploaded multiple times, no idempotency check, network interruption during upload

✓Add transaction ID uniqueness check + implement idempotent upload logic

🏪

Wrong Store Setup

Store Card · POS Profiles · Permissions

!

Store-specific settings not applied at POS

Root: Wrong store-POS terminal mapping, settings not replicated, profile wrong

✓Audit store card setup + re-map POS terminals + force settings replication

!

Store inventory doesn't match HQ

Root: Transfer documents not posted, wrong store stock rules, replication missed

✓Reconcile store stock via stock count + fix transfer posting + rebuild replication for inventory

☁️

Cloud / Hybrid Sync Problems

Cloud BC · On-prem POS · Hybrid Architecture

!

POS goes offline when internet drops

Root: No offline mode configured, POS relying on real-time cloud calls

✓Enable offline POS mode + configure local cache + set sync schedule on reconnect

!

Version mismatch between cloud BC and on-prem LS

Root: BC updated to new version while LS Central not upgraded yet

✓Plan synchronized upgrades + test LS Central compatibility before BC update

📊

Loyalty Sync Problems

Points · Tiers · Rewards · Real-time Sync

!

Customer points not updating at POS

Root: Loyalty sync job delayed, earn rule misconfigured, replication gap

✓Enable real-time loyalty sync via API + fix earn rules + add sync monitoring alert

!

Tier not upgrading even after qualification

Root: Tier calculation job not scheduled, wrong threshold, missing tier rule

✓Schedule tier calculation job + validate thresholds + test full loyalty cycle

Experiencing one of these issues? — Book a free 45-minute diagnostic call. We'll identify the root cause and give you a clear action plan.

⚡ Book a Diagnostic Call → View Troubleshooting Guides →

TROUBLESHOOTING ARCHITECTURE

Our Diagnostic Process — Step by Step

We follow structured diagnostic flowcharts for every ERP issue — no guessing, no random fixes. Identify → Root Cause → Fix → Validate → Document.

🐌

BC Page Performance Diagnostic

Business Central · Slow Pages · Load Optimization

🔴 Issue: Business Central page is slow

User reports 5–30 second load time

Check: SetLoadFields applied?

✗ No → Add SetLoadFields to all queries

Check: FlowFields optimized?

✗ No → Remove/cache unnecessary FlowFields

Check: OnAfterGetRecord clean?

✗ No → Move logic to Codeunit

Check: Queries used instead of loops?

✗ No → Replace FindSet with Query objects

✅ Page Performance Optimized — Measure with Telemetry

⚡

LS Central POS Speed Diagnostic

LS Central · POS Freeze · Slow Transactions

🔴 Issue: POS is slow or freezes

Transactions taking 5+ seconds

Check: POS item cache loaded?

✗ No → Enable POS local caching

Check: Promotions count manageable?

✗ No → Reduce/optimize active promotions

Check: Replication up to date?

✗ No → Fix replication jobs + counters

Check: POS UI layout simplified?

✗ No → Reduce buttons, simplify layout

✅ POS Speed Restored — Target < 0.5s per transaction

🔄

LS Replication Troubleshooting

LS Data Director · Scheduler Jobs · Store Sync

🔴 Issue: Data not reaching store POS

Prices/items/promotions not updating

Check scheduler logs for failed jobs

✓ Jobs failed → Fix job + restart + monitor

Check: Store mapping correct?

✗ No → Fix store-to-terminal mapping

Check: Replication counters initialized?

✗ No → Reset + reinitialize counters

Trigger manual replication + validate

✅ Replication Healthy — Set up monitoring alerts

🔗

BC API Optimization Diagnostic

REST API · OData · Rate Limits · Integration

🔴 Issue: API slow or hitting limits

Integration failing or returning incomplete data

Check: Too many fields in API page?

✓ Yes → Create lightweight API extension page

Check: Heavy triggers on OnInsert/Modify?

✓ Yes → Move logic to background Codeunit

Check: Pagination implemented?

✗ No → Add OData $skiptoken pagination

Check: Delta sync instead of full sync?

✗ No → Add modifiedSince filter

✅ API Optimized — Monitor with Application Insights

Facing any of these issues? We diagnose, fix, and document — usually within 48 hours.

⚡ Get a Free ERP Diagnosis

OUR PROCESS

How We Work Together

No surprises. No disappearing consultants. Here is exactly what happens from first contact to go-live.

01

📞

Discovery Call Free · 30 min

We understand your current system, pain points, and goals. No sales pressure. You leave with clarity on what needs fixing — regardless of whether we work together.

Remote or On-siteNo commitment

02

📋

Proposal & Scope

You receive a clear written proposal with timeline, deliverables, and pricing — fixed price or day-rate options. No hidden costs, no vague estimates.

Fixed priceClear deliverables

03

⚙️

Implementation

We work in structured sprints with weekly progress updates. You always know where we are, what was done, and what is next. No black boxes.

Weekly updatesStructured sprints

04

🎓

Handover & Support

Full documentation, team training, and ongoing support options. We are not done until your team is confident and the system is stable in production.

Full docsTeam trainingPost-go-live support

⚡ Start With a Free Discovery Call

FREQUENTLY ASKED

Common Questions

Straight answers to what most clients ask before getting started.

How long does an ERP implementation take?

+

Typically 4–12 weeks depending on scope, complexity, and customizations required. We provide a clear project plan before we begin so you always know the timeline.

Do you support existing ERP systems that aren't working?

+

Yes — troubleshooting, optimization, and upgrades are our specialty. We diagnose first, then fix. No unnecessary rebuilds unless it's truly needed.

Can you customize Business Central with AL extensions?

+

Absolutely. We develop clean, upgrade-safe AL extensions for Business Central — following Microsoft best practices to ensure your customizations survive future upgrades.

Do you offer training after implementation?

+

Yes — both onsite and remote training. We train your team on the specific workflows and features relevant to their roles, ensuring adoption and confidence.

How do you ensure zero downtime during upgrades?

+

We use a staged upgrade approach — development, testing, user acceptance, and production — with a full rollback plan at every stage. Your business keeps running throughout.

Do you fix staff permission issues in LS Central?

+

Yes. We completely rebuild your staff role and permission hierarchy in LS Central — preventing unauthorized discounts, access violations, and audit issues.

Which payment gateways can you integrate?

+

We integrate Stripe, PayTabs, PayFort, Checkout.com, Telr, and any gateway with a REST API or SDK. All integrated cleanly into Business Central or LS Central.

Do you work with small businesses or only enterprise?

+

Both. Business Central is ideal for SMBs, and LS Central scales from single-store to 50+ branch operations. We tailor scope and cost to your business size.

Have another question? Get in touch →

FROM THE PORTFOLIO

Browse all projects →