ENTER A GL RECIEPT (initial Balances)
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
ENTER A GL RECIEPT (initial Balances)
by Arwan
::
Rate this Message:
Hi
Am new to webERP and still trying out the system, I am trying to create some opening balance transactions from the webERP manual, the part under Bank Account Balances and Other General Ledger Balances Those are the example transactions given, which I enter using the GENERAL LEDGER > BANK ACCOUNT RECIEPTS > ENTER A GL RECIEPT, link. Debtors Control 5000 Creditors Control (2000) Motor Vehicles 10000 Loan (3000) Accum Profits (11000) Total bank deposit 1000 After entering all the above transaction, I use the link ACCEPT AND PROCESS BATCH and the system responds with the message: SUCCESS Report : Receipt batch 1 has been successfully entered into the database And the link below: PRINT PDF BATCH SUMMARY When I click the link I get the following error ERROR Message Report : The receipt batch number 1 was not found in the database. Please try again selecting a different batch number What am I doing wrong ? Thanks in Advance |
|
|
Re: ENTER A GL RECIEPT (initial Balances)
by Tim Schofield
::
Rate this Message:
Hi Arwan,
I think you need to be doing this with a GL Journal, and not a GL receipt. However it does illustrate a problem, that a receipt with a total of zero is posted to the gl codes, but doesn't appear in the banktrans table. I will look into this when I have a moment, can you post it as a bug at sourceforge. Thanks Tim 2008/9/10 Arwan <r1galaya@...>: > > Hi > > Am new to webERP and still trying out the system, I am trying to create some > opening balance transactions from the webERP manual, the part under > > Bank Account Balances and Other General Ledger Balances > > Those are the example transactions given, which I enter using the GENERAL > LEDGER > BANK ACCOUNT RECIEPTS > ENTER A GL RECIEPT, link. > > Debtors Control 5000 > Creditors Control (2000) > Motor Vehicles 10000 > Loan (3000) > Accum Profits (11000) > Total bank deposit 1000 > > After entering all the above transaction, I use the link ACCEPT AND PROCESS > BATCH and the system responds with the message: > > SUCCESS Report : Receipt batch 1 has been successfully entered into the > database > > And the link below: > > PRINT PDF BATCH SUMMARY > > When I click the link I get the following error > > ERROR Message Report : The receipt batch number 1 was not found in the > database. Please try again selecting a different batch number > > What am I doing wrong ? > > Thanks in Advance > > -- > View this message in context: http://www.nabble.com/ENTER-A-GL-RECIEPT-%28initial-Balances%29-tp19414980p19414980.html > Sent from the web-erp-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > web-ERP-users mailing list > web-ERP-users@... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ web-ERP-users mailing list web-ERP-users@... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
|
Re: ENTER A GL RECIEPT (initial Balances)
by Arwan
::
Rate this Message:
Thanks Tim,
Does this mean that opening balances for a new company (including bank opening balances) should be entered in GENERAL LEDGER > JOURNAL ENTRY ? I was following the webERP manual > Creating a New System - where it says: However, under general ledger - Bank Account Receipts - it is possible to enter general ledger receipts - a button to enter "General Ledger Receipt" allows receipts to be entered without selecting a customer account. The analysis of the other side of the general ledger entries that make up the receipt can then be entered. This is how general ledger balances should be brought on. I have been trying to enter the new company opening (balance sheet accounts and bank accounts) balances all under GENERAL LEDGER > BANK ACCOUNT RECIEPTS. As the manual explains. Is this wrong ? Thanks Arwan
|
|
|
Re: ENTER A GL RECIEPT (initial Balances)
by Tim Schofield
::
Rate this Message:
Hi Arwan,
Sorry I didn't read your initial post correctly. In order to get the bank balance into the GL correctly you do need to use a NBank Receipt or Payment. What you were doing wrong was to post to the Bank as well in the receipt. What you should have done is to enter: Debtors Control 5000 Creditors Control (2000) Motor Vehicles 10000 Loan (3000) Accum Profits (11000) which would have left a balancing entry into the bank of 1000. This would also have allowed you to print off the summary sheet. However I still think you have uncovered a bug, in that it wont allow a summary to be printed if the sum of the entries is zero. Sorry for the misunderstanding on my part, does this make it any clearer? Tim 2008/9/11 Arwan <r1galaya@...>: > > Thanks Tim, > > Does this mean that opening balances for a new company (including bank > opening balances) should be entered in GENERAL LEDGER > JOURNAL ENTRY ? > > I was following the webERP manual > Creating a New System - where it says: > > However, under general ledger - Bank Account Receipts - it is possible to > enter general ledger receipts - a button to enter "General Ledger Receipt" > allows receipts to be entered without selecting a customer account. The > analysis of the other side of the general ledger entries that make up the > receipt can then be entered. This is how general ledger balances should be > brought on. > > I have been trying to enter the new company opening (balance sheet accounts > and bank accounts) balances all under GENERAL LEDGER > BANK ACCOUNT > RECIEPTS. As the manual explains. > Is this wrong ? > > Thanks > Arwan > > > > Tim Schofield wrote: >> >> Hi Arwan, >> >> I think you need to be doing this with a GL Journal, and not a GL >> receipt. However it does illustrate a problem, that a receipt with a >> total of zero is posted to the gl codes, but doesn't appear in the >> banktrans table. >> >> I will look into this when I have a moment, can you post it as a bug >> at sourceforge. >> >> Thanks >> Tim >> >> >> 2008/9/10 Arwan <r1galaya@...>: >>> >>> Hi >>> >>> Am new to webERP and still trying out the system, I am trying to create >>> some >>> opening balance transactions from the webERP manual, the part under >>> >>> Bank Account Balances and Other General Ledger Balances >>> >>> Those are the example transactions given, which I enter using the GENERAL >>> LEDGER > BANK ACCOUNT RECIEPTS > ENTER A GL RECIEPT, link. >>> >>> Debtors Control 5000 >>> Creditors Control (2000) >>> Motor Vehicles 10000 >>> Loan (3000) >>> Accum Profits (11000) >>> Total bank deposit 1000 >>> >>> After entering all the above transaction, I use the link ACCEPT AND >>> PROCESS >>> BATCH and the system responds with the message: >>> >>> SUCCESS Report : Receipt batch 1 has been successfully entered into the >>> database >>> >>> And the link below: >>> >>> PRINT PDF BATCH SUMMARY >>> >>> When I click the link I get the following error >>> >>> ERROR Message Report : The receipt batch number 1 was not found in the >>> database. Please try again selecting a different batch number >>> >>> What am I doing wrong ? >>> >>> Thanks in Advance >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/ENTER-A-GL-RECIEPT-%28initial-Balances%29-tp19414980p19414980.html >>> Sent from the web-erp-users mailing list archive at Nabble.com. >>> >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win great >>> prizes >>> Grand prize is a trip for two to an Open Source event anywhere in the >>> world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> web-ERP-users mailing list >>> web-ERP-users@... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-users >>> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in the >> world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> web-ERP-users mailing list >> web-ERP-users@... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> >> > > -- > View this message in context: http://www.nabble.com/ENTER-A-GL-RECIEPT-%28initial-Balances%29-tp19414980p19428028.html > Sent from the web-erp-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > web-ERP-users mailing list > web-ERP-users@... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ web-ERP-users mailing list web-ERP-users@... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
|
Re: ENTER A GL RECIEPT (initial Balances)
by Arwan
::
Rate this Message:
Thanks Tim,
I managed to enter the new company opening balances in BANK ACCOUNTS RECIEPTS as you explained with the Dr Balance amount going to the bank account. 1100 Accounts Receivable 38250 2100 Accounts Payable -24000 2200 Loan Account -63000 2600 Other Liabilities -33250 1650 Computers 49000 1660 Printers 2500 1700 Furniture & Fixtures 25000 3100 Capital -14826 3500 Profits -11000 1030 Bank Account 21326 The trail balance and balance sheet both show the figures in the correct accounts. All seems to have worked fine so far. Is it possible to use the report builder tool to create a simple report to verify the accounting equation (ASSETS = LIABILITIES + OWNERS EQUITY), using the above data, as follows: ASSETS LIABILITIES OWNERS EQUITY 1100 account receivable 38250 2100 liabilities -24000 Capital -14826 1650 computers 49000 2200 Loan -63000 Profit -11000 1660 printers 2500 2600 Other liab -33250 1700 furniture 25000 1030 Bank account 31326 ======================================================================= 146076 -120250 25826 Thanks in advance
|
| Free Forum Powered by Nabble | Forum Help |
