Small and medium business | Business Central, N...

How to change an item dimension after a sales invoice has been posted and paid (so closed)

(0) Share

Report

Posted on by AmberPFC

We need to change an item dimension in some posted sales invoices that are already paid also, so basically in the system they are closed.

However, since we pay royalty on some of our sold items, we need to code each item ordered via dimension with a correct designer code (this is how we called the dimension).

For several invoices we have done this incorrectly (when we just started with BC). So these invoices keep on showing up as posted items where were need to pay royalty over, when in fact we should not.

So the only way to change this, is to remove/change the dimension value. But how do I do that after the invoice had been closed????

Can someone help me?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

Hi,

For this Call create dimension value function and set the Dimension Set Id in Posted Sales invoice table.

Regards

Amit Sharma

www.erpconsultors.com

linkedin.com/in/amit-sharma-94542440/

Press Yes if info is useful.

Was this reply helpful? Yes No
AmberPFC 52 on at

Like (0)

Report

Hi Amit, thank you. Can you explain that a little bit more if you have time? We are still searching our way around in BC and I am not sure what you mean.

Thanks, Amber

Was this reply helpful? Yes No
Alfredo_Iorio 1,264 on at

Like (0)

Report

You can correct the dimensions in the GL.

Search Dimension Corrections in BC, find the entries with incorrect dimensions and change the value.

More info here Troubleshooting and Correcting Dimensions - Business Central | Microsoft Docs

Was this reply helpful? Yes No
Suggested answer

Catharsis 65 on at

Like (0)

Report

We use App for that. There are multiple of those available in MS Application store.

For example these

appsource.microsoft.com/.../PUBID.origo|AID.ori_dimension_correction|PAPPID.dbcc68bb-b621-4ef1-b789-48e7532a9fe2

and

appsource.microsoft.com/.../PUBID.bcsitera|AID.dimension-correction-tool|PAPPID.c2b4ea2a-b001-4285-9d5f-097e9ee2fc2a

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

Hi,

Refer the below code. Pls change code as per the requirement. But this is tested code for getting "Dimension Set Id"

DimensionManagement.GetDimensionSet(TempDimSetEntry,InsertGenJournalLine."Dimension Set ID");

  TempDimSetEntry.INIT;

  TempDimSetEntry.VALIDATE("Dimension Code",GLSetup."Shortcut Dimension 3 Code");

  TempDimSetEntry.VALIDATE("Dimension Value Code",TypeOfExpense);

  TempDimSetEntry.INSERT(TRUE);

  NewDimSetID := DimensionManagement.GetDimensionSetID(TempDimSetEntry);

  IF NewDimSetID <> 0 THEN BEGIN

    InsertGenJournalLine."Dimension Set ID" := NewDimSetID;

  END;

  InsertGenJournalLine.MODIFY;

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, I recommend using General Journal or Sales Journal to adjust the amount of the dimension, rather than directly modifying the dimension of Posted Sales Invoice, which is very risky.

And, You can customize a tool by referring to the standard functions below.

New Features for Dynamics 365 Business Central 2021 release wave 1 (BC18): Dimension corrections (for G/L Entries)

https://yzhums.com/10655/

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No