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

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

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 header, export 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 News You Can Use | The business case for moving your ERP to the cloud and choosing MT deployment
Next Article Infor LN & Baan TECHNOLOGY Tip: Are you running the latest Infor components?
Print
9332 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt
Contact author

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Role-Based Security introduces Role type profiles and allows combining the use of Role profiles with the traditional LX User type security profile functionality. The new Role type profile can be defined to allow or deny access to All Products, Attention Key, Products, Programs, and Transaction Effects. Facility, Warehouse, and Company securities are still defined solely by the User profile settings and are not affected by the assignment of a Role. Where applicable, the Role authority is displayed alongside the User authority on the security profile maintenance screens making it easy to see where there are differences in authority between the User and the assigned Roles. 

When Users are assigned to Roles, security access in LX becomes a combination of authorities granted or denied by the Role, plus any User Exceptions. User Exceptions override authorities set by the Roles. A User can also be assigned to more than one Role.

Read more
12345678910Last

Theme picker

Tips: LN | Baan

In Baan IV, a distinction is made between the actual ERP system and a separate planning tool which contains the Constraint Planning package. This tool was intended to work with any ERP system, not just with Baan IV. The Enterprise Planning package is now considered to be a package like any other package in Infor LN.

Users of Baan IV could choose whether they wanted to plan their supply in one of the following ways:

  • By using the MPS and MRP modules in the Manufacturing package.
  • By using the RPD and RMP modules in the Constraint Planning package.

Users of Infor LN can only use the Enterprise Planning package. The distinction between the MPS items and MRP items has been abandoned. In Infor LN, all items can be planned by using a combination of master-based planning methods and order-based planning methods.

Read more

In LN, the People package is used to register the employee’s hours and expenses. To support the People package, the Employees - General (tccom0101m000) session only contains the general employee data.

The title of the Employees - General (tccom0101m000) session was changed to Employees – General (tccom0101m000).

From the Employees - General (tccom0101m000) session, users can start the following sessions to define the more specific employee data:

  • Employees - People (bpmdm0101m000).
  • Employees - Project (tppdm8101m000).
  • Employees - Service (tsmdm1140m000).
  • Skills by Employee (tcppl0120m000).
  • Employees by Team (tcppl0150m000).
  • Roles by Employee (tcppl0170m000).

After users define the employees, users can also start the listed sessions from the Employees Dashboard (bpmdm0101m100) session in People.

Read more
First132133134135137139140141Last

Theme picker

Categories