Dynamics GP - Cash Receipts - Another user is editing this document

RM00401 has the transaction status record.

Delete this record to free up the document.

delete from RM00401 where docnumbr = 'mydocnum'

Dynamics GP - How to fix average cost

Problem:
Average cost is all wrong because of data entry errors.


Solution:

If you want to reset the costing for all of your inventory, the simplest method is to remove all of your stock, adjust the iv10200 table to set the qtyonhnd to 0 for the last record, then adjust everything back in at the proper cost.
http://support.microsoft.com/kb/2706556

If you kno wthe exact problem, or the exact cost layer that's causing the bad average calculation, just modify the cost layer by going to

Tools>Utilities>Inventory>Adjust Costs

This will adjust the specific cost layer, and post the differences to the GL.
If the price still does not look correct, run an inventory reconcile on the item to have it recalculate the average cost.

Dynamics GP - this document number already exists you must provide a new document number

If you have "Delete documents" unticked for a specific sales order type, GP will automatically create a record for each SOP transaction in the SOP30200 and SOP30300 tables from the moment you enter any transaction for that document type, even if you don't post it.

To resolve this, tick the "Delete documents" for the sales order type, and delete the records in the sop30200 and sop30300 tables that should not be there.

Dynamics GP eOne SmartConnect - Could not log on to SQL server

If you get any errors pertaining to logging on or connecting to SQL, chances are the default Smartconnect user is not setup correctly.

• Install dot net 4.5
• Turn off all firewalls
• Log in to SQL server
• Delete the Smartconnect user (Or confirm the password by logging into SQL with the smartconnect account)
• Reinstall Smartconnect
• Log into GP
• Include Code
• GP>Smartconnect>Build cache
• Launch Smartconnect

Dynamics GP - In-Transit Transfer Tables and Views

https://www.gptablereference.com/2010/Group/Field%20Service


SVC00700 - In-Transit Transfer Header Work
SVC00701 - In-Transit Transfer Line Work

IV30300 - Item transaction detail
SVC30700 - In-Transit Transfer History Hdr
SVC30701 - In-Transit Transfer History Dtl



/****** Object:  View [dbo].[BI_ITTRHist]    Script Date: 03/29/2017 11:16:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[BI_ITTRHist]
AS
SELECT     dbo.SVC30700.ORDDOCID, dbo.SVC30700.RFRNCDOC, dbo.SVC30700.LOCNCODE, dbo.SVC30700.TRNSFLOC, dbo.IV00101.ITEMNMBR, dbo.IV00101.ITEMDESC,
                      dbo.SVC30701.UOFM, dbo.SVC30701.TRNSFQTY, dbo.SVC30701.QTYFULFI, dbo.SVC30701.QTYSHPPD, dbo.SVC30701.QTY_To_Receive, dbo.SVC30701.QTYRECVD,
                      dbo.SVC30701.LNITMSEQ, dbo.SVC30701.STATUS, dbo.SVC30701.QTYBSUOM, dbo.SVC30701.TRNSFLOC AS Expr1, dbo.SVC30701.TRNSTLOC,
                      dbo.SVC30701.Reason_Code, dbo.SVC30701.ITLOCN
FROM         dbo.SVC30700 INNER JOIN
                      dbo.SVC30701 ON dbo.SVC30700.ORDDOCID = dbo.SVC30701.ORDDOCID INNER JOIN
                      dbo.IV00101 ON dbo.SVC30701.ITEMNMBR = dbo.IV00101.ITEMNMBR

GO

Dynamics GP - Unable to open customizations dictionary

Problem:
This is happening because someone has Dynamics GP open on their machine.

Solution:
Make sure no one is actually using the system, or doing work before kicking them out, or just killing GP.
Any one of the following will work

1. Ask all users to log out and CLOSE GP
2. Disable the network connection to kill all connections to the file, then re-enable it
3. If you're on a terminal server, open the task manager, show processes from all users and kill all instances of dynamics*32.exe

Dynamics GP - Smartlist Builder - You do not have security privileges to view all of the tables used in this SmartList

Problem:
Users get the error
"You do not have security privileges to view all of the tables used in this SmartList"
Even though you have set the SQL table security, and the Smartlist security correctly


Solution:
You will need to add permissions to the View SmartLists with SQL Tables operation. Here are the settings under Security Tasks:

Product: SmartList Builder
Type: SmartList Builder Permissions
Series: SmartList Builder Permissions or SmartList Builder (depends on the Service Pack)
Operations: View SmartLists with SQL Tables

Original Post
http://victoriayudin.com/2008/10/08/granting-access-to-a-new-smartlist-in-gp-10/