Adding Customer Item User Defined fields to SOP Invoice
Mariano Gomez published an excellant article which explains the entire steps to add customer item user-defined fields to SOP invoice. The article is very detailed and very useful for developers. Mariano used Support Debugger Tool to deliver the solution and this demonstrate the power of SDT.
Click here to read Adding Customer Item User Defined fields to SOP Invoice
May 9, 2012
· 
Samuel Mathew · 
No Comments
Tags: Dynamics GP, Sales Order Processing, SDT · Posted in: Customization, Dynamics GP, General, GP 2010, Sales Order Processing, Support Debugging Tools
SQL view for unpaid SOP Transaction with No. of overdue days
Recently one of my customer asked me to create a script to shows all open (unpaid) sales transaction with the total number of days overdue based on the current system date and customer’s payment terms. Customer also wanted to see a column that shows the estimated payment date based on the actual payment terms and the posting/actual ship date.
The view below links SOP30200 (SOP _HDR_HIST – Sales Transaction History) and RM20101 (RM_OPEN – RM Open File) and SY03300 (SY_Payment_Terms_MSTR – Payment Terms Master). The overdue days is the difference between the current date and the GLPOSTDT (GL Posting Date) or ACTLSHIP (Actual Ship Date). The “Estimated Payment Date” is calculated by adding the DUEDTDS (Due Date in Days) from SY03300 table with the GL Posting date or actual ship date.
CREATE VIEW view_unpaidsoptransaction_with_overdue
AS
/*
Created Date: 05/08/2012
Created by Samuel Mathew - Eclipse Computing
Tables Used:
SOP30200 : Alias= SH | SOP _HDR_HIST - Sales Transaction History
RM20101 : Alias = RO | RM_OPEN - RM Open File
SY03300 : Alias = PT | SY_Payment_Terms_MSTR - Payment Terms Master
*/
SELECT CASE SH.SOPTYPE
WHEN 1 THEN 'Quote'
WHEN 2 THEN 'Order'
WHEN 3 THEN 'Invoice'
WHEN 4 THEN 'Return'
WHEN 5 THEN 'Back Order'
WHEN 6 THEN 'Fulfillment Order'
END AS SOPTYPE,
SH.SOPNUMBE,
SH.CUSTNMBR,
SH.CUSTNAME,
SH.GLPOSTDT,
SH.DOCDATE,
SH.ACTLSHIP,
SH.ReqShipDate,
SH.CSTPONBR,
SH.MSTRNUMB,
SH.DOCAMNT,
SH.ORDOCAMT,
SH.CURNCYID,
SH.PYMTRMID,
PT.DUEDTDS,
RO.CURTRXAM AS [Current Balance],
CASE SH.ACTLSHIP
WHEN '01/01/1900' THEN Dateadd(day, PT.DUEDTDS, SH.GLPOSTDT)
ELSE Dateadd(day, PT.DUEDTDS, SH.ACTLSHIP)
END AS [Estimated Payment Date],
CASE SH.ACTLSHIP
WHEN '01/01/1900' THEN Datediff(day, SH.GLPOSTDT, Getdate())
ELSE Datediff(day, SH.ACTLSHIP, Getdate())
END AS [Over Due]
FROM SOP30200 SH
INNER JOIN SY03300 PT
ON SH.PYMTRMID = PT.PYMTRMID
INNER JOIN RM20101 RO
ON SH.CUSTNMBR = RO.CUSTNMBR
AND SH.SOPNUMBE = RO.DOCNUMBR
WHERE ( SH.SOPTYPE NOT IN ( 5, 6 ) )
AND ( SH.VOIDSTTS = 0 )
AND ( SH.DOCAMNT > 0 )
AND ( RO.CURTRXAM <> 0 )
go
/*
Grant permission to this view to DYNGRP
*/
GRANT SELECT ON view_unpaidsoptransaction_with_overdue TO dyngrp
May 8, 2012
· Samuel Mathew · 3 Comments
Tags: Dynamics GP, Receivable, Sales Order Processing, SQL Script, SQL Server 2008 · Posted in: Accounts Receivable, Dynamics GP, Sales Order Processing, SQL Server, SQL Server 2008
Consultant’s Tool Box
I have included Siva’s Dynamics GP 2010 R2 Database SDK in my “Consultant’s Tool Box” section. 
You can access the Consultant’s Tool Box form the “GP Resources” menu option in my blog.
March 29, 2012
· Samuel Mathew · No Comments
Posted in: Dynamics GP, General, GP "12", GP 2010
Dynamics GP 2010 R2 Database SDK
Sivakumar, MVP at Interesting Findings & knowledge Sharing launched Dynamics GP 2010 R2 database SDK. This is an awesome tool and definitely a good item for consultants tool kit. This database SDK provides information about Microsoft Dynamics GP 2010 R2 database objects such as Tables, Views, Stored procedures etc. Currently he only published Dynamics System database SDK and he is working on the company database SDK.
Great Job Siva, you are truly a MVP.
Click here to read Dynamics GP 2010 R2 SDK.
March 29, 2012
· Samuel Mathew · One Comment
Posted in: General
Automatically Generate Purchase Orders in Microsoft Dynamics GP
Christina Philips at Dynamics GP insights explains��step by step process to automatically generate PO in Microsoft Dynamics GP. In her article, she explain the three easy steps to provide you the suggested PO based on your inventory setups. This is a very useful artcle.
Click here to read Automatically Generate Purchase Orders in Microsoft Dynamics GP
February 21, 2012
· Samuel Mathew · No Comments
Posted in: Dynamics GP, GP 2010, Purchase Order Processing
Microsoft Convergence 2012, Houston, TX
Eclipse Computing will be showcasing our premier products Royalty and Rights Management System for Microsoft Dynamics GP at Expo Booth # 1451. Eclipse Royalty & Rights Management System is the only comprehensive and integrated solution designed for Microsoft Dynamics GP.
Convergence will be held in Houston, TX from March 18th through 21st. Convergence is the largest event for Microsoft Dynamics community. Please don’t miss this event.
To learn more about our product.. Please visit Expo Booth # 1451 and ask for Joe Lerro or Samuel Mathew
February 1, 2012
· Samuel Mathew · One Comment
Posted in: General
Top Reasons to Attend Convergence 2012
Roger Borek of Borek Business Solutions explains top 8 reasons to attend convergence 2012. You must read this, he got some interesting points. If you haven’t registered for convergence, it’s not too late. To register visit Convergence website
Click here to read Roger’s article published in ERP SoftwareBlog
Until Next Post–
February 1, 2012
· Samuel Mathew · No Comments
Posted in: General
Client Version Tracking for Microsoft Dynamics GP
Willoware just annouced adding a new tool Client Version Tracking (CVT) into their GP Power Pack (It’s FREE). Client Version Tracking displays the version information of every dexterity module installed on each GP client. CVT can ensure that GP clients with version conflicts are not allowed to log-in to GP. CVT also displays the dictionary pathname information for each client so you can identify clients that are not pointed to shared reports and forms dictionaries.
See more here: http://willoware.com/products/gp-powerpack/#clientver
For more information about Willoware product contact ddrea@WilloWare.com
January 19, 2012
· Samuel Mathew · One Comment
Posted in: Dexterity, Dynamics GP, General, GP 2010, System
Optimizing and Maintaining Performance for Microsoft Dynamics GP® 2010
Microsoft Dynamics GP support and escalation team published a new whitepaper to better understand, optimize and maintain Microsoft Dynamics GP 2010. I have downloaded and read the document. I must say that this is a must have document for all consultants. This definitely a document in my GP tool box along with “Microsoft Dynamics GP 2010 Cookbook by Mark Polino” and “Microsoft Dynamics GP 2010 Implementation 2010 by Victoria Yudin”.
Click here to downlod (login required)
January 16, 2012
· Samuel Mathew · One Comment
Posted in: Dynamics GP, General, GP 2010
Support Debugging Tool Build 16 released
David Musgrave released Support debugging tool build # 16 and the new release is available to download form partnersource. This release comes with over 50 changes and it’s an awsome application for all GP consultants.
Check it out Support Debugging Tool Build 16 released
January 11, 2012
· Samuel Mathew · No Comments
Posted in: Customization, Support Debugging Tools
