Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Need inventory control database

Featured Replies

Hello,

I have a small business I run from my home. It involves buying parts and components from different vendors, and then reselling the finished product to customers.

I've tried templates like the Business Tracker and a few other demo's I've found online but they require too much modification or just are not right for my needs.

Buying: I have to be able to keep track of parts I ordered, their prices, vendors, quantity discounts and stock.

Selling: I then need to track the finished product and have pricing that is sometimes specific to the customer, quantity discounts, stock, customers.

Invoicing: Need a complete invoicing solution with customer orders and all the info surrounding the order, payments, credits, returns, etc.

Summary: The usual in terms of sorting any of the information in the database and to be able to know how much each customer has ordered and spent, total sales, cost vs. profit.

This is for small business, no warehouse, no POS, no bar code.

If you can help me at all I can give a more detailed list of requirements but this is the general idea.

Thank you.

  • Author

Hmmm I know this must exist somewhere...I guess it's back to searching the Internet and modifying something. UGH!

Try www.b2bdbsys.com and their EAS-ERP System. We having been using an earlier version for our sign company with our own modifications.

  • 4 weeks later...

Hi I see your post has been here a little while, but if you are still searching for a system that covers most small business operations please have a look at my web site www.creativetraining.info

I have a CRM Admin package that does most of what you require and while the demo is for the UK it can be adapted for the US if you are interested.

I hope that you find what your looking for.

Kind regards

Gill

In case you should deside to roll your own, will this article come handy:

http://jonathanstark.com/recursive_data_structures.php

...the second half, where many many recursive structures are dealt with!

--sd

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.