Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

George Moroses
/ Categories: Infor LX & BPCS Tips

Infor LX & BPCS Tip: Inventory Stocking Levels – Warehouses, Locations and Lots…Oh My!

The Infor LX system supports 4 levels of inventory. You can view summaries of stock at each level through the Material Status Inquiry program or through reports. Below are the 4 levels:

  • Item
  • Item + warehouse
  • Item + warehouse + location
  • Item + warehouse + location + lot

The lot number level and/or container of inventory can cross multiple warehouses and locations, for example, item + lot or item + lot + container. Locations exist within warehouses. There is no limit on the number of warehouses, locations, or lots that you can assign to an item.

Multiple Warehouses
You can assign as many warehouses as needed for any item. You can designate each warehouse as allocatable, allowed for order processing, or non-MRP, not used in the MRP netting logic. This allows your business to set up staging areas and quarantined warehouses. The warehouses can be physical or logical warehouses.

Multiple Locations
You can assign as many inventory locations as needed for any item. The location number is six characters long. This allows you to define sub-locations within a location, which can be an aisle, bin, or row.

The system stores item-warehouse combination inventory and allocation data. Optionally, sales history is available by item and warehouse in sales by units for the past twelve months. Total monetary amounts of sales by warehouse are also available in year-to-date, the last twelve months individually, and previous year-to-date.

Lot Inventory
On an item-by-item basis, the system requires the input of and performs tracking of lot numbers by inventory transaction. The system supports forward and backward lot traceability. The system provides inquiries and reports for the stock, allocation, and movement of inventory by lot. The system also automatically supports shelf life, expiration date, and reject data for each lot. The system automatically uses the expiration date in this allocation logic and MRP logic.

Previous Article Need Knowledgeable ERP Staff Quickly?
Next Article Tim Baker – Infor LX User Group’s Newest Board Member!
Print
20847 Rate this article:
4.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Understanding:

The Machine Master File

Do your machines have a fixed asset tag? The machine master file has a field called Fixed Asset.

BPCS does not use this field, so you can use this field for anything. You can record your fixed asset tag in this field and use the effective date. You can create a custom fixed asset list by using a DFU or Query program.

Understanding:

The Machine Master File


Machines are associated with a work center. For example, in the work center you may have multiple machines and each machine can have a unique machine ID. If there are several machines that perform the same function, they may operate at different speeds and efficiencies. Setting up the machine master can be a benefit for planning capacity and shop order throughput.
FirstLast

Tips: LN | Baan

Users can personalize sessions and apply special formatting to the data displayed in sessions. The personalizations and formatting settings that are specified by the users are stored on the LN server. Administrators can maintain these settings.

  • Session personalizations

    Users can personalize sessions in various ways. users can, for example, hide fields, change labels, customize the toolbar, and move fields to another tab. Administrators can maintain the personalizations defined by the users. For example, an administrator can export personalizations to an XML file, import personalizations from an XML file, and copy personalizations to another user, to a DEM role, or to a company number.

  • Report personalizations

    You can use the Report Designer (ttstppersrep) to personalize the layouts and style of reports, without modifying the standard reports or using an external reporting solution. The changes are stored as personalizations.

    You can also generate new reports that are based on a selection of fields from the application data model. These reports are generated in the extensibility package. You can personalize these reports in the Report Designer (ttstppersrep), or modify them in Infor LN Studio.

    For details, see the Infor LN Report Designer Development Guide
     
  • Conditional formatting

    users can define conditions to apply special formatting to the data displayed in LN sessions. The users can define multiple conditions per session and different types of formatting, such as a specific color for particular fields or rows, and a warning symbol for particular rows. Administrators can maintain the formatting settings specified by the users and can define system-wide formatting settings.

  • If Finances is implemented, we recommend that you do not delete order data in a fiscal year that has not yet been fully closed. This is because the GRINYA process uses information that would be deleted by this action. For best results, check whether the logistical balance for non-invoiced receipts matches the balance of the GRINYA accounts for the periods up to which you want to delete purchase order data.
  • When a purchase order is canceled, you can only delete the purchase order and the related tables. If only a purchase order line is canceled, the line can be deleted and archived.

You cannot delete a purchase order (line) if:

  • The linked warehouse order is closed but cannot be removed.
  • The purchase order is linked to a PCS project that is not yet archived. When the PCS project is archived, the purchase data is also archived and you can delete the purchase order.
  • A consignment replenishment order is not yet consumed completely.
  • The invoice is yet to be completely matched and approved.
  • The invoice amount is not yet inserted as turnover history.
  • The sales order or service order that is linked to the purchase order line, and for which an internal invoice must be sent from the purchase office to the sales office or service office, is not yet invoiced. In this case, you cannot delete the purchase order line before the sales order or service order is invoiced.

Categories