Questions tagged [accounting]

Systematic recording, reporting, and analysis of financial transactions of a business.

323 questions
2
votes
0 answers

Can't start slurm database (slurmdbd) daemon

Slurm 17.02.3 was installed on my cluster some time ago but recently I decided to use SlurmDBD for the accounting. After installing several packages(slurm-devel, slurm-munge, slurm-perlapi, slurm-plugins, slurm-slurmdbd and slurm-sql) and MariaDB in…
Paco el Cuqui
  • 93
  • 3
  • 10
2
votes
1 answer

How to create custom invoice fields in Xero?

Is anyone knows how to create customized fileds in our Xero invoices? We are a tour company and we need to add the following fields. Date of Sale, Booking ID, Guest Name, Tour Name, Children, Adults etc. Our tour booking system is generating and…
Johnny
  • 1,415
  • 4
  • 22
  • 36
2
votes
4 answers

Building a rudimentary accounting app

I'm building a simple accounting app to be used for personal finance. A user might keep track of purchases, upcoming bills, recurring deposits, etc. It will be verrrrry simple. Two questions: 1) Any advice I should keep in mind? Obviously, I'll use…
marclar
  • 2,926
  • 5
  • 30
  • 53
2
votes
2 answers

What's the proper way to associate different account types (database types) to payments and invoices?

I've run into a bit of a pickle during my development of a web application. I've boiled down the complexity of the application for sake of simplicity in this question. The purpose of this web application is to sell insurance. Insurance can be…
Dave L
  • 2,465
  • 1
  • 14
  • 20
2
votes
1 answer

How to Calculate Cost of Goods Sold

I have an inventory table. Inventory table SQL: CREATE TABLE INVENTORY ( INVENTORY_ID SERIAL PRIMARY KEY, INVENTORY_DATE date NOT NULL, ITEM_NAME text NOT NULL, PURCHASED_QUANTITY INTEGER…
Nancy
  • 137
  • 2
  • 18
2
votes
1 answer

Ofbiz want to import data from accounting software to ofbiz

I want to import an accounting software data in ofbiz. Can any one suggest me how to do this and is there any reference available to understand ofbiz accounting flow.
user2423768
  • 185
  • 11
2
votes
3 answers

What technology should I use to create a distributed Accounting Software?

Here are my current options. .Net : Using WPF, Visual C#, SQLServer Java : Using Spring, Hibernate, Enterprise DB, web-based Can you suggest which one is better?, especially with regards to building complex forms.
2
votes
2 answers

Anyone have experience integrating with MYOB?

Looking to integrate a web application with MYOB. There's not much in terms of documentation out there. I've found a couple of companies that provide middleware, but nothing promising. Just thought I'd see if anyone else out there has had experience…
mwalsher
  • 2,630
  • 2
  • 30
  • 41
2
votes
2 answers

How to echo specific data in loop with a condition specific to the last row

For an accounting system, I'm using PHP & MySQL. I've two tables "GROUP" and "ACHEADS". In the GROUP table, I have: --------------------- | id (AI) | group | --------------------- | 1 | Group 1 | | 2 | Group 2…
Mayeenul Islam
  • 3,857
  • 5
  • 39
  • 89
2
votes
3 answers

Database Design for Debit / Credit / Payout service

I have a webservice that I am designing which pays users to complete certain tasks. For example, if a user clicks a link, they are paid, say, $0.10 to their account. A user could perform any one of these tasks up to 20 times per day. In order for…
user1143767
  • 1,241
  • 2
  • 11
  • 13
2
votes
1 answer

Accounting table design for outstanding balances by due days (0-30,31-60, etc)

I have an accounting transaction table with the following fields: transactionid date transactiontype (charge,payment,credit,etc) debitaccount creditaccount amount And I have the following records id date type debaccount …
VAAA
  • 12,647
  • 20
  • 110
  • 213
2
votes
1 answer

How to create General Ledger/T-Account using PHP Mysql

I am trying to create a double entry financial accounting system. I have completed designing the database for it, please check this link to see the diagram of my database . http://i39.tinypic.com/juhbv6.png I have tried a lot to develop the mysql…
black_belt
  • 6,110
  • 33
  • 107
  • 179
2
votes
1 answer

VBA number formatting

I am writing a macro package to format numbers in accounting format so that I don't have to click "alt - h - fm" every time I want to make a number accounting format (which my job requires). I have the code up to a certain point, but it is not…
Ian Gaida
  • 21
  • 1
  • 2
1
vote
1 answer

Git "accounting"

Possible Duplicate: Generating statistics from Git repository I'm interested in doing some accounting on a git repository with multiple contributors, something akin to github's statistics. Is anyone aware of something similar that could be used…
seandavi
  • 2,667
  • 4
  • 21
  • 41
1
vote
1 answer

mysql query datetime fields accuracy

I'm using MySql 5.5, I am using the following query on a radius accounting table. query1: SELECT * FROM database.table WHERE framedipaddress='192.168.1.1' and '2011-09-09' BETWEEN acctstarttime AND acctstoptime; The acctstarttime and acctstoptime…
notmyname
  • 69
  • 2
  • 6