Archives

 
We tried to inactive an employee in the office here this morning, and got the error "There are unposted transaction for this employee. The employee record can not be deleted or inactivated". This article discusses the fix that we used.                    

This is our example SQL TRY/CATCH template.

Why bother with templates?

RAD. Rapid Application Development.

We work remotely 99% of the time, we're not on our local machines. Templates allow us to have a place to store boilerplate (and tested) code to rapidly insert into code.

 

I'm copying the example code for Menus for Visual Studio Tools, and I'm getting an error on the line that reads 'ByVal e As EventRegisterFunciton.InvoiceEventArgs'

 

Here is a working code example for the Dynamics GP RMTransactionType document

I'm in the habit of documenting every error that I get in Dynamics GP development. The aim is that then next time that the next time that I come across it, I'll have the answer. So, here's today's fun:

While deploying a Dynamics GP addin that had Menus for VSTools as a component, I got the error below

 

The type initializer for 'Microsoft.Dexterity.Applications.root' threw an exception.
Inner Exception:
Specified argument was out of the range of valid values.
Parameter name: productId
GetType: System.ArgumentOutOfRangeException
Source: Microsoft.Dexterity.Bridge
StackTrace: at Microsoft.Dexterity.Bridge.DictionaryRoot.InitCookie()
at Microsoft.Dexterity.Bridge.DictionaryRoot.Init(String path, Int32 productId, Boolean isFormsDictionary, Boolean openForCodeGeneration)
at Microsoft.Dexterity.Bridge.DictionaryRoot..ctor(Int32 productId, Boolean isFormsDictionary)
at Microsoft.Dexterity.Applications.root..cctor()
TargetSite: Void InitCookie()

DynDeveloper now supports Comments on Articles (like this one). Please test it out, give us your feedback. (see the new controls down below)                       

This seems like it should be simple, and maybe I'm just missing s/thing obvious.

The GP Web Service methods reference objects that do not always clearly match up with GP Dynamics tables -- even when looking at the expanded "user-friendly" table names.

For instance, the GetSalesInvoiceByKey() and GetSalesOrderByKey() methods both retrieve a record with a given SalesDocumentKey value ... 

What GP Dynamics table (or tables) does the SalesDocumentKey link to?  There is no "Sales Document" table (except for Setup and Temp tables).

More generally, is there a resource that maps GP Web Services methods to the GP Dynamics table(s) they work with?  Unfortunately, the MSDN documentation does not include this information.

Thanks in advance,

Rich

There are several fields in the table explanation page for RM00201. For example:

MXWOFTYP smallint

Max Writeoff Amount:
Maximum dollar amount that can be written off.
Only used if Writeoff = 2.

RM00101.MXWOFTYP

The Description for MXWOFTYP should be associated with the MXWROFAM column. This is only one example.

Is this due to the new "wiki" editing capabilities? That is, is there sufficient vetting done for the changes? It doesn't appear so.

 Sincerely,

Steve Erbach
Application Developer
WOW Logistics Company

 

I would like to turn on Multiple Bins in Fabrikam, however I am receiving the message "Multiple bins can't be enabled because there are unposted invoices transactions".  Does anyone have a SQL Script I can run to turn this feature on?

Hi,

I've been through the documentation and need to confirm that all I need to do to use the SQL stored procs for eConnect (reasons abound), is to put them in this order?  I have to import customers and AR Invoices from 2 separate XML files.

For Customers?

For AR invoices?

What about the Batch Records?   I'm not clear on those.

Thanks!
Mark

Hi

I am working on a GL import that will contain many detail lines.  The good thing is that all detail lines all go to one GL account.(Debit side).

We are importing each line because the distribution reference field is different and that information is required for later analysis purposes.

I am trying to find a way for Integration Manager to total all the debits that were imported and automatically insert that amount as a credit.  The credit side will be to one account only.

 Has anyone ever encountered this request?

thanks

I am using VSTools, GPCONNNET, and c# to build custom integrations, forms, etc into our install of GP 2010.

One of the items I would like to be able to do is reference custom developed tables/views and called custom stored procedures, preferably in a manner similar to using the tools such as:

RmCustomerMstrTable CustomerMasterTable;
CustomerMasterTable = Dynamics.Tables.RmCustomerMstr;

Instead of the above, I would have "UserTable" in its place.  

Is there a build in method to achieve this?

Or is there a recommended alternative approach?

Thanks,

Jeff

The error message I'm getting is very similar--but not quite identical--to the error message 9289 "Cannot create Bin (CreateBin = 1) if multi bins are not enabled" listed in the KB section.  Not seeing any existing KB article associated with that message, though.

Working in VS2012, I'm pushing Sales Invoice objects through the GP Web Service into Dynamics GP 2013, using the CreateSalesInvoice() web service method.  This was working, until I over-rode the automatic Lot Allocation Behavior in the Create Sales Invoice Policy (switched to Manual; now I'm building and adding a SalesLineLot array to each SalesInvoiceLine item).

Now, I'm getting this "Cannot create bin if multibin is not enabled." validation exception.  Multibin is not enabled in GP -- we don't want it enabled.  We don't want bins created in GP.  In my code, I am not creating/adding any bin objects or settings.  And since I started getting the exception, one by one I have over-ridden / turned off every Bin-related behavior in the Create Sales Invoice Policy object (both programmatically and in the GP DynamicsSecurityConsole's Policy node).

Thoughts or suggestions, anyone?

Thanks,

Rich

What is the flag in eConnect to automatically fulfill the line items when the document is pulled into GP?

Edit 9/16/15 View the main article for this error here 

Error Description = this company does not have access to the currency ID or is inactive.

I'm getting this error when I use smartconnect upload JE transction to one of the companies. the currency id being passed in the map is the functional currency.

when I key in the transactions on the UI window it populates fine.

Any help would be much appreciated.

When our users look at Inventory->Items->Select an Item,, they see a wrong On Order value.  When they click the On Order link, they get a different value for On Order that is correct.  We know that the initial value (that is wrong) is stored in IV00102.QTYONORD.

What will trigger an update/correction of IV00102.QTYONORD?

 

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