DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

I've developed a web based application to load payable transactions into Great Plains using eConnect 10.  When we load the Distributions into the system, if the "Allow Account Entry" is disabled for the payable GL account, eConnect does not import the distributions - the eConnect error returned is

9563 The Account Number you supplied is not set up to allow account entry. 

Without enabling "Allow Account Entry" because this is for control purposes, how do I get around this error using eConnect?  When I manually enter a payable it distributes the amounts, can we auto distribute with eConnect 10?

 

Hi All, 

I’m a newbie in gp integration. Trying to use the econnect9. I was able to send data in gp payable transaction entry but I can’t get the next voucher no. Im trying to use the misc routine but I’m getting the error “error in method GetNextSopNumber” even in trying to get the next PM payment no.  

 Thanks in advance. God bless..

Emerson

Full Error Message:

Server was unable to process request. ---> Sql procedure error codes returned:
Error Number = 6328  Stored Procedure taUpdateCreateCustomerRcd  Error Description = The Customer Priority parameter is invalid: 1 to 100 are valid values
Node Identifier Parameters: taUpdateCreateCustomerRcd                         
CUSTNMBR = ULINE
Related Error Code Parameters for Node : taUpdateCreateCustomerRcd                         
CUSTPRIORITY =  Note: This parameter was not passed in, no value for the parameter will be returned.

Error Number = 6327  Stored Procedure taUpdateCreateCustomerRcd  Error Description = The Order Fulfillment Shortage Default parameter is invalid: 1=None; 2=Back Order Remaining; 3=Cancel Remaining
Node Identifier Parameters: taUpdateCreateCustomerRcd                         
CUSTNMBR = ULINE
Related Error Code Parameters for Node : taUpdateCreateCustomerRcd                         
ORDERFULFILLDEFAULT =  Note: This parameter was not passed in, no value for the parameter will be returned.

<taUpdateCreateCustomerRcd><CUSTNMBR>ULINE</CUSTNMBR><CUSTNAME>ULINE</CUSTNAME>
<CUSTCLAS>ULINE</CUSTCLAS><ADRSCODE>MAIN</ADRSCODE><CNTCPRSN>Ron Htun  </CNTCPRSN>
<ADDRESS1>  2200 S. Lakeside Drive</ADDRESS1><ADDRESS2></ADDRESS2><ADDRESS3></ADDRESS3><CITY>Waukegan</CITY><STATE>IL</STATE>
<ZIPCODE>60085</ZIPCODE><COUNTRY>US</COUNTRY><PHNUMBR1>8474733000</PHNUMBR1><PHNUMBR2>
</PHNUMBR2><PHNUMBR3></PHNUMBR3><FAX>8476880859</FAX><SHIPMTHD>BST</SHIPMTHD>
<PRSTADCD>SHIP</PRSTADCD><PRBTADCD>BILL</PRBTADCD><STADDRCD>BILL</STADDRCD>
<USECUSTOMERCLASS>1</USECUSTOMERCLASS><CREATEADDRESS>1</CREATEADDRESS>
<UPDATEIFEXISTS>1</UPDATEIFEXISTS></taUpdateCreateCustomerRcd>

 Hi.

I am new in ecoonect10 subject.

I am working on a website and I don't know why when I run it.the website stop on this line without any error message.

eConnectMethods eConCall = new eConnectMethods();

 

 

Thanks

Hi Gurus,

I was able to send to GP a Manual Payment entry using eConnect9. But i dont see any schema that will allow me to send the corresponding application(applying the manual payment to settle invoice). Is there anyway i can do this using eConnect9? thanks in advance.

Regards,

Emerson

I figured I would write a new post for this instead of piggybacking another - I am having a problem with using eConnect on my local machine pulling data from the GP server.  I basically have taken the sample code and modified the connection string - and it all works great when I run it on the GP server directly.  If I take the code and run it from my local machine, it hangs/locks up on the New eConnectMethods object instantiation:Dim requester As New eConnectMethods()  I don't see anything getting logged when this occurs.

Do I need to install something locally for this to work?  I thought I could just reference the 3 dlls per the documentation and all would be good.

Any help would be greatly appreciated.  Thanks in advance!

Dear All

I am working with VS2005, C#, Developer tool kit, GP 10.

I am trying to use Continuum API to handle the response of Dialog Box
because I can't do that using Developer tool kit.

So I did create a new application "Microsoft Dynamics GP Add-in" C#

I have this error: "Specified cast is not valid"

I build my solution and I add the DLL in this path: C:\Program
Files\Microsoft Dynamics\GP\AddIns

Please I need your advise please.

And I wrote the below Code

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Dexterity.Bridge;
using Microsoft.Dexterity.Applications;


namespace HowToTestContinuumAPI
{
    public class GPAddIn : IDexterityAddIn
    {
        // IDexterityAddIn interface
        public static Dynamics.Application GPAPP = new Dynamics.Application();
        public GPCallbackClass GPCallBack = new GPCallbackClass();
        enum focus_type
        {
            PRE = 0, CHANGE, POST, PRINT, ACTIVATE, FILL, INSERT,
            DELETE, MODAL_DIALOG         }
        enum attach_type { Before = 1, After }       

        public void Initialize()
        {       
        //Dynamics.DIALOG_RESPONSE
       
        GPAPP.RegisterFocusTrigger("window 'IV_Transaction_Lot_Numbers' of
form 'IV_Transaction_Entry'",
            8, 1, GPCallBack, "POP_Lot_Entry_Dialogs");       

        }
GPAPP.SetParamHandler(GPCallBack);


    }
}



////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////

using System;
using System.Collections.Generic;
using System.Text;

namespace ContinuumAPIProjectCSharp
{
    public class GPCallbackClass
    {
        public GPCallbackClass()
        {
        }
        public void POP_Lot_Entry_Dialogs(int dialogType, string prompt, ref
string
        control1, ref string control2, ref string control3, ref int answer)
        {
            if (dialogType == 0 && prompt == "Are you sure you want to
remove all lot numbers?")
            {
                answer = 0;
                HowToTestContinuumAPI.GPAddIn.GPAPP.StopProcessing();
            }
        }
    }
}

 Hi All,

I wanna Create a salesorderDocument and I Sent a SOPNUMBER="" but It dosent generate SopNumber and it giva a error message .How can I fix it

thanks 

So here is my issue, I have to use integrated security in the connection string for eConnect. Even though when doing so it uses the network login to try and log in to the db. Is there a way to work around this so that I can use the login that the user is using for GP? By saying "I have to use", I mean that eConnect does not let me use a username and password.

The POP_PO table contains the identifying document information for non-historical purchase orders.

Display Name Purchase Order Work
O/S Name POP10100
 
 
Field descriptions: (Required fields appear in bold and are underlined)

PO Number The unique identifying number of the document.  (The document should not exist in Purchase Order history.)

PO Status  Status assigned to the Purchase Order
  1 = POP_POSTATUS_NEW 
  2 = POP_POSTATUS_RELEASED
  3 = POP_POSTATUS_CHANGEORDER
  4 = POP_POSTATUS_ RECEIVED
  5 = POP_POSTATUS_CLOSED
  6 = POP_POSTATUS_CANCELED

Status Group Assigned when the status of the purchase order changes and is used to group Purchase Orders by status types to enable ranging on active (New, Open or Modified)  or closed (Canceled or Closed ) purchase orders.
1 = POP_ACTIVE
 2 = POP_CLOSED

PO Type  Type of Purchase Order 
   1 = Standard
  2 = Drop Ship
  3 = Blanket
  4 = Blanket Drop Ship

User To Enter The User ID of the current user in the system when the purchase order document was created.

Confirm With Name or Initials of the person in company with whom the order should be authorized or approved

Document Date The date of the document. Changes to this date may also cause the payment terms to recalculate.

Last Edit Date Date the Purchase Order was last modified.  This date is not updated when the PO is being printed, even if printing changes the status. It also is not updated when a PO with a New status is received against and the status is changed to Open.

Last Printed Date The last date the Purchase Order was printed.

Promised Date The Promised Date when your vendor promised you would have your merchandise.

Promised Ship Date The Promised Ship Date when your vendor promised to ship your merchandise.

Required Date Required Date by which you must receive the items.

Requisition Date Requisition Date for a Purchase Order.

Shipping Method The assigned shipping method for a purchase order.

Tax Registration Number The tax registration number is stored here. It is for user reference only.

Remaining Subtotal The sum of the originating remaining line item amounts in the related POP_POLine records converted to functional.  Originating remaining line item amounts are calculated as follows:  Quantity Remaining to Invoice * Originating Unit Cost.  Quantity Remaining to Invoice = Quantity Ordered - Quantity Canceled - Posted to Date Invoiced - Unposted Invoiced

Subtotal The total of the originating extended costs of all line items converted to functional.

Trade Discount Amount The amount of the trade discount on this purchase order document.

Freight Amount The freight amount entered for a purchase order

Misc Charges Amount Used for Miscellaneous charges entered on a Purchase Order

Tax Amount The Tax Amount entered on the purchase order document.

Vendor ID The assigned Vendor ID for the purchase order.

Vendor Name The name of the vendor from the PM_Vendor_MSTR table for the Vendor ID assigned.

Minimum Order The Vendor’s Minimum Order Amount in functional.

Vendor Address Code - Purchase Address The Address Code for the Vendor Purchase Address ID

Company ID Company ID in which the Purchase Order was entered.  It is used on reports to establish a relation to the Company location addresses.  Found in the Company Master table (SY01500)

Primary Billto Address Code Address Code for the Bill To Address ID

Primary Shipto Address Code Address Code for the Ship To Address ID.

Company Name Company Name for the Ship To Address ID. 

Contact Contact for the Ship To Address ID

Address 1 Line 1 of the Ship To Address ID

Address 2 Line 2 of the Ship To Address ID

Address 3 Line 3 of the Ship To Address ID

City City for the Ship To Address ID

State State for the Ship To Address ID.

ZipCode The Zip Code for the Ship To Address ID.

Country Code: Country Code to which this address belongs to.

Country Country for the Ship To Address ID

Phone 1 Phone 1 for the Ship To  Address ID

Phone 2 Phone 2 Ship To Address ID

Phone 3 Phone 3 Ship To Address ID


Fax The Fax phone number for the Ship To Address ID

Payment Terms ID Used to calculate the Discount Amount Available

Discount Dollar Amount The discount available amount for payment terms when entered by the user and not calculated

Discount Percent Amount Used to determine the Discount Amount Available (Not used if Payment Term ID is being used)

Discount Amount Available The discount amount available for the assigned Payment Term ID

Discount Date The date the discount expires (required if discounts are calculated)

Due Date The date payment is due. It is set to document date if there are no payment terms.

Trade Discount Percent (Precise) Should be set to the percent (%) which will yield :
 Trade Discount Percent (Precise) * Subtotal = Trade Discount Amount

Customer Number The assigned customer number for a drop-ship purchase order

Times Printed The number of times the purchase order document has been printed.

Created Date The system date of the first save of the purchase order

Modified Date Updated with system date each time document is saved. (Not updated.)

PO Note ID Array Note Index Array for all purchase order note indexes:
 [1] PO Note Index - POP_PONOTEID_PO
 [2] Buyer Note Index - POP_PONOTEID_BUYER
 [3] Vendor ID Index - POP_PONOTEID_VENDOR
 [4] Comment Note Index - POP_PONOTEID_COMMENT
 [5] Payment Term ID Note Index - POP_PONOTEID_PAYTERM
 [6] Shipping Method Note Index - POP_PONOTEID_SHIPMETHOD
 [7] Currency ID Index - POP_PONOTEID_CURRENCY
 [8] Tax Schedule Index - POP_PONOTEID_TAXSCHED
 [9] Freight Tax Schedule Index - POP_PONOTEID_FREIGHTTAXSCHED
 [10] Misc Tax Schedule Index - POP_PONOTEID_MISCTAXSCHED
 [11] Contract Number Index - POP_PONOTEID_CONTRACTNUMBER
 [12] not used at this time
 [13] not used at this time
 [14] not used at this time
 [15] not used at this time

Comment ID  The ID of the comment

Canceled Subtotal The originating extended cost for the canceled quantity for all line items converted to functional.

Currency ID  Currency ID of the transaction.  If not a multi-currency transaction,
  leave blank. 

Currency Index  Currency index of the transaction.  If not a multi-currency transaction,
  leave blank. 

Rate Type ID  Rate Type ID of the transaction.  If not a multi-currency transaction,
  leave blank. 

Exchange Table ID  Exchange Table ID of the transaction.  If not a multi-currency transaction, leave blank. 

Exchange Rate  Exchange Rate of the transaction.  If not a multi-currency transaction,
  leave blank.  If there is triangulation and both rates are fixed, this is the originating to euro fixed rate.  Otherwise, this is the variable rate.

Exchange Date  Exchange Date of the transaction.  If not a multi-currency transaction,
  leave blank. 

Time  Time of the transaction, used for exchange rate purposes.  If not a multi-currency transaction, leave blank. 

Rate Calc Method  Rate Calc Method of the transaction.  If not a multi-currency transaction, leave blank. 
  0 = MULTIPLY
  1 = DIVIDE

Denomination Exchange Rate  Denomination Exchange Rate of the transaction. If there is triangulation, this is the fixed rate.  If both rates are fixed, this is the euro to functional fixed rate.  If there is no triangulation or a non multi-currency transaction, this is 0.0

MC Transaction State  MC Transaction State of the transaction.  If not a multi-currency transaction, leave blank.  State the transaction was created in.
  0 = Euro currency is not created or no denomination currencies are enabled.
  1 = Originating is not a denomination; Functional is not a denomination
  2 = Originating is not a denomination; Functional is the Euro currency.
  3 = Originating is not a denomination; Functional is a denomination.
  4 = Originating is a denomination; Functional is not a denomination.
  5 = Originating is a denomination; Functional is a denomination.
  6 = Originating is a denomination; Functional is the Euro currency.
  7 = Originating is the Euro currency; Functional is a denomination.
  8 = Originating is the Euro currency; Functional is not a denomination.

Originating Remaining Subtotal The sum of the remaining line item amounts in the related POP_POLine records.  Remaining line item amounts are calculated as follows:  Quantity Remaining to Invoice * Originating Unit Cost.  Quantity Remaining to Invoice = Quantity Ordered - Quantity Canceled - Posted to Date Invoiced - Unposted Invoiced

Originating Subtotal  The total of the originating extended costs of all line items.

The following fields must be imported regardless of if Multi-Currency is registered.  If the transaction is
not a multi-currency transaction, then fill the field with the same value of the corresponding non-mc
field.  Example:  If Freight Amount = $3.00, then set Originating Freight Amount to
the same amount.  If Freight Amount = $0.  Then leave the Originating Freight Amount
Freight blank also.
 
                Originating Canceled Subtotal 

Originating Trade Discount Amount

Originating Freight Amount

Originating Misc Charges Amount

Originating Tax Amount

Originating Discount Dollar Amount

Originating Discount Amount Available

Buyer ID  The username of the user that entered the POP TRx

On Order Amount  The sum of the originating on order amounts in the related POP_POLine records converted to functional.  Originating on order amounts are calculated as follows: ( Current Order Qty * Originating Unit Cost ) – Originating Posted Subtotal.   Current Order Qty = QTY Ordered  - QTY Canceled.

Originating On Order Amount  The sum of the originating on order amounts in the related POP_POLine records converted to functional.  Originating on order amounts are calculated as follows: ( Current Order Qty * Originating Unit Cost ) – Originating Posted Subtotal.   Current Order Qty = QTY Ordered  - QTY Canceled.

Hold Designates whether the Purchase Order document is on hold.
  0 - False
 1 – True

On Hold Date The date the purchase order document was placed on hold.

On Hold By The User ID of the current user in the system at the time the purchase order was placed on hold.

Hold Remove Date The date the purchase order document was taken off hold.

Hold Remove By The User ID of the current user in the system at the time the purchase order was taken off hold status.

Allow SO Commitments This field determines if Sales Order Processing documents are allowed to be committed to this Purchase Order document and whether the items purchased on this Purchase order may be reserved for a specific sales order.
  0 - False
 1 – True

Discount Grace Period  The number of grace period days assigned to the vendor on the purchase order

Due Date Grace Period The due date for the discount grace period

Revision Number Used to print revision number on a revised PO.  Leave empty for importing

Change Order Flag Will determine if “Change Order will print next time the order is printed.  Leave empty for importing

PO Field Changes Used to determine which items have changes since the last time the PO was printed.  Leave empty for importing

PO Status Orig The status of the PO
 1 – New
 2 – Released
 3 – Change Order
 4 – Received
 5 – Closed
 6 – Canceled

Tax Schedule ID: Default tax schedule used for transactions.  The tax schedule should exist in the TX_Schedule_MSTR file.

Tax Schedule Source: Source of the tax schedule, the following source and constants are available.
 
 Drop Ship - POP_POTAXSCHEDSOURCE_NONE
 Vendor - POP_POTAXSCHEDSOURCE_PURCH
 Company - POP_POTAXSCHEDSOURCE_COMPANY
 Setup Single Tax Schedule - POP_POTAXSCHEDSOURCE_SINGLE

Tax Engine Called: Set to true.  This field indicates whether the tax engine has been run.

Based On Invoice Total: This field contains information regarding whether the line item contains taxes which are based on the invoice total.
 True = Line items contains taxes based on invoice total.
 False = Line item does not contain taxes based on invoice total.

Purchase Freight Taxable: Value  indicating how Freight amounts are taxed.
 1 – Taxable
 2 – Nontaxable
 3 – Base on Vendor

Purchase Misc Taxable: Value indicating how Miscellaneous amounts are taxed.
 1 – Taxable
 2 – Nontaxable
 3 – Base on Vendor

Freight Schedule ID: The schedule masked against the Tax Schedule ID to determine which tax details are applicable for the freight amount field.  There must be a record in the TX_Schedule_MSTR file with this ID.

Misc Schedule ID: 

Freight Tax Amount: The tax amount from the ‘Freight Amount’ field.  This field is needed for backing out tax included with item price.

Originating Freight Tax Amount: The tax amount from the ‘Freight Amount’ field in the Originating Currency.  Set to Freight Tax Amount for non-MC transactions.


Misc Tax Amount: The tax amount from the ‘Misc Charges Amount’ field.  This field is needed for backing out tax included with item price.

Originating Misc Tax Amount: The tax amount from the ‘Misc Charges Amount’ field in the Originating Currency.  Set to Misc Tax Amount for non-MC transactions.

Backout Tax Amount If there is a tax included with item price detail, this is the amount of the backout tax.

Originating Backout Tax Amount: This field must be imported regardless of if Multi-Currency is registered.  If the transaction is not a multi-currency transaction, then fill the field with the same value of the corresponding non-MC field.

Backout Freight Tax Amount:

Originating Backout Freight Tax Amount:

Backout Misc Tax Amount:

Originating Backout Misc Tax Amount:

Flags: The Flags field is used to determine if the address attributes have been modified.

Backout Trade Discount Tax Amount: Amount of “Tax Included in Item Price” associated with the Trade Discount Amount.

Originating Backout Trade Discount
Tax Amount: Amount of “Tax Included in Item Price” associated with the Originating Trade Discount Amount.

POP Contract Number: Contract Number assigned to this Purchase Order.
 
Contract End Date: Date the contract will expire.

Control Blanket By: Blanket PO can be controlled by Item Quantities or Item Value.  The following constants are provided. 

 POP_PO_CONTROL_BLANKET_BY_QTY - 0
 POP_PO_CONTROL_BLANKET_BY_VALUE - 1

Purchase Company Name: Purchase Address Company Name

Purchase Contact: Purchase Address Contact

Purchase Address 1: Purchase Address 1

Purchase Address 2: Purchase Address 2

Purchase Address 3: Purchase Address 3

Purchase City: Purchase Address City

Purchase State: Purchase Address State

Purchase Zip Code: Purchase Address Zip Code

Purchase Country Code: Purchase Address Country Code

Purchase Country: Purchase Address Country

Purchase Phone 1: Purchase Address Phone 1

Purchase Phone 2: Purchase Address Phone 2

Purchase Phone 3: Purchase Address Phone 3

Purchase Fax: Purchase Address Fax

Total Blanket Line Ext Qty: Sum of all the Blanket Detail Line Quantities in Base U of M.

Cash Based VAT: True or False depending on whether the vendor is a cash based VAT or not.

Hi, im developing a web application that will post the major enteries to GP. Although have developed all the single headed transactions i.e Invoice, A/R, GL Transactions Posting. But now dont know with the following.

  • How can i post Invoices/ POs in Batches through eConnect.
  • When we post an Sales Invoice, we have an accounting entry in Distribution that further will be posted by pressing "Post" button. Can we do the "Post" through the eConnect so that user doesn't need to go to GP and press "Post"?

Please suggest, Thanks!

Hi

 By default, only the first 1000 items that meet the specified criteria will be returned in the
list. This limit prevents the web service from being overloaded by a query that returns an
extremely large collection.

How can I change it?