Impact of Blocked Dimension Code on Sales Credit Memo Posting

(7) Share

Report

Posted on by Jainam M. Kothari

15,666 Super User 2026 Season 1

Hello Experts,

While posting a Sales Invoice, the Dimension – Division Code used was "A", which is now blocked in the system.

I am planning to post a Sales Credit Memo using Dimension – Division Code "A+", but the original PSI (Posted Sales Invoice) linked to this Credit Memo was posted with Division Code "A".

Given this mismatch, could you please advise on the implications this may have on costing and reporting within the system?

Looking forward to your guidance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (4)

Verified answer

Teagen Boll 1,013 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

This won't have an actual GL level financial impact. Just an impact to reporting if dimensions are used in Financial Statements or other reports.

What I would do is one of the following:

1. What I recommend is to unblock the dimension value, post the credit memo and then block it again - this then ensures the CM and Invoice align 1:1.

2. Use dimension corrections to correct the GL Entries for the Invoice that was already posted. But this won't update any subledger level data. So if you have reporting for customer subledger data it will be inaccurate.

3. You can use a tool like this - Table Data Editor for Business Central - you can then change the dimension values at will without any validation or other limitations. You could even in theory move all old dimension values A to the new A+ value. This is the easiest and quickest option.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 97,970 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

It's recommended to unblock first, post the credit memo, and then block again.
This is reasonable because you need to cancel the previous invoice.

If you need to know what has been affected, this could affect all reports analyzed by dimension.

Of course, if you only care about General Ledger Entries, you can modify them using the standard method below.

Dimension corrections (for G/L Entries)

https://yzhums.com/10655/

Thanks.

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

OussamaSabbouh 10,875 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hello,

Using a new dimension (“A+”) for the credit memo won’t affect costing but will cause reporting mismatches, since the invoice is under “A.” For accurate reporting, temporarily unblock “A” and post the credit, or later use Dimension Correction on G/L entries.

Regards,

Oussama Sabbouh

2 people found this reply helpful.

Was this reply helpful? Yes No
Jainam M. Kothari 15,666 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Thank you so much Experts.

I got my answer.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Gregory Mavrogeorgis 901 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
hi,

What happens if invoice was “A” and credit is “A+”?

Costs: unaffected.

Reporting: messy. Sales/COGS sit in A for the invoice and A+ for the credit, so division reports look wrong even though company totals net out.

Best fixes (pick one):

Clean reversal (fast + tidy):
Temporarily unblock “A” → Posted Sales Invoice → Cancel/Correct → system posts the credit with “A.” Re-block “A”.

If “A+” replaces “A”:
Use Correct Dimensions to change the posted invoice from A → A+. Then your credit with A+ matches.

Already posted the credit with A+?
Run Correct Dimensions on either the invoice (A→A+) or the credit (A+→A) so they match.

Don’t forget: after changing dimensions, Update Analysis Views so reports refresh.

If you found it helpful please mark it verified

1 people found this reply helpful.

Was this reply helpful? Yes No