Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Resources Infor ERP Tips & News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Subscribe to newsletter

Infor LX & BPCS Tip of the Week: Journal Upload – EGLi

George Moroses 0 44712 Article rating: 5.0

EGLi users who maintain journal entries in a Microsoft Excel spreadsheet can use this utility to upload journal entries to EGLi. The Journal Upload installation program adds an Add-Ins tab to Microsoft Excel. This tab includes options to connect to the server where EGLi is installed and to open a spreadsheet template to use for manual journal entry. When the spreadsheet is complete, the Add-Ins tab is used to upload the spreadsheet.

To install Journal Upload:

  1.  The Power-Link Installation page has links to the Client installation programs and a link to download and install the Journal Upload utility. To access this page, use this link with your own values for system and NetLinkport: http://system:NetLinkport/Installs/ClientInstall/Install.html  where system is the server where IDF is installed and NetLinkport is the Net-Link port, typically 36001
     
  2. On the Power-Link Installation page, click the link provided to download and install EGLi Journal Upload.
     
  3. Follow the screen prompts to complete the installation on your PC.
     
  4. To verify the installation, open an Excel spreadsheet. Confirm that the Add-Ins tab is on the spreadsheet. 


See the Infor Enterprise General Ledger for System i Journal Upload Installation and Infor LX Configuration Guide.

Read more

Infor LN & Baan Tip: Open Transactions Check – LN 10.7

Kathy Barthelt 0 19025 Article rating: 5.0

When closing a project, users were informed about open transactions blocking the closure process. To proactively check on open transactions, the Show Open Transactions option has been introduced in the Project Status (tppdm6107s000) session. With this option, issues can be resolved before changing the status.

Read more

Infor LX & BPCS Tip of the Week: LX 8.4 Enhancement – Company Security for ACR510

George Moroses 0 11023 Article rating: 5.0

This enhancement provides LX Company Security to Invoice Maintenance, ACR510. Only users authorized to the invoice company can view or maintain invoices.

User must be authorized to ACR as a product or ACR510 as an individual program in Security Master Maintenance, SYS600. Additionally, ACR510-01, displays all records, but if the user tries to revise or display a transaction record for a company the user is not authorized to, this error message is displayed: “User is not authorized to the transaction company.”

Read more

Infor LX & BPCS Tip of the Week: Item Deletion Option in IDF Enterprise Items

George Moroses 0 14074 Article rating: 5.0

Previously, users were unable to delete items in IDF Enterprise Items when they have inventory balances or the item is connected to ancillary records, such as sales history records. This feature added in LX 8.4 provides the ability to delete an item when sales history records are found but all sales history activity is zero.

When the user attempts to delete an item in IDF Enterprise Items that is tied to a sales history record, the panel displays a message that the item cannot be deleted. The user can then run the Delete Validation Report to determine which records are tied to this item that prevents the validation. If the item no longer has manufacturing activity but had old sales history, the item can be deleted.

Read more

Infor LN & Baan Tip of the Week: In Transit Inventory Report – LN 10.7

Kathy Barthelt 0 21229 Article rating: 5.0

A new In-Transit Inventory report can be printed in the Print In-Transit Inventory (whinr1410m300) session. The report provides an overview of company inventory that is on the move and not stored in a warehouse. This concerns only inventory that is transferred from one warehouse to another. Items that are shipped to, for example, customers or projects, or items that are issued to production lines or service departments are excluded.

The report shows item inventory....

Read more
RSS
First3738394042444546Last

Theme picker

Tips:  LX | BPCS | M3

Previously, Material Requirements Planning (MRP) preferred practices meant that the component's due date was the same as the parent's shop order release date. Because MRP trends have changed, the preference for this due date is the day before the release date of the parent. Although Infor LX already has this functionality in Shop Order Maintenance programs (SFC500), users could not change how due dates were determined for lower-level shop orders in Multi-Level Shop Order Release, SFC530D.

This enhancement provides an additional parameter for Multi-Level Shop Order Release. This parameter allows the user to change how the due date of the child components is determined. The Multi-Level Shop Order Release, SFC5302, has a new parameter for shop orders. The Due Date of Children = Release Date of Prent (Due Date of Children) field allows the user to set the due date determined for multi-level shop orders.

Read more

This feature uses different exchange rates in the user's inventory processes by using new macros in Post Inventory to G/L, INV920D. INV920 used macros limited by the Override Exchange Rate parameter set on the book in Book Definition, CEA105D3. If the Override Exchange rate parameter is set to No, the macro uses the Rate Type of the Book. If the Override Exchange parameter is set to Yes, the macro uses the Rate Type of the Order Company. This enhancement provides macros that use the Rate Type of the Order Company. This enhancement provides macros that use the Rate Type of the Warehouse Company, Order Company, or the Book regardless of the Override Exchange Rate parameter in the Book.

Read more
12345678910Last

Theme picker

Tips: LN | Baan

Kathy Barthelt
/ Categories: Infor LN & Baan Tips, Operations

Infor LN & Baan Materials Tips: Serialized and Lot Controlled Items

Serial and Lot are additional characteristics/properties of Items that can be used to uniquely or collectively identify and track the item along with its Item code. Any Item can be made as Serialized and/or Lot controlled by choosing options "Serialized" and "Lot Controlled" in Items-General session under traceability section on the Details tab.

Further in Items-Warehousing data under the Identification tab, you can enable "Lot Tracking", "Lot in Inventory", "Serial Tracking" and "Serial in Inventory" which enables tracking of the Items. You can also define if the Item is "Serial/Lot not in inventory" then where you want to record the serial and lot details in the transactions like "Direct Delivery", "Receipt", "Transfer", "Register during As-Built, Service and Maintenance".

Below are some topics related to Serialized and Lot Controlled Items that will be useful:

Convert non-Serialized Item to Serialized and non-Lot Controlled item to Lot Controlled and Vice Versa

If Item is created as non-Serialized and/or non-Lot controlled... To change them to Serialized or Lot Controlled, here are some standard Sessions that can be used:

1.Convert (to) Serialized Item (whltc5201m000) can also be accessed from Item-Serials and Warehouses session's Specific Menu.

Note: Once Item is marked or converted as Serialized, it is not possible to revert the item to non-Serialized Items using this session. If any Item has to be converted to non-Serialized, then some Knowledge articles are available to show workaround steps.

2. Convert (to) Lot Item (whltc1202m000) can also be accessed from Item-Lot session's Specific Menu.


Related KB Articles:

2121795 - Item non-Serialized (Not Serial In Inventory) to Serialized (Serial In Inventory) Conversion.
692338 - Is it possible to convert a Serialized Controlled Item into a Not Serialized Controlled Item?
2057953 - Unable to convert a Lot Item to Serialized Item.
723772 - Blocking Message when Trying to Change a Non-Serialized Item to a Serialized Item.
1960873 - Register Serial Issue During As-Built Automatically Set after Converting to Serialized Item.
1134182 - Convert Item to Lot Controlled.
2084394 - Not able to convert Not Lot Controlled Item to Lot in Inventory.
1634725 - Procedure to covert (to) Lot Item (WHLTC1202M000) without using mask.
1009296 - Convert to LOT Item triggered multiple lot numbers. What is the logic behind?
1968968 - Lot Price Not Set after Conversion from Not Lot Controlled to Lot Controlled.
1852794 - Change Lot Type of an Existing Lot.
1634723 - How to enable "Lot" field in the session "Convert (to) Lot Item (whltc1202m000)".

Previous Article Infor LN & Baan Tip: Can You Backflush An Item If Estimated Quantity is Zero?
Next Article Infor LN & Baan Tip: Latest Porting Set – All Versions of Infor LN & Baan
Print
32287 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt
Contact author

Theme picker

Contact author

x

Categories