Inventory Transactions

Inventory Transactions

Below are the different types of transactions that can be created in Inventory

  1. Miscellaneous
  2. Move Order
  3. Inter-Org transfers
  4. Account alias issue and receipt
  1. Miscellaneous Transactions are used to create adjustments for the missing or any in-accurate transactions.

Responsibility: Inventory Vision Operations or MM INV

Change the organization to MIP (MM INV PUNE) as we would be creating the miscellaneous transaction in MIP organization.

Navigate to TRANSACTIONS-> MISCELLANEOUS TRANSACTIONS

Now when we try to create the transaction we would be getting an error “NO OPEN PERIOD” as the period should be open to do any transaction in that period.

OPEN the period in Inventory:

Navigate to ACCOUNTING CLOSE CYCLE-> INVENTORY ACCOUNTING PERIODS

Select OCT-12 Period

Click on Change Status

The period is now open.

Now we would be able to create a transaction.

Navigate to TRANSACTIONS-> MISCELLANEOUS TRANSACTIONS (Adding the Item qty into the inventory)

Date: 16-OCT-2012

Type: MISCELLANEOUS Receipts

Click on TRANSACTION LINES

Item                      Sub-Inventory                   Qty         UOM

MIHITEM             ST1 (Store 1)                      1000       EA

Finally SAVE

Now to check the stock of the item MIHITEM

Navigate to ONHAND AVAILABILITY->ONHAND QTY

Item/Revision: MIHITEM

Click on FIND

This would be showing on-hand qty availability as 1000

Now we create Miscellaneous Issues (Moving the Item Qty out of the inventory by creating Transaction issue)

Navigate to TRANSACTIONS-> MISCELLANEOUS TRANSACTIONS

Type: Miscellaneous Issue

Click on TRANSACTION LINES

Item                      Sub-Inventory                   Qty         UOM

MIHITEM             ST1 (Store 1)                      300         EA

Now to check the stock of the item MIHITEM

 Navigate to ONHAND AVAILABILITY->ONHAND QTY

 Item/Revision: MIHITEM

Click on FIND

This would be showing on-hand qty availability as 700.

Note: For miscellaneous transaction there would not be any reference like source as purchase order for receiving items, sales order for issuing items or inter-org transfer.

Now to Create Statistics for the number of transactions created on Item.

Navigation: TRANSACTION->TRANSACTION SUMMARIES.

Item: MIHITEM

Click on SUMMARIZE

Volume (Transactions)

Total In: 1000                                                     1

Total Out: 300                                                    1

Net: 700

Now if we click on the TRANSACTION it would display the transaction type (Source of the Transaction)

  2.  Move order transactions are created to move the goods physically from store to another store or staging area within the same inventory organization.

Move orders are going to be processed in 4 steps:

–> Creating a move order

–> Approving a move order

–> Allocating a move order

–>  Transacting a move order

Note: No approval is created if the move order is coming from other sources. But approval is required for manual creating a move order.

Note: Move order is to move the items from one sub inventory (store) to another sub inventory (store) in the same inventory organization.

Let us consider a case where we have 700 qty in store 1 and we need to move qty from store 1 to store 2 or staging area.

Navigate to MOVE ORDER->MOVE ORDERS

Tab out to get the Number generated by the system

Transaction Type: Move Order Transfer

Source Sub Inv: St1 (Store 1)

Destination Sub Inv: St2 (Store 2)

Items:

Item: MIHITEM

Transaction type: Move order

Qty: 350

Now SAVE.

Now we next need to APPROVE the Move order

Click on APPROVE to approve

(To restrict the Un-authorized approval of move order in real time this is restricted using “NON FORM” features)

The status of the move order is now APPROVED

Next we need to Allocate Qty

Navigate: MOVE ORDER->TRANSACT MOVE ORDER

Find the move order by clicking FIND.

Select (√) the Line.

Click on ALLOCATE.

The allocation is now updated with SINGLE

Note: We can observe that the Line status has the value as SINGLE in allocation column; this is because the quantity is moved from a single store and the source is single store. But if the item are moved from multiple stores then the column will have value MULTIPLE.

Next would be to generate MOVE ORDER SLIP Report.

Navigation: View->Request

Submit a new request

Program: MOVE ORDER PICK SLIP REPORT

Click on SUBMIT

View Output (Details of the move order)

This report is handed over to the Store In change.

Now once the report is generated go back to the form “Transact Move Order

Click on TRANSACT   (This will physically move the stock from store 1 to store 2)

Once we click on TRANSACT there would not be any lines visible in future if the item qty is fully available in the store, but in case there is no sufficient stock available then they would be a line with pending stock details.

Note: In move order at warehouse the qty would be as is , but the item qty is changed only at the store level to check on that navigate to ONHAND AVAILABILITY->ONHAND QTY

Now again we Create a Move order

Navigate to MOVE ORDER->MOVE ORDERS

Tab out to get the Number generated by the system

Here leave the Source Sub Inv blank but the destination sub inv is Store 3(ST3)

Item: MIHITEM

Transaction type: Move order

Qty: 450

Now SAVE

Now we next need to APPROVE the Move order

Click on APPROVE to approve

Next we need to Allocate Qty

Navigate: MOVE ORDER->TRANSACT MOVE ORDER

Find the move order by clicking FIND.

Here if we observe the system will automatically allocate the qty from the store from the store which is having the said qty. the system used the rules PICKING RULES defined for allocation of the qty for the item.

We can also click on View/Update allocation and change the allocation qty.

Select (√) the Lines.

Click on ALLOCATE.

The allocation is now updated with MULTIPLE

Next would be to generate MOVE ORDER SLIP Report.

Navigation: View->Request

Submit a new request

Program: MOVE ORDER PICK SLIP REPORT

Click on SUBMIT

View Output (Details of the move order)

Now once the report is generated go back to the form “Transact Move Order

Click on TRANSACT   (This will physically move the stock)

Sub-Inventory Transfers

Sub-Inventory Transfers are only used for creating adjustments. There is no physical movement of stock.

Now let us consider a case where in the stock is moved physically from one store to another in the same inventory org. but while moving the stock physically there is mismatch in the transfer and at the destination store has received a less quantity than the actual. So for this deficit quantity an adjustment is made both at the source store and the destination store.

Store 1 is transferring 350 quantities physically of an Item to Store 2, but store 2 has received only 345 quantity of that item. So for this an adjustment transaction is created for Store 1 and store 2 where in store 1 will be adjusted with +5 qty and store 2 would be adjusted with -5 items. This is done because at the start there was a transaction in both store 1 and store 2 as item qty as 350, but only 345 is actually received by store 2.

Responsibility: Inventory Vision Operations/ MM INV

Navigation: TRANSACTIONS->SUBINVENTORY TRANSFERS

Date: Sysdate

Type: Subinventory Transfer

Click on TRANSACTION LINE

Item: MIHITEM

Qty: 5

(Provide information of both the Subinventory (Stores))

Next SAVE the adjustment.

This adjustment transaction will create an adjustment entry and decrease/increase the on-hand quantity by 5 in both the sub inventories (Stores).

Move Order Issue

Move Order Issue is used to issue the stock to a receiving location. Used to  issue stock from store to some location.

Navigate to MOVE ORDER->MOVE ORDERS Issue

Tab out to get the Number generated by the system

Transaction type:  Move Order Issue

Location: MI_SEATTLE MFG (This field is enabled if the transaction type is Move Order Issue)

Item: MIHITEM

Then SAVE.

Remaining all the other process for a move order remains the same.

  3.     Inter-Organization Transfer is used to transfer the materials from one inv-org to another inv-org without any internal sales order as a source.

To execute the Inter-Organization Transfers we need to define Shipping Network from the source to the destination and the items that is to be transferred should be assigned in both the inventory organization (Source and Destination)

Defining the Shipping Network:

Navigation SETUP->ORGANIZATIONS->SHIPPING NETWORKS

Organization: MIP (MM INV PUNE)

Scope: From or To org/ From org / To Organization           (Defines the scope of the Org either only from or only to org or both can be defined as a shipping network)

We select From or To Organization

From To Transfer Type FOB Receipt Routing
MIP(Pune Inv) MIG(Goa Inv) Direct/In transit Receipt/Shipment Direct/Standard/Inspection

                                    In Transit is selected   Receipt is selected              Direct is selected

Transfer Type: (Direct/Intransit)

If direct transfer type then it is a Adjustment, it is Intransit then this would physically move the items from one Inv-org to another inv-org

FOB: (Receipt/Shipment)

FOB is Fright on board, this defines the responsibility of the source inv-org is defined. If the FOB is receipt then Source inv-org is responsible till the items are received at the destination inv-org and the shipment is been paid by the source inv-org. if the FOB is Shipment then the source inv-org is responsible only till shipment of the items and later on it’s the responsibility of the destination inv-org and the shipment charges are also taken case by the destination inv-org.

Receipt Routing: (Direct/Standard/Inspection)

Next in the SHIPPING NETWORKS form navigate to the Tab Primary Accounts and the Other Accounts Tabs and enter the accounts as 01-000-1410-0000-000.

Once the shipping Network is been defined we can now transfer the Items from one Inv-org to another.

Before this we need to assign the items in both the Inv-Organizations say MIP and MIG.

Navigation: ITEMS->MASTER ITEM

Query for the item MIHITEM

Navigate to TOOLS->ORGANIZATION ASSIGNMENT

Select the Assignment (√) against the line MIG. This would assign the Item to MIG Inv-Org.

Then SAVE.

Now Navigate to TRANSLATIONS->INTER-ORGANIZATION TRANSFERS

Date: SYSDATE

To ORG: MM INV GOA

Here there would be an error as the Period for GOA Inventory Organization is not OPEN.

Change the Organization to MIG

OPEN the period in Inventory:

Navigate to ACCOUNTING CLOSE CYCLE-> INVENTORY ACCOUNTING PERIODS

Select OCT-12 Period

Click on Change Status

The period is now open.

Now we would be able to create a transaction.

Change the organization To MIP

Navigate to TRANSLATIONS->INTER-ORGANIZATION TRANSFERS

 

Date: SYSDATE

To ORG: MM INV GOA

Type: Intransit Shipment

Shipment Number: 600 (Number of the Shipment Number is unique in an Instance level)

Click on TRANSACTION LINES

Item: MIHITEM

SubInv: St3 (STORE 3)

To SubInv:  <Leave Blank>

Qty: 100

Then SAVE

Now we need to receive the Goods at GOA inv-Org.

Change the organization to MIG (MM INV GOA)

Now MIG is going to receive the items of QTY 100.

Navigate to TRANSACTIONS->RECEIVING->RECEIPTS

Navigate to Supplier and Internal Tab

Enter the Shipment number created earlier: 600

Sys shows the Supplier Name as MM INV PUNE

Click FIND.

This opens the Receipt Headers and Lines

In Line Enter the Receiving SubINV details as STORE 1

If we observe the Destination Type is INVENTORY, this is because the receipt routing is selected as DIRECT.

Then SAVE.

There would be transactions created for this receipt.

Now to check the Transaction that are created.

Navigate to TRANSACTIONS->RECEIVING->VIEW RECEIVING TRANSACTIONS

Enter the Shipping Number 600

Click on TRANSACTIONS

There would be two transaction records Receive and Delivery.

Now let us consider a case where the RECEIPT ROUTING is STANDARD in the Shipping Network Form (SETUP->ORGANIZATIONS->SHIPPING NETWORKS)

Next Navigate to TRANSLATIONS->INTER-ORGANIZATION TRANSFERS

Date: SYSDATE

To ORG: MM INV GOA

Type: Intransit Shipment

Shipment Number: 601 (Number of the Shipment Number is unique in an Instance level)

Click on TRANSACTION LINES

Item: MIHITEM

SubInv: St3 (STORE 3)

To SubInv : <Leave Blank>

Qty: 50

Then SAVE

Now we need to receive the Goods at GOA inv-Org.

Change the organization to MIG (MM INV GOA)

Now MIG is going to receive the items of QTY 50.

Navigate to TRANSACTIONS->RECEIVING->RECEIPTS

Navigate to Supplier and Internal Tab

Enter the Shipment number created earlier: 601

Sys shows the Supplier Name as MM INV PUNE

Click FIND.

This opens the Receipt Headers and Lines

In Line Enter the Receiving SubINV details as STORE 1

Location: MI MID PARK (This is enabled as the Routing Type is Standard)

If we observe the Destination Type is RECEIVING, this is because the receipt routing is selected as DIRECT.

Then SAVE.

There would be transactions created for this receipt.

Now to check the Transaction that is created.

Navigate to TRANSACTIONS->RECEIVING->VIEW RECEIVING TRANSACTIONS

Enter the Shipping Number 601

Click on TRANSACTIONS

 

Only one record is created as RECEIPT TRANSACTION (Items are received at the Receiving Point)

Now going further to Receive the Items at the Store a transaction is to be done at the Receiving Point.

Navigate to TRANSACTIONS->RECEIVING-> RECEIVING TRANSACTIONS

Enter the Shipment Number as 601

Sub Inv: STORE 3

Now Observe the Destination Type is changed to INVENTORY

Then SAVE.

There would be transactions created.

Now to check the Transaction that is created.

Navigate to TRANSACTIONS->RECEIVING->VIEW RECEIVING TRANSACTIONS

Enter the Shipping Number 601

Click on TRANSACTIONS

One more record is created as DELIVERY TRANSACTION.

Inter-Organization Transfers with INSPECTION

Change the organization to MIP

Now let us consider a case where the RECEIPT ROUTING is INSPECTION in the Shipping Network Form (SETUP->ORGANIZATIONS->SHIPPING NETWORKS)

Next Navigate to TRANSLATIONS->INTER-ORGANIZATION TRANSFERS

Date: SYSDATE

To ORG: MM INV GOA

Type: Intransit Shipment

Shipment Number: 644 (Number of the Shipment Number is unique in an Instance level)

Click on TRANSACTION LINES

Item: MIHITEM

Qty: 25

Then SAVE

Now we need to receive the Goods at GOA inv-Org.

Change the organization to MIG (MM INV GOA)

Now MIG is going to receive the items of QTY 25.

Navigate to TRANSACTIONS->RECEIVING->RECEIPTS

Navigate to Supplier and Internal Tab

Enter the Shipment number created earlier: 644

Sys shows the Supplier Name as MM INV PUNE

Click FIND.

Now the Destination Type is RECEIVING

Here we also enter the location as MM GOA

This will run a program “Receiving Transaction Program”

The goods are now at the Receiving Point

Now to perform any transaction at this point

 Navigate to TRANSACTIONS->RECEIVING-> RECEIVING TRANSACTIONS

Enter the Shipment Number as 644

Now the Destination Type is Still RECEIVING

Now we need to do inspection of the Items at the Receiving Point

Navigate to TRANSACTIONS->RECEIVING-> RECEIVING TRANSACTIONS

Enter the Shipment Number as 644

Click on INSPECT

Lines:

Accept Qty 23

Reject Qty 2

Then SAVE

Now the Destination Type is INSPECT

 Navigate to TRANSACTIONS->RECEIVING-> RECEIVING TRANSACTIONS

Enter the Shipment Number as 644

 Click on FIND

 Goto the line and update the location as STORE 1

 There would be transactions created for this receipt.

Now to check the Transaction that is created.

Navigate to TRANSACTIONS->RECEIVING->VIEW RECEIVING TRANSACTIONS

Enter the Shipping Number 644 that we created

Click on TRANSACTIONS

The transaction Types are

  • Receive
  • Accept
  • Delivery
  • Reject

Going further there would be a case where in while physically counting the items in the Goa location they have observed that there are 2 Item Qty missing (Instead of 350 there are only 348) when they have checked with the Pune location they found that the missing items are available at Pune location which was missed to be transferred to Goa. But the ONHAND Qty is updated with 350. So we need to adjust the ONHAND qty in both the location.

Navigate to the Shipping Network form

Navigation SETUP->ORGANIZATIONS->SHIPPING NETWORKS

 Add a line as below

From To Transfer Type FOB Receipt Routing
MIG(Goa Inv) MIP(Pune Inv) Direct

Transfer Type Direct for Adjustment entries.

As the adjust are created in Goa location the From org would be GOA and To Org would be PUNE.

For Adjustments we no need to mention the FOB and Receipt Routing

Enter the Primary Account and Other Account details as 01-00-1410-0000-000

Next Navigate to TRANSLATIONS->INTER-ORGANIZATION TRANSFERS

Type: Direct Organization Transfer

Line details

Item: MIHITEM

SubInventory: Store 1   (Mandatory to provide in case of Adjustment Entry)

To SubInventory: ST1    (Mandatory to provide in case of Adjustment Entry)

Qty: 2

Then SAVE

Account alias issue and receipt will be covered later.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: