Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item Reconcile Error
Microsoft Dynamics GP (Archived)

Item Reconcile Error

(0) ShareShare
ReportReport
Posted on by pwr1 85

We have made some Item Inventory Adjustments and posted them. Now they show an allocation but not where. So we tried to run the item reconcile on them and get a message that we can't complete the process while transactions are being edited. This is our first month end so we aren't sure if we are missing something. Any ideas? Thanks all!

 Phil

*This post is locked for comments

  • pwr1 Profile Picture
    pwr1 85 on at
    Re: Re: Item Reconcile Error

    Thanks stewart. I have been going into SQL and removing any extrainious records in the DYNAMICS ACTIVITY table once everyone exits GP but your way looks easier for my poweruser. Thanks everyone for your help! It is all good info!

  • stewartf Profile Picture
    stewartf 110 on at
    Re: Item Reconcile Error
    I've run into this same problem multiple times and there's a very easy way to see this.  If you go to your Inquiry->Systems window as Admin you will find three options: Batch, Activity Tracking, Process Server.  Go into Batch.  This will show you all currently open batches by user.  Chances are you'll have to go into that batch ID and close/delete it.  Once it's gone you'll be able to do the Inventory reconcile.  It's much simpler than going in through the SQL server.
  • Paula Jones Profile Picture
    Paula Jones 5 on at
    Re: Item Reconcile Error

    Do you guys do any "SQL" stuff?  You could try running this script (replacing the 'xxx' with the item number) to see what pops up.  We have quite a few modules, so you may not need all of these steps.

     

    DECLARE @ITEMNMBR char(20)

    SET @ITEMNMBR = 'xxx'

    PRINT 'This is the allocated quantity in the SOP10200 for Orders'

    select SOPNUMBE,ITEMNMBR,ITEMDESC,ATYALLOC from SOP10200 where ITEMNMBR = @ITEMNMBR and ATYALLOC > 0 and SOPTYPE = 2

    PRINT 'This is the allocated quantity in the SOP10200 for Invoices'

    select SOPNUMBE,ITEMNMBR,ITEMDESC,ATYALLOC from SOP10200 where ITEMNMBR = @ITEMNMBR and ATYALLOC > 0 and SOPTYPE = 3

    PRINT 'This is the allocated quantity in the IV10001 for a decrease Adjustment'

    select IVDOCNBR,ITEMNMBR,TRXQTY from IV10001 where ITEMNMBR = @ITEMNMBR and TRXQTY < 0

    PRINT 'This is the allocated quantity in the IV10001 for Transfers'

    select IVDOCNBR,ITEMNMBR,TRXQTY from IV10001 where ITEMNMBR = @ITEMNMBR and TRXQTY > 0 and IVDOCTYP = 3

    PRINT 'This is the allocated quantity in the IVC10101 for saved Invoices'

    select INVCNMBR,ITEMNMBR,QUANTITY from IVC10101 where ITEMNMBR = @ITEMNMBR and DOCTYPE = 1

    PRINT 'This is the allocated quantity in the BM10300 '

    select TRX_ID,ITEMNMBR,ATYALLOC from BM10300 where Component_ID <> 0 and ITEMNMBR = @ITEMNMBR and ATYALLOC > 0

    PRINT 'This is the allocated quantity in the MOP1400 for this Manufacturing Order'

    select MANUFACTUREORDER_I, ITEMNMBR, ATYALLOC from MOP1400 where ATYALLOC > 0 and ITEMNMBR = @ITEMNMBR

    /* FIELD SERVICE TABLES */

    PRINT 'Allocated Orders in Service Call Management'

    select CALLNBR,ITEMNMBR,ATYALLOC,LOCNCODE from SVC00203 where ITEMNMBR=@ITEMNMBR and ATYALLOC <> 0

    SELECT ITEMNMBR,QTYONHND,ATYALLOC FROM SVC00502 WHERE ITEMNMBR = @ITEMNMBR

    PRINT 'Allocated Service Call Transfers'

    select ORDDOCID,ITEMNMBR,TRNSFQTY from SVC00701 where ITEMNMBR=@ITEMNMBR and TRNSFQTY <> 0

    PRINT 'Allocated Documents in Depot Management'

    select WORKORDNUM,ITEMNMBR,UOFM,QTYORDER,ATYALLOC from svc06101 WHERE ITEMNMBR = @ITEMNMBR

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Item Reconcile Error

    Hi Phil--

     

    Are there other users in the system while you are trying to run reconcile on inventory?  Also make sure you first run reconcile on Sales Documents and Purchasing first (let me know if you need more guidance on those).

     Take care,

    Christina

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans