Database to save each incoming goods and the cost of the batch of goods quantity

Outbound, according to the principle of first in first out, when you need to record every time the number of outbound and corresponding cost

If the delivery time is more than one batch of stocks with output, also calculate the comprehensive cost

My table is designed as a father and a son, the remaining quantity of the records,

From the table the number and cost of change the batch record for ins and outs of each

Outbound query when the remaining amount is not zero inventory records, then cycle to take out the appropriate number of records, cost calculation, and then insert a outbound records from the list, and deduction for the number of remaining in inventory records.

The feeling is not reasonable, it is calculated with bosses to give directions?

CodePudding user response:

Warehousing is a table, inventory is a table, outbound is also a table, refer to the WMS system,

CodePudding user response:

Writing table storage warehouse, attribute is the supplier, goods name, quantity, what of,
, write inventory table at the same time, because there are different batches of the same products, outbound, too, to inventory list, to write outbound table; Inventory list is said to have a state outbound or put in storage, inventory can find out,

CodePudding user response:

Separate storage, outbound, storage, inventory, this will be a problem,
In fact, depending on your business,
Your first in first out, for example, batches of in-out warehouse, etc., you are on the business rules,
According to the business model and database tables,

CodePudding user response:

Here can only say, why do outbound and inbound apart,
For outbound, may need to be batch id associated warehousing,
You have to show your library from which batches,

And some erp also have no batch outbound, outbound, namely a cursory yards didn't care about the outbound order of first in first out,
So talk about how to build table light is very empty,
Combined with specific business

CodePudding user response:

We have locked before inventory and concepts, in the process of the outbound
Locking is that stocks down the outbound order today, but no actual outbound,
This time, you need to make sure that the next time the delivery, the quantity is enough for outbound,
Rather than two outbound order at the same time, as a result, because the first out, resulting in the insufficient number remaining second outbound,

Outbound is actually goods haven't put in storage,
But it is expected that may have the goods to the warehouse in two days,
So this time, he could start with the next outbound instruction, outbound, is expected in the third day or after

So this is all the business logic,

CodePudding user response:

Appropriate inappropriate don't ask us, consult professional accounting they how to calculate the cost,

As to deduct the amount, the ans is a travel, we generally in the batch record child table or revision,

Only the actual inventory turn real number

CodePudding user response:

In-out warehouse must be separated, warehousing number affirmation cannot reduce, this is the original record, how to check after you lost? Reduction can reduce inventory, warehousing to increase inventory, outbound synchronous reduce inventory, and want to remember good outbound information, so that even if the inventory is not allowed, or for the record to calibration, loading and unloading of paper documents, actually you can refer to the specific analyze what is the raw data, which is to calculate the data, the original data are kept separately built table,

CodePudding user response:

This as "database" do not have what relation, this is UML or Class, is a problem in the domain model, look at the most basic books, going to enterprises to learn management, want to be in actual books on a few zhang, don't take some programming knowledge for granted,

At least books are divided into two kinds, one is general ledger, it records the remaining quantity and remaining amount; The other is a subsidiary ledger, it records each sum of the number of "independent event", amount, Posting number remaining, Posting the remaining amount, actually there is nothing between this two kinds of "master-slave relationship," but by accounting Key associations, such as "inventory - goods 342423 -... Other accounting subjects "and" stock - goods 342423 -... Other accounting subjects "and" delivery - goods 342423 -... Other accounting subjects "is the Key link between, but you can't say which both with the former is" master-slave "relationship, actually customers associated with commodity categories and at least more than 30, and you only know three, products of the enterprise knowledge management process is also known to less than one over ten,

Database is the place where save the data, however, in a database table with several layers, determines whether you use a relational database (or no (database), with the memory, text files, or anything else, you have to know the same domain model, write a domain model UML diagram, the Class code, and more to the point is to take a book practice for a period of time

CodePudding user response:

In real business, as a result of each kind of production and operating activities need to quickly get some time to relevant information, so often want to "nissin monthly statement", such as inventory at any time to get the surplus quantity and remaining amount every day, because the production and business operation at any time to frequent query specify the date when the purchase cost, cost of sales, inventory cost, cost discount, to sales commission costs, deal with the unpaid fees and so on, you throw a bunch of things all in "stock list", which became a focus of a large junk, you need to forget the "database" this low-level things, in the field of computer's eye in the field of business affairs as a metaphor, the business domain knowledge to understand first high, according to the habits of more than one thousand years in the field of business system to understand the process and build your list, try to avoid to take it for granted "database" to put the cart before the horse to handle business,

CodePudding user response:

Customer groups associated with goods and at least more than 30 - & gt; Enterprise management accounting subjects related to commodity categories and at least more than 30