Monthly Archives: April 2015

Adding a “Go To” with SmartList Builder

With standard SmartLists in Dynamics GP, you can double-click on a record to access a related window, or you can use the “Go To” button in the upper right-hand corner to access additional related windows for the selected record. However, … Continue reading

Posted in Uncategorized | Leave a comment

How to use a SQL view in SmartList Builder

STEP 1  –  create SQL view To start we need a  SQL view.  I have published a number of views for getting GP data, so I will use one of my favorites – Payables Apply Information.  You can see the list … Continue reading

Posted in Uncategorized | Leave a comment

Types of way to integrate data in to GP System

sandipdjadhav.blogspot.ae/…/types-of-integration-method-with.html

Posted in Uncategorized | Leave a comment

POP Document Inquiry listing all Shipments and Invoices and Retruns

We had problem in scrolling window like its listing only Shipments BOL number  not as Invoices  BOL Number.This issue was resolved through Dexterity. Soluion: l_sResults[1] = “”; sQuery = “SELECT USER_DEFINED_TEXT01 FROM POP10306 WHERE POPRCTNM like ‘%”+ trim(‘POP Receipt Number’ … Continue reading

Posted in Uncategorized | Leave a comment