Thursday, January 31, 2013

Login to Sage 300 ERP via Windows Authentication


Sage 300 ERP (formerly known as Sage Accpac ERP) has a login feature, which helps user to login using their windows login. Thus whenever, user login to their domain they do not have to enter a password to login into Sage 300.
Thus, follow below steps to set the settings;
1. Login to Sage 300 ERP.
2. Navigate to Administrative Services -> Users. Select a User for whom you want to apply the settings.
3. Once done, ask user to login to the system via windows login. User has to make sure that he is entering a proper login id and has selected an appropriate domain.
4. Thereafter, double click on Sage 300 short cut key to get the below screen.
5. Thus user just needs to click on Windows Authentication check box; User name will be displayed and the domain selection will be available in a drop down. By default Sage 300 will capture the User ID and domain accordingly.
6. After selecting the domain users can login to system without entering the password.
Hence, users would now be able to use Windows authentication to log into Sage 300 ERP by setting the above simple steps.

Auto-Reverse General Ledger Entries in Sage 300 ERP


Many a times Sage 300 User comes across a situation, where they want to reverse an entry in GL at particular period. This functionality is available in Sage 300 ERP (formerly known as Sage Accpac ERP) in General Ledger Module /GL Transaction/Journal Entry.
The prime example of such cases is the Salary Journal Entry which user enters every month end for making salary provisions which they reverse immediate in the next month.
In Journal Entry users will find an “Auto Reverse” check-box, wherein checking this check-box, will provide with a drop down list adjacent to it with 2 options detailed below.
1. Next period – If you select this option, G/L Journal Entry will get reversed in the immediate next period set.
2. Specific period – When users select “Specific period” option, they will get a drop down where they can select a period in which they want the entry to be reversed.
Note: System will not create any physical entry in the system, but its effect will be replicated in all the required reports and in the Account Inquiry Screen.

“You do not have a license to use this product” Error in Sage 300 ERP


After installing WSSetup on work station sometimes Sage 300 ERP (formerly known as Sage Accpac ERP) shows error message “You do not have a license to use this product!” even after you have a genuine license of Sage 300 ERP.
Reason 1: At the time of WSSETUP user might not have full access rights to access Sage directory where Sage 300 ERP was installed.
Solution: Provide full access rights to user OR login as Administrator and then install WSSETUP on Work-station.
Thus, to provide access right to User navigate to Sage application folder where Sage 300 ERP is installed (its default path would be C:\Program Files\Sage), Right click on Sage folder and go to Sharing and Security options to provide access rights.
Reason 2: It may because of wrong share data directory selected at the time of WSSETUP installation.
Solution: Provide correct path of Sage 300 Application directory installed on server.
Thus, for providing correct path, re-run Sage 300 ERP workstation setup and select Repair option, then navigate to ‘Sage 300 ERP Folders’ and make sure the Program and Data path is rightly selected as that of the server application path.
Thus, by taking care of these small but important steps while installing/settings one can ignore above mentioned error.

Source Journal Profile in Sage 300 ERP


In Sage 300 ERP (formerly known as Sage Accpac ERP) has a distinctive feature known as Source Journal Profile in GL, which can be used by User to configure their Source Journals Reports. Say for an example,  Users want to view Total Cash In or Payment that he has received, then in Source Journal Profile he has to define the source journal profile code say Payment, AR Payments for a particular account (Petty Cash), which would list down all the transactions (payments) for Petty Cash account.
The GL Source Journal Profiles let you specify which source (type) of transactions you want in a report. Source journals select and print posted transaction details according to transaction source codes.
The GL Source Journal reports created using Source Journal Profile can be used for different purposes such as; Reports requested by Auditors, Tracking specific transactions for month end balancing, basic job cost reporting etc.
For Setting up a Source Journal Profile, follow below mentioned process:
1. Navigate to Sage 300 ERP >> General Ledger Module >> G/L Setup and select Source Journal Profiles.
2. Enter a Journal Profile name (say Payment) and select the source codes to be included in the Source Journal Report.
Here, in the above example AR Prepayment implies advance received from customers and AR Payment received implies total cash in from customers. It would give us the total payments received from customers.
Similarly, one can create different profiles depending on their need; it can be Invoice Journals, Purchase and Receipt Journal, GL Journal and so on.
Printing Source Journal Report:
Source Journal lists the details of posted transactions from the source codes that are included in source-journal definition.
Users can also narrow report’s focus by specifying ranges of report fields. Specify the source codes that appear in a report in the source journal profile, and specify the following items when you print the source journal:
1. Reports can be Sort by account number, account segment, account group, or account sorted group. 
a. Account Number – Chart of Accounts are defined in General Ledger, that identifies the account type as one of the income, expense, asset, and liability accounts that records companies business transactions.
b. Account Segment – General Ledger account number let’s user to define account numbers with two or more segments, one segment may be of account segment, and other segment may identify department. Every account number requires an account segment.
c. Account Group – Account Group is a broader classification to which each Account is assigned. Sage 300 ERP uses Account Groups to classify Account Balances whether it is an Income Statement or Balance Sheet Account.
d. Account Sorted Group – If you want to print a set of common account groups then give the same sort code to all account groups in set, specify printing by sort code order, and then choose the sort code of that set.
2. The ranges of account numbers, segment codes, account groups, or account sorted groups.
3. The ranges of fiscal periods (Month selection Range), references, dates (From and to dates selection), posting sequences, and batch numbers.
In other words, Journal profile specifies the type of transaction, but you refine the detail selection at print time. Thus, resulting in a flexible reports for tracing all kinds of transactions, originating from any of the sub-ledgers.
General Ledger comes with three source journal report definitions:
1. GLSJ01F.RPT — lists only the functional-currency value of transactions. This is a single-currency or functional-currency-only version of the source journal.
2. GLSJ01S.RPT — lists the source-currency and/or the functional-currency value of transactions. This is the full multicurrency version of the source journal.
3. GLSJ1SA.RPT — Use this report when you want to print source-currency reports on A4 paper.