Skip to content
Advanced Inventory Count app iconAdvanced Inventory CountReconcile and post

Journal Test Report for Microsoft Dynamics 365 Business Central

A large physical inventory journal can stop partway through posting on one bad line. The error gets fixed, posting starts again from the top, and the next error appears thousands of lines later. Advanced Inventory Count adds a journal test report that lists every line that would fail, and why, before anyone posts.

Advanced Inventory Count runs on its own for counts entered in Business Central, and works with Warehouse Insight or WMS Express, Insight Works' mobile warehouse apps, for counting on handheld barcode scanners.

How Journal Test Report works in Advanced Inventory Count

  1. The supervisor copies the finished count to the journals.
  2. The person posting opens the physical inventory journal and runs the item journal test report.
  3. They turn on Only Show Lines With Errors and Show Error Messages.
  4. They fix the lines the report lists, such as unblocking an item or adding a posting group.
  5. With a clean report, they post the journal.

Key capabilities

Checks before posting

The test report checks the journal for problems that stop posting, such as blocked items, missing item tracking, and missing posting groups.

Only the lines with errors

An option limits the report to lines with errors, so a journal of thousands of lines comes down to the few that need fixing.

Error messages

Each problem line shows its error message, so the fix is clear without posting to find out.

Adjustment total

Run in full, the report shows the journal details and the total adjustment the journal will post.

Part of the hand-off

Copy Count to Journals moves the finished count into the standard journals, and the person posting runs the test report first.

See Journal Test Report on screen

Real screens from Advanced Inventory Count, shown with demo data.

Details that matter on the floor

Fix first, post once

Every problem is visible before posting starts, so the journal posts in one pass instead of stopping on the first error and starting again.

Who uses Journal Test Report

Accountants and financial controllers

Check a count journal before posting and fix problems in one pass.

Inventory managers

Hand over a count that is ready to post.

Questions about Journal Test Report

What does the journal test report check?

It checks for problems that stop posting, including blocked items, missing item tracking, and missing posting groups.

Can the report show only the problem lines?

Yes. Turn on Only Show Lines With Errors, and turn on Show Error Messages to see why each line will fail.

When should we run it?

After the count is copied to the journals and before posting.

Advanced Inventory Count app icon

Part of Advanced Inventory Count

Finish inventory and cycle counts sooner in Business Central with barcodes and multi-user entry.

Have a question about Journal Test Report?

Send us a note and the Advanced Inventory Count team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions