Follow Me On:
The Adventurous Silversmith
  • Home
  • Blog
  • Portfolio
    • Metal Work >
      • Chasing & Repousse
      • Holloware
      • Jewelry
      • Other Wonderful Items
    • Fiber Arts >
      • Temari
      • Yubinuki
  • Resources
    • Library
    • Tools & Equipment
    • Links
  • About
    • Artist Statement
    • Curriculum Vitae
    • How it is Made
    • Contact

Software Saga Part 2

8/10/2013

 
In my last post, I chronicled The Saga of the Inventory Software.  
In this post I will explain how I resolved it.

To refresh your memories, finding BUSINESS accounting software that runs on a MAC that does not cost a hefty penny; does inventory; and works well is a very rare thing BUT after much Googling I located Express Accounts and Inventoria which are both my NCH Software. 

I won't go into the evaluation process but let me just say that after working with each for a week I was convinced that they would meet my needs. I was fortunate enough to hit this right as they were having a software sale so I bought both.   

IF you want to do just inventory management then Inventoria alone will suit your needs. You can set up suppliers, customers, inventory categories and sub-categores, unit of measure. Create orders and receive parts as well as Invoices for items you sell, as well as reports for costing. If you want to track COSTS and what your business is doing money wise, then Express Accounts is for you. AND in Express Accounts you can do some basic Inventory Management too.  So it comes down to basic double entry accounting;  purchasing, selling and reporting.  A basic knowledge of accounting is required.  For either package I will not teach you how to do all of this but their website will help you if you have further questions on it.   

Once I had bought the software, I now had to move everything I had done in Bead Manager Pro (BMP) and export it so I could import it onto the new system. Yes this would take time but starting over from scratch would be even longer. The ace in my pocket to do this was my many years of experience working with and installing this type of software. FYI in big business the entire suite is called Enterprise Resource Planning "ERP" and this covers Sales driving Manufacturing which drives Purchasing and Recieving and the Accounting that ties it all together.  I was in my element even though I would have preferred not be there. 

From BMP, I exported my suppliers and I also did separate exports of each category of parts; these I set aside.  In Express Accounts I set up the chart of accounts and imported my suppliers. Next I massaged the parts exports to give me lists of parts and categories which I could then import in the software world this process is called a data conversion. It took a few tries to get the files setup so I could import each portion of the data but working with just one or two lines of data allowed me to eventually import over 166 different items in inventory along with their costs and quantities (wire, sheets of metal, disks, jewelry components, stones, etc.) an for those items that did not export from BMP (about 20 items) those I hand entered.  This was all done in Inventoria.

Then I had to do journal entries to take care of the dollar amounts in Express Accounts. For items like hammers and other equipment that is not tracked in a normal inventory, I had put them into BMP so I could track the costs.  I just had to find the totals, in BMP for these categories and make the appropriate journal entries. I then did journal entries for the inventory categories.   

Afterwards, I did a quick reconciliation which is just bean counter speak for make sure it all totals and I was done.   

In 3 days I had moved out of BMP and into my new system.  
I would not recommend this for the faint of heart or if you don't know how to do it; but I did and I could so it is now done. 

What can you learn from all of this. 
Don't do a quick evaluation
Test everything! In the past I would have, doing this on a paid job but I admit I was lazy this time around
Don't be afraid to say "This won't work" and ...
Quit while you are a head, not when you have a head ache. 

I hope I have helped you.

Comments are closed.

    RSS Feed

    How to Aquire Your Own Shop Elf

    Archives

    October 2020
    August 2020
    March 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    May 2018
    April 2018
    February 2018
    January 2018
    November 2017
    October 2017
    September 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    November 2011
    August 2011
    July 2011
    June 2011
    May 2011
    April 2011
    March 2011
    February 2011
    January 2011
    December 2010
    November 2010

    Jan - Nov 2010 History
    File Size: 2272 kb
    File Type: pdf
    Download File

    Jan - Dec 2009 History
    File Size: 2332 kb
    File Type: pdf
    Download File

    Categories

    All
    42
    A Year Of Repousse
    Blacksmithing
    Blogoversary
    Box Project
    Business
    Chasing & Repousse
    Commission
    Education
    Embroidery
    Enamel
    Entries
    Entry
    Exhibition
    Facebook
    Filing
    Fold Forming
    Gold
    Holloware
    Hot Forging
    Hydraulic Press
    Jewelry
    Keum-boo
    Learning
    Leather
    Market
    Metal
    Patina
    Photography
    Polishing
    Publications
    Raising
    Sanding
    Santa Fe Symposium
    Shop Elf
    Sinking
    Social Media
    Soldering
    Store
    Studio Visits
    Superbowl Challenge
    Teaching
    Teapot Project
    Technique
    Temari
    Tin
    Tools
    Vessels
    Visiting Workshops
    Weaving
    Website
    Workshop
    Yubinuki

Powered by Create your own unique website with customizable templates.