Archives

 

I have successfully installed MS Dynamics 9.0 on SQL server 2008 well it was an upgrade from SQL 2005 to 2008, along with an uprdade of GP 8.0 to GP 9.  Things are working fine, but when I try to install the eConnect 9.0 (tried many SP and hotfix of eConnect ) the follow error message is coming.

Error: 1720. There is a problem with this windows installer package. A Script required for this installation to complete could not be run. Contact Support personnel or package vendor:

Does anybody have any solution, I am stuck I bought the license of Sql server 2008 but unable to use it due to this reason. I have GP 9.0

 

 

When you try to import a package file by using the Customization Maintenance window in Microsoft Dynamics GP 9.0, you receive the following error message:
Unable to open customizations dictionary.
This problem occurs when the package file contains a form or a report that was modified by using Modifier with Microsoft Visual Basic for Applications (VBA).

Hello, I've heard where you can use eConnect to import your chart of accounts but I don't see a schema for this action in the help file. Does anyone know anything about this?  Can eConnect be used to import your COA?  If so, what is the name of the schema?

 Any information would be greatly appreciated.  Thanks.

G

 I am attempting to match an invoice against a PO and posted shipment.   It's working fine except for the VarianceAccount.  The UNITCOST does not match the original UNITCOST on the shipment and I have defined a VarianceAccount but the variance is not getting populated in the distributions, so I am left with an unequal credit/debit.

When I do an invoice and change the unit cost through the UI, the Variance Account is populated perfectly.  Whether or not the VarianceAccount is present, doing it through eConnect doesn't seem to work quite right.

Any idea what I might be doing wrong?  My POPEnterMatchInvoiceType is shown below.

 

<?xml version="1.0" encoding="UTF-8"?>
<eConnect>
  <POPEnterMatchInvoiceType>
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>INV18</POPRCTNM>
        <POPMtchShpRcpt>RCPT15</POPMtchShpRcpt>
        <PONUMBER>PO15</PONUMBER>
        <QTYINVCD>1</QTYINVCD>
        <ITEMNMBR>INSTALLATION</ITEMNMBR>
        <VENDORID>JERRY</VENDORID>
        <UNITCOST>55</UNITCOST>
        <EXTDCOST>55</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <AUTOCOST>0</AUTOCOST>
        <POLNENUM>1</POLNENUM>
        <VarianceAccount>TEST-ACT2</VarianceAccount>
        <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
        <TAXAMNT>0</TAXAMNT>
        <AutoInvoice>0</AutoInvoice>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvHdr>
      <POPRCTNM>INV18</POPRCTNM>
      <VNDDOCNM>JERRYINVOICE</VNDDOCNM>
      <receiptdate>2010-05-13</receiptdate>
      <BACHNUMB>BATCH</BACHNUMB>
      <VENDORID>JERRY</VENDORID>
      <SUBTOTAL>55</SUBTOTAL>
      <FRTAMNT>100</FRTAMNT>
      <MISCAMNT>0</MISCAMNT>
      <TAXAMNT>0</TAXAMNT>
      <PYMTRMID>Net 45</PYMTRMID>
      <AUTOCOST>0</AUTOCOST>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
      <CREATEDIST>1</CREATEDIST>
    </taPopEnterMatchInvHdr>
  </POPEnterMatchInvoiceType>
</eConnect>
 

Hello, I keep getting this error:

Error Description = Account Segment is too small, you need to pass spaces to fill the account string, check the Account passed or Segment Length in the SY00300 table
Node Identifier Parameters: taUpdateCreateAccountRcd
ACTNUMST = 000-1000-00

My account format is setup as 3-4-2.  Not sure where I would need to add spaces.  Anyone seen this error before?  Any help would be appreciated.

 Thanks

G

Hi All,

I get an error while importing through eConnect for taUpdateCreateItemRcd  the error says "Cannot insert the value NULL into column 'UOFM', table TWO.dbo.IV00107; Column does not allow nulls. Insert Fails"

Following is my XML, can any one let me know am i missing something here.

<?xml version="1.0" encoding="utf-8" ?>

- <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <IVItemMasterType>
  <eConnectProcessInfo xsi:nil="true" />
  <taRequesterTrxDisabler_Items xsi:nil="true" />
- <taUpdateCreateItemRcd>
  <ITEMNMBR>TEST ITEM 999</ITEMNMBR>
  <ITEMDESC>eCONNECT TEST ITEM</ITEMDESC>
  <ITMSHNAM>ITEM999</ITMSHNAM>
  <ITMGEDSC>ITEM999</ITMGEDSC>
  <ITMCLSCD>MODEMS</ITMCLSCD>
  <UOMSCHDL>EACH</UOMSCHDL>
  <USCATVLS_6>YES</USCATVLS_6>
  <UpdateIfExists>0</UpdateIfExists>
  </taUpdateCreateItemRcd>
  <taUpdateCreateItemCurrencyRcd_Items xsi:nil="true" />
  <taIVCreateItemPriceListLine_Items xsi:nil="true" />
  <taIVCreateItemPriceListHeader xsi:nil="true" />
  <taItemSite_Items xsi:nil="true" />
  <taCreateItemVendors_Items xsi:nil="true" />
  <taCreateKitItemRcd_Items xsi:nil="true" />
  </IVItemMasterType>
  </eConnect>
Error Number = 387  Stored Procedure taPoLine  Error Description = Invalid Free On Board value

I'm getting this error when submitting a PO where the VENDOR ITEM (IV00103) has 'freeOnBoard' set to 0

 

Hello, I'd like to use eConnect to setup tax detail and schedule records.  But I don't see a schema for this in eConnect help file.  I see a UPRCreateLocalTaxType schema with taCreateLocalTax & taCreateLocalTaxDetail but it does not look like they match the fields on the Tax Detail Maintenance screen (tools-setup-company-tax details).  Does anyone know about using eConnect to setup Tax Detail Maintenance records and Tax Schedules that are used in SOP, PM, RM transactoins?  Much appreciated.

 

G

Greetings,

I am trying to learn how to use the Visual Studio Tools, right now I am working with GP tables and would like to know if there is a way to create custom table indexes, like in dexterity where you could do this:
int x;

assign x as key for table SOP_HDR_WORK using SOP Type of table SOP_HDR_WORK;

 

Thanks in advance

Jorge A.

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3