Hello All,

Thanks once again for your commitment to making frontaccounting competitive.

I just discovered that when I do a backup, after backup is finished the size of the file is 0. there is nothing in the file. I am using 2.4.11. But when I do backup from phpmyadmin, it works. How do I correct this anomaly.

Thanks.

Popsicles12

2

(1 replies, posted in Accounts Receivable)

Hello All,

How do I include sales discount on Invoice. I know that there is discount in the customer payment module. My challenge there is that when the customer's statement is generated, the discount in not included. So customers are complaining that the discount they are given is not reflected in the Invoice nor their Statement.
How do I correct this?

Thanks.

Popsicles12

Hello All,

I discovered that when I use Standard Cost as my basis of Costing in FrontAccounting, there is still automatic cost update which changes the Standard Cost at interval. Is that standard Cost not working? Please advice.

Popsicles12

4

(1 replies, posted in Reporting)

Good day All,

Thanks for your commitment to making FA robust.
I have this issue with my Reports.
Since we issue a lot of Invoices, I discovered that in the Invoice Report Drop down menu to select an Invoice to print, some of the invoices are not appearing. same with Receipt. how do I get a list of all my invoices generated on the system. Please help out.

thanks so much

Popsicles12

Good day All,

Frontaccounting is getting Interesting and better bu the day. Thanks to Joe and everyone who has made frontaccounting excel so far.
I need to add Shipping Company and Contact name to Only Delivery Note and Packing Slip.

Is this possible? If yes how? KIndly help out.

Thanks.

Popsicles12

Hello @ samsa,

Thanks so much for the modification you helped with in the invoice reporting.

Please I will need just a line input in it. The customers I have they always want to see their outstanding Balance in their new Invoice so that they know the exact amount they are owing. Something Like this

Sum Total                    =       5,000.00
Outstanding Balance   =   251,000.00
Total Amount               =   256,000.00
Allocated                     =   100,000.00
Total Balance              =    156,000.00

Please make the spacing uniform so it can also contain the usual number of lines for product inputs

Please kindly help out.

Thanks in advance

Popsicles12

7

(9 replies, posted in Setup)

Hello @ Joe & @apmuthu,

Thanks for all the support.

I have read through the wiki for importing Debtors and Creditor. But I dont understand the No. 4 which says "You will need to create a reverse GL journal entry for all these transactions (the sum of them)".
Kindly throw more light on this.

thanks

Popsicles12

8

(17 replies, posted in Reporting)

Hello @apmuthu,

Thank you for the above contribution.
I have done the above and I still have some issues.
I need extra space between the company legal statement and this text. moreso, how can I make it to  be like this

_____________________                                                                                                           ____________________
For: XYZ Company                                                                                                                     Customer Sign

Only on the invoice.
Looking forward to your response

Thanks in advance

Popsicles12

9

(28 replies, posted in Accounts Receivable)

Hello @Apmuthu,

Thanks for your prompt response always.

I need you to attend to this please. It is possible to have the amount in words like this Two hundred and fifty thousand naira and eighty five Kobo other than the usual NGN: Two hundred and fifty thousand and "85/100".

thanks for always prompt response

Popsicles12

Hello Sledge,

This modification is nice. but there is a problem. I did this modification in header.inc, it affected the Receipt header, Delivery header and other Reports. Cant it be done in Just rep107.php so it is on just the Invoice only?

thanks

Popsicles12

11

(8 replies, posted in Reporting)

Hello All,

Thanks for all responses on the Inventory Valuation Report.

Please is there anyway that it can be made to use standard cost instead of average cost for this report. I believe this is very important.

Thanks in advance for a positive response.

Popsicles12

Hello All,

Thanks for your reponses so far.

@ Apmuthu, you suggested I do a new Installation and see if this Standard Cost Alteration still persist. I have installed version 2.4.11 and it still persist.

Please this might sound stupid. How do I enter cost of Good so that when I do Inventory Valuation Report, It uses the standard cost to calculate and not average cost.
Cost when I got value different from my Standard cost which I know is average cost, I updated the Standard Cost but its not reflected in the Report.
Please help out.

Thanks

Popsicles12

13

(23 replies, posted in FA Modifications)

thanks Rafat.

I have installed and activated it for the company and the price is still not editable. What am I missing out?

thanks.

waiting for your response.

Popsicles12

14

(23 replies, posted in FA Modifications)

Hello @Boxgen

Thanks for the solution. I placed it in the extension folder and I have installed it.

How does it work cos i tried editing previous invoices price and products but it has no option of editing as the price field and the product cost field is grey out.

Please assist.

Thanks

Popsicles12

15

(23 replies, posted in FA Modifications)

@ Bozygen
I used the Invoice extension that you modified and put them in the Sales Folder. but this is the error I get.

Warning: include_once(../../sales/includes/cart_class.inc): failed to open stream: No such file or directory in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 23

Warning: include_once(): Failed opening '../../sales/includes/cart_class.inc' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 23

Warning: include_once(../../includes/session.inc): failed to open stream: No such file or directory in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 24

Warning: include_once(): Failed opening '../../includes/session.inc' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 24

Warning: include_once(../../sales/includes/sales_ui.inc): failed to open stream: No such file or directory in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 25

Warning: include_once(): Failed opening '../../sales/includes/sales_ui.inc' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 25

Warning: include_once(../../modules/editable/includes/sales_order_ui.inc): failed to open stream: No such file or directory in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 26

Warning: include_once(): Failed opening '../../modules/editable/includes/sales_order_ui.inc' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 26

Warning: include_once(../../sales/includes/sales_db.inc): failed to open stream: No such file or directory in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 27

Warning: include_once(): Failed opening '../../sales/includes/sales_db.inc' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 27

Warning: include_once(../../sales/includes/db/sales_types_db.inc): failed to open stream: No such file or directory in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 28

Warning: include_once(): Failed opening '../../sales/includes/db/sales_types_db.inc' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 28

Warning: include_once(../../reporting/includes/reporting.inc): failed to open stream: No such file or directory in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 29

Warning: include_once(): Failed opening '../../reporting/includes/reporting.inc' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 29

Warning: include_once(../../modules/editable/includes/addon.inc): failed to open stream: No such file or directory in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 30

Warning: include_once(): Failed opening '../../modules/editable/includes/addon.inc' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 30

Fatal error: Call to undefined function set_page_security() in C:\xampp\htdocs\frontaccount\sales\sales_order_entry.php on line 33

Kindly help out. how do I correct this?

thanks.

Popsicles12

16

(4 replies, posted in Reporting)

@Apmuthu & @dearmosin,

Please kindly attend to my post.

How do I modify my Invoice report to show Total Amount, Amount Paid and Balance
How do I edit Sales Order and Invoice prices as an Administrator of the System after the invoice has been raised. Sales persons may not have such access since I will not enable it in the user access
I need to remove the Stock Code column from the Invoice so the Description is very Clear and not shrink.

Please help.

Popsicles12

17

(4 replies, posted in Reporting)

Good day All,

Kudos to Joe and crew that has made FA what it is today. Excellent job you've done so far.

I needed help for modification of some things in FA to make it flexible in use.

1. Once an invoice is raised, I cant modify the price. sometimes prices are entered and later i may decide to reduce price. But I cant in FA.
2. In my Invoice I need these to appear in my report: Total Price, Amount Paid and Balance. even though I have receipt to that effect.
3. I needed the Invoice body to be extended more to accommodate more lines of items and if possible remove somethings at the bottom.
4. I need to add a Place for Customer Signature & Company Signature
5. I need to remove the Column for the Item code so the description is clearly show instead of it looking clumsy.
6. I also want to remove the ship to address in the Invoice, Receipt and Sales Order
7. I also need auto numbering for both invoice and Sales Order.

Please kindly assist as this is very important to our day to day transaction.

Thanks in advance.

Popsicles12

Good day all,

I am trying to setup frontaccounting to be able to alert me when Customer credit has risen to an amount after about say 30days. How do I achieve this.
More how do I set it up that it will refuse to issue invoice until debts is paid.

Thanks

Popsicles12

Thanks  rafat. noted

Hello Apmuthu,

Thanks for your usual and prompt response.

I am having the same challenge. I have a supplier that is also a Customer and when we do transactions, we do set-off and pay the outstanding depending who is owing.
Now I want a situation where I can have a statement showing me the transactions. i.e. Sales & purchases and now see what the balance is at a given period.

Kindly assist.

Thanks.

Popsicles12

Hello All,

FrontAccounting is good. I like it. There are some things that I need clarifications on.
1. Why is it not possible to change a product quantity on an invoice already issued. If there is a mistake in the quantity of product, One will need to void that invoice and re-enter it again. This I think is laborious.

2. This is also applicable to date. One cannot change the date of an invoice already issued.
Is there a solution to the above question without voiding the invoices and re-entering it.

Thanks.

Popsicles12

22

(28 replies, posted in Accounts Receivable)

Hello All,

Thanks for the beautiful feature. I have the Amount in Words working in my invoice print-out. Can any one assist in the changing the fraction side to proper wording.
For example if my currency is Dollar then the fraction is cents. can it be done in such a way that the cents will be in words and not 00/100. NGN: One Hundred and Eighty-Nine Thousand and "00/100".

Thanks.

Popsicles12

Hello All,

With FA, It is possible to enter a new customer on the fly on the Invoice without having to go through the Sales -> Add and Manage Customers?

Kindly Assist.

Thanks

Popsicles12

24

(1 replies, posted in Reporting)

Hello Everyone,

So nice to be in this FA community. It is a very good software.

I want to know how I can generate my Daily sales Report, Weekly Sales Report and Monthy Sales Report.

Kindly help out.

Thanks

Popsicles12

25

(2 replies, posted in Reporting)

Thanks kvvaradha,

Solved my problems.