Hi,
I am trying to understand the correct posting type to make on Front Accounting. We came from using Sage 50, which basically had 2 options, Pay Purchase invoices or Pay Expenses. The system works great for supplier invoices where you have inventory and then pay the supplier. The issue seems to be with 'Expense' payments. If we just put these down as a Supplier Payment the amount come allocated to the Accounts Payable, making this incorrect, the correct expense nominal account isn't posted and the supplier balance goes into a minus. It would appear we would need to first post an invoice and then a payment to make this work correctly. If we post these payments under Bank and General Ledger as a Bank Payment and select a supplier payment (to log onto the correct supplier account) then although the correct expense nominal account is posted the Supplier account shows a minus. Should the system create an expense invoice on the supplier account to counter act the payment to bring the balance to zero?
We have spent a year incorrectly posting expense invoices and need to rectify these. More importantly we need to make sure we post these correctly going forward.
Any help you can provide would be very helpful.
Thanks,
Steve
1 09/10/2015 05:38:35 pm
Topic: Supplier Payment v Bank Payment (4 replies, posted in Banking and General Ledger)
2 07/13/2015 03:09:02 pm
Topic: Item Number field length (2 replies, posted in Items and Inventory)
Hi,
I need to extend the item number field length from 20 to 25. How easy it this to do? I can amend the database, but know the php needs to be changed. Will all the associated pages that use the item number need to be changed or have you made it easy for this change?
Many thanks,
Steve
3 04/23/2015 04:09:18 pm
Topic: Sales customer set up (2 replies, posted in Reporting)
Hi,
We have recently started using a code for the customer short name, to enable us to easily find customers. We have noticed that the contact is created from the information entered but seems to be matching fields incorrectly. Eg.. If we create a new customer, John Smith, we would use 'John Smith' in the customer name field and 'smith-joh-123456' in the short name field. When the Contact is created it shows as.... Reference = John Smith and Full Name = smith-joh-123456. Therefore, when you send an invoice via email, the system pulls the full name from the contact.... 'Dear smith-jon-123456'. We have to remember to go back in and amend this.
Is this correct?
Should the system update the fields the other way round?
Many thanks,
Steve
4 03/18/2015 08:06:02 pm
Re: FA Planet announced (www.faplanet.pl) (17 replies, posted in FA Modifications)
I have just installed this in a demo site to play with it. I love where this is going mainly for the extra search facilities for finding customers etc.
I would switch over to this option in a heartbeat once the final version is available!!
Steve
5 02/26/2015 08:36:53 pm
Re: How to amend Purchase Order PDF (2 replies, posted in Accounts Payable)
I have managed to sort this. Just for everybodies info I amended page /reporting/includes/header2.inc line 156 and changed to:-
// address2
$this->row = $temp;
// Added by Steve to not print company name if N/A
if ($Addr2 == "N/A") {
$this->Text($mcol, $Addr2['name']);
$this->NewLine();
}
$this->TextWrapLines($mcol, $this->rightMargin - $mcol, $Addr2['address']);
Regards,
Steve
6 02/26/2015 06:38:22 pm
Topic: How to amend Purchase Order PDF (2 replies, posted in Accounts Payable)
Hi,
I need to amend the layout of the Purchase Orders very slightly. When we have a different delivery address the system always prints out the customer name as the first line. When we place orders for drop ship direct to customers, we don't want our company name appearing. I want to set up the code to print the company name if this section is blank (or N/A which is the default) anything else in this section should just be what's been entered. What file needs to be amended for this please.
Thanks,
Steve
7 12/23/2014 04:59:35 pm
Re: Supplier Invoice GL entries going to Inventory Adjustment (1 replies, posted in Accounts Payable)
Please disregard my post.
I have discovered that the correct GL accounts are adjusted on delivery (Direct GRN), with the Adjustment account being the other side of the posting. This then gets counter acted when the invoice is posted.
Thank you,
Steve
8 12/23/2014 04:47:39 pm
Topic: Supplier Invoice GL entries going to Inventory Adjustment (1 replies, posted in Accounts Payable)
Hi,
I have just noticed that all the supplier invoices that we have been entering have all been going to the Inventory Adjustment GL account and not the associated GL accounts as set up in the Inventory file. I have also checked the supplier account to make sure this has been set correctly and it is (Purchase Account: Use item inventory/COGS Account).
Any idea on why this is posting to the GL in this way?
Thanks,
Steve
9 10/01/2014 06:22:43 pm
Re: The entered transaction does not exist or cannot be voided. (13 replies, posted in Accounts Receivable)
Thanks Joe,
Do I also need to make a entry in the voided table?
Steve
10 10/01/2014 02:31:22 pm
Re: The entered transaction does not exist or cannot be voided. (13 replies, posted in Accounts Receivable)
Hi Joe,
2.3.21 Build 01.07.2014.
Steve
11 09/30/2014 08:27:27 pm
Re: The entered transaction does not exist or cannot be voided. (13 replies, posted in Accounts Receivable)
Hi Joe,
No. We would have produced an invoice and allocated the payment at the same time (POS). We then voided the invoice as this was incorrect. We cannot now void the payment for some reason. We have done this many times where we have had to voice the invoice then the payment without issue. I cannot figure out why we get the error when we try and void this payment.
I am happy to manually do this in the database if we can't figure out the reason why, I just need to be sure I do this correctly!!
Cheers,
Steve
12 09/30/2014 07:26:44 pm
Re: The entered transaction does not exist or cannot be voided. (13 replies, posted in Accounts Receivable)
Hi Joe,
I tried this but the transaction already shows as unsettled. I am still not able to void this transaction.
Cheers,
Steve
13 09/26/2014 04:14:14 pm
Topic: The entered transaction does not exist or cannot be voided. (13 replies, posted in Accounts Receivable)
I need to void a customer payment, the invoice has already been voided, but I am receiving this error when I try to void it:-
The entered transaction does not exist or cannot be voided.
I have checked the tables and everything looks ok, so not sure why I am receiving this error. Can you tell me the process and tables that are altered when doing a void customer payment, so I can manually do it in the database please.
Thanks,
Steve
14 08/12/2014 11:32:46 pm
Re: Decimal places of prices (14 replies, posted in Setup)
This would definitely be a useful amendment to the system. We have a supplier who have unit prices of products to 4 decimal places but the line total is 2 decimal places. Obviously when you are dealing with pricing you can't have partial pennies (more that 2 decimal places) but you often find product unit prices to have 3 or 4 places.
We are new to FA (but find it an all round great product) and our old system worked in this way. This way you always have posted invoices on the system that match your suppliers.
Would be grateful if you could consider this for a future update.
Steve
15 07/30/2014 05:07:22 am
Re: No item code on printer Purchase Orders (3 replies, posted in Report Bugs here)
Ok, thanks Joe. That does kind of make sense for sure. Can I suggest that if there is no suppliers item code set up, the report use the system default item code instead.
I did try this for one of the items we currently have on a PO and it did in fact display the suppliers item code but now no description. The field states item code or description, so do you have to put both in this field to print on the PO?
Steve
16 07/29/2014 03:29:07 pm
Topic: No item code on printer Purchase Orders (3 replies, posted in Report Bugs here)
Hi,
We are new to FA and have just noticed that the item code does not print out on PO's. There is a heading for the Item code but under it is the item description. I need to fix this ASAP.
Thanks,
Steve
17 07/14/2014 04:35:28 pm
Re: Cash account selection in Sales > Direct invoice (9 replies, posted in Accounts Receivable)
Hi Janusz,
Actually most web site orders are on the same payment date as the invoice as the customer has to pay when entering on the order. We do really need to have the payment account option on the direct invoice screen otherwise we have to go through another process to enter on the payment. We are switching to FA to reduce the amount of data entry we do. At the moment we have created different log in names for each of the different payment options (Amazon, PayPal, Credit, etc.), which is not ideal but works. Could this be done in a later build or could we add this functionality now?
TM; Thanks for your reply, we are also in the process of adding Cartspan to completely integrate our online shop to FA, which should eliminate 90% of the data entry.
Steve
18 07/11/2014 04:10:01 pm
Topic: Voiding Customer Invoices & Stock (1 replies, posted in Report Bugs here)
We have had to void a customer invoice and notice that FA did not return the stock items back into stock. Should this happen or did we do something wrong?
Steve
19 07/10/2014 02:08:58 pm
Topic: Credit items no appearing as a credit in Payments to Suppliers (1 replies, posted in Report Bugs here)
Hi,
I have recently switched over to FA. We have entered a credit note from a supplier by simply adding a - in front of the unit price. Firstly is this the correct way of entering a credit? Some systems require you to enter a - in front of the quantity to create a credit. I have looked at the posting and it appears to have gone in the GL correctly.
When we not go to the Payments to Suppliers section to log a payment and add the credit (which does not appear as a credit) it is added to the payment not subtracted.
Have we done this initial entry incorrectly or is there a bug in the system?
Thanks,
Steve
20 07/08/2014 03:12:24 pm
Re: Cash account selection in Sales > Direct invoice (9 replies, posted in Accounts Receivable)
Most of our business is done via our web site therefore when we enter invoice on to the accounts system these are all paid. We need to post where this money has come from, i.e. credit card, PayPal etc. This way we know where our money is and who owes it to us. The customer has paid, as far as he is concerned, so we need to note this when entering on the invoices.
We currently use Sage 50 and when we enter on a web site order, we select payment by 'cash' and the correct bank account i.e. Credit Card or PayPal. There doesn't appear to be a way to make an immediate payment of an invoice into a particular 'cash' account.
21 07/03/2014 07:03:46 pm
Re: Cash account selection in Sales > Direct invoice (9 replies, posted in Accounts Receivable)
Hi Joe,
Unfortunately it wont as I really need to be able to select different POS per transaction. Each user will have to allocate the payment to the correct account as the one POS per user will not work for us. Any way of having a selection box for this like the payment option?
Cheers,
Steve
22 07/03/2014 05:36:49 pm
Topic: Cash account selection in Sales > Direct invoice (9 replies, posted in Accounts Receivable)
Hi,
We are just in the process in switching over to Frontaccounting. We accept orders and get paid in several different ways. We would like to change the cash account that payments are logged to when creating a direct invoice. At the moment if I select Cash only for Payment, the Cash payment section displays the cash account set up for the users POS. Oue users allocate payments the the correct accounts, Paypal, Credit Card etc...
Is there a way to do this?
Thanks,
Steve