Search options

Hi Guys,

I am running in a issue. When I entered the Purchase Orders/Direct Invoices the numbers were from SI00001 (Supplier Invoice) to increments of 1, 2 etc. Now when I am printing a report of all the Purchase orders the PO reference is printed as "auto". Can somebody help me identify what I am doing wrong.

Hello admins,

Thanks for this wonderful s/w. Can someone help me cleaning supplier allocations from backend. Which tables are affected so that i can clean through queries.

Thanks.

Hello Joe/itronics

Thanks for this wonderful s/w and a tremendous support. you guys are just awesome. I am currently facing a small problem. In my version of s/w (2.3.1) I have created 2 dimensions (departments) one is products and other is catering services. I also created 2 different cash sales (customers) so as to keep products sales segregated from catering sales.

While doing so, I modified previous data in items and assigned them individually to these departments from the front end. This worked out perfectly clean. However problems started coming in when I saw reports from customer sales. Currently when i pull the trial balance and click on petty cash a/c i see customer payments from "cash sales - products" and when i check the back end (gl_trans and debtor_trans) i see all the codes that refer to "cash sales -catering".

As far as i understand following are the tables that are affected when we do a cash sale:
debtor_trans
debtor_trans_details
stock_moves
gl_trans
sales_orders
sales_order_details
bank_trans

Can you please guide me as to what table i need to modify if i have to change the "cash sales - products" to "cash sales - catering" from backend.

Thanks in advance. This will save from entering the invoices twice.

I am currently running FA 2.3.0a the newest version from sourceforge. However I am getting following error when I click Void Transactions -> Purchase Order.

DATABASE ERROR : Error reading record set
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' t.order_no) FROM 0_purch_orders t LEFT JOIN 0_voided v ON t.order_no=v.id AND v' at line 1
sql that failed was : SELECT COUNT(DISTINCT t., t.order_no) FROM 0_purch_orders t LEFT JOIN 0_voided v ON t.order_no=v.id AND v.type=18 WHERE (ISNULL(v.`memo_`))

Can someone please help. Thanks.

Hi Admins,

Thank you for a wonderful piece of software. I had earlier entered alot of Purchase Orders but when I moved to 2.3 I get the following error:

DATABASE ERROR : could not get location info
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEF''' at line 1
sql that failed was : SELECT delivery_address, phone FROM 0_locations WHERE loc_code=''DEF''

When I set the go_debug to 1 following is the sql that i guess is problematic.

SELECT delivery_address, phone FROM 0_locations WHERE loc_code=''DEF''

Steps to reproduce:
Clicking the Purchase module -> PO Entry link.

Can someone please help.

Hello,

Thanks for FA. this is the best accounting software that I have used.

I just installed repgen module 2.2 on my fa. However whenever I am pressing any button from the repgen module such as

Create Block, Create Function the page refreshes and gives the home page. I aint too sure whats wrong. Can someone please help.

Hello,

Thanks for a wonderful software. I am a retailer and using this software for accounting. I import products and sell it here in Canada.

My Inventory figures are skewed as the Inventory valuation report shows 2 categories with following amount: 357.49 (I believe this is the Stock in Hand). So this figure should affect Balance Sheet and should appear there.

However when I open the Balance Sheet the figure that appears there is Cost of Goods Sold.

Why is this happening can somebody help me.