Hi,
While making entries for movement of stock in and out of inventory, I usually face two situations -
#1 New Stock is being added to the inventory, with related invoice details (in which case column TypeofEntry = "Invoice")
#2 Stock is removed from the inventory, for use in the manufacturing process (in which case column TypeofEntry = "Others"). Side note - It is possible that Stock not used that day in the manf process could be returned to the main stock (in which case again, column TypeofEntry = "Others")
For situation #1, in addition to other data (e.g. Qty being added/ removed), I also capture Invoice#, S#, Price Per Unit & Line Sub Total (i.e. Qty x Price Per Unit)...
For situation #2, I use the Show If & Required If features to hide/ suppress these 4 columns.
The problem arises when a user mistakenly sets the TypeofEntry = "Invoice", and adds Invoice#, S#, PPU & LST..... then realises his/ her mistake and changes the TypeofEntry to "Others". At this point, the data entered under Invoice#, S#, PPU & LST is not reset, rather, it persists. This causes big problems when I am filtering or summing up data using those 4 fields, as those rows too, appear in the results.
Is there anyway to automatically clear those 4 columns/ reset the data, when TypeofEntry is changed from Invoices to Others?
LinkedIn
Twitter
