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

Infor LN & Baan Tips & Tricks for TECHNOLOGY: Adding a Timestamp to LN Standard Tables

Kathy Barthelt 0 1223 Article rating: 5.0

Table Timestamp Definitions (ttadv4136m000)

Use this session to define timestamps for Infor LN tables. A timestamp is an additional column that stores the date and time of the last change for each record.

Timestamps are utilized by features like the extraction logic of CPM Enterprise Analytics. They enable CPM to perform incremental data extractions. For example, CPM can use the timestamps to extract records that were changed during the last week in a weekly extraction process.

To Create Timestamps...

Infor LN & Baan Tips & Tricks for OPERATIONS: Absorbing Cost Items into Projects

Kathy Barthelt 0 1269 Article rating: 5.0

Operations: To absorb the cost of cost items into specific projects, you'll need to handle them as customized items. However, cost items cannot directly be defined as customized items. Customized items must be physical, either manufactured or purchased.

That said, it's still possible to absorb cost items into a project, although indirectly. Here's how:

  1. Set Up Ledger Account: First, create a new ledger account in session tfgld0508m000 and set the type to "PCS" (project) in the operations management integrations. This account will be used for matching and approving purchase orders for cost items.

  2. Create and Activate Projects: Ensure that the necessary projects are created and set to active status.

  3. Purchasing Cost Items...

Infor LN & Baan Tips & Tricks for FINANCE: Ledger Account Blocked Error

Kathy Barthelt 0 1136 Article rating: 5.0

When attempting to post to a ledger account, users may occasionally encounter an error indicating that the ledger account is blocked. To resolve this issue, navigate to the Chart of Accounts session (tfgld0508m000) and select the Miscellaneous tab. Once there, review the Blocking field. The available settings are:

  1. Free
  2. Blocked for manual input (integration transactions and other automatic transactions can be posted with this setting)
  3. Blocked for all purposes.

Infor News You Can Use: Infor Velocity Summit

October 1-2, 2024 (Las Vegas) & October 22-23, 2024 (Amsterdam)

Kathy Barthelt 0 869 Article rating: 5.0

Antiquated technology has no place in today’s fast-moving world

To succeed, you need to move with velocity—this means not just moving fast, but with purpose and precision. Velocity-powered businesses measure success by the value created at every turn, not just by speed.

At the Infor Velocity Summit, we’ll unveil our latest innovations across generative AI, process intelligence, ESG, and more, distilled from our work with 60,000 customers and built for your industry, from the ground up.

Discover how possible happens>  https://www.infor.com/events/infor-velocity-summit

The Far-Reaching Impact of Disconnected Data: From Operations to the Executive Suite

Kathy Barthelt 0 1375 Article rating: 5.0

The Impact of Disconnected Data Across Your Organization

Operations Impact:

  • The warehouse manager’s spreadsheet tracking inventory levels and supplier shipments is disconnected from your ERP.
  • Dealer Portal Email orders need to be manually entered into the system.

Finance Impact:

  • Budgeting data is maintained in isolated spreadsheets, unlinked to quotes or sales figures in your ERP.
  • Open purchase orders and invoices need manual matching and approval, creating inefficiencies.

Technology Impact:

  • A large number of reports must be generated outside the ERP for teams to stay "up to date."
  • Valuable time is spent exporting ERP data for analysis in external data cubes.

Executive Impact:

  • Compiling an accurate picture of inventory and financial health is a struggle when data comes from multiple sources.
  • Lack of visibility to inventory shortages results in losing customers due to stockouts or delays.

Disconnected data refers to information stored separately from your main business system, such as your ERP. While this data holds value, the lack of integration creates challenges across your entire organization—often more than expected...

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Role-Based Security

George Moroses 0 1156 Article rating: 5.0

Role-Based Security introduces Role type profiles and allows combining the use of Role profiles with the traditional LX User type security profile functionality. The new Role type profile can be defined to allow or deny access to All Products, Attention Key, Products, Programs, and Transaction Effects. Facility, Warehouse, and Company securities are still defined solely by the User profile settings and are not affected by the assignment of a Role. Where applicable, the Role authority is displayed alongside the User authority on the security profile maintenance screens making it easy to see where there are differences in authority between the User and the assigned Roles. 

When Users are assigned to Roles, security access in LX becomes a combination of authorities granted or denied by the Role, plus any User Exceptions. User Exceptions override authorities set by the Roles. A User can also be assigned to more than one Role.

RSS
12345678910Last

Theme picker

Tips:  LX | BPCS | M3

Understanding: How many hours remain in total and at each operation?

First let’s look at some key BPCS Master File data starting with the routing file.

How many routing steps (operations) are set up that reflect how the product is produced in the factory? If you take a short cut and set up only one operation for the entire process, then you will limit the information seen on the SO inquiry program. Set up the operation steps to reflect what you want to report back to from the factory floor.

Will each of the routing steps run in one work center, or in different work centers? To keep it simple you may want to set up work centers as departments. For example:

  • Assembly
  • Machine
  • Paint
  • Etc.

For each operation setup consider how you have set up the following:

  • Load Codes – for example a code 5 is used if reporting both setup time and run labor time. These codes are maintained in the work center file
  • Basis Code – typical codes are P for pieces per hour,  3 is used for hours per 1,000 pieces
  • Setup hours – if you set them up, you also want to report them
  • Run hours – Direct Labor
  • Machine hours

How you set up th

Came across an article online from Lauber CFO’s, and thought I would share. Here is a checklist for things to consider in order to finish out the year and help you plan for 2016:

 

  • Are your accounting records up to date so that you can make a projection of how the current year will turn out?
  • Are all account reconciliations currently up to date to facilitate the closing of the books after year end?
  • Are there accounts receivable that should be reserved for or written off prior to the end of the year?
  • If your business carries inventory, do you need to plan a physical count as of the end of the year?
  • Has depreciation on your fixed assets been recorded during the year? Have you considered depreciation on current year additions?
  • Have all new asset purchases and bank loans been recorded on your books?
  • Are there any liabilities, for example, pending legal actions or warranty issues, which will need to be recorded prior to year end? 
  • Do you have a plan in place to properly “cut-off” revenue at year end to properly match revenue and expense?
  • Will there be bonuses, profit sharing contributions or discretionary retirement plan contributions paid prior to the end of the year? How will these payments affect cash f
First119120121122124126127128Last

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
23403 Rate this article:
5.0
Crossroads RMC

Crossroads RMCCrossroads RMC

Other posts by Crossroads RMC

Theme picker

Contact author

x

Categories