SOP Tab - Bulk Adding product to specific SOP's
Posted: 02 Sep 2012, 07:52
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
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