• Registered: 07/18/2013
  • Posts: 67

Topic: close year 2017

hello

in this database i can not close amount year and when open trial_balance
view this msg

The Opening Balance is not in balance, probably due to a non closed Previous Fiscalyear.

and i need transfer profit and amount in next year
how this

this is database
https://ufile.io/0frb6
thanks

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: close year 2017

File not visible in BSNL, India

apmuthu's Website

  • Registered: 07/18/2013
  • Posts: 67

Re: close year 2017

this is message when close year

The Retained Earnings Account should be a Balance Account or the Profit and Loss Year Account should be an Expense Account (preferred the last one in the Expense Class)

here find link download database
http://XXXXXX.com/db.zip
plz attach database after close year and transfer amounts

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: close year 2017

As all your data is in ar_EG, what is the account code for your P&L Account? The sys_prefs table shows it as: 9990. There is also such an account in the chart_master table. Why did you have other accounts after the P&L account like:

,('9990','','الربح / الخسارة للعام','23',0)
,('9991','','م. سولار وبنزين السيارات','22',0)
,('9992','','مصروفات نثرية متنوعة','50',0)
,('9994','','محمد سلطان - دائنون','41',0)
,('9995','','م. كهرباء','50',0)
,('9996','','صيانة عقار','50',0)
,('9997','','م. مياة','50',0)
,('9998','9998','غرامات ','50',0)
,('99982','','اغلاق العام','23',0)
,('9999','9999','م كارته ','50',0);

-- Translation

, ('9990', '', 'profit / loss for the year', '23', 0)
, (1999), M. Solar and Benzin Motor, 22, 0)
, ('9992', 'Miscellaneous sundry expenses', '50', 0)
, (9994', '' Mohamed Sultan - creditors', '41', 0)
, ('9995', '', 'M. electricity', '50', 0)
, ('9996', '', 'maintenance of property', '50', 0)
, ('9997', '', 'M. water', '50', 0)
, ('9998', '9998', 'Fines', '50', 0)
, ('99982', '', 'General Fines', '23', 0)
, ('9999', '9999', 'M Karate', '50', 0);

?

You cannot have sub-ledger accounts across different chart classes.

apmuthu's Website