Question Assistance in cost accounting program

[ibrahim horus]

Assistance in cost accounting program
Hello my friends
I want to make a program for a small factory that produces door and nets

 

[plog]

You asked no questions, nor provided many details. So I will just jump in with what I see is glaringly wrong:

1. Forms are the last things you should work on. Set up your tables correctly first, then build reports to make sure you can get the data you need out of your database. Then the last step is building forms.

2. You should only use alpha-numeric characters and underscores in names. I see a few fields with spaces--get rid of those.

3. Do not name anything with words from this list: https://support.office.com/en-us/ar...-symbols-E33EB3A9-8BAA-4335-9F57-DA237C63EABE It makes coding and querying more difficult later on. [Name] and [Number] should be renamed.

4. You shouldn't have tables with nearly-identical structures. Add_Doc and Issue_Doc are virtually identical in structure--that means all their data should probably be in the same table with an additional field to denote if the record is for an 'Add' or an 'Issue'. I bet you could also merge the Customers and Suppliers tables.


That's just looking at your Relationships. If I had a better understanding of your data I could help more.

I suggest you complete your relationship tool, post a screenshot then write a simple explanation (no database jargon) of the process you are trying to capture with your database.

 

[jdraw]

Further to plog's comments, what is the business you are supporting/will support with this database?
Tell us in plain English what are the things involved? How are these things related?
Basically describe a day in the business to help readers understand your needs. The old what, when, who, how much and how often....

If this is a viable business, why not but an off the shelf product that meets requirements?

 

[ibrahim horus]

First: Thanks for the replies
For the labels will be adjusted....
​

Second :​

This program is for small factory, manufactures door and window . The factory plan is: Three stages pass​

The first stage :​

Purchase of raw materials Such as (all kinds of wood - nails - glue - other materials).​

The second stage : Is the manufacturing process Consisting of :​

1- Raw materials purchased.
2 - Administrative expenses required for the manufacturing process.
3- Forming wood in other factories if necessary.​

After the manufacturing process, it is sold directly to the customer or displayed at the factory exhibition , This is the third stage​

The problem I can not solve is the second stage​

I worked group tables to my knowledge​

1- table : Add_doc .. Purchase invoice header​

2- table : Produce_doc …Manufacturing invoice head, this invoice was used to control the withdrawal of materials from the warehouse .​

3- table : issue_doc ... Head of sales invoice after production .​

4- table : Movements … Table of movement of raw materials inside and out of the warehouse.​

5- table : Forming … This is to record the cost of forming wood in other factory so that it is added to the cost of the product .​

6- table : Administrative_expenses … To record administrative expenses during the work of the plant to be added to the cost of the product as well .​

7- table : Customers … Customer registration .​

8- table : Suppliers … Suppliers registration .​

9- table : Names … Registering the names of the items only .​

If there is an adjustment in a table you can do this or create a new table. Important I want to help solve the problem of programming the second stage, which is manufacturing. Thank you very much​

 

[jdraw]

My first read of your set up is that you have inputs and outputs intermixed in your table structure. But I don't know your business as well as you. So I may be guessing/misunderstanding things.
In any database application it is critical to get your tables and relationships designed and tested to ensure they reflect and support the business involved.

The following is meant to describe the business in simple English -based on your posts.

This project involves a small factory that manufactures door and windows.
In overview there are 3 major processes:
1. Purchasing raw materials (all kinds of wood - nails - glue - other materials) from Suppliers
2. Manufacturing processes consisting of :
- Taking Raw materials purchased.
- Manufacturing products.
- Forming wood in other factories(if necessary).
- Accounting for resources (human, material, administrative) during acquisition, manufacturing, forming, exhibiting, sales, marketing, product planning...
3. Product Sales to Customersand Display
- Products are sold directly to the customer or displayed at the factory exhibition.

It seems to me that you would have a Product Catalog or List of Products that are currently for sale to Customers. You might also have marketing literature. Do you manufacture windows not made with wood (aluminum/vinyl)? What about window designs/styles? Glass variety/finishes etc? Orders? Invoices? Shipping? Products in inventory???

Perhaps there is a broader description of the business? I'm just trying to get the big picture identified briefly, so you can focus on priority areas--but knowing where those priority projects fit in the big picture.

Good luck.

 

[ibrahim horus]

Thank you my friend for your prompt response
My friend , in order to simplify you matter, the factory is a small factory that produces only doors and windows of wood - Nail - Glue - Iron.
These raw materials are needed so far, My friend can you edit the tables

 

[jdraw]

Here is a link to information on database design and planning.

Good luck with your project.

 

[ibrahim horus]

thanks my friend

 

[ibrahim horus]

Nice site but I did not find a database that draws lines of cost accounting for the product

 

[ibrahim horus]

So far I have not found anyone to help me or understand what I mean

 

[jdraw]

What exactly do you expect?
If you have a list of requirements -clear, complete and well documented- you could review these against available commercial cost accounting packages.

Search Google or Bing with cost accounting software to see what software/packages might be available/applicable.

If you plan on developing such a system, then you will still need requirements. You will need to do the analysis that gets you the details. And if you intend to use Access or other database management system you will need to have knowledge of database concepts and Access capabilities. You need to plan out the project --requirements, review of options and feasibility, design, resources, development, testing.....

It really all starts with a description of the business and a clear list of requirements. Just consider if you could find someone who would build such a system for you, they need details of what it is you want them to build.

I have provided some links on database design and planning.

It is very unlikely that you will find a database or application or commercial package that will meet /match your needs without some adjustment or customization.

Good luck with your project.

 

[ibrahim horus]

Dear friends
First thank you for your interest

​

These are some of the beginning tables of the program:​

1- Table " Suppliers " To record the supplier data .​

2- table " Purchases_Bill " Register purchase invoices .​

3- table " Administrative_expenses " to Record all expenses .​

4- table " Production_Order " To register products manufactured and raw materials required to it , And drawn from the store to be a valid balance .​

4- table " Customers " Record customer data .​

5- table " Sales_Bill " Registration of sales invoices for the produced products .​

6- table " Forming " Registration of the cost of forming the required wood in other workshops, where this cost is within the cost of the finished product .​

database attachment clearer with a sketch of the workshop. my Friend , I do not want a ready-made mold but I want to help me arrange the processes and relationships​

 

[ibrahim horus]

:banghead:

 

[ibrahim horus]

problem
table Purchases bill and sales bill and Production linked Movements
Worked forms Purchases To record purchases and form RetPurchases To record purchase returns and form Production To record the raw materials needed for production and at the same time to record the quantity of products to be produced and from salee To record sales and form Resales To record sales returns
Because of this I consider that I deal with a single table that duplicates data, especially quantities, and the balance appears wrong
Tables, relationships and forms worked in the attach

 

[Frothingslosh]

Ibrahim, what you're asking to have done is a significant project that people usually sell for hundreds or even thousands of dollars. It will require a significant investment of time and energy (think man-months of effort), and is simply outside the scope of what we do here.

If you run into specific issues, by all means, ask about them and you'll get LOTS of help. If you're stumped on a concept or how to do something, you'll also get help, but that help may well be a post like jdraw provided you, pointing you to a resource to help you learn what you need to do.

In this case, the lowest cost option for your employer may well be to purchase an existing product and, if possible, have it modified to better suit your needs. Otherwise, you probably need to hire a specialist full-time (either directly or as a contractor), because this is NOT a small project, and will get very complex very quickly.

 

[ibrahim horus]

Thanks for your response, I do not mean from this program is selling it , but I ask for a certain point I do not want to make a whole program but there is a loophole I have not yet found it solves

 

[Minty]

As has been mentioned in other responses, invoicing and stock control are very complex things to manage correctly, and your current table design is not really anywhere close.

You need to read up on normalization, and have a think about why accounting software companies sell inventory management as an add-on for thousands of pounds.

Whilst it wouldn't be impossible to make a system yourself, your current experience levels are not high enough, and this is not a "beginners" task. I would want at least 2-3 months to plan out, and prepare the basics for something like this, let alone the time to really get stuck in and build it suitable for end user use.

 

[ibrahim horus]

thanks my Friends