Public Profile
  • PTE Timesheet Report prints 0 hour days on Edit List.

    PTE Timesheet Report prints 0 hour days on Edit List. It would be nice to exclude the 0 hour days by default, although there is a package file you can download as a workaround already on the new feature blog for this. https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/07/12/microsoft-dynamics-gp-2016-addition-of-edit-list-reports-to-pte-entry-windows
  • eConnect and Vendor Workflow

    As of now, if you have your Vendor Workflow turned on, you cannot update Vendors information through eConnect. You will receive a message saying that this must be done through the front end in Microsoft Dynamics GP. Adding logic to allow updates through eConnect to Vendors even with Workflow turned on, would be a great addition to eConnect. Essentially the only way to get through this is by turning the Workflow off, then updating the vendors and turning it back on, but then you also have to make sure you set the workflow status back to what it was or else it will come in as a 0 which is invalide. PRE PROC Update WF100002 Set Active = 0 Where Workflow_Type_Name = 'Vendor Approval'; if exists(select VENDORID from PM00200 where VENDORID = @I_vVENDORID) begin select @I_vUSRDEFND1 = (Select Workflow_status from PM00200 where VENDORID = @I_vVENDORID) End Else Begin select @I_vUSRDEFND1 = 1 End POST PROC Update WF100002 Set Active = 1 Where Workflow_Type_Name = 'Vendor Approval'; update PM00200 Set Workflow_Status = @I_vUSRDEFND1 where VENDORID = @I_vVENDORID I tested this in my environment and it worked for me.
  • Add the Ability to Cancel Purcahse Orders with Project Accounting data that originated from Requisitions

    If the requisition is also committed to a Project\Cost Category it cannot be cancelled, deleted or Voided. This is noted in our new feature blog and new feature documentation for GP 2016 R2. As of this time, this is not a feature that we have available in GP. Users would like to have this ability so that they are not stuck with an Open PO that they do not want to receive against. https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/12/14/purchase-order-processing-cancel-purchase-order-when-linked-to-a-requisition-amp-visual-indicator-if-quantities-not-fulfilled
  • Add the Ability to Cancel Purchase Orders with Project Accounting data that originated from Requisitions

    If the requisition is also committed to a Project\Cost Category it cannot be cancelled, deleted or Voided. This is noted in our new feature blog and new feature documentation for GP 2016 R2. As of this time, this is not a feature that we have available in GP. Users would like to have this ability so that they are not stuck with an Open PO that they do not want to receive against. https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/12/14/purchase-order-processing-cancel-purchase-order-when-linked-to-a-requisition-amp-visual-indicator-if-quantities-not-fulfilled
  • restrict the Voucher Number field to not allow special characters

    The Voucher Number field allows the user to enter special characters in it. There are no repercussions until later when the user tries to run the HATB report. Then they will receive SQL Errors. If GP is not designed to handle this, then I think there should be a restriction on what is allowed on the Voucher Number field when the user is entering the data. SQL Error: "Unclosed quotation mark after the character string ‘ and DocumentType = 6’ Incorrect Syntax near ‘XXXXX’"
  • Mass Item Vendor Assignment

    We already have a mass assignment for Sites but customers may change which vendor they purchase their items from often depending on the price at the time. It might be 100+ items that the user is now going to be purchasing from a different vendor and as of now unless you use eConnect or and integration, you would have to do it 1 by 1 for each vendor to assign them to the items which can take hours.
  • PM Reprint Journal is blank when restricting by Posting Date and doing transaction level posting (without a batch)

    This looks to be pulling from the GLPOSTDT field in the PM80100 table. If you post at transaction level without a batch, then the GLPOSTDT in this table is 01-01-1900. This would have been normal prior to GP 2018 R2 but in GP 2018 R2 we added a feature to be able to Post Through GL at the Transaction Level. Microsoft Dynamics GP 2018 R2: Transaction Level Post Through General Ledger - Microsoft Dynamics GP Community In order to make this work with this new feature we would also have to add the GLPOSTDT to the PM80100 which GP never has when posting without a batch.
  • Keep Vendor Information up on the screen when recalling them with new Workflow Changes

    When a new change is made on a Vendor record who has already been approved, it must be Recalled, which makes sense. However, when you recall the Vendor Record the window clears so you must look the vendor back up in order to resubmit the Vendor through workflow for approval. This creates multiple extra clicks and is time consuming for users who are making address changes multiple times a day and submitting those changes through workflow. It would be nice if when you clicked the Recall button, the Vendor Maintenance window refreshed with the same Vendor so that you can resubmit the change without requiring all the extra clicks.
  • Allow Contra Account for Costs to be sourced to Vendor in Project Accounting

    Currently Microsoft Dynamics GP will only allow the Contra Account for Costs to be sourced to the Item. Some businesses require this to be sourced to the Vendor, but that is not allowed in the user interface and will cause errors if you try to update it in the backend in the PA01301 table to be sourced to Vendor.