Thanks a lot Esgici.
To input transactions, one has to
- Allocate Unit of Measurements to the Material
- Allow the Material to a location
- Allow the operation(s) ( issue, receipt, consumption, transfer etc) to location(s)
- Allow the unit of measurement to the material in each location.
This is to control the movement and operation of a particular material in a particular location.
For example, you can allow 'material1' in 'location1' only to be 'receive'd and 'transfer'red but not consumed.
Ware-Soft (A Warehouse management Software)
Moderator: Rathinagiri
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Ware-Soft (A Warehouse management Software)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: Ware-Soft (A Warehouse management Software)
Thanks Rathi, useful clarificationrathinagiri wrote:Thanks a lot Esgici.
To input transactions, one has to
- Allocate Unit of Measurements to the Material
- Allow the Material to a location
- Allow the operation(s) ( issue, receipt, consumption, transfer etc) to location(s)
- Allow the unit of measurement to the material in each location.
This is to control the movement and operation of a particular material in a particular location.
For example, you can allow 'material1' in 'location1' only to be 'receive'd and 'transfer'red but not consumed.
Perhaps our "ware house" management a little different than yours
For example :
- "Unit of Measurements" is a "property" of material, so it must (or may) be enter while adding material info.
- "Location" is another property, but no belong to the material. A material may be exists more than one location
etc.
So, I have some difficulties to understand how works this data management system
Anyway your work is wonderful, thanks again.
Best regards
--
Esgici
Viva INTERNATIONAL HMG
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Ware-Soft (A Warehouse management Software)
Hi Esgici,
The same here too!
- A material can be in more than one location.
- Regarding Unit of Measurement, one material can have two or more units! (yes, for example, milk can be in number of tins, then in number of liters (we can define the factor that 1 tin = 10 liters). Here liter is the basic unit and tin is a factor unit. So, we are separately linking this material and unit in a different window. So, we can move 'Milk' from 'Location 1' as tins and received and processed in 'Location 2' as 'Liters'.
In my software, all materials can not be moved to all the locations. To have a control over the materials and operations in various locations, one has to allow material, operation and unit in every location once.
Now, this is window Product-> UoM to link materials and Units. Here you can see that 'Material 1' basic unit is 'Kgs' (for which the factor is 0 ) and the factor unit is 'Bags' being 1 Bag = 10 Kgs.
After that we have to select location control.
1. We have to allow the material in the location. This is the first tab. Left side you have a list of all available products, and in the right side you have allowed materials in location. We can remove or add by pressing the arrow buttons.
2. We have to allow some operations in the location. It is done in the second tab. You can add the operations allowed for this location. For example, we are allowing only receipt and transfer operations for this location.
3. The third and final is for defining the Unit of Measurement for the material in the particular location. Now we are allowing only 'Bags of 10 Kgs' in this location.
Now, we can enter only 'Bags of 10 kgs' of 'Materia 1' to be received or transferred in location 1. We have to configure like this whenever we want to add some materials to the locations.
Hope I have explained correctly.
The same here too!
- A material can be in more than one location.
- Regarding Unit of Measurement, one material can have two or more units! (yes, for example, milk can be in number of tins, then in number of liters (we can define the factor that 1 tin = 10 liters). Here liter is the basic unit and tin is a factor unit. So, we are separately linking this material and unit in a different window. So, we can move 'Milk' from 'Location 1' as tins and received and processed in 'Location 2' as 'Liters'.
In my software, all materials can not be moved to all the locations. To have a control over the materials and operations in various locations, one has to allow material, operation and unit in every location once.
Now, this is window Product-> UoM to link materials and Units. Here you can see that 'Material 1' basic unit is 'Kgs' (for which the factor is 0 ) and the factor unit is 'Bags' being 1 Bag = 10 Kgs.
After that we have to select location control.
1. We have to allow the material in the location. This is the first tab. Left side you have a list of all available products, and in the right side you have allowed materials in location. We can remove or add by pressing the arrow buttons.
2. We have to allow some operations in the location. It is done in the second tab. You can add the operations allowed for this location. For example, we are allowing only receipt and transfer operations for this location.
3. The third and final is for defining the Unit of Measurement for the material in the particular location. Now we are allowing only 'Bags of 10 Kgs' in this location.
Now, we can enter only 'Bags of 10 kgs' of 'Materia 1' to be received or transferred in location 1. We have to configure like this whenever we want to add some materials to the locations.
Hope I have explained correctly.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: Ware-Soft (A Warehouse management Software)
No "correctly", but "perfectly"rathinagiri wrote: ...
Hope I have explained correctly.
I acquired some new and useful ideas for my software from this explanation, many thanks
Best regards
--
Esgici
Viva INTERNATIONAL HMG