[Little Mountain]

We ship packages for customers via UPS daily. Now I have a stock number for "UPS Shipment" but, it gives us a 100% profit, but there is a cost on our end.

I'd like to figure out a way to have something pop up asking us the cost, and the retail price (so we can have accurate cost/profit figures)

Something along the lines of the "parts" thing we have setup. when we type in stock number 5099, anything from $.01 to $0.99 it pops up w/ $0.00 and we type in the cost and quantity.

Something along that line, because our cost is different for every shipment. We also don't us a set markup, Next Day Air's we make more, etc.

This is one problem I can't figure a way around, and I need to figure it out before the end of the year.

Thanks,

[RetailEdge Moderator]

Let us know how you calculate a shipping price at the point of sale and I will try to come up with the best solution for you.

We typically recommend that you put your shipping items in your inventory with $0.00 cost. Users do this a lot of different ways (price point items, etc.) This is so that you don't create an artificial cost for an item, by assuming a cost. The shipping item(s) should be put in a separate "Shipping" department. That way when you are running your sales reports, you would exclude this department to prevent your overall margins from making your totals look out of whack.

There are going to be a number of items that you potentially won't track costs for in RetailEdge. Some of the typical ones might be shipping charges from a Vendor on a PO, credit card merchant service percentages and shipping charges. These costs are things that you won't get billed for until after you have received or sold these things. So these are costs that are tracked in an accounting program. If you want to have the shipping charge cost tracked in RetailEdge, once you get the invoice from UPS, then you can create an item with the cost of the charge and sell it for $0. This will balance your costs out in RetailEdge.

We ship packages for customers via UPS daily. Now I have a stock number for "UPS Shipment" but, it gives us a 100% profit, but there is a cost on our end.

I'd like to figure out a way to have something pop up asking us the cost, and the retail price (so we can have accurate cost/profit figures)

Something along the lines of the "parts" thing we have setup. when we type in stock number 5099, anything from $.01 to $0.99 it pops up w/ $0.00 and we type in the cost and quantity.

Something along that line, because our cost is different for every shipment. We also don't us a set markup, Next Day Air's we make more, etc.

This is one problem I can't figure a way around, and I need to figure it out before the end of the year.

Thanks,

[Little Mountain]

The only problem with not counting the report is that we do make a profit on the shipping, so it wouldn't be accurately counted so to speak.

Is it possible to have a box pop up and fill in cost/price/quantity?
Not sure if that's possible.

[RetailEdge Moderator]

No way to have a pop up with cost information. Only Price and Quantity.

If you do make a profit on the items, wouldn't the above suggestion work? It would not show you profit on a per sale basis, but it would keep your department profits accurate on a monthly basis.

The only problem with not counting the report is that we do make a profit on the shipping, so it wouldn't be accurately counted so to speak.

Is it possible to have a box pop up and fill in cost/price/quantity?
Not sure if that's possible.

[Little Mountain]

Well the costs for each shipment is different. So that's why we can't put a value in for "last cost" for a UPS shipment.

Changing it for each shipment is too time consuming.

[RetailEdge Moderator]

1. Create an item for Shipping. Put it in the separate shipping department. It should have a $0.00 price and $0.00 cost.

OR

Create multiple items for shipping using price point items. So for instance create a $5.00, $10.00, $15.00 ship item, etc. These should have a cost of $0.00 in your inventory.

Whichever method works best for you and is quicker at the time of sale.


As I have have said before typically the costs for shipping should be tracked in your Accounting Software (along with other business costs that you might want to track there, lighting, heat, etc.). If you are exporting your data to QuickBooks Accounting, then RetailEdge will take over the sales numbers and will actually break out the sales into sub accounts based on your RetailEdge departments. So you will have a sales number in the Shipping subaccount that you will be able to add a cost to when you receive your invoice from UPS.

We probably won't be adding a feature to allow someone to enter cost information at the time of sale. Most businesses don't want clerks touching cost information and it is prone to having clerks enter bad data at the time of sale. Then you will have to unwind this later and it is much harder to do this once a sales transaction has been made.

If you must have the costs reflected in RetailEdge, I would enter another SKU called Shipping Cost Adjustment and put it in the Shipping department at a $0.00 price. Then once you have a UPS Invoice with your monthly costs, then you would edit the average cost of this item which is an easy thing to do, then sell the item for $0.00. This will adjust your shipping department costs and won't effect your sales totals for the day (because you are selling it at $0.00. If you need to have the date of the sale reflect the date of the invoice from UPS, then you can change the sale date by pressing Ctlr-Alt-D on the sales screen and changing the date of the sale.


Here is the

Well the costs for each shipment is different. So that's why we can't put a value in for "last cost" for a UPS shipment.

Changing it for each shipment is too time consuming.

[fwhorch]

We'd also like the ability to set the cost and price for shipping.

I understand the workarounds suggested, but it would be much simpler and easier for us if we could enter the actual cost of the shipping and the price we charged.

Hope you can consider this feature for a future release. An item with 0 cost and 0 price could pop up a dialog box asking for cost and price, with defaults set to 0 and 0.

Thanks,
Fred

[RetailEdge Moderator]

Fred,

Good suggestion. I have added it to the suggestions list.

We'd also like the ability to set the cost and price for shipping.

I understand the workarounds suggested, but it would be much simpler and easier for us if we could enter the actual cost of the shipping and the price we charged.

Hope you can consider this feature for a future release. An item with 0 cost and 0 price could pop up a dialog box asking for cost and price, with defaults set to 0 and 0.

Thanks,
Fred

[Little Mountain]

lol umm.