Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

help - need advice or input about adjust inventory account

(0) ShareShare
ReportReport
Posted on by 3,205

Hi there,

Help please.

I need to adjust Inventory Balance.

we realized this problem too late. the problem came when moving data to another database. this policy (moving data) happen because changing of internal company's policy. they want to split of something.

anyway, here the case:

when we move the data, we didn't notice from old database. there were batches from IV transfer that have status "in transit".

those batches related to another batch on IV issue (batch is auto generated by OM module while made sales order). since the batch of IV transfer still on status "in transit", batch of IV issue not released (and  worse, status is S).

I have found the records from batch of IV issue which not release.

those all affected beginning balance for new database.

now there are new transactions on new database. How to adjust the inventory balance so the balance can be matched between old database and new database, ending balance of old database match with beginning balance of new database?

thanks in advance

*This post is locked for comments

  • rodi Profile Picture
    3,205 on at
    RE: help - need advice or input about adjust inventory account

    hello there..any help please?

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans