Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In

Archives

 

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 is very easy.  See the simple steps using the wizard. 

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

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

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

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

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

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

 

 

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