Managing Job and purchase order numbers
Hi, I currently use Google Sheet to enter all our jobs, give them a unique Job Number, enter PO Number, client, location, description, value of the PO. This is then linked to a planner for the different divisions and I can extract data for stats. I currently download MYOB Report to see which PO has been invoiced and what not, show graphs on a dashboard etc. While it is working very well, the main table is still a spreadsheet with all its dangers and I worry when someone else uses it when I am away. I looking for a database where anyone in the office could enter all our jobs as per above with the security of a database so that the job info are not damaged or mixed up by a misuse of the spreadsheet (as it has happened before). But I am looking for a database that works with MYOB so that I do not have to export the sales report and other report required for my dashboards. Is there such a thing? I thank you in advance for your help. Kind Regards Laurence Elisabeth MilesSolved