web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Deleting Item records with ledger entries

(0) ShareShare
ReportReport
Posted on by 37

I have an issue with a new client config of BC.

They've set up the My Company trial and they'd like to continue using it as we loaded some of their data already, however inadvertently during the trial someone loaded current inventory.

That means that a large number of Items already have ledger entries, and can't be deleted and reloaded easily. there are numerous changes required to the data, including costs, costing methods etc - which can't be changed with open ledger entries in the current period. As we've already tried to re-load items from a config package, it has left the items with issues, blanked fields like UoM, costing method etc - and they can't be updated because of the ledger entries. Of course, I can't delete ledger entries, and I can't adjust the inventory because uom etc are missing from the records.

I'm thinking that the fastest way to resolve this issue would be to export the current configuration as a package, create a new company, and then reload the data (replacing the Item data with the correct info, of course)

Can anyone please confirm if this is the appropriate approach, or if there is an easier way to complete that?

Cheers,

Hamish

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    Yes. What you describe is the appropriate and best practice approach to this,

    Technically you could delete all transnational data and move on from there but it is not recommended because you can so easily get inconsistencies.

    I

  • Hamish Duff Profile Picture
    37 on at

    Thanks for verifying that NorthW :)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,468

#2
YUN ZHU Profile Picture

YUN ZHU 923 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans