1

(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

4

(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

5

(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

6

(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

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

10

(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

11

(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

12

(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

13

(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

14

(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

19

(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

21

(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

22

(2 replies, posted in Reporting)

Thanks kvvaradha,

Solved my problems.

23

(2 replies, posted in Reporting)

Good day All,
I am trying to implement the sales person commission in my office where for every service rendered, a commission is paid to the staff who does that. E.g. I have a salon and for every hairdo, the stylist gets a percentage of the payment. If I use the sales person, how do I know how much the sales person gets at the end of the month. I mean how do I get the report show the total amount of his commission. If this is not going to work, how do I implement it so I can generate the amount for every stylist at the end of the month.

thanks.

Popsicles12

Thanks kvvaradha,

I am most grateful for your prompt reply. I will attach the report for you to see. Then I am thinking I will install the latest version maybe version 2.4.10 or 2.4.11 and get my opening balances and enter them and start afresh.

When I do this, do I still need to enter any standard cost or I just enter the purchase prices and the selling prices and let the software do the calculation for Standard Cost or I just enter a standard cost which can be changed say once or twice yearly.

With these scenarios, what will be the resultant effect on this very report "INVENTORY SALES REPORT". This report is very critical to our business as it tells us what Product is fast selling and what product we make good profit.

I will be expecting your reply.

Thanks

Popsicles12

Thanks kvvaradha for your prompt response.

I know Frontaccounting uses Standard cost. Why do the Cost change over time when you try to get your Inventory Sales Report. This report is so valuable to me because it shows the performance of all products. they one that is fast selling and the one with the most profit.
So how do I configure it to make sure it adheres strictly to the standard cost or do I just leave out the standard cost. so It uses the purchase price and the selling price to calculate the profit per product or what do you think.

Since my installation has gone through several upgrade, do I do a new installation. In so how do I correct this nomaly?

expecting your reply

Thanks

Popsicles12