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

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

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

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
Suggested answer

Amit Baru 3,025 on at

Like (0)

Report

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

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;
Suggested answer

Catharsis 65 on at

Like (0)

Report

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

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
Alfredo_Iorio 1,260 on at

Like (0)

Report

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

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
AmberPFC 52 on at

Like (0)

Report

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

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
Suggested answer

Amit Baru 3,025 on at

Like (0)

Report

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

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.