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
How can we make that timeout longer?
On the reports I generally get a timeout and then I retry and it will work sometimes.
It is really a pain and if a longer timeout will allow it to work then I am happy to wait another 30 seconds!
Retry may be nice, but not needed at this point!
Glad I could help clarify this issue.
Joe, my thinking was that if you ran another bank account as a "Till" you would add all deposits your customers make to that account. Then you could run the currently non-existent Bank deposit report on the till. When you made a deposit to your bank which would satisfy their requirements and then create a transfer from the Till to your bank account which would enable the real bank account deposits to be reconciled. Still a bit of a workaround, but pretty simple and workable.
I do something similar with a Paypal Account and I might add the ability in FA to add a bank fee at the time of the transfer is a great asistance. Previously (different ssystems), I had to post a payment for paypal fees.
Itronics, I think the need for a bank listing report mechnism is still required to deal with debit card and credit card transactions. If you have a terminal from your bank to accept these payments electronically, they will be consolidated into one depost on the bank account. Most systems I have used have the concept of a payment type to suport this. So when you receive a payment you set the payment type and it is consolidated accordingly when posted to the bank to simplify reconciliation.
In my case, I have only written about 2 cheques in 4 months of trading and all of my deposits have been via Paypal or Direct deposit.
I might add that one system I used also had the ability to split off deposits so you could post one figure for say a week's sales and then split off the daily bank deposits from this gross amount when your book keeper came in for his weekly visit
Thiswas the most awesome feature!
Rod,
We can already add a Bank Fee at the time of Transfer, look again.
You just pointed me at something that was bugging me with my Credit Cards.. Customer Payment != Bank Deposits.
Reading about I just realized that the account is not really non-existent, it is your "Merchant Account"
So run the payments into the Merchant Account and then transfer the Batch Deposit (w/Bank Fees) and you're set.
Tom
Rod,
I can help. I am sorry it has taken me so long to reply.
Let's talk directly.
tom
That is not surprising.
Maybe we should add checking to the add/modify customers to check for ",;' and any other specials that are not valid in names.
Granted we could attempt to escape it which may be as simple as "lastname, firstname" but that could look odd to most people.
Maybe YOU can try entering the name that way, the email should accept it, I am not sure how it will look elsewhere in FA
tom
I have been meaning to write a Summary page that gives more debug info.
Maybe it's time for that...
tom
It sounds like you are having trouble accessing the osc database.
on line 123 of /modules/osc_orders/osCommerce.php do you have this?
$one_database = 1; // Use one DB
This was the problem for someone else, maybe I have the default set poorly...
What do you have it set to?
tom
You can set the customerID range by changing:
Starting osC Customer ID:
Ending osC Customer ID:
before you click [Import osC Customers]
I believe I have seen a Donations link somewhere.
I am sure any donations are always appreciated!
Tom
(Just a code contribution user)
You need to give yourself permission to use that module, Setup -> Access Setup
tom
How do you check to see if any customers were created?
Tom
So the Sales Account: could be 4010 (Sales) or 4030 (Shipping and Handling) or maybe add a new one Wire Transfer fees(?)
What about COGS Account? should I use 5690 Interest and bank Charges?
I am sure it is not taxable
tom
What is the best way to add a bank fee (such as wire transfer fee) to a quote or sales order?
Last time I did one I added it to the shipping charges, but that does not seem right.
Should I create an Item 'WIRE FEE' but what GL accounts should I select for it?
Would I need to use the 'bank fee' field when processing the Customer Payment or would the GL codes from the Item handle it?
tom (programmer not accountant)
Go to Setup->Access Setup and select the role you are (Admin?) and enable the checkbox for osCommerce Customer / Order Import
tom
Ok I am not past 30 days old and should see changes.
My online banking shows current statement, then has selectors for each previous statement period.
tom
Well I am sure FA can do it.
In FA you will have 2 locations, 1- Online, 2 - Offline and you can transfer stock as needed between locations.
If you can handle having an item go out of stock online after the online order was made, then you could have ZC always take orders and if you ran out of something contact the customer.
Then you can still keep one location (Your physical inventory) which could keep it simpler.
I believe FA has reports for forecasting, I am not sure, I have not looked, maybe someone else can address that.
All I know is the osC (ZC basis) database
tom
I am talking about the default date range used by Bank Account Inquiry, not reconcile
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
FrontAccounting forum → Posts by tom
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.