1. Screenshotsepos 4 Excel Spreadsheets

• Points

  35

  Trophies

  1

  Posts

  3

  Hi there,

  
  

  I have a small retail shop in Edinburgh selling artwork.

  
  

  We currently use excel as a back office function to track inventory, costs, sales and to reorder stock but we don't have a 'point of sale' system attached to this.

  
  

  Martin Stokely has an excellent solution in EPOS 4 Excel (as far as it goes) but it doesn't allow you to put in the product costs (essential if you want to track costs and work out profit margin). Also it needs to have a search facility on the 'sell screen', ideally this would be a predictive search working off both the product description and supplier. There are some other minor requirements.

  
  

  Is there anyone who would be interested in customising this software / worksheet for our requirements. I've a very clear idea of what we want, it's just whether someone can make it work with Martin's programme?

  
  

  Please email in first instance if interested and I can send you through a better brief etc.

  
  

  ----------------------------------------------------------------------------------
  ***If the above is too complicated to integrate (???), then I would at least like to implement the following improvements toi our current worksheet***
  [FONT=&quot]
  Basically, we use a simple excel worksheet to list our product inventory (some 3000 lines total), including name of product, date received, quantity, cost price, sales price.

  
  

  At the end of each working day, I have to search the 3000 lines of spreadsheet to find the items that sold that day, copy / paste (the sold items) onto a separate 'Daily sales worksheet', manually reduce the unit quantity of goods sold, enter the date sold, etc.

  
  

  As you can imagine, this is a very time consuming exercise (and prone to manual errors) and we really want to have some function buttons that (when pressed) will:

  
  

  1) Automatically reduce the quantity of stock by a value (-1).
  2) Copy the relevant product line onto a separate sheet (i.e. to record the sale)
  3) Have a search function that can better find our products i.e. a search query box which will look up 2 or more different fields at the same time.

  
  

  Anyone interested in this 'wee project' ('wee' means 'small' in Scotland), I can send our excel sheet to better explain this?

  
  

  Many thanks for reading.

  
  

  Jason Redman [/FONT]

  1. Navigation
  2. OzGrid
  3. Forum
  4. Members
  5. Options
  6. Current Location
  This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.

  Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.

Screenshotsepos 4 Excel Spreadsheets

Many large companies use complex inventory databases to minimize excess inventory, but these systems are costly and difficult to setup. If you are a small or medium size company, or just need something to get you started, check out our simple inventory control solution that includes an Inventory Control Spreadsheet template, a Physical Count Sheet and an Inventory Label template. 7 Excel tips for huge spreadsheets: Split Screen, Freeze Panes, Format Painter and more The bigger and uglier your spreadsheet is, the more you need to keep a handle on the data.