How to find accounting information on PO lines

There are two places where GL distribution information resides. One is in MMDIST. If the item is a special item or not setup on IC12, then MMDIST is where you will find the GL distribution information.

Keep in mind that a PO line might have started as a requisition and the GL Distributions were added then. When you are looking for PO line distributions,  make sure you look for the document type of PO and specify the company and the document number that matches the PO you are looking for.

 

If the item is on IC12 it is either an inventory item or a non-stock item that is found at an IC location. All items that are setup on IC12 will have a GL Category assigned to them and that is where the GL distribution information can be found for these items. The key fields here are the Company – IC Location – Item. You will be able to find the GL distribution information for these items using these key fields on the GL Category table.

 

AD FS Configuration Errors – gMSA/Insufficient Privileges

If you are configuring AD FS, it is important to remember that you must have at least one domain controller hosted on Windows Server 2012 (at a minimum).  If your infrastructure does not meet these requirements, you will receive the below errors during the AD FS configuration.  Update those domain controllers!

 

Update ADFS Certificate

When it is time to renew the certificate on your AD FS server, you will need to import the new certificate.  To do this, you will first need to get the thumbprint of your newly installed certificate.  Then, run the Set-AdfsSslCertificate command and provide the thumbprint value you retrieved.

Setting session timeout for ADFS and Lawson

It is recommended that the session timeout for AD FS and Lawson be synchronized. You can modify the session timeout in Lawson for Lawson in ssoconfig option 1. To modify the session timeout for AD FS, set the TokenLifetime for your relying party trust using the command below.

Find database file by prefix

Clicking Ctrl+Shift+O in a field on a screen in Lawson is a useful tool to determine what database file that field is populated by. This can be used in Lawson DME Queries, but it also can be used in SQL queries. The prefix of the field name (such as VEN) maps to the table name where the value comes from. If you don’t know how the prefix maps to a table, you can easily find this information in the GEN database. The table you want to search is FILEDEF on the PREFIX column. So, your query might look something like this:

SELECT * FROM FILEDEF WHERE PREFIX = ‘VEN’

This will return the record that contains table name and other information about the database file that populates this screen.

Troubleshooting ED501 job in recovery

A common ED501 message is “WARNING: SUBSTITUTION TABLE ENTRY NOT FOUND”.  This substitution table is maintained in screen ED40.1, and if the key values passed to ED501 are missing, you will receive this error.  Simply update your ED40.1 and recover the job.

If this message causes your job to go into recovery, that is because you have not set up notifications for EDI.  If you set up notifications, then this message will cause an email to be sent about the warning, but the job will continue to process the remaining files.  Notifications are configured on ED00.1, as well as the configuration file located in the EDI directory.

 

Cascading Parameters in Crystal Reports for LBI

When creating an LBI report, there may be a need for a parameter list to be dependent on a previous parameter selection.  The best way to accomplish this in Crystal is to create a cascading parameter. This method works even for multiple-select parameters.

First, create a data source that contains the values you want in your parameters. If your report data source is large, it is best to move that into a sub report, and add a parameter dataset to your main report. In the parameter data set, pull all the records that might be dependent on each other, such as companies and locations.

Create a new parameter called “Locations”. The List of Values should be dynamic. Select a new data source. Set the value and description of the top-most parameter (in this case, Company). Click on the next line in the value box to create a cascading parameter.  In this case, point it at the Location data. Allow select multiple for the parameters where it applies.

Go to Report > Select Expert > Record. Set the Company value equal to the Locations – Company parameter. This way the list of Locations will be dynamically loaded when Company is selected.

When you publish the report to LBI, make sure that you configure the report to use the Crystal Reports parameter page.

Need to deduct a percentage or a flat amount from a vendor’s invoice? Here’s how…

Need to deduct a percentage or a flat amount from a vendor’s invoice?  Here’s how:

  1. Setup a distribution code on AP05.3 as a percentage and indicate the account that the amount should go to. You can actually setup two or more different percentages to distribute to two different accounts. Make the percentage a negative percentage when deducting an amount from the invoice.
  2. On the vendor’s AP10 record on the Default Tab add the distribution code. It will default onto the invoices and automatically deduct the percent or percentages specified on the AP05.3 form for the distribution code.

  1. You may have to adjust the invoice total amount to reflect the deduction(s) to be in balance.

Can you have a single BL & AR company and have transactions post to more than one GL company?

The short answer is no.

However, there are some creative ways to accomplish having a single BL & AR company and still booking information to various GL Companies.

Option 1: Using allocations and getting creative with your Process Levels and possibly accounting units, you can move the amounts to various companies using the allocation module.

The AR process Level setup has a default accounting unit that allows you to book all transactions for this process level to the various accounting units and then setting up an allocation to transfer those amounts at the end of each period would allow you to see the AR amounts on your various GL companies in the financial statements.  I would make these allocations auto reversing so that you can show what you need to for financial reporting only.

Option 2: Setup the various AR and BL companies and use the National Account relationship for your processing.  This option will allow everything to book in the correct company, and still allow you to process payments and adjustments, produce various reports, create consolidated aging reports and all other AR reports.

So as often is the case, you can get what you want, you just need to think it through and see if it will work for your needs.