How did this go - any luck? Also what about osCommerce integration ?
2 10/03/2008 02:19:08 pm
Re: Invoice QTY is negative (6 replies, posted in Report Bugs here)
Any update on this? Thanks
3 10/03/2008 02:17:50 pm
Re: Comment on Line Item Level (2 replies, posted in FA Modifications)
Right...
Just to make sure you know about the requirement:
Multiple people are linked to a centralized billing entity. They want one bill but internally allocate the cost to the various cost centers/people/budgets etc. So the comment could be used for:
A cost center or the date of service or person who ordered it or any other 'identifying mark'. So we need to capture this, like the reference field on an invoice / sales order, but at the line item level. Maybe a reference field would be a better name for it, bit comment + reference at the line item would probably solve many other potential uses.
Thanks
4 10/02/2008 08:37:21 pm
Topic: Comment on Line Item Level (2 replies, posted in FA Modifications)
Could you add a comment field in the sales_order_details? This would be helpful for customers that allocate line items to cost centers when ordering. So either we could add inforation like who ordered it or where a call came from etc.
This is because you cannot change the item description field. It is driven from the Item's description.
5 10/02/2008 06:13:43 pm
Re: Invoice QTY is negative (6 replies, posted in Report Bugs here)
An addl note - this is an allow Negative stock item. These are telephone minutes being billed so there really is no stock on hand.
6 10/02/2008 04:54:27 pm
Re: Invoice QTY is negative (6 replies, posted in Report Bugs here)
Latest and greatest 2.02 - Direct Invoice
7 10/01/2008 03:19:26 pm
Re: Invoice QTY is negative (6 replies, posted in Report Bugs here)
The QTY printed on the invoice is negative. The Sales Order report shows positive 100.
8 10/01/2008 02:47:21 pm
Topic: Invoice QTY is negative (6 replies, posted in Report Bugs here)
I have an invoice for a customer with QTY of 100. The DB shows a + 100 in qty_sent and quantity.
Is this a problem?
9 09/30/2008 07:15:55 pm
Re: Upgrade 1.xx to 2.0.2 (6 replies, posted in Report Bugs here)
Yup - prior version ignored the type and now it matters. Needs to be JPG
10 09/30/2008 06:17:40 pm
Re: Upgrade 1.xx to 2.0.2 (6 replies, posted in Report Bugs here)
Maybe I have a gif logo and the system needs a jpg for the logo?
11 09/30/2008 06:16:10 pm
Re: Upgrade 1.xx to 2.0.2 (6 replies, posted in Report Bugs here)
OK things seem to be going however I have a single invoice I an looking to print and during the PDF gen I am getting:
TCPDF error: Missing or incorrect image file: C:\Inetpub\wwwroot\frontaccounting\reporting\fonts\jpg1260.tmp
in the output window - thoughts?
12 09/30/2008 04:25:23 pm
Re: Upgrade 1.xx to 2.0.2 (6 replies, posted in Report Bugs here)
OK got the new alter.sql - That is much better - thanks!
13 09/30/2008 03:44:10 pm
Re: Upgrade 1.xx to 2.0.2 (6 replies, posted in Report Bugs here)
First - I appreciate the design of a simple open source solution! Second - I could lend a hand for major db changes if you like depending on time of course!
14 09/30/2008 02:56:41 pm
Topic: Upgrade 1.xx to 2.0.2 (6 replies, posted in Report Bugs here)
The alter.sql and alter2.sql scripts do NOT reflect the DB I have installed on my instance.
I am in the process of applying schema changes manually, a real pain. Currently stuck on sales orders and sales order details.
I see you now allow for same SKU different pricing on orders - great, but the upgrade is far from smooth. The upgrade scripts should be smart than this.
My current problem is altering :
ALTER TABLE `0_sales_orders` ADD `version` tinyint(1) NOT NULL default '0' after 'order_no';
Which is throwing an error, any thoughts?
15 04/04/2008 06:48:41 pm
Topic: Load to Company Posting (1 replies, posted in Report Bugs here)
I'm not an accountant so this may be a dumb question. I am trying to post a loan to the company that shows u as a positive balance in the checking account. I have tried posting a journal entry but got all messed up in the debit credit world.
So how should this be done?
I have money to deposit into the account and want to track it as a loan to the company.
Thanks in advance
16 04/04/2008 06:04:43 pm
Re: DATABASE ERROR : The debtor transaction record could not be inserted (2 replies, posted in Report Bugs here)
Version is 1.13
17 04/04/2008 06:03:30 pm
Topic: DATABASE ERROR : The debtor transaction record could not be inserted (2 replies, posted in Report Bugs here)
DATABASE ERROR : The debtor transaction record could not be inserted
error code : 1292
error message : Incorrect date value: '' for column 'due_date' at row 1
I am trying to just enter a payment for an account. There are no orders or invoices for this customer. Just trying to get my costs and my customer payments in place first.
Is this not possible? The field in the 0_debtor_trans.due_date is not null with a default of '0000-00-00'.
18 04/01/2008 10:46:13 pm
Re: Invoice Importing (3 replies, posted in Report Bugs here)
Would it be better to do a Sales Order then invoice them, or do direct to an invoice? Looks like the Sales Order and Invoice are one in the same from the schema. I see Qty and amount also InvoicedQTY and Invoiced Amount is that correct?
19 04/01/2008 04:27:48 pm
Topic: Invoice Importing (3 replies, posted in Report Bugs here)
I have looked into the import scripts / add-ons posted ant they look fairly straight forward. However I need the ability to import CDR summaries (Call Detail Record) summary rows into a new invoice from an external set of systems.
Is there a method of doing that posted any place? I can sync the billto in the remote system using the ID of the FA billing entity but just need to get the detail imported into a new invoice.
Rough Example:
AccountID, Invoice Date, ItemCode, Qty,Discount%,Unit Price
Any thoughts, pointers etc. I'd be glad to code it and contribute the resulting code 
20 04/01/2008 04:22:33 pm
Topic: Late Charges (2 replies, posted in Report Bugs here)
OK I might be stupid, but what is your recommended way / method of assessing late charges / fees etc. on aged accounts?
Our method currently is to total all past due invoices and * .15. How should this be handled.
Thanks in advance
21 09/28/2007 11:38:33 pm
Re: Payroll (16 replies, posted in Wish List)
Payroll had a plethora of implications that could open a company to the IR$, at least in the US.
Would really like to add a commissioning module based on sales orders, Quotas and tiered percentages.
22 09/28/2007 09:58:17 pm
Topic: Pricing and Orders / Invoicing Wishes (3 replies, posted in Wish List)
1. Multiple Line Items of the Same Item per Order/Invoice. Allows for different prices example 10 Free but ordered 20. 10 would need to be priced while 10 would be 100% discounted
2. Tiered Pricing - a big one
3. Re-Occuring Sales Orders for Subscription based sales.
4. Integrated Request Payment via Gateway not just on the invoice
5. Payment via Credit Card paypal would be fine using the CC Merchant account
23 09/28/2007 09:54:29 pm
Topic: Multiple Line Items - Same Item (1 replies, posted in Items and Inventory)
EdgeERP and WebERP allow multiple lines of the SAME item on an order / invoice. The reason is in the telco business, a call is priced differently based on termination or tiered pricing.
I see the DBschema uses the ORder and Item as keys and dows not use a 'counter' per line item. This would allow for additional lines of the same item.
Example:
Conference Call: Minutes are included as part of a standard monthly price while anything over that is billed separately. So the first set of calls would be on a line with 100% discount, the others would carry a price.
Also would be nice to have re-occurring Orders (subscriptions for example) that are billed monthly as well as tiered price plans (I know that is a bit Telco specific)
I Love the interface of frontaccounting and prefer not to go the webERP / EdgeERP route.