another blog


About Microsoft Dynamics GP :-)

RE: Smartlist Error – Explorer_Get_DDL_Type not found

For Gp2013 SP2, we have option of Smart List Designer, so we can workaround for PA Status issue by using it.

First Create new view in your company database.


After that press button New, select Project Accounting in Product.Select Database view expand it and select the view we have created in SQL ‘Almas’ and also the Microsoft Dynamics project view PAProjects. Define the relationship as selected in below screen shots and save this new smart list.


Now filter as you wish.




Filed under: Dynamics GP, Project Accounting

Workaround of GP2013 SP2 SmartList error ASI_Get_DDL_Type_Master

Workaround of GP2013 SP2 SmartList error ASI_Get_DDL_Type_Master

‘ASI_Explorer_CriteriaSBM OK Button K_CHG on form ASI_Advanced_Search’

‘ASI_Get_DDL_Type_Master()’, 0, 258, 1, 258, 32208

Filed under: Dynamics GP, dynamics-gp, Project Accounting

Project data has not been entered for this customer.

When trying to create new contract for the customer ID ‘WORLDENT0001’, got following message.

“Project data has not been entered for this customer.”

To get rid of this message, go to customer maintenance window, browse the customer, open ‘PA Customer Option’ window through Project button. Just click “OK” and close the window, and it will allow entering contract for the customer. (Definitely if things need to be setup on PA customer option window then we will select options there). This window copy customer information on PA_Customer_MSTR table (PA00501).

That’s It.

Friday,14 Sep 2012

Project data has not been entered for this customer.

Filed under: Project Accounting,


Enter your email address to follow this blog and receive notifications of new posts by email.

Enter your email address to follow this blog and receive notifications of new posts by email.


Error: Twitter did not respond. Please wait a few minutes and refresh this page.

Blog Stats

  • 9,913 hits

RSS dynamics-gp

  • VSTools and database triggers.
    In SanScript coding we have database triggers, Below is a detail of what database triggers are as explained in dexterity manuals. Database triggers Database triggers are activated by successful table operations, such as a record begin read, saved, or deleted. The procedure that runs in response to a database trigger has access to the same […]
  • Getting the current active window in Dexterity.
    Using dexterity there is not a direct way of getting current active window information, but with set of available GP functions and triggers can make this task happen. Below I am sharing a trigger and function which can tell the active window name. Below code needs to be changed according to the needs of developer, […]
  • Hints and Tips… On going Post
    This is on going post and points will be added from time to time. 🙂 .. with Field Level Security we can not restrict document access on Sales transaction entry Window. Means we can not make user to choose only ‘Invoices’ in SOP Type drop down. .. we can not add custom table in table […]
  • Reversing the sort order of Receivable Transaction Inquiry – Customer by Document Date
    Last few months we got more request on changing sort orders of Inquiry windows and lookups and to cover them all in a one place I have been working on a small project which will provide a simple sorting without much effort. In Dynamics Community there was a post having similar situation, I have already […]
  • Getting the current open window in .net GP Add In
    There are many ways of getting information of active window in GP, but it changes according to the developing tool we are working on. 1.Dexterity.(the best tool 🙂
  • Not all RW_Function are meant for reports.
    There are lots of RW functions available in a report writer Calculated Field Definition window and almost all of them are so handy while working on report writer, but it is a matter of fact that some of them are not actually meant for report writer. Usually RW functions are associated with report writer and […]
  • Dexterity Can Wait and Respond.
  • Cross Dictionary Development.    
  • Calling Sales Document Numbers Lookup
    Often developers need to open available lookup on their custom form from dynamics GP.Sales Document Number lookup is a very common and much used lookup and every dynamics technical person needs to call it in once (or more) in their lifetime. 🙂 Dynamics GP SDK provide a prototype of coding on how to open various […]
  • This datatype name is already in use.
    This datatype name is already in use.
Ghostriver Studios Blog

Sculptural stained glass of Andrew Kosorok

Coding Notes

Code, News, Tech & Stuff

Dynamics GP Builders & Reporting

How to use MS Dynamics SmartList Builder, Excel Report Builder and other Reporting tools to get the data and analysis you need.

%d bloggers like this: