Month End- Checks & Validations Pt. 3

Today we’ll look at 3 more ways to verify that all entries have been posted.

  1. Conversion Variance
    • This function creates entries to offset variances due to exchange rates so that accounts will balance
      1. Navigate to Financials > Closing processes > Conversion variance (ACCCURCNV)
      2. Choose the Company group for which to preform the conversion
      3. Check ‘All Sites’
      4. Check ‘All Control Accounts’ or define the accounts
      5. Set the date range for the fiscal period
      6. Choose one BP or a range
      7. Ensure ‘Generate entries’ is marked, generation type is ‘Actual’ and Entry status is ‘Temporary’
      8. This function is most commonly run for BP type Customer and BP type Supplier
      9. Click OK
  2. Stock Accounting Interface
    • Use this function to create entries for stock movements/transactions and update values of stock. When sales deliveries, purchase receipts, stock movements and similar transactions are created, the GL is not updated until this function is run.
      1. Navigate to Stock > Periodic processing >Account Interface (FUNSTKACC)
      2. Selection Criteria should be set to ‘Allocation Date’
      3. Financial site can be left blank to run this for all companies
      4. Click OK
  3. Stock Valuation Report
    • Run this report to use a check to confirm stock values are what you are expecting
      1. Navigate to Stock > Periodic processing > Stock valuation report (FUNSTVA)
      2. Choose the Company to run the report for
      3. You may define other parameters but it is not necessary
      4. Click OK. This will bring you to a screen from which you can print the report

Tune in next time to read about the final step in validating and checking for month end closing!

What’s New in SEI V9- Financials on the Web

Financials on the Web

SEI V9 comes with many improvements including the Universal Data Model(UDM). The UDM allows you to create comprehensive reports using data from various sources(sales, inventory, etc).

Free your financial data. Creating financials on the web allows executives and senior staff members to have a comprehensive look at the company’s financial position while allowing for the flexibility to see current and past data.

Financials on the web means you can view your data on the go! No more refreshing excel workbooks, understanding formulas or waiting on coworkers to update excel workbooks .

Executive staff members, not normally working in excel, could have easy, instant access to important information, used to make key business decisions, like a balance sheet & income statement.

User also have the ability to drill down to different dimensions and details or roll up multiple accounts on same line. Financials come print ready so no time is needed to make them pretty. Easily export to excel/pdf or use the SEI distribution service to have them emailed on a schedule to appropriate team members.

Utilize the new budget entry tools available with SEI V9 to allow users to enter budgets and submit them for review. Also include a side by side budget with ease.

Below is an example of what is possible.

Check back later this week for more details on what’s possible with the finance UDM.

If you’d like a demo of V9 or have questions, contact us at (412) 226-3086 or admin@rebdev.com.

How to Update Customer Email Addresses

In Sage X3 is possible to store customer contact information by ship to address. Sometimes customer contacts change or information needs updated.

Customer emails can be added/ updated by navigating to Common Data> BPs> Customers

Choose your customer from the left list and navigate to the Addresses tab

Choose from the list of address

Scroll to the bottom of the tab to the Email block. Here you can enter email addresses

How to create a browser object with filter criteria

Sometimes the left list in a function can be a bit overwhelming when it contains every record. Did you know it’s possible to created another left list that contains only the data you need? Below are the steps to create a browser object with filter criteria. By following these steps a ‘drawer’ or ‘tab’ on the left list will be created making it quicker and more simple to find the records you need to see.

Navigate to Development > Script Dictionary > Objects

Click ‘New’ to start a new record

Give your object an identifying code & a description. Use the selection icon to choose a linked table

On the General tab, give your object an activity code and choose ‘Browser’ as the management type.

Also on the General tab, make sure your standard & specific script names populate. You will need the specific script name later.

Usually on an object you pick, from the linked table, which fields to display, as below. The SOH object, for example, in the selection screen block, you would define an index (SOH0) then specify a table and field from that table to display. For our browser object, we will do this in the specific script.

Click the ‘Create’ button to create your object.

Create your specific script and add the following piece of code to the Action label:

When "CLE_GAUCHE" : Gosub CLE_GAUCHE  

This action is called before loading the left list

Next, create the action label block:

$CLE_GAUCHE 
return

This is where you will define the filter criteria for your left list drawer by using the variable ‘FILTSUP’. The filter criteria is expressed in a string with logic to combine criteria. See below for an example.

FILTSUP = 'SOHCAT = 4'

This will filter the left list for sale orders that are categorized as contract types. If you need a more complex filter see how to add more criteria below.

FILTSUP = '(SOHCAT = 4 OR SOHCAT = 3) AND CPY = 111'

This would filter the left list for sale orders categorized as contracts or direct invoice and also looking for the company to be ‘111’.

 ###########################################

$ACTION

Case ACTION

         When “CLE_GAUCHE : Gosub CLE_GAUCHE

Endcase

###########################################

$CLE_GAUCHE

FILTSUP=FILTSUP = '(SOHCAT = 4 OR SOHCAT = 3) AND CPY = 111'

Return

###########################################