Open Forum

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

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

Original Message:
Sent: 02-06-2017 11:28 AM
From: Amber Bell
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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

Original Message:
Sent: 02-08-2019 06:00 PM
From: Jeremy Freeman
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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

Original Message:
Sent: 02-06-2017 11:28 AM
From: Amber Bell
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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

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

Original Message:
Sent: 02-09-2019 10:35 AM
From: Thaddeus Suter
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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

Original Message:
Sent: 02-08-2019 06:00 PM
From: Jeremy Freeman
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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

Original Message:
Sent: 02-06-2017 11:28 AM
From: Amber Bell
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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

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

Original Message:
Sent: 02-06-2017 11:28 AM
From: Amber Bell
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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

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

-Joe

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

Original Message:
Sent: 02-11-2019 01:06 PM
From: Aleiha Hanson
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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

Original Message:
Sent: 02-06-2017 11:28 AM
From: Amber Bell
Subject: Tech Tip: Create Sales Transaction Returns (Linked to Invoice)

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