How to set 0 Inventory not to be displayed
1. Design background
Many users will use forms to design the purchase, sale, storage, and warehousing scenarios. In order to improve the efficiency of data entry and reduce the interference of invalid data, data with inventory 0 in the intermediate table needs to be hidden, you only need to display inventory data. So, how can we set the data of 0 inventory to not be displayed?
There are many ways to implement this function. We use the simplest one to filter out 0 inventory data by associating the data of form components.
2. Form design
For more information about the purchase, sale and storage system, see the following documents:Purchase, sale and storage system construction
Create an item firstBasic information tableAnd enter basic data.
Create a inbound table, an outbound table, and an intermediate table inventory statement respectively.
[Warehousing table]]: add an associated form component to the subform, associate the item code in the item information table, and use data to fill in the item name and item model, the three fields of item code are automatically displayed in the single-line text and numeric component.
[Middle-inventory statement]]: update the data of the subform entered in the inbound table to the corresponding product in the middle-inventory statement. (The design of the intermediate table will be explained later)
[Outbound table]]: add an associated form component to the subform, associate the item code in middle-inventory statement, and display the remaining inventory data. Use the data to fill in the item name, item model, item code, the four fields of the current inventory are automatically displayed in the single-line text and value component. (The design of the intermediate table will be explained later)
Filter condition settings for associated form components: The data filtering conditions in the associated form component areCurrent inventory> = 1.
3. Intermediate table-business association rule design
By configuring business association rules in the inbound table and the outbound table respectively, the number of corresponding products is increased at Inventory statement when warehousing and the number of corresponding products is decreased at Inventory statement when outbound, and the current inventory is calculated.
Note: When configuring the EQ condition of the business association rule, the object encoding of the associated form component cannot be used. You must fill the object encoding into a single line of text and compare it with a single line of text values.
[Inbound table] the configuration of business association rules is shown in the following figure:
[Outbound table] the configuration of business association rules is shown in the following figure:
[Outbound table] when submitting data, the submission is blocked when the outbound quantity is greater than the current inventory. The configuration is shown in the following figure:
4. Effect demonstration
In the middle-inventory statement, the inventory of wireless keyboard items in the keyboard is currently 0, and the inventory of wired keyboard items is currently 2
When you select an item in the outbound table, the item that is 0 will no longer be displayed, and only the wired keyboard with the inventory of 2 will be displayed.
5. Video demonstration
YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!
-------------------- Get the latest information YIDA, welcome to follow US--------------------
