Category: Sales Order Processing
Price Level Defaulting in SOP Entry
Recently, I was handling a support case, where the user raised an issue in the way the Price Level was defaulting in the Sales Transaction Entry window line. The issue is explained below. “I have a client whose standard pricing doesn’t seem to be working as expected, or at least as I thought it should. [...]
Add Item option in POP and SOP
There are many little options in Dynamics GP which goes unnoticed most of the time. One such option is the Add Item option which is available under Options menu in the Sales Transaction Entry window. So when the user enters a line item number which does not exist in the system, if this option [...]
Selling Options in Item Price List Maintenance
I was recently assisting a customer who was getting the following error when trying to enter a quantity in the Sales Transaction Entry window for a specific item. This message is because of an Selling Option setup which is defined for the specific item and unit of measurement in the Item Price List Maintenance window. [...]
Support Debugging Tool Customization #5 – Unapplied Credit on SOP Blank Invoice
Another request that came in on the support forum was to add the posted and unapplied credits for a customer on the SOP Blank Invoice for reference purposes. I have decided to post a customization code using Support Debugging Tool to achieve the same so that it will benefit the community. Version Information Dynamics GP [...]
Support Debugging Tool Customization #4 – U Of M Long Description on SOP Invoice
A recent support request was to add the U Of M Long Description on the SOP Blank Invoice Report. The situation explained was that the U Of M was just an abbreviation and the client was using the U Of M long Description to capture a meaningful description in the Unit Of Measure Schedule Setup [...]
Nice Features for Auditing Information in GP
Hi all I read the recent article posted by Vaidy titled Sales Quote Line Item Cancellation, where he explains the use of the Qty Canceled field and how it helps the companies to track the actual quote and details of the canceled item, rather than deleting the line item completely. As a follow-up article for [...]
SQL Query – Sales Accounts Due Report
Hi all In this article I have posted the SQL query for generating the Accounts Due report in the sales module. SELECT B.CUSTNMBR , B.CUSTNAME , A.DOCNUMBR , C.DOCDESCR AS DOCTYPE , C.DOCABREV AS DOCTYPEABB , A.DOCDATE , A.DUEDATE , A.ORTRXAMT , CASE WHEN A.RMDTYPAL <= 6 THEN A.WROFAMNT + A.DISTKNAM ELSE 0 END AS [...]
Loading ...