26

(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

28

(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

29

(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

30

(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

31

(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

32

(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

37

(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

39

(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

40

(2 replies, posted in Reporting)

Thanks kvvaradha,

Solved my problems.

41

(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

Hello kvvaradha,

Thanks for your reply.
Once this process is done. How do I make sure this issue does not reoccur?

thanks. expecting your reply.

Popsicles12

hello kvvaradha,

Thanks for the response. But I dont get it. How do i get cost update entry? Kindly assist cos after a while the inventory report begins to give negative profit margin. On the report you see the Cost far higher than the Selling price.

I will be waiting.

thanks

Popsicles.

Hello Apmuthu,

Thanks for your reply.
I am thinking the problem with this report is due to the fact that I have been upgrading the software from version 2.3.6 to 2.4.6.
Is that the cause? if yes what do I do.
Do i do a new install and just pick the beginning balance for a for a fresh installation?

Kindly advise.

thanks

Popsicles12

Good day All,

Found the Payroll module very nice and an added advantage for FrontAccounting. When I setup the Payroll module I discovered that in Adding an Employee, there is no payment Details where Basic pay, medical allowance, etc.

Moreso, when you create an Employee there are no extra tab with information about the employee. Did I not set it up well or what am I doing wrong? I am using version 2.4.10

Thanks.

Expecting a response.

Popsicles12

Hello Apmuthu,

I am back again with the issue of Sale Report. I will show you the report for November 2021. It is show a negative Contribution (Profit per product). There are selected products that has this issue. I do not know why? It always brings negative contribution. How do I correct this anomaly.
How do I prevent this from re-occurring?
1. did I forget the standard cost i.e. make it zero so that the purchase price is used as cost?
2. do I always change standard cost whenever there a new purchase?

Now I need to rectify this. I need to file in the database that I need to manually correct these cost to reflect the true picture of the profit per product. This is crucial as it is used to know the product that performs well in terms of sales and profit margin.

thanks apmuthu.

expecting your response soonest.

Popsicles12

Good Day All,

Migrating from another accounting system to Frontaccounting, I am confused about the beginning balances. Are we using BALANCE SHEET for the journal entry for beginning balance or TRIAL BALANCE.

Please Clarify.

Thanks

Popsicles12.

Thanks Notrinos for your response. But it is not working. I have done that about 10 time and the error remains thesame.

It is not working. Can anyone help me for this has made us remain on a standstill.
Pls.

Thanks.

Popsicles12