IBM Support

How to Create Consignment Invoices

How To


Summary

Steps to create Consignment Invoices in Maximo 7.6

Steps

SETUP:

Create a storeroom in the Storerooms application (for example, "CONSIGNMENT" storeroom)

image 1001



STEPS:

1) Create a Consignment Item as follows:

Go to the Item Mas ter application and create a new item (for example, item CONS2).
Order Unit=EACH and Issue Unit=EACH

Select the "Add items to Storeroom" action.

Enter the following in the "Add Items to Storeroom" dialog box:

Consignment = checked
Storeroom = CONSIGNMENT
Issue cost type = FIFO (First In First Out)
Consignment Vendor = VOLVO
Invoice generation Type = CONSUMPTION

image 1002

Click OK.
Go to the Storerooms tab and verify that this item is added to the CONSIGNMENT storeroom.


image 1003

Change the item's Status to 'Active'.

"Roll new Status to Organizations and Inventory"  = checked
Click OK.

2) Add the Vendors for this Consignment Item in Inventory application:

Go to the Inventory application and the Reorder tab.
Set Last Price of the primary vendor "VOLVO" = $10.00
Add a couple more vendors.

Enter a value for the Last Price of the newly-added Vendors.
Save the record.


image 1004

Hyperlink to the Companies application.
Select the DATASTAR vendor and set Disqualified Vendor = checked
Select the SKF vendor and set Disqualified Vendor = checked

image 1005

NOTE: Disqualified Vendors are considered to be invalid Vendors and their Last Price value must not get picked up when you create Purchase Orders or Work Orders.
 

3) Purchase and receive this consignment item as follows:

Go to the Purchase Orders application and create a new PO record (for example, PO "CONS2").


image 1006

Vendor is the consignment vendor, "VOLVO".


image 1007

Go to the PO Lines tab.

POLine 1, Item=CONS2

Storeroom=CONSIGNMENT 

Quantity=10 

UnitCost=10

That is, the Cost value is brought across from the last price of VOLVO entered from the Reorder Details tab in the Inventory application.


image 1008

Approve the PO record.


image 1009

Go to the Receiving application and receive the Consignment Item. 

image 1010
 


 

4) Go to the Inventory application, find the consignment item "CONS2" and check data.


'LIFO / FIFO Costs' section:
The first one Unit Cost=10, Quantity=10

Inventory balances section:
Current balance = 10
Physical count = 10

image 1011



 

5) Consignment items can be issued to Work Orders and get consumed and Invoices are created

Go to the Work Order Tracking application and create a new Work Order record.
Change the Work Order's status to Approved.

Go to the Actuals tab and the Materials sub-tab.
Insert a new row:
Transaction Type = ISSUE
Line type = Item
Item = CONS2
Storeroom = CONSIGNMENT
Site = BEDFORD
Quantity = 1
Enter a GL Debit Account value.


image 1012

Save the record.

Go to the Invoices application.
Click the down arrow next to "Advanced Search" and select "More Search".

Select Type = CONSIGNMENT

Enter Item = CONS2


image 1013

Click the "Find" button.

A newly-created Consignment invoice is returned (for example, Invoice 1080 with Type = Consignment)

Setting Invoice generation Type = CONSUMPTION therefore automatically generates new Consignment Invoices when the Consignment items are consumed.



image 1014

Go to the invoice Lines tab.
The Consignment Item value is populated on the Invoice line.

image 1015


 

Additional Information

1) You can also choose to create Consignment Invoices manually by setting "Invoice generation Type" to "Manual" when you do 'Add Item to Storeroom' in the Item Mas ter application.

image 997

Specify Invoice Type = "Consignment" when you create Consignment Invoices manually.

image 998

Enter a Consignment Vendor in the Company field.

image 999

2) Another option is to set Invoice Generation Type = "FREQUENCY" when you add a Consignment Item to a Storeroom.

Invoice is generated based on the date of the next Invoice.

image 1000

Go to the Cron Task Setup application and select the ConsignmentInvoiceCronTask crontask.

Activating the ConsignmentInvoiceCronTask crontask automatically generates Consignment Invoices.

image 996

Document Location

Worldwide


[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

TPAEINVOICE

Document Information

More support for:
IBM Maximo Asset Management

Software version:
All Versions

Document number:
883254

Modified date:
01 December 2021

UID

ibm10883254

Manage My Notification Subscriptions