It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by tom
I reset my database the first of the year.
My first transaction was 1/4/10
When I look at the bank account transactions start from 1/4/10 until now.
I just reconciled the account and it still starts there, shouldn't it start from the current statement period?
Or maybe the real question is when will it use a different date?
tom
That fixed it
Thanks!
I would love to work with you and see if the osCommerce Import module I wrote will work with ZC or maybe a configuration flag to modify the SQL needed to extract the data
Tom
(ex osCommerce Core Developer)
He has sent it to me and I will update the package.
thanks!
tom
Thanks for the bug report, I will add the update and have a new version posted for download!
On this page a table is displayed with all the outstanding invoices.
The first column is "Transaction Type" but in my simple case it is always "Supplier Invoice" what other Types can show up here?
It would help me if it also listed the "Supplier Reference" because service charges are allocated before invoices and without the reference I have to look at each line's details to see which is a "SC" reference vs invoice type.
I am not sure if this would be of general use
tom
I had that error like that.
I went to: "Banking and General Ledger" -> "Bank Accounts" and had NO selected for the "Dflt" for all accounts
thanks
-------------------------------------
Well I still get it.
"Cannot retrieve exchange rate for currency as of 02/03/2010. Please add exchange rate manually on Exchange Rates page."
From Customer Payment page.
I do have search customer list and the default customer is NULL, maybe the first one should come up by default?
tom
This edit session has been abandoned by opening sales document in another browser tab. You cannot edit more than one sales document at once.
---
I did not have the site open in another tab/browser.
I do recall seeing this message once before, not sure where.
It DID enter the quote ok...
odd
tom
Well when I voided the JE it left the trans_tax_detail records with non-zero values.
I have 3 copies of my db...before, during and after... I can send them to you...
I was going to try on the demo site, but I need higher privs to test there
tom
Is this a bug?
When I did this JE:
Debit 3590 $6.46 and Credit 2150 $5.54 Credit 2154 $0.92
It also added 2 records in 0_trans_tax_details
Firstly: Should it have done that?
(I was just moving money between accounts not collecting money from the outside.)
If that is correct then in my next step when I voided the JE, should it (could it?) have voided the trans_tax_details?
tom
It dawned upon me that the real answer is to fix the Initial Error I made.
I should have added initial balances in the correct Sales Tax GL accounts.
So I see two solutions:
1) Pay the taxes from "Retained Earnings" (since that is where the money was put when I set the Initial Balances)
2) Transfer the Taxes from Retained Earnings to the right tax accounts and then pay as I first suggested
I like #2 since it feels much cleaner.
So I did a Journal Entry Debit 3590 $6.46 and Credit 2150 $5.54 Credit 2154 $0.92
(I did a backup first of course!)
I then did the payment as I first proposed...
Wow this is frightening... I think I am getting the hang of this...
That looked bad... I did The First Journal Entry, voided it and tried a second time.
When I did a Tax Report they both showed up...
I think next year I will pay the taxes before I close 2010 so I can pay it from the 2010 books...
I restored from backup and followed Idea #1
I will try voiding some JE's on my backup server and let you know if there is a problem...
tom
Great... now a SNAFU...
Last year I started using FA in june and was not doing everything right... so I reset my DB fresh and entered initial balances etc...
I need to move some money from "some account" to my Sales Tax GL's or just do a misc payment directly from "some account"
The big question... What GL should I use for "some account"
I want to get it right so that next year I am not totally confused (well because of taxes anyway)
Since the tax was collected last year, it may make sense to use "3590 Retained Earnings - prior years"
I have credit balances in the following:
1060 Checking
1200 Account Receivable
1510 Inventory
2100 Accounts Payable
2150(2152) Sales Tax collected
3590 Retained Profit - Prior years
4010 Sales
4430 Shipping & Handling
4050 Purchase price Variance
The more I look at it, I think I should use 2100, but I could have it backwards...
tom
(Should this section be called "Banking and General Ledger" to match th FA categories?)
I need to pay my sales tax...
I also get a Collection Allowance for collecting the tax, if I pay on time.
How should I account for this?
I was thinking about entering a payment and select each of the Tax types/rates I am paying
and then for the Collection Allowance I will use the GL 4500 "Prompt Payment Discount" and enter a negative payment.
Will that take the Collection Fee and move it from "Sales Tax Collected" and put it in Income?
tom
I will have it this weekend.
I am just finishing up testing
tom
The demand is from any sales orders that have not delivered yet.
Directly or indirectly (via BOM's)
That has been fixed in CVS.
You will also have to tab through (click and tab) Bank Fee and Payment Discount so they get filled with 0.00
That is also being looked at and will have a fix in CVS at some point
tom
This topic should be a wiki page.
Can this annual activity be automated in any way?
tom
Got it thanks.
Also the osc import for FA22 has been posted to the downloads section
I wonder if it would be easy to check the values in setup when enabling roles. (Since they are all listed on that page)
Joe,
I am updating the oscommerce module for FA22 and have a question about security areas:
$security_areas['SA_OSCIMPORT'] = array(SS_SALES|100, "osCommerce Customer / Order Import");
I looked at other modules but do not see any hint at rules for the array values.
In the above statement I used 100, but do those have to be unique for all entries?
for the SS_SALES group? etc
tom
In the update.html it says:
Enter 'Setup' tab, 'System and Generel GL Setup'. Set the correct Accounts for Retained Earnings, Profit/Loss Year and Bank Charge.
I think the BANK CHARGE is used for the Bank Fees for sending or receiving money
Can you give a layman's description for RETAINED EARNINGS and PROFIT/LOSS YEAR?
tom
ps. very wierd I turned on sql_trail and it completed with no errors...
I will look at it, I glanced at it before posting and did not see where comments were being updated... I will dig deeper..
tom
ok.
One speed bump...
Notice the use of ' in the comments...
DATABASE ERROR : cannot update record
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 '' at line 1
sql that failed was : UPDATE 0_comments SET `memo_`='hello, \nplease make sure that the package is mailed asap. it's critical for me to receive it before friday. I understand that priority mail takes about two days, which should work fine for me.\nthank you.\n' WHERE
I am currently running 2.1.3 and see 2.2 and 2.2.2 are out.
Do I need to do this in steps or can I jump right to the latest?
I understand it might be ok to jump right to the latest THIS time...
but maybe not through future updates...
I also have some local mods and will update using CVS...
Tom
There may be a tmp directory that you also changed to 777 that has the php session file in it (The session has to be stored SOMEWHERE 
)
it is not generally a good idea to leave *all* your files set to 777
tom
FrontAccounting forum → Posts by tom
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.