SOP Tab - Bulk Adding product to specific SOP's

[ontracks]

Hi All,

Does any one have an app or way of mass adding a specific product to selected multiple SOP's without opening them and typing the product code each time?

We are using Sage Line 50 V2012 Financial Controller, Multi User. on Windows 7 machines.

We receive orders from our website which are set up automatically as a SOP. Each order includes a P&P charge. It's a product so appears on the first tab of an SOP (i.e. Code 01 - UK Postage Charge £1.99).

On a percentage of our orders we part dispatch the goods, and then have an item(s) outstanding which can't be dispatched straight away. These are items which have been announced by manufacturers, collectors want to guarantee they obtain them , but which may not actually be released for several months. Once we have part shipped an order the SOP will show as nothing allocated initially, before becoming part or fully allocated once the next delivery of goods arrives from the manufacturer.

We charge a small second P&P charge on all subsequent dispatches. At the moment we either open every SOP with nothing allocated and add this manually, or check invoices once printed, amend and re-print. Both are a waste of time and resources.

Does anyone know a way to automatically check all SOPs, and apply a specific product (our P&P charge) to them? As an alternative we could add the second P&P charge onto the supplemental SOP Tab where you can add a shipping charge - either is fine by us. Depending on what the App can do and which parts of Sage SOPs it can easily write to.

I'm assuming we'd need to run this routine every day to catch all SOP's when they are in the 'Nothing Allocated' state. Rather than think an Application is clever enough to read every SOP no matter what it's Allocation status, find the P&P charge and see if we've already dispatched it, then add a second P&P charge only if none were waiting to be allocated or dispatched on it.

Hope this make sense!
If not just ask,
Tim

[brucedenney]

I guess we could create a tool that looks at all part shipped orders and if there is not a delivery charge outstanding it could add it on.

You would need to run the tool between shipping the first part and the second part (or second and third part etc)

I assume the delivery charge would always be the same amount. If we need to change the amount each time it could get very complicated.

[ontracks]

Hi Bruce,
You've got it exactly.

Would a standard price for P&P based on either a sage product code or something held in an ini file be OK. Then as the years progress we can revise it as the Royal Mail increases their prices.

Can you let me know costs? You can email me at my usual email!

Thanks
Tim