Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

SOP Copy sales order lines - Preview Line Items

Posted on by 1,325

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

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: SOP Copy sales order lines - Preview Line Items

    Larry, have a look at the last paragraph in this article - support.microsoft.com/.../859923.  It appears there is a MSFT tool available to re-order line items in Sales Transaction Entry documents.  Contact your GP Partner for assistance getting this tool.

    Not sure anything exists for the RMA window - likely requires a customization.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans