Customization/Work Inquiry

I am a Dynamics GP freelancer, and can assist you in your Dynamics GP related task. 
I can manage, provide support, research problems, recommend solutions for your problem. Feel free to contact me and discuss requirements.

How to verify inactive employee on Time Card Entry Window.

 A small VS Tools customization to handle entering of inactive Employee on Time Card Entry window.



Inspiration: GPUG Post

Cash Receipt Window: Stop user to delete receipts.

Requirement: 

We are looking for a way to disable the “Delete” functionality on Cash Receipt Entry window, like when closing the window a message pop-up asking to save or delete the receipt will not allow user to select delete. From field level security I had already disabled “Delete” button. But for pop-up notifications I am unable to block it. Can we do any customization for this ?


Solution: Small customization was done for blocking the delete functionality for certain users, users will not able to delete cash receipts and need to save the changes for existing cash receipts. Users with disabled functionality was identified by user class id assigned to users.

Estimated Time: 10 Hours.



 

Sales Transfer Document , Include Total and Deposits

 

Requirement: To mark 'Include Totals and Deposits' check box when Transfer to Invoice selected. Solution: Small AddIn developed in VStools.

Price: 100 USD







Example: How to Open URL from .Net from inside of Dexterity Code.

After Adding Library references. Use below code.
using System;
using System.Text;
using System.Diagnostics;
using System.Diagnostics.Process;


local ProcessStartInfo psi;
local text url;
local Process OpenUrl;


OpenUrl=new Process();
psi=new ProcessStartInfo();
url= "www.google.com";
psi.UseShellExecute = true;
psi.FileName= url;


OpenUrl.Start(psi);
Edit: To add error message and screenshot of stackoverflow.

Auto calculate the backorder qty on a sales order.

Recently I got a modification request where user wanted to Auto calculate the backorder qty on a sales order. as they don't wish to calculate the backorder qty on partial shipments. The example they come up with have Sales Order with line item of 100 pcs, ship 20 pcs, 80 pcs should be the calculated backorder. the next time item needed to ship (Order Qty) is 20 pcs so they want backorder qty to auto calculate to 60 At this point user can also partially transfer order to invoice. For this requirement we come up with a solution, to add a field 'QTY Ship' on sales transaction entry window. User need to enter the Ship qty and on saving order it will automatically calculate the back order quantity. To cover the functionality of auto calculation of back order quantities the functionality was added on Save button, Transfer button and print button, as user can print and transfer order to invoice any time. For this eConnect was used to keep the business logic correct.



-- Link back to similar customization --
Quantity update issue with eConnect
eConnect and SOP10200.QTYTBAOR and SOP10200.QTYPRBAC

Issue with Vendor Check Name on Payables Payments Zoom Window.

Issue with Vendor Check Name on Payables Payments Zoom Window.

Issue Detail: This Community Post

My Observations:

I able to replicate the issue explained in this post, But I also find vouchers in PM30200 table without vendor check number.

So we have two issues, as below.

1. Vendor Check Name is in table PM30200 but the window is showing vendor check name from vendor card instead of the one user posted voucher with.

2.On posting vendor check Name is not updated.

My work around for issue 1 is attached here, a dll file, copy it inside GP AddIns folder , if there will be record inside PM30200 it will show it on Zoom window.

 Download file here

Another eConnect task for Payable Transaction Tax Assignment

 This task was totally related to addressing clients needs and their wish to handle it in this way. They were creating  payables transaction from external application with taPMTransactionInsert , Issue was the unavailability of functionality for assigning the corresponding tax detail as eConnect don't offer anything related to this. Since GP tax assignment functionality is extremely complex so after thoughtful analysis they come up with a solution with setup and some fixed tax schedule ids to calculate the tax amount and update in table while calling eConnect.



eConnect Vendor EFT Bank information

Here comes quick write up for another eConnect related task.  

It is a GP integration using eConnect to update a vendor record.  Our initial design is to expose the eConnect object to Microsoft Power Automate (Flow) using a REST web service.  So basically, we are looking for help in setting up the integration using Power Automate, mapping the fields to the eConnect, and most likely writing custom eConnect objects as not all fields will be available.  Specifically, the ACH info on the vendor record I don’t believe is available.


So I provided them with custom code for creating vendor EFT Bank info while creating or updating vendor via taUpdateCreateVendorRcd. 
contact me if you need my assistance in similar kind of work. :)







I can help you with your eConnect task

This article is about small but significant task of working on eConnect script for a client's existing external application. Below is the flow of their process.


After the invoice being created in the external application, eConnect was leveraged to create the payable transaction. For this they already used eConnect and have a huge amount of coding for various business rules and then creating Payables Document in GP.

But then Client wants the PURCH account to come from the integration but the PAY account to default using GP defaults setup checking first for vendor setup and if not found account setup there then looking for posting setup.  These accounts are illustrated on the diagram below:




If you also need my help for similar kind of task let me know! :)


Keep Calm and "Let me" Sort Out your Dynamics GP Windows


There are many times I saw people asking on different forums and communities about possibility of sorting various Dynamics GP windows. 
Sometimes by using out of the box functionalities it's possible to manage the sorting option and sometimes small modifications are needed, but there are also time when one need to have some coding to get the desired result. At this point various tools and ISVS are suggested as alternate options to avoid coding and customization. But it's not always very economical to go for such tools. I have done dozens of sorting on various Dynamics GP windows, listing down here so if anyone is interested to have me do it for them, contact me
I do all the customization work in very reasonable hourly rate. 
    
2. Item Serial Number sorted for selection.
3. Manufacturing Travelers Report Components. Printing with sequence number and not a position number.
4.Sorting Sales Invoice by Item Class: This is certainly possible to do so, and if you really looking for a solution do connect with me to discuss this solution cost and support.
5.Apply Sales Document Window, sort scrolling window by Due Date.
More reports and window names will be added here.