• Visit Us on Facebook
  • Visit Us on Twitter
  • Link with Us on LinkedIn
800.762.2077

Infor LX & BPCS Tip of the Week: LX 8.4 Database

The database in LX 8.4 has undergone a significant change from previous versions. The database has been created using SQL DDL language instead of the old DDS language. The newer format allows for LX to take better advantage of advances in IBM database technologies as they move forward. Additionally, LX will be better able to make changes to tables (aka files) in the future without causing very large MR explosions to replace all programs that use a specific table. To ease the impact of this significant change, the LX tables (aka physical files) have new names that are the same as the previous version file names but with a “P” at the end, for example IIM is now IIMP. The old file names now belong to SQL views that looks just like the tables. This change made it easier to upgrade all the LX programs without changing every reference to every file. Many of the logical files remain although some have been replaced by SQL indexes to improve performance.

Tuesday, July 09, 2019/Author: Anthony Etzel/Number of views (89)/Comments (0)/ Article rating: 5.0
Categories: BPCS & LX Tips
Tags:

Infor LX & BPCS Tip of the Week: Partial Search in Item Description List

Previously, if a user performed a partial search for an item by using a double byte language, no matches were found. Regardless of whether the MLS module is used, this enhancement allows a user to use a double byte language to perform partial or full item description searches. This enhancement resolves an issue with partial searches on screens where the Item Master Lookup (WINIIM) screen is used, such as Material Status Inquiry, INV300D-01, Item Master Selection INV100D1-01, Facility Planning Selection, MRP140D1-01, and Purchasing Inquiry, PUR300D1).

The user selects the F4 prompt from these screens to open the Item Description List. In the prompt window, the user specifies option 10 to perform a partial or full search on an item description.

Tuesday, June 25, 2019/Author: Anthony Etzel/Number of views (164)/Comments (0)/ Article rating: 5.0
Categories: BPCS & LX Tips
Tags:

Infor LX & BPCS Tip of the Week: Inventory Transfers for Outside Operations

This enhancement allows users who currently perform outside operation processing in shop floor programs to manage the transfer of components used in the outside operations to the vendor’s designated warehouse.

This enhancement provides modified and new INV511D screens and adds new logic to allow the user to identify all shop orders that have components linked to outside operations or to identify all the components linked to an outside operation on a shop order. The shop orders can be filtered by either a date range or by a specific vendor.

Inventory Transfers for Outside Operations enhances the management of external operations by providing screens that simplify the selection of the shop orders or items to transfer to a vendor.

Transfers to the vendor warehouse are performed in the Inventory Transfers, INV511D, screens.

Monday, June 10, 2019/Author: Anthony Etzel/Number of views (343)/Comments (1)/ Article rating: 5.0
Categories: BPCS & LX Tips
Tags:

Infor LX / BPCS Tip of the Week: Optional Authority to Maintain Reason Codes

This enhancement allows users to update Reason Code Maintenance, INV140D1, for Transaction Effects that they are not authorized to in any other programs. A new system parameter was added to Inventory Parameters, INV820D. The enhancement allows users who do not actually perform transactions in Infor LX to maintain the reason codes for the transactions.

Tuesday, May 28, 2019/Author: Anthony Etzel/Number of views (516)/Comments (0)/ Article rating: 5.0
Categories: BPCS & LX Tips
Tags:

BPCS / LX Tip of the Week: Inventory Period Balance Freeze

This enhancement provides clients the ability to store the opening/ending on hand balance for each Inventory period at the Item (IIM), Warehouse/Item (IWI) and Lot/Location (ILI) levels. Infor LX clients can back date inventory transactions into the immediate previously closed period, and thus update what was saved as the opening/ending balance throughout the current open period. 

Tracking the opening/ending/period balance for each inventory period can give users insights into the levels of inventory for each item, item/warehouse and item/warehouse/lot/location combination.

Tuesday, May 14, 2019/Author: Anthony Etzel/Number of views (622)/Comments (1)/ Article rating: 5.0
Categories: BPCS & LX Tips
Tags:

BPCS/LX Tip of the Week: Purchase Order Receive All Processing

With this enhancement the Purchase Receipts screens are optionally shown with the quantity and weight fields populated with the open value on the purchase order. The screens are now populated with the open value and if the open value is the same as the value received, the user can simply accept the line. The Receive All field on the PUR550D1-01 screen determines whether the receipt lines are populated with the open value. A system parameter controls the Receive All default value but the default value can be overridden.  

If this option is selected, the user does not have to enter the open quantity or weight. If the purchase order receipt has many lines, this option saves time and prevents errors.

Tuesday, April 30, 2019/Author: Anthony Etzel/Number of views (807)/Comments (0)/ Article rating: 5.0
Categories: BPCS & LX Tips
Tags:

BPCS / LX Tip of the Week: Purchase Order Print Security Validation

This enhancement allows users to restrict access to purchase order print programs. The purchase order print programs were updated to provide security validation for the user who selects the purchase orders to print. The security validation is controlled by the PO Print Security Validation flag on the Purchasing System Parameters screen, PUR820D-04. This enhancement gives users the option to restrict access to purchase order print programs, providing additional security at the company and warehouse levels.

Tuesday, April 16, 2019/Author: Anthony Etzel/Number of views (902)/Comments (0)/ Article rating: 5.0
Categories: BPCS & LX Tips
Tags:

BPCS / LX Tip of the Week: Facility Security Ranges

Previously, a user was able to complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings that were set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and complete the cost transfer process. After the user enters a range in the CST920 screen that is outside of their authority set up in SYS600, a message is displayed that explains they are not authorized to all facilities. Before the enhancement was applied, a user could enter any range in CST920 and it would transfer the costs, regardless of their security level. This enhancement provides security in CST920 that prevents incorrect cost transfers from being processed. 

Wednesday, April 03, 2019/Author: Anthony Etzel/Number of views (1227)/Comments (0)/ Article rating: 5.0
Categories: BPCS & LX Tips
Tags:
RSS
12345678910 Last