Open Forum

Expand all | Collapse all

Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

  • 1.  Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

    Posted 02-06-2017 11:29 AM
      |   view attached
    Saw a question about returns on the discussion board. I had written this up for a client last year and decided to clean it up and make it into a tip.

    I know a lot of companies that do not properly use Returns. My philosophy is use Sales Transaction Returns for all transactions that affect something that originated as a Sales Order Processing Invoice. The reason: you can easily compare Sales Transactions for Invoices vs. Returns. You cannot easily compare Sales Invoices (especially at the line level) vs. AR Credit Memos.

    The very absolute worst thing to do is use the AR "Posted Transactions" window to void a SOP document!! This does not properly update Inventory or all GL Accounts from the SOP document!!

    Let me know what you think.


    ------------------------------
    Amber Bell
    Owner
    Training Dynamo LLC
    Derby CT
    ------------------------------


  • 2.  RE: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

    Posted 13 days ago
    This document is very nice. Can you possibly clarify the "best" way to create a return for items that were ordered on a PO tied to a Job or Work Order? I know that crosses over in to other areas but we are searching for the best way to complete a return and do it at the original cost versus having different originating invoice cost and return cost.

    ------------------------------
    Jeremy Freeman
    Petroleum Solutions Inc.
    San Antonio TX
    ------------------------------



  • 3.  RE: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

    TOP CONTRIBUTOR
    Posted 12 days ago
    Jeremy,
    Regarding cost, If you do a  SOP Return the way Amber shows, then the unit cost of the returned item will be sourced from the linked sales Invoice, even if the invoice was 2-3 years old. If you do not link the Return to its originating Sales Invoice, then the cost will default as the Items Current Cost. That value though can then changed based on the items valuation method and user input.

    If you need more sophisticated customer side Returns such as tracking Awaiting Receipt, Received, Ready for Repair, Return to Vendor, Closed etc, then you move to the GP Returns module for RMA which also supports RTV (Returns to Vendor).

    The approach shown by Amber is to link a new customer side SOP Return to an existing posted SOP Invoice. It expedites the process and creates a good audit link.
    The other methods get beyond the scope of this thread so I'll stop here.

    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------



  • 4.  RE: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

    Posted 10 days ago
    My inquiry is specifically in regards to a Purchase Order that is created with the material directly tied to a service work order or job. The inventory is then essentially treated as a pass through so we have a receipt but I don't believe we have an actual invoice to reference. We are a Key2Act user and that seems to be part of the issue. We basically are looking to remove material from the job or work order which I believe has to be done via a Sales Order Return. Hopefully that clarifies a little?

    ------------------------------
    Jeremy Freeman
    Petroleum Solutions Inc.
    San Antonio TX
    ------------------------------



  • 5.  RE: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

    TOP CONTRIBUTOR
    Posted 10 days ago
    Thanks for sharing @Amber Bell! We're going to be reviewing how we do both customer and vendor returns.
    This is a great tip sheet for starting those conversations!​

    ------------------------------
    Aleiha Hanson
    Royal Basket Trucks, Inc - IT Manager
    GPUG Milwaukee WI Chapter Leader
    ahanson@royal-basket.com
    ------------------------------



  • 6.  RE: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

    TOP CONTRIBUTOR
    Posted 9 days ago
    Amber, this is very nice. Thank you for writing this up!

    -Joe

    ------------------------------
    Joseph C. Markovich
    IT Manager
    Okaya Electric America
    Valparaiso IN
    ------------------------------