Purchase, sale and storage system construction
1. Usage scenarios
The purchase, sale and storage system can helpHelp enterprises to manage commodities in an orderly manner, quickly enter commodity information, quickly exit the warehouse, accurately query the inventory data and warehouse information of each product anytime and anywhere, each entry and exit record of the product can be clearly checked, so how do we realize the entry and exit statistical inventory?
2. Video Display
3. Procedure
3.1 build a page
(1) new product page: Common form
Used to add product information, including product name, product specification, and unit price
(2) warehousing page: Common form
Includes warehousing personnel, warehousing time, and warehousing details. The details include product name, product specifications, and public int count.
(3) outbound page: process page
The list includes the outbound person, outbound time, and outbound list. The list includes the product name, product specification, current inventory number, and outbound number. Different from the inbound list, the outbound application needs to be approved before it can be submitted.
(4) inventory page: form page
Including product name, product specification and inventory quantity
3.2 configure Business Association formula
(1) when the purchase table is changed, update inventory statement
Enter a commodity in the purchase table. If the data of the same commodity name exists in the inventory table, add public int count to the inventory quantity of the commodity. If the commodity name cannot be found in the inventory table, insert the commodity name into inventory statement. The inventory quantity is the inventory quantity. In this case, we can use the business association formula UPSERT to implement it. The formula configuration is shown in the following figure:
(2) update inventory statement when the shipping table changes
After a product is shipped out of the warehouse, check whether there are products in the inventory, and automatically obtain the quantity of the goods. After obtaining the quantity of the goods, the warehouse will be shipped out according to the quantity. If the quantity of the goods is greater than the inventory, the warehouse will be blocked, if the outbound quantity is less than the inventory quantity, the corresponding quantity will be reduced in the inventory after approval.
1) configure data linkage to automatically obtain inventory quantity
2) configure the verification formula. If the outbound quantity is greater than the inventory quantity, the outbound quantity will be blocked.
Path:Process> settings on the right> node submission rules> Create
3) configure node submission rules and modify the inventory quantity after approval. Here we use the UPDATE formula
Path:Process> settings on the right> node submission rules> Create
##> click the link to authenticate now ##<
「Click me for free consultation!」
Kuairen enters the digital age step by step
-------------------- Get the latest information YIDA, welcome to follow US--------------------
