Tag: sql server

Tech Tuesday: How to Perform a SQL Trace to Debug eConnect Errors

This week’s Tech Tuesday article is from our Support Guru, David Youngquist, who will walk you through how to perform a SQL trace to debug eConnect errors.  1. Find out what user the eConnect service is running under

Continue Reading

Modified SOP Entry window

| 08/20/2014 | 0 Comments

The SOP Entry window pictured above has been modified to bring the Description up to the first line. This made the window quite wide, but my goal was to get as much of the description visible as possible. The expanded view looks almost the same as the original, except I added the Item Code field as can be seen below: If you would like a copy of this modified window for yourself, you can download the package file containing this window here: https://app.box.com/s/z2sujz9pu62jbybhxb4b This is a GP2013 R2 window

Continue Reading

ARABIC & ENGLISH Amount in Words for Excel

| 08/13/2014 | 0 Comments

5 years back I have published a script that allows you to view amount in words in Arabic, what we call it “TAFQEET”, the article is published under the following link: http://mohdaoud.blogspot.com/2008/10/convert-numbers-to-arabic-words-tafqeet_5647.html I been getting many requests across the years on how to make this works for Excel and my answer was always that you cannot make it as it is an SQL based function and not a VBA. This morning I have see a comment sharing me a video that shows how to make a simple VBA script to achieve the ENGLISH amount in words and the video is below: https://www.youtube.com/watch?v=fYAxYtzBi5A Moving forward I decided to make the same for ARABIC language considering that I have a script that works on .NET does the same and all what I need to do is to make this works for Visual Basic for Applications and the result is below: 1. Download the function from the following path: http://www.di.jo/files/DI.bas If that file was viewed and not downloaded, please right click and click “Save Target AS”.

Continue Reading

Modified RM Aged Trial Balance–Summary

| 08/06/2014 | 0 Comments

The RM summary aged trial balance is too busy.

Continue Reading

Modified Payables Transaction Entry Distribution

| 08/06/2014 | 0 Comments

I modified the Payables Transaction Entry Distribution window so the Account Number appears on the first line of the scrolling window. I also added the Currency ID field to the second line of the scrolling window because the second line looked pretty desolate and  needed something else

Continue Reading

Applying Security to Record Notes

| 08/05/2014 | 0 Comments

Quite often, users want to apply Field Level Security on the Notes windows. Since the whole company shares the same four Notes windows, you really can’t apply security to the windows themselves

Continue Reading

Use Tax due because Inventory was used by the company

| 08/03/2014 | 0 Comments

I had a question recently asking me if there was an easy way to record Use Tax that becomes due when inventory is used by the company. There are several existing methods to record Use Tax if you know it is due at the time of purchase, but this question applied to an existing inventory item, so those techniques are not useable. Using the procedure below will allow you to record your use tax as well as tie it back to the inventory items you put in use

Continue Reading