Sage 100

Hi Everyone,

It was great meeting a lot of you at MOTM and look forward to continuing the relationships that are being built.  It was a great conference and I always get so much from it.

With that said, I have a client that does trade-ins.  We have bounced a couple ideas around (using a Receipt of Goods with an Invoice # and an SO Invoice for the new equipment then do the AP/AR Clearing or a negative Sales order (only the cost is not picked up).

Any thoughts would be greatly appreciated.

Thanks Jacquie.

------------------------------
Jacqueline Hoyte
Director of Client Services
Integrated Data Technology, Inc.
------------------------------

What is the value of the trade in?  Is the allowance/trade value going to be the cost?  Last I recall, you can't do a negative SN on an invoice.  My client does a negative transaction on the invoice with the cost of the trade in equaling the trade value.  They then do a IM transaction entry to place the item in serialized inventory.  The sales allowance stays on the P/L.  Would be nice to allow negative SN transactions on the invoice though.  Hopefully, someone has a more efficient method.

------------------------------
Jeff Schwenk
Owner
Bottomline Software, Inc.
Waynesboro VA
(540) 221-4444

Improving bottom lines for over 25 years!
------------------------------

Thanks Jeff,

Fortunately they do not use Serialized inventory (but this could possibly change)..

The trade in values vary and yes the trade-in value does become the cost. I think we are going to go with the Purchase Receipt and AP/AR Clearing.

Appreciate the additional info. Thanks.

------------------------------
Jacqueline Hoyte
Director of Client Services
Integrated Data Technology, Inc.
------------------------------

Original Message:
Sent: 04-01-2025 15:20
From: Jeff Schwenk
Subject: Equipment Trade-Ins with Sage 100

What is the value of the trade in?  Is the allowance/trade value going to be the cost?  Last I recall, you can't do a negative SN on an invoice.  My client does a negative transaction on the invoice with the cost of the trade in equaling the trade value.  They then do a IM transaction entry to place the item in serialized inventory.  The sales allowance stays on the P/L.  Would be nice to allow negative SN transactions on the invoice though.  Hopefully, someone has a more efficient method.

------------------------------
Jeff Schwenk
Owner
Bottomline Software, Inc.
Waynesboro VA
(540) 221-4444

Improving bottom lines for over 25 years!
------------------------------

Maybe a negative /M line on the invoice (to a suspense account), and the same /M amount on the PO receipt to offset?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

I would receive the used equipment (inventory) on a PO receipt.  Use a miscellaneous item on the SO invoice with a negative amount as a discount to the new item sold.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Thanks Kevin and Doug.

They track their sales and cogs very closely so we need to keep the credit to the customer very clean and not mix it with another sale.  All great ideas for other folks looking this up in the library!!

------------------------------
Jacqueline Hoyte
Director of Client Services
Integrated Data Technology, Inc.
------------------------------

Original Message:
Sent: 04-01-2025 15:57
From: Doug Higgs
Subject: Equipment Trade-Ins with Sage 100

I would receive the used equipment (inventory) on a PO receipt.  Use a miscellaneous item on the SO invoice with a negative amount as a discount to the new item sold.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

My clients have trade ins valued in excess of 10K each.  SN's are the only way to track the specific costs.  Thus, the credit on the SO invoice, then a transaction entry to move the item at cost into inventory.  Keeps it simple for the customer; they see the credit on the same invoice as the new item sale.  Short and simple.  By serializing, you can then pull the used item into PM, refurb it and sell it at the value added cost.

------------------------------
Jeff Schwenk
Owner
Bottomline Software, Inc.
Waynesboro VA
(540) 221-4444

Improving bottom lines for over 25 years!
------------------------------

Original Message:
Sent: 04-01-2025 16:26
From: Jacqueline Hoyte
Subject: Equipment Trade-Ins with Sage 100

Thanks Kevin and Doug.

They track their sales and cogs very closely so we need to keep the credit to the customer very clean and not mix it with another sale.  All great ideas for other folks looking this up in the library!!

------------------------------
Jacqueline Hoyte
Director of Client Services
Integrated Data Technology, Inc.
------------------------------


Original Message:
Sent: 04-01-2025 15:57
From: Doug Higgs
Subject: Equipment Trade-Ins with Sage 100

I would receive the used equipment (inventory) on a PO receipt.  Use a miscellaneous item on the SO invoice with a negative amount as a discount to the new item sold.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles