Customization CR1449- POP Receipt Post SN Performance

Customization CR1449

POP Receipt Post SN Performance

Description of Need:

ACME has some serial numbered items in Dynamics GP that are purchased in very large quantities (such as 100,000).  During PO Receipt Entry the window verifies that each serial number does not exist in either the Serial Master or on another unposted transaction.   

 

During posting it again verifies that the serial numbers do not exist in the Serial Master (but it does not check other unposted transactions).  Because it performs the verification one serial number at a time, the posting process can take more than 40 minutes. 

 

ACME would like to reduce the amount of time it takes to post PO Receipts. 

Description of Solution:

The first option we considered, and tested, was to force the POP Receipt Posting process to skip verification of the serial numbers.  This could work and would be the fastest approach, however it would create an unlikely, yet possible, scenario where duplicate serial numbers are added to GP. 

 

The proposed approach is to modify the POP Receipt Posting process so that it performs a mass validation of POP Serial Numbers against the Serial Master.  This will be a single SQL query that checks for matching serial numbers between the POP Receipt Serials table and the Serial Master.  This approach retains the same data validation that Dynamics GP would otherwise perform one serial number at a time. 

In the unlikely event that a POP Receipt has a serial number that already exists in the SN master, the POP Receipt will not be posted.  An error code will be set on the POP Receipt Header that indicates “One or more line items contains errors.”  This error will print on the POP Receivings Posting Journal. 


This modification to the posting process will apply to Transaction, Batch and Series posting. 

Assumptions/Requirements:

  1. The functionality described above will not work with eConnect, any software that uses eConnect, or any software that directly writes to, updates, or deletes from SQL tables. 
  2. The functionality described above is intended for the GP Desktop client. 
  3. National Accounts functionality is NOT used. 
  4. Advanced Distribution functionality is NOT used. 
  5. Unless otherwise noted in this document, reporting is not included in this estimate. 
  6. Unless otherwise noted in this document, Word Template functionality is not addressed. 
  7. Unless otherwise noted in this document, the enhancement will not integrate with 3rd party products.  Some examples of 3rd party products would be: 
  • An ISV plug-in product including WilloWare products 
  • A dexterity customization designed by another developer 
  • Dynamics GP Modules including, but not limited to: 
  • Project Accounting 
  • MDA 
  • Analytical Accounting 
  • Copy functionality found in SOP, POP and Inventory 
  • Field Service 
  • Extended Pricing 
  • Manufacturing 

For Information on this customization, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/