Most of my invoices have more than 60-70 boxes going out on an invoice made of 12-15 items so having total number of quantity would help my van driver to reconcile it with the customer.
26 09/27/2013 02:51:20 pm
Re: Total Quantity on Invoice & Delivery note (4 replies, posted in FA Modifications)
27 09/27/2013 01:43:57 pm
Re: FA table character set (6 replies, posted in Setup)
Hi
Does the collation has to be latin1_general_ci?
28 09/27/2013 01:37:36 pm
Topic: Total Quantity on Invoice & Delivery note (4 replies, posted in FA Modifications)
Hi
I think we should have total quantity (total number of items/boxes) on the bottom of sales/purchase invoice & delivery note.
Thanks
29 09/24/2013 06:30:06 pm
Re: FA table character set (6 replies, posted in Setup)
Yes I am using it for English only FA.
Sorry. The Collation are different for tables. It's "latin1_swedish_ci" and "utf8_general_ci" . The character is latin1 for colums where table collation is latin1_swedish_ci and utf8 where table collation is utf8_general_ci. Do I need to change my database. I am getting error when I post any documents with "£" sign in note or comment.
30 09/24/2013 04:54:31 pm
Topic: FA table character set (6 replies, posted in Setup)
Hi
In my frontaccounting database, some of my tables and columns have character set as "Latin1" and some are "utf8". Is this correct?
31 09/21/2013 05:23:18 pm
Re: Error in £ sign in comment on sales invoice. (2 replies, posted in Report Bugs here)
I sorted out by changing mysql server "character-set-server" parameter to "Latin1"
32 09/19/2013 10:32:57 am
Topic: Error in £ sign in comment on sales invoice. (2 replies, posted in Report Bugs here)
Hi
I am using mysql version 5.6.13. After upgrade of server, I am getting this error if I use £ sign in any of the comment box in frontaccounting.
DATABASE ERROR : order Cannot be Added
error code : 1366
error message : Incorrect string value: '\xA3540' for column 'comments' at row 1
sql that failed was : INSERT INTO 0_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date, order_type, ship_via, deliver_to, delivery_address, contact_phone, freight_cost, from_stk_loc, delivery_date, payment_terms, total) VALUES ('1354','0','59', '30','59', '','auto','£540','2013-09-19', '1', '2','A & S Sweet','376 Katherine Road\nLondon\nE7 8NW', '', '0', 'HO', '2013-09-20','8','30')
33 09/19/2013 08:08:03 am
Topic: Backup (2 replies, posted in Report Bugs here)
Hi
I am having problem backing up database in Google chrome. It sometimes works in internet explorer. This is happening on all versions from 2.3.15 to 2.3.18. Is there a bug?
34 09/18/2013 10:51:08 am
Topic: Amount Total on Purchase Invoice (1 replies, posted in Report Bugs here)
Hi
After editing tax amount on purchase invoice, the "Amount Total" is not being updated after moving focus from the tax field. It is posting correct Amount Total in the datatbase though.
35 08/15/2013 09:57:35 am
Re: Release 2.3.17 (12 replies, posted in Announcements)
Hi
There is no upgrade file for 2.3.16 to 2.3.17 on Sourceforge. Only a full new version of 2.3.17 is available.
36 08/08/2013 03:39:13 pm
Re: Release 2.3.17 (12 replies, posted in Announcements)
Hi
Where can I find upgrade package for 2.3.17?
37 04/18/2013 09:07:46 pm
Re: Bug in Customer Balances & Supplier Balances Reports (13 replies, posted in Report Bugs here)
Hi Joe
All reports are now perfect. Great job.
Thanks
38 04/18/2013 09:14:34 am
Re: Bug in Customer Balances & Supplier Balances Reports (13 replies, posted in Report Bugs here)
Hi Joe
The Grand Total line at the bottom of the report is still showing wrong total for "Outstanding" column on both the reports. It should be total of Charges minus total of credits.
Thanks
39 04/17/2013 03:54:34 pm
Re: Bug in Customer Balances & Supplier Balances Reports (13 replies, posted in Report Bugs here)
Hi Joe
These 2 reports gives wrong total balances. For example, I had 1 customers owing me £1000 on 31 Mar 2013 which is my year end. In by balance sheet as of 31 Mar 2013, my debtor should be £1000. Now on 31 March 2013 when I print customer balances report, it shows me Grand Total outstanding of £1000 (this tallies to my balance sheet). On 17 April 2013 customer pays £500. So 17 April 2013, my debtor balance is £500 on balance sheet. Now I run customer balance report today but with Start date "01/04/2012" and end date "31/03/2013", the Grand Total balance will show £500 instead of £1000 because it is showing £500 received on 17/4/13 as allocated against the invoice which was outstanding on 31 Mar 2013. I think the best way to sort this is to show outstanding balance as column "charges" minus "credits" instead of allocated column. On my excel report when I do minus of these columns, I get the correct balance.
40 04/17/2013 12:42:43 pm
Topic: Bug in Customer Balances & Supplier Balances Reports (13 replies, posted in Report Bugs here)
Hi
There is a bug in Customer balances & supplier balance report. As per my balance sheet ending 31 Mar 2013, my debtors balance is £32,876 but which I run my customer balances report today (17 Apr 2013) with dates 1/4/2012 to 31/3/13, total outstanding is £25,082. I've realised the report not showing invoices as outstanding for invoices paid after 31 March. If I deduct column totals of "Charges" & "credits" I get correct balance which tallies to balance sheet. Also same bug on supplier balance report. It would be nice if this could be fixed.
Thanks
41 04/08/2013 10:46:55 pm
Topic: Open Year Posting (1 replies, posted in FA Modifications)
Hi
I think we be able to post transactions for "Open" years in FA. My current year is from 1 Apr 2013 to 31 Mar 2014. My users are still receiving purchase invoices from suppliers for March 2013 which is my previous. I have to switch between the year in order for them to post the invoices and other transactions which is very annoying. On the other hand, person generating sales order/invoice can't create/post in current year becuase I had to select previous year as fiscal year. They have to wait for me to switch back to current fiscal year. I think until the fiscal year/s are marked as "closed", system should allow you to post any transactions.
42 03/25/2013 05:01:44 pm
Re: Stock Valuation Report (5 replies, posted in Report Bugs here)
That is what I think. Only quantity should be negative. There are other 60+ BoM items which are fine. Other items where quantity is negative, material cost is positive and is what it should be. There seems to be some bug in script which updates costs either when negative intenvory option is active or under both cases.
43 03/25/2013 10:16:34 am
Re: Stock Valuation Report (5 replies, posted in Report Bugs here)
Hi
As reported in Inventory forum, there is something wrong in cost update script. I am setting up new system for my friend. We are currently running system with allow negative inventory option check so that we can do live sales invoices. I have no clue how this has happened. The stock value has completely wrong as system has posted wrong COGS. We started creating BoM on 18 March 13 for all the sales done from 1 April 2012 till 18 March 13. I have tried to look in to entries in database but can find anything. I can email you entries on excel spreadsheet of Stock and COGS. Please let me know your email.
stock_id mb_flag material_cost
DalMuth-150Gms M -6,260.86
DalMuth-150Gmsx12 M -75,130.00
DalMuth-250Gms M -10,434.79
DalMuth-300Gms M -12,521.75
DalMuth-325Gms M -13,565.24
DalMuth-550Gms M -22,956.58
PunjabMix-150Gms M -1,845.84
PunjabMix-150Gmsx12 M -22,149.86
PunjabMix-250Gms M -6,153.17
Thanks
44 03/22/2013 05:11:21 pm
Re: Wrong Inventory Costing (3 replies, posted in Items and Inventory)
Hi
These are my BoM items.
45 03/22/2013 02:53:29 pm
Topic: Stock Valuation Report (5 replies, posted in Report Bugs here)
Hi
There is a bug in Inventory valuation report. My Balance report is showing stock of 142,175 but the inventory valuation report is showing total value of 150,685.
46 03/22/2013 10:34:36 am
Topic: Wrong Inventory Costing (3 replies, posted in Items and Inventory)
Hi
I have serious issue with inventory cost update. FA has automatically update item cost to negative as below. Because the cost is negative, i can't post item adjustment entries. The stock valuation report is also showing wrong stock value. Can somebody help me on how to rectify this.
stock_id mb_flag material_cost
DalMuth-150Gms M -6,260.86
DalMuth-150Gmsx12 M -75,130.00
DalMuth-250Gms M -10,434.79
DalMuth-300Gms M -12,521.75
DalMuth-325Gms M -13,565.24
DalMuth-550Gms M -22,956.58
PunjabMix-150Gms M -1,845.84
PunjabMix-150Gmsx12 M -22,149.86
PunjabMix-250Gms M -6,153.17
Thanks
47 03/20/2013 04:10:41 pm
Topic: BoM Cost update (0 replies, posted in Items and Inventory)
Hi
I issue with BoM unit cost which is inflating the item cost price. User by mistake posted wrong quantity and hence wrong unit price for an item on purchase invoice. This item is used in BoM for many other manufactured. The error was detected yesterday while looking at COGS. All the items on BoM using this raw material is showing unit cost of £0.45 instead of £0.04. We have rectifed the item itself by issuing credit note and then reentering the invoice with correct quantity & unit cost. My BoM is made of 3 tiers. First and item is made from raw material, then it is packed in packs of different size. Now at this second level, the item (bags) is showing correct cost of £0.04 after correcting the purchase invoice but on the 3 tier where each small packs are packed in 1 box of 12 such packs, the cost of single pack is automatically corrected. It is still showing old unit cost. I want to update unit cost to the actual cost. I know there is no cost update procedure in FA. So how do I fix this?
Thanks
48 03/18/2013 10:03:34 am
Re: Sales Delivery Note & Packing Slip (4 replies, posted in Report Bugs here)
Hi Joe
Is there any way to get the system generated "order no" or "No" instead of auto?
Thanks
49 03/18/2013 09:01:45 am
Topic: Sales Delivery Note & Packing Slip (4 replies, posted in Report Bugs here)
Hi
There is a bug in "Print Deliveries" report. On both Sales Delivery Note & Packing Slip the delivery No & Packing slip No is showing "auto" instead of actual number.
50 03/16/2013 12:30:04 pm
Topic: Sales Discount Account (1 replies, posted in Report Bugs here)
Hi
There is a bug in Sales Discount Account setup in System and General GL Setup. I have change my sales discount account in System and General GL Setup but it 's not enforcing the changes on customer setup. My discount posting is still being posted to old GL account. The customer branch sales discount account still shows my old GL account. I think on change of sales discount account in the main system setup, all customers sales discount accounts should be changed.