Skip to main content

Notifications

Business Central forum
Suggested answer

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

Posted on by 52

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?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,510 Super User 2024 Season 2 on at
    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 Profile Picture
    Amit Baru 3,025 on at
    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 Profile Picture
    Catharsis 65 on at
    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 Profile Picture
    Alfredo_Iorio 1,260 on at
    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 Profile Picture
    AmberPFC 52 on at
    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 Profile Picture
    Amit Baru 3,025 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans