That seems to have cleared the problem. Many thanks for the advice. I'm very grateful.
2 11/10/2012 07:12:29 pm
Topic: Asset extension (3 replies, posted in Items and Inventory)
I have been using FA for the past two years. About a year ago I added the Assets extension, checked the relevant Authorization boxes, added an Asset Type and a couple of Assets.
Recently I had cause to restore a Backup but now, although the Asset Extension is shown as installed, there are no menu items, and no Authorization check boxes and hence I cannot add further Assets. The original entries are still present in the database.
What can I do to remedy the situation. Deleting the Extension and reinstalling it seems a bit risky without some advice.
Ticketman
3 10/22/2012 09:09:23 am
Re: Paypal import problem (5 replies, posted in Banking and General Ledger)
I have solved my immediate problem of not being able to import the 'net' figure in a transaction. This was traced to the 'taxline' calculation which needed a 'Tax Group' to be defined. We are a non VAT registered Company and although I had set up a 0% tax rate I had not defined a 'Tax Group'. Setting up a Tax Group after enabling the appropriate role, resulted in correct import of Web transactions.
Now need to find out why I get database errors when trying to create Customers and Invoices. I'll post what I find
4 10/20/2012 04:43:23 pm
Re: Paypal import problem (5 replies, posted in Banking and General Ledger)
I am also trying to use this Import Paypal extension. I successfully executed the the SQL script but I ran into a couple of more problems. The headings in the UK Paypal csv file do not .entirely match up with those in the code, e.g. post and packing heading did not match any of the alternatives given and the 'types' of payment processed do not cover all the types included in the csv file.
However most serious at the moment is ,that although it appears to process payments (I haven't tried generating receipts or Invoices yet), inspection of the Paypal Bank Account shows only Credits (fees) but never Debits (Nett Amounts).
Bank Transfers however appear in both Credit and Debit columns.
I'm trying to work through the code but my php and sql skills are very limited.
Any ideas?
5 08/27/2012 03:26:19 pm
Topic: Paypal import problem (5 replies, posted in Banking and General Ledger)
I have installed the Paypal extension and enabled the roles. I've tried to import a csv file but get an error:-
DATABASE ERROR : Cannot clear paypal items
error code : 1146
error message : Table 'fusion_fact.0_import_paypal' doesn't exist
sql that failed was : DELETE FROM 0_import_paypal WHERE user_id = 'mike'
What do I need to do to clear this error? As far as I can tell the extension installation was successful but obviously there are database tables missing
Thanks
6 03/24/2012 04:33:21 pm
Topic: Voiding Bank Seposits (0 replies, posted in Banking and General Ledger)
Whe I started Front Acounting I used Bank Deposits to record Income from Purchasers. I soon realised that a preferred method was to raise an Invoice and use Customer Payments on receipt of payment as this gave the opportunity to also record the Bank (Paypal) charges. I thenvoided several Bank Deposits and re-entered the transactions through the Purchases/Invoice/Customer payment route.,
However I have about 6 Bank Deposits that I cannot void as they return 'Tranaction does nnot exist or cannot be voided' even though they do exist and appear in the relevant Customer Transaction Enqugiry. Is there a reason for this and a possible workaround?
Thannks
7 03/14/2012 09:13:53 pm
Topic: Assets (1 replies, posted in Items and Inventory)
I've installed the Assets module but the 'Asset Type Entries' and the 'Asset Entries' tabs in the Items and Inventory menu are greyed out. How do I enter an Asset and how do I apply depreciation?
Thanks