Showing posts with label finance. Show all posts
Showing posts with label finance. Show all posts

Friday, October 26, 2012

CREATE RECURRING ENTRIES IN GL


Recurring Entries in GL is used to set up journal entries for transactions that occur on a periodic basis. Setting up a recurring entry is similar to recording a journal entry, except that the Recurring Entry form contains additional fields for identification.

To Setup Recurring Entries:
1.       In the GL Setup folder, click Recurring Entries icon
2.       In the entry screen, enter the unique recurring entry code which should represent the type of entry created; maximum 16 characters.
3.       In the Entry description field, enter the suitable description e.g. ‘Recurring batch for Nov 2012 Salary Liability.’
4.       In the schedule field, select the schedule an appropriate schedule such as Monthly.
The scheduling defines the frequency and the day on which the recurring transactions will be         processed.
5.       In the start date field, enter the first processing date for the entry e.g. ‘10/19/2012’.
6.       In the Expiration type, there are two options:
1.       No Expiration date
2.       Specific date
If you select Specific date, you must specify an expiration date in the field that appears.
When an expiration date is specified, the entry is included in the recurring entry batch only if the expiration date is later than the run date.
7.       The Last Run Date field displays the last date this entry was included in the recurring batch.
8.       The Last maintained field displays the last date when this record was changed.
9.       In the description, enter the description for the recurring entry e.g. ‘Recurring batch for Nov 2012 Salary Liability for Greytrix Employees.’
10.   Complete the remaining fields the same way a typical journal entry is created.
Create Recurring Entries Batch:
Select the Create Recurring Entries Batch icon from GL Periodic Processing. The Create Recurring Entries Batch form appears:

1.       Enter a date in the Run Date field if the recurring entries are being created manually in the Create Recurring Entries Batch form. The run date determines which recurring entries are due to be processed. It includes all entries up to the date specified.
2.       Enter the From and To Recurring Entry Codes. For e.g. ‘If a new batch is to be created for salary to Greytrix employees for the month of November, then the code that is already created as a recurring entry for the monthly salary should be selected in the From and To criteria.’
3.       The selection criteria Method has the following three options:
1.       Default - When this method is selected, the batch will be appended to an open batch if both batches have the same run date; otherwise, a new batch is created.
2.       Create a new batch – When this method is selected, a new batch is created.
3.       Add to an existing batch - When this method is selected, a Finder field appears. Click the Finder to select an existing open batch to add this batch to
4.       Run Process.

After creating a recurring entry batch:
• Print the Batch Listing and, if necessary, edit the batch using the Journal Entry form.
• Post the recurring entry batch.
                                                                                                                                                      

Friday, June 8, 2012

GL Control Account Feature in Sage 300 ERP


We come across requests that are sometimes so straight forward and some really need you to be a cracker and maybe that’s why we love Sage (Accpac) 300 ERP which makes our life simpler.
Suppose there are 2 different users wherein one user does the AP Invoice entries while the other user performs operations on AR entries. There is a possibility of accidentally selecting an account which is to be used for AP entries. Hence to avoid such mistakes, we were looking for a feature in Accpac which will restrict the user from using the Accounts which are meant for the AP Transactions.
As far as Accpac is concerned we can definitely restrict the users from avoiding this mistake using control Account feature which is inbuilt in GL module of Accpac. Let us see how it works and how it can ensure your accounts are in order.
Consider, we have a GL account which is being used for our bank account and this account should be affected only by AP transactions [by vendor] and not by any of other modules. In such case we will follow below procedure:
  • Open the GL Account screen and select the GL Account which has been set as bank Account. On the detail tab we will check the option Control Account, the new tab as Subledger gets added on the screen as shown in below screenshot.

  •   Go to Subledger tab and choose the subledgers which will have a control on this account. Here we are adding AP source codes as sub ledgers as shown in below screenshot.


Now let’s check the same by doing a normal GL Entry from GL Module on this account. For this go to GL Transactions>>GL Entry and select source code as GL-JE and add select the Account 1020 for Transaction entry. As we select this account for entry, a pop-up screen appears as shown in below screenshot. It will restrict us to make GL entry by another source code which has not been set as subledger on in GL Account screen.


It will accept GL transactions only created by AR Receipt and AP payment Transactions as set against the account sub ledger. If we want to allow account to get affected by other transactions also then we need to add  Source codes of those respective transactions into subledger of GL Account. The transactions created by only those subledgers may be posted to the account. General Ledger checks the ledger by looking at the first two characters prefixed on the source code for each sub ledger Transaction. These first two characters must match the subledger codes.  For example, all transactions created by Accounts Payable use source codes that begin with AP.


This way we can avoid user’s repetitive mistakes which would have been difficult for the admin to keep a hold.


Wednesday, August 19, 2009

CFO is your organizations Gatekeeper, does he have the right Arsenal???


CFO’s are the Gatekeepers of your organization.

They are responsible for planning and forecasting and budgeting the business and cash flows in your organization.
It is and will always be the duty of the CFO to provide the management with a single view of the organizations activities and present the case on what can be the most profitable way for the organization to work in. The key indicators always remain the revenue, cash and cost of operations i.e. the working capital that will be required to function. It is believe it or not the duty of the CFO to facilitate this.
It is the job of the CFO to consolidate all this info and present it , this info comes from precise planning. The precise planning is done not only by drilling and grilling the general ledger but by eying info from all the departments like sales, purchase, Inventory, Manufacturing , HR etc. so the CFO is supposed to have a 360 degree view of the entire organization so that he can precisely plan your company’s next move.
How does the CFO do this?
Traditionally the CFO’s have been doing this by their experience and rigorous efforts and hours of evaluating their books of accounts. This is earned by sleepless nights in the office.
Sage ACCPAC ERP is the solution to providing the CFO’s with a complete 360 degree view of their organization. Sage ACCPAC offers a comprehensive integrated suite of the processes required by your business. With its presence in 150 countries across the globe and 30+ years of experience Sage ACCAPC is a backbone of more than 5,00,000 customers across the globe.
What Sage ACCPAC ERP Offers to the CFO?
· A complete end to end reporting and 5 budget sets for you to make and compare budgets.
· A transaction history of 99 years which you can refer to.
· Drill down at the level of every transaction.
· Financial reporting tools – to generate the reports in formats in which you desire.
o Sales Management reports
o Dashboard of top 5 customers, top 5 expenses and many more
o Management analysis reports ( Custom made as per your requirement)
· Business intelligence reporting to estimate and scrutinize the performance of your business and plan them for the next planning period.
· Current Ratio analysis, Dashboards giving graphical analysis – completely customizable as per your requirement
· Overview of the Sales and Purchases done, complete history of the Customer – Supplier-- Item to give you an analysis of whether they are making profit or loss for you.
· All in all a complete view of the system along with Management Dashboards which reflect your Key Responsibility Area.
For more info on Sage ACCPAC ERP contact us at
sales@greytrix.com .