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

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.

Previous Article And Then There Were None - Short Staffed?
Next Article Manufacturing vs. Finance: Who wins?
Print
23246 Rate this article:
5.0
Crossroads RMC

Crossroads RMCCrossroads RMC

Other posts by Crossroads RMC

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Understanding: The quantities required, finished and remaining at the operation and in total for the Shop Order

The shop order may require 1,000 pieces but only 950 are reported as finished in total for the shop order. The quantity required is what is planned on the SO and it may be a higher number than what is finished, factoring in that there can be scrap. If a 1,000 pieces are required to be produced, and there is always is scrap of 10 pieces, then plan for scheduling a quantity of 1,010.

The quantity finished for the end item is what is reported in the inventory application with a production order receipt transaction. At the operation level, if the quantity is reported at the operation, there will be a value in the PCS Complete field on the operation detail screen showing the pieces completed through that operation.

If you want to get a handle on the difference between the required quantity and the finished quantity, you may want to look into reporting quantities at the operation level as well as examining how scrap is controlled and reported.

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

Now let’s look at what information is being supplied from the shop floor.

It’s not uncommon for transaction reporting to be captured manually on the shop packet that was issued to the factory floor when the SO was released.

The big question is, is anything done with the data? Is it collected and keyed to a  spreadsheet and not shared, or is the transaction data keyed to SFC600? If it is being keyed, ask how often and by whom? Some companies use alternative methods to capture transaction data that do not require batch keying via a keyboard.

Not a lot of data is required to be keyed to SFC600 in order for the SO Inquiry to be useful. The data that should be reported for the transaction process is as follows:

  • The type of hours being reported – machine, run labor, setup labor
  • If reporting setup and run labor you want an employee clock number
  • The shop order and the operation that is being reported
  • Is the operation complete
  • How many good were produced at this operation
  • How many hours – the numbers of hours are critical. Do the employees estimate how many hours they worked, or do they track actual time started and stopped in order to calculate the actual number of hours.

Based on what is captured and how often will have an impact on the SO inquiry screen. Understanding the batch times as to when the transactions are keyed will provide you with the window as to the SO status at that point in time. Or, are they keyed as they happen in a near real time fashion so that you can have a more current view of the factory floor.

First118119120121123125126127Last

Theme picker

Tips: LN | Baan

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...

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...

12345678910Last

Theme picker

Categories