in the top level I am doing a
cvs -q update -PAd
That should get everything... maybe you did not commit the file?
There is a special state for Added files that have not been comitted.
tom
202 10/21/2009 11:16:44 am
Re: 2.2 release (15 replies, posted in Announcements)
joe wrote:
Yes, there are db changes, but maybe you don't need to update your modules. You can check the file alter2.2.sql to see if there are changes to be fixed in the modules.
/Joe
I do not see a alter2.2.sql file, so I assume there have been no DB changes..
tom
203 10/19/2009 11:02:48 am
Re: osCommerce (59 replies, posted in Modules Add-on's)
The osC ProductsID must match the FA ItemID.
If you run the osCommerce 'Price Check' it will point out errors
I have noticed that I do not resolve some Item Codes properly.
ex. osC AL-075M is really FA HA-60 it does not resolve properly.
I will look into that too
204 10/11/2009 01:14:51 pm
Re: request to adjust the csv item importer (7 replies, posted in FA Modifications)
I have a number of additions to the importer, but got side tracked.
I will get back to it soon
tom
205 09/28/2009 10:58:00 am
Re: 2.2 release (15 replies, posted in Announcements)
I lost track. Have there been (or are they any planned) db changes in the 2.2 release?
I may need to update my modules if there are.
tom
206 09/02/2009 10:42:05 am
Re: OSCommerce Integration (2 replies, posted in Jobs wanted/offered, non-free offers)
I have all those things implemented in the module I created.
If you need help getting it working, let me know
tom
208 08/20/2009 12:31:02 am
Topic: PO Receive Items (2 replies, posted in Accounts Payable)
When receiving items and you enter the Q of this delivery and hit update, shouldn't the Value of items received be updated?
tom
209 07/21/2009 11:33:56 am
Re: Bank Account Payment Entry to Customer (9 replies, posted in Banking and General Ledger)
I think everything was ok in this table.
"9";"13";"1";"1766";"1859";"2009-06-23";"2009-06-23";"8";"1";"13";"7.1";"0";"15";"0";"0";"0";"1";"1";"24";"0";"0"
"14";"12";"2";"1766";"1859";"2009-06-23";"0000-00-00";"8";"0";"0";"0";"0";"0";"0";"0";"0";"1";"0";"0";"0";"0"
"24";"10";"0";"1766";"1859";"2009-06-23";"2009-06-24";"8";"1";"13";"7.1";"0";"15";"0";"0";"22.1";"1";"1";"9";"0";"0"
No negative numbers and allocation =0 on all but the last.
I ended up editing debtor_trans alloc=0 for the problem records.
tom
210 07/18/2009 03:41:13 pm
Re: Bank Account Payment Entry to Customer (9 replies, posted in Banking and General Ledger)
Joe,
Does this also include the situation I had?
Customer Branch A/R account = Bank Account
I tried voiding out those transactions and re-entering the customer payment hoping I would then be able to allocate it properly, but I get an error.
There are no unsettled transactions to allocate.
How do I unsettle the transaction so I can get it allocated properly?
tom
211 07/18/2009 03:21:02 pm
Re: Adjust Import items module to import foreign item codes (3 replies, posted in Wish List)
I think the latest version does support that.
I also have a version that I am testing that allows for a single dimension for items.
Once I have that tested I will have it posted.
It also allows for *export* of items as well...
tom
212 07/15/2009 10:51:20 am
Re: Recurring invoice create orders without comment field from template (8 replies, posted in Accounts Receivable)
I had to void an invoice and I was able to recreate a new one with out changing anything else. (I had the shipping cost wrong)
tom
213 07/13/2009 11:28:10 am
Re: osCommerce/Zen Cart Import - separate databases (4 replies, posted in Modules Add-on's)
Actually the module that you downloaded only supports different databases.
I have found that if you are using the same mysql server and username
that php will attempt to re-use the connection, so it is recommended that
you use a different username for the second connection.
I have a version I am cleaning up that also supports havig all the tables in the same database.
As far as which cart is better, let's not dredge up the tep/osc zc history I seem
to recall a lot of flame wars over the how the fork was done and qustions if
ZC violated GPL
tom
214 07/13/2009 11:02:54 am
Re: One invoice & payment received for multiple item sales? (3 replies, posted in Accounts Receivable)
I believe you can do this by using Dimensions.
If you add a Dimension for Hardware and Furniture and then add the proper dimension to each item in the Item's properties (stock_master) you can then
run dimension reports that will break things dwn.
You can even create Quick Entries so you can divide any shipping/handling
charges down by dimension.
(I am fairly sure I am correct... Joe will correct me or clarify 
)
tom
215 07/09/2009 01:42:02 am
Topic: Test search of customer list (1 replies, posted in Wish List)
It would be nice if the places you have a Customer List pull-down
(like Customer Payment) there was a text box where you can start typing the name and it could be selected much like the Stock_ID does on Sales Order entry
tom
216 07/02/2009 05:10:29 pm
Topic: Export Module (0 replies, posted in Modules Add-on's)
I am working on a module to export various items to be imported with the Import Module.
I Expanded the Import because I would need to reload items, etc over and over while I was getting used to things.
I have been using it a few weeks and am changing the way I do some things and want to Export to include a number of changes I made
online but not in my CVS files...
stay tuned
tom
218 07/01/2009 07:49:49 pm
Re: Getting started with development (2 replies, posted in FA Modifications)
There is no 'getting started guide' but I can give a few suggestions...
1) The IDE is your favorite text editor...
2) I often find it easiest to edit the web pages in-place
3) The best way to learn how FA code works is to look at the Downloadable Modules
4) Often a lot of what you want to add can be added via a module
5) using CVS to keep the official code in-sync makes life easier (I like it so when I totally mess up I can do diff's against known good code)
I started improving the Import module and then wrote the module for osCommerce (web store) customer/order import.
I use the import module and Backup/Restore (Setup tab) a lot.
I like to wipe out the db to a known state and re-test things... also helps to look at DB before and after..
helps answer "why did it do THAT?"
that is all I can think of of the top of my head
tom
219 06/30/2009 11:12:34 am
Re: reinstalling FA (6 replies, posted in Installation)
Will the Create Company change the table prefix from 0_ to 1_ ?
220 06/30/2009 11:10:23 am
Re: after invoice added (5 replies, posted in FA Modifications)
I may figure out how to do it directly, but what harm would there be in adding that additional link after invoicing?
Is it a bit ironic, all my customers have payment terms set to Cash Only, no delayed payments
tom
221 06/29/2009 11:00:32 am
Re: after invoice added (5 replies, posted in FA Modifications)
Do you mean Direct Invoice (aka Direct Sales Invoice)?
When I import the orders from osCommerce I create Sales Orders.
I do this for four reasons:
1) They have the greatest flexibility for being modified
2) I have not verified payment (credit card or paypal)
3) They do not cause any Inventory/Stock changes
4) They do not cause any GL changes
Maybe what I need is *Direct Invoice Against Sales Order*
But then again I can get two forms of payment...
(3 if you include cash or check in person)
All three still end up in two different bank accounts... Bank and Paypal
Am I wrong using the Sales Order as the Initial order documentation?
tom
222 06/29/2009 12:28:25 am
Topic: after invoice added (5 replies, posted in FA Modifications)
On the page sales/customer_invoice.php?AddedID=#
It would be nice if there was another link: Receive/Process Payment for Invoice
and have it take you to sales/customer_payments.php? with the correct customer
selected
If it could be real smart (if this makes sense) to maybe show Allocate Payment
if the payment had already been received... of if any unallocated payments were
pending
tom
223 06/25/2009 03:10:03 pm
Re: synchronizing offline databases with online ones (7 replies, posted in Setup)
It might be possible through mysql.
Since we use innodb type we do everything in transactions and I believe there are mysql tools that can be used to sync.
If you do not have access to a mysql expert, let me know I may be able to find one (or figure it out myself)
tom
224 06/25/2009 10:46:29 am
Re: synchronizing offline databases with online ones (7 replies, posted in Setup)
I am not sure what you would gain, but you could do a nightly backup (mysqldump) and then restore that backup to the offline server.
Of course you would not be able to perform any updates to the offline db that would be retained.
tom
225 06/25/2009 02:09:11 am
Re: Automatic Payment Allocation (4 replies, posted in Accounts Receivable)
I was thinking of using phpAdmin UPDATE 0_cust_branch SET receivables_account = '1500' where receivables_account = '1700'
tom