Changing item price after creating sales order

Unfortunately you are wrong. You may have overlooked the fact that there is a lot of code that needs to be written including queries to the database before you put the simple execute command.

2 Likes

Also, just because something can be done, doesn’t mean that it should be done.

Manager seems to be designed with a clear vision and everything is done with a purpose. Even if the dev decided to add a feature like the one you are requesting, a more complicated approach might make sense long-term (rather than just placing random buttons).

Trying to write this in a nice way, the above is not intended as an attack on you or your idea. It’s great that you’re suggesting things you think will be helpful. But it’s probably best to find an alternative for now.

That alternative may be a different accounting system that caters for your unique situation, or it could just as easily be using Manager but updating several records daily with the API - you mentioned that you have programming experience, so you could put together a solution that way.

1 Like

Just trying to get my head around what you are trying to do here.

A customer wants to order a collection of inventory items where the price is based on when the order is fulfilled not when the order is placed? Most customers would not be happy with that arrangement.

Or is something else happening, such as

  • is the price change in each item due to exchange rate variability?

  • are all the sub items components in a production order for an internal customer? So do you actually sell the inventory items individually or only combined in a larger product?

  • is it that the prior pricing was never applicable to the current customer. Such as an old order is copied the edited to a new customers quantities and prices (ie used as marking a sale on an order from)

1 Like

Thank you for your reply, I know that all here have good intentions … no worries
it is just a situation like if you are stuck with a single issue on one screen but the client is happy with the rest of the program. That’s why I’m trying to find any solution that can cover this side, the rest of the work is completely fine.
Appreciate your efforts, Thank you!

1 Like

The complete business life cycle is 1 day maximum 7 days
So every day they buy new items or some of the same items they already have but at different prices
It is Flowers business, which is completely updated every day (Because clients take new orders, buy, and sell EVERYDAY) and wants to keep updating the current products and create new for any new
I tried to convince him by adding new products and mentioning the date in the item name or code but in this case, after 3 months he will have like 5000 items, so the current solution is the best for him
at the same time, he wants to keep working on Manager io because he likes the simplicity of it.

Manager is not really build for that scale of business. The entries will be numerous. Also it will require sufficient staff to do all these entries. I do not think there is anything cheap ready available on the market that will do this as part of accounting. I know that for example Oracle Financials has supply chain add ons but then we talk about hundreds of thousands of dollars in software. I am very familiar with it and even then most depend on sufficient data entry staff pure because of scale. So if the client is happy with Manager you probably should explain all this and definitely increase your charges to the client so you can recruit data entry personnel.

2 Likes

I agree with the comments of other forum members that the change requested is not likely to happen very quickly or at all, but I would suggest that this request is worthy to be considered and put into the ideas category.

It would be good to be able to copy from past sales orders (for example) to a new sales order after Non-Inventory Items and Inventory item sale prices are updated on revision of sales prices.

A new option of “Copy to - with current item prices” would accomplish this.

2 Likes

Or something less wordy … but yeah, that sounds like a better suggestion.

1 Like

Any ability to add this option?
We are still stuck here with no further action, So please help, at least on the sales invoice screen, Please!

@Yaser, while you have a real problem. The solution isn’t to have the program force changes on copying a transaction because you just don’t know whether this is the true nature of the deal or not.

However, not all hope isn’t lost. In order to get the unit prices to auto fill you first need to get rid of them before copying, which is a lot to do for a 50 line invoice but there’s still a better way.

Your solution is to:

  1. First copy Sales Order → Delivery Note. This will get rid of all the old prices.

  2. Copy Delivery Note → Sales Invoice. This will populate the latest prices.

and if the business doesn’t require a Delivery Note step?
We are talking about 100’s invoices and clients every day

The copy to with updated price involves 3 clicks of a mouse or 3 seconds. Creating an intermediate Delivery Note takes a 3 more clicks and adds 3 seconds. Scaled to 100 invoices, that’s 5 minutes per day.

Compared to the hours taken to manually update 10000 invoice lines or filling the invoices from scratch, that’s a lot of saved time. So I don’t see a time problem.

Also:

I assume you deliver your goods, so why Delivery Notes don’t apply?

We don’t.

You talk from the consultant / Programmer/implementer point of view, which is the same problem between the end user who does all the work every day and the implementer who does it once or even 10 times, and I’m not referring to you in person, I have been suffering with 8 accountants for 3 years with consultants when we were applying Oracle ERP in a group of companies

Please note that every business has its own rules, and in the end the last answer I get here, Manager io is not designed for what you ask, in a very pushing way like i don’t have the right to ask for anything or that end user is requesting options just to enjoy watching it.

The best in any business is the client, the same as the end user.
so 2000 flowers items with a quantity of 70000 pieces are purchased and sold in the same week and every week more different new items with different prices and regular clients and new more every week with 5 users at least like 300 invoices every day and each second used in extra click mean delay for all, So God help

@Yaser I hope that you appreciate as I had to do that Manager is for small businesses. What you describe is a large business with numerous items and transactions. Oracle ERP indeed may be overkill but there are intermediate solutions more appropriate for the size of your business. At some point Manager will slow you down because the volume of transactions and the way SQLite is using system memory resources (hence pagination in Manager to reduce loads) will render it useless to you over time.

Manager fits most small business accounting needs and clients with needs beyond such small business environments indeed may get frustrated by the limitations.

1 Like

So far after trying more than 23 accounting programs /systems … I ADMIT that Manager io is the BEST all over the world

All businesses do things slightly differently.
When choosing software there is a choice.

  1. Get software which matches your company’s needs. Which implies buying software then having it tailored to your actual requirements (and associated costs to do that).

  2. Buy an generic software package, tinker with it a bit (within relatively narrow parameters) to sort of match it to your business. A much simpler thus cheaper task but inherently resulting in only a partial match to your ideal requirements.

Manager is a product in the group 2. Market which means:

  • anyone who wants something just right for their business is looking in the wrong product group.

  • if you want a feature added to Manager the important thing is how that feature helps a large percentage of the target market, not how it helps your particular business.

  • forum suggestions identifying how to adapt Managers current features to achieve reasonable operation (even if not exactly what is wanted) are addressing Managers core approach.

You already use Sales Orders, you really don’t need the prices in your sales orders – for internal purposes that is.

One reason prices are included in sales orders is that prices get copied from Quotes → Orders → Invoices, without change. This is exactly the opposite of what you need but most businesses operate in this way.

So I was thinking why not abandon the Sales Orders tab altogether and use Delivery Notes as your sales orders. You can change their title using form defaults.

We had 7 demonstrations for 7 different local (Romanian) programs, and all users including the business owner preferred to stay on Manager, and as if it is not enough, the owner is opening new business and insists that Manager be the only program which runs all companies, So God help!

My dear, I appreciate your kind help to find a solution, but it is really different process and if you noticed, most of my requests come Wednesday, because the business life cycle is 7 days.

But you haven’t made your process clear, it difficult for other users to keep guessing if a particular solution fits an unknown process.

Anyway, I don’t think my contributions are helpful anymore but I think we agree that copying sales orders and invoices in Manager isn’t suitable for daily changing prices. I personally can’t include this in ideas because I’m not in a position to decide on these two:

  1. The effect on most users
  2. Feasibility of development

The best I can do at this point is to defer to @lubos or more experienced mods like @Tut and @Abeiku. Maybe they can be of more help.

1 Like