1 Reply by damiantaylor

(3 replies, posted in Accounts Payable)

Thanks for the help RodW!

Quick entry seems like a good idea! My situation is slightly different though in that the costs are split across 2 suppliers rather than 1 so I can't use a quick entry.
I'm still going to set one up though for the future smile

I think the only way to do this is to just do it with journal entries.

Am I right in thinking FA doesn't have a separate purchase ledger entry screen or a sales ledger entry screen, it is all done by the journal entry screen?

Go to forum: Accounts Payable

2 Topic by damiantaylor

(3 replies, posted in Accounts Payable)

We buy goods from two suppliers in the US but because of shipping charges we don't have the goods shipped directly to us, we use an agent instead.
The suppliers ship the goods to the agent in the US, and the agent ships both sets of goods to us in the UK.
When the goods reach the UK we have to pay import duty and VAT as well as the delivery charge to the agent.

I have been told by my accountant I should deal with the 2 purchase orders as normal, then use the purchase ledger to deal with the agent's delivery charge, Import duty & VAT.

I initially thought this would mean I just raise a purchase order as if I am purchasing a service rather than an item from the agent but now I've come to actually do it I'm stuck!

What is the correct way to account for the agent fees/import duty & VAT using FA?

Go to forum: Accounts Payable

3 Reply by damiantaylor

(3 replies, posted in Accounts Payable)

Thanks Joe, that works smile
Is this normal behaviour for foreign currency purchases? It would be nice if they behaved in the same way as default currency purchases.

I was reading other threads and thought this guy may have been having the same porblem...https://frontaccounting.com/punbb/viewtopic.php?id=1952

Go to forum: Accounts Payable

4 Topic by damiantaylor

(3 replies, posted in Accounts Payable)

When I enter a purchase order for a supplier in my default currency (GBP), I can then receive, process the invoice and pay the supplier.
On the payment screen (Payments->Supplier Payment Entry), the outstanding bill is shown as 'Supplier Invoice' along with the amount to allocate.
I can then just click the 'All' link to pay the bill amount.

If I do the same process with a supplier in a different currency (I've tried it with EUR and USD), the payment screen does not show any outstanding bill.

It could be that I've missed a setting or does this sound like a bug?
I have set $go_debug to 1 in config.php when I go through the process and saw no error messages.

Is there anything else I can try to get this working?

Go to forum: Accounts Payable

5 Reply by damiantaylor

(5 replies, posted in Accounts Payable)

While we're on this subject, I have a couple of discounts against Freehold Property in my GL transactions.
Can I just use phpMyAdmin to change the records in table gl_trans or will I need to void the transactions and do them again?

Thanks Joe

Go to forum: Accounts Payable

6 Reply by damiantaylor

(5 replies, posted in Accounts Payable)

Joe, it's ok I've found it!
I hadn't noticed the 'Purchase Discount Account' against this particular SUPPLIER was set to Freehold Property.
I had seen the setting in Setup->System and General GL Setup and forgot there was an override against each supplier.

Once I'd corrected that, it was all working smile

Sorry to waste your time

Go to forum: Accounts Payable

7 Reply by damiantaylor

(5 replies, posted in Accounts Payable)

Hi Joe,
I have done that and through the proceduce again, and here is the GL transaction:

Account Code     Account Name                                Debit               Credit
2100                     Creditors Control Account      1,471.10   
0010                     Freehold Property                                                  400.00 
1200                     Bank Current Account                                       1,071.10 
Total                                                                          1,471.10          1,471.10 

Is there a log somewhere that I need to look in for errors or would there have been messages on screen if anything strange happened?

Go to forum: Accounts Payable

8 Topic by damiantaylor

(5 replies, posted in Accounts Payable)

When entering a payment to a supplier, the discount I have entered is coming up in the GL enquiry against account 0010 Freehold Property.

In Setup->System and General GL Setup I have Purchase Discount Account set as 5201 Discounts Taken.

Have I missed a setting somewhere or could this be a bug?

Go to forum: Accounts Payable

9 Topic by damiantaylor

(2 replies, posted in Accounts Payable)

Is it best to add a quick entry called 'Discount' so when entering the Supplier Invoice I can enter the discount amount there like I do with shipping cost, or is it better to wait until the Payment to Suppliers stage where I can enter the discount into the discount field?

Go to forum: Accounts Payable

10 Reply by damiantaylor

(4 replies, posted in Items and Inventory)

Hi Joe,
Can you point me at the specific place in the Wiki?
I have read the section on Purchase Prices that shows me how to set up with a single suppliers UOM but I would need to break a single bulk item in to 2 separate sale items.

It's a bit of a tricky one so I'm not expecting FA to be able to deal with it, I'm just putting the question out there in case it can smile

My workaround is to remove one of the items from sale so I only need to break a bulk order in to 1 product.

Can you confirm whether or not FA can break a bulk purchase in to more than 1 sale item?

Go to forum: Items and Inventory

11 Topic by damiantaylor

(4 replies, posted in Items and Inventory)

Hi guys,
I buy a box of 24 bars of wax and sell them either as a set of 4 or a set of 8.
How do I set this up in FA?

In my stock items I have product A which is 4 bars of wax and product B which is 8 bars.
I have my purchase pricing set like this:
product A Supplier's Unit as 1 with a conversion factor of 6
product B Supplier's Unit as 1 with a conversion factor of 3

If I'm correct in what I've done, when I buy 1 box of product A, FA will only let me sell product A.
In reality I would break the box of 24 in to 2 x product A (4 bars) and 2 x product B (8 bars).

Is there a way to do this?

Go to forum: Items and Inventory

12 Reply by damiantaylor

(2 replies, posted in Accounts Receivable)

Thanks Janusz,
From what I could see, when I select a customer it pulls the address into the form form me so I should be able to tell if I have the right one or not, but I haven't explored the whole of FA yet so there could be places where that doesn't happen!

If it gets a problem I could always make the debtor ref unique manually but at least changing to non-unique will allow me to import all my customers from my cart smile

Thanks a lot for your help!

Go to forum: Accounts Receivable

13 Topic by damiantaylor

(2 replies, posted in Accounts Receivable)

Hi guys,
I've been reading post https://frontaccounting.com/punbb/viewtopic.php?id=1510 and have a similar problem with debtor_ref being unique.
I'm importing customers from Zen Cart using zen_import and noticed that if 2 customers have the same name, the import assumes they are the same person.
After a bit of digging I realised it is because debtor_ref on the debtors_master file must be unique.

I know we definitely have separate customers that happen to have the same name so my question is simply, if I remove the uniqueness of debtor_ref using MyphpAdmin, will that cause an issue?

Thanks for your help!

Go to forum: Accounts Receivable

14 Topic by damiantaylor

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

I've finally found why I couldn't activate zen_inport!
There's a typo in either the code or the installation folder name, depending on which way you look at it smile

In the code, everything seems to be looking for /modules/zen_orders but the installed folder is /modules/zen_import.

When I renamed the folder to /modules/zen_orders I was able to activate and access this mod!

Go to forum: Modules Add-on's

15 Topic by damiantaylor

(1 replies, posted in Setup)

Hi,
I couldn't find a suitable forum to post this in so I hope this isn't too far off topic!

I'm evaluating an accounting solution for my company.
I've played around with Phreebooks and have found it to be very good but I'm getting really frustrated with the support/community over there. Basically, you rarely get an answer to your questions. It is no good having a great system if nobody knows how to use it!
All this has led me to think maybe Phreebooks isn't the one for me, then I stumbled across FrontAccounting which seems to be equally impressive smile

While using the FrontAccounting demo, I noticed a few differences between the two systems that I hope someone can help me with.

1. Vendor Deposits.
In Phreebooks, if I have to pay for goods up front, I create a purchase order, then create a Vendor Deposit for the bill amount, then when I receive the goods I pay the bill using the vendor deposit.
Is there a similar system in FrontAccounting?

2. Journal Entry
In Phreebooks, when I enter a transaction in the General Ledger, I have 2 rows as it is a double entry system. I have to debit one account and credit the other.
When entering a transaction in the journal in the FrontAccounting demo, there was only one row to enter data. How do I keep the debits and credits balanced in FrontAccounting?

Thank you for your help!

Go to forum: Setup