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

Partner News: Avalara’s 2020 sales tax changes webinar is now available

George Moroses 0 30024 Article rating: 5.0

Now that 2020 has arrived, it's time to make sure you’re prepared for all of the changes that 2019 brought in the world of sales tax.

Avalara’s 2020 Sales Tax Changes Webinar is now available to arm you with knowledge on the biggest changes that have taken effect, plus give you a preview of the changes we anticipate this year. 

In this webinar you’ll hear Scott Peterson, Avalara’s VP of U.S. Tax Policy, cover:

  • The current state of sales and use tax in the U.S.
  • Which states have enacted economic nexus, and what’s expected to change in 2020
  • New requirements for marketplace sellers (Amazon, Etsy, etc.)
  • A look at cross-border ecommerce and what international sellers must know about sales tax 

Avalara 2020 Sales Tax Changes Webinar>

Infor LN & Baan Consulting News: So we put our hands up, like the ceiling can’t hold us…

Kathy Barthelt 0 32147 Article rating: 5.0

Crossroads RMC partnered with Hunter Douglas Architectural Ceilings and Walls to upgrade their LN system from LN 10.2 to LN 10.6. This upgrade was undertaken primarily as a result of unsupported hardware/operating system versions at Hunter Douglas. Despite an extremely tight deadline, Crossroads and Hunter Douglas partnered to complete this upgrade from start to finish in under 4 months. Phase 2 is planned to kick off in late Q1 of 2020, which will focus on specific areas of the business for process improvement and the implementation of Avalara’s Avatax software.

Learn about Crossroads RMC's Consulting Services

Infor LN & Baan Tip of the Week: Customer Defined Fields

Kathy Barthelt 0 81621 Article rating: 4.3

Customer Defined Fields (CDFs) can be added to tables, screens, reports and BODs and validation and calculation logic can be defined around those fields.

Use the CDF concept to store additional data in the standard Infor LN tables. The CDF definitions are stored separately from the table definitions in the Data Dictionary. For the end user, the CDFs behave in the same way as the standard fields, if defaulting, validations, etc. are built using the CDF logic of the table extension point. The session extension point also has features for the CDFs.

CDFs are configured per package combination. This implies that when moving your companies from one package combination to another, the CDF definitions must be present in the target package combination. Otherwise you lose the data in the CDFs.

Crossroads RMC is proud to introduce our new Production Order Variance Reports package for Infor LN

Kathy Barthelt 0 71795 Article rating: 5.0

The package includes numerous reports and sessions to view the variances in a way that Finance can identify problems based on the Finance Integration Transactions in the General Ledger.

There are a few main sessions with many detailed sessions linked to them. The reports can be run from the main Print Production Order Variance Reports or in the individual detailed session.

Sessions included in the report package:

1. Print Finalized Trans – Variance Reports.

a. Financial Trans. by L/Acct – Prod. Order Variances - Recap

b. Financial Trans. by L/Acct – Prod. Order Variances – Details

2. Update Production Order Variances (updates special variance table).

3. Production Order Variance Overview – Main view

a. Production Order Variance Details

b. Price Variance Details – Material Variances

c. Price Variance Details – Operation Variances

d. Efficiency Variance Details – Material Variances

e. Efficiency Variance Details – Operation Variances

f. Efficiency Variance Details – Reject Variances

g. ACO Variance Details – Reject Variances

h. Accept Production Order Variances

i. Un-accept Production Order Variances

j. Finally Accept Production Order Variances

4. Print Production Order Variance Reports:

a. Production Order Variance – Overview

b. Production Order Price Variance – Material Revaluation

c. Production Order Price Variance – Operation Revaluation

d. Production Order Efficiency Variance – Material

e. Production Order Efficiency Variance – Operation

f. Production Order Efficiency Variance – Rejects

g. Production Order ACO Variance – Rejects-Additional Costs

5. Delete Production Order Variances (used to redo a month)

Contact Kathy Barthelt to learn more.

Have you missed deadlines or lost a valuable customer due to orders not being shipped on-time?

George Moroses 0 32450 Article rating: 5.0

OTTO helps you consider all of the factors that affect your ability to deliver on-time.
Make plans happen with OTTO.

Request your free 30 day trial today and add value to your current ERP, without altering, changing, or revising the source data. 800.762.2077

ION News: Crossroads RMC uses the ION process to deliver data to/from LX 8.3.5

George Moroses 0 32939 Article rating: 5.0

Crossroads RMC is currently working with a customer in the food and beverage industry to develop 18 inbound and outbound customized BOD messages using the ION process to deliver data to/from LX 8.3.5.

All of the messages will be using the standard OAGIS (Open Applications Group Integration Specification) BOD Message. The OAGIS is a widely accepted standard within the industry which specifies a standard way of passing data in and out of applications using an XML format. 

Some of the BOD Messages that we will be processing are:

  • Item Master
  • Purchase Order
  • Receipts
  • Accounts Payable Invoices
  • Vendor information
  • Notifications messages

This project kicks off in February 2020 with milestone deliveries throughout the year.

How Do I Determine If MES Is Right For My Business?

George Moroses 0 36456 Article rating: 5.0

There are certain key questions that must be answered to determine whether or not an MES system would benefit your organization: 

  • How do you analyze OEE?
  • Is there an opportunity to reduce WIP inventory, indirect labor, downtime, waste or scrap?
  • What is the cost and impact of producing and distributing shop paper including drawings and work instructions?
  • Would you like to go paperless on your shop floor?
  • How are your continuous improvement initiatives tied to your ERP?
  • Is Management requesting real time production status reporting via dashboards or drilldown reports?
  • What different “islands of automation” exist on your shop floor?

The answers to each of these questions could have a significant impact on the profitability of your business. Want to quantify your results? Contact George Moroses today to schedule your FREE MES ROI Analysis.

Consulting News: How comprehensive is the Crossroads RMC ERP business audit & how does it work?

George Moroses 0 43493 Article rating: 5.0

Our Infor LX Practice just finished a Supply Chain and Manufacturing audit for one of our customers. During that engagement, several areas of the business were identified that could benefit from additional training and consulting support. 

Areas of significance were:

  • Purchasing
  • Customer Service
  • Billing
  • Inventory
  • Costing
  • Bills of Materials and Routings
  • Material Requirements Planning
  • Shop Floor Control

Several manual procedures and “tribal knowledge” systems were discovered. The evaluation was done by two consultants who spent time with key users during two onsite visits. The next step in the process will involve working with the client to prioritize the list of items identified and develop a strategic plan focused on growth and efficiency.

First5152535456585960Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt
/ Categories: Infor LN & Baan Tips

Infor LN & Baan Tip: Considerations for Release to Warehousing for a Cost Item

When there are two Cost Items, one with Release to Warehousing applied and the other with Release to Warehousing not applied, upon approval of the Sales Order, the Cost Item that is released to Warehousing will go straight to Staged status, pending Shipment confirmation, while the Cost Item that is not released to Warehousing will be up for Sales Deliveries.

Apart from this main difference in functionality between having and not having this option to release to Warehousing checked, there are other impacts to consider. Below is some information gathered from various KBs related to the impact of having release to Warehousing applied (or not). KBs used as reference are listed as “– REF: KB XYZ”. Editing the checkbox “Release to Warehousing” itself If there is a Sales Order (in status Free is enough) for a Cost Item, the check box is not editable. As soon as all the Sales Orders for which the Item is involved are Closed (or Canceled or Deleted) the check box becomes editable again. – REF: KB 1439313 & KB 1613780 Simultaneous/separate release to Warehousing with Physical Items In a scenario where a Cost Item (that is released to Warehousing) and a physical Item are released to Warehousing separately, then the shipment confirmation of each of these Items will occur separately. If they are released simultaneously, the shipment of the Cost Item will not be processed unless and until the physical Item is ready to be shipped. – REF: KB 1449001 Note: Ensure a Warehouse is added to Order Lines to ensure Release to Warehousing Activity is applicable. – REF: KB 2229767 Invoicing

To invoice them separately or together, factors to consider are:

  • Composing Criteria, a list of fields that need to match to have a single invoice created – REF: KB 717977
  • Invoicing Methods (tcmcs0555m000) in the General tab, select Combine, for example, Shipments, to combine different Shipments of the same Sales Order into one Invoice. This Invoicing Method is also defined in
  • Invoice-to role of a Business Partner (tccom4112s000) in the Invoicing tab. – REF: KB 812637
  • For a Return Order where a Cost Item and a Physical Item were originally invoiced together, to invoice them together again, consider using Original Document type = Invoice and link the original Invoice to the Return Order. – REF: KB 2072847 

Note: Consider solution in KB 2108605 if Composing Criteria is met, yet still Credit Notes are not combined for a Return Sales Order copied from original Sales Order for one Physical Item and one Cost Item without release to Warehousing. 

ASN ASN cannot be generated for Purchase Order Lines with Cost Item if not released to Warehousing. – REF: KB 1548301 & KB 2111341 Intercompany Trade Intercompany Trade can be applied for a Cost Item that is released to Warehousing, as Intercompany Trade needs a Warehouse and a Department. – REF: KB 2112430 Customs Value Cost Items that are released to Warehousing that are handled via normal Sales Order Lines are considered as delivered goods and will get the customs value assigned like other Items being subject to warehouse handling. Cost Items handled on Shipment Lines as "Additional Cost" are not considered as delivered goods but as pure costs. The customs value of these shipment lines gets defaulted with a zero amount and cannot be modified. The same applies to additional costs on sales order lines. – REF: KB 1600847 Freight  Cost Items cannot be used for Freight handling. – REF: KB 1830170 Additional Cost

  • For automatically generated Additional Costs in Sales Orders, Cost Items that are released to Warehousing are not released to Warehousing. This is because automatic Additional Costs are always generated with 0 quantity, therefore only the amount is filled for these Lines, which leads to the Delivery Type being set to Sales and not Warehouse. As a result, delivery must take place in Sales module. – REF: KB 1995781
  • For Additional Cost Lines added to Shipment for Cost Items, refer to KB 2236856.

Intrastat Record When using Cost Items without release to Warehousing, there is no shipping data within Invoicing. Therefore, the corresponding Intrastat record cannot be found during the printing of the Invoice. To get the Invoice data filled on the Intrastat record, Cost Items with release to warehousing should be used. Otherwise, session Update Intrastat Transactions with Invoicing Data (tccom7271m100) should be ran to update the Invoicing data in Intrastat. – REF: KB 2005482

Previous Article Infor LN & Baan Tip: What conditions must exist before changing an item's inventory unit?
Next Article Infor LN & Baan Tip: Cash Flow Functionality and Setup
Print
53396 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories