I suspect this hasn't been addressed within the app yet.

Annually we have to update the various pricing levels for inventory items. Vendors tell us "everything is going up in price by 3%" and we have to export all the inventory for that vendor, massage the data in Excel to alter the pricing by the required amount, and then import it back into AENE telling it to update existing records.

This has been a royal PITA but it does work. When will AE add this function so one may do this within the app? This is not rocket science; the old app my client used (it came on floppies and ran in MacOS 7.6) would do this pricing update without a problem. (Of course, there were other issues with that app that caused the switch to AENE.)

Thanks,
Barry

Inventory panel
Set Item prices

I just raised all my prices 5% Globally and then lowered my copper wire prices the same way by only selecting the wire items. Copper went down 50%.

Kid,

It looks like what you suggest does nothing for raising the prices of what may be arbitrarily set prices. For example: If the standard cost or last cost is, let's say, $9.45 but we sell the item for $25 (and we have hundreds of products purchased and sold at many different costs and prices that might show no specific margin), how would the utility you mention help if a particular vendor says that the cost for his products has gone up by 5% and I want to increase what I charge for those products by 5%? In the preceding example, my cost has gone from $9.45 to $9.92 while the price I would charge has gone from $25 to $26.25. I do not see anything in the "Set Item Prices" that resolves this issue.

Thanks

Under set item prices the button marked Shortcuts takes you to the place on The 2007 and 2008 Mac Account Edge

Use Calculated Price on top
Next area set how much you want to raise the price. Slide the Pricing Shortcuts to the side and with the items that went up 5% checked in view set Percent Markup to 5% click updated checked items only and your items go up 5%

Kid,

The "Basis for Calculation" popup menu is where the problem resides. There is no choice for "Standard Price", only "Average Cost" and "Last Cost". So this procedure can change what you "pay" for the item but not if what you charge has no direct relationship with your cost.

I select last cost and type 5% and it updates the price no matter what by 5% from what my last price was. Last cost shows the column that way not the markup. The proof is I paid a high of 9.42 for conduit and the last cost was 5.56. Under the way I described the selling price went up 5% from my 9.58 price not my 9.92 one time price or my 5.56 but based on my price that I still had in it so it went up to 9.89. Now if I set my price to zero it would take 5.56 and raise it to 5.838.

Kid,

You're not reading my post completely. The "Set Item Prices" Shortcuts dialog does not use the Base Selling Price in any calculations; it only -sets- the Base Selling Price based upon modifying the Last Cost or Average Cost (of what you paid). What I charge has no mathematical relationship to those two costs so this process is useless. I want to alter the Base Selling Price by adding a percentage to it irrespective of my costs (although this dialog is useful for changing my -costs- by a measured amount).

Thanks anyway.

Thank you for sharing useful information.I hope this information will be useful to everyone and hope you continue.


Finance blog, finance, economics, Corporate finance, Personal finance, Investing, Marketing