Item Reconcile Error

• 11-13-2008 3:39 PM

  pwr1 Joined on 11-13-2008 Posts 2	Item Reconcile Error Reply Contact 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
  	Tags: Inventory, Dynamics GP 10, SQL 2005

• 11-18-2008 10:19 PM

  In reply to

  ChristinaGeyerPhillips Joined on 04-01-2008 Denver and Kansas City Posts 70	Re: Item Reconcile Error Reply Contact 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 Check out my new blog, http://dynamicsgpland.blogspot.com/
  	Tags: Dynamics GP, Inventory, reconcile

• 11-19-2008 11:17 AM

  In reply to

  Paula Jones Joined on 11-19-2008 Posts 1

  Re: Item Reconcile Error Reply Contact 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

• 11-21-2008 6:13 AM

  In reply to

  stewartf Joined on 09-18-2008 Posts 1

  Re: Item Reconcile Error Reply Contact 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.

• 11-21-2008 7:15 AM

  In reply to

  pwr1 Joined on 11-13-2008 Posts 2	Re: Re: Item Reconcile Error Reply Contact 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!