Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inventory app master data structures for remarks
Message
 
To
22/04/2003 20:48:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00775412
Message ID:
00780463
Views:
18
>>>Do you need a hierarchy ("A" contains "B", "B" contains "C", etc., perhaps for several levels), or do you want to consider >this for future expansion?
>>
>>Will my BOM Master suffice for this?
>
>In principle, your BOM contains references to what item contains what other item. But another point, which I consider vital, is that all items (raw material, intermediate articles at several levels, and the finished article) have to be in the same table - otherwise, it is very difficult to make proper relations.

Yes the Items Master will contain all item names before it can be used in BOM Master or in it's own heirarchy.

>
>>And finally at the time of transaction data entry totally undiscussed yet, do I have to get the Item, SecUnit, Location or is there a better way than such brute force data entry?
>
>I don't quite understand what you mean with this.

As we discussed previously there is this SecUnit (1kg, 10kgs), so when the user enters the transaction I will have to get the name of the item, the SecUnit and maybe also the location of where the goods were received/dispatched. Say the user enters Tobacco, 10kgs, SuburbanUnit, Qty. 50 (internally 50*10=500kgs of Tobacco)

Now is this the only option to get things one by one ie. Tobacco, 10kgs, SuburbanUnit or is there an intelligent way to do it?

>
>Hilmar.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform