Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: BJ's Little Helpfull Program of the Month

  1. #1
    Silver Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    231
    Thanks
    4
    Thanked 10 Times in 7 Posts

    BJ's Little Helpfull Program of the Month

    Enspired by Nevilles pic of the day.

    Will be writing a small little program every month

    that is helpful and can be used for daily business. No unfortunetly not every day.

    This months program is: SellAt

    Purpouse: To calculate your sell price using markups and GP%.

    Please report any bugs and any suggestions for a Version 0.2

    Version 0.1
    Calculate Sell Price and Profit by entering Cost Price and GP%

    *Upcoming
    Version 0.2 Features List
    - Calculate GP% / Markup% / Cost Price / Sell Price / Profit by entering any 2 values. The rest will be calculated.
    - Import Products Cost Price via .CSV or Excel and then Export Selling Prices to .CSV or Excel

    If you do not have MS Access installed on your computer the you will need the Access 2003 runtime. I have included it in the download package.


    Version 0.1 can be downloaded here http://www.mediafire.com/?118quxxcgqkwe

  2. #2
    Silver Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    231
    Thanks
    4
    Thanked 10 Times in 7 Posts
    Version 0.2
    Calculate GP% / Markup% / Cost Price / Sell Price / Profit by entering any 2 values. The rest will be calculated.

    *Upcoming
    Version 0.3 Features List
    - Import Products Cost/Selling Prices via .CSV or Excel and then Export Cost/Selling Prices to .CSV or Excel


    If you do not have MS Access installed on your computer the you will need the Access 2003 runtime. I have included it in the download package.


    Version 0.2 can be downloaded here http://www.mediafire.com/?118quxxcgqkwe

  3. Thank given for this post:

    Citizen X (21-Aug-12), wynn (17-Aug-12)

  4. #3
    Silver Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    231
    Thanks
    4
    Thanked 10 Times in 7 Posts
    *Upcoming
    Version 0.3 Planned Feature list update
    - Import Products Cost/Selling Prices via .CSV or Excel and then Export Cost/Selling Prices to .CSV or Excel
    - New - Add VAT to the mix
    - New - Calculate what your markup and gp is base on cost and sell

  5. #4
    Silver Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    231
    Thanks
    4
    Thanked 10 Times in 7 Posts
    Version 0.3 Added
    - Import Products Cost Prices via Excel , Put your Markup on and then Export Selling Prices to Excel
    - Calculate what your markup and gp is base on cost and sell


    *Upcoming
    Version 0.4 Planned Features
    - VAT Calculations
    - Import Selling Prices and export Cost Price
    ( As some suppliers give you normal selling prices and then give you discount on that )

    Version 0.3 can be downloaded here http://www.mediafire.com/?118quxxcgqkwe

  6. #5
    Silver Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    231
    Thanks
    4
    Thanked 10 Times in 7 Posts
    New in Version 0.4
    - Import Selling Prices and Export Cost Prices


    *Upcoming
    Idees for next versions
    - Calculator - VAT Calculations
    - Importer - Linking of Excel columns and ms access fields, as-well as importing/exporting of extra excel columns
    - Saving of price-lists by supplier
    - Quick Access To Price Lists - Save the file location of your excel price lists and open it with MS Access
    And any Suggestions?

    Version 0.4 can be downloaded here http://www.mediafire.com/?118quxxcgqkwe

  7. #6
    Diamond Member wynn's Avatar
    Join Date
    Oct 2006
    Location
    east london
    Posts
    3,338
    Thanks
    548
    Thanked 625 Times in 524 Posts
    Is it possible to have a price list in excel which will transfer price and description of required items to another quote or invoice when required?
    "Nobody who has succeeded has not failed along the way"
    Arianna Huffington

    Read the first 10% of my books "Didymus" and "The BEAST of BIKO BRIDGE" for free
    You can also read and download 100% free my short stories "A Real Surprise" and "Pieces of Eight" at
    http://www.smashwords.com/books/view/332256

  8. #7
    Full Member
    Join Date
    Apr 2012
    Location
    KZN
    Posts
    36
    Thanks
    4
    Thanked 4 Times in 4 Posts
    Hi Wynn

    VLOOKUP would be my choice of Excel command to do what you are looking for, simple and easy. Type a product code into one field and let the vlookup command work in the background to populate other parts of the row.

  9. #8
    Silver Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    231
    Thanks
    4
    Thanked 10 Times in 7 Posts
    Quote Originally Posted by kleva View Post
    Hi Wynn

    VLOOKUP would be my choice of Excel command to do what you are looking for, simple and easy. Type a product code into one field and let the vlookup command work in the background to populate other parts of the row.
    Hi Wynn, if the invoice or quote is in excel then VLOOKUP will work as Kleva suggests. But i would rather do it in MS Access and export to excel when required. Benefits of doing it in MS Access.

    - All your data is in one place.
    - Updating of Product Name in Products Table will filter threw automatically to quotes / invoices
    - Prices can be pulled threw to quotes and invoices
    - Design a quote / invoice template
    - Export to PDF or Excel
    - Generate Sales Reports

    Are you currently using Excel for Quotes / Invoices?

  10. #9
    Diamond Member wynn's Avatar
    Join Date
    Oct 2006
    Location
    east london
    Posts
    3,338
    Thanks
    548
    Thanked 625 Times in 524 Posts
    Quote Originally Posted by bjsteyn View Post

    Are you currently using Excel for Quotes / Invoices?
    yes excel and OO calc
    "Nobody who has succeeded has not failed along the way"
    Arianna Huffington

    Read the first 10% of my books "Didymus" and "The BEAST of BIKO BRIDGE" for free
    You can also read and download 100% free my short stories "A Real Surprise" and "Pieces of Eight" at
    http://www.smashwords.com/books/view/332256

  11. #10
    Silver Member bjsteyn's Avatar
    Join Date
    Jul 2010
    Location
    east lndon
    Posts
    231
    Thanks
    4
    Thanked 10 Times in 7 Posts
    What type of sales are you doing wynn? distribution or cash customers only?

    I am asking because because i have written an order processing system.

    It is not for retail sales, but can be used for office sales.

    I can send you a copy that you can use, then you can just give me some feedback.

    I am wanting to start working on a second version of the software and license it out. With web features for sales analysis, customer order placing and billing etc. Integration with Patel also. The system has been used by a company that does about R700 000 in sales every month.

    BJ :-)

Page 1 of 2 12 LastLast

Similar Threads

  1. [Question] EMP501 - Which month to include amount?
    By J7J in forum Tax Forum
    Replies: 1
    Last Post: 14-Apr-11, 03:24 PM
  2. Productivity month
    By Dave A in forum General Business Forum
    Replies: 5
    Last Post: 25-Feb-09, 05:59 PM
  3. T'was the month after Christmas....
    By Morticia in forum General Chat Forum
    Replies: 2
    Last Post: 07-Jan-09, 07:57 PM
  4. Your salary a month ?
    By Nourbous in forum Scam Alert Forum
    Replies: 4
    Last Post: 03-Jul-07, 12:15 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •