Got a call today about a SQL Server 2008 R3 machine where the SQL Services would not start. 

Research lead me to this:

Below is what I saw and how it got fixed. 

Today when setup up a VS Tools project, I encountered the error

Type not found MrpSetupCompositeData

When trying to run DAG.exe

The simple answer is below

I have library code on this site to parse text files using the .NET TextParser library


But today's task is a little different, the file had variable lengths. The code sample below introduces a variable then setting the line lengths to solve the problem

This is a working piece of code that shows how to use an eConnect stored procedure to get the next PM Voucher, Payment, or Alignment number. 


This is working SQL code that wraps the eConnect taPMTransactionInsert stored procedure and makes it a little easier to call

A scalar function returns exactly one value, unlike a 'table function' which returns a ... table. 

This is our template for the scalar function. We ( are professional consultants and work at customers across the country. It's convenient to have these templates on the internet to be able to easily access them and get to coding.

"Doesn't SSMS have templates?" you ask. Of course it does. But ours are better, cleaner, quicker. Easier to access. 

A request came in today to create a scalar function that would accept a date parameter and return the fiscal period end date for the date provided, the code is below. 

On the way to create this, I discovered that we didn't have a 'scalar function template' on this site, so I created that too.


I'll often open up an application locally to choose a color for an application that I'm working on.

Please let me make it clear that I'm not a 'graphics person', I'm a coder. I don't have that bent. 

So, choosing a color is something that I have to work on. 

Below is the code to default the date parameters, and I link to a step-by-step video that shows you how to do it. Enjoy

It seems that every day I get a call to do something new. 

Today's newness is this: The client is in the habit of writing returns that have the same document number as the corresponding invoice. In practice, most invoices have a small return. 

These are all sitting in the RM Open table, unapplied. Lots of them. 

Task: Create a stored procedure that will search the RM20101 (RM Open) table and return all matching unapplied credits and invoices, and then automatically apply them. 

Care to comment on my approach? Can you improve the code?

The working stored procedure is below, fully commented. 

So, the problem is that you have a grid that scrolls off the page, when you click on a grid like to enter edit mode the page posts back and you have to scroll down to do the editing. 

(sigh) using the Telerik ASP.NET grid in BATCH edit mode can be challenging. 

Below is a working example...


Good evening,

I try to “Release” in the Transactions/Assembly Entry but GP generate this error

“No Valid, Active Components exist for this bill of materials. The process can’t be completed.”

Any suggestion is welcome.

Thanks a lot,

Mr. García

I have an SSIS package with VB .net code in it to import purchasing receipts in GP2016. Package runs fine.

I am now been assigned to create one for creating new items in INVENTORY. While i was dabbling with documentation and other resources, I found the encrypted stored procedures for eConnect. Rather than writing .net code, I realized I could just make calls to eConnect SP taUpdateCreateItemRcd and create the items by passing the required parameters to this stored procedure. 

Questions are:

1) Am I correct in assuming this process to create items?

2) How is the result different calling SP directly rather than creating XML and passing it to the .net Classes?

3) Could I have used the appropriate SP for importing the purchasing receipts also?

Good afternoon,


Every time that an user open the window: SOP_DOCUMENT_LOOKUP for the first time that message appear: ASI_EXPLORER_FAVORITES FAIL

She can use others windows without problems.


I have a report that has several parameters, including the start and end date.  It is a monthly report that I want to produce with a subscription.

It will run on the 3rd of each month and the data it's looking for is always for the previous month.

Best way to have it calculate the start and end dates without user intervention?


Example:   Report will run on May 3, 2018.   I want the start date to be April 1, 2018 and end date April 30, 2018.

The report will run again on June 3, 2018.   Start date = May 1, 2018   End date = May 31, 2018



Hi, I greet everyone. A user has found that their order indicates "Open by another user" and apparently no user has the contract open. there is some SQL QUERY that allows me to identify who has the order open or because GP indicates that it is open
I am trying to create either a SmartList or an Excel Builder file that will report back all sales lines entered in the CURRENT month regardless if they have shipped or are still on backorder.  Thoughts?

Looking to submit our Invoices via type of Straight Thru Processing where Finance can load these unposted batches via the GUI batch number and then post them.

Right now, able to use taGetPMNextVoucherNumber to get next ID, and able to use taPMTransactionInsert to create rows in both the PM10000 – Work/Unposted Transactions

PM10100 – GL Distributions for Work and Open Transactions tables.   But Finance is not able to find these to post via the GP GUI.   I've not found any stored proc that allows my to create a "PM Batch" so the GUI can see them.  Is what we are attempting possible?  If yes, what step(s) am I missing.  If not, what alternatives exist?

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