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
226 06/24/2009 01:18:35 am
Re: Automatic Payment Allocation (4 replies, posted in Accounts Receivable)
227 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
228 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
229 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
230 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
231 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)
232 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
233 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
234 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
235 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
236 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
237 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
238 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
239 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?
240 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
241 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
242 05/27/2009 07:49:53 pm
Re: Paypal Payments (8 replies, posted in Accounts Receivable)
That may work, I will look closer at that.
tom
243 05/27/2009 06:59:28 pm
Re: Paypal Payments (8 replies, posted in Accounts Receivable)
Not really.
The customer has an invoice for $68.50 he pays $68.50, so I will expect to allocate that entire payment to his account.
The very act of receiving the $68.50 will incur a processing fee of $2.36 (let's say that is 3% discount rate + $0.30/transaction)
That is a expense that has nothing to do with the customer.
tom
244 05/27/2009 06:52:11 pm
Re: Supplier Invoice (5 replies, posted in Accounts Payable)
I added a Quick Entry for Supplier Invoice/Credit and I do not see how that will generate the desired effect.
It should add to the total I owe that supplier.
It should also add to the Freight Inwards (4300)
I am hoping to not worry about GL Account codes for day to day normal operations...
tom
245 05/27/2009 03:22:27 pm
Re: Supplier Invoice (5 replies, posted in Accounts Payable)
I donno, would I need to enter the invoice and then enter the shipping charges separately?
I figured that a very high percentage of invoices include some form of shipping or handling charge that it would merit adding that field to the form.
I'd like to stay away from the GL area when possible, too many chances for errors (self inflicted)
tom
246 05/27/2009 03:18:51 pm
Re: Paypal Payments (8 replies, posted in Accounts Receivable)
I guess I could, but I like to keep things simple.
I would likely pick the wrong account code and really mess up the books...
I figured it might be a common enough need to warrant an extra field on the page.
I guess I only want to have to THINK about account codes when I need to be the accountant but
more importantly, I don't want to have to think when I am the salesman or getting payments
tom
247 05/27/2009 11:21:19 am
Topic: Paypal Payments (8 replies, posted in Accounts Receivable)
I accept payments basically 3 ways
1) Credit Card
2) Paypal
3) Good old cash/check
#1 and #2 have expenses associated with them
#1 I get billed monthly and can add a misc expense
#2 gets fees with each transaction
So while I want to allocate 100% of the payment to the customer, I also want to enter a 'Bank Charges' item for the fees.
Would it make sense to add a field for this in sales/customer_payments.php ?
A lot of people do use paypal or other payment services.
#3 of course is no problem.
tom
248 05/27/2009 10:49:20 am
Re: Setting Initial Stock, COGS, Balances etc (3 replies, posted in Setup)
As fro #3 it looks like a Bank Deposit will do it.
The default GL Acct is 3000 (Sales) does the acct matter since we're talking about something from the prior year?
249 05/27/2009 10:38:34 am
Topic: Supplier Invoice (5 replies, posted in Accounts Payable)
When I receive an Invoice I typically have a shipping charge.
How should that be entered?
I do see a way to add a GL Entry to go with the invoice, but with shipping
charges (Inward Freight) being relatively common I figured there should
(could) be a field on the Invoice entry form (purchasing/supplier_invoice.php)
tom
250 05/27/2009 10:30:09 am
Re: Setting Initial Stock, COGS, Balances etc (3 replies, posted in Setup)
Well maybe the answer for #2 is to enter a dummy invoice.
If that is correct I will edit my original post