201 Reply by tom

(16 replies, posted in Items and Inventory)

He has sent it to me and I will update the package.

thanks!
tom

Go to forum: Items and Inventory

202 Reply by tom

(16 replies, posted in Items and Inventory)

Thanks for the bug report, I will add the update and have a new version posted for download!

Go to forum: Items and Inventory

203 Topic by tom

(3 replies, posted in Accounts Payable)

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

Go to forum: Accounts Payable

204 Reply by tom

(40 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

205 Topic by tom

(0 replies, posted in Accounts Receivable)

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

Go to forum: Accounts Receivable

206 Reply by tom

(8 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

207 Reply by tom

(8 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

208 Reply by tom

(8 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

209 Reply by tom

(8 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

210 Topic by tom

(8 replies, posted in Banking and General Ledger)

(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

Go to forum: Banking and General Ledger

211 Reply by tom

(16 replies, posted in Items and Inventory)

I will have it this weekend.

I am just finishing up testing

tom

Go to forum: Items and Inventory

212 Reply by tom

(7 replies, posted in Items and Inventory)

The demand is from any sales orders that have not delivered yet.

Directly or indirectly (via BOM's)

Go to forum: Items and Inventory

213 Reply by tom

(6 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

214 Reply by tom

(27 replies, posted in Banking and General Ledger)

This topic should be a wiki page.

Can this annual activity be automated in any way?

tom

Go to forum: Banking and General Ledger

215 Reply by tom

(59 replies, posted in Modules Add-on's)

Got it thanks.

Also the osc import for FA22 has been posted to the downloads section

Go to forum: Modules Add-on's

216 Reply by tom

(59 replies, posted in Modules Add-on's)

I wonder if it would be easy to check the values in setup when enabling roles. (Since they are all listed on that page)

Go to forum: Modules Add-on's

217 Reply by tom

(59 replies, posted in Modules Add-on's)

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

Go to forum: Modules Add-on's

218 Reply by tom

(16 replies, posted in Installation)

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...

Go to forum: Installation

219 Reply by tom

(16 replies, posted in Installation)

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

Go to forum: Installation

220 Reply by tom

(16 replies, posted in Installation)

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

Go to forum: Installation

221 Topic by tom

(16 replies, posted in Installation)

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

Go to forum: Installation

222 Reply by tom

(9 replies, posted in Installation)

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 smile)

it is not generally a good idea to leave *all* your files set to 777

tom

Go to forum: Installation

223 Reply by tom

(12 replies, posted in Accounts Receivable)

Go to Downloads, Module Downloads and look for osCommerce customer and order import

https://frontaccounting.com/wbt/pages/download/download-modules.php

Go to forum: Accounts Receivable

224 Reply by tom

(12 replies, posted in Accounts Receivable)

To keep things flexible for me I stopped at importing Sales Orders, since they do not cause any permanent db changes.

tom

Go to forum: Accounts Receivable

225 Reply by tom

(7 replies, posted in FA Modifications)

jackel7007

Please contact me directly if you are interested in testing the new import/export

tom
(see the EMAIL link to the left)

Go to forum: FA Modifications