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

Baan / LN tip of the Week: approving a new tax code

Kathy Barthelt 0 93852 Article rating: 5.0

Prior to approving a new tax code, the system displays a message, “An approved tax code cannot be changed anymore. Continue?” This is concerning to end users if they take the message literally. The user can answer “Yes” to the question as it refers to the tax details, not the rates or ledger accounts. A user can always change the tax rate and ledger accounts after it has been approved. All taxing authorities change rates periodically, so it is logical that these could be updated as needed.

OTTO: Making plans happen isn't just about material

Anthony Etzel 0 28582 Article rating: 5.0

Making plans happen isn't just about material. Other things can be the real cause of delays.

OTTO provides the ability to proactively manage the entire customer order backlog from top to bottom. It begins monitoring orders as soon as they’re booked and identifies and prioritizes those critical events that must happen every day so they can be managed and get orders produced and shipped on time.  Learn more

BPCS / LX Tip of the Week: Facility Security Ranges

Anthony Etzel 0 55186 Article rating: 5.0

Previously, a user was able to complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings that were set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and complete the cost transfer process. After the user enters a range in the CST920 screen that is outside of their authority set up in SYS600, a message is displayed that explains they are not authorized to all facilities. Before the enhancement was applied, a user could enter any range in CST920 and it would transfer the costs, regardless of their security level. This enhancement provides security in CST920 that prevents incorrect cost transfers from being processed. 

Crossroads RMC is now set up to accept credit card payments!

Crossroads RMC 0 22742 Article rating: 5.0

Crossroads RMC is now set up to accept credit card payments! We can accept Visa, MasterCard, Discover and American Express. Please note that there will be a 3% transaction fee for domestic payments and a 3.5% transaction fee for international payments. If you are interested in paying for software or consulting services via credit card, please contact our Office Manager, Amy Webber at 630.955.1310, x123. She will work with you to set this up as your preferred method of payment.

Attention Baan IV Customers...

Kathy Barthelt 0 34292 Article rating: 5.0

Attention Baan IV Customers! Crossroads RMC is pleased to announce that we have come to an agreement with Avalara to build an integration between Baan IV and their AvaTax product.

AvaTax provides sales and use tax calculations in real-time including rate determination, returning filing, remittance, and exemption certificate management. 

Want to learn more? Please contact Kathy Barthelt for more details.

Baan / LN Tip: Pro Forma

Kathy Barthelt 0 75927 Article rating: 5.0
Pro Forma invoices can be issued based on order or delivery. If you choose delivery, the pro forma can be linked to the final sales invoice through the sub-session “Related Invoices.”  However, this requires the sales order step “Release to Sales Order/Schedules to Invoicing” to be a manual step. If it is automated, the order will be sent to Invoicing 360 directly and the link to the final invoice will not be made.
First7778798082848586Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan FINANCE Tip: Is it possible to upload accounts receivable invoices into LN using Excel?

Yes, this is possible, by following the steps below:

1. Maintain a batch

2. Maintain an invoice headerexport it, add an additional invoice header to the Excel file, and import it

3. Maintain an invoice line for the first invoice, export it, add additional invoice lines to the Excel file and import it
 

Below the above steps are described in detail.

1a. Open the transactions (tfgld1101m000) session and create a batch.

1b. Insert a transaction type, used for creating sales invoices, like ACR, and open it.

2a. The Sales Invoices (tfacr1110s000) session starts. Maintain the invoice header and save it. For example sales invoice ACR 4497.

2b. In the Actions menu select Export and Import -> Advanced Export (fields: All tabs).

2c. In the excel file created during previous step, add the headers for the invoices to be uploaded. Notice if for the transaction type the Documents in Fixed Sequence checkbox is ticked in the Transaction Types (tfgld0511m000) session, the document number for the not-yet existing invoices to be imported in LN should be equal to the default series for this transaction type. Otherwise, so if the Documents in Fixed Sequence checkbox is not ticked, the desired document numbers can be maintained in the excel file.

2d. In the Sales Invoices (tfacr1110s000) session in the Actions menu select Export and Import -> Settings, and make sure the Import Only in This View checkbox is NOT ticked. Then select in the Actions menu select Export and Import -> Import, select the excel file as saved in the prior step, and import it. Afterwards the invoice headers should be visible in the Sales Invoices (tfacr1110s000) session.

3a. Navigate to the first invoice, select Lines. The Transactions (tfgld1102m300) session opens. Maintain at least 1 line and save it.

3b. Open the line created in the prior step. Notice the detailed version of the Transactions (tfgld1102m300) session opens.

3c. In the Actions menu select Export and Import -> Advanced Export (fields: All tabs).

3d. In the excel file created during previous step, add lines for the header invoice numbers as available in the Sales Invoices (tfacr1110s000) session (as per step 2d).

3e. In the detailed version of the Transactions (tfgld1102m300) session in the Actions menu select Export and Import -> Import, select the excel file as saved in the prior step, and import it.

Previous Article Infor LN / Baan Tips & Tricks for EXECUTIVES
Next Article Infor LN & Baan TECHNOLOGY Tip: Are you running the latest Infor components?
Print
24536 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories