Re-Usable Items entry in system using VB

As I have already shared with you about “Re-Usable Items” practice, their purpose and benefits now I want to share my experience about an application for recording all transaction regarding “Re-Usable Items”. With the help of this application I never lose any record from my system and easily sought out any record, it can also help for compiling many types of reports in a second. 

You can use MS-Excel too for this purpose, but there are many chances of mistakes, deletions, additions etc without your knowledge because MS-Excel is manual entry program.

Let see about my application for “Re-Usable Items”

First of all I need a database for storing “Re-Usable Items” data in system, so I designed with the following fields.

1. Item Code / Material Code / Material Number / etc

2. Description / Nomenclature / Summary / etc

3. Document Number / receiving number  / etc 

4. Unit / UOM / etc

5. Item User / Item Department / etc

6. Date of first time issuance

7. Date of submission

8. Any work order / maintenance number (if available)

9. Reason / remarks / fault detail / etc

10. Item condition

11. Received Quantity 

12. Item removed from which machine / equipment / etc

You can use more field as per your requirements.

When a “Re-Usable Item” received in store then we must check all necessary fields in receiving document and few proper marking / tagging on item/spare/part. After complete verification of documents and item, an entry will pass in system with the help of VB application. 

With the help of this application user can easily:

• Gathered or compile all your inventory in database for acquiring field as you want

• Pass new entry in database

• Edit/delete any entry

• Easily sought out any item

• Easily sought out any types of items such as (re-usable, repairable, scrap, ir-repairable etc)

• Extract many types of reports on your management requirements

• Easily calculate the numbers of items by their types, conditions, departments, etc

• Monthly reporting

• Overview reporting

• Compile reports condition-wise

• Compile reports department-wise

• Compile reports item-wise

• Compile reports date-wise

• Compile reports returning status-wise

And many more functions of this application can help the store and user for their "Re-Usable Items" and saving a big amount and time of your respective company.

Read More

Re-Usable Items in Inventory Management

Today I am sharing a profitable idea in inventory management by which you can save lots of money of your companies. During my professional career I learn a practice of “Re-Usable Items” in an energy sector. I was the part of inventory management in energy sector and this “Re-Usable Item” practice save a huge amount of my company. By using this practice you can save your purchasing, searching, and space.

What is “Re-Usable Items” practice?

Basically this is practice is focusing on your efficiency. 

For example: 

“I am quoting here an example of energy sector where I learn and gain this practice.”

If any item/part/spare is alarming of fault, so user want to replace it on urgent basis for saving production losses. In any organization/company actually you must be need to resolve the problem without losing a minute, so at this time you can not verify the fault of that item/spare/part. Simply you need to replace this part. It OK! But when you finished your job and remove the fault of machine or after completion your job and resolve the problem from machine you can check and verify the fault of that faulty part/item/spare.

In easy words I suggest you that every item/part/spare never loses its complete functions, if there is something went wrong in any item/part/spare so that mean there is a problem in this part, not complete part is faulted. But for time and production loses saving you need to replace this item but after replacement you must be check and verify the fault of that faulty spare/item/part. If you have not enough time to do this practice so you can return this item to your store/warehouse in repairable condition. Store/warehouse can store this item/part/spare in a separate store. In our energy sector we have design an area for storage of “Re-Usable Items”.

For a standard and good practice you need documentation or record keeping in every step. Just like when you want to issue an item from store so you must be submit an issue note, debit note, etc in store. So for returning the faulty item/part/spare in store you need this practice too. After submitting your faulty part/item/spare in store you set a timeline after peak season of your production for proper check and repairing activities of that faulty item/spare/part. If your part/item/spare can be repaired by user so re-issue it from store against a document and after repairing you can re-submit this item in store in usable condition or if this item/spare/part cannot be repaired so user can submit this item/part/spare in store in scrap condition then store scrapped these items according to their timelines and practices.

Store can be record these all transactions in their respective systems SAP, Oracle ERP, QuickBook, PeachTree etc, I have also design a program in database with the help of VB. If anyone want any help in this respect so you can mail me with your opinion and requirements. 

A simple introduction of my VB application related to “Re-Usable Items” is here.

Read More

SAP Material Requirement Planning (MRP) MM01

Material requirements planning (MRP) is to monitor stocks and in particular to automatically generate order proposals for purchasing or production. For this purpose you can define re-ordering levels to your stocks/material, by this SAP automatic intimate the defined user when the stock level go down from the re-ordering level.

Field Name	R/O/C	Description
MRP Type	R	Key that determines whether and how the material is planned. Select as follows:  - VB for stores and spares  - PD for production related materials  - ND for material with no planning requirement
Reorder Point	C	Applicable if VB is selected. The system compares available warehouse stock with the reorder level. If available stock falls below the reorder level, an order proposal is generated. Example: 10

Field Name	R/O/C	Description
MRP Controller	R	The MRP controller or group of MRP controllers responsible for material planning for the material.
Lot Size	R	Is used to calculate the purchase order quantities. LTC specific lot sizes are: for VB - EX (lot for lot order qty), HB (replenish to max.) for PD - PW weekly lot sizing key is to be selected. for PD - MB monthly lot sizing key is to be selected.

Read More

SAP (MM) Material Creation (MM01) Ch-1

All the information your company needs to manage a material is stored in a data record in the material master.

For every material that ABC used must create a material master record in the material master, This record is uniquely identified by a system generated material number.

The creation / change / deletion of material master in SAP system has to be carried out with reference to the material master form. This form will contain the data which is to be entered or changed. The form will provided by the requester to the master data controller.

Field Names	R/O/C	Description
Material	R	Internally generated number so needs to enter anything
Industry Sector	R	Select industry sector. Example: Power Utility
Material Type	R	Select suitable material type Example: 01 Stock & Spares
Change Number	O	Change number is the reference # of material master changes.
Copy From Material	C	Enter existing material No. Material whose data you want the system to copy as default values

Material Type Used	Mapping to Material in LTC
Stock & Spares	Cigarette Paper, Tripping Paper, Cutting Disc etc.	ZSPR
Chemical & Lubes	CWC, HL, Outer Wrapper, etc	ZCHM
Medical Supplies	Filter Rods, etc	ZMED
Tools & Equipment	Wrench, Hammer, Pliers etc	ZEQP
Stationary	Poster, Stickers, TV, Give-away etc	ZSTN

Select an option "Select ü Views"

Select the views in which information is to be updated. Refer to the "Material Master Form". Provided by the requester for the views selection.

Click ü after selecting the views.

Please enter/select relevant data in Organization level as mentioned in the material master data form.

Click ü then next screen will appear, in which further information will be updated. These screens will depend upon the views which were selected in section "Select Views".

The symbol ü of current screen are mandatory fields.

In basic data 1 views please enter the following data.

Field Name	R/O/C	Description
Material	R	You can enter material description
Base Unit of Measure	R	Select base unit of measure. Press F4 to select from the list. Example: EA (Each), KG (Kilo Gram) etc
Material Group	R	Select Material Group. In addition to material type, each material record can further be grouped using material group for LTC, a 5-digit code will be sufficient to meet the sorting and reporting requirement. Press F4 to select from the list. Example: E0MK8
Old Material No.	R	Enter material code mentioned in Legacy system. Example: Y30012593

Please enter the following data.

Field Name	R/O/C	Description
Sales Unit	O	A Unit of measure in which a material is sold.

Please enter the description/specification about the material.

Field Name	R/O/C	Description
Purchasing Group	O	Buyer or a group of buyers, who is/are responsible for certain purchasing activities. Example: P02, etc
Mfr part number	O	Specifies the number used by the manufacturer, or also by the vendor to manage a material.
Mfr	O	Specifies the manufacturer of the MPN material or the manufacturer's plant for which a manufacturer master record has been created.

Read More