Impact of Blocked Dimension Code on Sales Credit Memo Posting

(7) Share

Report

Posted on by Jainam M. Kothari

15,639 Super User 2025 Season 2

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 663 on at

Like (5)

Report

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 95,449 Super User 2025 Season 2 on at

Like (3)

Report

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 5,798 on at

Like (4)

Report

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,639 Super User 2025 Season 2 on at

Like (3)

Report

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 763 on at

Like (4)

Report
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