exactly
252 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
253 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_ ?
254 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
255 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
256 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
257 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
258 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
259 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
260 06/24/2009 01:18:35 am
Re: Automatic Payment Allocation (4 replies, posted in Accounts Receivable)
If I edit the branches and set receivables_account to 1500 directly is that sufficient to change the A/R account for all customer?
I think so, but before manually modifying the db thought I better ask...
tom
261 06/20/2009 07:11:30 pm
Re: Reverse Customer Payment (2 replies, posted in Accounts Receivable)
I did not expect to find it under śetup... it worked fine
tom
262 06/19/2009 01:48:48 pm
Topic: Reverse Customer Payment (2 replies, posted in Accounts Receivable)
I entered a payment twice...
now I need to remove the extra one...
Should I just issue a payment to the customer?
tom
263 06/19/2009 01:46:16 pm
Topic: Automatic Payment Allocation (4 replies, posted in Accounts Receivable)
I saw in the code a comment like this:
If the Customer's A/R Account is a Bank Account then automatically allocate the payment
(Which looks nice since I only ship on paid invoices)
But when I look at Customer Allocations (sales/allocations/customer_allocation_main.php)
it shows the whole payment is left to allocate...
Maybe the comment is not accurate...
tom
264 06/15/2009 04:30:00 pm
Re: Work Order Flow (4 replies, posted in Manufactoring)
It would help a lot if manufacturing/work_order_entry.php had an Item Code input.
Right now the only way to select an item to manufacture is the pull-down
Also why does line 328 have $dec = 0; thereby forcing the quantities to be whole numbers?
Why not use the decimal places of the UOM of the item we're manufacturing?
tom
265 06/12/2009 03:31:07 pm
Re: Bank and Cash should not come in Journal transaction..! (6 replies, posted in Report Bugs here)
It does not need a new MYSQL database, it just adds a new set of tables with a unique prefix (0_, 1_, 2_ etc)
266 06/11/2009 10:38:55 am
Re: Bank and Cash should not come in Journal transaction..! (6 replies, posted in Report Bugs here)
Why do you say it is not multi-user?
You can create additional companies when logged in as admin under setup.
tom
267 06/11/2009 10:35:36 am
Re: negative inventory adjustment (6 replies, posted in Items and Inventory)
Maybe we need to look at WHY the manufacturing process did not work.
In my site I buy in 20kg buckets and repackage into 1/4, 1/2, 3/4, 1 and 5 lb packages.
I do two processes, first I manufacture my 1 x 20kg into 44 x 1lb and then
build the other products from the 1lb units.
tom
268 06/10/2009 11:00:58 am
Topic: sales pricing shows Foreign Item Codes too? (0 replies, posted in Items and Inventory)
in inventory/prices.php
The first SQL is:
SELECT i.item_code, i.description, c.description, count(*)>1 as kit
FROM
0_item_codes i
LEFT JOIN
0_stock_category c
ON i.category_id=c.category_id GROUP BY i.item_code ORDER BY c.description,i.item_code
And it ends up including foreign item codes in the list as well, which can't have prices
as a check I tried to enter a Sales Order and noticed the Foreign item codes were replaced with the proper stock_id
tom
269 06/08/2009 05:12:04 pm
Re: Printing in Frontaccounting (7 replies, posted in Reporting)
Dumb Question time...
Since all printing is performed at a user's request, what is the advantage of using a network printer over the browser's printer settings?
(Yikes I said ALL, maybe I am making a wrong assumption!)
tom
270 06/08/2009 05:09:24 pm
Re: Import an inventory list from a csv file (16 replies, posted in Items and Inventory)
You can use anything (without spaces is best)
item_import
is good.
I think that field is in there so you can install more than one version of a given module
item_import1
item_import2
Why you'd need to do that I am not sure, but the flexibility is there.
You then go to the Menu Tab you selected (Items and Inventory) and click on the Name you have it (Items Import)
Select the GL Accounts you want to use for the items, etc.
Make sure you use the right Field separator. The default is ;
I personally use ,
The browse to the CVS file on your local system that you prepared
click Import
Warnings and errors will be noted and a summary of the number of updates made.
Tom
ps. I prefer to answer things here, so others can use the information too
271 06/05/2009 03:11:58 pm
Re: email POs etc (3 replies, posted in Report Bugs here)
Maybe we need to add a parameter when adding an attachment (for each part) or maybe derive it from the file extension.
My mail reader looks at the content type to decide what program to use to open it...
winzip does not know how to handle PDF files...
tom
272 06/05/2009 10:53:13 am
Topic: email POs etc (3 replies, posted in Report Bugs here)
Why does class.mail.inc use Content-Type: application/x-zip-compressed;
We are attaching a PDF document.
Why not use Content-Type: application/pdf;
tom
273 05/29/2009 02:14:17 am
Re: Supplier Invoice (5 replies, posted in Accounts Payable)
How do Quick Entries work?
I created one and I see it on the Enter Supplier Invoice page and I add items to the invoice and enter a number in the Quick Entry and click GO and nothing appears to happen.
What am I missing?
274 05/29/2009 02:03:01 am
Re: Paypal Payments (8 replies, posted in Accounts Receivable)
I am still not comfortable with this... there is a big difference between a cash incentive I give ("Prompt Payment Discount") vs a Hard expense I have to pay no matter what... Bank Processing fee... be it Paypal fee, or wire transfer fee.
tom
275 05/28/2009 02:38:19 pm
Re: Paypal Payments (8 replies, posted in Accounts Receivable)
It looks like it will work ok for me.
For Paypal Payments:
Enter the NET payment in the Amount: field
Enter the Paypal Fee in the Amount of Discount: field
thanks
tom