[Amber Bell]

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
——————————

[Jeremy Freeman]

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
——————————
——————————————-

[Thaddeus Suter]

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
——————————
——————————————-

[Jeremy Freeman]

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
——————————
——————————————-

[Aleiha Hanson]

Thanks for sharing ! 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
——————————
——————————————-

[Joseph C. Markovich]

Amber, this is very nice. Thank you for writing this up!

-Joe

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