BP080 Future Process AWCCS Inventroy V2.2

AIM

BP.080 FUTURE PROCESS MODEL Al Wathba Company for Central Services Inventory

Author:

K.Babu

Crea reation Date:

Apri Ap rill 19 19, 20 2011

Last Updated:

June 29, 2011

Document Ref:

INV - BP80

Version:

Final V2.2

CSC India (P) Ltd Confidential - For internal use only

BP.080 Future Process Model – Inventory, AWCCS

Document Control Change Record6 Date

19-APr11 28-Apr11 24-May11 29-Jun11

Author

Ver sio n

K.Muthukumarasam y K.Muthukumarasam y K.Muthukumarasam y K.Babu

V0. V0. 1 V0. 2 V1. 0

Change Reference Reference

final Updated as per suggestions from AWCCS Team. Updated as per agreed discussions Updated as per the latest org Structure Structure

Reviewers Name

Position

Dumitru Iantela Raouf Abdelrazek Ibrahim Ali

AWCCS Inventory manager AWCCS Purchasing manager

Approvers Name Ayman Hazem Tanouli Kunal Kaushal

Position El

Date

AWCCS - CSO CSC- Project Manager

Distribution Cop y No. 1 2 3 4

Name

Project Library

Location

AWCCS- CSC

Note to Holders: If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

Inventory File Ref: 105752118.doc

Document Control Company Confidential - For internal use only

ii


Contents

Document Control........................................................................................ Control........................................................................................ ii Event Catalog.................. ...................................... ......................................... .................................... ..................... ............ ........... ........ ...1 Inventory Invento ry................... ....................................... ........................................ .............................. ............... ........... ............ ........... ......... ....1 Process Proces s Listing and Process Descriptions Descriptions.................. ............................ ............... ........... ............ ........... ........ ...2 Inventory Invento ry................... ....................................... ........................................ .............................. ............... ........... ............ ........... ......... ....2 Process Proces s Step Catalogs................... ....................................... ......................................... ...................................... ...................... .....5 System Configuration Configuration................... ....................................... ........................................ .............................. ............... ........ ...5 Process Proces s Flow Diagram for Enterprise –Structure................... ............................ ............... ........... ......... ....6 6 Proposed AWCCS Organization Proposed Organization Structure: ............................................ ............................... ............... ..7 Business Busines s Group: Group:................... ....................................... ......................................... ............................. .............. ........... ........... ......7 Ledger:................... ....................................... ........................................ ................................. .................. ........... ............ ........... ......... ....7 Legal Entity: Entity:.................... ........................................ ........................................ ........................................ ......................... ........... ......7 Operating Operatin g Unit:.................. ...................................... ..................................... ....................... ........... ........... ............ ........... ........ ...7 Inventory Invento ry Organizations Organizations................... ....................................... ................................. ................... ............ ........... ......... ....7 Process Step Catalogs Item Creation & Maintenance..... .......... .......... .......... .......... .......... ........ ...... ...9 9 Process Step Catalogs Material request and Issue.... ......... .......... .......... ......... ....... ...... ...... ...... ...... ...19 19 Process Flow Material Request & Issue (Tires & Spare S pare Parts to Workshop). .22 Process Flow Material Request & Issue (Consumables /Paints to Workshop) .................................................................................................................. 24 Process Flow Material Request & Issue (Materials to Project)..... .......... ......... ....... ...... ..... ..26 26 Process Flow Material Request & Issue (Materials to Service contract) .. .... .. .. .28 Process Flow Material Request & Issue against Account code/ cost centre centr e.. ..30 30 Process Proces s Flow Worksh Workshop op Returns.................. ...................................... ..................................... ....................... .......... ....33 Process Proces s Flow Project Returns..................... ......................................... ........................................ ............................. .........35 35 Process Flow Stock Transfers (Sub inventory transfers)..... .......... .......... ......... ....... ...... ...... ..... ..36 36 Process Flow Stock Transfers (Inter org transfers)..... .......... .......... .......... ......... ....... ...... ...... ...... ..... ..37 37 Process Flow - PO Receipts ........................................................................40 Process Step Catalogs PO Receipts ...........................................................42 Process Proces s Flow Return to Supplier................... ....................................... ............................... ................. ........... ......... ....46 46 Process Proces s flow Managing Consigned Inventory................. ............................... .................... ........... ......... ....48 48 Process Proces s Flow Min-Max Planning..................... ......................................... ................................ ................. ........... ........ ..50 50 Process Proces s Flow Physical Inventory.................... ......................................... ................................ ................. ........... ....... ..52 52 Process Proces s Flow Cycle Counting................... ....................................... ....................................... ......................... ........... .......55 55 Process Proces s Step Catalogs................... ....................................... ......................................... .................................... .................... .....59 59 Period Close.................... ........................................ ......................................... ................................ ................. ........... ........... ......59 59 Inventory File Ref: 105752118.doc


ii


Process Proces s Step Catalogs................... ....................................... ......................................... .................................... .................... .....60 60 Reporting Reporti ng................... ....................................... ........................................ ..................................... ....................... ........... ........... ......60 60 Open and Closed Issues for this Deliverable................... .................................... ....................... ........... .....61 61 Open Issues.................... ........................................ ....................................... ......................... ........... ........... ............ ........... ....... ..61 61 Closed Issues.................... ........................................ ........................................ .......................... ............ ............ ............ ......... ...61 61



ii

– Inventory, AWCCS

Event Catalog This compon component ent lists lists all events events to which which the business business respon responds. ds.

Inventory Name

Type

Description

Frequency

Setup Requirement

System Configuration

Internal

Inventory Module configuration

Initial setup

AWCCS – INV-RD 010

Item Creation and maintenance Material ial re request & Iss Issu ue

Inte Intern rnal al

Whenever Required

Internal


Works Worksho hop p & Proj Projec ectt Retu Return rns s

Inte Intern rnal al

AWCCS – INV-RD 040 AWCCS – INV-RD 030

Stock transfers

Internal

Item Item Creat Creatio ion n and and modi modific ficati ation on process in AWCCS Material ial Re Request an and Is Issue process in stores Works Worksho hop p & Proj Projec ectt Retu Return rns s Process Stock transfer Process

PO Rece Receip ipts ts and and Ret Return urns

Inte Intern rnal al

Managing Consignee Inventory Min Max Planning

Inte Intern rnal al


AWCCS – INV-RD 040 AWCCS – INV-RD 020

Internal


Physical counting and Cycle counting

Inte Intern rnal al


Period Close Process

Internal

Rec Receivi eivin ng Mater ateria iall agai again nst Purchase orders. Mana Managi ging ng Cons Consign ignee ee Inve Invent ntor ory y Process Min Max Planning for Planned Items Physi Physical cal coun counti ting ng and and Cyc Cycle le counting process for Inventory Accuracy Period Close process

Whenever Required Whenever Required Whenever Required Whenever Required Whenever Required Whenever Required Whenever Required

Whenever Required


Document Control

ii

Company Confidential - For internal use only


Process Listing and Process Descriptions Inventory

Event

Process Title

Description of Process

Output

INVINV-B BP – 010. 010.01 01

Syst Syste em Conf Config igu urat ration ion

Ente Enterp rpri rise se Stru Struc cture ture

Manage Inventory

INV-BP – 010.02


Workday Calendar

Manag anage e Inve Inven ntory tory Organizations Manage Wo Working Days

INV-BP – 010.03


UOM Classes/Conversions

Item Unit of Measures and Conversions

UOM & Classes

INVINV-BP BP – 020 020.01 .01

Item Item Creat Creation ion & maintenance

Item Master

This process envisages creation of items

Active Item in Item Master

INVINV-BP BP – 020 020.02 .02


Item Categories

Item Categories

INVINV-BP BP – 020 020.03 .03


Item Template

This process envisages creation of Item Templates

Reporting Requirements Item properties Item Templates

INVINV-BP BP – 020 020.04 .04


Ite Item Rel Relati ationship

This proce ocess envisa isages creation of Relationship between Items

Item relationship

INVINV-BP BP – 020 020.05 .05


Item Query

INV-BP – 030.01

Material request & Issue

MR : Tyres & Parts

This process envisages querying Items on various parameters Material Requests from Workshop for Tyres

Query result based on parameters Material Issue

INV-BP – 030.02 .02

Mate ateria rial request & Issue sue

MR: Pain aints &

Material Requests from

Material Issue

Shift Details


Process Listing and Process Descriptions Inventory

Event

Process Title


Output

INVINV-B BP – 010. 010.01 01

Syst Syste em Conf Config igu urat ration ion

Ente Enterp rpri rise se Stru Struc cture ture

Manage Inventory

INV-BP – 010.02


Workday Calendar

Manag anage e Inve Inven ntory tory Organizations Manage Wo Working Days

INV-BP – 010.03


UOM Classes/Conversions

Item Unit of Measures and Conversions

UOM & Classes

INVINV-BP BP – 020 020.01 .01


Item Master

This process envisages creation of items

Active Item in Item Master

INVINV-BP BP – 020 020.02 .02


Item Categories

Item Categories

INVINV-BP BP – 020 020.03 .03


Item Template

This process envisages creation of Item Templates

Reporting Requirements Item properties Item Templates

INVINV-BP BP – 020 020.04 .04


Ite Item Rel Relati ationship

This proce ocess envisa isages creation of Relationship between Items

Item relationship

INVINV-BP BP – 020 020.05 .05


Item Query

INV-BP – 030.01


MR : Tyres & Parts

This process envisages querying Items on various parameters Material Requests from Workshop for Tyres

Query result based on parameters Material Issue

INV-BP – 030.02 .02

Mate ateria rial request & Issue sue Mate Materi rial al requ reques estt & Issu Issue e

INV-BP – 030.04 .04

Mate ateria rial re request & Issue sue

MR: Se Servi rvice co contract act

INV-BP – 030.05


MR: General

Material Requests from Workshop for Paints Mate Materi rial al Requ Reques ests ts from from Projects Mate aterial rial Requests fr from services for spares Material Request & Issue for General Items

Material Issue

INVINV-BP BP – 030. 030.03 03

MR: Pain aints & Consumables MR: MR: Proj Projec ects ts


Shift Details

Material Issue Material Issue Material Issue Document Control

ii


– Inventory, AWCCS Event

Process Title


Output

INVINV-BP BP – 030. 030.06 06

Mate Materi rial al requ reques estt & Issu Issue e

MR: MR: Asse Assets ts

Material Issue

INVINV-BP BP – 030 030.07 .07

Misc Miscel ellan laneo eous us Req Reque uest st & Issue

Miscellaneous transactions

Mate Materi rial al Requ Reques estt & Issu Issue e for for Assets (Stock to Assets) Stock adjustment by authorized persons.

INVINV-B BP – 030. 030.08 08

Use Used Tyre Tyres s tran transa sact ctio ion n

Used Used Tyr Tyres tran transa sact ctio ion n

INVINV-B BP – 040. 040.01 01

Work Worksh shop op & Proje roject ct Ret Return urns

INV-BP – 040.02

Workshop & Project Re Returns

INV-BP – 050.01

Stock transfers

INV-BP – 050.02

Stock transfers

INVINV-B BP – 060. 060.01 01

PO Rec Receip eipts and and Retu Return rns s

INVINV-B BP - 060. 060.02 02


INVINV-BP BP - 060 060.0 .03 3

PO Rece Receip ipts ts and and Retu Return rns s

INVINV-BP BP - 060.0 060.04 4

PO Rec Recei eipt pts s and and Retu Return rns s

INV-BP - 060.05

PO Re Receipts an and Re Returns

INVINV-BP BP – 070. 070.01 01 INV-BP – 080.01

Mana Managi ging ng Cons Consig igne nee e Inventory Min Max Planning

No valu value e tran transa sac ction tion wit with tracking. Work Worksh shop op Retu Return rns s Ret Return urns hand handli ling ng from from Workshop process Project Re Returns Returns ha handling fr from projects process Sub inventory transfer Transfer of material between sub inventories Inter org transfer Transfer of material between Rece Receiv ivin ing g – Stoc Stock k Receiving materials against Items PO Rece Receiv ivin ing g Expen xpense se Receiving Expense Goods/ Goods / services Services by the Requestor Rece Receiv ivin ing g Asse Assets ts - fle fleet et Rece Receiv ivin ing g Flee Fleett Ass Asset ets s by by the Requestor Receiving Assets -Non Receiving Non Fleet Assets fleet by the Requestor Return to to su supplier Returning Ma Material ag against PO Consig Consigne ned d Inve Invent ntor ory y Supp Supplie lierr store stores s main mainta tain ined ed in our campus process Min Max Planning Stock replenishment process

INV-BP – 090.01

Inventory accuracy

Physical Inventory

This Process is performed to verify verify the Material Physical Stock Vs

Miscellaneous transactions Processed Transaction Transaction processed Material receipt Material receipt Stock transfer Stock transfer PO Receipt PO Receipt Fleet assets Receipt Non Fleet assets Receipt PO Returns Consigned Inventory Min Max Planning Report and Purchase requisitions Inventory accuracy

– Inventory, AWCCS Event

Process Title


Output

INVINV-BP BP – 030. 030.06 06

Mate Materi rial al requ reques estt & Issu Issue e

MR: MR: Asse Assets ts

Material Issue

INVINV-BP BP – 030 030.07 .07

Misc Miscel ellan laneo eous us Req Reque uest st & Issue

Miscellaneous transactions

Mate Materi rial al Requ Reques estt & Issu Issue e for for Assets (Stock to Assets) Stock adjustment by authorized persons.

INVINV-B BP – 030. 030.08 08

Use Used Tyre Tyres s tran transa sact ctio ion n

Used Used Tyr Tyres tran transa sact ctio ion n

INVINV-B BP – 040. 040.01 01

Work Worksh shop op & Proje roject ct Ret Return urns

INV-BP – 040.02

Workshop & Project Re Returns

INV-BP – 050.01

Stock transfers

INV-BP – 050.02

Stock transfers

INVINV-B BP – 060. 060.01 01


INVINV-B BP - 060. 060.02 02


INVINV-BP BP - 060 060.0 .03 3

PO Rece Receip ipts ts and and Retu Return rns s

INVINV-BP BP - 060.0 060.04 4

PO Rec Recei eipt pts s and and Retu Return rns s

INV-BP - 060.05

PO Re Receipts an and Re Returns


Mana Managi ging ng Cons Consig igne nee e Inventory Min Max Planning

No valu value e tran transa sac ction tion wit with tracking. Work Worksh shop op Retu Return rns s Ret Return urns hand handli ling ng from from Workshop process Project Re Returns Returns ha handling fr from projects process Sub inventory transfer Transfer of material between sub inventories Inter org transfer Transfer of material between Rece Receiv ivin ing g – Stoc Stock k Receiving materials against Items PO Rece Receiv ivin ing g Expen xpense se Receiving Expense Goods/ Goods / services Services by the Requestor Rece Receiv ivin ing g Asse Assets ts - fle fleet et Rece Receiv ivin ing g Flee Fleett Ass Asset ets s by by the Requestor Receiving Assets -Non Receiving Non Fleet Assets fleet by the Requestor Return to to su supplier Returning Ma Material ag against PO Consig Consigne ned d Inve Invent ntor ory y Supp Supplie lierr store stores s main mainta tain ined ed in our campus process Min Max Planning Stock replenishment process

INV-BP – 090.01

Inventory accuracy

Physical Inventory

This Process is performed to verify verify the Material Physical Stock Vs System Stock

INV-BP – 100.01

Inventory accuracy

Cycle Counting

This Process is performed to verify verify the Material Physical Stock Vs System Stock


Perio Period d Clos Close e Proc Proces ess s Custom Reports

Period Close

Closing periods.

Period Close

Custom reports

AWCCS Custom reports

Custom Reports


Miscellaneous transactions Processed Transaction Transaction processed Material receipt Material receipt Stock transfer Stock transfer PO Receipt PO Receipt Fleet assets Receipt Non Fleet assets Receipt PO Returns Consigned Inventory Min Max Planning Report and Purchase requisitions Inventory accuracy maintained Inventory accuracy maintained

Document Control

ii





Document Control

ii



Process Step Catalogs System Configuration ID

Process

Process description

Fitment Type

Fitment Description

Automat ion

INV.BP.010.01

Enterprise Structure

Requirement of the various elements of Enterprise/Organization Structure, for consolidating the AWCCS business activities. Inventory Organizations are defined as per the business needs and any future addition to this depends upon the business need, for example, better accountability, expansions, etc.

Standard

Initial Setup

Manual

INV.BP.010.02

Workday Calendar

Appropriate Calendar Names, Workday Pattern (Weekly off Details) Shift Timings, Exception Days (Holiday list) can be defined.

Standard

Initial Setup

Manual

Stan Standa dard rd

Initi Initial al setu setup p & As and when required

Manual

In AWCCS workday will be 24H X 7D ON for all 365days in a year as requested.

INV.BP.010.03

Unit of Measures

Define UOM Class Name, Description, UOM Base Class Unit, UOM and UOM Conversion will be defined as per requirement of


Process Step Catalogs System Configuration ID

Process

Process description

Fitment Type

Fitment Description

Automat ion

INV.BP.010.01

Enterprise Structure

Requirement of the various elements of Enterprise/Organization Structure, for consolidating the AWCCS business activities. Inventory Organizations are defined as per the business needs and any future addition to this depends upon the business need, for example, better accountability, expansions, etc.

Standard

Initial Setup

Manual

INV.BP.010.02

Workday Calendar

Appropriate Calendar Names, Workday Pattern (Weekly off Details) Shift Timings, Exception Days (Holiday list) can be defined.

Standard

Initial Setup

Manual

Stan Standa dard rd

Initi Initial al setu setup p & As and when required

Manual

In AWCCS workday will be 24H X 7D ON for all 365days in a year as requested.

INV.BP.010.03

Unit of Measures

Define UOM Class Name, Description, UOM Base Class Unit, UOM and UOM Conversion will be defined as per requirement of Inventory Organizations.


Document Control

ii



Process Flow Diagram for Enterprise –Structure

AWCCS Business Group

AWCCS Legal Entity ntity

AWCCS Operating Unit

AWCCS AWCCS Item Master

AWCCS General Store

GEN-MSF

AWCCS Workshop Musaffah

AWCCS Workshop Dubai

WS-MN-MSF

AWCCS Workshop Baniyas

AWCCS Workshop Sharjah

AWCCS Workshop Al Ain

AWCCS Workshop Bedazayed

AWCCS Workshop Al Mirfa Mirfa

AWCCS Workshop Ghaiathy

AWCCS Workshop Sila

HVAC-M-BYS

GEN -AIN WS-WIP-MSF HVAC-PJ-BYS GEN- BYS BYS WS-RTN-MSF GEN-BDS

GEN-GYT

HVAC-R-BYS

WS-UN-MSF HVAC-U-BYS

GEN-UN-MSF WS-SRP-MSF HVAC-S-BYS GEN-SUR-MSF

AWCCS HVAC Store


Process Flow Diagram for Enterprise –Structure

AWCCS Business Group

AWCCS Legal Entity ntity

AWCCS Operating Unit

AWCCS AWCCS Item Master

AWCCS General Store

AWCCS Workshop Musaffah

GEN-MSF

AWCCS Workshop Dubai

AWCCS Workshop Baniyas

AWCCS Workshop Sharjah

AWCCS Workshop Al Ain

AWCCS Workshop Bedazayed

WS-MN-MSF

AWCCS Workshop Al Mirfa Mirfa

AWCCS Workshop Ghaiathy

AWCCS Workshop Sila

AWCCS HVAC Store

HVAC-M-BYS

GEN -AIN WS-WIP-MSF HVAC-PJ-BYS GEN- BYS BYS WS-RTN-MSF GEN-BDS

HVAC-R-BYS

GEN-GYT

WS-UN-MSF HVAC-U-BYS

GEN-UN-MSF WS-SRP-MSF HVAC-S-BYS GEN-SUR-MSF

Organization Structure for illustrative purpose only


Document Control

ii



All workshop Orgs have the sub inventories like shown above. Also sub inventories are defined as per the business requirement for each inv organization. Proposed AWCCS Organization Structure:

AWCCS will have a single Operating Unit structure owing to centralized activities relating to invoicing, payments and receipt management and without any specific need to secure such data a cross locations/ line of o f businesses. Business Group:

AWCCS will have a single Business Group as the data relating to employees will be shareable across the company. This is an Organization Organization that represen represents ts the consolidate consolidated d enterprise, enterprise, a major division, division, or an operation company company and has has no accounting impact. The Business Group partitions Human Resources information and the Purchasing Approval Hierarchy. Ledger:

AWCCS will have a single Ledger for its accounting and reporting requirements. Legal Entity:

AWCCS currently has one reporting entity for which consolidated fiscal reports are submitted. Accordingly, one legal entity will exist i.e. AL-Wathba Company of Central Services P.J.S.C. Operating Unit:

AWCCS will have a single Operating Unit structure owing to centralized activities relating to invoicing, payments and receipt management and without any specific need to secure such data a cross locations/ line of o f businesses Inventory Organizations

AWCCS will have following inventory organizations to track the inventory transactions and balances. The following are the Inventory Organizations of AWCCS: 1. AWCC AWCCS S Item Item Mast Master er 2. Gene General ral Store Stores s 3. HVAC Stores 4. Workshop Musaffah 5. Worksh Workshop op Dubai Dubai


All workshop Orgs have the sub inventories like shown above. Also sub inventories are defined as per the business requirement for each inv organization. Proposed AWCCS Organization Structure:

AWCCS will have a single Operating Unit structure owing to centralized activities relating to invoicing, payments and receipt management and without any specific need to secure such data a cross locations/ line of o f businesses. Business Group:

AWCCS will have a single Business Group as the data relating to employees will be shareable across the company. This is an Organization Organization that represen represents ts the consolidate consolidated d enterprise, enterprise, a major division, division, or an operation company company and has has no accounting impact. The Business Group partitions Human Resources information and the Purchasing Approval Hierarchy. Ledger:

AWCCS will have a single Ledger for its accounting and reporting requirements. Legal Entity:

AWCCS currently has one reporting entity for which consolidated fiscal reports are submitted. Accordingly, one legal entity will exist i.e. AL-Wathba Company of Central Services P.J.S.C. Operating Unit:

AWCCS will have a single Operating Unit structure owing to centralized activities relating to invoicing, payments and receipt management and without any specific need to secure such data a cross locations/ line of o f businesses Inventory Organizations

AWCCS will have following inventory organizations to track the inventory transactions and balances. The following are the Inventory Organizations of AWCCS: 1. AWCC AWCCS S Item Item Mast Master er 2. Gene General ral Store Stores s 3. HVAC Stores 4. Workshop Musaffah 5. Worksh Workshop op Dubai Dubai 6. Worksh Workshop op Bani Baniyas yas 7. Worksh Workshop op Shar Sharja jah h 8. Worksh Workshop op Al Ain 9. Workshop Workshop Bedazay Bedazayed ed Inventory File Ref: 105752118.doc

Document Control

ii



10.Workshop Al Mirfa 11.Workshop Ghaiathy 12.Workshop Sila

All the item item codes codes will will be defined defined in the AWCCS AWCCS Item Master Master Organi Organizati zation on,, which which is a logical logical Invent Inventory ory Organization and will not have any transactions. Then transactions. Then it will be assigned assigned to appropriat appropriate e organizatio organizations. ns. Above Inventory Inventory Organizations Organizations except AWCCS Item Master Master will have Sub Inventories Inventories across locations locations in UAE. Sub Inventory Organizations are the physical locations, which will be used to inventories, track and transact inventories.

INV ORG & SUB INV DETAILS:

AWCCS INV ORG & Sub Inv.x Inv.x ls

Locators:

Locators are the specific storage Racks and Bins in a Sub inventory (Stores). Based on the AWCCS business requirement, Locators can be defined in all or specific sub inventories. In Project sub inventories, ‘Project’ and ‘Task’ will be captured in the appropriate Locator Field segments.


10.Workshop Al Mirfa 11.Workshop Ghaiathy 12.Workshop Sila

All the item item codes codes will will be defined defined in the AWCCS AWCCS Item Master Master Organi Organizati zation on,, which which is a logical logical Invent Inventory ory Organization and will not have any transactions. Then transactions. Then it will be assigned assigned to appropriat appropriate e organizatio organizations. ns. Above Inventory Inventory Organizations Organizations except AWCCS Item Master Master will have Sub Inventories Inventories across locations locations in UAE. Sub Inventory Organizations are the physical locations, which will be used to inventories, track and transact inventories.

INV ORG & SUB INV DETAILS:

AWCCS INV ORG & Sub Inv.x Inv.x ls

Locators:

Locators are the specific storage Racks and Bins in a Sub inventory (Stores). Based on the AWCCS business requirement, Locators can be defined in all or specific sub inventories. In Project sub inventories, ‘Project’ and ‘Task’ will be captured in the appropriate Locator Field segments.


Document Control

ii



Process Step Catalogs Item Creation & Maintenance ID

Process

INV-BP – 020.01.01

Item Code Generation – Manual Process

Process description 1.

Item code is single segment of type “Alphanumeric”.

2.

Item codes are defined by authorized person from Inventory department when required, in AWCCS Item Master Organization and assigned to appropriate Inventory organizations.

3.

Based on the Item Template used for Item creation, Item code will have appropriate Prefix to identify the Item Types. (Eg: A10000001 = Asset Item, ST10000002 = stock item etc)

Fitment Type

Fitment Description

Automation

Customizatio n

No Standard functionality in Oracle to generate Item codes automatically. Customization can be done to create sequential numbers as Item code in the Item field (segment1) while user applies the Item template and Save the record. Asset Owner department and Asset serial numbers will be captured in DFF field of Item master. (Asset Serial # will be updated based on GRN )

Manual


Process Step Catalogs Item Creation & Maintenance ID

Process

INV-BP – 020.01.01

Item Code Generation – Manual Process


Item code is single segment of type “Alphanumeric”.

2.

Item codes are defined by authorized person from Inventory department when required, in AWCCS Item Master Organization and assigned to appropriate Inventory organizations.

3.

Based on the Item Template used for Item creation, Item code will have appropriate Prefix to identify the Item Types. (Eg: A10000001 = Asset Item, ST10000002 = stock item etc)

Fitment Type

Fitment Description

Automation

Customizatio n

No Standard functionality in Oracle to generate Item codes automatically. Customization can be done to create sequential numbers as Item code in the Item field (segment1) while user applies the Item template and Save the record. Asset Owner department and Asset serial numbers will be captured in DFF field of Item master. (Asset Serial # will be updated based on GRN )

Manual


Document Control

ii


– Inventory, AWCCS ID

Process

INV-BP – 020.01.02

Item Code Generation – through ‘BYNX’ Interface.


Items created in ‘‘BYNX’’ Application for Vehicle related items will be i nterfaced to AWCCS Item master defined in Oracle Inventory through dynamic custom Interface.

2.

Chassis#, Engine number and Body number (if applicable) will be captured at the time of PO Receipt will be populated in the additional information field (DFF) of the respective items in Item Master.

3.

Additional details for Vehicle related items like Make, Model, Year, Specification, etc are captured in the additional information field (DFF) of the respective items in Item Master.

4.

Specific Oracle ‘Item Templates’ defined for Fleet & Fleet related Asset Items based on Asset categories will be applied at this time. a. Fleet Item Template ( PRV,PRA,PRAC) b. Fleet Fleet Expen Expense se Temp Templat late e (PRAE)

Each record sent by Bynx through the interface will have the associated template Identifier. 5.

Item Description will be a one string, which

Fitment Type

Fitment Description

Automation

Interface

Custom Interface to Import Item details created in ‘BYNX’ system.

Auto generation


Process

INV-BP – 020.01.02

Item Code Generation – through ‘BYNX’ Interface.


Items created in ‘‘BYNX’’ Application for Vehicle related items will be i nterfaced to AWCCS Item master defined in Oracle Inventory through dynamic custom Interface.

2.

Chassis#, Engine number and Body number (if applicable) will be captured at the time of PO Receipt will be populated in the additional information field (DFF) of the respective items in Item Master.

3.

Additional details for Vehicle related items like Make, Model, Year, Specification, etc are captured in the additional information field (DFF) of the respective items in Item Master.

4.

Specific Oracle ‘Item Templates’ defined for Fleet & Fleet related Asset Items based on Asset categories will be applied at this time. a. Fleet Item Template ( PRV,PRA,PRAC) b. Fleet Fleet Expen Expense se Temp Templat late e (PRAE)

Fitment Type

Fitment Description

Automation

Interface

Custom Interface to Import Item details created in ‘BYNX’ system.

Auto generation

Each record sent by Bynx through the interface will have the associated template Identifier. 5.

Item Description will be a one string, which is a combination of “Make, Model, Year” for Vehicle & accessories.


Document Control

ii



Process

INV-BP – 020.01.03

Item Code Generation – through Custom Program

Process description

Item code will be created for the new items and superseded items while a mending Blanket Purchase Agreements with Manufacturers/ Suppliers, the details will be provided by Manufacturer / Suppliers in the CD.

Fitment Type

Fitment Description

Automation

Custom Program

Supplier Part number validation and related AWCCS Item code generation while uploading new Supplier Price list – Custom Process.

Auto generation

Manufacturer Part number corresponding to the respective items and appropriate Item status will also updated in this Process. (Ref: BP 80 Purchasing – BPA Amendment process) INV-BP – 020.02

Item Category

Item categories are controlled at Master Level. These are defined for various levels of Analysis and Reporting.

1.

Inventory Item categories will be defined as 5 segments with Independent Value sets. 2.

Purchasing Item categories will be defined as 3 segments with Independent Value sets. 3.

Each Item will be assigned to appropriate Item categories and PO categories during Item creation. 4.

5.

For Asset Items, Asset categories and

Standard

DFF Fields will be enabled in Item category form to capture Account codes used for Accounting validation for Material transactions.

Manual


Process

INV-BP – 020.01.03

Item Code Generation – through Custom Program

Process description

Item code will be created for the new items and superseded items while a mending Blanket Purchase Agreements with Manufacturers/ Suppliers, the details will be provided by Manufacturer / Suppliers in the CD.

Fitment Type

Fitment Description

Automation

Custom Program

Supplier Part number validation and related AWCCS Item code generation while uploading new Supplier Price list – Custom Process.

Auto generation

Manufacturer Part number corresponding to the respective items and appropriate Item status will also updated in this Process. (Ref: BP 80 Purchasing – BPA Amendment process) INV-BP – 020.02

Item Category

Item categories are controlled at Master Level. These are defined for various levels of Analysis and Reporting.

1.

Standard

Inventory Item categories will be defined as 5 segments with Independent Value sets. 2.

DFF Fields will be enabled in Item category form to capture Account codes used for Accounting validation for Material transactions.

Manual

Purchasing Item categories will be defined as 3 segments with Independent Value sets. 3.

Each Item will be assigned to appropriate Item categories and PO categories during Item creation. 4.

For Asset Items, Asset categories and appropriate Asset clearing A/c will be captured through Item Templates.

5.


Document Control

ii



(Note: The following following are are the five levels of ‘Inventory Item Categories ‘configured in the Oracle ERP system . (Note: Based on the Final values’ provided by AWCCS for these 5 segments, Categories will be configured)

Inv. Category - GL Level PARTS

FAMILY TYRES

FAMILY BATTERIES

MAKE MAKE

CLASS VEHICLE BUS & HVY EQUIPMENT ANCILLARY GENERAL USE

SUB-CLASS MECHANICAL BODY ELECTRICAL A/C GENERAL USE

MAKE MAKE

CLASS VEHICLE BUS & HVY EQUIPMENT USED VEHICLE TIRES USED Bus HVY TIRES USED USED EQUI EQUIPM PMEN ENT T TIRE TIRES S GENERAL USE TUBES

SUBCLASS Standard Standard Standard: Off Road Standard: On/Off Road Premium Premium ium: Off Road Prem Premiu ium: m: On/O On/Off ff Roa Road d Block Block: Off Off Road Block: On/Off Road Sand Solid

MAKE MAKE

CLASS FLEET

SUBCLASS Right

S-SUBCLASS GENERAL

S-SUBCLASS 1200R24

S-SUBCLASS 40AH


(Note: The following following are are the five levels of ‘Inventory Item Categories ‘configured in the Oracle ERP system . (Note: Based on the Final values’ provided by AWCCS for these 5 segments, Categories will be configured)

Inv. Category - GL Level PARTS

MAKE MAKE

CLASS VEHICLE BUS & HVY EQUIPMENT ANCILLARY GENERAL USE

SUB-CLASS MECHANICAL BODY ELECTRICAL A/C GENERAL USE

MAKE MAKE

CLASS VEHICLE BUS & HVY EQUIPMENT USED VEHICLE TIRES USED Bus HVY TIRES USED USED EQUI EQUIPM PMEN ENT T TIRE TIRES S GENERAL USE TUBES

SUBCLASS Standard Standard Standard: Off Road Standard: On/Off Road Premium Premium ium: Off Road Prem Premiu ium: m: On/O On/Off ff Roa Road d Block Block: Off Off Road Block: On/Off Road Sand Solid

FAMILY BATTERIES

MAKE MAKE

CLASS FLEET GENERAL USE

SUBCLASS Right Left Special

FAMILY OIL

MAKE MAKE

CLASS FLEET

SUBCLASS ENGINE OIL

FAMILY TYRES


S-SUBCLASS GENERAL

S-SUBCLASS 1200R24

S-SUBCLASS 40AH 50AH 90AH 120AH S-SUBCLASS 10W15 Document Control

ii



HVAC GENERAL USE

GEAR OIL HYDRAULIC OIL TRANSMISION OIL REFRIGERANT OIL BRAKE FLUID GENERAL USE

FAMILY PAINT

MAKE MAKE

CLASS FLEET HVAC GENERAL USE

SUBCLASS PAINT HARDENER THINNER LACQUER PRIMER BODY FILLER BODY COATING POLISH GENERAL USE

FAMILY CONSUMABLE

MAKE MAKE


SUBCLASS CLEANING SANDING LUBRICANTS WHEELS ELECTRICAL COOLANTS REFRIGERANT

15W40 T4-SAE50 5W30

S-SUBCLASS General

S-SUBCLASS


HVAC GENERAL USE

GEAR OIL HYDRAULIC OIL TRANSMISION OIL REFRIGERANT OIL BRAKE FLUID GENERAL USE

FAMILY PAINT

MAKE MAKE


SUBCLASS PAINT HARDENER THINNER LACQUER PRIMER BODY FILLER BODY COATING POLISH GENERAL USE

FAMILY CONSUMABLE

MAKE MAKE


SUBCLASS CLEANING SANDING LUBRICANTS WHEELS ELECTRICAL COOLANTS REFRIGERANT GENERAL USE


15W40 T4-SAE50 5W30

S-SUBCLASS General

S-SUBCLASS

Document Control

ii



FAMILY AC PARTS

MAKE MAKE

FAMILY

MAKE

CLASS

MAKE

QHSE STATIONERY Food & Beverages

GENERAL

CLASS A/C PARTS A/C EQUIPMENTS TOOLS THERMOSTAT THERMOSTAT COPPER FITTING COPPER PIPE CONTACTOR CAPACITOR CIRCUIT BREAKER COMPRESSOR BELT REFRIGERANT GENERAL USE

PROMOTIONAL IT ACCESSORIES General Maintenance GENERAL FLEET

SUBCLASS 30GTN050 RG250 YWTB.17F28 YWTB.17F28 ZR12JKC-TFD ZR12JKC-TFD

SUBCLASS

S-SUBCLASS

S-SUBCLASS


FAMILY AC PARTS

MAKE MAKE

FAMILY

MAKE

CLASS

MAKE

QHSE STATIONERY Food & Beverages

GENERAL

CLASS A/C PARTS A/C EQUIPMENTS TOOLS THERMOSTAT THERMOSTAT COPPER FITTING COPPER PIPE CONTACTOR CAPACITOR CIRCUIT BREAKER COMPRESSOR BELT REFRIGERANT GENERAL USE

SUBCLASS 30GTN050 RG250 YWTB.17F28 YWTB.17F28 ZR12JKC-TFD ZR12JKC-TFD

S-SUBCLASS

SUBCLASS

S-SUBCLASS

SUBCLASS

S-SUBCLASS

PROMOTIONAL IT ACCESSORIES General Maintenance GENERAL FLEET

FAMILY EXP.GOODS

MAKE

CLASS Uniform & Safety Gear Short Life Tools And Equipment Stationery & Office


Document Control

ii



Supplies IT Stationery Kitchen Supplies GENERAL EXP GOODS

FAMILY EXP.SERVICES

MAKE

CLASS Vehicle Recovery Repair & Maintenance

SUBCLASS

S-SUBCLASS

Outsourced Man Power Services Professional Charges Advertising and Sponsorship Hospitality Software support

Details of Purchasing Item categories are mentioned in Purchasing BP80.

Following are the “Asset categories” captured for Asset Items defined in Oracle Inventory, attached through “Item Template”. Template”. Land, Building, Rental premises and other Assets which are not defined in Item master wi ll be handled in Oracle Fixed Assets.


Supplies IT Stationery Kitchen Supplies GENERAL EXP GOODS

FAMILY EXP.SERVICES

MAKE

CLASS Vehicle Recovery Repair & Maintenance

SUBCLASS

S-SUBCLASS

Outsourced Man Power Services Professional Charges Advertising and Sponsorship Hospitality Software support

Details of Purchasing Item categories are mentioned in Purchasing BP80.

Following are the “Asset categories” captured for Asset Items defined in Oracle Inventory, attached through “Item Template”. Template”. Land, Building, Rental premises and other Assets which are not defined in Item master wi ll be handled in Oracle Fixed Assets.


Document Control

ii



Major Category IT WORKSHOP HVAC E&T PROJECT GPS G.S

Minor Category HARDWARE SOFTWARE STATIONARY MOBILE STATIONARY MOBILE E&T PROJECT GPS FURNITURE FIXTURE OFFICE EQUIPMENT

RENTAL/PAYLESS

FLEET

LPV LCV MCV HVC BUS IE CE


Major Category IT WORKSHOP HVAC E&T PROJECT GPS G.S

Minor Category HARDWARE SOFTWARE STATIONARY MOBILE STATIONARY MOBILE E&T PROJECT GPS FURNITURE FIXTURE OFFICE EQUIPMENT

RENTAL/PAYLESS

FLEET

LPV LCV MCV HVC BUS IE CE


Document Control

ii



INV-BP – 020.03

Item Template Template

Item templates will be created to apply the appropriate Item attributes during Item creation for each Item types like :     

Standard

Item definition

Manual

Stock Items, Expense goods, Expense services, Fleet Assets and Non Fleet Assets etc.,

Based on number of Asset clearing accounts, Interface requirements, and AWCCS business requirements, Item templates can be defined. Each record sent by Bynx through the interface will have the associated template Identifier ID. This will will minimize minimize the the manual manual effort effort for Item Item creation and selecting required attributes. INV-BP – 020.04

INV-BP – 020.04.01

Item Relationship – Defining Superseded Items

Superseded items will be defined and referenced to respective Original Items defined. If it is through Automatic process, BPA Price upload program will be used.

Item Relationship Substitute (Alternate)

Substitute: Based on the knowledge & experience on Items, Item relationship – “Substitute” (alternate) can be manually defined between AWCCS Item

Standard Item relationshipSupersede.

standard

Item re relationshipSubstitute

Manual/ Automatic

Manual


INV-BP – 020.03

Item Template Template

Item templates will be created to apply the appropriate Item attributes during Item creation for each Item types like :     

Standard

Item definition

Manual

Stock Items, Expense goods, Expense services, Fleet Assets and Non Fleet Assets etc.,

Based on number of Asset clearing accounts, Interface requirements, and AWCCS business requirements, Item templates can be defined. Each record sent by Bynx through the interface will have the associated template Identifier ID. This will will minimize minimize the the manual manual effort effort for Item Item creation and selecting required attributes. INV-BP – 020.04

INV-BP – 020.04.01

Item Relationship – Defining Superseded Items

Item Relationship Substitute (Alternate)

Superseded items will be defined and referenced to respective Original Items defined.

Standard Item relationshipSupersede.

Manual/ Automatic

If it is through Automatic process, BPA Price upload program will be used.

Substitute: Based on the knowledge & experience on Items, Item relationship – “Substitute” (alternate) can be manually defined between AWCCS Item codes in Oracle Inventory.

standard


Item re relationshipSubstitute

Document Control

Manual

ii



INV-BP – 020.04.02

INVINV-BP BP – 020 020.0 .05 5

Item Relationship – Manufactur er Part #

Item Item Quer Query y

Manufacturer Part # will be updated for the respective items in the Item Master through BPA Price upload Program Users will be able to query the inventory stock by Manufacturer’s Part # (Supplier Item code). To facilitate facilitate this this requireme requirement, nt, ‘Manufac ‘Manufacturer turer part numbers’ will be defined as ‘Supplier Item code’ in “Item Cross Reference” window through custom program. The The On On han hand d Qua Quant ntit ity y det detai ails ls of the the Ite Item m can can be viewed by various filters like Item code, Description, Item cross reference (Supplier Item code)etc.,

standard

Item Re Relationship – Manufacturer part number (Item Cross reference)

Manual & Automatic

standard

Querying Items

Manual


INV-BP – 020.04.02

Item Relationship – Manufactur er Part #

INVINV-BP BP – 020 020.0 .05 5

Item Item Quer Query y

Manufacturer Part # will be updated for the respective items in the Item Master through BPA Price upload Program Users will be able to query the inventory stock by Manufacturer’s Part # (Supplier Item code). To facilitate facilitate this this requireme requirement, nt, ‘Manufac ‘Manufacturer turer part numbers’ will be defined as ‘Supplier Item code’ in “Item Cross Reference” window through custom program. The The On On han hand d Qua Quant ntit ity y det detai ails ls of the the Ite Item m can can be viewed by various filters like Item code, Description, Item cross reference (Supplier Item code)etc.,

standard

Item Re Relationship – Manufacturer part number (Item Cross reference)

Manual & Automatic

standard

Querying Items

Manual


Document Control

ii



Process Step Catalogs Material request and Issue “Move Order Issue transaction type” will be used to approve a transaction and to provide a • Move orders with a “Move document to track the issue of the material. This is used for issuing Materials against Cost centre / Account.

• Move orders with a “Move “Move order Transfer transaction type” (Sub inventory Transfer) will be used to approve a transfer and to provide a document to track the transfer of the material. This is used for moving Materials from one Sub inventory to another Sub inventory within an organization.

• When the requisition is created by the material requestors, the workflow approval process sends a Notification to the approver that a move order requisition line is awaiting approval.

• In AWCCS, Multi level amount based work flow for approval process will be configured. • Once the Move order is approved, notices are sent to a notification list that is attached to the source and destination sub inventories to let the sub inventory planners (Stores users) know that material will be moved to or from their areas. Stores Users Users will will ‘Issue/Trans ‘Issue/Transfer fer the the Material’ Material’ using “Transact Move order” Form for the Move orders which • The Stores are in ‘Approved’ ‘Approved’ status.

• If sufficient Quantity is not available in the stores, Partial issue will be processed. Remaining quantity will be issued after receipt of the related Purchase order. A Custom Program can be triggered by submitting a request by store keepers. The program will create Purchase requisitions (in ‘Approved status’) automatically for the Pending issue line quantity of the Move order for WIP requirement for stock items.

• Line Item Cost (i.e. Unit Cost), Extended Line Value (i.e. total line Cost), and Move Order Total value (i.e. total of the transaction) will be captured in Move Order Notification.

•

“Manufacturer Part number” for line levels and MO approval statuses will be captured in Move Order Form.

‘ Transact Move order’ Form. (It is expected to • Serial Numbers / Lot numbers for Tires will be captured in ‘Transact configure Serial controls for heavy Tires and Lot controls for Light Tires). If item is stocked in Locators, Locator details has to be entered for in addition to serial/Lot number for each Line transactions.

• Custom Accounting logic will val idate based on user LOB/DEPT & Location in addition to Item template account and defaults Account segment for Line charge account.

• Custom Accounting logic will be used in Oracle Move order form. User will select from List of values in Header level, appropriate LOB, Department, Location if differs from Default values. This will be defaulted to all lines in


Process Step Catalogs Material request and Issue “Move Order Issue transaction type” will be used to approve a transaction and to provide a • Move orders with a “Move document to track the issue of the material. This is used for issuing Materials against Cost centre / Account.

• Move orders with a “Move “Move order Transfer transaction type” (Sub inventory Transfer) will be used to approve a transfer and to provide a document to track the transfer of the material. This is used for moving Materials from one Sub inventory to another Sub inventory within an organization.

• When the requisition is created by the material requestors, the workflow approval process sends a Notification to the approver that a move order requisition line is awaiting approval.

• In AWCCS, Multi level amount based work flow for approval process will be configured. • Once the Move order is approved, notices are sent to a notification list that is attached to the source and destination sub inventories to let the sub inventory planners (Stores users) know that material will be moved to or from their areas. Stores Users Users will will ‘Issue/Trans ‘Issue/Transfer fer the the Material’ Material’ using “Transact Move order” Form for the Move orders which • The Stores are in ‘Approved’ ‘Approved’ status.

• If sufficient Quantity is not available in the stores, Partial issue will be processed. Remaining quantity will be issued after receipt of the related Purchase order. A Custom Program can be triggered by submitting a request by store keepers. The program will create Purchase requisitions (in ‘Approved status’) automatically for the Pending issue line quantity of the Move order for WIP requirement for stock items.

• Line Item Cost (i.e. Unit Cost), Extended Line Value (i.e. total line Cost), and Move Order Total value (i.e. total of the transaction) will be captured in Move Order Notification.

•

“Manufacturer Part number” for line levels and MO approval statuses will be captured in Move Order Form.

‘ Transact Move order’ Form. (It is expected to • Serial Numbers / Lot numbers for Tires will be captured in ‘Transact configure Serial controls for heavy Tires and Lot controls for Light Tires). If item is stocked in Locators, Locator details has to be entered for in addition to serial/Lot number for each Line transactions.

• Custom Accounting logic will val idate based on user LOB/DEPT & Location in addition to Item template account and defaults Account segment for Line charge account.

• Custom Accounting logic will be used in Oracle Move order form. User will select from List of values in Header level, appropriate LOB, Department, Location if differs from Default values. This will be defaulted to all lines in addition to custom vali dation query to populate appropriate account segment for each li ne item. Based on the specific Business requirement for tracking and accountability of Material requests and issues, the following types of Move order Transaction Types will be defined in Oracle Inventory


Document Control

ii



Sl #

1

Move Order Transaction s - Business Scenarios

Move Order Request from Workshop for Spare parts, Tires

Move Order Transaction Name

MR : Workshop WIP Tire

MR : Workshop WIP Parts

2

Move Order Request from Workshop for Paint, Consumable s

Move Order

Move Order Issue

Move Order Issue

Demand Source

Action

Worksho p– Oracle System

Move Order Transfer Transfer

Worksho pOracle System

Worksho pOracle

Worksho p- Oracle

Transaction Types

Move Order Transfer Transfer Material Request will be created in Oracle Inventory Move Order Request Form Material Request will be created in Oracle Inventory Move Order Request Form Material Request will be created in

Move Order Issue

Move Order Issue

Status at Creation

Additional Accounting Information Treatment Job Order Order # and License# to be captured in the MO Line DFF. While “Material transfer Incomplete “appropriate” Serial# for Heavy Tires Against WIP and Lot Tires accoun accountt numbers for when issued Light Tires will from WIP sub be captured. inventory Job Order # Against WIP and License# Parts account to be captured when issued in the MO line from WIP parts Incomplete Incomplete DFF account

Incomplete

Line Item Cost, Extended value, MR Total Value

Incomplete

Line Item Cost, Extended value, MR Total Value Line Item Cost, Extended

Against WIP Suspense Paint account Against WIP Suspense Consumable account Against HVAC Project account when issued


Sl #

1



MR : Workshop WIP Tire

Move Order Request from Workshop for Spare parts, Tires

MR : Workshop WIP Parts

2

3

Move Order Request from Workshop for Paint, Consumable s

Move Order Issue

Move Order Issue

Move Order Request for HVAC Project Move Order Issuance Transfer Transfer

Demand Source

Action

Worksho p– Oracle System

Transaction Types


Worksho pOracle System


Worksho p- Oracle

Material Request will be created in Oracle Inventory Move Order Request Form Material Request will be created in Oracle Inventory Move Order Request Form

HVAC Projects

Material Request will be created in Oracle Inventory Move Order Request Form

Worksho pOracle

Move Order Issue

Move Order Issue


Status at Creation

Additional Accounting Information Treatment Job Order Order # and License# to be captured in the MO Line DFF. While “Material transfer Incomplete “appropriate” Serial# for Heavy Tires Against WIP and Lot Tires accoun accountt numbers for when issued Light Tires will from WIP sub be captured. inventory Job Order # Against WIP and License# Parts account to be captured when issued in the MO line from WIP parts Incomplete Incomplete DFF account

Incomplete


Incomplete


Incomplete Incomplete

Line Item Cost, Extended value, MR Total Value, Project & Task


Against WIP Suspense Paint account Against WIP Suspense Consumable account Against HVAC Project account when issued from HVAC project Sub inventory

Document Control

ii



Sl #


4

Move Order Request for Heavy Project Issuance

5

6

7



Move Order Requests – Move Order GPS Transfer Transfer Move Order Requests against HVAC Maintenance / Service Move Order Contracts Transfer Transfer Move Order Requests General Stocked Items (Eg: Consumable Move Order s) Issue

Demand Source

Action

HVAC Heavy Projects


GPS Lines of Business


HVACServices (AMS+)


All Business Lines


Transaction Types




Move Order Issue

Status at Creation

Additional Information





Accounting Treatment Against Heavy Projects -Project account when issued from HP project sub inventory Against GPS -Service Contract account when issued from “GPS “GPS Sub inventory” inventory”


Line Item Cost, Extended value, MR Total Value, Service Request#, Task#

Against Service -Project account when issued from project stores (AMS+)


Against Department/ cost centre. (Follows custom Accounting logic)

Incomplete


Sl #


4

Move Order Request for Heavy Project Issuance

5

6

7



Move Order Requests – Move Order GPS Transfer Transfer Move Order Requests against HVAC Maintenance / Service Move Order Contracts Transfer Transfer Move Order Requests General Stocked Items (Eg: Consumable Move Order s) Issue

Demand Source

Transaction Types

Action

HVAC Heavy Projects


GPS Lines of Business


HVACServices (AMS+)


All Business Lines





Move Order Issue

Status at Creation

Additional Information





Accounting Treatment Against Heavy Projects -Project account when issued from HP project sub inventory Against GPS -Service Contract account when issued from “GPS “GPS Sub inventory” inventory”


Line Item Cost, Extended value, MR Total Value, Service Request#, Task#

Against Service -Project account when issued from project stores (AMS+)


Against Department/ cost centre. (Follows custom Accounting logic)

Incomplete


Document Control

ii



Process Flow Material Request & Issue (Tires & Spare Parts to Workshop) Workshop Tyres Tyres /Spare Parts n o i t a c o L e v i t c e p s e R p o h s k r o W

e r o t S n o i t a c o L r e h t O

No Requested created in Oracle for the required items (MO Transfer) From WIP store

MO Transfer

Availabil ilability ity

Full Stock Available

Approve Approved Yes Yes

Creation of PR for the pending MO qty in approved status

Workshop -Main Store is notified

No

No

Check the availability in other Org sub inventory

Material Available ilable

Partial Stock Available

Stock Replenished

No GRN receipt

Yes Full Stock

Inter org Transfer

PR Created for remaining Qty Yes Partial Stock

t n e m e r u c o r P

Partial Fulfilment

PO/Rel created & approved


Process Flow Material Request & Issue (Tires & Spare Parts to Workshop) Workshop Tyres Tyres /Spare Parts n o i t a c o L e v i t c e p s e R p o h s k r o W

No Requested created in Oracle for the required items (MO Transfer) From WIP store

Full Stock Available Yes

Yes Creation of PR for the pending MO qty in approved status

e r o t S n o i t a c o L r e h t O

MO Transfer

Availabil ilability ity Approve Approved

Workshop -Main Store is notified

No

Check the availability in other Org sub inventory

Material Available ilable

No

Partial Fulfilment

Partial Stock Available

Stock Replenished

No GRN receipt

Yes Full Stock

Inter org Transfer

PR Created for remaining Qty Yes Partial Stock


PO/Rel created & approved


Document Control

ii



Process

NV-BP – 030.01

Material Request from Worksh op for Tires & Parts.

Process description

1) Material Material Request Request will be created created in “Oracle “Oracle” ” by Workshop users for Tires and parts in the WIP sub inventory from the Main sub inv. 2) Job order order #, License License #will #will be captured captured in Line level DFF segments. 3) In case, case, if sufficient sufficient stock is not available, available, MR will be converted in to PR automatically through the Custom Program. Job order number, Oracle M.O # and License # will be carried to PO and GRN. 4) Lot number number for Light Light Tires Tires and Serial Serial number number for Heavy Tires will be captured during material transfer ( in ‘Transact Move order form’) 5) After PO receipt receipt of the Tires/ parts it it will be be issued through Transact Move Order form and will be charged against appropriate accounts based on Custom Accounting logic. 6) Custo Custom m Rep Repor ortt “Pending “Pending Material Report” will be developed to track the status of MR, PR, PO, and GRN related to Job order# captured in Move order. 7) After the the job order order is closed closed complete completely ly items items from WIP sub inventory is issued out automatically through misc issue

Fitment Type

MO Transfer

Fitment Description

Automation

Material issue.

Manual


Process

Process description

NV-BP – 030.01

Fitment Type

1) Material Material Request Request will be created created in “Oracle “Oracle” ” by Workshop users for Tires and parts in the WIP sub inventory from the Main sub inv. 2) Job order order #, License License #will #will be captured captured in Line level DFF segments. 3) In case, case, if sufficient sufficient stock is not available, available, MR will be converted in to PR automatically through the Custom Program. Job order number, Oracle M.O # and License # will be carried to PO and GRN. 4) Lot number number for Light Light Tires Tires and Serial Serial number number for Heavy Tires will be captured during material transfer ( in ‘Transact Move order form’) 5) After PO receipt receipt of the Tires/ parts it it will be be issued through Transact Move Order form and will be charged against appropriate accounts based on Custom Accounting logic. 6) Custo Custom m Rep Repor ortt “Pending “Pending Material Report” will be developed to track the status of MR, PR, PO, and GRN related to Job order# captured in Move order. 7) After the the job order order is closed closed complete completely ly items items from WIP sub inventory is issued out automatically through misc issue

Material Request from Worksh op for Tires & Parts.

Fitment Description

Automation

Material issue.

Manual

MO Transfer


Document Control

ii



Process Flow Material Request & Issue (Consumables /Paints to Workshop) Material Issuance Issuance – Workshop- Consumables/Paints Consumables/Paints

p o h s k r o W

Requirement for Consumables/ Paints Communicated to Main Store by Mail, Telephone

MR Cr eated

n o i t a c o L e v i p t c o h e p s s k r e o R W – e r o t S n i a M

n o i t a c r e o o L t r S e h t O t

Appr oved

No

End Full stock Available

Approved Approved MR Received at Store for fulfillment

Check Material availability ty in the store

Move Order Issue

Yes Partial Fulfilment

Availabi lability lity

Stock Replenished No / Partial Available No Check availability of stocks in other location sub inventory

GRN Receipt

Create Purchase Requisition from MR & PR is Approved

No

Material Availabl lable PR created for Remaining qty

Yes-Full Stock

Yes-Partail

Sub Inventory Transfer / Inter Org Transfer


Process Flow Material Request & Issue (Consumables /Paints to Workshop) Material Issuance Issuance – Workshop- Consumables/Paints Consumables/Paints

p o h s k r o W

Requirement for Consumables/ Paints Communicated to Main Store by Mail, Telephone

MR Cr eated

n o i t a c o L e v i p t c o h e p s s k r e o R W – e r o t S n i a M

Appr oved

No

End Full stock Available

Approved Approved MR Received at Store for fulfillment

n o i t a c r e o o L t r S e h t O

Check Material availability ty in the store

Move Order Issue

Yes Partial Fulfilment

Availabi lability lity

Stock Replenished No / Partial Available No Check availability of stocks in other location sub inventory

GRN Receipt

Create Purchase Requisition from MR & PR is Approved

No

Material Availabl lable

Yes-Full Stock

PR created for Remaining qty

Sub Inventory Transfer / Inter Org Transfer

Yes-Partail


PO Created & Approved Approved


Document Control

ii



Process

INV-BP – 030.02

Process description

1) Move order order Request Request will be be created in “Oracle ERP” by Workshop users for Paints & Consumables.

Material Request & Issue for Paint and Consumabl es Workshop

2) Destination Destination account accounts s will be populated based on the Custom accounting logic. logic.

If line Item category is paints, WIPPaint-Clearing account will be populated automatically.

If line Item category is Consumables, WIP-Consumables Clearing account will be populated automatically.

Fitment Type

Fitment Description

Automation

Custom program for MR to PR

Paints& Consumables Consumables MR & issue to Workshop.

Manual

Amount based Multi level Approval for MR


Process

INV-BP – 030.02

Process description

1) Move order order Request Request will be be created in “Oracle ERP” by Workshop users for Paints & Consumables.

Material Request & Issue for Paint and Consumabl es Workshop

2) Destination Destination account accounts s will be populated based on the Custom accounting logic. logic.

Fitment Type

Fitment Description

Automation


Paints& Consumables Consumables MR & issue to Workshop.

Manual


If line Item category is paints, WIPPaint-Clearing account will be populated automatically.

If line Item category is Consumables, WIP-Consumables Clearing account will be populated automatically.


Document Control

ii



Process Flow Material Request & Issue (Materials to Project)


Process Flow Material Request & Issue (Materials to Project)


Document Control

ii



INV-BP – 030.03

Process

Material Request & Issue for Materials against Project Task#

Process description

1) Move order order Request Request for materials from HVAC and HP will be raised for Project Task # / Project work order. 2) Material Material will be transferred transferred to a Intermediate Project sub inventory (Locator controlled) 3) From there there it will be issued issued to Projects. 4) Excess Material can be stocked in the the Projects sub inventory

Fitment Type

Custom program for MR to PR Amount based Multi level Approval for MR

Fitment Description

material request & issue for Projects

Automation

Manual


INV-BP – 030.03

Process

Material Request & Issue for Materials against Project Task#

Process description

1) Move order order Request Request for materials from HVAC and HP will be raised for Project Task # / Project work order. 2) Material Material will be transferred transferred to a Intermediate Project sub inventory (Locator controlled) 3) From there there it will be issued issued to Projects. 4) Excess Material can be stocked in the the Projects sub inventory

Fitment Type


Fitment Description

Automation

material request & issue for Projects

Manual



Document Control

ii



Process Flow Material Request & Issue (Materials to Service contract)


Process Flow Material Request & Issue (Materials to Service contract)


Document Control

ii



Process

INV-BP – 030.04

Materials request for Maintena nce Contract against service Request # created through Spares Manage ment Module

Process description

Fitment Type

Fitment Description

Automation


Material issued to Service Request

Manual

MR: Maintenance Contract 1) Move Move order order Reque Request st for Mate Material rial will be created from Oracle spares management module against Service request # from HVAC, HP and GPS 2) Requested Requested material material will will be transferred to a logical Spares Management sub inventory 3) From there it will be issued to Service Request.

Amount based Multi level Approval for MR Form Personalization to restrict users using global account segment


Process

INV-BP – 030.04

Materials request for Maintena nce Contract against service Request # created through Spares Manage ment Module

Process description

Fitment Type

Fitment Description

Automation


Material issued to Service Request

Manual

MR: Maintenance Contract 1) Move Move order order Reque Request st for Mate Material rial will be created from Oracle spares management module against Service request # from HVAC, HP and GPS 2) Requested Requested material material will will be transferred to a logical Spares Management sub inventory 3) From there it will be issued to Service Request.

Amount based Multi level Approval for MR Form Personalization to restrict users using global account segment


Document Control

ii



Process Flow Material Request & Issue against Account code/ cost centre


Process Flow Material Request & Issue against Account code/ cost centre


Document Control

ii



Process

INV-BP – 030.05

Process description

1. Users of various various Department Departments s will send Material Request for general items against Department cost centre, through Move Order form with approval from Department Heads. 2. Material Material will be issued against against this Move Order #through Transact Move order Form. Material Request & Issue for General Items

3. In case full or or partial quantity quantity is not not available in stock, Purchase Requisition will be created automatically by custom program by storekeeper and send PR (in Approved status) to Purchase department.

Fitment Type


Fitment Description

Automation

General Items material request & issue

Manual

Stock item issued to proje roject ct and and conv conver erte ted d into into Assets.

Manual


Report Customization

4. Remaining Remaining Quantity Quantity will be issued issued after PO Receipt. 5. Based on the the Custom Accoun Accounting ting logic Destination accounts will be populated in Move order request Lines. INV-BP – 030.06

Move Order Requests from HVAC for Assets (convert

MR: HVAC Asset 1) Move order order Request Request for Assets Assets from HVAC will be raised for Project Task # / Project Project work order. order. 2) Assets will be transferred to a logical Project sub inventory (Locator controlled) 3) From there it will be issued to Projects against HVAC-Asset HVAC-Asset Clearing

Standard


Process

INV-BP – 030.05

Process description

1. Users of various various Department Departments s will send Material Request for general items against Department cost centre, through Move Order form with approval from Department Heads. 2. Material Material will be issued against against this Move Order #through Transact Move order Form. Material Request & Issue for General Items

3. In case full or or partial quantity quantity is not not available in stock, Purchase Requisition will be created automatically by custom program by storekeeper and send PR (in Approved status) to Purchase department.

Fitment Type


Fitment Description

Automation

General Items material request & issue

Manual

Stock item issued to proje roject ct and and conv conver erte ted d into into Assets.

Manual


Report Customization

4. Remaining Remaining Quantity Quantity will be issued issued after PO Receipt. 5. Based on the the Custom Accoun Accounting ting logic Destination accounts will be populated in Move order request Lines. INV-BP – 030.06

Move Order Requests from HVAC for Assets (convert Stock to Asset)

MR: HVAC Asset 1) Move order order Request Request for Assets Assets from HVAC will be raised for Project Task # / Project Project work order. order. 2) Assets will be transferred to a logical Project sub inventory (Locator controlled) 3) From there it will be issued to Projects against HVAC-Asset HVAC-Asset Clearing Account through Move order Account issue Transaction.

Standard


Document Control

ii



Process

NV-BP – 030.07

Miscellaneous Transactions 1) This functionality functionality is basically basically used for entering Opening Balances and any Stock Adjustment to Miscellan Increase/Decrease the Inventory Qty eous (If required). Transactio 2) Appropriate Account, Department n and Reason should be selected to Track the the Charge. Charge. 3) This is performe performed d by AUTHORIZED Persons only.

INV-BP – 030.08

Process description

Miscellaneous Transactions form will be used by ‘Inventory manager’ to process the Receipt transactions of used Tires with 1AED cost. Used Tyres transacti on

Used Tires which are received into stores through above process will be issued from ‘Used Tires stores’ against Material Request from Workshop. (Note:, Dedicated sub inventories for this purpose will be defined in each Locations in Workshop Inventory organization for the Used Tires)

Fitment Type

Fitment Description

Automation

standard

Stock adjustment

Manual

standard

No value transaction with tracking.

Manual


Process

NV-BP – 030.07

Miscellaneous Transactions 1) This functionality functionality is basically basically used for entering Opening Balances and any Stock Adjustment to Miscellan Increase/Decrease the Inventory Qty eous (If required). Transactio 2) Appropriate Account, Department n and Reason should be selected to Track the the Charge. Charge. 3) This is performe performed d by AUTHORIZED Persons only.

INV-BP – 030.08

Process description

Miscellaneous Transactions form will be used by ‘Inventory manager’ to process the Receipt transactions of used Tires with 1AED cost. Used Tyres transacti on

Fitment Type

Fitment Description

Automation

standard

Stock adjustment

Manual

standard

No value transaction with tracking.

Manual

Used Tires which are received into stores through above process will be issued from ‘Used Tires stores’ against Material Request from Workshop. (Note:, Dedicated sub inventories for this purpose will be defined in each Locations in Workshop Inventory organization for the Used Tires)


Document Control

ii



Process Flow Workshop Returns Workshop Returns

P I W p o h s k r o W

y r o t n e v n I b u S n r u t e R p o h s k r o W n i a M e p r o o h t s S k r o W

Return Material from WIP

Sub Inventory Transfer

Return items transferred to Return sub inv through sub inv transfer


Material Transferred to main store sub inv


Process Flow Workshop Returns Workshop Returns

P I W p o h s k r o W

y r o t n e v n I b u S n r u t e R p o h s k r o W n i a M e p r o o h t s S k r o W

Return Material from WIP


Return items transferred to Return sub inv through sub inv transfer


Material Transferred to main store sub inv


Document Control

ii



ID

Process

Process description

INV-BP – 040.01

Worksho p Return

Workshop Return : 1. Workshop return Material will be returned directly from the WIP sub inventory to Return Sub Inventory through sub inventory transfer. 2.

Later on Based on the Business requirement/ Decision, Material can be moved from ‘Return sub inventory’ to main sub inventory.

Fitment Type

Standard

Fitment Description

Sub Inv Transfer Transfer

Automation

Manual


ID

Process

Process description

INV-BP – 040.01

Worksho p Return

Workshop Return : 1. Workshop return Material will be returned directly from the WIP sub inventory to Return Sub Inventory through sub inventory transfer. 2.

Fitment Type

Standard

Fitment Description

Sub Inv Transfer Transfer

Automation

Manual

Later on Based on the Business requirement/ Decision, Material can be moved from ‘Return sub inventory’ to main sub inventory.


Document Control

ii



Process Flow Project Returns

ID

Process

Process description

Fitment Type

INV-BP – 040.02

Projects Return

Project Return: 1. Returns/ excess material from Projects will be transferred from ‘Projects’ Sub inventory’ to “HVAC Main-stores- Returns” sub inventory by Sub inventory transfer.

Standard

Fitment Description

Sub inventory Transfer Transfer

Automation

Manual


Process Flow Project Returns

ID

Process

Process description

Fitment Type

INV-BP – 040.02

Projects Return

Project Return: 1. Returns/ excess material from Projects will be transferred from ‘Projects’ Sub inventory’ to “HVAC Main-stores- Returns” sub inventory by Sub inventory transfer.

Standard


Fitment Description

Sub inventory Transfer Transfer

Automation

Manual

Document Control

ii



Process Flow Stock Transfers (Sub inventory transfers)


Process Flow Stock Transfers (Sub inventory transfers)


Document Control

ii



Process Flow Stock Transfers Stock Transfers (Inter org transfers) Inter Organization Transfer

y r o t n n e o i v t n a I z n i o n i a t g a r n i O t s e D

n o i t a z i n a g r O y r o t n e v n I e c r u o S

ID

Start

End

Receipt of Material

Stock Transfer Report

Inter Org Transfer Request through Mail / Phone

Create Inter Org Transfer in the system

Material Dispatch

Process

Process description

Fitment Type

Fitment Description

Automat ion

Stock Transfer between

It can be achieved by the following two ways

Standard

Stock transfer

Manual


Process Flow Stock Transfers Stock Transfers (Inter org transfers) Inter Organization Transfer

y r o t n n e o i v t n a I z n i o n i a t g a r n i O t s e D

n o i t a z i n a g r O y r o t n e v n I e c r u o S

Start

End

Receipt of Material

Stock Transfer Report

Inter Org Transfer Request through Mail / Phone

ID

Create Inter Org Transfer in the system

Material Dispatch

Process

Process description

Fitment Type

Fitment Description

Automat ion

Stock Transfer between Locations

It can be achieved by the following two ways 1. Move Order Transfer Transfer (with (with in Inventory Organization)

Standard

Stock transfer

Manual

2.

Inter Org transfer (Between sub inventories of an organization)


Document Control

ii



Process

INV-BP – 050.01

Move Transfer

Process description

order

1. Move Move order order Trans Transfer fer betw between een sub inventories will be used to transfer stock between various locations of an Inventory Organization. Stock will be transferred to the “Logical sub inventory” of the Destination Location. From there it will be transferred to actual sub inventory through ‘Sub inventory Transfer’. Transfer’. 2.

This is to to track the delivery delivery after in transit time. (Actual physical receipt of items) 3.

Inventory Packing slip report/ Discoverer Report will be used for physical stock movement as reference. 4.

Fitment Type

Fitment Description

Automat ion

Standard process

Inventory Department

Manual


Process

INV-BP – 050.01

Move Transfer

Process description

order

1. Move Move order order Trans Transfer fer betw between een sub inventories will be used to transfer stock between various locations of an Inventory Organization.

Fitment Type

Fitment Description

Automat ion

Standard process

Inventory Department

Manual

Stock will be transferred to the “Logical sub inventory” of the Destination Location. From there it will be transferred to actual sub inventory through ‘Sub inventory Transfer’. Transfer’. 2.

This is to to track the delivery delivery after in transit time. (Actual physical receipt of items) 3.

Inventory Packing slip report/ Discoverer Report will be used for physical stock movement as reference. 4.


Document Control

ii



Process

INV-BP – 05.02

Inter Organization Transfer

Process description

Fitment Type

Fitment Description

Automat ion

Manual Inter Organization Transfer between sub inventories of two Inventory Organizations will be used to transfer stock between Inventory Organizations. 1.

2. On rece receipt ipt of Stoc Stock k trans transfer fer request through Mail/ phone, Source organization initiates the stock transfer Through ‘Inter Org Transfer’ form. Inventory packing slip Report / Discoverer report copies will be sent as a reference along with the stock during Transfer. 3. On recei receipt pt of of the stock stock along along with with the ‘Reports, Receiving organization enters the Receipt details in the system.

Standard process

Inter or organization transfer


Process

INV-BP – 05.02

Inter Organization Transfer

Process description

Fitment Type

Fitment Description

Automat ion

Manual Inter Organization Transfer between sub inventories of two Inventory Organizations will be used to transfer stock between Inventory Organizations. 1.

Standard process

Inter or organization transfer

2. On rece receipt ipt of Stoc Stock k trans transfer fer request through Mail/ phone, Source organization initiates the stock transfer Through ‘Inter Org Transfer’ form. Inventory packing slip Report / Discoverer report copies will be sent as a reference along with the stock during Transfer. 3. On recei receipt pt of of the stock stock along along with with the ‘Reports, Receiving organization enters the Receipt details in the system.


Document Control

ii



Process Flow - PO Receipts


Process Flow - PO Receipts



For Stock Items and Expense Goods & services it will be “Direct Delivery” Routing and for Fleet assets it will be “Standard Receipt” Routing.


Document Control

ii


– Inventory, AWCCS 

Direct Delivery Routing is a single step process, where materials are delivered in one step. On receipt of Items Inventory material stock value is increased.



Standard Receipt Routing is a two step process, where materials are received in first step and delivered in delivered in step Receipt transaction and Delivery transactions in locations.



The average cost is recalculated based on the transaction value of the purchase order line value and the transaction quantity.



The actual delivery date (special field other than the PO Receipt (GRN) date) will be manually entered by Receiving user in line level DFF for each PO Receipt transaction which will be used for the aging report in Oracle Accounts Payable.



The Invoice will be directly sent to the finance for payments. The receipt quantity captured in the receiving transactions are automatically updated in the Purchase order, purchase requisition, Inventory material stock register (material workbench) and also Invoice workbench of Account payables modules (Finance).



Payment will be released by Accounts Paya bles after the Invoice Match (PO Qty, receipt Qty and Invoice Quantity) - 3 way match.



After receiving, if any defect is found in the material then the material can be returned returned to the vendor and debit memo is created against the supplier for the defective Quantity.



If the material delivery is delayed from supplier end, Penalty charges are charged on the supplier as per the instruction received through Mail by Purchasing Department. This is a manual process i n oracle by creating Manual Debit memo against the supplier to the agreed amount.

– Inventory, AWCCS 

Direct Delivery Routing is a single step process, where materials are delivered in one step. On receipt of Items Inventory material stock value is increased.



Standard Receipt Routing is a two step process, where materials are received in first step and delivered in delivered in step Receipt transaction and Delivery transactions in locations.



The average cost is recalculated based on the transaction value of the purchase order line value and the transaction quantity.



The actual delivery date (special field other than the PO Receipt (GRN) date) will be manually entered by Receiving user in line level DFF for each PO Receipt transaction which will be used for the aging report in Oracle Accounts Payable.



The Invoice will be directly sent to the finance for payments. The receipt quantity captured in the receiving transactions are automatically updated in the Purchase order, purchase requisition, Inventory material stock register (material workbench) and also Invoice workbench of Account payables modules (Finance).



Payment will be released by Accounts Paya bles after the Invoice Match (PO Qty, receipt Qty and Invoice Quantity) - 3 way match.



After receiving, if any defect is found in the material then the material can be returned returned to the vendor and debit memo is created against the supplier for the defective Quantity.



If the material delivery is delayed from supplier end, Penalty charges are charged on the supplier as per the instruction received through Mail by Purchasing Department. This is a manual process i n oracle by creating Manual Debit memo against the supplier to the agreed amount.


Document Control

ii



Process Step Catalogs PO Receipts ID

Process

Process Description

INV-BP – 060.01

Receiving Stock items

PO Receipt: (Stock Items) 1. Stocke Stocked d Items agains againstt Purchase Purchase Orders Orders will will be rece receive ived d in to appr approp opria riate te Stor Store e Loca Locati tion ons s ment mentio ione ned d in the the Purc Purcha hase se Order /BPA. Release Shipments. ‘Direct delivery’ type of Receipt Routing will be used. One step Process.

2.

3. Receipt # is generated after this process. The Sub inventory inventory Material Material Valuation Valuation account will be charged for PO price value on Receipt. 4. Duri During ng rece receip iptt Seri Serial al Numb Number er,, Lot Lot numb number er Locato Locators rs quan quantit tity y detai details ls are entered for the receipt. (as per Item setup)

5. The actual actual delivery delivery date (speci (special al field other than the PO Receipt (GRN) date) will be manually entered in line level DFF for each PO Receipt transaction which will be used for the Aging report in Oracle Accounts Payable module.

Fitment Type

Form Customizatio n

Fitment Description

To default default the supplier part number in the Line Items, view Purchase Requestor name, Note to receiver and additional info.

Automation

Manual


Process Step Catalogs PO Receipts ID

Process

Process Description

INV-BP – 060.01

Receiving Stock items

PO Receipt: (Stock Items) 1. Stocke Stocked d Items agains againstt Purchase Purchase Orders Orders will will be rece receive ived d in to appr approp opria riate te Stor Store e Loca Locati tion ons s ment mentio ione ned d in the the Purc Purcha hase se Order /BPA. Release Shipments.

Fitment Type

Form Customizatio n

‘Direct delivery’ type of Receipt Routing will be used. One step Process.

2.

3. Receipt # is generated after this process. The Sub inventory inventory Material Material Valuation Valuation account will be charged for PO price value on Receipt.

Fitment Description

Automation

To default default the supplier part number in the Line Items, view Purchase Requestor name, Note to receiver and additional info.

Manual

4. Duri During ng rece receip iptt Seri Serial al Numb Number er,, Lot Lot numb number er Locato Locators rs quan quantit tity y detai details ls are entered for the receipt. (as per Item setup)

5. The actual actual delivery delivery date (speci (special al field other than the PO Receipt (GRN) date) will be manually entered in line level DFF for each PO Receipt transaction which will be used for the Aging report in Oracle Accounts Payable module.


Document Control

ii



Process

Process Description

Fitment Type

Fitment Description

Automation

INV-BP – 060.01.02

Receivin g Expense Goods / services

PO Receipt: (Expense Goods / Services)

cust custom omiza izati tion on

PO rece receip iptt for Expense Goods/ services.

Manual.

1. All the User departme departments nts including including Workshop will have the access to Purchase requisition for Expense Goods and services. 2. The The rece receip iptt of the the Expe Expens nse e Good Goods s / Expense services for the above PO’s will be by appropriate users against the Cost centre / Project #/ service #/Workshop Job order. 3. ‘Direct delivery delivery’’ type of Receipt Receipt Routing Routing will be used. One step Process. On Receipt Receipt of the Expense Expense Goods Goods / 4. Expens Expense e servic services, es, approp appropriat riate e Expens Expense e Acco Accoun untt will be charg charged ed.. The The actua actuall delivery date (special field other than the PO Receipt (GRN) date) will be manually manually ente entere red d in line line leve levell DFF DFF for each each PO Receipt transaction which will be used for the the agin aging g repo report rt in Orac Oracle le Acco Accoun unts ts Payable module. 5. Service: Generic Service Item codes like Professional services, Maintenance services etc will be created in the Item Master. But users can update the description in Purchase requisition. Service receipt is a logical receipt which is ‘amount based ‘. This Receipt is made in the system to close the related Purchase Order and releasing Payments to supplier from AP.

PR requestor’s department users only can receive their Goods/ services.


Process

Process Description

Fitment Type

Fitment Description

Automation

INV-BP – 060.01.02

Receivin g Expense Goods / services

PO Receipt: (Expense Goods / Services)

cust custom omiza izati tion on

PO rece receip iptt for Expense Goods/ services.

Manual.

1. All the User departme departments nts including including Workshop will have the access to Purchase requisition for Expense Goods and services.

PR requestor’s department users only can receive their Goods/ services.

2. The The rece receip iptt of the the Expe Expens nse e Good Goods s / Expense services for the above PO’s will be by appropriate users against the Cost centre / Project #/ service #/Workshop Job order. 3. ‘Direct delivery delivery’’ type of Receipt Receipt Routing Routing will be used. One step Process. On Receipt Receipt of the Expense Expense Goods Goods / 4. Expens Expense e servic services, es, approp appropriat riate e Expens Expense e Acco Accoun untt will be charg charged ed.. The The actua actuall delivery date (special field other than the PO Receipt (GRN) date) will be manually manually ente entere red d in line line leve levell DFF DFF for each each PO Receipt transaction which will be used for the the agin aging g repo report rt in Orac Oracle le Acco Accoun unts ts Payable module. 5. Service: Generic Service Item codes like Professional services, Maintenance services etc will be created in the Item Master. But users can update the description in Purchase requisition. Service receipt is a logical receipt which is ‘amount based ‘. This Receipt is made in the system to close the related Purchase Order and releasing Payments to supplier from AP. Job order/ order/ Project#/ Project#/ service# service# will be captured in Purchase requisitions, which can be referred at the time of Receipt.

6.


Document Control

ii



Process

Process Description

INV-BP – 060.01.03

Receivin g Assets (fleet Related)

PO Receipt: (Assets- Fleet related) Procurement: Vehicle Receiving Officer will have the access to receive the Vehicles through Oracle Receipt form against the PO. E.g.: Vehicles, Ancillary, Exp. Goods, and Exp. Services; 1.

2. While While Receiv Receiving ing the Vehicle Vehicles s Chassis Chassis#, #, Engine # will be captured in the Line Item level DFF enabled for the purpose While rece receiv ivin ing g Vehi Vehicl cle e Anci Ancilla llari ries es 3. While (Bodies) Body# can be captured in the Line Item level DFF enabled for the purpose. This information is passed to Bynx through the interface13.

‘Standard Standard Receipt’ Receipt’ type type of Rece Receip iptt Routing will be used. Two step Process.

4.

On Receipt of the Fleet (Assets) appropriate Asset clearing contra Account will be charged. 5.

Fleet and Fleet items are non Stocked Items and these can be received by the requestor in the Location mentioned in the PR. 6.

Fitment Type

BYNX Interface

Through Through Custom Interface “Receipt information” will be sent to ‘BYNX’

Fitment Description

Automation

Engine #, Chassis # should be captured in Line level DFF of PO Receipt. This information should be sent to Item Master.

Manual


Process

Process Description

INV-BP – 060.01.03

Receivin g Assets (fleet Related)

PO Receipt: (Assets- Fleet related) Procurement: Vehicle Receiving Officer will have the access to receive the Vehicles through Oracle Receipt form against the PO. E.g.: Vehicles, Ancillary, Exp. Goods, and Exp. Services; 1.

2. While While Receiv Receiving ing the Vehicle Vehicles s Chassis Chassis#, #, Engine # will be captured in the Line Item level DFF enabled for the purpose While rece receiv ivin ing g Vehi Vehicl cle e Anci Ancilla llari ries es 3. While (Bodies) Body# can be captured in the Line Item level DFF enabled for the purpose. This information is passed to Bynx through the interface13.

Fitment Type

BYNX Interface

Through Through Custom Interface “Receipt information” will be sent to ‘BYNX’

Fitment Description

Automation

Engine #, Chassis # should be captured in Line level DFF of PO Receipt. This information should be sent to Item Master.

Manual

‘Standard Standard Receipt’ Receipt’ type type of Rece Receip iptt Routing will be used. Two step Process.

4.

On Receipt of the Fleet (Assets) appropriate Asset clearing contra Account will be charged. 5.

Fleet and Fleet items are non Stocked Items and these can be received by the requestor in the Location mentioned in the PR. 6.


Document Control

ii



Process

Process Description

Fitment Type

Fitment Description

Automation

INV-BP – 060.01.04

Receivin g Assets (Non fleet Related)

PO Receipt: (Assets- Non Fleet related)

Standard

Receiving Non fleet Related Assets

Manual

Only Asset Owner users will have the access to receive the Assets (Non Fleets) through Oracle Receipt form against their Purchase Orders. 1.

2. ‘AWCCS bar code’ is generated and associated with each of its assets; this code will be keyed in manually during the receipt of the asset (i.e. PO Receipt for each asset, similar to the chassis number concept of the vehicle…). DFF field will be provided in Oracle Item Master level for this Non –Fleet Asset Items. In addition to this In PO-Receipt form also line level DFF’s will be available. While Receiving the Asset PO’s, the Appropriate Asset owner user has to manually enter the serial number details, which will be stored in Item Master DFF also. ‘Direct Direct Delive Delivery’ ry’ typ type of Rec Receip eipt Routing will be used. One step Process.

3.

4. On Receipt Receipt of the Assets Assets appropri appropriate ate Asset clearing Account attached in the Item level will be charged. 5.

Since these are of Item type non Stocked


Process

Process Description

Fitment Type

Fitment Description

Automation

INV-BP – 060.01.04

Receivin g Assets (Non fleet Related)

PO Receipt: (Assets- Non Fleet related)

Standard

Receiving Non fleet Related Assets

Manual

Only Asset Owner users will have the access to receive the Assets (Non Fleets) through Oracle Receipt form against their Purchase Orders. 1.

2. ‘AWCCS bar code’ is generated and associated with each of its assets; this code will be keyed in manually during the receipt of the asset (i.e. PO Receipt for each asset, similar to the chassis number concept of the vehicle…). DFF field will be provided in Oracle Item Master level for this Non –Fleet Asset Items. In addition to this In PO-Receipt form also line level DFF’s will be available. While Receiving the Asset PO’s, the Appropriate Asset owner user has to manually enter the serial number details, which will be stored in Item Master DFF also. ‘Direct Direct Delive Delivery’ ry’ typ type of Rec Receip eipt Routing will be used. One step Process.

3.

4. On Receipt Receipt of the Assets Assets appropri appropriate ate Asset clearing Account attached in the Item level will be charged. Since these are of Item type non Stocked Items, will be received against Location mentioned in the Purchase Order.

5.


Document Control

ii



Process Flow Return to Supplier


Process Flow Return to Supplier


Document Control

ii



Process

Process description

INV-BP – 060.05

Supplier Return

Return to Supplier : (from stock) Supplier defective Materials Materials can be returned from Stock with reference reference of PO# / Receipt # 1.

Items which are found defective (due to suppliers product defect) in the sub inventory found after some days of PO Receipt can can be returned to supplier against the PO using “Returns” form available in Oracle Inventory module by the store Keeper.

2.

Defective Items from workshops will be received and stored in a ‘Returns’ sub inventory. Later this can be returned to Supplier against PO # reference.

3.

Inventory Material Value is decreased against this stock. i.e., Accounting transactions are reversed.

4.

Debit note will be created in payables module, which is adjusted against the Supplier invoice.

Fitment Type

Supplier Returns

Fitment Description

Automati on

Return to Supplier.

Manual


Process

Process description

INV-BP – 060.05

Supplier Return

Return to Supplier : (from stock) Supplier defective Materials Materials can be returned from Stock with reference reference of PO# / Receipt # 1.

Items which are found defective (due to suppliers product defect) in the sub inventory found after some days of PO Receipt can can be returned to supplier against the PO using “Returns” form available in Oracle Inventory module by the store Keeper.

2.

Defective Items from workshops will be received and stored in a ‘Returns’ sub inventory. Later this can be returned to Supplier against PO # reference.

3.

Inventory Material Value is decreased against this stock. i.e., Accounting transactions are reversed.

4.

Debit note will be created in payables module, which is adjusted against the Supplier invoice.


Fitment Type

Fitment Description

Automati on

Return to Supplier.

Manual

Supplier Returns

Document Control

ii



Process flow Managing Consigned Inventory


Process flow Managing Consigned Inventory


Document Control

ii



Process

Process Description

INV-BP – 070.01

Managing Consigned Inventory

Managing Consigned Inventory: 1. Since Since the the supplie supplierr is maintain maintaining ing his his own own unit unit with within in AWCCS WCCS camp ampus and and also lso rele releas ase es materials based on the Purchase orders issued by AWCCS, Blanket Purc Purcha hase se Agre Agreem emen entt and and BP Releases can be used to meet this process in oracle. 2. Blan Blanket ket Purcha Purchase se Agre Agreem emen entt is created between the supplier and AWCCS for the specified Items. 3. Supp Suppli lier er will deli delive verr the the Mate Materi rial al at the count ounter er base based d on BP Release. Payment nt is made made throu through gh AP 4. Payme invoice for the Receipt #.

Fitment Type

Fitment Description

Automat ion

Work Workar arou oun nd

Inve Inven ntory tory Department Purchase Department

Manual


Process

Process Description

INV-BP – 070.01

Managing Consigned Inventory

Managing Consigned Inventory:

Fitment Type

Fitment Description

Automat ion

Work Workar arou oun nd

Inve Inven ntory tory Department Purchase Department

Manual

1. Since Since the the supplie supplierr is maintain maintaining ing his his own own unit unit with within in AWCCS WCCS camp ampus and and also lso rele releas ase es materials based on the Purchase orders issued by AWCCS, Blanket Purc Purcha hase se Agre Agreem emen entt and and BP Releases can be used to meet this process in oracle. 2. Blan Blanket ket Purcha Purchase se Agre Agreem emen entt is created between the supplier and AWCCS for the specified Items. 3. Supp Suppli lier er will deli delive verr the the Mate Materi rial al at the count ounter er base based d on BP Release. Payment nt is made made throu through gh AP 4. Payme invoice for the Receipt #.


Document Control

ii



Process Flow Min-Max Planning

S t a r t

ABC Analysis

CycleCount

Decidew ewhicha hall Itemswill gofor INV INV Min -Max Planning

Monitoringof ItemC onsumption Judgem entonC nCriticalit ity

Min -MaxPlanning Attributesareset MinQty , MaxQty

OrderModifier Attributesare set - MinOrder Qty , M ax Order Qty , Fixe xed Lot Multiplier

-

MinM n MaxP xProgram scheduledaspertth he interval planned

Min - MaxisRunas per schedule

,

INVPlanner decidesth t he frequencyof Min MaxP xProgramRun

INVP VPlanner reviewsthe Min -Max Report

INVPlannerdecidesto run Min - MaxPlanningEngineItem a) ItemSpecific or b) ItemCategoryS ry Specific or c) All Itemsunder Min Planned

Systems msuggestsP s Purchase Requisi sitio tions , if replen enishment is required

INVPlanner confirm rm stheReplenishment Actions - PurchaseRequisitions necessary changesto to the Requisition Q uantityandD dDueDates

INVP VPlanner

-

INVPlanner decidesu suponthe demanda dandsupply cut off datef efor each Min -Max Program Run

- after making

-Max


Process Flow Min-Max Planning

S t a r t

ABC Analysis

Decidew ewhicha hall Itemswill gofor INV INV Min -Max Planning

CycleCount

Monitoringof ItemC onsumption Judgem entonC nCriticalit ity

Min -MaxPlanning Attributesareset MinQty , MaxQty

,

OrderModifier Attributesare set - MinOrder Qty , M ax Order Qty , Fixe xed Lot Multiplier

-

MinM n MaxP xProgram scheduledaspertth he interval planned

Min - MaxisRunas per schedule

INVPlanner decidesth t he frequencyof Min MaxP xProgramRun

INVP VPlanner reviewsthe Min -Max Report

INVPlannerdecidesto run Min - MaxPlanningEngineItem a) ItemSpecific or b) ItemCategoryS ry Specific or c) All Itemsunder Min Planned

Systems msuggestsP s Purchase Requisi sitio tions , if replen enishment is required

INVPlanner confirm rm stheReplenishment Actions - PurchaseRequisitions necessary changesto to the Requisition Q uantityandD dDueDates

INVP VPlanner Approvesthe Purchase requisitions ns

-

INVPlanner decidesu suponthe demanda dandsupply cut off datef efor each Min -Max Program Run

-Max

- after making

End


Document Control

ii



Process

Process description

Fitment Type

Fitment Description

Automatio n

INV-BP – 080.01

Min Max Planning

Stock replenishment:

Standard

Stock Replenishment

Automati c

1.

Min-Max planning is enabled for items such as Parts, Consumables and Spares during the item definition at Item-Sub inventory level. Source details, Minimum and maximum Quantity will be defined to the Item.

2. Whenev Whenever er stock stock level level goes goes below below the Minimum level, on running the Min-Max report, Purchase requisitions will be triggered for the Maximum Quantity. 3. Min-Max Min-Max plannin planning g reports reports can be run for sub inventories in which Min-max Items are below the minimum levels.

4.

Purchase requisitions are created automatically from the above process and sent for approval.


Process

Process description

Fitment Type

Fitment Description

Automatio n

INV-BP – 080.01

Min Max Planning

Stock replenishment:

Standard

Stock Replenishment

Automati c

1.

Min-Max planning is enabled for items such as Parts, Consumables and Spares during the item definition at Item-Sub inventory level. Source details, Minimum and maximum Quantity will be defined to the Item.

2. Whenev Whenever er stock stock level level goes goes below below the Minimum level, on running the Min-Max report, Purchase requisitions will be triggered for the Maximum Quantity. 3. Min-Max Min-Max plannin planning g reports reports can be run for sub inventories in which Min-max Items are below the minimum levels.

4.

Purchase requisitions are created automatically from the above process and sent for approval.


Document Control

ii



Process Flow Physical Inventory Physic Physical al invent inventory ory is a proces process s to count count all items items in select selected ed sub inventor inventories ies or all sub inventor inventories ies for an organization. The physical inventory process takes a snapshot of the on-hand balances, and generates tags for all items with an on-hand balance. balance. Counts are recorded recorded against the tag number and compared compared to the snapshot snapshot quantity. Deltas between the snapshot quantity and the the counted quantity will generate adjustment transactions. Physical inventory counts are generally performed at the end of a fiscal year, the physical count is compared to a snapshot snapshot or frozen on-hand on-hand balance quantity, quantity, so material movements movements should not be done from the time the snapshot is taken until the count is completed.


Process Flow Physical Inventory Physic Physical al invent inventory ory is a proces process s to count count all items items in select selected ed sub inventor inventories ies or all sub inventor inventories ies for an organization. The physical inventory process takes a snapshot of the on-hand balances, and generates tags for all items with an on-hand balance. balance. Counts are recorded recorded against the tag number and compared compared to the snapshot snapshot quantity. Deltas between the snapshot quantity and the the counted quantity will generate adjustment transactions. Physical inventory counts are generally performed at the end of a fiscal year, the physical count is compared to a snapshot snapshot or frozen on-hand on-hand balance quantity, quantity, so material movements movements should not be done from the time the snapshot is taken until the count is completed.


Document Control

ii



ID

Description

Frequency

Notes

Agent

Automation

INV-BP – 090.01

Defi Define ne Phys Physic ical al Inv Inven ento tory ry Enter a unique physical inventory name Select approval requirements for adjustments

One tim time e One time

Physical inventory name

Inventory

Manual

Inventory

Manual

Enter positive and negative approval tolerances

One ti time

If ap approval is is re requir ed ed fo for adjustments out of tolerance you must enter a value in at least one of these fields. You cannot update these values after you perform physical Inventory adjustments. Qty : Enter acceptable Positive and Negative limits (expressed as a percentage) for the difference between the systemtracked on-hand quantity and the actual tag count quantity. Value: Value: Enter acceptable Positive and Negative limits for the total value of a physical inventory adjustment If ap approval is is re requir ed ed fo for adjustments out of tolerance you must enter a value in at least one of these fields. You cannot update these values after you perform physical inventory adjustments. Qty : Enter acceptable Positive and Negative limits (expressed as a percentage) for the difference between the systemtracked on-hand quantity and

Inventory

Manual

One ti time


ID

Description

Frequency

Notes

Agent

Automation

INV-BP – 090.01

Defi Define ne Phys Physic ical al Inv Inven ento tory ry Enter a unique physical inventory name Select approval requirements for adjustments

One tim time e One time

Physical inventory name

Inventory

Manual

Inventory

Manual

Enter positive and negative approval tolerances

One ti time

If ap approval is is re requir ed ed fo for adjustments out of tolerance you must enter a value in at least one of these fields. You cannot update these values after you perform physical Inventory adjustments. Qty : Enter acceptable Positive and Negative limits (expressed as a percentage) for the difference between the systemtracked on-hand quantity and the actual tag count quantity. Value: Value: Enter acceptable Positive and Negative limits for the total value of a physical inventory adjustment If ap approval is is re requir ed ed fo for adjustments out of tolerance you must enter a value in at least one of these fields. You cannot update these values after you perform physical inventory adjustments. Qty : Enter acceptable Positive and Negative limits (expressed as a percentage) for the difference between the systemtracked on-hand quantity and the actual tag Count quantity. Value: Value: Enter acceptable Positive and Negative limits for the total value of a physical Inventory adjustment.

Inventory

Manual

One ti time


Document Control

ii



Description

Frequency

Select the scope of the physical inventory

One time

Indicate whether to allow dynamic entry of tags.

As requ requir ired ed

Select Exclude Zero Balances Select Exclude Negative Balances


Save Work Take Snapshot Snapshot

As requ require ired d

As required As required

Generate Physical Inventory Tags


Enter and Void Physical Inventory Approval Process for Adjustment

As requ requir ired ed As req requ uired ired

Notes

Determines whether the physical inventory is for all sub inventories or for one or more specific sub inventories. Only enter a quantity tracked sub inventory. If you do not not wan wantt to to all allow ow dynamic tag entry but you need blank tags, you can generate numbered blank tags for counting miscellaneous items to excl exclud ude e item items s wit with h zero zero quantity from the snapshot to excl exclud ude e item items s wit with h a nega negativ tive e quantity from the snapshot Save This step must be completed completed before you can generate tags The snapshot snapshot saves all current item on-hand quantities and costs Orac Oracle le Inve Invent ntor ory y can can gene genera rate te default or blank tags for your physical inventory. If you choose to generate default tags for each item, specify the starting tag number and the Increment by which you want to increase each digit in the tag number. Ente Enterr and and Void Void Phys Physic ical al Inventory Adju Adjust stme ment nts s are are perf perfor orme med d based on the Approval Workflow

Agent

Automation

Inventory

Manual

Inventory

Manual

Inventory

Manual

Inventory

Manual

Inventory Inventory

Manual Manual

Inventory

Manual

Inventory

Manual

Inventory/Finance

Manual


Description

Frequency

Select the scope of the physical inventory

One time

Indicate whether to allow dynamic entry of tags.


Select Exclude Zero Balances Select Exclude Negative Balances


Save Work Take Snapshot Snapshot



Generate Physical Inventory Tags


Enter and Void Physical Inventory Approval Process for Adjustment

As requ requir ired ed As req requ uired ired

Notes

Determines whether the physical inventory is for all sub inventories or for one or more specific sub inventories. Only enter a quantity tracked sub inventory. If you do not not wan wantt to to all allow ow dynamic tag entry but you need blank tags, you can generate numbered blank tags for counting miscellaneous items to excl exclud ude e item items s wit with h zero zero quantity from the snapshot to excl exclud ude e item items s wit with h a nega negativ tive e quantity from the snapshot Save This step must be completed completed before you can generate tags The snapshot snapshot saves all current item on-hand quantities and costs Orac Oracle le Inve Invent ntor ory y can can gene genera rate te default or blank tags for your physical inventory. If you choose to generate default tags for each item, specify the starting tag number and the Increment by which you want to increase each digit in the tag number. Ente Enterr and and Void Void Phys Physic ical al Inventory Adju Adjust stme ment nts s are are perf perfor orme med d based on the Approval Workflow

Agent

Automation

Inventory

Manual

Inventory

Manual

Inventory

Manual

Inventory

Manual

Inventory Inventory

Manual Manual

Inventory

Manual

Inventory

Manual

Inventory/Finance

Manual


Document Control

ii



Process Flow Cycle Counting Cycle counting is a process used to periodically count selected items in the inventory to make sure that the actual inventory balances agree with the system records. By setting up a cycle counting program, all items in the inventory can be counted over a period of 12 months. In the Oracle Inventory applica tion, the cycle counting process starts with assigning an ABC value to each item. Then select the frequency of counts per year for each category of items. Appropriate Adjustments approvals are processed by authorized person from Finance team.


Process Flow Cycle Counting Cycle counting is a process used to periodically count selected items in the inventory to make sure that the actual inventory balances agree with the system records. By setting up a cycle counting program, all items in the inventory can be counted over a period of 12 months. In the Oracle Inventory applica tion, the cycle counting process starts with assigning an ABC value to each item. Then select the frequency of counts per year for each category of items. Appropriate Adjustments approvals are processed by authorized person from Finance team.


Document Control

ii





Document Control

ii



Description

Frequency

INV-BP – 100.01

Define Define ABC Classes Classes

As required required

Comp Compil ile e AB BC C analy nalys sis

Once

Defin Define e Cycle Cycle count count

As requir required ed

Enter Scope of the count

Once

Enter Se Serial and Schedule

Once

Adjustment and ABC

Once

Classes

As required

Generate daily count Perfo Perform rm full full cycle cycle cou count nt repo report rt

As required As requir required ed

Genera nerate te Mult Multip iple le rep report

A s requ requir ire ed

Run Run Gen Gener erat ate e Coun Countt requ reques estt

As Requ Require ired d

Run Run Cycl Cycle e coun countt listi listing ng rep repor ortt

As req requi uire red d

Entering Cycle count

As required

Find Cycle count

As required

Entry performed

As required

E t

A

Q

tit

i

d

Notes

Agent

Automation

Define Define the ABC classes classes based based on the Historical number of Transactions Comp ompile ile ABC analys lysis to atta attach ch items to the classes. Define Define cycle cycle count count name, name, Calendar and Adjustment account Inactive date, Count Sequence no and Sub I nventory Whether Serial control It Items are also needed for the counting and Count Schedule Enter the adjustment control and Attach the ABC In classes enter the count per year

Stores Su Supervisor

Manual


Manual


Manual


Manual


Manual


Manual


Manual

Plan for the daily count From From the the Tools Tools menu menu Run Run the Perform cycle count report Perfo rform cyc cycle count ount rep repo orrtt wil willl trigger multiple reports. Coun Countt requ reques estt can can be be don done e on on manual or System Generated. This This repo report rt will will cont contai ains ns all all the the items for cycle counting within the given date range. Entering cycle count result in the system. Select your cycle count from cycle count summary window. Find all open count request. Enter the Name of the employee who performed the cycle count. E t th C tS It S b

Stores Supervisor Stores Su Supervisor

Manual Manual


Manual


Manual


Manual


Manual


Manual


Manual

St

M

s S

i

l


Description

Frequency

INV-BP – 100.01

Define Define ABC Classes Classes

As required required

Comp Compil ile e AB BC C analy nalys sis

Once

Defin Define e Cycle Cycle count count

As requir required ed

Enter Scope of the count

Once

Enter Se Serial and Schedule

Once

Adjustment and ABC

Once

Classes

As required

Generate daily count Perfo Perform rm full full cycle cycle cou count nt repo report rt

As required As requir required ed

Genera nerate te Mult Multip iple le rep report

A s requ requir ire ed

Run Run Gen Gener erat ate e Coun Countt requ reques estt

As Requ Require ired d

Run Run Cycl Cycle e coun countt listi listing ng rep repor ortt

As req requi uire red d

Entering Cycle count

As required

Find Cycle count

As required

Entry performed

As required

Enter Quantity

As required

Approving Cycle count Query Cycle count


Notes

Agent

Automation

Define Define the ABC classes classes based based on the Historical number of Transactions Comp ompile ile ABC analys lysis to atta attach ch items to the classes. Define Define cycle cycle count count name, name, Calendar and Adjustment account Inactive date, Count Sequence no and Sub I nventory Whether Serial control It Items are also needed for the counting and Count Schedule Enter the adjustment control and Attach the ABC In classes enter the count per year


Manual


Manual


Manual


Manual


Manual


Manual


Manual

Plan for the daily count From From the the Tools Tools menu menu Run Run the Perform cycle count report Perfo rform cyc cycle count ount rep repo orrtt wil willl trigger multiple reports. Coun Countt requ reques estt can can be be don done e on on manual or System Generated. This This repo report rt will will cont contai ains ns all all the the items for cycle counting within the given date range. Entering cycle count result in the system. Select your cycle count from cycle count summary window. Find all open count request. Enter the Name of the employee who performed the cycle count. Enter the Count Seq, Item, Sub Inventory and Quantity for each item. Save after entering all results. Approving the count re results. Select your cycle count from cycle count summary window. Query counts pending approval.


Manual Manual


Manual


Manual


Manual


Manual


Manual


Manual


Manual


Manual Manual


Document Control

ii



Description

Frequency

Notes

Agent

Automation

If Adju Adjust stme ment nt Any approval Production ap approval

As requ require ired d As required As re required

Is ther there e any any Adju Adjust stme ment nt is ther there e Need Approval Need Pr Production Ap Approval se send the Information to the User

Store Stores s Supe Superv rvis isor or Stores Supervisor Stores Su Supervisor

Manu Manual al Manual Manual

Finance ap approval

As required

Sends no notification to to finance Approval


Manual


Description

Frequency

Notes

Agent

Automation

If Adju Adjust stme ment nt Any approval Production ap approval

As requ require ired d As required As re required

Is ther there e any any Adju Adjust stme ment nt is ther there e Need Approval Need Pr Production Ap Approval se send the Information to the User

Store Stores s Supe Superv rvis isor or Stores Supervisor Stores Su Supervisor

Manu Manual al Manual Manual

Finance ap approval

As required

Sends no notification to to finance Approval


Manual


Document Control

ii



Process Step Catalogs Period Close ID

INV-BP – 110.01

Process

Sequential set of proc proced edur ures es shou should ld be foll follow owed ed for for clos closin ing g a Period iod in Inv Inventory. Transaction Transaction distribution distributions s will be posted GL. GL. To close a period: 1. Ente Enterr all trans transact action ions. s. Perf Perfor orm m all all issu issues es,, receipts, and adjustments. 2. Review Inventory transactions. 3. Balance perpetual inventory. 4. Close Close Oracl Oracle e Payab Payable les s and Oracle Purchasing. 5. Run Run the the Peri Period od Close Close Reconciliation report. 6. Clos Close e the the acco accoun unti ting ng period.

Description

Fitment Type

Fitment Description

Automation

Accounting Period is closed in the system and posted to General Ledger.

Standard

Standard oracle Period close process

Manual


Process Step Catalogs Period Close ID

INV-BP – 110.01

Process

Sequential set of proc proced edur ures es shou should ld be foll follow owed ed for for clos closin ing g a Period iod in Inv Inventory. Transaction Transaction distribution distributions s will be posted GL. GL. To close a period: 1. Ente Enterr all trans transact action ions. s. Perf Perfor orm m all all issu issues es,, receipts, and adjustments. 2. Review Inventory transactions. 3. Balance perpetual inventory. 4. Close Close Oracl Oracle e Payab Payable les s and Oracle Purchasing. 5. Run Run the the Peri Period od Close Close Reconciliation report. 6. Clos Close e the the acco accoun unti ting ng period.

Description

Fitment Type

Fitment Description

Automation

Accounting Period is closed in the system and posted to General Ledger.

Standard

Standard oracle Period close process

Manual


Document Control

ii



Process Step Catalogs Reporting Note: Custom Reports will be developed based on the AWCCS requirement & Templates. ID

INV-BP – 120.01R01

Process

Description

Mater ateriial Requ Reques estt Slip Slip (MR) (MR)

Rep Report ort

Material issue Slip

Report

Pending Material Request details Report Inventory Packing slip Report

Report

Fitment Type

Report

Cust Custom omiz izat atio io n Customizatio n Customizatio n Standard

Move Order Pick slip Report

Report

Cycle Counting Snapshot report Physical Inventory Tag Listing Report for counting the Items Cycle counting Tag Listing Report for counting the Items Cycle Counting Adjustment Report should include Supplier Part number Physical Inventory Adjustment Report should include Supplier Part number Physical Physical Inventory Inventory Snap shot reports should display Supplier Part numbers against AWCCS Item codes.

Report

Fitment Description

Automation

Customizati ation

Manu anual

Customizati ation

Manu anual

Customizati ation

Manu anual

Standard

Manual

Standard

Standard

Manual

TBD

TBD

Manual

Report

Standard

Standard

Manual

Report

Standard

Standard

Manual

Report

Customizatio n

Customizati ation

Manu anual

Report

Customizatio n

Customizati ation

Manu anual

Report

TBD

TBD

Manual


Process Step Catalogs Reporting Note: Custom Reports will be developed based on the AWCCS requirement & Templates. ID

Process

INV-BP – 120.01R01

Description

Mater ateriial Requ Reques estt Slip Slip (MR) (MR)

Rep Report ort

Material issue Slip

Report

Pending Material Request details Report Inventory Packing slip Report

Report

Fitment Type

Report

Cust Custom omiz izat atio io n Customizatio n Customizatio n Standard

Move Order Pick slip Report

Report

Cycle Counting Snapshot report Physical Inventory Tag Listing Report for counting the Items Cycle counting Tag Listing Report for counting the Items Cycle Counting Adjustment Report should include Supplier Part number Physical Inventory Adjustment Report should include Supplier Part number Physical Physical Inventory Inventory Snap shot reports should display Supplier Part numbers against AWCCS Item codes.

Report

Fitment Description

Automation

Customizati ation

Manu anual

Customizati ation

Manu anual

Customizati ation

Manu anual

Standard

Manual

Standard

Standard

Manual

TBD

TBD

Manual

Report

Standard

Standard

Manual

Report

Standard

Standard

Manual

Report

Customizatio n

Customizati ation

Manu anual

Report

Customizatio n

Customizati ation

Manu anual

Report

TBD

TBD

Manual


Document Control

ii



Open and Closed Issues for this Deliverable Open Issues

ID

Issue

Resolution

Responsibility

Target Date

Impact Date

Resolution

Responsibility

Target Date

Impact Date

Closed Issues

ID

Issue


Open and Closed Issues for this Deliverable Open Issues

ID

Issue

Resolution

Responsibility

Target Date

Impact Date

Resolution

Responsibility

Target Date

Impact Date

Closed Issues

ID

Issue



ii

BP080 Future Process AWCCS Inventroy V2.2

Recommend Documents