|

Direct Posting in Business Central: The Tiny Setting That Prevents Massive Accounting Headaches

There are certain ERP mistakes that happen once, get corrected, and everyone moves on. Then there are the mistakes that come back every few months like a horror movie sequel nobody asked for. One of those?

Posting directly to General Ledger accounts that are supposed to be controlled by subledgers. And recently, I talked to two different companies live on Microsoft Dynamics 365 Business Central where nobody had properly explained this concept during implementation. They were told:

“Don’t post directly to Accounts Receivable, Accounts Payable, or Inventory accounts.”

But nobody explained why. And more importantly… nobody explained that Business Central has had a built-in safeguard for this for years. A simple setting called Direct Posting. Tiny checkbox. Massive impact.

First, Let’s Talk About What a Subledger Actually Is

In accounting systems, subledgers are detailed transaction records that roll up into the General Ledger.

Examples:

  • Customer transactions roll into Accounts Receivable
  • Vendor transactions roll into Accounts Payable
  • Item transactions roll into Inventory
  • Fixed asset transactions roll into Fixed Assets

So if your customer ledger says customers owe you $245,000……the Accounts Receivable G/L account should also say $245,000. Easy peasy.

That balance should stay synchronized automatically as long as transactions are managed correctly through the proper processes. That’s the whole point of an ERP system.

Where Things Go Sideways

Problems start when someone bypasses the subledger entirely and posts directly to the G/L account using a journal entry.

For example:

  • Posting an inventory adjustment directly to Inventory G/L
  • Posting an A/R adjustment directly to Accounts Receivable
  • Posting an A/P adjustment directly to Accounts Payable

Now the General Ledger changed……but the subledger didn’t.

And suddenly:

  • Inventory valuation reports don’t tie
  • Customer balances don’t match the G/L
  • Vendor aging is off
  • Reconciliation becomes a nightmare
  • Month-end turns into detective work

And here’s the really dangerous part:

Once you’re out of balance, the only way to fix it is usually……another direct G/L entry. Which means the cycle continues.

Business Central Already Has a Fix for This

This is the part that always surprises people and frankly it’s disappointing. Microsoft Dynamics NAV and Business Central have had a built-in protection mechanism for years.

On the General Ledger Account card, there’s a field called:

Direct Posting

If Direct Posting = No, users cannot post directly to that account through a journal entry.

Business Central throws an error. Which is exactly what should happen. Because the system is basically saying:

“Hey… this account is controlled by a subledger. Go use the proper transaction process.”

That means:

  • Customer adjustments should go through customer entries
  • Vendor adjustments should go through vendor entries
  • Inventory adjustments should go through item journals
  • Fixed asset transactions should go through fixed asset journals

The system protects itself. Or at least… it tries to.

The Accountant Who Thought the System Was Broken

Years ago, I worked with an accountant who absolutely refused to believe this mattered. Every time inventory looked wrong, she would “fix” it by posting directly to the Inventory G/L account. Every. Single. Time. Then a few months later we’d get the call:

“The system is broken. Inventory doesn’t tie to the General Ledger.”

Nope. The system was actually working perfectly. The problem was that the subledger and G/L had been manually forced apart. We explained Direct Posting. We helped her make the proper adjustments. We turned it off on the Inventory accounts. Problem solved.

Until……somehow……it happened again. And again. Finally, we checked the Change Log.

Sure enough: Someone kept turning Direct Posting back on. And yes… it was the same accountant. At that point the conversation changed from:

“Why is the system broken?”

to:

“Why are we bypassing the controls?”

That’s an important distinction. I may have threatened to invent a keyboard that would shock her if she did it again. Just saying.

This Isn’t Just a Technical Setting — It’s an Accounting Control

That’s the bigger lesson here. Direct Posting isn’t some obscure ERP configuration detail.

It’s part of your financial control structure. Because once people get comfortable bypassing subledgers:

  • Reporting becomes unreliable
  • Reconciliations take longer
  • Audits get messier
  • Trust in the ERP system drops
  • Finance teams start exporting everything to spreadsheets

And then the dangerous phrase starts showing up:

“We don’t trust the numbers in the system.”

That’s rarely caused by Business Central itself. It’s usually caused by process breakdowns and weak controls.

Best Practices for Managing Direct Posting in Business Central

Here’s the practical recommendation I give clients:

Turn Direct Posting Off For:

  • Accounts Receivable control accounts
  • Accounts Payable control accounts
  • Inventory accounts
  • Inventory interim accounts
  • Fixed asset accounts
  • Bank accounts

Leave It On For:

  • Expense accounts
  • Revenue accounts
  • Accrual accounts
  • Adjustment accounts
  • Typical operational journal entry accounts

Monthly Reconciliation Should Be Simple

When Direct Posting is managed correctly, monthly reconciliation becomes incredibly straightforward.

You simply verify:

  • Customer ledger ties to A/R
  • Vendor ledger ties to A/P
  • Inventory valuation ties to Inventory G/L
  • Fixed asset ledger ties to Fixed Asset G/L

Done. No mystery journal entries. No archaeology project. No “the ERP is broken” panic calls.

The Bigger ERP Lesson

One of the most common implementation failures I see isn’t bad software. It’s failing to explain why controls exist. If users only hear:

“Don’t do that.”

without understanding the accounting logic behind it…they’ll eventually bypass the process.

Usually during a stressful month-end. Usually because they’re trying to “help.” And usually creating a much bigger mess in the process.

Business Central gives companies excellent tools for protecting financial integrity.

But those controls only work when teams understand both:

  • the process
  • and the reason behind it

Otherwise somebody eventually turns Direct Posting back on……and six months later everyone’s on a Teams call trying to figure out why inventory doesn’t reconcile again.

Subscribe to be notified when I post next. I’ve got one coming up on the easiest way to assure your Inventory accounts are easy to reconcile at month end.


Discover more from Dynamics Power Play

Subscribe to get the latest posts sent to your email.

Similar Posts

Leave a Reply