The design of the core data table
Demand, warehouse has to buy into the Treasury, the production material (outbound), production material return
1, keep monthly inventory data initial inventory data (monthly)
2, at any time found to every day before the inventory data, and the number of in-out warehouse

Design and implementation is as follows:
1, main data inventory table
Material ID, location, inventory date (date of the initial inventory), material batch

2, the material for ins and outs of the daily data sheet

Material ID, location, date, operating categories (purchase inventory, production acquisition, production material return), material batch, the balance

Loading and unloading of material balance is every time with the material data changes (increase and decrease)
This design is reasonable?

CodePudding user response:

I think your little table, inventory table to record your materials in location, the number of existing on this form and your second daily operation table should be associated with the use of,
As for zhang inventory that table 1, the initial inventory quantity should also come from the stock list, and after completion of inventory, you should use the final inventory quantity to update the stock list,

CodePudding user response:

Add:
Inventory have a plate of gains and losses, inventory surplus to do other warehousing; Dish deficient to do other outbound
As for stock want to consider, I think than warehouse settlement whether points, for example, a device in different warehouses will have different costs (such as local buy $5, outside buy 8 dollars)
1, the inventory balance sheets (view the current inventory, whether spending points warehouse display view)
2, the history of inventory balance inventory detail (see history)
3, send list

CodePudding user response:

Enters sells saves the data structure of tables:
Inventory list
Purchase inventory table
Purchase return outbound table
Sales of outbound table
Sales return warehouse table
The profit and loss sheet

When it comes to cash flow, and then do a cash flow of library table (do CaiWuZhang) :
Inventory amount table
Procurement statement
Purchase return statements
Sales statement
Sales return statements
Profit and loss statement
Invoice table

In addition to these, of course, basic data table
Material list
Supplier list
The customer table
Such as

CodePudding user response:

Every step links can also be expanded again and processes, such as purchasing storage table can have before purchasing schedule, purchase orders, according to purchasing plan automatically split the order and the printing process, after goods to the warehouse for inspection, qualified do put in storage after processing, unqualified to do purchase return application form, purchase return to purchase return after examination and approval, may end up a goods not to also did not put in storage, but the process had gone again,

CodePudding user response:

Enterprise management mode is: raw material ordering, with raw material processing products, the products are sold,
As raw materials, product inventory gains and losses discovered will offer operation, how to operate

CodePudding user response:

Manufacturing process is the process of the assembly step materials products more, other parts are the same,
Raw material and product inventory, purchasing raw materials - assembled products - sales, purchased raw materials didn't assembled into the product and the assembled product didn't sell out,
This part is the so-called inventory, inventory is according to the operation of the warehouse inventory, warehouse have raw materials and products, will be to control,
Inventory - a plate of incurring losses is to adjust the system inventory and actual inventory,
The operation of the need to:
Prepare inventory list (MingPan and dark pools, MingPan number is printed out to make inventory, the grey is not print number, direct physical inventory), light and shade plate of advantages and disadvantages on enterprise how to control,
Print the inventory table
Warehouse for inventory
Inventory table registration
Difference data checking list (here only to print out the number of inconsistencies, and then again in inventory)
Checking into the
Verification and
Inventory surplus inventory ahortage update inventory data
Automatically generate the profit and loss sheet (financial)
The following is the process of CaiWuZhang ~ ~ ~

CodePudding user response:

Gains and losses discovered disk data, how to deal with in the software inventory data and theory data

CodePudding user response:

Inventory surplus to add inventory, inventory ahortage inventory reduction, new inventory quantity=inventory quantity + inventory surplus quantity (number of dish deficient: negative)

CodePudding user response:

Directly to the operating categories down into different columns is more appropriate,

CodePudding user response:

Plate of gains and losses, loading and unloading problems must be daily, while the new inventory quantity=inventory quantity + inventory surplus inventory ahortage number, the system with the formula of inventory and actual inventory data is consistent, however, such as system inventory as of 2020-3-31, after the inventory system inventory revised with the above formula, then query after the 2020-3-31 days as of the inventory, use the following formula: the 2020-3-31 days as of inventory=its early last month inventory count - outbound + warehouse and the data and the data is not the same as the 2020-3-31 day, because with inventory data revised one day on the number of inventory, whether have this kind of situation? In the software of how to solve?

CodePudding user response:

references to the tenth floor dxinyan response:

gains and losses discovered dish, certainly is daily problems directly, while the new inventory quantity=inventory quantity + inventory surplus dish deficient quantity, the system with the formula of inventory and actual inventory data is consistent, however, such as system inventory as of 2020-3-31, after the inventory system inventory revised with the above formula, then query after the 2020-3-31 days as of the inventory, use the following formula: the 2020-3-31 days as of the inventory=its early last month inventory count - outbound + warehouse and the data and the data is not the same as the 2020-3-31 day, because with inventory data revised one day on the number of inventory, whether have this kind of situation? In the software of how to solve?

Not simply increase or decrease inventory, inventory is based on inventory increase or decrease inventory surplus inventory ahortage single to update,
The 2020-3-31 days as of the inventory=its early last month inventory + inventory count - dispatch number + inventory surplus (plate vexed the number)
Inventory profit and loss sheet and receipt outbound order is the same, is to change the inventory,

CodePudding user response:

Can understand it, such as finished goods inventory calculation of A system is 1000, but the inventory count is 1200 inventory surplus, the extra 200 inbound processing, so how to deal with inventory?
Is on the table for ins and outs of adding a number of 200 records? If so, the production date how to define the 200?
Finished product B system inventory is 2000, but counting the inventory is 1700, less 300 libraries to deal with, so how to deal with the delivery? Is on the table for ins and outs of adding a number of 300 records? But as a finished product sold the outbound is

CodePudding user response:

CodePudding user response:

Yole

reference 4 floor response:

links can also be expanded again and process each step, such as purchasing inventory table can have before purchasing schedule, purchase orders, according to purchasing plan automatically split the order and the printing process, after the goods to the warehouse for inspection, qualified do put in storage after processing, not qualified to do purchase return application form, the purchasing after the return of the examination and approval to purchase return, may end up a goods not to also did not put in storage, but the process had gone again,

too many details, actually is the supply chain and production module, thin but also make out an invoice, receipt, verification series

refer to 12 floor dxinyan reply:

can you understand it, such as finished goods inventory calculation of A system is 1000, but the inventory count is 1200 inventory surplus, the extra 200 do warehousing processing, so how to deal with inventory?
Is on the table for ins and outs of adding a number of 200 records? If so, the production date how to define the 200?
Finished product B system inventory is 2000, but counting the inventory is 1700, less 300 libraries to deal with, so how to deal with the delivery? Is on the table for ins and outs of adding a number of 300 records? But as a finished product sold the outbound is

To design a "other receipt" and "other outbound order", loading and unloading, runs in the usual business time generated by the date for the documents, such as today is May 19, customer inventory cost accounting to may, the warehousing date fill in May

CodePudding user response:

refer to 12 floor dxinyan reply:

can you understand it, such as finished goods inventory calculation of A system is 1000, but the inventory count is 1200 inventory surplus, the extra 200 do warehousing processing, so how to deal with inventory?
Is on the table for ins and outs of adding a number of 200 records? If so, the production date how to define the 200?
Finished product B system inventory is 2000, but counting the inventory is 1700, less 300 libraries to deal with, so how to deal with the delivery? Is on the table for ins and outs of adding a number of 300 records? But as a finished product sold the outbound is

An inventory adjustment, adjust the pattern is set to: inventory profit and loss
Profit and loss of the finished product batch corresponding add to inventory.

CodePudding user response:

Data process isn't that true, the inventory data contrast calculation of inventory data and system, the inventory surplus inventory ahortage records extracted, and then inserted into a separate inventory adjustment?
Add and subtract inventory table, the inventory adjustment data record for ins and outs of the same, to keep

CodePudding user response:

reference 15 floor Yole response:

Quote: refer to 12 floor dxinyan reply:

Can understand it, such as finished goods inventory calculation of A system is 1000, but the inventory count is 1200 inventory surplus, the extra 200 inbound processing, so how to deal with inventory?
Is on the table for ins and outs of adding a number of 200 records? If so, the production date how to define the 200?
Finished product B system inventory is 2000, but counting the inventory is 1700, less 300 libraries to deal with, so how to deal with the delivery? nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull