Skip to end of metadata
Go to start of metadata

INTRODUCTION TO MATERIAL MANAGEMENT

The Material Management Rules comprise Products and Price Lists, which were discussed in the relevant chapters (the Products Chapter and the Pricing Chapter).

Other Material Management aspects are:

  • Warehouse
  • Shipments (receipts)
  • Inventory Movements
  • Physical Inventory
  • Internal Use Inventory
  • Production
  • Customer Shipment
  • Replenishment (Demand)
  • Available to Promise
  • Valuation Costing

THE WAREHOUSE

The Warehouse is the physical location where your Items are stored. You can set up as many Warehouses as you need. They do not need to separate physical buildings as you can have multiple  'virtual' warehouses in a single physical building. Warehouses can have one or more locators. Each locator has five predefined dimensions:

  • Aisle
  • Bay
  • Row
  • Position
  • Bin

The last two segments, Position and Bin, are optional. However, if you enter a value for Bin, you must enter a value for Position. In other words, you cannot have a locator with a Bin and not a Position.

The Warehouse is owned by one Organization, i.e. it is a logical entity. Inventory moves can be carried out from any locator to any locator in any Warehouse. There is no overhead for moving items across Warehouse boundaries.

You create different Warehouses for different purposes. If one location of your enterprise trades with consignment goods, for example, you could set up a Consignment Warehouse for that specific location.

In a simple setup, you receive and ship your items directly from one Warehouse that includes multiple locators.


 
The advantage of the simple setup is that there is no need for product movements and the products are immediately available upon processing the Material Receipt.

In a complex setup you create a Warehouse for receipts, a Warehouse for storage and a Warehouse for shipment.


 
This setup requires more inventory movements. The benefit is that the QA and Shipping can be done in a controlled environment, since you might want to prevent a product from becoming available immediately after its receipt.

Note: Once you have defined a Warehouse, you cannot modify the Organization that owns the Warehouse in this window. This can be accomplished using the Warehouse Organization utility process.

For additional information on the Warehouse Organization utility process, refer to the UtilitiesChapter.

MATERIAL MOVEMENTS

External Movements are Receipts and Shipments. A Receipt is the document for a Product that you receive while a Shipment is the document for a Product you send out.

Internal Movements include Inventory Moves, Physical Inventory and 'Production' (or Assembly) moves. Inventory Moves are moves for a specific reason (e.g. Movement of Products from a QA Warehouse to a Storage Warehouse). Physical Inventory moves are carried out when the system count of products differs from the actual or physical count of products. This in generally known as "shrinkage." Movements are represented by a change of the physical or virtual location. Production moves reflect the movements done when you produce or assemble products on the basis of a Bill of Materials.

Physical Inventory

The following steps are to be carried out:

  • Create a Count List
  • Print it for manual checking
  • Enter the differences
  • Process Inventory Count

If there are delays during the physical counting transactions (which very often happens), Compiere allows you to Update Counts. Compiere posts the differences between the Quantity Count and the Quantity Book. This allows for a delay between the actual count and the processing of the inventory count so your business can continue.

Internal Use Inventory

The Internal Use Inventory process allows you to move items out of stock for use within your company. Unlike Physical Inventory where you count the quantity of an item, in Internal Use Inventory you indicate the quantity that you will be removing from Inventory.

Production or Assembly

The following steps are to be carried out:

  • Create a Stored Bill of Materials (BOM)
  • Create a Production Plan
  • Create Production Lines
  • View and Modify, if necessary the Production Lines
  • Post the Production

There may be situations where one of the production lines must be changed (e.g. replace a specific part on a one time basis). You can change the Production lines directly and process. There is no need to modify the existing Bill of Materials or create a new one.

Inventory Valuation

The Inventory Valuation Report is based on the Price List. It lists the PO price and calculates the Quantity on the basis of the Valuation Date. Thus Compiere allows you to do current valuations as well as historical valuations. For more complex Valuations you have the possibility to export your data to an Excel spreadsheet.

PHYSICAL INVENTORY

To create, change, or delete Stock via Physical Inventory, open the Physical Inventory window by clicking on Physical Inventory from the Main Menu.

The window allows you to generate inventory count lists. These counts can then be processed to update the actual inventory with the new counts.


 
Use the Inventory Count tab to define the parameters for a manual count and adjustment of inventory. Click the New Record button. Enter a Document Number or allow the system to assign one.

Enter a Description.

The Warehouse indicates where the stock is to be counted.

The Perpetual Inventory is not used at this time.

The Movement Date defaults to the current date but may be updated if necessary.

Select a Document Type for this Physical Inventory. The standard one is Material Physical Inventory but you may add others if necessary.

For additional information on Document Types, refer to the Implementation and Basic Settings Chapter.

In the Reference area, select a Project and Campaign (if enabled) to be used for this Physical Inventory.

Note: These fields or other fields may display here based on your Accounting Schema.

For additional information on Accounting Schemas, refer to the Performance Analysis Chapter.

The Approval Amount field is not used at this time.

Click the Create Inventory Count List button after saving the record to generate your inventory count lines.

Select a Locator by clicking on the icon in the field. A dialog window will display. Click OK to continue.

You may also leave the Locator blank to use all locators.

Select a Locator Key (full or partial value) to create an Inventory Count List for selected Locators.

Select a Product Key (full or partial value) to create an Inventory Count List for selected Products.

Select a Product Category and an Inventory Quantity. Possible selections for the latter are: not 0, < 0, > 0 and = 0.

Select a Set Inventory Count to option of On Hand Qty or Zero.

Select the Delete old/existing records check box if you want to delete any records from previous executions of the Create Inventory Count List

You may run the Create Inventory Count List multiple times to get different subsets of products to count. When you run it multiple times do not select the Delete old/existing records check box. If this check box is selected the existing records will be deleted. Leaving this check box deselected will cause the Inventory Count List to be appended with the new records.

The records selected must meet all of the criteria entered.

Click OK to display your Inventory Count List. If the process completes successfully, the bottom line displays how many records were inserted.

To print a list for the manual check you first need to open the Inventory Count Line tab and display the Data Grid.

Create a Report by clicking on the Report button on the toolbar.

The Report displays.

Print the Report by clicking on the Print button on the toolbar. Now you do your manual check (your actual physical inventory) and compare the report with the actual inventory. Note down changes on the report and enter these changes in the Inventory Count Line tab. Switch to single record view by selecting the data grid toggle tool bar button.

Enter the new Quantity count, which can easily be compared with the Quantity book count. Compiere will post the difference between the 2 values (in this case -2). This allows you business to continue (Customer Shipments and Material Receipts) even if there is a delay between the counting and the processing of the count.

When looking at the grid view we saw that there were two records for Fertilizer. That is because the Fertilizer is stored in the Warehouse with an Instance Attribute (as seen in the single record view above). When a product is stored with Instance Attributes you will receive one row for each unique attribute for that product.

For more information on Product Attributes, refer to the ProductsChapter.

If desired you can enter a Description for each line.

Select an Inventory Type of Inventory Difference or Charge. If you select Inventory Difference the loss or gain of inventory is booked to the Warehouse Difference Account defined for this Accounting Schema. If you select Charge a field for selecting a specific Charge is displayed. This allows you to account for specific differences in inventory due to shrinkage or damage. It also allows you to move items out of inventory for internal use and account for them properly.

For more information on Charges, refer to the UtilitiesChapter.

The Attribute tab is a read only tab which will show the Inventory broken down by its receipts into inventory. This will appear only if you have selected the Advanced Tab option in Preferences.

Save your entries before opening another line. Enter all your values and then go back to the Inventory Count window.

If you want to continue your physical inventory the next day, you can do so. You can collect your counts and enter them using the Inventory Count Line tab at any time. Another option is to process the counts you have done at that time. Then go back to the Inventory Count tab and click on the Update Quantity button. This button recopies the info in the system for inventory to the lines. The correct amounts that were processed will now be reflected in those counts.

If you have completed the physical inventory, click on the Process Inventory Count Button to update your inventory. The movement will also appear in the Product window, Transactions tab so you have an audit of all movements of the product.

If the process completed successfully, the bottom line displays how many records were updated. The Not posted button appears. Click on it and confirm the dialog window that displays.

Your application server must be running for your accounting entries to be created and posted.

Physical Inventory- Accounting Consequences

When Inventory is posted, the Organization used in the accounting transactions is the Organization defined for the Physical inventory Document. If, however, a Charge is selected in the Physical Inventory Line, the Organization of the Physical Inventory Line is used in the accounting transactions. Any required intercompany entries will be created.

The following outlines the accounting transactions generated for Physical Inventory. The account used for Product Asset is defined in the Product window. The account used for Charge is defined in the Charge window. The account used for Warehouse Differences is defined in the Warehouse window.

Physical Inventory (reduction in stock to a Charge account)

    DR: Charge Account     

           CR: Product Asset

Physical Inventory (increase in stock to a Charge account)

    DR: Product Asset        

           CR: Charge Account

Physical Inventory (reduction in stock to a Warehouse Difference)

    DR: Warehouse Differences       

           CR: Product Asset

Physical Inventory (increase in stock to a Warehouse Difference)

    DR: Product Asset        

           CR: Warehouse Differences

CYCLE COUNTING

Cycle counting is the process of locking down of a select few locators in a warehouse for a short period of time in the day to perform physical counts of products in those locators. Once products in those locators are counted and reconciled, they are unlocked for material movements immediately. It is done on a daily basis for different products and locators. It helps ensure that the inventory that physically exists in the facility is reflected correctly in the system in order to maintain inventory accuracy. It allows the warehouse to function with minimal disruption and at the same time maintain high levels of inventory accuracy. It ensures that after a period of time all products in the facility gets counted on an ongoing basis so that the highest levels of inventory accuracy is continually maintained.

Setup for Cycle Counting 

To perform Cycle Counting you must define the document type which will be used to create the transactions.

Open the Document Type window by clicking on Document Type from the Main Menu. The icon in front of the Document Type menu item indicates that it is a window. 

 
 
Enter a Name, Description and Print Text.  The Document Base Type should be "Material Physical Inventory".
 
Next define the Analysis Criteria

Analysis criteria are the rules on which the products in the warehouse are sorted and assigned ranks. Three rules have been seeded in the Compiere system. They are:

  • Product velocity by dollar value sold
  • Product velocity by number of units sold
  • Product/Component of highest dollar value on price list 

User can also define custom rules using the "ABC Rank Analysis Criteria" window. You must provide the class name which implements the rule. The implementation class should implement the Interface "RankAnalysisInterface.Java"
To define a custom rule open the ABC Rank Analysis Criteria window by clicking on ABC Rank Analysis Criteria from the Main Menu.

Enter a Name and Description of the analysis criteria.

Enter the full Class Name of the Class which implements this rule.

Check the Based on Price List check box if the rule uses the price list for evaluation.

Next define the Sort Criteria.

The Sort Criteria are the rules on which products are sorted within the rank. This is used in deciding which product should be counted first within a rank. Three rules have been seeded for Sort criteria in the Compiere system. They are:

  • Least On-hand Quantity
  • Earliest Ship Date
  • Highest Price 

User can also define custom rules for sort criteria using the "ABC Rank Sort Criteria" window. You must provide the class name which implements the rule. The implementation class should implement the Interface "RankSortInterface.Java"

To define a custom rule open the ABC Rank Sort Criteria window by clicking on ABC Rank Sort Criteria from the Main Menu.

Enter a Name and Description of the analysis criteria.

Enter the full Class Name of the Class which implements this rule.

Check the Based on Price List check box if the rule uses the price list for evaluation.

Now define the Analysis Group

The Analysis Group is a set of properties which are used when generating Cycle Count requests. They are defined for a given warehouse.

To define an Analysis Group open the ABC Analysis Group window by clicking on ABC Analysis Group from the Main Menu.
Select the Warehouse you are counting and the Document Type which will be used to generate the Cycle Count documents.

The Days for Analysis represents the time period for which transactions will be considered when evaluating the ABC Rank Analysis Rules.  This value can be over-ridden when executing the 'Generate ABC Rank Assignment' process.

Analysis Groups have a set a Ranks into which the products in a warehouse are classified,  Ranks for an Analysis Group are defined in the 'ABC Rank' tab.
Enter a unique Name to the Rank.
The Sequence defines the relative importance of the Rank. The lower the Sequence number higher is the importance of the rank.

The Percentage defines the proportion of products in the warehouse which should be part of this Rank. In an analysis group the sum of all the ranks should be 100 percent.

Rank Sort Criteria is the rule on which products are sorted within this rank. If the Rank Sort Criteria is based on price list, the user has to enter a valid price list which will be used while evaluating the rule.

Cycle Count Frequency defines how often the products in this rank should be counted. E.g in the above example, products in this rank "A" should be counted twice every week.

After entering ABC ranks, user has to validate the analysis Group. For this "Verify analysis Group" button is provided. This checks the integrity of the analysis group on a number of parameters, including ensuring that the percentages total 100. Once the analysis group is verified it is available for use in cycle counting.

Warehouse Working Days

You should define the number of working days for the warehouse.  Open the Warehouse window by clicking on Warehouse & Locators from the Main Menu.
 For the UK Distribution Center, 300 Working Days have been defined.

You are now able to generate the Rank Assignment for your products.  The 'Generate ABC Rank Assignment' process ranks the products in the warehouse based on the selected Analysis Rule.
 
Enter the Organization for which the process should be run.

Enter the Warehouse within the selected organization for which the ABC Assignment will be created.

Choose a valid and active Analysis Group for the chosen warehouse which will be used for generating the ABC Assignment.

Choose a Rank Analysis Rule based on which the ABC Assignment will be generated.

Optionally enter the Days for Analysis. If not entered, then the value defined in the analysis group will be used.

Enter a Price List Version if the Rank Analysis is based on price list.

Once the process has completed successfully, the products in the warehouse are assigned rank based on Analysis Group and the Analysis Rule chosen. The product assignment can be viewed from the "ABC Product Assignment" tab of  "ABC Analysis group" window.

You can delete a product assignment or create new assignment manually from this window. One product can not be assigned to more than one Rank inside an analysis group.
The Generate Cycle Count process is run periodically (ideally everyday) to generate a list of product-locator combination inside a warehouse. This list indicates the products that should be counted in different locators today. This process once run successfully can't be run again on the same day for the analysis group. There should be a gap of at least one day between two runs of this process for an analysis group.

Enter the Organization for which the process will be run

Enter the Warehouse in the selected organization for which the process will be run.

Enter the Analysis Group of the selected warehouse for which the process will be run.

Check  the Consolidate to one Document check box if user wants to generate one cycle count document for all product-locator combinations. If left unchecked, one document is created for each product-locator combination.

Check the Lock Document check box to lock the product-locator combination for all the material transactions.

Once the process completes successfully, it generates Cycle Count document(s). This document lists all the product-locator combinations which should be counted today. This window functions the same as the Physical Inventory window described in a previous section.
 
While the counting is occurring, you have the option to manually lock/unlock any product-locator combination. Once the document has been completed all the locks are released automatically and the Date Last Counted field in the ABC Product Assignment tab is updated.


INTERNAL USE INVENTORY

Open the Internal Use Inventory window by clicking on Internal Use Inventory from the Main Menu.

This window allows you to move items out of stock that will be used by the company as opposed to being sold to a customer.

 
Enter a Document No or allow the system to assign one.

Enter a Description if desired.

Select the Warehouse from which the inventory will be taken.

Enter Movement Date for the document.

Select a Document Type for this Internal use Inventory.

Optionally enter a Project and Campaign.

The Approval Amount field is not used at this time.

When you have completed entering in the required data, Save the record and select the Internal Use Line tab to enter the items to be moved.

Enter a Line No or use the system default value.

Enter a Locator or accept the default.

Select a Product which will be removed from Inventory.

Select an Attribute Set Instance, if appropriate.

Enter a Description if desired.

Enter the Internal Use Qty for this line.

Select the Charge account to be used when accounting for this reduction of Inventory.

Save the record.

Continue entering Internal Use Lines until all items necessary have been entered.

For additional information on Attribute Set Instance, refer to the Products Chapter.

For additional information on Charges, refer to the Utilities Chapter.

Click on the Internal Use tab to process this document.

Select the Complete button to process this Internal Use Inventory.

The Document Status is now marked "Completed" and this document may now be posted.

Internal Use Inventory- Accounting Consequences

The following outlines the accounting transactions generated for Internal Use Inventory. The account used for Product Asset is defined in the Product window. The account used for Charge is defined in the Charge window.

Physical Inventory (reduction in stock to a Charge account)

    DR: Charge Account     

           CR: Product Asset

INVENTORY MOVES

Open the Inventory Move window by clicking on Inventory Move from the Main Menu.

This window allows you to move inventory from one locator or warehouse to another. After the appropriate lines are entered selecting the Process Movements button will adjust the inventory.


 
The Move Tab defines and identifies the movement of an item or items in inventory. Click on the New Record button to create a Movement. Enter the Name and a Description if you like.

Enter a Movement Date and Document Type.

The In Transit and Approved check box, Approval Amount, and Date received fields will be used in a future release.

Enter a Project and Campaign if desired for referencing this Inventory Move. These fields will display only if they have been selected for your Accounting Schema.

For additional information on the Accounting Schema, refer to the Performance Analysis Chapter.

When you have completed entering the necessary data, click the "Save" button and continue.

Switch to the Move Line tab to enter the items to be moved.

Enter the Product, Attribute Set Instance, (if appropriate) the Movement Quantity, and the Locator To which the product is to be moved.

The Scrapped Quantity, Target Quantity, and Confirmed Quantity will be updated based on the values entered in the Confirmation for this Inventory Move. Confirmations are optional documents that may be utilized. For additional information on Confirmations, refer to the Purchasing chapter.

Now switch to the Move tab and click on the Process Movements button to adjust your inventory.

If the process completed successfully, the bottom line displays how many records were updated.

To print a document for this Inventory Move, select the Document Print button on the tool bar.

The Not posted button appears if the process was successful. Click on it and confirm the dialog window that displays. Your application server must be running for your accounting entries to be created and posted.

Confirmation with Inventory Moves

Compiere provides you with the ability to require a Confirmation with Inventory Moves. The process is similar to Shipment and Material Receipt Confirmations.

As noted above, each Inventory Move requires a Document Type. It is the Document Type that will determine if a Confirmation is required.

Move to the Document Type field and select Zoom. This will direct you to the Document Type record for Material Movement w/confirmation.

For this Document Type we have selected the In Transit check box.

This is the indicator that a Confirmation is required.

In the Inventory Move Line we specify the product to move and the Locator to move it from and to.

Return to the "Move" tab and select the 'Complete' button.

Up to this point, there is no difference in the processing steps as we saw without a Confirmation. When the Process is completed, note the Status area and the message in the message window that displays.

The Document Status is In Progress as the Confirmation must be completed.

The Message text area indicates that a Move Confirmation was created and displays the document number.

Next, open the Move Confirmation by clicking on Move Confirmation from the Main Menu.

This document was created by the 'Complete' process in Inventory Move and has a Document Status of Drafted.

Select the Line tab to confirm the movement quantities.

The document has set the Confirmed Quantity to the Target Quantity (in this case the Movement Quantity). You may leave it as it is or update the Scrapped Quantity if appropriate.

If you have entered a Scrapped Quantity, a Physical Inventory record is created for the target (to) warehouse.

Return to the Confirmation tab to complete the Confirmation.

Select the Complete button to complete this Confirmation. When the process has completed, the Document Status is updated.

The Description is updated with the User who completed this Confirmation and Date that the Confirmation was completed.

The Document Status is now marked "Completed."

Now, return to the Inventory Move record and select the "Complete" button to complete the Inventory Move.

The Document Status is now marked "Completed," as the Move has been confirmed. This document may now be posted.

Inventory Move- Accounting Consequences

The following outlines the accounting transactions generated for Inventory Move. The account used for Product Asset is defined in the Product window. There will only be a net effect on the accounts if you have included Warehouse as one of your Account Schema Elements and you are moving product between Warehouses

Inventory Move

    DR: Product Asset        

           CR: Product Asset

PRODUCTION


Production is generally used to create kits or baskets of products that do not require any resources.  For example, you may sell chairs, tables and sun umbrellas as separate products and also sell a Patio Set.  These Patio Sets are simply 4 chairs, 1 table and 1 umbrella.  There is no manufacturing or assembly required.  There is also little or no delay from when the individual items are moved as single items from stock and moved back into stock as the finished Bill of Materials.  If there were a delay or some type of resource or other asset were required (e.g. machine time or machinist) then it would more appropriate to use the Manufacturing Module. Manufacturing 3.6 is discussed in a separate chapter.

Open the Production window by clicking on Production from the Main Menu. The icon in front of the Production menu item indicates that it is a window.

The Production window defines the plan and inventory movements that occur when a product is created from a bill of materials.


 
The Production Header tab defines the Name of the production and the Movement Date.

Enter the Name for the Production Plan, and a Description if you like. The Movement Date defaults to the current date. Save the screen and switch to the Production Plan tab.

Enter the Product (must be a BOM) and the Production Quantity (i.e. the quantities of end products to produce). Enter a Locator to indicate where the final product will be stored. Save it and go back to the Production Header tab to create Production Lines. Click on the Create/Post Production button. If the Production Lines are not present then the process will create the lines. If there are Production Lines then the process will post the production. You can enforce the quantity to be on stock by selecting the Product quantity must be on stock check box. Click OK to create the production lines.

The bottom line of the window shows you if the process completed successfully or not.

You can then go to the Production Line tab and make any changes (i.e. if you need to change one of the parts of a BOM on a one time basis).

Note that all Optional items in the BOM will be included in the Production. Also, if Alternative Groups are used any items from these groups that are not to be used should be deleted.

Once the production is complete, select the Create/Post Production button again to create the inventory movements (parts out of inventory, new product in).

If the process completed successfully, the bottom line displays how many records were updated. The Not posted button appears. Click on it and confirm the dialog window that displays. Your application server must be running for your accounting entries to be created and posted.

Production- Accounting Consequences

The following outlines the accounting transactions generated for Production. The account used for Product Asset is defined in the Product window.

Production

    DR: Product Asset (for Product BOM produced)  

           CR: Product Asset (one line for each Product used in Production)

REPLENISHMENT

Replenishment provides a method for indicating those stocked products that should be re-ordered. Products that are evaluated as part of the Replenishment Process must be stocked (define in Product Tab); they must have one and only one Current Vendor (defined in Purchasing Tab) and they must have a Replenishment type of To Maximum or When below Minimum (defined in Replenishment Tab). The Source of the Replenishment may be a Vendor (when creating a Purchase Order) or a source Warehouse (when creating an Inventory Move).

For additional information on these settings, refer to the Products Chapter.

To run the Replenishment Report and optionally create a Requisition, Purchase Order, or Inventory Move, start by opening the Replenishment Report window from the Main Menu. The icon in front of the Replenishment Report menu item indicates that it is a report.

Click the Start button to initiate the Replenishment Report.

Select a Warehouse to use for this Replenishment Report. The Warehouse will determine which products are interrogated (based on the Replenishment Rule) and which stock levels will be used to determine the current levels (including On Hand, On Order and Reserved Quantities).

Select a Business Partner to limit the Replenishment Report to a specific Current Vendor.

Select a Create value of Requisition, Purchase Order or Inventory Move if you want the process to create a document(s) based on the Replenishment Report.

If you have selected a value in Create, select the desired Document Type to be created.

Select the OK button to generate the Replenishment Report and optionally any Document(s) indicated.

The Replenishment Report displays the Product, Current Vendor, Maximum and Minimum Quantities, Minimum Order Qty, On Hand and Reserved Qty, as well as the Qty to Order, Source Warehouse, and the Replenishment Rule. The Quantity to Order is determined based on the Replenishment Rule, the stock that is On Hand, the stock that is Reserved and the stock that is On Order. In addition, it also used the Pack Quantity and Minimum Order Quantity defined for the Product / Vendor.

For example, assume that we have 22 Hoes on Hand, 2 are reserved and none are On Order. There is a Replenishment Rule of to Maximum and the Maximum Quantity is 25. The Minimum Order Quantity is 1 and the Pack Quantity is 1. The Replenishment Report would recommend ordering 5 Hoes. If, the Pack Quantity had been 2 and the Minimum Order Quantity was 2 then the Replenishment Report would recommend ordering 6 Hoes.

If the process had also requested a Requisition or Inventory Move be created then a single document would be created representing the results of the Replenishment Report.

Note: Inventory Move documents can only be created when the Replenishment Rule defined for the Product / Warehouse defines another Warehouse as its source.

If the process had also requested a Purchase Order be created then 3 Purchase Orders would have been created, one for each unique Vendor.

REPORTING ON MATERIAL MANAGEMENT

Compiere provides a number of predefined reports for analyzing the movement of Products. Like all reports in Compiere, you can modify the layout and content to meet your needs.

Material Management Reports

The available reports on Material Management Rules can be found in the Menu under Material Management.

Transaction Detail: This report displays the details of a product(s) and their Movement. You select a Movement Type (e.g. Shipment, Material Receipt, Physical Inventory), to and from Movement Date, Product Category, Product, Locator, Lot and Lot No. This report will also display Attribute and Lot data. For more information on Attribute Sets, refer to the Products Chapter.

Product Transaction Value: This report displays pricing information for a Product(s). You may select a "To and From" Movement Date, Product Category, Product and Business Partner. The report will list the Last PO Price, List Price and PO Price for each product.

Product Transaction Summary: This report displays product movements summarized by Product, Movement Date and Invoice Type. You may select a "To and From" Movement Date, Warehouse, Movement Type (e.g. Shipment, Material Receipt, Physical Inventory). The report lists Products, Warehouse, Movement Date, Type, and Quantity.

Product Movement Transaction Detail: This report displays the movement details to,from and within a warehouse. You may select a Movement Type, To and From Movement Date, Warehouse and Product Category. 

Product Movement Summary: This report displays the summary of various movement transactions for a given product and locator combination by date. You may select a Movement Type, To and From Movement Date, Warehouse and Product. 

Replenish Report: This report displays all Products that should be ordered based on the Replenishment Rules defined for each product. Use this report when creating your Purchase Orders. You may select a Warehouse and Business Partner. The report will list the Product, Current Vendor, Maximum and Minimum Quantities, Minimum Order Qty, On Hand and Reserved Qty, as well as the Qty to Order. If a Product has a Replenishment rule of Manual it will not appear on this report. You may also generate a Requisition, Purchase Order, or Inventory Move for the products on this report. For more information on Product Replenishment, refer to the Products Chapter.

Storage Detail: This report displays Storage information for a Product(s). You may select a Warehouse, Locator, Product Category, Product, Lot, and Lot No. The report will list details including the Available, Ordered, and Reserved Qty along with Lot, Serial No, and Attribute Instance data.

Inventory Valuation Report: This report lists Products, their On Hand Quantities and Value based on the Valuation Date. You may select a Warehouse, Currency, Price List, Version, and Valuation Date. The valuation is calculated using the On Hand Quantity and the List Price from the selected Price List Version.

Product Costing Report: This report displays Product Cost details. You may select an Accounting Schema, Product Category, and Product. The report will list the Current Cost Price, Future Cost Price, Last Invoice Price, and Last PO Price. Note that all Average Cost data will not be accurate until Average Costing Functionality is fully implemented.

Vendor Selection: This report displays those Products with multiple suppliers (Vendors).There is no parameter for this report. The report lists all Products that have more than one Vendor defined along with PO Price, Last PO Price, Minimum Order Qty, Pack Qty, etc. It also indicates which Vendor is the current Vendor. This report should be used when determining who to purchase a Product from.

For more information on customizing reports, refer to the Info and Reporting Chapter.

Labels
  • None