Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Year End Inventory Close issue

(0) ShareShare
ReportReport
Posted on by 260

Hi All

I am trying to close the 2012 calendar year for inventory however when I read the Inventory year-end closing procedures I saw that no new transactions (ie transactions for 2013) should have been posted for inventory. I know there were some 2013 transactions posted. My dilemma is when I close the 2012 year,  the transactions for 2013 will be zeroed out. How can I fix this so the 2013 transactions will not be zeroed out or if they are, how I can enter the 2013 transactions without duplication of amounts on the GL side.

Any help will be greatly appreciated.

 

Erica

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    65,271 on at
    Re: Year End Inventory Close issue

    Hi Erica,

    You'll not like this answer, but it's the only one I could think of, and it does work. The answer is you need to manually adjust the totals using a 'backend' tool, like SQL. You will need to change at least the IV30101 and IV00102 tables. Running reconcile won't fix it, and it won't break your manual 'adjustments' either.

    Kind regards,

    Leslie

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans