Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Monday, July 13, 2015

GP 2015 R2 Feature List - All in One View


This comes out as one of the most astonishing features introduced in GP 2015 R2, it provides an effective and efficient way of reviewing vendor-related documents in an easy, user-friendly and dynamic way. 

The theoretical concept beyond designing this window is to provide one central window to review vendor associated documents, including all purchasing documents; purchase orders, receipts, invoices, payments, return and credit documents.
 
All in One View - Purchasing Module
All in one view for the purchasing module can be reached from a various windows, which are:
  • Vendor Maintenance (Cards > Purchasing > Vendor)
  • Vendor Inquiry (Inquiry > Purchasing > Vendor)
  • Purchase Order Processing Document Inquiry (Inquiry > Purchasing > Purchase Order Documents) 
  • Purchase Order Processing Item Inquiry (Inquiry > Purchasing > Purchase Order Items)
  • Transaction by vendor inquiry (Inquiry > Purchasing > Transaction by Vendor)
  • Transaction by Document inquiry (Inquiry > Purchasing > Transaction by Document)
  • Navigation Lists:
    • Vendors
    • All Purchasing Transactions
    • Payable Transactions
    • Purchase Order Transactions 
In any of the windows above, there is a new icon added to the ribbon to open the All-in-one view for purchasing, an example is shown below for the payable transaction inquiry window,
All in one view - Icon (Action Pane)

In case the menu bar is activated instead of the action pane, the icon is illustrated as shown below:
All in one view - Icon ( Menu Bar)
 
Window Components
The window has a variety of components, which are all dedicated to provide a better user experience. These components are briefly illustrated below
All in one view - Details
1- Options:
This window gives you the ability to choose which document type to show within the window, you may want to create your custom view including only POs and receipts or payments ..etc.
Purchasing Options

2- Filter 
Each purchasing document tab has its own filter, through which you can consider specific search criteria to find specific documents. 
Filter 
3- Sorting Options
If you want to order the listed documents either in an ascending or descending way, these two arrows will do the sorting for each of the purchasing document types. 
Sorting Options
4- Dynamic View
When choosing a specific vendor, the view will retrieve all purchasing documents according to the search criteria. If you want to limit the view as illustrated in the example below:

               - Payments to specific PO
               - Receipts on a specific PO
               - Invoices on a specific PO
               - ....etc
 In such cases, the all in one view provides a dynamic capability to filter by a specific document, and the other document types tabs will be filter to show only the documents related to your original choice.

As shown below, choosing a specific PO will result with the following view:
Dynamic View
 5- More details
Each of the purchasing document has an arrow to show further more details within the view itself, this will provide a brief about any of the purchasing documents in case you do not want to drill down into another inquiry window.
More details


6- Flip through pages
The view shows only five documents under each purchasing document type, you may use the arrows of (Next and Previous) in the bottom of the screen to navigate through the purchasing documents. This can be done for each of the types solely


Best Regards,
Mahmoud M. AlSaadi

Wednesday, July 8, 2015

Document Attachment Error with GP 2015 R2 - "A Save Operation on table 'coAttachMSTR' has created a duplicate key error"


We have recently encountered an issue with GP 2015 R2 in the Document Attachment functionality, the case has been reported by various community members such as this case.
Symptoms
Users are not able neither to attach documents or to view attached documents. The issue is related to all Dynamics GP users except for 'sa' specifically, regardless of the security roles granted to the users. 

When attaching a new document, the systems responds with an error stating that "A Save Operation on table 'coAttachMSTR' has created a duplicate key error"
 
Save Operation Error when Attaching Documents

When a user tries to preview already attached documents, the systems responds with an error message stating that "Unable to preview this attachment"

Error previewing Attached Documents


Technical Perspective 
Tracking this error on the SQL profilers shows that this is mostly a dysfunctional issue related to all users other than 'sa', and the reason is not security since granting any of the users a "Sys Admin" just for the sake of testing doesn't resolve the issue. 


As retrieved from the SQL profiler, the 'sa' user is getting the attachment ID properly, and then getting it inserted into the CO00100 (procedure zDP_CO00101SI ),

-- The code below is retrieving the Attachment ID  
EXEC sp_executesql N'INSERT INTO coAttachmentItems (Attachment_ID, fileName, BinaryBlob) VALUES (@Attachment_ID, @fileName, 0x0) ',
    N'@Attachment_ID nvarchar(36),@fileName nvarchar(6)',
    @Attachment_ID = N'7e063e4d-4d5c-4c14-9337-70d0a15a337a',
    @fileName = N'12.mac'
go
    
-- The code below is inserting the record into CO00100 including the attachmentID    
BEGIN
    DECLARE @num INT
    EXEC FIVER.dbo.zDP_CO00101SI '7e063e4d-4d5c-4c14-9337-70d0a15a337a',
        '12.mac', '', 'sa', '2017.04.12', '03:12:37', 'IC', 0, 0, 0, '', 0,
        0, @num OUT
    SELECT  @num
END


On the other hand, the other test user is not retrieving any attachmentID, and the field is blank as shown below:

BEGIN
    DECLARE @num INT
    EXEC FIVER.dbo.zDP_CO00101SI '', '12.mac', '', 'USER15', '2017.04.12',
        '03:07:48', 'IC', 0, 0, 0, '', 0, 0, @num OUT
    SELECT  @num
END

As you see, the first parameter which is the AttachmentID is blank, and that's why the error is popping on the screen.

Solution

The case is currently reported to Microsoft support team on MSConnect and it has been marked as "Tracking", any further official responses will be provided immediately on this post. Meanwhile, you may review the report on MSConnect on this link


Best Regards, 
Mahmoud M. AlSaadi