Archives

 
This is a short code example that shows how to use the Telerik GridClientSelectColumn column, and how to retrieve selected values in the codebehind
I have a need to sort an existing Data Table by a given column.  I know I can sort in my stored procedure, but for processing, I may need it in an order other than what is returned and/or displayed. 
When an autopostback occurs, the groups in my RadGrid all expand, even though I have collapsed several of them.  Is there a way to prevent this from happening?

Increment a document number:

This routine takes the input number and increments it by 1

Document numbers commonly are in the format of a few alpha characters followed by a number --like 'ORD0001' or 'PO0001'

This routine will strip off the trailing numbers, increment, and then put the two parts back together again

I did an interesting VBA mod yesterday to copy a customer. This article will document all the code. 

There is a form mod to add the 'copy' button, VBA code behind the window to copy the customer, and three stored procedures to do the work. 

HTH...

 

I've seen some code online to handle the Action button in the SOP Transaction entry form, and none of it worked for me. Below is the code that I ended up using. 

The Action button is the one that lets you Transfer, Void, Delete, etc

 

With this article we begin a new era, the era of Dynamics 365. We believe that D365 is what Microsoft wants to sell, so... that's what we're going to see predominately in 10 years. 

Today we'll begin teaching developers about D365. 

Where to start? How about "how to log in"?

 

This will be a primer on how to create a SmartConnect to Dynamics 365 / Business Central integration.

We're going to cover everything that you need to know about how to build this integration, start to finish


SmartConnect to D365 Business Central: Failed to create record. Unable to call service: You may not enter numbers manually. If you want to enter numbers manually, please activate the Manual Nos. in No. Series 'xxx'

 


We're trying to learn Dynamics 365 Business Central because that seems to be the coming thing. 

This article details the on-premise install

After the install I got this error, need to install the 3.51 framework beforehand next time

 

Microsoft Dynamics NAV Build 13682
Error Report
Microsoft SQL Server 2014 Report Builder 3.0
Microsoft SQL Server 2014 Report Builder 3.0
Fatal error during installation.
The Microsoft .NET Framework 3.5 SP1 must be installed on your computer before you can install SQL Server Report Builder 3 for SQL Server 2014 .
Microsoft .NET Framework 3.5 SP1 is available at:
http://go.microsoft.com/fwlink/?LinkID=179240 .
After installing .NET Framework 3.5 SP1, restart the computer if required, and then install SQL Server Report Builder 3 for SQL Server 2014 .
Created on "VMNAV2017"
10/30/2018 7:06 AM

Error: Post Custom Business Logic returned an error value

We are using the eConnect option to transfer invoices into GP. The general document outline of these transactions uses the <RMTransactionType> setup.

Everything comes across fine expect for the "Original Amount" on the Sales Transaction Distribution screen. The "Functional Amount" is set correctly.

How can I set the "Original Amount"?

Thanks,

Steve

Hi,

Which table in GP holds the transaction details in a batch? I have a batch called "TEST" and I have 5 transactions in that batch. Which table holds that information?

Thanks

Paul Chacko

We have heavy dex customization. I have a custom table in which one column is size 20. I want to increase it to 30.

I am dex developer with beginner capabilities. I went into Dexterity and changed the field size from 20 to 30. I checked the table and it reflects the field with new size of 30. I have a macro to create a chunk file. I create the chunk file and it extracts, GP starts. I went into Tools -> Resources, find the table and when I look the respective field, it still shows as size 20, when i drop and recreate the table through GP, it recreates it with size 20. 

I am stumped, please help.

 

Hi

We have an issue where we get the error Reconciliation for this chequebook has already started. If the process was interrupted use the check links window to check links on the CM logical files

 

We run check links and it resolves the issue

 

the question I have is does anyone know why it happens

We have companies that have to run it numerous times

GP2018

 

 

 

 

I have a user that gets this error:

error the cost of goods sold amount is incorrect and will not be posted on sales return

I have defaulted the distributions on the transactions

I have run this in sql and checked:

SELECT SUM(EXTDCOST) AS LineExtdCost, SUM(OREXTCST) AS LineOrigCost

FROM SOP10200

WHERE (SOPNUMBE = 'the document number')

No luck, any suggestions please

 

GP2018

Does anyone know if it is possible to have the Smartlists point to a different database (we have a replicated db of our GP data) ?

We have had issues where a user will run a huge list that ties up resources and hangs GP.

If we could point all Smartlists to the replicated data, then the Live DB would not be at risk.

 

 

ello, somebody knows where I can find a description of the GP2018 tables, similar to the one in the knowledge base section of this page.

Hi,

I need to highlight all payments in Green and invoices in Black in an SSRS report so I edited the formula as follows:

=SWITCH(Fields!Document_Type.Value = 'Payment', "Green", Fields!Document_Type.Value = 'Invoice', "Black")

This is not working. I get the error: The Color expression for the textrun ‘Document_Type.Paragraphs[0].TextRuns[0]’ contains an error: [BC30201] Expression expected.

Does anyone know what it means and how do i fix it?

Thanks

Paul

why does a purchase requisition not convert to a purchase order in dynamics GP

in GP2016

 

We have vendors set up with one or more vendor address records.   I need to come up with a query that will show all these address records and whether they are marked as EFT or not.   Any suggestions will be appreciated. 

 

Is there any way to search this site (or any part of it) by keyword?

I am trying to find information related to in-transit transfers and cant find any way to search.

Thank you,

Hi, I am using VST to return some data off the Transaction Entry Zoom form.  The problem is that all lines return a line sequence of zero.  The Journal Enquiry form is fine as is the Journal Entry form.

This is what I am using to for return data;

string sourcedocument = Dynamics.Forms.GlZoomCurrentTransaction.GlZoomCurrentTransactions.SourceDocument.Value;
int journalnumber = Dynamics.Forms.GlZoomCurrentTransaction.GlZoomCurrentTransactions.JournalEntry.Value;
decimal lineseq = Dynamics.Forms.GlZoomCurrentTransaction.GlZoomCurrentTransactions.TransactionScroll.SequenceLine.Value;
int accountindex = Dynamics.Forms.GlZoomCurrentTransaction.GlZoomCurrentTransactions.TransactionScroll.AccountIndex.Value;

All data is returned correctly except for the sequence line, it is always zero - pretty critical for my solution and identifying the correct line.

Has anyone run into this problem before?  It looks like this is a problem on the Bank Transaction Enquiry Zoom also.

Thanks

 

Hola, Saludos a todos.

Se me ha solicitado un reporte muestre los artículos con menor venta dentro de un periodo determinado. uno de los parámetros es que se haya vendido menos de 72 unidades por mes o que no se haya movido en el mes. la fecha puede limitarse a un mes especifico, o aun periodo comprendido entre dos fechas.

La ayuda que necesito en en  la consulta SQL...

 

I have been asked for a report to show the least-selling items within a given period. One of the parameters is that you have sold less than 72 units per month or that you have not moved in the month. The date may be limited to a specific month, or even period between two dates.
The help I need in the SQL query...

 

saludos

When setting up a new vendor, the Tax Type automatically defaults 'Not a 1099 Vendor'. We need to change this to initially default to 'Miscellaneous' and '7 Nonemployee Compensation'. I am able to change the sort order of the Tax Type in modifier, but am having issues changing the 1099 box in VBA. Any assistance would be greatly appreciated. 

Hi,

Are there any ways to import blanket PO line items from a txt/csv/excel file into POP module in GP 2013?

Thanks

Paul Chacko

Hello,

Is there a GP Stored Procedure to add DOCID's to the SOP40200 table?  I'm integrating between GP and our current application.

I don't have GP on my machine.  I code between the 2 apps using GP Stored Procedures.  I can't seem to find one to create SOP40200 records.

Thanks in advance.

I am attempting to import a general journal entry via eConnect.  The entry should have a multicurrency rounding adjustment from a foreign currency to functional currency, but it is producing the error below.  When manually entering an entry in foreign currency, the additional round variance to convert to functional currency is automatically produced when clicking save.  The error below appears to be indicating that the taGLTransactionHeaderInsert stored procedure is the problem; however, it seems like the problem is with the taGLTransactionLineInsert procedure since it is not generating the extra rounding distribution.

Sql procedure error codes returned:
Error Number = 944  Stored Procedure= taGLTransactionHeaderInsert  Error Description = Unbalanced journal entry, the credits do not equal the debits
Node Identifier Parameters: taGLTransactionHeaderInsert
BACHNUMB = *BL_2497-DB
JRNENTRY = 885285
REFRENCE = Scoot Activity
TRXDATE = 09/27/2018
TRXTYPE = 0

<taGLTransactionHeaderInsert>
  <BACHNUMB>*BL_2497-DB</BACHNUMB>
  <JRNENTRY>885285</JRNENTRY>
  <REFRENCE>Scoot Activity</REFRENCE>
  <TRXDATE>09/27/2018</TRXDATE>
  <TRXTYPE>0</TRXTYPE>
  <CURNCYID>GBP-UK</CURNCYID>
</taGLTransactionHeaderInsert>
|Source:mscorlib|StackTrace:   at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateTransactionEntity(String connectionString, String xml)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String connectionString, String sXML)
   at BlackLineConnectorJEImportProcess.OBS_EConnect.SendToGP_GLTransactions(taGLTransactionHeaderInsert taGLHeader, taGLTransactionLineInsert_ItemsTaGLTransactionLineInsert[] taGLLineItems_List, String DBConn)

 

We have tried mapping the currency ID, line sequence number, and document date to taGLTransactionLineInsert, but the same failed results continued.  Please let me know if you have a work around or fix for this issue.

I would like to know what is the best practice in Great Plains to configure an accounting based in Cost Centers, do the Cost Centers have to be in the Chart Of Accounts or is there an specific table of Cost Centers?  
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