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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Reconcile Issue
Microsoft Dynamics GP (Archived)

Inventory Reconcile Issue

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,852 Moderator

Every time I run IV reconcile(GP  10)  I get the same items on the report. It says it is making the same adjustments. When I look at the IV10200 records in SQL the values to which it says it is adjusting have already been adjusted. For example, I jsut ran IV Reconcile on part XYZ 6 times. All six times it says it is adjusitng the quantity sold on the purchase receipt record from 240 to 180. When I look at that record, the qtysold column is already 180. It appears we have a bug here. Has anyone else seen this and is there a fix, besides upgrading to GP 2010?

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Richard,

    What happens if you run the reconcile using the PSTL utility. Also, and this is a reach, are you running mulibin inventory and are you using the average costing method?

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    They are not licensed for PSTL. I am going to try to look at the relationship between the IV10200 and the IV10201 tables. If I could find from where the 240 is coming it may give me a clue. They use FIFO perpetual for the costing method.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    I think I finally found something. Using part C3412-0000-LGE as an example since this was one of the parts that had the problem, I ran scripts against the IV10200 and IV10201 tables. These are the purchase receipt header and detail table. The header records holds the data when the goods come into stock and the IV10201 table holds the data when it goes out. The detail record has a column that references the receiving receipt number so you can always match up what came in versus what went out. When  I finally zeroed in the IV10201 table for this part there was this ‘extra’ record at the bottom for qty 60 which was the exact number the reconcile report kept trying to change. It would say adjusting qty sold on receipt record from 240 to 180. I also noticed the transaction type was not the usual POP receipt but an adjustment entry. Using this information I then went into GP and did an Item Transaction inquiry and low and behold I come across this transaction.  There are 60 items taken out of stock and then put immediately back in on the same transaction. I think what they were trying to do was change the cost of the goods in stock. I then went into SQL and just deleted this record from the IV10201 table and ran reconcile and now this reconcile record no longer appears. So it appears that by trying to adjust the cost this way by doing a negative and positive inventory adjustment was the cause because what GP did was go back to the very first receipt record for the item and since the net was zero, just added a detail record which in turn messes up the reconcilation report. I will confirm this with a few other but I think we have the cause here.

     

     

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi All,

    Make note of this:

    The PSTL reconcile utility is FREE. All you have to do is install the Technical Service Tools and you have several utilities FREE.

    DO IT DO IT DO IT

    There are many very handy tools that Microsoft is just giving away.

    Item Reconcile is on of the FREE tools.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    The PSTL does not do me any good in this case. I ran it and it reported the same problems with the same items as the GP reconcile reported and made no correction. The problem is this:

    I have about 8 items that keep appearing on the reconciliation report. The same changes are stated each time. What is causing the problem is the fact that someone, way back when, wanted to change the cost of an item in inventory. Instead of just changing the cost on the item card, they did a negative inventory adjustment at the old cost to get the parts out of stock and then on the same transaction put them in at the new cost. So now in the IV10200 table I have the same RCTSEQNM but the PCHSRCTY is 1(INV ADJ) as opposed to 5 (PO Receipt). This apparently confuses the IV reconcile routine. I can manipulate the IV10201 table but sometimes he did this multiple times and the hole keeps getting deeper and deeper. My options are to tell them to just live with these messages on the report and ignore them or I can remove all the records where IV10200.PCHSRCTY =1 and I can see it was clearly just to change the cost.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans