Setting up the GL Bridge

Setting up the GL Bridge

GL Bridge

The GL Bridge is a function that takes all of the transactions created from your JAS ERP system and using the GL accounts associated with your
code file, and will transfer this information into the JSI accounting system. The following document explains how to set up the GL Bridge.

 

System Options and Chart of Accounts

In the main JAS menu go to:

  • Specialx

  • GL Bridge

  • Processing

  • System Options-Chart Acct


Use Chart of Accounts From:  JSI is where your Chart of Accounts has been created.  If you are not using the JSI package, you cannot use the GL Bridge function.

Path for VJSI system: Enter the path that the JSI company belongs in.

Path for JSI Chart of Accounts:  Enter the path to the JSI company that contains the Chart of Accounts.  In the example above, P is the Drive, USER is the User Directory, VJSI is the JSI folder, and JSI2 is the Data Directory for Company 2 in JSI.

JSI company number:  This will usually be Company 1.  If you are using different charts in your JSI companies that are to be linked to your different companies in JAS, this number and the number of your Data Directory will be changed depending on which company you are linking.  However, in most cases, the chart in JSI1 will be used throughout.

Classify Sales By:  "Style" is used in most cases.  This will use all transactions generated by Styles in the linking process. "Customer" will generate the link based on Customer transactions.

The user also has the option to separate transactions by Country, Currency, or None.

Note: The user can also select the option to 'Enter Account by Division'. This option is selected only when transactions are to be posted into different JSI Data Companies. Change the number in each JAS division to correspond with the JSI Company it will be posted into

  • If this is selected, the divisions you have created in JAS will appear.

 

 

 


 

 

 

In the main JAS menu, go to:

  • Specialx

  • G/L Bridge

  • Processing

  • Link JAS to G/L Chart


 

Company Defaults

This option allows you to enter the main GL Accounts for the specific JAS Data Company.

Note: If the user receives a message such as "CA MISSING GL ACCT", this means that a GL account is missing in the company defaults section. 

 

 

From the Link File Entry screen, select "Company Defaults."


Country:  If the user selected "Post by Country" under the system options and chart of accounts, the user must enter the GL Accounts for each country that appears in the browse screen.  The codes will be displayed from the Country Codes in the Code File.

Division:   If the user selected "Enter Account by Division" under the system options and chart of accounts, the user must enter the GL Accounts for each division for each country.  For example, you will select Country Canada, Division A, and enter the GL Accounts required. The user will then change to Division B and enter the accounts. Continue this process for all Divisions for Canada.  Then, choose another country and repeat the process for all Divisions, until all countries have been completed.

Exchange Rate:  This is entered/changed just prior to creating the monthly batch of transactions.


 

 

GL Accounts: The browse screen that will display if you click on any of the buttons for the GL Accounts comes from your JSI Chart of Accounts.  Select the corresponding account for each item listed. 

 

 

 


 






Credit Adjustments

From the Link File Entry screen, select "Credit Adjustments."


Use this option to link all of your Credit Adjustments to the GL.  As with Company Defaults, depending on the selections in System Options, the user will have to link each credit code for each division for each country.

 

Click on the browse button next to Adjustment code to display the credit codes from the Code File.  Every code in the browse screen must be linked.

Click on "Update."

NOTE: For each Credit Adjustment code there must be a matching Debit Adjustment code. 


 

Debit Adjustment

From the Link File Entry screen, select "Debit Adjustments."


This option is similar to the Credit Adjustments option, except that the codes will display from the Debit Codes in the Code File.  All codes must be linked.

 

Click on "Update."

 

NOTE: For each Debit Adjustment code, there should be a matching Credit Adjustment code. 

 


 

Customer File Codes/Style File Commands

In the Link File Entry screen, the user will have access to either "Customer File Codes" or "Style File Commands" depending on
the selections in System Options.  The Style File is the most common selection, and throughout this documentation that is the
option being used. However, if the user selects Customers, click on the Customer File Codes.

 






Customer File Codes

From the Link File Entry screen, select "Customer File Codes."


The Customer option is similar to the Style option.  Refer to the next section for most information.


 



Style File Commands - Recommended Option

From the Link File Entry screen, select "Style File Commands.


As with previous entry screens, the GL Accounts for Sales and Returns must be entered for every division, for each country.

Link Code:  The Link Code links each style to the GL.  Initially, there will be no Link Code in the file.  Therefore, if the user clicks on the browse button, the screen will be empty.  Enter a new 3-character code in the field provided. The user will be asked if he or she wants to add a code.  Click OK and enter a description. Entering different codes will separate your styles into different groups. For example, if the user imports and manufactures styles, a BUY and MKE, or STB and STM would be entered.  If the user does not require this kind of grouping, simply enter STY as the default code.

Style File:  The Link Code that is entered in the Style File Commands screen must also exist in each style.  In the Style File Maintenance screen, there is a button for General Ledger. 

If the user does not have access to this button, go to Setup, Installation Parameters, Special Options, AR, and enter Y to “Are you using GL Link?”


Note:  Once the user answers Y to the GL Link, all styles must contain the Link Code, and from now on all new styles must have this code.

The user can create more than two Link Codes, according to the user's preferences, but this makes adding new styles more complicated.  JAS Support personnel can load a default Link Codes of your choice into the style file the first time to update all of your styles. If the user has created more than two codes, you have the option to manually update the styles one style at a time with the correct code or once Jonar has updated the files, modify the styles in question. 

Remember, the three GL Accounts must be linked to each Style Link Code for every country.

 

Printing all GL codes

Click on the printer icon to print a list of all the GL Codes for each option in the Link File Entry screen.

This process will show you if any codes have the GL accounts missing and will need to be updated before moving on. 


*** This is the end of the GL Set-up Procedures.  It is important to note that any new codes created in JAS after the set-up must be
linked, i.e. new countries, adjustment codes and styles.  Codes that are not linked to GL accounts will cause errors in future monthly
processing.***

 

Generation Reports

The first time running the generation report, a function called 'Include/Exclude' transactions should be run.  If you have been using
JAS for a while and this is the first time linking into JSI, this function must be run. It is necessary to exclude transactions from prior
months
before running the report for the current month.  You will need to exclude from a BLANK date range to the month-end date
prior to the start date of the first link.

In the JAS main menu, go to:

  • Specialx

  • G/L Bridge

  • Processing

  • Journal Entry Transactions

  • Include/Exclude Transactions


Enter in a blank date range in the left hand date field

Enter the latest month-end date, preceding the date of the JSI/JAS link

Once this is run you can then run the Generation Report.

Example: If the user is linking for December 2014, the user will exclude transactions blank to November 30/2014.

 


    • Related Articles

    • Changing a GL account number in JSI and its history

      Table of Contents Introduction Setup Introduction The following document explains how to change a GL account number in JSI. It is important to note that  this function will run though ALL the files that have these existing numbers which includes the ...
    • Reversing a Link posted into the GL

      This Wiki will show you how to reverse a link posted into the General Ledger. Two main reasons for the reversing of a link is due to an out of balance or because it was posted from a future period in error.  Requirements: 1)   The General Ledger must ...
    • Setting up Discounts in JAS from EDI PO's

      Introduction Some trading partners such as Walmart, requires that EDI invoices contain the same Discount Codes and Descriptions that were sent in on the EDI Purchase Orders.  These codes print on the EDI PO. Once the PO is processed in EDI, the ...
    • Message Received when Trying to Delete a GL Account

      Introduction It can occur where users may try to delete a GL account in VJSI and will receive the following message: Explanation of the Message The message means that the GL Account cannot be deleted as there are transactions associated with it. Even ...
    • Setting up BOM by Size in JAS

      Table of Contents Introduction Instructions Step 1: Activating the BOM by size option for the material Step 2: Activating the BOM by size option for the style Step 3: Adding in the Style BOM information If "The material color is always the same as ...