Hiya
I need a simple way to run reports for my management spreadsheet information which is updated at the end of each month
We pay overseas factories to make garden pots, pay shipping companies to transport them to uk, pay couriers to take them to customers shops or warehouses.
I need a simple way of coding the sales invoices so that I can tell which factory the pots have been supplied from. E.G b and q sales from factory a. I put this info in the details but can only run reports on the customer by sales nominal and then have to troll through details for factory info.
I was thinking of using departments for each factory so a report would be easier.
I then need to be able to do the same for the supplier invoices from factories and link to customers each month. E.G factory to b and q.
Would this work or is there a simpler way?
I suspect the project manager module - in Accounts+ or Pro - may be what you really need. (At this stage, I'd run it to try and recreate something along the lines you describe in practice mode, but I don't have a Windows computer set up here at home, so I can't run it.)
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Hi Vince
I was wondering if the extended nominal range might help this better than departments but my brain is so BATTERED that Im going to ponder it later. Plus I need to eat.
__________________
Joanne
Winner of Bookkeeper of the Year 2015, 2016 & 2017
Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.
You should check out answers with reference to the legal position
Yeah, I'm suffering battered brain syndrome as well after the last couple of weeks.
What doesn't help is trying to visualise what Maggie is trying to/wants to do, as well as try to remember what facilities are available in Sage, but not be able to actually play with the software myself to try to set up a similar scenario to try it. That's especially problematic for something like the PM module which I haven't used in quite some time.
While I've used extended nominal codes in place of departments before, it was for something not dissimilar to departments (care homes) and the goal was to analyse the costs associated with a home. That's not the goal here - Maggie doesn't want the costs associated with a particular factory, but with a particular sale. I can't see how extended nominals would help.
Looking at it in more detail now that I've had half an hour to relax and there's a cuppa on my desk - this bit is what I think may be key, and needs clarifying:
"We pay overseas factories to make garden pots, pay shipping companies to transport them to uk, pay couriers to take them to customers shops or warehouses. I need a simple way of coding the sales invoices so that I can tell which factory the pots have been supplied from. E.G b and q sales from factory a."
What I'm inferring from that is that [batches/quantities of] these garden pots are made in the overseas factories to order, and shipped to the UK and thence to the customers that placed the order.
If that's correct, then project management is the answer: When an order is raised, presumably there's an internal order number used - that becomes the project reference number (or a new numbering system to match Sage is used, if necessary). Then, as each cost is raised - the factory manufacturing the order, the shipment to the UK, the delivery to the customer, that project number is assigned to the cost as its entered on Sage. You can then run a report on any given order (project) that will show all the relevant costs. IIRC, the sales invoice itself can be assigned to a project, allowing you to see the complete picture.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
