RSSCategory: Sales Order Processing

Price Level Defaulting in SOP Entry

| 11/20/2011 | 3 Comments
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.  […]

Continue Reading

Add Item option in POP and SOP

| 09/28/2011 | 3 Comments
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 […]

Continue Reading

Selling Options in Item Price List Maintenance

| 08/12/2011 | 2 Comments
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. […]

Continue Reading

Support Debugging Tool Customization #5 – Unapplied Credit on SOP Blank Invoice

| 08/09/2011 | 2 Comments
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 […]

Continue Reading

Support Debugging Tool Customization #4 – U Of M Long Description on SOP Invoice

| 08/08/2011 | 4 Comments
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 […]

Continue Reading

Nice Features for Auditing Information in GP

| 06/26/2011 | 1 Comment
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 […]

Continue Reading

SQL Query – Sales Accounts Due Report

| 11/06/2010 | 3 Comments
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 […]

Continue Reading