This has come up as an issue during various stages of warehouse material movements – transfers, outbounds, shipments. We have seen it right up to 10.4. The inventory structure table (whinr150) becomes a problem. The error points to that table, but users are lost as to how to fix it.

In the session Units by Unit Set many companies let the field Storage default to Yes. If the UOM is not intended to be used in inventory then that setting should be No. 

If an item is purchased in UOM different from the inventory unit and the setting is Yes then LN adds a record in that UOM to the inventory structure table. It is that record that causes problem later.

The session has an option to change the value of the storage field. Specific > Convert Use for Storage. This option works both ways and will correct all inventory in the UOM range. 

Should a user receive an error that references inventory structure table then the solution is to check that session to see if an odd UOM exists in it. If so use the Convert Use for Storage to correct the problem.

If functionality such as Commissions, Rebates, or Contracts are enabled in the parameters, LN checks this functionality during transactions, even if you did not specify anything for these concepts. Therefore, if you do not use certain functionality within LN, to improve performance, disable the corresponding parameter.

Optimize Your Manufacturing Today!

Avalara Announces 41 Newly-Certified Integrations Into Business Application

December 20, 2018 05:00 AM Eastern Standard Time

You’ve got an ERP system, so everything should be real-time and everyone should have access to information in real-time, right? RIGHT?!

Why not? Why are there spreadsheets, and separate Access databases off to the side?

Data loses value over time, so why not give everyone up to date, accurate information all the time? Take a look at those silos of information and see how you can eliminate them. Your business will benefit greatly as a result.

Optimize Your Manufacturing Today!

You’ve got an ERP system, so everything should be real-time and everyone should have access to information in real-time, right? RIGHT?!

Why not? Why are there spreadsheets, and separate Access databases off to the side?

Data loses value over time, so why not give everyone up to date, accurate information all the time? Take a look at those silos of information and see how you can eliminate them. Your business will benefit greatly as a result.

Optimize Your Manufacturing Today!

When is the last time you took a hard look at your production lines?

• How are you moving product through the facility?
• Do you have work instructions / drawings available where needed?
• Do you have frequently used inventory available at the line?
• Where are the bottlenecks?
• Are your processes simplified?

Taking a hard look at your processes and procedures may reveal some interesting results. Don’t assume that everyone is doing things the same way. Some may be superstars, and others may need some mentoring. Some processes may be outdated and costing you time and money, while others are extremely efficient. One area of the business may benefit from how others operate. Take the time to review and analyze your findings. Your company may benefit greatly as a result.

Optimize Your Manufacturing Today!

When is the last time you took a hard look at your production lines?

• How are you moving product through the facility?
• Do you have work instructions / drawings available where needed?
• Do you have frequently used inventory available at the line?
• Where are the bottlenecks?
• Are your processes simplified?

Taking a hard look at your processes and procedures may reveal some interesting results. Don’t assume that everyone is doing things the same way. Some may be superstars, and others may need some mentoring. Some processes may be outdated and costing you time and money, while others are extremely efficient. One area of the business may benefit from how others operate. Take the time to review and analyze your findings. Your company may benefit greatly as a result.

Optimize Your Manufacturing Today!

Such lofty goals you had when you implemented your ERP system. It was going to be like pressing the “Easy Button”…  then it wasn’t.

What happened? In some cases, decisions were made to implement the system “just like we used to run our old system”. Great idea? Not so much. Your business changes, and your business software needs to change as well.

Are you using the ERP system, but everything seems cumbersome and takes more time than its worth? 

Ask yourself these questions:

• Have you looked at streamlining your processes?
• Can you automate a step or two and eliminate some manual keying?
• Can you add barcoding to avoid keying in some information altogether?
• How about automating the printing of some reports?

Now is the time to sit down and really review the steps required to complete the task and think out of the box a bit. Soon you can develop your own streamlined process to get the job done quickly and efficiently.

Optimize Your Manufacturing Today!