226 Reply by seahawk

(31 replies, posted in Accounts Receivable)

Hi

Is it possible to have an edit option on the page where you can Print and or email the recurring invoice after it was created?

Sometimes the dates printed on the Invoice refers to the previous period instead of the new 12 month period (for today plus 12 months).

I now have to go to Customer Transaction Inquiry to fix the period of the recurring invoice.

I have issued the first invoice, 1 /6/2013. The next invoice would be due again on 1/6/2104. In setting up the repeating invoice I have set the start date as 1/6/2013 and then set 12 months in the month column.
It shows up in the Create and Print recurrent Invoices, but when I create the invoice and print it it reads: Invoice covers period 01/06/2013 to 31/05/2014 instead of 01/06/2014 to 31/05/2015.

Some advice here would be appreciated.

Go to forum: Accounts Receivable

227 Reply by seahawk

(28 replies, posted in Banking and General Ledger)

Joe

Tested it on a number of companies and works great for me. Think we can offer it on the extensions.

regards

Go to forum: Banking and General Ledger

228 Reply by seahawk

(14 replies, posted in Reporting)

Thanks.

Go to forum: Reporting

229 Reply by seahawk

(3 replies, posted in Installation)

Janusz

You are correct. It seemed that their was difference in pointing and what we saw on the main domain.

The host then send me a link to the server of the shared account that is a temporary link. The install was then successful and the site is reading the version file correct. It also seems that after the server crash the PHP and Mysql was not installed correctly. Once they host fixed that the problem was resolved.

Thank you for everyone's help.

big_smile

Regards
Wynand

Go to forum: Installation

230 Reply by seahawk

(4 replies, posted in Installation)

Janusz

The server crashed and the hosting provider reinstated a backup to the website. I then upgraded the FA on the site but for some or other reason that is still not clear to me, it seemed that the information on the hosting account was duplicated on another server linked to the main server PC.

I deleted the FA files but on refreshing the browser it kept on running with the old info.

I then removed the complete installation and database. I created a new database and did a complete new install. On the main domain it did not want to accept the installation. The host then send me a link to the server of the shared account that is a temporary link. The install was then successful and the site is reading the version file correct.

Thank you for everyone's help.

Regards
Wynand

Go to forum: Installation

231 Reply by seahawk

(4 replies, posted in Installation)

Joe

It contains the version 2.3.20 inside the code. The template is the default option.

Go to forum: Installation

232 Topic by seahawk

(4 replies, posted in Installation)

Hi

Cannot get above version to display after upgrade.

Regards

Go to forum: Installation

233 Reply by seahawk

(14 replies, posted in Installation)

FA 2.3.19. PHP5.4; Same error occurred after server crash and host restored.

Cannot get PDF to display. Urgent fix needed.

Regards

Go to forum: Installation

234 Topic by seahawk

(3 replies, posted in Installation)

One one of the shared hosting domains, we had a crash of the server. The hosting provider only had a backup of 20/02/2014.

All other backup's were lost. The provider then restored the backup which included FA database and files. Now FA does not want to print any reports.

I did the following:

1. Restored the database and tables (Did not work)
2. Reloaded FA 2.3.19 (Did Not work)
3. Looked at System info and it kept on showing installation file to be removed. There is no installation file at that point. The Backup screen also continued to show old backups that was removed.
4. Installed the new 2.3.20 (Did not work - FA still sees it as 2.3.19. Cleaned the browser cache and used different browsers.)
5. Deleted the whole data base and created new database. (Did not work. FA shows splash screen and does not want to do reinstall) Login Screen still shows 2.3.19 although I installed clean 2.3.20)
6. Removed the config and config.db files, still showed 2.3.19 and was running without these files. Do not know how this is possible.

Any advice will be appreciated. Have searched the forum but could not find something similar.

Go to forum: Installation

235 Reply by seahawk

(28 replies, posted in Banking and General Ledger)

Joe

Sorry for only getting back to you now. I think it looks great. Will test it on a number of installation with multiple bank accounts and see what it does.

See it will give you last twelve months which is great. Some might want a from and to date to do the report for  quarter of six months.

Thanks for the development. Will keep you posted.

Go to forum: Banking and General Ledger

236 Reply by seahawk

(2 replies, posted in Setup)

I agree, they can only login with some-one else's password if they shared it or if the person have saved it on their browser and they use that person's computer.

Go to forum: Setup

237 Reply by seahawk

(6 replies, posted in Accounts Receivable)

itronics wrote:

Two invoices can be enetered by two different users at the same time, but obviously they invoice number hav eto be unique. FA uses database transactions, so there is no way to entry two invoices at the same time: just one will be stored, and second user will encounter error message. Then you just have to incement the invoice number suggested in input field and try store the invoice again. You do not need to abandon edition and change the number in Forms Setup.
Janusz

I agree with Janusz. When I train multiple people at a company it happens. Then the person who receives the error message can just resubmit their invoice and it then allocates the next number, otherwise just update the invoice.

Go to forum: Accounts Receivable

238 Reply by seahawk

(14 replies, posted in Reporting)

Have same problem. It indicates that "You can only upload *.sql backup files"

Go to forum: Reporting

239 Reply by seahawk

(28 replies, posted in Banking and General Ledger)

It would be similar to the report: Annual Expense Breakdown - Detailed. The only difference is that it will only reflect all cash receipts and payments and not all sales and purchases like this report.

Regards

Go to forum: Banking and General Ledger

240 Reply by seahawk

(5 replies, posted in Reporting)

Joe

The sale summary report does not give you a list of invoices. Just a summary of total business for a given period with a particular client.

Is there a way to just get a list of invoices (Documents)  with invoice numbers and amounts for a given period.

Regards

Wynand

Go to forum: Reporting

241 Reply by seahawk

(28 replies, posted in Banking and General Ledger)

Cash Flow statement would be done with the bank and cash accounts setup.

It will receive all the cash receipts minus the cash payments for each account. The balance would be you positive or negative cash flow. This is not sales on credit or purchases on credit. These will only reflect when you receive payment on those sales or when you pay your supplier.

Depending how you have setup your accounts, will determine how one would write the report.

Let's for example say that you have two bank accounts set up. Bank Account A (Current Account) and Bank Account B (Cash Account).

Need to add all the receipts in Account A for a given period together and then subtract the expenses that was paid from that account.

Then you need to do the same for Account B.

Each account will then have an opening and closing balance and the difference would be you negative or positive cash flow.

To that one need to decide how many periods should be included in this cash flow  report. 1,2,3,4,5,6 periods and the total for those periods. Say from 01/01/20xx to 31/01/20xx would be one period.

------------------------------------------------------------------------------------------
Example:

CASH Flow
    As at 01-Mar-2011
    Account
    October   10 -  November  10    December  10    January   11    February  11    March     11    Total
   
    0.00                   0.00                     0.00                      0.00              0.00              0.00             0.00
       
    Net Cash Flow   
        0.00                   0.00                     0.00                       0.00              0.00              0.00              0.00
    Total Bank Balance   
        0.00                   0.00                     0.00                        0.00               0.00              0.00               0.00

----------------------------------------------------------------------------------------------------------------------------------------------------

Go to forum: Banking and General Ledger

242 Topic by seahawk

(0 replies, posted in Accounts Receivable)

I have tried to find some info in the forum without much success.

When adding some items from  the inventory and you add the item on a direct invoice, it changes the quantity from 1 to three and changes the price from 1850 to 666.67 which is then equal to 1850.01.

I have checked the item code and there is no characters in the code.

When I go back and edit the line item the quantity can be changed but the amount now remains at 666.67 and needs to manually changed back to the selling price of 1850. When I then add, the amount and the price is correct. There is also no characters in the description field.

Any idea what could cause this?

Regards

Wynand

Go to forum: Accounts Receivable

243 Reply by seahawk

(4 replies, posted in Accounts Receivable)

tm wrote:

https://frontaccounting.com/punbb/viewtopic.php?pid=18394#p18394

Thanks tm. This solved the problem. Have added the changed file to my 2.3.19 installation for the other updates that I still have to run.

Go to forum: Accounts Receivable

244 Reply by seahawk

(4 replies, posted in Accounts Receivable)

Thanks. It still worked with 2.3.18.

SQL version is: 5.0.96-community

regards

Go to forum: Accounts Receivable

245 Topic by seahawk

(4 replies, posted in Accounts Receivable)

Hi

After Installation of FA 2.3.19 I get the following error on Print Receipt after receipt and remittance of Payment.

DATABASE ERROR : query for bank transaction
error code : 1305
error message : FUNCTION iingcoza_frontacc.IFNULL does not exist
sql that failed was : SELECT bt.*, act.*, IFNULL(abs(dt.ov_amount), IFNULL (abs(st.ov_amount), bt.amount)) settled_amount, IFNULL(abs(dt.ov_amount/bt.amount), IFNULL (abs(st.ov_amount/bt.amount), 1)) settle_rate, IFNULL(debtor.curr_code, IFNULL (supplier.curr_code, act.bank_curr_code)) settle_curr FROM bank_trans bt LEFT JOIN debtor_trans dt ON dt.type=bt.type AND dt.trans_no=bt.trans_no LEFT JOIN debtors_master debtor ON debtor.debtor_no = dt.debtor_no LEFT JOIN supp_trans st ON st.type=bt.type AND st.trans_no=bt.trans_no LEFT JOIN suppliers supplier ON supplier.supplier_id = st.supplier_id, bank_accounts act WHERE act.id=bt.bank_act AND bt.type='12' AND bt.trans_no = '33' ORDER BY trans_date, bt.id

Any advice will be appreciated.

regards

Wynand

Go to forum: Accounts Receivable

246 Reply by seahawk

(4 replies, posted in Reporting)

joe wrote:

The customer statement uses the contact defined on the customer and not the branch contact.

Setup a customer contact with relevant type (invoice).

Joe

Isn't there a way that one can copy the first branch that is created to the company as well as branch contact. Most Companies will have one contact with one branch.

At the moment only the one item is normal selected to be email and you have to manually add the rest of the documents that needs to be emailed, example  Invoice and statement.

Can't we get all selected when the auto branch is created as well as creating a contact in the company for Statements.

regards

Wynand

Go to forum: Reporting

247 Reply by seahawk

(2 replies, posted in FA Modifications)

I think it might work.

Go to forum: FA Modifications

248 Reply by seahawk

(12 replies, posted in Accounts Receivable)

Thanks Janusz. Done that

Go to forum: Accounts Receivable

249 Reply by seahawk

(12 replies, posted in Accounts Receivable)

Thanks will give it a try. Once edited where do I send the file?

Go to forum: Accounts Receivable

250 Reply by seahawk

(2 replies, posted in Report Bugs here)

Thank You. big_smile

Go to forum: Report Bugs here