POS Multiple Stores

Options
Ian Towell
Ian Towell Member Posts: 12
edited February 2017 in Reckon Accounts (Desktop)
Wondering. Thinking about wanting to start a new store and want each store to be able to see the others stock level of the products. Does Reckon POS / Accounts Premier support this? Thanks

Comments

  • Chris McGregor
    Chris McGregor Member Posts: 140
    edited March 2015
    Options

    Hi Ian,

    Officially...No... However there are 2 possible workarounds:

    1) Two separate POS databases(PDB) connected to two separate Reckon Accounts Company files

          a)The catch to this is to add stock into the 2nd file you would need to raise an invoice in the first files and then enter a bill in the 2nd file so you would be effectively selling from one store to the other. this may cause you to have an inflated tax so you would need to remove the total of the amounts sold to that store before doing BAS and other reports.

    2)  One Reckon Accounts Company file but duplicate your items  list for each store

    Store1:
              Item1
              Item2
                      Sub Item 2
              Item3
              etc
    Store2:
              Item1
              Item2
                      Sub Item 2
              Item3
              etc

    There are a couple of catches with this:

        a) Every new item you create you will need to do it twice, once under store one and once under store two.
        b) To transfer stock from store one to store two you will need to do a bill at the average cost of the item, 
            -Store1:Item1 and 
           +Store2:Item1 
        c) The standard prefix on a barcode scanner is '~' so when a bottle of code is scanned into the windows notepad application it will appear as '~9300675009829' based on the barcode in reckon accounts being entered as '9300675009829'. In a single store environment this is not an issue as there is only one product in your item list that has that barcode but when running two stores it would take the stock from the same stock pile eg; Store1:Coke, and this could cause a problem.
    To Fix this you would need to program your barcode scanner to have a 2 character prefix so as to define which stores stock to pull from. in this case we might have '~a' for store one and '~b' for store two:
        '~a9300675009829' 
        '~b9300675009829'

    so when entering the barcode when creating new items you would just need to remember to enter the store appropriate letter in front of the barcode in that item eg 'a9300675009829' for store one.

        d)   Sharing the info: you need to ask yourself do you want store ones staff to see stock at store two? 
            i) If not then it would be best to have a PDB file physically at each store which is best to ensure you can still trade in the event of a network failure and both PDB files will be based on the one Reckon Accounts Company file.
            ii) If you do then you will need the data then you have two options although you really need to have good internet before considering these options:
               1 )  Create a virtual private network (VPN) between store one and two, this is a private network across public lines(the internet) so your data is secure, then have the PDB at the main store and the Point of Sales at the 2nd store would be remotely retrieving the data from the PDB file at store one, the downside to this is if your internet is slow it will be  a bad experience and if your internet drops out then store 2 will not be able to trade at all, exactly the same as if you were to use any cloud based solution.
               2 )  Using Point of Sale Enterprise which is a MS SQL based database you are able to use MS SQL replication to maintain a database at each store and have them synchronise in the background at intermittent periods(10min, 30min, 4hours etc), this means if the internet drops out you will still be able to trade at both stores. The downside is it requires the additional purchase of Microsoft SQL standard edition and a 5 pack of CALs(Microsoft licences) which could be an addition of $1,500 depending on where you purchase it from. also you will need an IT professional to set this us as its not for novices.

    I know I've given you a lot on info but I hope it helps.


    Regards,

    Chris




  • Ian Towell
    Ian Towell Member Posts: 12
    edited March 2015
    Options
    Thanks Chris,

    What is stopping me using the "QuickBooks POS v12 (2015) Multi-Store" program?

    Ian

  • Chris McGregor
    Chris McGregor Member Posts: 140
    edited March 2015
    Options

    Hi Ian,


    To our knowledge it doesn't integrate with our Australian accounting software.

    Also keep in mind when purchasing software supported by overseas offices that support may not be available during Australian business hours. We have always found this extremely important for POS clients.


    Regards,

    Chris

  • Michael Graham
    Michael Graham Member Posts: 9
    edited March 2015
    Options
    Hi Ian,

    You might like to take a look at Ostendo Operational Software.

    Ostendo provides multi site, multi warehouse and multi locations for full inventory control. It also has POS and sales order functionality. Multi site POS would require Terminal Services to access the database or you could just Host the Reckon Accounts and Ostendo product so all sites connected via a hosted cloud solution. Each site depending on user restrictions could either see only Stock available at their site or see all stock available in all locations.

    Ostendo intergates with all current versions of Reckon Accounts Pro / Premier and Enterprise.

    Regards

    Michael