Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Accounting management project


Recommended Posts

begin project for accounting management in Osc

I will add configuration_group value 14 but i need to know if it is used for other planned function ....

Maybe Osc team can confirm if it is free or planned for later use


if Ok i will add these value

#Add an Accounting group in configuration_group table value 14

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (14, 'Accounting', 'Accounting options', 14, 1);

#Add default values in configuratin table

#Status Order needed to allow order to be added in accounting table

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Order status required', 'ACC_ORDER_STATUS_REQUIRED', '3', 'Usually will be when order is shipped. (Osc default shipped status = 3).', '14', '1', '', '', NULL, NULL);

#Max default allowed credit for customer

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Max Allowed default credit', 'ACC_MAX_ALLOWED_CREDIT', '500', 'Maximum credit allowed by default to customers.).', '14', '2', '', '', NULL, NULL);

#String for Debit

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default sign for account debit (invoice)', 'ACC_DEBIT', 'D', 'Usual is set to display D before amount but you can select - .', '14', '3', '', '', NULL, NULL);

#String for Credit

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default sign for account credit (payement)', 'ACC_CREDIT', 'C', 'Usual is set to display C before amount but you can select + or nothing .', '14', '4', '', '', NULL, NULL);



Then the idea is

When order reach the defined status (like shipped) the total amount of order is stored in following table accounting

CREATE TABLE accounting (

acc_id int(11) NOT NULL auto_increment,

acc_order_id int(11) default NULL,

acc_customer_id int(11) default NULL,

acc_customer_first_name varchar(32) NOT NULL default '',

acc_customer_last_name varchar(32) NOT NULL default '',

acc_dc int(1) NOT NULL default '0',

acc_amount decimal(15,4) default NULL,

acc_date date default NULL,

acc_currency char(3) NOT NULL default '',

acc_currency_value decimal(14,6) NOT NULL default '0.000000',

acc_payement_method varchar(32) NOT NULL default '',

PRIMARY KEY (acc_id),

UNIQUE KEY acc_id (acc_id)



All on line payement will be stored after checkout_payement directly from module


In admin panel will be able to add new payement when received bank t/t check cod money....


accounting balance will be added in admin / customers

maybe also in catalog/ account history for customers

a module will produce a daily, weekly, monthly, yearly accounting balance

or balance for one customer


let me know if you have other ideas....

Link to comment
Share on other sites

  • 5 months later...

accounting is only a project i had started some time ago

has i got no answer for this i kept it for later dev


however i have no time to dev until end april

Link to comment
Share on other sites

Hey Elari :D


Have you looked at what oss did with tep 2.1?


They intergrated NOLA with tep.


Problem is that both use different tables and such. However, I thought that running the product_factory_query contrib to abstract table and row names to intergrate with NOLA would save time BUT then you run into the trouble of what to do when osC updates and what not.


osC could use a more powerful admin / accounting section for sure.


hehe, we thinking alike?

NewsDesk(934) / FAQDesk(1106) / OrderCheck(1168) :::

Link to comment
Share on other sites

what is NOLA ??


for accounting, there are so many change request that i keep this project as a last thing to do.

i look at palm&garden edit order that would be a great needed improvement before we should make real accounting inside osc itself.

for instance i have made something to lock order by using a special final order_status (this way you can not delete it, or change status any more) and using zzfritz sales report you have a sort of accounting report.....


Moyashi :

absolutly nothing to do with this thread, let me know if you want to host newdesk/faqdesk on my cvs server. it really help to make more easy dev and for user to follow change made. just create a sourceforge account :)

Link to comment
Share on other sites



NOLA is a SQL Ledger type of program (I guess sort of like quickbooks ..) that helps maintain the accounting side of your business. I believe that ossuite with their fork of osC was going in the right direction -- giving more power to small outfits/companies.


I saw several posts here at osC that were locked. Not sure why :roll:


here's a link to a NOLA fork http://arias.sourceforge.net/main.htm

and here's to nola's site http://nola.noguska.com/main.html


I had hoped to look into this further but the amount of work was quoted at 60 hours to do tep 2.1 by the developer over at ossuite. Problem was he converted tep to fit Nola rather than Nola to fit tep.


I really like osc and am quite "Happy!" with the front of osC but the backend for some reasons I can't point a finger to exactly seems to be lacking. I could guess that this is because the osC dev team is trying to build up the front to A+ material before venturing into the backend.


I would love to have a backend that would allow a wide range of different countries to be able to access easy to use accounting product management abilities with osC.


@ shipping contrib.

I'm going through a few scripts right now fill in a few gaps in the admin section like easy_populate, db table checker, and attribute manager. least to say I haven't really played with the backend until a few days ago and I'm having a rough time getting used to the way things are done in osC.


@ cvs

I just downloaded a gui application for OSX to run CVS abilities on my notebook (server/local unit). So, I'm pretty much in agreement that I need to be more organized and thorough in my commenting of code.


ugh, I just wished I had the time to devote to all these projects I have in mind.

NewsDesk(934) / FAQDesk(1106) / OrderCheck(1168) :::

Link to comment
Share on other sites

  • 2 years later...


This topic is now archived and is closed to further replies.

  • Create New...