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?
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)
Hope this helps as well.
Thanks.
ZHU
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;
We use App for that. There are multiple of those available in MS Application store.
For example these
and
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
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
Hi,
For this Call create dimension value function and set the Dimension Set Id in Posted Sales invoice table.
Regards
Amit Sharma
linkedin.com/in/amit-sharma-94542440/
Press Yes if info is useful.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148