The transactions are in the table X_gl_trans, where X is your Company number.
/Joe
1,452 09/03/2014 10:08:38 pm
Re: Error in inventory valuation report (45 replies, posted in Report Bugs here)
Well, the problem here is that you are allowed to change the standard costs at any time, which changes the GL as well, but does not change anything in the stock moves.
This will give an incorrect value in the IVR compared to the GL if taken before todays date and the standard cost has been changed manuelly.
The CIVR should give the correct costed value over all periods. If not, please download the final file here. However if you have changed the standard cost manuelly, it will show an incorrect value.
/joe
1,453 09/03/2014 01:20:29 pm
Re: Error in inventory valuation report (45 replies, posted in Report Bugs here)
Maybe we should take away the date selector from Inventory valuation Report, and force users to use the Costed Inventory valuation Report for selecting periods. What do you say guys?
Joe
1,454 09/03/2014 01:17:20 pm
Re: Multiple delivery dates per sales order (4 replies, posted in Accounts Receivable)
When you use the delivery from sales order, you can deliver parts of the sales order.
Joe
1,455 09/03/2014 11:31:26 am
Re: Error in inventory valuation report (45 replies, posted in Report Bugs here)
But you can use the costed invnetory valuation report, right?
Are you saying, that this report should work just like the costed inventory report?
I am not sure if this is right. Somebody in the audience has earlier asked for the change as it is now.
Joe
1,456 09/03/2014 11:27:48 am
Re: WO with multiple items (7 replies, posted in Manufactoring)
One item on each Work Order.
No, you will have to initiate the work order yourself.
Joe
1,457 09/03/2014 07:24:30 am
Re: Import Multiple Journal Entries (13 replies, posted in Modules Add-on's)
Please Contact the author of the extension. You will find hes email, if you click on the extension name in 'Install / Activate Extensions'.
/Joe
1,458 09/03/2014 06:13:19 am
Re: Anyone tried Clever Accounting based on FA? (5 replies, posted in Installation)
1,459 09/03/2014 05:00:09 am
Re: Import Multiple Journal Entries (13 replies, posted in Modules Add-on's)
Look into Access Setup and see if it is cheched for you user role.
/joe
1,460 09/01/2014 06:48:45 pm
Re: Individual units and cases of units (1 replies, posted in Items and Inventory)
I would use simple assembly in the Manufacturing tab, for the box with 12 units. This will make it easy to keep everything updated automatically.
Please use a Training Co. To test on. This way you will get a feeling of how to use it practically.
Joe
1,461 08/30/2014 04:27:02 pm
Re: Amount left to allocate is not settled after payment to the customer (4 replies, posted in Accounts Receivable)
When you allocate the customer deposit on the left $300 you should select the bank payment to be allocated for this record. Then everything will be ok.
Joe
1,462 08/28/2014 08:39:56 pm
Re: Login white screen (2 replies, posted in Report Bugs here)
It seems that your MySql has been upgrading to a version that do not support the mysql_ routines.
Please try to downgrade the mysql version.
The actual version is first supported in FA release 2.4.
Joe
1,463 08/26/2014 01:30:15 pm
Re: Tax calculation showing in wrong column (6 replies, posted in Installation)
Glad that it helped 
Joe
1,464 08/26/2014 12:46:07 pm
Re: Tax calculation showing in wrong column (6 replies, posted in Installation)
Check that the sales type you use doesn't have the tax included marked.
Joe
1,465 08/26/2014 07:55:24 am
Re: Tax calculation showing in wrong column (6 replies, posted in Installation)
If the tax is included in your prices, then the tax amount is not shown in the 'right' column, because it is already added.
/Joe
1,466 08/25/2014 01:23:31 pm
Re: Direct sales (2 replies, posted in Accounts Receivable)
This is not possible, but you can just ignore it, if you don't need it.
Joe
1,467 08/25/2014 10:37:13 am
Re: Negative Stock (10 replies, posted in Report Bugs here)
You. Should not elaborate between allow and disallow negative stock. It will cause troubles.
Joe
1,468 08/25/2014 10:34:28 am
Re: Decimal Places in Inventory Valuation Report (2 replies, posted in Items and Inventory)
You can change in report rep308.php. Instead of the decimals in AmountCol (the last parameter) you can hardcode it to 2.
Joe
1,469 08/22/2014 05:41:30 am
Re: Forum server breakdown during the last day. (4 replies, posted in Announcements)
I don't think so. Maybe Janusz knows more.
Joe
1,470 08/14/2014 04:48:36 am
Re: Additional dimensions needed (6 replies, posted in Setup)
Consider using dimension/account tags for the dimensions that exceed two.
Joe
1,471 08/13/2014 06:26:54 am
Re: Error in costed inventory movement report (5 replies, posted in Report Bugs here)
Hello again MarkAndrew,
Yes, it looks like we can improve this costed inventory valuation report.
Will you download the file rep308.php1 and rename it to rep308.php and replace it in /reporting folder. Please test with various scenarious and tell me if this is better. Thanks in advance.
/Joe
1,472 08/12/2014 09:52:27 pm
Re: Inventory Valuation (10 replies, posted in Report Bugs here)
This has now been fixed. The HG repository has been updated and the fix will go to next minor release.
You can download a fixed file here .
/Joe
1,473 08/12/2014 08:24:34 pm
Re: Inventory Valuation (10 replies, posted in Report Bugs here)
Seems to be some problems during voiding. Will have a look at this.
/Joe
1,474 08/12/2014 08:23:35 pm
Re: Error in costed inventory movement report (5 replies, posted in Report Bugs here)
FA is using the average material cost when calculating the cost prices.
The item cost price can be manuelly adjusted in the Items and Inventory tab. These Changes will not affect the stock movements and therefore will show the wrong results when using the stock movement cost prices.
This is the fact for report:
Inventory Valuation report,
The reports, Inventory Sales Report, GRN Valuation report, Inventory Purchasing report, Costed Inventory Movements, Inventory Sales report shows the correct cost price values for the stock movements.
/Joe
1,475 08/12/2014 08:23:10 pm
Re: Error in inventory valuation report (45 replies, posted in Report Bugs here)
FA is using the average material cost when calculating the cost prices.
The item cost price can be manuelly adjusted in the Items and Inventory tab. These Changes will not affect the stock movements and therefore will show the wrong results when using the stock movement cost prices.
This is the fact for report:
Inventory Valuation report,
The reports, Inventory Sales Report, GRN Valuation report, Inventory Purchasing report, Costed Inventory Movements, Inventory Sales report shows the correct cost price values for the stock movements.
/Joe