DynDeveloper.com - Your Dynamics GP Questions, Answered

Archives

The selected company is not configured as a company

The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company.

I was very frustrated to get this message. Here is script to resolve it.

Setting up a Business Alert in Dynamics GP

Setting up a Business Alert is very easy. See the simple steps using the wizard.

DEX.DIC version is not compatible with executable version

DEX.DIC version 14.00.0084 is not compatible with executable version 14.00.0085.00 was an error I encountered on a recent upgrade

The Account Number (ACTNUMST) does not exist in the Account Index Master Table

Sql procedure error codes returned:

Error Number = 679
Stored Procedure= taGLTransactionLineInsert
Error Description = The Account Number (ACTNUMST) does not exist in the Account Index Master Table
Node Identifier Parameters: taGLTransactionLineInsert
BACHNUMB = CONCUR 0303
JRNENTRY = 3874
CRDTAMNT = 0.00000
DEBITAMT = 80.99000
Related Error Code Parameters for Node : taGLTransactionLineInsert
ACTNUMST = 7600-00

This article discusses the error

Setting the Image property of a Winforms button

Just another of one of those cool pieces of code that takes too long to Google.

This snippet of code will succinctly set the image property of a Winforms button.

The image needs to be in the Images folder under the application

Setting up database mail on SQL 2008 R2

This article will show how to set up database mail on SQL 2008 R2

QuantitytoInvoice is auto populating on save

Hi,

I am saving a sales order that was created at a packing station. It is saving fine but i noticed when there is a packed amount that is 0 in the Quantity it automatically sets the QuantitytoInvoice to the Quantity amount even if the QtyFullfi is set. Everything is updating and creating fine. all the information is correct headed into the save. I am wondering if anyone has heard of this?

Thanks

eConnect Receivings ITem Detail Entry

Hi All,

Our client noticed that the screen Receivings ITem Detail Entry is not reflecting the tax amount for the invoice we've created - how can we update this screen within eConnect?

Receivings Item Detail Entry form - not showing Calculated Tax

XML Used to create this:

[code]

<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<POPReceivingsType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateVendorRcd xsi:nil="true" />
<taCreateVendorAddress_Items xsi:nil="true" />
<taPopRcptLotInsert_Items xsi:nil="true" />
<taPopRcptSerialInsert_Items xsi:nil="true" />
<taPopRcptLineInsert_Items>
<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT1219</POPRCTNM>
<ITEMNMBR>Laynards x 30</ITEMNMBR>
<ITEMDESC>Laynards x 30</ITEMDESC>
<VENDORID>ACETRAVE0001</VENDORID>
<RCPTLNNM>1</RCPTLNNM>
<InventoryAccount>000-1100-00</InventoryAccount>
<UOFM>Each</UOFM>
<UNITCOST>43.20</UNITCOST>
<EXTDCOST>43.20</EXTDCOST>
<NONINVEN>1</NONINVEN>
<QTYSHPPD>1</QTYSHPPD>
<QTYINVCD>1</QTYINVCD>
<Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
<Purchase_Item_Tax_Schedu>000-1100-00</Purchase_Item_Tax_Schedu>
<Purchase_Site_Tax_Schedu>ALL DETAILS </Purchase_Site_Tax_Schedu>
<TAXAMNT>8.64</TAXAMNT>
<LOCNCODE>WAREHOUSE</LOCNCODE>
<receiptdate>01/02/2016 00:00:00</receiptdate>
<CURNCYID>Z-US$</CURNCYID>
</taPopRcptLineInsert>
<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT1219</POPRCTNM>
<ITEMNMBR>A5 Meet the Team invites</ITEMNMBR>
<ITEMDESC>A5 Meet the Team invites</ITEMDESC>
<VENDORID>ACETRAVE0001</VENDORID>
<RCPTLNNM>2</RCPTLNNM>
<InventoryAccount>000-1100-00</InventoryAccount>
<UOFM>Each</UOFM>
<UNITCOST>80.00</UNITCOST>
<EXTDCOST>80.00</EXTDCOST>
<NONINVEN>1</NONINVEN>
<QTYSHPPD>1</QTYSHPPD>
<QTYINVCD>1</QTYINVCD>
<Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
<Purchase_Item_Tax_Schedu>000-1100-00</Purchase_Item_Tax_Schedu>
<Purchase_Site_Tax_Schedu>ALL DETAILS </Purchase_Site_Tax_Schedu>
<TAXAMNT>16.00</TAXAMNT>
<LOCNCODE>WAREHOUSE</LOCNCODE>
<receiptdate>01/02/2016 00:00:00</receiptdate>
<CURNCYID>Z-US$</CURNCYID>
</taPopRcptLineInsert>
</taPopRcptLineInsert_Items>
<taPopRcptMultiBin_Items xsi:nil="true" />
<taPopRcptLineTaxInsert_Items>
<taPopRcptLineTaxInsert>
<VENDORID>ACETRAVE0001</VENDORID>
<POPRCTNM>RCT1219</POPRCTNM>
<TAXDTLID>AUSSTE+PS20N0</TAXDTLID>
<TAXTYPE>0</TAXTYPE>
<ACTNUMST>000-1100-00</ACTNUMST>
<TAXAMNT>8.64</TAXAMNT>
<TAXPURCH>43.20</TAXPURCH>
<TOTPURCH>43.20</TOTPURCH>
<RCPTLNNM>1</RCPTLNNM>
</taPopRcptLineTaxInsert>
<taPopRcptLineTaxInsert>
<VENDORID>ACETRAVE0001</VENDORID>
<POPRCTNM>RCT1219</POPRCTNM>
<TAXDTLID>AUSSTE+PS20N0</TAXDTLID>
<TAXTYPE>0</TAXTYPE>
<ACTNUMST>000-1100-00</ACTNUMST>
<TAXAMNT>16.00</TAXAMNT>
<TAXPURCH>80.00</TAXPURCH>
<TOTPURCH>80.00</TOTPURCH>
<RCPTLNNM>2</RCPTLNNM>
</taPopRcptLineTaxInsert>
</taPopRcptLineTaxInsert_Items>
<taPopRctUserDefined xsi:nil="true" />
<taPopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taPopRcptHdrInsert>
<POPRCTNM>RCT1219</POPRCTNM>
<POPTYPE>3</POPTYPE>
<VNDDOCNM>RCT000111-E</VNDDOCNM>
<receiptdate>01/02/2016 00:00:00</receiptdate>
<BACHNUMB>02032016101150</BACHNUMB>
<VENDORID>ACETRAVE0001</VENDORID>
<TRDISAMT>0.00</TRDISAMT>
<TAXAMNT>24.64</TAXAMNT>
<AUTOCOST>1</AUTOCOST>
<TAXSCHID>ALL DETAILS </TAXSCHID>
<USINGHEADERLEVELTAXES>2</USINGHEADERLEVELTAXES>
<CURNCYID>Z-US$</CURNCYID>
<RATEEXPR>0</RATEEXPR>
<DYSTINCR>0</DYSTINCR>
<TRXDTDEF>0</TRXDTDEF>
<RTCLCMTD>0</RTCLCMTD>
</taPopRcptHdrInsert>
<taMdaUpdate_Items xsi:nil="true" />
</POPReceivingsType>
</eConnect>

[/code]

THanks a lot

Invoice - Adding Project Number to Receivings invoice

Hi again,

So we've basically nailed down our issue to adding the Project Number/Cost Centre ID to the invoice that is causing our Distribution Items to be unballanced.

When we submit an invoice via eConnect without setting the ProjNum and CostCatID values, the distribution form will balance. However when we set these (as this is the requirement from the client) the Distribution type changes from PURCH to "Work In Progress" and the sub total is not included on the form

What we really need to happen is the "Work in Progress" to be included in the PAY value - this must be some configuration somewhere but we can't figure this out.

Class_ID not allowing full functioanlity?

Hello

I am trying to determine why I am not able to provide administrative access to a specific user group for password resets.

We have a SECURITY group (Class ID) called PASSWORDRESET for our helpdesk to simply reset Dynamics GP passwords, generally we copy the access for a new help desk employee from an existing user who has this role or we manually assign the role.

There are a few users in this class ID who can login to reset a users password, the new users created in the past two years do not have the ability to click the "save" button in the User Setup window because the "save" button is greyed out.

I thought perhaps it was something in SQL so I went and verified the following settings:
I have verified that all of the logins within SQL under Server/Security/Logins all have the same access which is true between functional users and the non functional users.

Can anyone think of what may be causing this?

Thank you

Mark

consulta

Deseo hacer un addon para gp desde visual estudio, es solo para aprender.

alguien podría indicarme los pasos, o referirme a algún tutorial...

I want to make an addon for gp from visual studio , it's just to learn.
someone could tell me the steps , or refer to a tutorial ...

Update header-level location code on sales order

Does anyone have any sample code on how to update one piece of information on a sales order header such as the location code?

Thanks!

business alert for new vendor

Hello,

I need to create a business alert for notifying a manager that a new purchase vendor has been added.

Does this alert already exist or if not, how do I use the date as a constant?

VBA and SQL Stored Procedures

Okay -

I need to modify some Manufacturing Tables using a Push Button on the MO Entry Screen.

I know exactly what I need to do in SQL (I've written a SQL Stored Procedure that handles the updating and deleting part of the process).

My question is - Using Visual Basic Editor in GP - Can I fire off a SQL Stored Procedure? I would need to pass the MO Number as a parameter to the stored procedure.

At this point I just need to confirm feasibility - anybody have an opinion?

Thanks in advance........

Bron

ConnectMethods UpdateEntity return error Root element () not found.

I'm trying to update the LOCNCODE for header and lines in SO transaction, but I get this error "Root element (<eConnect>) not found. Please verify xml document.The current root element is root"

this is my code:

Dim strDoc As String = oeConnectMethods.GetEntity(connectionString, doc.OuterXml)

strDoc = strDoc.Replace(oldLoc, newLoc) (here I replace <LOCNCODE>MIA-FL</LOCNCODE> for <LOCNCODE>EGV-IL</LOCNCODE>)

Try
oeConnectMethods.UpdateEntity(connectionString, strDoc)
Catch ex As Exception
Dim strMessage = ex.Message
Throw New Exception(strMessage)
End Try

this is my strDoc content, there is a <eConnect> element ..so I dont understand why the error :(

- <root>

- <eConnect ACTION="0" Requester_DOCTYPE="Sales_Transaction" DBNAME="NP12" TABLENAME="SOP10100" DATE1="1900-01-01T00:00:00" SOPNUMBE="2175575" SOPTYPE="2">

- <SO_Trans>

<DOCID>STDORD</DOCID>

<ACTLSHIP>2016-03-07T00:00:00&l