Archives

 

Most of the code that we write has an email component to it, and I always need to get the information for that from the client about the email server/username etc.

The text below has that request so that I can cut and paste, or send a link to this article.

That's lazy, right?                       

Using eConnect, you get this error:

Procedure or function 'taSomething' expects parameter '@I_Something', which was not supplied

I've seen this caused two ways, so I'm pretty familiar with how to fix it.

I'll detail those two, and the new one that I found today trying to extend eConnect using a custom procedure

The Extender tables have changed completely. Here is a set of stored process that I used in a recent job. They won't be right for every job, but it's a good starting place, good enough for a starting place for me to modify for the next job.

Procedure or function 'taSomething' expects parameter '@I_Something', which was not supplied                       

We recently posted an article on difficulties with extending eConnect with custom stored procedures. We've come across a new wrinkle today that causes the error above, and we show how to fix it.  

An error occurred during client rendering

An error has occurred during report processing.

Query execution failed for dataset 'dsCompanyName'. Invalid object name 'SY00100'

This article shows the fix that we arrived at. The GP version was 10, and the client had started a GP2013 upgrade

 

Using VST for Dyn GP 2013.

If user adds a line in an Invoice or Fulfillment order does not tab to Extended Price column, the distributions for that line don't get initialized.

If they invoke our tool and it tries to udpate order, the distributions are invalid.

How can I either detect or prevent this?  Can I know which column in the line grid the user is currently on when they invoke our application?  Or automatically go to the next column?

I'm trying to submit the document below to Dynamics via eConnect, and I'm getting a cryptic 'An Item with the same key has already been added.'.

Can anyone offer any insight?

I have verified that Functional Currency has been setup, and I can key the transaction manually.

  <PMTransactionType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateVendorRcd xsi:nil="true" />
    <taCreateVendorAddress_Items xsi:nil="true" />
    <taPMTransactionTaxInsert_Items xsi:nil="true" />
    <taPMDistribution_Items>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>00015782</VCHRNMBR>
        <VENDORID>CHASEVISA01</VENDORID>
        <DSTSQNUM>1</DSTSQNUM>
        <DISTTYPE>2</DISTTYPE>
        <ACTNUMST>62000-01-00</ACTNUMST>
        <DEBITAMT>270.00000</DEBITAMT>
      </taPMDistribution>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>00015782</VCHRNMBR>
        <VENDORID>CHASEVISA01</VENDORID>
        <DSTSQNUM>2</DSTSQNUM>
        <DISTTYPE>2</DISTTYPE>
        <ACTNUMST>62000-01-00</ACTNUMST>
        <DEBITAMT>87.00000</DEBITAMT>
      </taPMDistribution>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>00015782</VCHRNMBR>
        <VENDORID>CHASEVISA01</VENDORID>
        <DSTSQNUM>3</DSTSQNUM>
        <DISTTYPE>6</DISTTYPE>
        <ACTNUMST>20100-00-00</ACTNUMST>
        <CRDTAMNT>357.00000</CRDTAMNT>
      </taPMDistribution>
    </taPMDistribution_Items>
    <taAnalyticsDistribution_Items>
      <taAnalyticsDistribution>
        <DOCNMBR>00015782</DOCNMBR>
        <DOCTYPE>1</DOCTYPE>
        <DistSequence>1</DistSequence>
        <ACTNUMST>62000-01-00</ACTNUMST>
        <aaTrxDim>PROJECT</aaTrxDim>
        <aaTrxDimCode>BDX004</aaTrxDimCode>
      </taAnalyticsDistribution>
      <taAnalyticsDistribution>
        <DOCNMBR>00015782</DOCNMBR>
        <DOCTYPE>1</DOCTYPE>
        <DistSequence>2</DistSequence>
        <ACTNUMST>62000-01-00</ACTNUMST>
        <aaTrxDim>PROJECT</aaTrxDim>
        <aaTrxDimCode>BDX004</aaTrxDimCode>
      </taAnalyticsDistribution>
    </taAnalyticsDistribution_Items>
    <taPMTransactionInsert>
      <BACHNUMB>EW_EMP</BACHNUMB>
      <VCHNUMWK>00015782</VCHNUMWK>
      <VENDORID>CHASEVISA01</VENDORID>
      <DOCNUMBR>A</DOCNUMBR>
      <DOCTYPE>1</DOCTYPE>
      <DOCAMNT>357.00000</DOCAMNT>
      <DOCDATE>6/13/2013</DOCDATE>
      <DUEDATE>1/1/1900</DUEDATE>
      <PRCHAMNT>357.00000</PRCHAMNT>
      <CHRGAMNT>357.00000</CHRGAMNT>
      <TRXDSCRN>1748 -- 05/28/2013 - 06/10/201</TRXDSCRN>
      <CREATEDIST>0</CREATEDIST>
    </taPMTransactionInsert>
    <taMdaUpdate_Items xsi:nil="true" />
  </PMTransactionType>
</eConnect>

I need to import a FA but i don't know  how,

what is the format of the .txt (tab delimitier)  what can i need

or if you have one example please send me.

in the documentation says i need a asset.txt but a found in my computer and not found

please help me

We are using Field Service in GP. When we try to edit a specific RMA number is tells us the "document is edited by another user".

I know nobody else is in the document so where do I go in SQL to fix that?

Thank you

 

i need to copy a ledger accounts from a company to another company how can i do that?

the companies are in diferent server

I have a problem i create a new company but when a try to login in thge company but this message appears  

¿how can i config the company?  

I am working VSTMenus, no problem installing, and have written some integrations. As I get ready for deployments, I will need to be able to roll back the install, but I don't see how I roll back installing. It is not mentioned in the documentation.

Any suggestions? Do I just need to put the DYNAMICS.SET back to the original and remove the VSTMENUS.DIC?

I have developed three GP AddIns and am using VST Menus to provide each with a menu in GP.

I have a few questions about the placement and ordering of the custom menu items.

1. Is it possible to have a custom VST menu item at the very top of Transactions -> Sales?  The client asked if the custom items could be listed before Sales Transaction Entry.  Since VST Menus seems to only have a "Below" option, I didn't think it would be possible to put something above Sales Transaction Entry, but I'm interested to know if it is possible.  Has anyone found a trick to placing custom VST menus at the top of the GP transaction list?

2. When you have multiple custom VST menu items that are all grouped together, is it possible to control the order of those items?

In my screen shot below, is it possible to have "Compass Apply Payments" appear above "Compass Apply Credits"?

I understand that when we setup a new user, they are added to primary company database, such as "TWO", and they are put into the correct group with the appropriate rights, such as the DYNGRP.

But, we have another database on the server that holds some functionality, such as stored procedures and tables, that are used for some integration and extensions within the GP company database. I have the DYNGRP role inside this second db (we will call it "THREE"), and have set all the appropriate rights in the "THREE" db for the role DYNGRP.

What I would like to be able to do is either automatically assign the users rights to this second, non-company db, when a new user is added or give an option in the setup screens for the new user. Right now in the setup we only see the single company database, "TWO".

One option that I am entertaining is adding a SQL step to the job "Remove Posted PJOURNALs From All Companies", that will query "TWO" database and compare users to what is in the "THREE" database, and sync up users that may be missing.

What I don't want to do is require IT intervention when a new user is added to GP. Assume that we cannot integrate the "THREE" database into the GP "TWO" database.

I am open to some other options.

Thanks,

Jeff

What table i can see a funtional currency in GP?

(Currency ID)

hello 

I have a econnects but this econnects is for No Accounting Analytics,

the question is this econnects found in analytical accounting or is necessary create a new econnects

 

 

If user brings up a sales transaction, runs my tool to calculate freight and write freight, but doesn't change anything else, they can then navigate off of that sales transaction without the "do you want to save or delete the document" prompt and lose the changed freight value.

This is where I write the freight:

// Force the validation of the new freight amount

 

 

 

 

 

Dynamics.Forms.SopEntry.SopEntry.LocalOriginatingFreightAmount.RunValidate();

 

 

 

Dynamics.Forms.SopEntry.SopEntry.LocalOriginatingFreightAmount.ForceValidate(true);

 

 

 

Dynamics.Forms.SopEntry.SopEntry.LocalOriginatingFreightAmount.Value = WriteBackDoc.TotalFreight;

 

 

 

// Force the validation of the new freight amount

 

 

 

Dynamics.Forms.SopEntry.SopEntry.LocalOriginatingFreightAmount.RunValidate();

 

 

 

Dynamics.Forms.SopEntry.SopEntry.LocalOriginatingFreightAmount.ForceValidate(true);

 

 

 

Dynamics.Forms.SopEntry.SopEntry.CustomerPoNumber.Focus();

 

 

 

Dynamics.Forms.SopEntry.SopEntry.PullFocus();

 

when i try to install GP 10 this messages appers

how can i fix this errors

 

 

when i go to cards/financial/dimensions this messages appears 


where I can enable that when I create the new company did not appear that the analytical accounting option

to create the default log I have to go setup >> company >> Analitycal  Accounting >> Setup 

income when I am asked to enter either the user or SA DYNSA the problem I have is that the company deleted those users could re-create or can do to configure
This article contains examples of CSS code to use for styling the RadGrid                       
Error: The control with ID 'RadMenu1' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it                       
This is a followup to the RadMenu post, here we show styling
Example styling for the radGrid                       
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