Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Automatic Cost Adjustm...
Microsoft Dynamics GP (Archived)

Automatic Cost Adjustments appear in GL but dont Post

(0) ShareShare
ReportReport
Posted on by Bill Campbell 22,647

I get that inventory cost adjustments have to happen and that they have to post to GL to keep the system in sync.

However, what I don't get, is why the batch does not post once it gets to the GL.

The batch stops at the GL, Series Post - Marked - and with a Batch Status of 3 (Receiving) and so the users can not even look at the batch to see what is wrong.

At last count there were over 680 such batches.

Client wants them gone - I am tempted to DELETE them, but the accountant in me says NO.

Someone got any suggestions?

*This post is locked for comments

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Automatic Cost Adjustments appear in GL but dont Post

    Quick summary to the problem.

    We printed and reviewed all the transactions that the system wanted to post.

    None were considered material - all were less than 100.00 and all of the transactions included only a single line - one inventory item per batch.

    Geoff is correct, if we were using the HITB for inventory reconcile I would want to continue to post.  However, the client, accountant and external review all agree that for the amount of work, correcting the dates, we did not need the head ache, so it was agreed that we would 'delete the batches'

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automatic Cost Adjustments appear in GL but dont Post

    Hi Bill,

    These Cost adjustments will most likely have old dates, as when, the cost adjust occurs it goes back through the whole table. I have seen that they have old tax dates as well. You would need to either use SY00500 and change BCHSSTIUS to 0 as suggested, and then edit each batch date, if you want to post them. The Accountant in you is correct, you should post them, but beware what effect it will have on your current month. Some of my clients have deleted them, as they do not want to have any changes on the current year, but they also do not use HITB to reconcile Inventory to GL. Hope this helps a little.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Automatic Cost Adjustments appear in GL but dont Post

    Thanks for the reminder - when I ran the Batch Recovery, no change.  The BCHSTTUS was still showing as Receiving.  

    Nothing I do outside of SQL seems to matter.

    From in SQL I also made the change, Unmark and Batch Status to 0

    Printed all the documents - what  a waste of paper

    Had the finance staff review and comment - and they all agreed for the dollar involved they would have me delete them.  Some of these go back over a fiscal year and back over 2 inventory cycle counts - and it is believed by all that the money was accounted for and this is not needed.

    So our solution was to delete the batches and we did that in SQL.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automatic Cost Adjustments appear in GL but dont Post

    Just adding my own experiences to this.

    I have had same issues of batches getting stuck in GL with "marked" and "receiving". Unfortunately, in my case Batch Recovery did not help. "Receiving" status would simply won't go away.

    I have to run a SQL update query that updates BCHSTTUS (Batch Status) to 0 and MKDTOPST (Marked To Post) to 0.

    And in my case, the issue is not just with only cost adjustment batches. It happens with even an SOP batch (SLSTE) and at times Payables Apply (PMAPY).

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Automatic Cost Adjustments appear in GL but dont Post

    Hi Bill,

    I would first attempt Batch Recovery (Tools - Routines - Batch Recovery).  Hopefully after this the batch will be available, and then you can pull up the batch in GL and get an edit list.  The edit list will hopefully highlight the issue.  If no errors appear on the edit list you can try to post the batch.

    If Batch Recovery doesn't allow you to access the batch/transaction, I'd manually make some updates on the SY00500 so that you can pull up the batch/trx in GP, and again try to print the edit list, or Transaction Level Post the journal.

    Thank you,
    Justin

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans