seahawk wrote:

When sending an email to a client, the email would only contain the client's surname in the client address for example:

Dear "Surname" or "Last Name", instead of First Name or Full name. Only $contact['name2'] was displayed.

Would be nice to have some way of choosing the way a client is addressed in the email or at least use the full name.


Resolved the issue by changing line 1006 in pdf_report.inc

Changed contact details to:

$contact['name'].' '.$contact['name2']


Regards
Wynand

The other way is to fill the customer information with what you want to be displayed in the email.

/Elax

Brilliant, maybe that should be an option in the config file ;-)

/Elax

I'm not an expert with module but each type correspond to the different "page" find in editing "Items and Inventory" and "Manufacturing"
- Bill of Material
- Unit of Measure
- Sales Kit
- Foreign Item Codes
- Purchase prices

/Elax

Is the item active or has it been excluded from Sales ? (both options setable in the edit item page)

/Elax

Glad you like it :-)

I did it  mainly because I was managing massive purchase orders (over 20 pages) and the actual GUI wasn't just working (really time consuming , prone to error and sometime couldn't save it because the session expired in between).

Anyway, if you have any question or need help about the templating system, don't hesitate (but please ask in a separate thread), the doc is not necessarily up to date so the templating system can do much more than the example I gave in the doc.

/Elax

Hi Andrew

There is no menu or link to textcart, neither you need to add all the order information (customer, branch etc ).
Instead, go to the normal order/invoice/dispatch (whatever) page and you should find a textcart tab. This will replace the standard UI by a textbox from which you can copy/paste from/to Excel (or any text editor).

I strongly sugest that you read the doc there.


/Elax

The FA package repository is available directly from FA, go to Setup -> install/activate extension, and you should be able to download it from here. Don't forget, once downloaded to activave it (switch the select box on top of the install page to 'activate').

The version on the FA repo might not the up-to-date one, let me know if you encounter any difficulties.

/Elax

I agree with the page number, that would be really handy.

About the editing, even though it might be handy, I don't think it's legal in most country to be able to edit an invoice : editing it would allow you to easily dodge taxes.

However, if you make that many mistake have a look at the textcart module, it allows you to import order/dispatch/invoice from an excel spreasheet. You might be more confortable writting the whole invoice on excel and the importing it.

About the dispatching (I have also lots of big order to dispatch ) and I use to make lots of mistake , I have another module which allow you to pre-select part of an order to picked and then only quantity "picked" would be dispatchable. Let me know if you are interested.

/Elax

109

(2 replies, posted in Accounts Payable)

You can either void it (setup/void transaction) or create an credit note (which you should do if you already sent the invoice to the customer).

/Elax

Another way is to configure the BCC address for ongoing email in Setup/Company Setup.
That way, all emails which have been sent are also sent to the configured address. You can configure your email to filter those email and archive them straight away without going to the inbox. You could then check all the "history" of emails in your mail box.
Alternatively, you can have a special email account just for this.

/Elax

111

(5 replies, posted in Wish List)

joe wrote:

No, this not possible in FA. The customer should be able to see this info in his own accounting system.

/Joe

Lots of my customers, don't have an accounting system. They just have an accountant to whom they send paper invoices and send them back a tax return once a year. They don't have any stock system, have no idea how much payment are outstanding etc ...

I told them to use FA but that doesn't work ;-)

/Elax

To be fair, I never understood what this 'Reverse Transaction' checkbox was for, and even after reading this, I'm still not sure.
The new version seems better, even though it's behavior is still obscur : If I click on a reverse transaction button why would it generate 2 transcation instead of just reversing the initial one ?

/Elax

Hi Gunnar

Are you a developper ? If so, I have an "experimental" picking list module and application
which is at the moment really tailored to my need, so I'm not sure it can be used out of the box.
However It provides on FA side a interface to select which order to pick for the day. Then in a different app
a interface to select which orders to pick together (which can combine together or not : meaning
all the order from a same style but different customer are grouped in one, with a customer breakdown)
And packing list group styles by customer, then order, then styles.

It also relies on a patched version of FA allowing to only display on the lists which quantity is available for a customer (depending on the quantity on hand but also eventual orders which have been made by other customer, beforehand).

It's also meant to work with variant , so group stuff by variant.

If you are interested let me know.
I'm working on the moment on a order priority module, so I'll probably rewrite part of this one I've finished.

/Elax

114

(20 replies, posted in Reporting)

/Xero

AS I said, the main problem of the Box 7 is the "0 VAT" transaction problem. This has been sorted in FA but not released yet, because it's still under test, but it should be release soon.
Once it's been release doing a UK VAT report should be straight forward. But you'll need to have run  the full quarter with the "new" code and configuration, so all the 0 VAT transaction are recorded properly. By that time, I probably would have  done a UK VAT report compatible with the new version and so write a report as well.

Just be patient (and do it manually for now)
/Elax

Thanks

I'll have a look at it.

/Elax

116

(1 replies, posted in Report Bugs here)

Hi

This report doesn't really do anything with "cost" or at least not cost history.

117

(11 replies, posted in Reporting)

@Joe

I think so. Normally, everything Item related should work because you can create a 0% VAT type and assign it to an item.
This 0% VAT type will appears in the tax report with the correct net amount.
itronic patch should allow also to 'tweak' the tax amount calculated on invoice.
The problem only occurs for payment or deposit. In my version you can enter the net amount corresponding to a 0% VAT transaction, so everything should work fine. This net amount will then show up in the tax report on the corresponding tax type.

/Elax

It's probably a rounding error (so 216.85- 216.85 is not exactly equal to zero).
add $1 or 1cent  in the cash account (in FA and physically ) it see if it solve the problem.

I know it's not ideal, but that's the only thing you can do at the moment.

/Elax

119

(11 replies, posted in Reporting)

@AlastairR

For your info, I've been working on a way to enter 0-VAT transaction and it should be available in FA soon. So the 0-VAT problem (and box 7) should be sorted. I was thinking also doing a generic VAT report for the UK. It seems that once you have all the tax type configured, what you need for a generic VAT report is only to be able to specify a list of box (with a name) and which tax types to include in that box (net and/or tax amount) (the same amount can be in different box).

I was planning to work on it (in a couple of month) but it would be brilliant if someone could do it beforehand ;-)

/Elax

120

(1 replies, posted in Report Bugs here)

Hi

I have some really dodgy standard cost from some items. I'm trying to investigate but I have 2 questions:

- is the standard_cost in stock_move table the standard_cost corresponding to the transaction, or the standard cost after (or before).

- Is there a way to find all the price adjustement which have been made to a particular item ?


/Elax

As your items can be depending on external factor either %1 or %13.5 it's obviously not a good idea to create a 1% tax type and a 13.5% tax one.
YOU DON'T NEED a VAT@1% Item Tax type because you don't  have item which you buy at 1%
You should have only 2 item Item taxes
VAT@5% (1% AND 5% unchecked)
VAT@13.5% (1% AND 13.5%)

Then the purchase tax group should NOT select 1% but 5% and 13.5% (so depending of the product you get either 5 or 13.5 %)
The sales group is alright

That's my final answer.
/Elax

I have a similar problem, but in the other way, my supplier wants prepayment which I want be allocate on each delivery (The main problem is we usually mix the initial order in each delivery).
What I do (seems a bit complicated but works really well, however you might be able to simplify it).

When the supplier raise an pre-payment invoice
- I create an invoice which go on a prepayment account (or item). It's not related the real items I'll get. It's a 'deposit' item.
- A the same time, I create a credit-note to cancel it.

Then, (that's the clever bit), every payment I made, I allocate them on this pre-payment. I never allocate payment to the real order.
When the real invoice arrives, I pay it with the credit note (even if the payment haven't been made ).

Example
I have an order A for $100 and and order B for $1000

I create:
  a pre-payment A-P $100
     credit note A-D $100
    pre-paymint  B-P $1000
    credit note B-D $1000

At that point everything cancel each other, in theory I don't owe  anything to anybody.

Then the supplier wants me to pay 30% deposit of everything

I pay $330 which I allocate the pre-payment
at that point, I can see than I need to 70+700 $ to pay and I have $1100 (from the credit not) which I haven't allocated to anything.

Now, the supplier send  and invoice half of A and half of B (but I haven't paid anything yet).

I create the invoice corresponding to the delivery
  D1 $550

And I allocate the correspoding bit from the credit note , so at that point I have
        Amount     | Allocated       | Outstanding
A-P  $100         | 30 (deposit)   | 70
B-P  $100         | 300 (deposit) | 700
A-D  $100         | 50  (delivery)| 50
B-D $1000        | 500 (del.)     | 500
D1  $550          | 550              |

I can see easily that I have 770 outstanding to pay, and 550 left to be invoiced by the supplier.
One of the advantage of that method, is it decouples the physical payment from the invoice, so for example with the 30% deposit, I don't to worry about how to allocate them to the real delivery (should I consider that half of the 30% should be allocated to D1 ? etc ...).

With that I just allocate the deposit and payment to the order A pot. And allocate delivery from the A pot (the credit note).

Hope that will help,

/Elax

The fix just fix a rounding bug in the report not filtering properly, it doesn't alter the data.
Therefore, it work for old and new data.

/Elax

It's fixed on my version , but apparently not in the official FA.
I have a patch for it but I don't how to post a file on this forum.

@Joe I remember having this problem a while ago and raising a bug about rounding issue, I think it's been sorted.
@ed10 which version of FA are you running ?

/Elax