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

IDF: Defining the Attributes for a New Object

Anthony Etzel 0 25224 Article rating: 5.0

Attributes are the fields you define in your System i file.

You can begin by building your attribute list in Integrator by synchronizing the object with the host. This process reads the file definition from the System i and builds your list of attributes. The synchronize process will automatically run and read the definitions for the first occurrence of this file name within the library list. You can repeat this process manually multiple times if you change the file definition on the host by using the ‘Synchronize with Host’ option. However, the synchronization process will not recognize changed field names.

Non on key field attributes: The integrator requires a unique key for each object. If the host file already has a key, the synchronization process will automatically identify fields as part of the key as well as add a sequence number to multiple key parts. If the file does not have a unique key, you must either create a keyed logical file or identify the key manually. Key fields are the default sort order for all list views for an object.

Why do you need OTTO? Let’s let our customers tell you…

George Moroses 0 21563 Article rating: 5.0

“Our priorities change daily. It’s important to manage the priorities instead of having someone here in the office constantly expediting. We don’t want to run MRP every day, that would just introduce nervousness, all plans and priorities are likely to change and the flood of recommendations would be unmanageable. We run MRP once a week and rely on OTTO to track the constantly shifting priorities day-to-day.”  
Production & Inventory Control Manager, Top U.S. Crane Manufacturer

Learn More About OTTO

Crossroads RMC is proud to announce the release of the following dashboard views that come STANDARD with the LX Analytics Dashboard

George Moroses 0 23572 Article rating: 5.0

Standard Analytics Dashboard Views: 

  • Sales Bookings (ECH)
  • Accounts Receivable (RAR)
  • Accounts Payable (APH)
  • Planned Orders (KFP)
  • Purchasing (HPH)
  • Shop Order Material (FMA)
  • Shop Order Operations (FOD)
  • CEA
  • Order Booking (ECS)
  • Labor History (FLT)
  • Sales History (SIH)
  • Material Status (IIM/ILI)

Click Here to Learn More

If you can't see everything that happens on your shop floor, you are at a competitive disadvantage

Anthony Etzel 0 24934 Article rating: 5.0

If you’re not able to see everything that happens on your shop floor in real-time, you’re at a HUGE competitive disadvantage! Your competitors are running MES. 

Crossroads MES software provides:

  • A user-friendly interface and an easy exchange of information between the shop floor users and your ERP database. 
  • Planners the ability to schedule work to a specific machine or work area. In addition, it allows for work to be re-sequenced and split for better flexibility in scheduling shop floor activities.
  • Factory workers with the ability to receive the work schedule electronically as well as interacting with it by reporting transactional activity.
  • The ability to electronically display Drawing, Process Instructions, and Quality Instructions so you can eliminate, or minimize, the need for some of the paper on the shop floor.
  • The ability to pass shop floor transactional activity to dashboard displays as well as the ERP system. 

Click here to learn more about Crossroads MES 

or Contact Anthony Etzel today to learn more.

Infor LN & Baan Tip of the Week: Job Groups in LN

Kathy Barthelt 0 40985 Article rating: 5.0

In a scenario where performing job A depends on the result of job B, it is hard to decide at what time job A must be scheduled, and how long job B runs. To handle dependent jobs, you can now create a job group. Use the Job Groups (ttaad5140m000) session to create a job group. A job group has a name, with the same characteristics as a job name, and a description. The Status and User of the job group are handled automatically.

After creating the job group, the jobs are added to the group, approximately in the order the jobs must be performed. The first job in the group (with the lowest Group Number) determines the handling of the whole job group, such as execution date and whether the job group is being repeated. If the job group is not repeating, the job group and all non-repeating jobs in the job group are deleted when the job group has run.

The dependencies of the jobs in the job group are also determined. A job in the job group can only depend on a job in the same job group with a lower job number.

You can use the specific options in the Job Groups (ttaad5140m000 andttams5640m000) sessions to change the status of the job group. The job group statuses have the same meaning as the status of the jobs and the same status changes are allowed.

Note: Job groups are only handled by the BSE service Job Scheduler Service.

A/P Payment Update in LX 8.3.4

Anthony Etzel 0 35604 Article rating: 5.0

A/P Payment Update in LX 8.3.4. ACP660B creates a file using a layout required by the bank; the file informs the bank to pay invoices. These conditions must be met to create the file:

  • FIM is an installed product in SYS821  ­
  • The user is authorized to FIM in SYS600 ­
  • The company is active in FIMCOMIT in SYS105  ­
  • The payment type is in BONPAYTP (SYS105)

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

Anthony Etzel 0 32612 Article rating: 5.0

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.

Crossroads RMC is Proud to Announce Product Certification for Baan IV to Avalara!

Kathy Barthelt 0 33706 Article rating: 5.0

Crossroads RMC is pleased to announce that our Baan IV integration to AvaTax has officially been certified by Avalara! This means that all Baan IV, Baan V and Infor LN customers now have an automated solution for sales and use tax!

AvaTax provides sales and use tax calculations in real time including rate determination, returning filing, remittance and exemption certificate management. 


Want to learn more? Please contact Kathy Barthelt for more details
RSS
First5657585961636465Last

Theme picker

Tips:  LX | BPCS | M3

TECHNOLOGY: Facility Security Ranges

Previously, a user could 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 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 completes the cost transfer process.

FINANCE: Expiration Date for Quotes and RMAs

A Cancel-by-Date has been added to the Quote Header and RMA Header panels. This optional field can limit how long a quote or authorization to return items for credit is valid.  

For quotes, this enhancement provides an optional end date for the quote. For RMAs, it provides an optional date by which the customer must return the items to receive the credit listed on the RMA.

The Cancel-By-Date prints on the Order Acknowledgement and RMA Acknowledgement to inform the customer of this important limitation to the quote or return authorization. 

An Order Entry user cannot copy the quote to create a new order if the Cancel By Date has caused the quote to expire.

OPERATIONS: Default Split Salesperson to Customer Orders

Sales commissions are based on combinations of the Primary, Split, and Line-Level salesperson and the commission codes defined for the customer and item. You can now define the Split Salesperson in the same master files as the Primary Salesperson. While the Primary Salesperson is mandatory, the Split Salesperson is optional. It defaults during Order Create using the identical hierarchy as Primary Salesperson. Using Split Salesperson provides more flexibility in the calculation of sales commissions. The ability to define a default Split Salesperson improves the accuracy of sales commission qualification and calculation and reduces maintenance and adjustments necessitated by corrections.

Previously, a user could 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 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 completes the cost transfer process.

12345678910Last

Theme picker

Tips: LN | Baan

Beyond the Four Walls—Achieving Upstream and Downstream Inventory Visibility

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

When an enterprise has many suppliers, dealers/distributors, and customers spread out across the globe, it becomes important that it gains better visibility into inventory outside of its direct ownership and control, on both the supply and demand side. On the supply side, the company has outstanding POs and needs reliable estimates of when those will ship, as well as early indications whenever there will be delays in shipment. Once shipped, updates on the estimated time of arrival (ETA) are important, particularly when there are delays.

This external visibility is even more important during times of disruption. Early visibility into disruptions in supply or rapid changes in demand is key to providing the intelligence to drive agility. By responding earlier, faster, and with more accurate intelligence, a company has more options, makes smarter decisions, and avoids catastrophes.

How do you get that visibility? Here are some options…

• EDI—EDI can provide POs (EDI 850) for orders, ASNs (EDI 856) to communicate what has been shipped, Inventory Inquiry/Advice (EDI 846) with updates to on-hand inventory at various holding locations, including status (on hand, committed, on order, etc.), forecasts (e.g. EDI 830 planning schedule with release), shipping schedules, and other useful information about inventory in transit or at rest. EDI can be challenging for a smaller company to implement, especially without the right partner and solution. For this reason, not all suppliers or customers will necessarily have EDI. In those cases, an alternate approach, such as a portal, is needed to serve the remaining non-EDI trading partners.

• Supplier and Customer Portals—Portals provide a way for suppliers or customers who do not have EDI capabilities to update inventory, production, and order status. This requires some training and communications so that the trading partners use the system consistently, properly, and in a timely manner. (Portals to ERP for Infor LN & Baan Only)

• External Inventory Locations/Accounts—Some ERP systems allow supplier or customer stocking locations to be set up within the solution, so those locations look like another distribution center or plant, but with the inventory in those locations not being owned by the company. Personnel at the supplier or customer can then be given an account within the ERP system to update their inventory information. The account may provide additional functionality to the supplier or customer as well. If the trading partner actively uses the system to run a part of their operations, the data are more likely to be timely and accurate.

• API Integration—Trading partners may provide inventory data via an API in the ERP system.

• Planning Solutions—provides the ability to proactively manage the entire customer order backlog from top to bottom. It begins monitoring orders as soon as they’re booked and identifies and prioritizes those critical events that must happen every day so they can be managed and get orders produced and shipped on time. (OTTO - On Time Orders for Infor LX, BPCS & M3 Only)

Now more than ever, good inventory management, with accurate inventory data, is a core element of success for manufacturers and wholesale distributors. Having the right products, in the right place, at the right time, in the right quantities—and doing so at a low cost—drives profitability, cash flow, customer loyalty, and success for a company. This can be a difficult balancing act, especially when demand is volatile and supply disruptions occur. It can be achieved with the right inventory strategy, process disciplines, risk management, and capable systems in place. Excellence in inventory management, with the right systems, is key to enabling businesses to survive in challenging times and thrive in the market during good times.

Not sure where to start? Crossroads RMC consultants have expertise with all of the options listed above and can help you realize optimal inventory management, regardless of the size of your organization. 800.762.2077, solutions@crossroadsrmc.com, or ask us to contact you.

Print
25221 Rate this article:
5.0
Crossroads RMC

Crossroads RMCCrossroads RMC

Other posts by Crossroads RMC

Theme picker

Contact author

x

Categories