G/L Branch Table Maintenance GB5700
The branch file maintenance program is used to add, change or delete a branch record.
Due to the highly integrated nature of the branch, as it pertains to the financial implications it is very important to follow and verify the following steps when setting up and using a new branch:
1) Define the branch via this maintenance (gb5700)
IMPORTANT : After creating a new branch, you must be given access to this branch in User Maintenance (gb4200). If you do not you will not be able to use the branch in other applications. Note also that after you save/create the new branch you will not be able to query it in this application until this step is done.
2) Define all of the G/L accounts for this branch by using the General Ledger Account Maintenance (gb5800).
3) Create a currency detail entry for the currency of the branch defined using the Currency master maintenance (gb0700). This will define all of the General Ledger Accounts to be used for the financial applications.
4) Update (if required) accounts like retained earnings and consolidation accounts for the branch by using this maintenance gb5800.
Branches entered through the statistical General Ledger menu will become statistical branches, and branches entered through the non-statistical General Ledger will become non-statistical branches. Statistical branches may not be queried through the non-statistical menu and vice versa. Branches must still have distinct names, however. For example if 's1' exists as a statistical branch, you will not be allowed to create 's1' as a non-statistical branch.
Branches on whole, can be consolidated by using the “consolidation branch 1”
and “consolidation branch 2” discussed below.
Branch and account consolidation can also be defined by using the consolidation branch and/or consolidation accounts in the General Ledger Account Maintenance (gb5800).
Branch
Enter the branch code that you wish to add to the branch file.
Description
Enter the description of branch to be added or modified.
Branch Currency
Enter the currency code for this branch. The currency is entered using the Currency Maintenance Program (GB0700).
Consolidation Branch 1
Enter the first consolidation branch code to which this General Ledger branch is consolidated. The consolidation branch 1 code should not be the same as consolidation branch 2 code. This field is not available if the Branch Consolidation by Branch flag was not set in System Flags Maintenance (GB2800).
Note. When setting consolidation the Chart of Accounts Validation program (GL0900) should be run to verify that there are no endless loops in the consolidation. Eg. A branch and or account consolidating back onto itself.
Consolidation Branch 2
Enter the second consolidation branch code to which this General Ledger branch is consolidated. The consolidation branch 2 code should not be the same as consolidation branch 1 code. This field is not available if the Branch Consolidation by Branch flag was not set in System Flags Maintenance (GB2800).
Note. When setting consolidation the Chart of Accounts Validation program (GL0900) should be run to verify that there are no endless loops in the consolidation. Eg. A branch and or account consolidating back onto itself.
Example: You may want branch 3 and 4 to consolidate to branch 2 and then branch 2 to consolidate to branch 1 and also have branch 4 consolidate to branch 5
Retained Earnings
This is the account to which the net amount of income and expense accounts will be transferred when General Ledger Year End Close (GL3200) is run.
Retained Earnings Branch
Enter the retained earnings branch code.
Retained Earnings Account
Enter the retained earnings account code. Retained earnings account number is utilized during the end of year procedures in order to deposit the accumulated retained earnings amount in the appropriate account. This means that all accounts in this branch which have an "eoy clear" flag set to "X" (see GB5800) and will have their retained earnings posted to this account.
When this account has been entered, a message informing the user that the account does not exist on the g/l master file will be displayed. This message is displayed to remind the user to create the retained earnings account in the master file.
Cumulative Translation Adjustment Account
Enter the general ledger account that the system will use when consolidating branches of different currencies. This account is used for inter-branch consolidation balancing. All of the converted currency amounts will be held in this adjustment account in order to accumulate any rounding that may occur. The NET rounding will be used to keep the branch balancing at zero. This account will be an account set up in a statistical branch. This field will allow for a null entry.
Example. You may have a USD branch and a CAD branch that you want to consolidate into a 3rd USD branch.
This means all your CAD accounts must be converted to USD. The cumulative translation account stores all the exchange amounts of all the accounts' currency conversion. After all accounts are converted, the balance in this account represents the net rounding error offset. This is the amount that keeps the branch balancing to $0.00.
Simple example. CAD branch has 1 journal.
1-1 $100 DB.
1-2 $33.33 CR
1-3 $66.67 CR.
NET 0.0
Exchange rate is .705.
1-1 $100.00 * .705 = $70.50 Cumulative Translation Account $29.50
1-2 $33.33 * .705 = $23.48- Cumulative Translation Account $9.85-
1-3 $66.67 * .705 = $47.00- Cumulative Translation Account $19.67-
NET .02+ NET .02-
State Tax Code
Enter the State Tax registration code.
Address
Enter the address (there are two lines available for this).
City
Enter the city.
Province / State
Enter a valid province or state. This must exist in the Province/State Maintenance (gb1300).
Country
Enter the country name. This must exist on the country code country maintenance file (gb0220). Although it does not appear this way on the screen the fields will be required to be entered in this order based on the validation of information defined in gb0220.
Postal / Zip Code
Enter the postal code or zip code.
Phone
Enter the telephone number.
Fax
Enter the fax number.
Document Text
Click on this button with the mouse, or press [Enter] to enter the document text pop-up window.
Language
Enter a valid language code for the document text. In Order Entry this will be matched against the customer's language. In Purchase Order it will be matched against the vendor's language. In both cases, if no match is found, then the default language will be used.
Document Code
Enter the document code. Valid values are :
OA (Order Acknowledgement)
PS (Packing Slip)
IN (Invoice Print)
BL (Bill of Lading)
PO (Purchase Order)
RC (Receive Copy)
SQ (Sales Quotation)
WO (Work Order)
PL (Export Packing Slip)
CI (Commercial Invoice)
or any combination of the above.
For example, to have a particular document text print on the Packing Slip, Bill of Lading and Invoice print, you could enter 'PSBLIN'. It does not matter what order the codes are entered so 'BLINPS' is equally valid.
Document Text
Enter the document text.
Control Numbers
To access this window of information click on the control information button or using the tool bar, click on next page or using the keyboard, do control page down and press enter. If the corresponding control number is setup at the branch level the system will use it otherwise it goes and take the control number from the consolidation branch 1. If the corresponding control number is not setup at the consolidation branch level or there is no consolidation branch 1 setup for the branch then control number comes from the global level which is setup in Global Maintenance (GB0100). In short, the control number hierarchy is general ledger branch code as the highest followed by consolidation branch 1 (if branch has a consolidation branch 1) for the branch and the lowest is the company. See Global Maintenance (GB0100) control number help for more information.
Next Order Number
This is the next Purchase Order number in Purchase Order to be used when the system was initially set up.
Next Job Number
This is the next Work Order number to be used in Manufacturing when the system was initially set up.
Next Purchase Number
This is the next order number to be used in Order Entry, which is automatically incremented by the system.
Next Requisition
This is the next Requisition number to be used in Purchase Order, which is automatically incremented by the system.
Next Customer Number
This field is used in conjunction with the automatic customer number assignment. The automatic assignment of customer number is an option that can be turn on or off via the System Flag Maintenance (gb2800) Sequential Customer Number check box. This is the customer number that will be assigned by the system when a new customer is entered.
Next Adjustment Number
This is the next Adjustment number to be used in Inventory, which is automatically incremented by the system.
Next Invoice Number
This is the next invoice number to be used in Order Entry, which is automatically incremented by the system.
Next Issue Number
This is the next Issue number used in Inventory, which is automatically incremented by the system.
Next Receipt Number
This is the next receipt number to be used in Inventory, which is automatically incremented by the system.
Next Request Number
This is the next Request number, which is automatically incremented by the system.
Next RMA Number
This is the next Authorization number in Customer Service to be used, which is automatically incremented by the system.
Next Transfer Number
This is the next transfer number in Inventory to be used, which is automatically incremented by the system.
Next Unapplied Cash Number
This is the next Unapplied Cash number, which is automatically incremented by the system.
Export Information
Click on this button with the mouse, or press [Enter] to enter the export information pop-up window.
Exporter Number
Enter the exporter number to be shown on the commercial invoice, if applicable.
Commercial Invoice Text
Enter the commercial invoice text. This text will be the default text for the branch that will appear in the special instructions when the Commercial Invoice Print (oe2470) is run. It can be changed/overridden at that time.
Formats
Click the formats button to access the windows where special documents like invoice, purchase order, format can be specified. To view the available special document format, navigate to the corresponding document format field and to a List of Value [LOV]. The list will only show the currently available formats. Entering a format other than the one on the lists will be rejected by the system.
Invoice Format
Enter the invoice format value.
Preview Invoice Format
Press the button to view or print the corresponding invoice print format selected in the invoice format field
Purchase Order Format
Enter the purchase order format value.
Preview Purchase Order Format
Press the button to view or print the corresponding purchase order print format selected in the purchase order format field.
Order Acknowledgement Format
Enter the order acknowledgement format value.
Preview Order Acknowledgment Format
Press the button to view or print the corresponding order acknowledgement print format selected in the order acknowledgement format field.
Account Receivable Statement Format
Enter the Accounts Receivable Statement format value.
Preview Account Receivable Statement Format
Press the button to view or print the corresponding accounts receivable statement print format selected in the accounts receivable statement format field.
Work Order Format
Enter the work order format value.
Preview Work Order Format
Press the button to view or print the corresponding work order print format selected in the work order format field.
Receiving Document Format
Enter the receiving document format value.
Preview Receiving Document Format
Press the button to view or print the corresponding receiving document print format selected in the receiving document format field.
Packing Slip Format
Enter the packing slip format value.
Preview Packing Slip Format
Press the button to view or print the corresponding packing slip print format selected in the packing slip format field.
Bill Of Lading Format
Enter the bill of lading format value.
Preview Bill Of Lading Format
Press the button to view or print the corresponding bill of lading print format selected in the bill of lading format field.
Repair and Service Quote / Job Estimate Format
Enter the repair and service quote / job estimate format value.
Preview Repair and Service Quote / Job
Estimate Format
Press the button to view or print the corresponding repair and service quote / job estimate print format selected in the repair and service quote / job estimate format field.
Internet Information
To access this window click on Internet Information button.
Public Domain
Enter the public domain address. This is for information only at this point. This is for information only at this point. Ex) sdc.on.ca.
Web Application Server
Enter the web server URL of your Oracle Application server. Ex) www.sdc.ca. You can also enter the IP address.
Oracle Logon Application
Used to access PSP (PLSQL server pages) via Oracle’s PLSQL Gateway. PSP’s are used to create dynamic web pages which display in the client’s browser.
DAD stands for Database Access Descriptor. It specifies the database username, password and connect string. SDC uses PSP’s for image (Bill Of Material, Employee, Global, Branch, Product, and Warehouse) uploads (from web clients), and for displaying training tutorials. Your SDC installer will set this value for you. Ex) pls/production.
No Logon Application
Enter the outside application connect string. This is for information only at this point. For now set to the Oracle Logon Application value.
Custom Logon DAD
Enter the custom application connect string. DAD stands for Database Access Descriptor.
Mail Server URL
Enter the company mail server address. Oracle’s JavaMail routine sends email requests to this server. Used by tm2100 (Mailing List Email) and gb9810 (SDC Email Facility).
Sales Email Address
Enter the Sales Email Address.. This is for information only at this point. Ex) sales@sdc.on.ca.
Customer Service Email Address
Enter the Customer Service Email Address. This is for information only at this point. Ex) help@sdc.on.ca.
Information Request Email Address
Enter the Information Request Email Address. This is for information only at this point. Ex) info@sdc.on.ca.
Attachments
To access this window click on attachments button.
Attachment
System presents attachment file name.
Type
System presents attachment file type.
Attach New
Pressing this button will allow you to fined file to be attached.