Miscellaneous Transactions

Miscellaneous Transactions

We have 6 types of miscellaneous transactions, they are

                                  i.            Miscellaneous Receipt

                                ii.            Miscellaneous Issue

                              iii.            Account Receipt

                             iv.            Account Issue

                               v.            Account Alias Receipt

                             vi.            Account Alias Issue

 

1.     Miscellaneous Receipt:

Miscellaneous Receipt transaction in Oracle Inventory is performed to increase inventory for any miscellaneous Inventory adjustments.

To Perform Miscellaneous Receipt first create a item, then create a sub-inv and check whether the periods are opened or not.

Now go to

Inventory -> Transactions ->Miscellaneous Transaction

Select type as Miscellaneous Receipt, then click on Transaction Lines

Now give the item, Sub-inv, Qty, Account and then save

 

 

Now we’ll check On-Hand Qty

Go to Inv-> On-Hand, Availability -> On-Hand Qty

Here search with the item

 

Click on Availability to check Qty

 

 

2.     Miscellaneous Issue:

·        A Miscellaneous Issue can issue material from general ledger accounts in your current organization.

·        This allows you to issue material to groups that are not inventory, receiving, or work in process such as a research and development group or an accounting department.

 

To perform Miscellaneous Issue, go to

Inventory -> Transactions ->Miscellaneous Transaction

Select type as Miscellaneous Issue, then click on Transaction Lines

Now give the item, Sub-inv, Qty, Account and then save

Give how much qty you want to issue and save

Now we’ll check On-Hand Qty

Go to Inv-> On-Hand, Availability -> On-Hand Qty

Here search with the item

Click on Availability to check Qty

 

·        To see this Inventory entries

·        Go to

Inventory -> Transactions ->Material Transaction

Remove the Dates and Search with the item

In Transaction Type screen we can the Transaction entries

 

3.     Account Receipt:

We use Account receipt to receive the stock, and here it is mandatory to give source information in Header level

To perform Account Receipt, go to

Inventory -> Transactions ->Miscellaneous Transaction

Select type as Account Receipt, Here we can see Source as Mandatory Field

 and then click on Transaction Lines

Here we can see Accounting information is automatically derived

Save screen and check on-hand qty

 

4.    Account Issue:

We use Account Issue to issue the stock, and here it is mandatory to give source information in Header level

To perform Account Issue, go to

Inventory -> Transactions ->Miscellaneous Transaction

Select type as Account Issue, Here we can see Source as Mandatory Field

 and then click on Transaction Lines

Now give the item, Sub-inv, Qty, Account and then save

Give how much qty you want to issue and save

Here we can see Accounting information is automatically derived

 

Save screen and check on-hand qty

 

· 
To see this Inventory entries

·        Go to

Inventory -> Transactions ->Material Transaction

Remove the Dates and Search with the item

In Transaction Type screen we can the Transaction entries

5.    Account Alias Receipt:

·        An account alias is an easily recognized name or label representing a general ledger account number.

·        You can view, report, and reserve against an account alias. During a transaction, you can use the account alias instead of an account number to refer to the account.

·        Account Alias Receipt is one of the Inventory transactions that Oracle Inventory module offers.

·        Like any other 'RECEIPT' inventory transactions it increases the on-hand quantity in the receiving transaction subinventory.

 

To perform Account Alias Receipt we need to create a Account Alias KFF

No go to

Inventory -> Setup -> Account Aliases

 

Save it and now let’s perform the Transaction

To perform Account Alias Receipt, go to

Inventory -> Transactions ->Miscellaneous Transaction

Select type as Account Alias Receipt,

 Here in Source we have to give our Alias

 and then click on Transaction Lines

Now give the item, Sub-inv, Qty, Account and then save

Give how much qty you want to receive and save

Here we can see Accounting information is Hidden

Save screen and check on-hand qty

6.    Account Alias Issue:

By using Account Alias Issue we’ll issue the stock from our inventory

To perform Account Alias Issue, go to

Inventory -> Transactions ->Miscellaneous Transaction

Select type as Account Alias Issue,

 Here in Source we have to give our Alias

 and then click on Transaction Lines

Save screen and check on-hand qty

·        To see this Inventory entries

·        Go to

Inventory -> Transactions ->Material Transaction

Remove the Dates and Search with the item

In Transaction Type screen we can the Transaction entries

Item Template Creation

Item Template Creation

• Templates are defined sets of attributes that you can use over and over to create many similar items.
•  Templates make initial item definition easier.
•     Oracle recommends that you use templates--either those Oracle provides or those you define--when you define your items.

To create a Item Template, go to

INV -> Setup -> Items -> Templates

Click on new and create your own template

Give name to the template and follow the same values and save

·        In main tab,

 

·        In Inventory tab,

·        In BOM,

·        In costing tab,

·        In Purchasing tab,

 

·        In WIP tab,

·        In Order Management tab,

·        In Invoice tab

·        After creating everything just save it

·        Now we create a item and use this template

 To create a item go to

Inv-> Items -> Master Items

 

Now to copy the template

Click on the Tools -> Copy from

Then give our template and click on done

Now we can see template is Applied

Profile Options

Uses of Profile Options and how to set them for Responsibility

Basically we have four Profile options for every Responsibility, they are

1.     HR: Security Profile

2.     MO: Security Profile

3.     MO: Operating Unit

4.     GL: Ledger Name

·        To assign Profile Options to the Responsibilities

·        Go to

System Administrator -> Profile -> System

·        Here select the Responsibility Check Box and give your responsibility

·        In Profile dialog box, give the Profile Option

 

 

1.   HR: Security Profile:

HR: Security Profile is used to restrict the data in Human Resources according to the Business Group or whatever criteria you define in this security profile. Thus, for HR, it uses this security profile in its data exposure to the user.

 

·        Here we set the profile option for our (Inventory Responsibility)

·        Here we give our Business Group

·        And it works, depends on which level we are going to use this responsibility

·        Here I’m using this at the responsibility level

 

2.   MO: Security Profile:

MO: Security Profile acts the same but is used for Financials and Manufacturing applications. It restricts the access (site level or can be set at responsibility level) to certain operating unit (or whatever criteria defined in the security profile).

 

·        Here we set the profile option for our (Inventory Responsibility)

·       Here we give our Operating Unit

·        And it works, depends on which level we are going to use this responsibility

·        Here I’m using this at the responsibility level

 

 

3.   MO: Operating Unit:

 

The MO: Operating Unit profile option only provides access to one operating unit.

The MO: Security Profile provides access to multiple operating units from a single responsibility.

MO: Operating Unit– Secondary priority being evaluated after ‘MO: Security Profile’

 

·        Here we set the profile option for our (Inventory Responsibility)

·       Here we give our Operating Unit

·        And it works, depends on which level we are going to use this responsibility

·        Here I’m using this at the responsibility level

 

4. GL: Ledger Name:

 

This allows you to drill down to your subledgers independent from their multiple organization setup. As a result, when you drill down to subledger details, General Ledger will show you all of the transactions that comprise an account balance, regardless of which organization originated the transaction.

·        Here we set the profile option for our (Inventory Responsibility)

·       Here we give our Operating Unit

·        And it works, depends on which level we are going to use this responsibility

·        Here I’m using this at the responsibility level

 

 

Repeat the Same Process for every Responsibility

BLANKET PURCHASE AGREEMENT

                                     BLANKET PURCHASE AGREEMENT

v We will raise Blanket Purchase Agreement (BPA) when we know about Goods and Service, Terms and Conditions which has a agreement with specific Supplier.

v In BPA Price is a Particular thing.

v Here we don’t know about the Quantity, how much we are procuring at the time of BPA.

v Here we need to do Blanket Release against the BPA.

 

o   Now we will perform BPA

o   Go to

o   Purchasing super user – Purchase orders – purchase orders

o   Give Type as BPA and Give Supplier and Item

o   Here we can see Quantity field is Grade out.

o   Give Terms and Conditions

o   Then click on Price Breaks and give Quantity and Save

o   Then send it for Approval

o   Here I had set Auto Approval so it gets Auto Approved.

 

v After getting PO approval Copy PO num

v In PO summary Screen We can see the status of the PO

v Now we have to do Blanket Release

o   Go to

o   Purchasing super user – Purchase orders – Releases

o   Give PO num and find

 

o   Here Give PO num and Tab Out the we can see Release num

o   In Shipments – Give Line, Quantity and Need By Date

o   Then once check out Distributions

o   In Agreements after Release  Approval we can total Released Amount.

v Now we do Receiving for that PO

o   Go to

o   Purchasing super user – Receiving – Receipts

o   Give PO num and Find

o   Select line and give Sub Inv and then Save

 

o   Then go to Receiving Transaction Summary Screen

o   Give PO and Find

o   Select Receipt num and click on Transactions