126 Reply by tom

(4 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

127 Reply by tom

(13 replies, posted in Reporting)

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

Go to forum: Reporting

128 Reply by tom

(4 replies, posted in Banking and General Ledger)

I am talking about the default date range used by Bank Account Inquiry, not reconcile

Go to forum: Banking and General Ledger

129 Topic by tom

(4 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

130 Reply by tom

(40 replies, posted in Report Bugs here)

That fixed it

Thanks!

Go to forum: Report Bugs here

131 Reply by tom

(13 replies, posted in Reporting)

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)

Go to forum: Reporting

132 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

133 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

134 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

135 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

136 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

137 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

138 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

139 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

140 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

141 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

142 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

143 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

144 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

145 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

146 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

147 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

148 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

149 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

150 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