Posts

Transitioning Open POs from one ERP to another ERP

Here are some things to consider:

  1. Is there a cut-off date for open POs or are all open POs going to move over to the new systems?
  2. Will open (unmatched) receivers also be moved over to the new system for the open POs?
  3. When AP vendors are moved to the new system, will they have the same vendor number or is a vendor cross reference needed to import the open POs and receivers to the new system?
  4. Are your item numbers staying the same? If not, you will need an item cross reference for bringing the line items of the POs and receivers over to the new system.
  5. Is there anything special about your PO processing that needs to be taken into consideration when selecting POs or Receivers for conversion?

 

 

 

Transitioning Open Receipts from one ERP to another

There are things to consider when transitioning your open receipts from one ERP to another:

  1. How old are the receipts before you will not move them to the new ERP?
  2. Are the POs still open for the open Receipts?
  3. Is there a new PO number that needs to be used for cross referencing purposes in the new ERP?
  4. How about the vendor number – did it change in the new ERP?
  5. What about your item numbers? – Do you need a cross reference between the old and new item numbers?

Transitioning Open AR from one ERP system to another

Things to consider:

  1. Do your addresses need to be cleaned up?
  2. Do you have duplicate customers that need to be consolidated?
  3. Do you currently have abbreviations in your addresses that you don’t need in your new system?
  4. OR – do you not have abbreviations in your current ERP and need them in your next one?
    1. Create an abbreviation cross reference to easily make the abbreviations needed
  5. Cleaning up the addresses is often very time consuming and can be expensive when waiting until the last minute paying a consultant to do it. Hire a temp now and get it done early and much less expensive
  6. How much history do you want to bring over to the new ERP system?
  7. If you are moving off Lawson, are you using National Accounts? If so, make sure to apply all open payments at the National Account level unless you are sure the new system will allow this same functionality.
  8. Is there anything special about your AR processing that needs to be considered when moving to a new ERP?

Transitioning Open AP from one ERP to another

Things to consider:

  1. Can you pay off all your existing AP prior to transitioning to a new system?
    1. This is preferred whenever possible and start your new ERP with fresh AP
  2. Consider the length of the address fields in your new ERP
    1. Do you need to come up with some abbreviations that work throughout your addresses in the new system?
    2. Have you used abbreviations you no longer need to use and therefore want to undo your abbreviations and make them full words in your new system?
    3. Do you have duplicate addresses that need to be consolidated prior to transitioning? If you are moving off of Lawson, Vendor locations often have duplicate addresses which other ERP systems can’t accept
  3. Cleaning up of inactive Vendors or addresses
    1. This is work that should be done now instead of waiting to the last minute. Paying a consultant to clean up your addresses is expensive.  Hire a temp now and get it done early and less expensive.
  4. Is there anything special about your AP processing that needs to be considered when changing ERP systems?

 

BL vs. BR What are the major differences?

BL vs. BR What are the major differences?

As a summary, BR allows for different billing options that are not only item – Quantity times Price to invoice.

BL allows for creating automatic recurring invoices by running a job that creates the invoices.

BR has jobs that will book the revenue recognition as defined for the contract

 

Feature / Module BL

(Billing)

BR

(Billing & Revenue Recognition)

Using IC for item tracking Y N
Can bill ad-hoc Items Y N
Can Set up Products for billing Y – in IC Y
Can you Print an Invoice to send to the customer Y Performa only
Interfaces to AR Y Y
Requires Activity Module N Y
Auto Create Revenue Recognition entries N Y
Uses Allocations to create Revenue Recognition Entries Y N
Has an Invoice Entry form that looks like an invoice Y N
Create Recurring Invoices Y for various intervals N
Cost Plus Billing Y – based on pricing Y
Pass Thru Billing Y Y
Time and Materials Billing Y Y
Units of Production Billing Y Y
User-Defined Billing Needs to have an item with Quantity times rate associated with invoiced lines Y
Milestone Billing Y- if there isn’t a system generated trigger for the milestone, any invoice item quantity*Price invoice can be created Y – needs to be triggered by something

 

New Level Addresses

When changing level addresses on GL20 or AC10 make sure to specify all the level addresses, not just the ones that might have changed.

When you create the file for uploading, make sure to have the first level first, the second level next and so on until all levels are rebuilt.  If you try to change an address to one which has upper levels that did not exist in the old system, you will get errors.

Just like building the level addresses, you start with level 1, add a level 2 to an existing level 1 and so on.  Same thing when you rebuild the addresses – make sure to rebuild level by level.

Chart of Accounts when using Activities

The Chart of accounts is recommended to be consistent for GL and Activities.  The Activity field, when populated, already differentiates the JE entry line from one to the same account without an activity specified.  This allows for easily determining how much was booked to a specific account and also split the bookings to a specific account into project related or not.

Account Categories in the AC module also allow you to have a separate chart of accounts, if desired, from your GL Chart of Accounts.

Since an account category is required when an activity is entered, it allows for a separation of the GL and AC charts if separation is desired.

Many users default in the Account Category so this value doesn’t have to be specified on each transaction that uses an activity throughout the system.  The defaulting could occur on GL20 instead of GL00 if the accounting unit used in the transaction would alter the way you would account for the project/activity posting.

Creating a “Bursted” Income Statement

To create an income statement for some accounting units, create an Accounting Unit list on MX10 that includes the companies and accounting units that you want to include in the report. Specify that list when running the GL293 and presto – an Income Statement with just those company-accounting unit combinations desired.

This can also be done by creating company groups if the “bursting” should be done by different companies.

A Level group can also be used which is great if one of your Accounting Unit levels signifies a reporting level.  As with the MX10 list, using RW70 level groups can also create a “bursting” effect to the GL293 Income Statement report.

Of course, creating different RW100 reports can also create the same effect and can be run together as a whole on RW100 by specifying a Report Group for example.  Use the same Format for all of the reports, and create different Row definitions that allow you to “burst” the income statement into different accounting groups.

How to automatically deduct a percentage from an invoice

Lawson allows you to use distribution codes that allow for percentages to be negative which would create a deduction. Book the invoice at normal 100% for the expense account and use the distribution code to book the discounts to the proper GL accounts. The amount of the invoice will need to be adjusted to reflect the deductions taken.

If there is a vendor who always gets the same deductions, you can add the distribution code to their AP10 Vendor Record and it will always default onto invoices for that vendor.

Can’t assign a printer in a RECDEF job?

Can’t assign a printer in a RECDEF job? Make sure you have a Printer assigned to you.  Although the rest of the job can be setup, if you do not have a printer assigned to you, then you won’t be able to assign a printer to a step in RECDEF.  For more information see KB 1206370.