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 Tips & Tricks for OPERATIONS: Blocking or Unblocking Warehouses

Kathy Barthelt 0 21848 Article rating: 5.0

You can block a warehouse for inbound procedures, outbound procedures, or both. For example, you can block inbound and outbound procedures for a warehouse if the warehouse must be closed temporarily for inspection.

You can impose these types of blockings:

  • Full block: Full block on warehousing procedures.

  • Interactive block: Override blocking allowed except blocks on confirm shipment or confirm receipt.

If you impose a full block on inbound procedures...

Infor LN & Baan Tips & Tricks for FINANCE: Interest Invoices

Kathy Barthelt 0 29744 Article rating: 5.0

You can generate interest invoices for paid invoices, partially paid invoices, and unpaid invoices. In addition, after you generate and send an interest invoice, you can generate a subsequent interest invoice for the next period.

Setting up interest invoicing: You can set up interest invoicing in Accounts Receivable and the General Ledger.
To set up interest invoicing, use these sessions:

  • Invoice-to Business Partner (tccom4112s000)

For invoice-to business partners...

Infor LX/BPCS Tips & Tricks for FINANCE: Creating Configurable Macros (CEA)

George Moroses 0 23475 Article rating: 5.0

You can create new macros in the Infor LX Configurable Enterprise Financials CEA107. 

On the Macro Definition window, you define the source file and the field in which you perform an arithmetic or special operation. For example, you can create a macro to accrue sales commission based on revenue. Your source file and field are the Invoice Line History (SIL) file and the G/L revenue (ILREV) field. 

Select Functions to access the Macro Functions window, on which you define the arithmetic, character, or special operation to process against the defined source field. In the previous example of accrued sales commission, you enter an arithmetic operation of multiply (*) and an operand value for the percentage, such as 0.05 for five percent. 

Note:  Previously created user defined macros will have to be updated to include any expanded field sizes in V84. 

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Setting Up User Groups (CEA)

George Moroses 0 18979 Article rating: 5.0

To utilize the Security Rules Optimization feature, a system administrator can assign security codes to 100 pre-defined user groups. User groups are created in the Group Security Maintenance (SYS603) program. All users assigned to this group possess the same level of security.   

A system administrator can assign security codes for up to 100 of the user groups. All user groups over 100 are still administered by all security reject/allow rules assigned to them but are not able to utilize the optimized process. 

Each of the security codes and access levels are assigned to user groups and are mapped to the account strings and stored in the Account Cross Reference (CEA106D1) file.   

Once security codes have been assigned, the system administrator must: 

  • Determine which level each group is allowed access.

  • Determine which segment values/account strings are assigned to which user groups.

  • Create security rules for specific segment values/account strings and assign these groups to the created rules.

  • Select the rules to be processed.  Processing can be done in either batch mode or interactively.

  • The Security Rules flag must be on in the CEA Control Parameters program before any rules are effective. 

Infor LX/BPCS Tips & Tricks for OPERATIONS: Lot Expiration Date

George Moroses 0 15347 Article rating: 5.0

This feature provides a parameter that allows the user to enter expiration dates on the Inventory Transaction Posting screen, INV500, and Purchase Order Receipts screen, PUR5505, when they have received a lot controlled item that is not QMS controlled. This new field allows an expiration date to be entered and not overridden. A system parameter was added to Advanced Process Industries Parameters, API820D. When the parameter is set to Yes, a new lot expiration date is available in the Inventory Transaction Posting, INV500D2, and Purchase Order Receipts, PUR550D2, screens.

First1112131416181920Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for FINANCE: Currency Differences

When currency differences are posted, several parameters affect the way the entries in the General Ledger are created. This section explains the possible parameter settings:

  1. Ledger accounts by currency

  2. Writing off currency profits

  3. Fixed exchange rate

  4. Writing off currency differences for anticipated payments


1. Ledger accounts by currency
This parameter is recorded in the Finance Company Parameters (tfgld0503m000) session.

If the Ledger Accounts Currency Differences by Currency check box is selected, the (un)realized currency differences are posted to the ledger accounts defined in the Currency Difference Ledger Accounts by Currency (tfgld0119s000) session.

LN retrieves the related dimensions from these sessions:

  • General Ledger: Finance Company Parameters (tfgld0503m000)

  • Accounts Payable: Ledger Accounts by Business Partner Group (tfacp0111m000)

  • ACR: Ledger Accounts by Business Partner Group (tfacr0111m000)

If the Ledger Accounts Currency Differences by Currency check box is cleared, the currency differences are posted to:

  • General Ledger: the ledger accounts specified in the Finance Company Parameters (tfgld0503m000) session.

  • Accounts Payable/ Accounts Receivable: the ledger accounts recorded for the business partner group.


2. Writing off currency profits
This parameter is defined in one of these sessions:

  • ACP Parameters (tfacp0100m000)

  • ACR Parameters (tfacr0100s000)

If the Currency Profits check box is selected, the unrealized currency profits are posted as well as the unrealized currency losses. Unrealized currency losses are always posted when writing off currency differences.

3. Fixed exchange rates
For each invoice, the rate determiner defines:

  • Which date is used to determine the exchange rate.

  • If currency differences are calculated.

  • For which (home) currencies the currency differences are calculated.

The Rate Determiner is set in the Sales Invoices (tfacr1110s000) session or the Purchase Invoice Entry (tfacp2600m000) session.

Unrealized currency differences are written off in one of these sessions:

  • Write Off Currency Differences (tfacp2240m000)

  • Write Off Currency Differences (tfacr2250m000)

4. Writing off currency differences for anticipated payments
This parameter is defined in one of these sessions:

  • ACP Parameters (tfacp0100m000)

  • ACR Parameters (tfacr0100s000)

If the Currency Difference Anticipated Payments check box is selected, invoices with anticipated payments or anticipated receipts are considered for writing off currency differences.

Previous Article Infor LN & Baan Tips & Tricks for EXECUTIVES
Next Article Infor LN & Baan Tips & Tricks for OPERATIONS: Pegging Material Supply Lines for Operation and Product Subcontracting
Print
2650 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories