I have two equity accounts for recording federal and state taxes paid throughout the year. During the year end closing for 2023 these accounts were not zeroed out. It seems logical to me that these accounts should have a zero balance for the new year, but I'm not sure. If it is OK to zero these accounts what is the appropriate GL account to use for the credit entry?
1 01/05/2024 07:36:50 pm
Topic: Closing equity accounts for start of new year (2 replies, posted in Banking and General Ledger)
2 11/13/2021 11:55:23 pm
Re: Inventory Valuation Report (7 replies, posted in Reporting)
I am experiencing the same issue with version 2.4.9. Unit Cost on Inventory Valuation Report does not agree with Costed BOM Inquiry. All BOM items have Standard Costs and Purchase Costs. I noticed that some items on the Valuation report show the Purchase Cost while others show the Standard Cost.
3 10/23/2021 07:50:53 pm
Re: Can the Initial Value field for a fixed asset be edited? (1 replies, posted in Fixed Assets)
After reading what I had written I realized that I had misspoken. Everything is accurate except for the tooling purchases being outside of FA. The expenses for the tooling were captured in FA years ago but at the time fixed assets were not established. Now I want to create those fixed assets.
4 10/23/2021 07:43:08 pm
Topic: Can the Initial Value field for a fixed asset be edited? (1 replies, posted in Fixed Assets)
I own injection moulds that I want to add as Fixed Asset but the tooling was purchased years ago and outside of FA. It appears that the process of purchasing the asset is how the Initial Value is set. There doesn't appear to be any way to edit the assets Initial Value field after the asset has been purchased. I've checked the permissions associated with Administrator but don't see anything that allows editing Fixed Assets.
So, is my only option then to purchase the asset in FA and then do a JE to reverse the credit to Bank and the debit to Capital Assets account?
5 10/05/2021 03:48:30 am
Re: Problem logging in (11 replies, posted in Installation)
Update:
What fixed the problem was a reinstall of Xampp as well as an earlier version of php. I wish I knew what caused the issue in the first place but other than a few days of being down, none of my data was lost.
Thanks for all the help!
6 09/24/2021 07:52:15 pm
Re: Problem logging in (11 replies, posted in Installation)
While I waited I decided to restore a backup. As a precaution is exported the frontacc database first. Restoring the backup did not fix the issue. So now, with the most recent input from rafat, I plan to install a new version of xampp. However, I would like to restore the exported database file, since it contains the most up to date data. I'm not sure though that using that exported file will result in a clean restore. When I compare the backup file that I used to the exported database file I see some differences in code. The backup has the following code (similar code precedes each table listing):
DROP TABLE IF EXISTS `0_areas`;
CREATE TABLE `0_areas` (
`area_code` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`inactive` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`area_code`),
UNIQUE KEY `description` (`description`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
### Data of table `0_areas` ###
INSERT INTO `0_areas` VALUES
('1', 'Global', '0'),
('2', 'TSI', '0'),
('3', 'Mech.Eng.', '0');
Whereas the exported database file has this code:
CREATE TABLE `0_areas` (
`area_code` int(11) NOT NULL,
`description` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`inactive` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `0_areas`
--
INSERT INTO `0_areas` (`area_code`, `description`, `inactive`) VALUES
(1, 'Global', 0),
(2, 'TSI', 0),
(3, 'Mech.Eng.', 0);
I've been told that the code "DROP TABLE IF EXISTS" is very important to have included. I would appreciate folks weighing in on this.
Thx
7 09/24/2021 02:56:29 pm
Re: Problem logging in (11 replies, posted in Installation)
Thanks for the explanations. I found my latest backup and got some instructions on how to restore it. Before I do so though I want to share one other discovery:
While in phpmyadmin, on the Databases tab, if I click on Check priviledges associated with the frontacc database, an error window is displayed with the following information:
#1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria
( SELECT `User`, `Host`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `Index_priv`, `Alter_priv`, `References_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`, '*' AS `Db`, 'g' AS `Type` FROM `mysql`.`user` WHERE NOT (`Select_priv` = 'N' AND `Insert_priv` = 'N' AND `Update_priv` = 'N' AND `Delete_priv` = 'N' AND `Create_priv` = 'N' AND `Drop_priv` = 'N' AND `Grant_priv` = 'N' AND `References_priv` = 'N' AND `Create_tmp_table_priv` = 'N' AND `Lock_tables_priv` = 'N' AND `Create_view_priv` = 'N' AND `Show_view_priv` = 'N' AND `Create_routine_priv` = 'N' AND `Alter_routine_priv` = 'N' AND `Execute_priv` = 'N' AND `Event_priv` = 'N' AND `Trigger_priv` = 'N')) UNION ( SELECT `User`, `Host`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `Index_priv`, `[...]
It has been suggested that it might prove beneficial to reinstall xampp. Thoughts?
8 09/23/2021 03:55:16 am
Re: Problem logging in (11 replies, posted in Installation)
Thank you all for your responses. Please bear with me as I attempt to follow the recommendations given me, as I do not have any experience working behind the scenes, if you will, with the underlying files and databases. That said, I did find the config_db.php file and I did discover how to access the xampp phpmyadmin database. I did find the Databases and User accounts tabs, as well as the 0_users table in the frontacc database. The below code is from the .php file but I cannot find corresponding settings in the database.
array (
'name' => 'Diventi Enterprises, LLC',
'host' => 'localhost',
'dbuser' => 'frontacc',
'dbpassword' => 'frontacc',
'dbname' => 'frontacc',
'tbpref' => '0_',
'collation' => 'utf8_xx',
),
Also, the dbuser and dbpasswords values shown above are not the credentials I use to login in to company 0, so this information doesn't make sense to me.
I wish there was a more efficient way to diagnose the issue but I am so very grateful for your help.
9 09/22/2021 11:02:17 pm
Re: Problem logging in (11 replies, posted in Installation)
Yes. I wasn't sure where to locate this log file but I finally did under xampp > htdocs > account > tmp, which I I think is correct. The reported error is:
[22-Sep-2021 18:55:16 Europe/Berlin] <b>DATABASE ERROR :</b> could not get validate user login for jeff<br>error code : 1046<br>error message : No database selected<br>sql that failed was : SELECT * FROM 0_users WHERE user_id = 'jeff' AND password='658bd16d7fdac6883fba21937ecb2c8d'<br><br><br>
I verified that the login credentials I'm using are correct.
10 09/22/2021 05:14:26 pm
Topic: Problem logging in (11 replies, posted in Installation)
Hi. After starting XAMPP and after entering my login credentials, the page changes and instead of taking me to the home page I get a nearly blank page and all that shows is "Back", a functioning hyper-link the the FrontAccounting web page and today's date and time. I've tried rebooting and another browser. the FA version I have is 2.4.9 Build 12.05.2021. Up till today FA has been running fine. I recently installed Malewarebytes but FA has been stable after that install.
11 07/01/2021 03:22:17 pm
Re: Existing past fiscal year date in new company setup (4 replies, posted in Setup)
Thanks for the response and path forward. No new data exists so it should be a pretty clean fix. Maybe what I've experienced is a very infrequent occurrence, but even so it would be nice to have that little "gotcha" brought out in the various 'new company setup how-to's' that are out there. The FA WIKI has a link to a doc that provides a bunch of helpful instructions but no mention of the demo data. That doc also links to a KVCodes article, that is very good, but again no mention. Now that I know about it I feel like it was staring me in the face but I just missed it! Thanks again!
12 06/30/2021 08:29:25 pm
Re: Existing past fiscal year date in new company setup (4 replies, posted in Setup)
After a bit of searching the forum I've learned that data is related to a "test" company. So this helps a bit to know but I still want to clean up the data associated with the new company. It would be nice to know why it's there since it is not present in my default company.
13 06/30/2021 08:18:46 pm
Topic: Existing past fiscal year date in new company setup (4 replies, posted in Setup)
Hello. I just setup a new company in FA 2.4.9 on a localhost and discovered that there is data for fiscal years 2019 and 2020. I opted to use the existing database for my default company. The data is unrelated to my business so I am confused as to why it is in the database. All of the transactions are related to two customers: Donald Easter and MoneyMaker Ltd.
I would like to simply delete the data but I'm not sure of the best way to do this. If I delete the fiscal years the system reports that the transactional data will be gone but there will remain the relevant balances.
What to do?
14 05/11/2021 03:54:02 pm
Re: MySQL will not start (2 replies, posted in Report Bugs here)
2nd solution found: I'm still not sure what happened to cause the issues I was having but I found that I just needed to do 3 things:
1- repair the 0_users table in the frontaccounting database, 2- repair the db table in the SQL database and 3- re-enter the ID and password associated with the frontaccounting database.
15 05/10/2021 06:13:38 pm
Re: MySQL will not start (2 replies, posted in Report Bugs here)
I found a solution (create a new data file and populate it with files from backup and the original data file), so now XAMPP will start. However, now when I attempt to log in to Front Accounting I get the message "Incorrect Password, The user and password combination is not valid for the system".
16 05/10/2021 05:00:39 pm
Topic: MySQL will not start (2 replies, posted in Report Bugs here)
I'm not sure if this is the correct forum for this issue but it's the best fit I could see in the index.
From the XAMPP Control Panel, when I click the MySQL button I get the message "Error: MySQL shutdown unexpectedly".
I am not aware of any power outages or systems issues. The only change to the system was that I installed an Adobe suite; CS5. When I discovered that MySQL would not start I uninstalled that suite, thinking that there might be some kind of conflict. It did not help. Any suggestions on courses of action to correct the issue would be appreciated.
Here are the log entries for MySQL for the numerous attempts I've tried today:
InnoDB: using atomic writes.
2021-05-10 9:47:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 9:47:14 0 [Note] InnoDB: Uses event mutexes
2021-05-10 9:47:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 9:47:14 0 [Note] InnoDB: Number of pools: 1
2021-05-10 9:47:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 9:47:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 9:47:14 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 9:47:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=71807730
2021-05-10 9:47:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 9:47:14 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-05-10 9:47:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 9:47:14 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 9:47:14 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 9:47:14 0 [Note] InnoDB: Waiting for purge to start
2021-05-10 9:47:15 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807739; transaction id 500923
2021-05-10 9:47:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 9:47:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 9:47:15 0 [Note] InnoDB: Cannot open 'C:\xampp\mysql\data\ib_buffer_pool' for reading: No such file or directory
2021-05-10 9:47:15 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 9:47:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 9:47:57 0 [Note] InnoDB: Uses event mutexes
2021-05-10 9:47:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 9:47:57 0 [Note] InnoDB: Number of pools: 1
2021-05-10 9:47:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 9:47:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 9:47:57 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 9:47:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 9:47:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 9:47:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 9:47:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 9:47:57 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807748; transaction id 500923
2021-05-10 9:47:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 9:47:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 9:47:57 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 9:47:57
2021-05-10 9:47:57 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 9:49:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 9:49:07 0 [Note] InnoDB: Uses event mutexes
2021-05-10 9:49:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 9:49:07 0 [Note] InnoDB: Number of pools: 1
2021-05-10 9:49:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 9:49:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 9:49:07 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 9:49:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 9:49:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 9:49:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 9:49:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 9:49:07 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807757; transaction id 500923
2021-05-10 9:49:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 9:49:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 9:49:07 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 9:49:07
2021-05-10 9:49:07 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 9:50:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 9:50:07 0 [Note] InnoDB: Uses event mutexes
2021-05-10 9:50:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 9:50:07 0 [Note] InnoDB: Number of pools: 1
2021-05-10 9:50:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 9:50:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 9:50:07 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 9:50:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 9:50:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 9:50:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 9:50:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 9:50:07 0 [Note] InnoDB: Waiting for purge to start
2021-05-10 9:50:07 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807766; transaction id 500923
2021-05-10 9:50:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 9:50:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 9:50:07 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 9:50:07
2021-05-10 9:50:07 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 9:50:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 9:50:37 0 [Note] InnoDB: Uses event mutexes
2021-05-10 9:50:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 9:50:37 0 [Note] InnoDB: Number of pools: 1
2021-05-10 9:50:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 9:50:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 9:50:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 9:50:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 9:50:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 9:50:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 9:50:37 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 9:50:37 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807775; transaction id 500923
2021-05-10 9:50:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 9:50:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 9:50:37 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 9:50:37
2021-05-10 9:50:37 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 9:52:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 9:52:26 0 [Note] InnoDB: Uses event mutexes
2021-05-10 9:52:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 9:52:26 0 [Note] InnoDB: Number of pools: 1
2021-05-10 9:52:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 9:52:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 9:52:26 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 9:52:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 9:52:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 9:52:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 9:52:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 9:52:26 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807784; transaction id 500923
2021-05-10 9:52:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 9:52:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 9:52:26 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 9:52:26
2021-05-10 9:52:26 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 10:05:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 10:05:00 0 [Note] InnoDB: Uses event mutexes
2021-05-10 10:05:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 10:05:00 0 [Note] InnoDB: Number of pools: 1
2021-05-10 10:05:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 10:05:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 10:05:00 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 10:05:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 10:05:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 10:05:01 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 10:05:01 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 10:05:01 0 [Note] InnoDB: Waiting for purge to start
2021-05-10 10:05:01 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807793; transaction id 500923
2021-05-10 10:05:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 10:05:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 10:05:01 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 10:05:01
2021-05-10 10:05:01 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 10:22:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 10:22:33 0 [Note] InnoDB: Uses event mutexes
2021-05-10 10:22:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 10:22:33 0 [Note] InnoDB: Number of pools: 1
2021-05-10 10:22:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 10:22:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 10:22:33 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 10:22:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 10:22:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 10:22:34 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 10:22:34 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 10:22:34 0 [Note] InnoDB: Waiting for purge to start
2021-05-10 10:22:34 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807802; transaction id 500923
2021-05-10 10:22:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 10:22:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 10:22:34 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 10:22:34
2021-05-10 10:22:34 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 10:29:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 10:29:15 0 [Note] InnoDB: Uses event mutexes
2021-05-10 10:29:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 10:29:15 0 [Note] InnoDB: Number of pools: 1
2021-05-10 10:29:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 10:29:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 10:29:15 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 10:29:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 10:29:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 10:29:16 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 10:29:16 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 10:29:16 0 [Note] InnoDB: Waiting for purge to start
2021-05-10 10:29:16 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807811; transaction id 500923
2021-05-10 10:29:16 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 10:29:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 10:29:16 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 10:29:16
2021-05-10 10:29:16 0 [Note] Server socket created on IP: '::'.
17 03/18/2020 07:31:32 pm
Topic: Upgrading from 2.3.19 to latest version (2 replies, posted in Installation)
Hello. I am looking for recommendations for how to proceed in doing this upgrade. This is my first update since the initial install in 2014, and that was done by someone else, so I'm a bit tentative.
I have found and read the FrontAccounting Update guide as found on the frontaccounting.com site.
My first problem is that I cannot locate a FrontAccounting directory on my computer, which is a problem since copying files to it is the first step!
18 04/12/2018 11:50:30 pm
Re: Shipping with FA (9 replies, posted in Setup)
This is making sense. Finally! right!?
But won't this approach mess with the accurate reporting for income and expenses?
Accounting is by no means a strength. Just want to make sure that I'm not goofing the bookkeeping.
Thanks again for helping understand things.
19 04/12/2018 08:07:17 pm
Re: Shipping with FA (9 replies, posted in Setup)
Thanks. It helps to talk this through and I really appreciate the feedback.
It's really pretty straight forward: somehow I have to record the shipping expense to the GL, which will be partially offset by Shipping & Handling revenue flowing from sales orders.
I was hopeful that I could book the expense as part of the SO processing transaction. When I couldn't find a shipping function, I was hoping to see a field in the Delivery Against Sales Order routine that would allow me to enter the freight expense associated with the sales order deliver.
The freight amount charged to the customer is usually not the same as the amount charged to me by the freight carrier.
The shipping amount charged to the customer will be booked as a revenue. The JE that I make will book the freight charges from the carrier as an expense (COGS). The revenue will offset part of the expense.
20 04/12/2018 02:36:08 pm
Re: Shipping with FA (9 replies, posted in Setup)
Thanks for the suggestions. I am currently using the Shipping field on Sales orders to capture freight revenue, just as intended.
Won't the amount of the Service type inventory item (Prepaid USPS), when used on the Sales Order, be added to the subtotal? I assume it will because the algorithm will simply treat it as a product being sold to the customer, which in this case it is not.
Looks like I'll have to make a separate JE to capture the freight expense.
Once again, so strange that FA does not provide a straight forward way to create a shipping service provider, ship product, maybe print labels, and record the relevant expense transaction.
21 04/12/2018 04:57:15 am
Re: Shipping with FA (9 replies, posted in Setup)
Thanks. I will do the upgrade and see if it helps. I'll also see if Quick Entries is a good solution.
It seems odd that FA does not have a Shipping product to complement the Sales, Inventory and Manufacturing functionalities currently present is the software. Companies that make products certainly need to ship them.
Can you help me understand why this is?
Perhaps the shipping solution I've described was part of a version enhancement later than my current version? I don't think so because the FA web page doesn't list SHIPPING under the Products tab.
22 04/11/2018 08:13:45 pm
Topic: Shipping with FA (9 replies, posted in Setup)
I am trying to determine if/how FA handles freight expense. Here's what happens in real life and what I'd like to do in FA:
I use an online freight consolidator (a branch of the US Postal Service); I prepay for postage and execute the shipment online.
I want to do a JE for the prepaid postage expense and bank account transaction in FA, then consume the postage expense each time I ship a sales order.
I see where I can setup shipping companies but that appears to be for reference only on invoices.
I was expecting to find a stand alone shipping function within FA but I don't believe it's there.
I'm using FA version 2.3.19
23 03/22/2018 10:58:55 pm
Topic: BOM component omitted from GL transaction when W/O posted (0 replies, posted in Report Bugs here)
I am not on the latest version of FA, so this issue may have already been resolved:
I am using version 2.3.19
I have a kit BOM that contains an item with a purchase cost of $0.003 USD. There is one of this items in the kit. When I post a work order for a kit of quantity 1, the $0.003 item is omitted from the GL posting.
If I change the decimal places to display for Prices/Amounts in Setup/Display Setup to 3 decimals, then the $0.003 item appears in GL transactions.
24 02/09/2018 09:45:34 pm
Re: Invoice Against Sales Delivery (4 replies, posted in Accounts Receivable)
I discovered the problem. The payment option Credit Card, in Payment Terms under the Miscellaneous section of Setup, was set to Cash. Once I edited the type to "After No. of Days" and set the "Due After/Days" to 30 days everything processed as expected.
25 02/09/2018 09:23:16 pm
Re: Credit Card Sale (7 replies, posted in Accounts Receivable)
I'm sorry but I did not perform the install. Can the COA be identified from within FA?