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 Tip: Can You Backflush An Item If Estimated Quantity is Zero?

Kathy Barthelt 0 65080 Article rating: 5.0

Yes, you can backflush an item with an estimated quantity = 0.00 if you haven't already backflushed the order. For example, you had an order with one component, you reported the quantity at the operation or order level and ran the backflush. Now you realize you need another component added. In this example, the order has already been backflushed, so if you were to add a second component, run backflushing, nothing would happen.

Backflushing is based on the 'quantity to backflush' in report operations or report orders complete. When the quantity is backflushed....

Increase Production by 10-20% - It's Simple!

Developed for Infor LX, BPCS, Infor LN, Baan & Infor M3

Crossroads RMC 0 28138 Article rating: 5.0

Studies show that merely displaying current production data to your workers via a dashboard increases production.

Improve the performance of your shop floor with Analytics Dashboard for Infor LX, BPCS, Infor LN, Baan, and Infor M3. It's simple to use and configure without programming knowledge. Display performance metrics in a grid, graph, chart, or any way that makes sense. learn more>

Infor LX & BPCS Manufacturing Tip: Production Register Listing

George Moroses 0 28392 Article rating: 5.0

Use the Production Register Listing screen, JIT610D1-01, to print an edit list of the labor tickets that you added or updated. Use this report to see the data to post before you actually perform the update. After you print the edit list, you can go back to Production Reporting (JIT600) and change the data before you post the batch. The program assigns a number to each production report that you posted in JIT600. You can use JIT600 to reference the production report that you want to update. Access: Specify Post on Production Reporting, JIT600D1-01.

Infor LN & Baan Tip: Remove Posted Payment/Direct Debit Batches

Kathy Barthelt 0 60648 Article rating: 5.0

The functionality of session Remove Posted payment batches tfcmg1259m000 and Remove posted Direct Debit batches tfcmg4259m000 is explained below:

1.These 2 sessions can be used to removed already posted payment/direct debit batches that have been processed through CMG Module. After the batches are changed to removed status they can be deleted also.

2. Only a superuser, defined in the Payment Authorizations (tfcmg1100m000) can delete the payment/direct debit batch.

3....

Understanding Taxability Rules Is Key To Sales Tax Compliance

Avalara for Infor LN | Baan | Infor LX | BPCS

Crossroads RMC 0 30512 Article rating: 5.0

Product taxability may seem straightforward because there are generally only two options: taxable or exempt. Yet that seemingly simple contrast fails to truly capture the inherent complexity of sales tax compliance. In fact, it’s a multistep process that starts with determining where a business has sales tax nexus. Knowing whether the products or services one sells are taxable or exempt is critical to the compliance process, from start to finish.

The good news is that you don’t have to be a tax expert, nor do you need to stay up on the latest tax rules and regulations in each state or country where you do business. Avalara handles all of this for you and Crossroads RMC provides the integration to Infor LN, Infor LX, Baan, and BPCS to make staying compliant a no-brainer.

Want to learn more?...

Infor LX & BPCS Finance Tip: Items without costs, CST101D

George Moroses 0 26921 Article rating: 5.0

This program generates an uncosted items listing for the specified facility and cost set. You can use this report as an exception listing to identify those items that are currently maintained at zero cost or new items that require entry prior to cost rollup in Cost Set Rollup, CST500.

If a facility-specific component cost does not exist for a parent being rolled up, zero cost is rolled up for the component. When a new parent item is being rolled up for the first time, the audit report for Cost Rollup, CST500, displays a warning wherever a component cost is zero. Rolling up the parent cost again does not display a message for zero component costs.

Access: Menu CST01

Infor LN & Baan: What are your production orders telling you?

Kathy Barthelt 0 29140 Article rating: 5.0

Measure what you want to improve.

Six simple words, but put together they convey a powerful concept that can transform manufacturing companies. It’s a basic concept that’s hard to argue with: Collect data, see where the data leads you, and make changes that have a positive impact on the data. Repeat often.

If your company is manufacturing a product, you’re more than likely creating manufacturing variances. These variances tell managers where the company is not performing to the standards that were created and agreed to by those responsible in the Engineering, Finance, or Production Departments. There is almost a 100% chance you are creating either favorable or unfavorable manufacturing variances and, quite frankly, none of the variances will ever be favorable because the company is either over-costing or under-costing the production parts.

The data is all there within your ERP system… or at least it should be… provided that you are not tracking production information outside of your ERP system in a spreadsheet.

Analyzing your production orders can help you track down:

Infor LN & Baan Tip: MPS planned vs. MRP planned

Kathy Barthelt 0 63353 Article rating: 3.8

What items should be MPS planned, and what items should be MRP planned…

Master Scheduled Items are those items that are finished goods, or service items, that receive their requirements either specifically from Independent demand, or both Dependent and Independent demand.

  • Independent Demand is...
First3738394042444546Last

Tips:  LX | BPCS | M3

Item Facility Master has a new attribute to define the override inspection days lead time CICP.ICINSD.

  • When an item facility has a defined override inspection days lead time, that value will be used instead of the system parameter inspection days lead time.

MRP exception report, MRP200B
Purchase planning report, PUR285B
Purchase order / Requisition maintenance, PUR500D3
Purchase order consolidation / release, PUR640B1
Vendor splits, PUR653B

This enhancement improved the subfile utilized in MRP320D Master Schedule Detail Inquiry -SCR001 by expanding the subfile with data rather than clearing the subfile as user pages. This change provides full support for the WebTop 4.8 Grid decorator.

This enhancement updated the approach used to populate the subfile to allow a deployed Webtop Grid to function correctly. There is no visible or user-impacted change to the way the program functions.

This enhancement provides improved functionality and full support of a Webtop grid applied to the subfile.

Last

Tips: LN | Baan

George Moroses

Infor LX & BPCS Tip: PowerLink

PowerLink is a Windows-based client for end-users within the Infor Development Framework (IDF). PowerLink allows exports/imports from/to the ERP database, but how much do you really know about it? Here is some helpful information about PowerLink.​

Why does PowerLink sometimes fail to export all records?
There's not a finite amount of records that PowerLink can export. However, PowerLink export was never intended to handle large volumes of data. It was designed as a quick snapshot of a fairly small subset and a simple view of the user's PowerLink card. 

What is the maximum amount of data that can be exported?
The maximum number of records is only limited by the system resource like memory, etc. When the system runs out of resources, an OutOfMemory error should occur. In previous testings, we have exported +1 million records, although the size of records differs greatly between business objects, the total size of the data could be an issue. For larger volumes of data, customers should investigate other tools such as the iSeries Access "Data Transfer from iSeries Server" feature to download directly to Excel.

How do I know if the size of the data is an issue?
1. When exporting to an external file (text, HTML) then importing to Excel: You can easily check the output (text, HTML) to see if the intermediate output has all the records. This can be done by visual inspection or through the use of column totals. Simply compare between the output and what you see in PowerLink. If the exported file has all the records, then the problem is definitely Excel.
2. When exporting to clipboard, then copy/paste to Excel: There is a clipboard export size limit that is controlled through client preferences. Check the exported data in the clipboard, and see if it contains all the records or only partial records due to the size limitation set in client preferences. If limited, change the client preferences using Customize from the Main browser > Preferences > Miscellaneous tab > Limit Clipboard Export, and try the export again. If the clipboard has all the records the problem is in Excel, which we don't have jurisdiction over.

Suggestions for improving the export process. 

  1. Reduce the number of columns seen in the view. This will serve to reduce the data being exported and may increase the number of records that can be exported. 
     
  2. Reduce the complexity of the view. If the view has one column that lives on a related object, then it has to build SQL behind the scenes to get that related record. If all of the columns come from a single business object, then the processing will be significantly faster.
     
  3. Export to HTML, which can be opened directly by Excel, Access, and many other programs. This reduces the processing of the export formatting because PowerLink needs only to put begin and end tags around each data element. This will also preserve column alignment when Excel or other programs open the file.
     
  4. Unless you are exporting a fairly small volume of data, export to a file, not clipboard. Clipboard is held in memory until the entire view is read, and records are written to the file as they are retrieved.
     

 Also see KB 1357068 for more information about testing your view.

Print
49512 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories