@ Apmuthu Thanks for your response. Please how does this works?

thanks

Popsicles12

Thanks @apmuthu for your continued support.
Is it not possible for the system not to issue invoice when the value on invoice is above the limit or the out standing debt and additional invoice exceeds the limit?
This is what I expected to see when I set the customer credit limit.
Please help.

Thanks.

Thanks @apmuthu for your response.

I don't understand what you mean. But this is what happens.
I put a customer credit limit for 150,000. I decide to raise invoices of 250,000. The invoice was raised without restriction.
What happened next was that when I tried to raise another invoice for same customer I see that the credit limit is the difference of the amount raised and the limit and it is negative and in red.
I thought it will prompt me that i have exceeded the limit for the customer.
How can this be achieved.

Thanks.

Expecting your kind response.

Hello All,

How do this feature works in FA. I have inputted an amount as Credit limit for Customers. It seems not to work as invoices are being issued even when the amount is exceeded. Where do I indicate that the system should not issue invoices when an amount is reached? Once the customer pays his outstanding, the system begins to issue invoice to such customer.

Thanks for your prompt response

Popsicles12

@ Apmuthu Thanks for your response. I will see how I can combine both reports to get what I want.

6

(5 replies, posted in Reporting)

Hello Apmuthu,
Thanks for your timely response. Please can you let me know the files I am supposed to edit and the lines to comment out?

Thanks in advance

Popsicles12

7

(5 replies, posted in Reporting)

Thanks Apmuthu for your timely response.

I dont get what you mean by just blank the heading.

I needed to remove some headings and also their contents in the table. Please kindly explain.

Thanks so much

Popsicles12

8

(5 replies, posted in Reporting)

Hello All,

Kudos to our developers. You guys are great.

I needed to modify the Invoice layout. I wanted to remove the Stock code from the invoice printout so that I am left with Item description, Quantity, Unit, Price & Total while  Code and discount is removed.

Can someone show me how to do this.

Thanks.

Popsicles12.

Hello all,
I am tryring to locate the Inventory Adjustment entered in FA so I can edit it. How do I find it. I printed stock list or stocksheet  but it does not have cost price & selling price attached to it. How do I do that.
thirdly, I am trying to locate cost update in the Void list but it is not there anymore. was it intentionally removed. I am using 2.4.18.

Thanks for your continued support.

Popsicles12

Thanks @Apmuthu for your reply.

You are right when it is a manufacturing Company. This is just a sales company that does not do manufacturing. It is a buying and selling business.
So how can this be achieved?

Thanks and expecting your reply.

Popsicles12

Hello All

Thanks so much for the continued support.
Please I will need a line input in my invoice. 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

Outstanding Balance   =   251,000.00
Sum Total                    =     5,000.00
Total Amount               =   256,000.00
Allocated/Payment       =   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

Good day all,

I am helping someone to setup Frontaccounting for his small business.

I am entering his opening inventory and I used Inventory and the Inventory Adjustment GL  for the Items. Now after entering the Inventory its showing NIL. As I check the GL transaction, debit & credit is Inventory.

Please which account do I use as Inventory Adjustement GL. Do I create one or use the Purchase Price Variance that is used as default by FA.

thanks

Popsicles12

13

(2 replies, posted in Reporting)

Hello All,
Happy New year everyone.
I just discovered that when I do my backup in FA, It backup fine. But when you look at the backup file, it is empty. Its Zero.

How do I correct this?

Popsicles12

14

(3 replies, posted in Items and Inventory)

Please not the file attached here is the first screenshots while the file in the previous file is the second screenshot.

15

(3 replies, posted in Items and Inventory)

Hello All,

Joe and all team members, you guys are doing a fantastic Job.
I am having issues with Inventory import. I exported an Inventory item files in Front Accounting to import it in another instance and this is what it showed me.

Please kindly help out.

Thanks.

Popsicles12

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

17

(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

19

(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

22

(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

23

(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

24

(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