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

George Moroses
/ Categories: Infor LX & BPCS Tips

Infor LX & BPCS Tip: How Items Are Selected for a Cycle Count

The Cycle Counting Sub-System Within Inventory Management

The system uses the following information as the basis for cycle counting selection:

  • Cycle Counts/Year: The system calculates the time between cycle counts based on your entry in this Item Master file field for each item (optional).
  • Last Cycle Count Date: This date is in the Location Inventory file, ILI, if you use locations, or in the Warehouse Inventory file, IWI, if you don't.

The system adds the time between cycle counts (calculated as described above) to this date. If the result is less than or equal to today's date, the item is selected for cycle counting. If it is greater than today's date, the item is not selected, it is not due yet for cycle counting.

There is another special condition that causes an item to be selected for cycle counting. If the ILI/IWI record of the item has a Y in the Cycle Flag field, the item is selected automatically. This flag indicates that the item's on-hand balance has gone to a negative value sometime since the last cycle count. That applies even if the value is not negative at selection time. The programs that can set this field are INV500D, INV510, and BIL540.

You can also limit the items selected for counting by specifying limits of the item numbers or warehouses to be searched.

Previous Article Mitigating Risk With Your Infor ERP
Next Article Infor LN & Baan Tip: Project Status Options
Print
15076 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

This method of inventory tracking is slow, and prone to human error.

Putting a simple barcode system in place speeds up the process of tracking inventory movements, reduces the likelihood of mistakes, and creates a recorded history of the who/what/where that can provide valuable insight to those who make critical business decisions for your business.

Not sure where to start? Contact us and we’d be happy to help you take the first step.

 

Optimize Your Manufacturing Today!

Congratulations! You bought that shiny, new car! It has all the features you can possibly want and goes a million miles an hour. It can take you anywhere your heart desires…….but you rely on a manual scooter to get you around. You know, the kind you had when you were a kid…BEFORE you could drive…before you could afford the BMW. Make sense? Uh... no.

You’d never do this, right? So, why are you doing this with the ERP system that runs your business? Why are you relying on spreadsheets and separate little Access databases to record and store the information that is the most critical to your business when you have an ERP system that is meant for this? Why continue to plod along at a snail's pace when you have the tools to take your business to the next level?

Your ERP system is your BMW. Use it. See what it can do for you. Think you’ve used it to its potential? Unlikely. We’ve helped customers breathe new life into their EXISTING ERP version all by unlocking functionality for them that was already there and ready to use! We’ve also helped by offering add-ons to the ERP that can make your productivity skyrocket.

Ask us how. We’ve got an extra set of keys to the BMW in case you lost yours.

Optimize Your Manufacturing Today!

First8485868789919293Last

Theme picker

Tips: LN | Baan

All actions required for converting, validating, matching, and posting electronically received bank statements can be performed within a single session:

  • Bank Statement Workbench (tfcmg5610m100)
  • Bank Statement (tfcmg5610m000)

Alternatively, you can use the sequence of electronic bank statement sessions outlined below.

Steps to Process Electronic Bank Statements:

12345678910Last

Theme picker

Categories