We use the SOP “Copy a Sales Order” and the related “Preview Line Items” windows to select and copy invoice lines in the creation of sales Return documents. Our sales orders and invoices are created in custom (Non-GP) applications and then they are integrated into GP. The order of the lines on an invoice is the order in which they are created during order entry while a CSR is on the phone with the customer. This order is almost always not alphanumeric by item number. The order of the lines as they are presented for selection to copy from the invoice to the return document is based on SOP30300 – LNITMSEQ. The source for LNITMSEQ is populated in our custom order entry application as lines are added to an order. It is later mapped to LNITMSEQ during order and invoice integration with GP. So, when we are creating a return document and there are many pages (many dozens) of lines on the Preview Line Items window and they are not in item number sequence it can be rather time consuming to find and select the items to add to the return document. The same problem exists with creating RMA return transactions in Returns Management RMA Entry / Update “Sales Invoice Return Item Selection”.
It seems to me that it would be a common business practice to capture order lines with or without GP in a random item number sequence. I’m wondering if other GP customers have encountered this type of issue and how they have resolved it. It is my understanding that there is no sort by item number feature on the “Preview Line Items” and the “Sales Invoice Return Item Selection” windows in GP 2010 or GP 2013.
Thank you.
Larry
*This post is locked for comments