1

(2 replies, posted in Report Bugs here)

Hi

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

2

(8 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

4

(8 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

5

(2 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

Yes, you just need to configure this supplier to use 5% and 13.5% rates.

You definitely needs to read the wiki, because everything is in it.

/Elax

Basically, you set your item to both VAT 1% and 13.5%. (in fact, exclude everything else)/
Then you setup tax group one, 1% and the other 13.5%.
Assign your supplier to the 13.5 % group (so what you buy from him would be taxed as 13.5%)
and assigne your customer(s) the group 1%, so when you sell the same item, it would be taxed at 1%.

Simple, ;-)

(The trick if any, is to configure the item to all tax types, and create different groups to "filter" which tax are applied).

/Elax
Max

13

(1 replies, posted in Wish List)

There is a (apparently) a stop forum spam module for punBB.
That might be worth having a look. (I use www.stopforumspam on my website, and it works really well)

/Elax

seank123 wrote:

Ah OK - so it can show, for example, 10 shirts in stock, 5 at the printer etc, is that right?  Total number of each item in each location?

Yes.

seank123 wrote:

  What I really need is to have each item in each order identified by location.

Depends on the season - will be in the order of 30+ per week.

I will have a look at the module - thanks.

As I'm developping it, my version is always in front of the "official" one, so I'm not sure, if the "official" version can handle transfer location. Just let me know if you have any problem


/Elax

As I said, your item will probably 'live' in their location independently from the order. Therefore you should be able to use adjustement location to move more than one item at a time.
What type of volume are you speaking of (1 item a week or 1000 a day ?)

If you have a spreadsheet you can use my textcart module to transform a spreadsheet to a adjustemen location cart.

/Elax

Yes you can. I strongly suggest that you read about the tax system in fa here. And then come back and answer question about what you don't understand (maybe we should be able then to update the wiki and make it clearer).

/Elax

Yes you need to create one GL account for each tax type (under liabilitie).

On what depends the VAT ?
If it depends on the customer create a tax group which exclude the tax you don't want (and leave the VAT you need).
If it depends on the item, configure the item with the relevant VAT.

/Elax

Sorry I miss read your post.

You are right, but you can still move a item (if it already exists) from one location to another one. So if you order use the 'READY' location, and your t-shirt is initially in the 'WAITING'  one. You can move it (using location transfer) to WAITING to PRINTER etc, and you won't be able to dispatch the final order until there is something the item reach 'READY'

However, I'm a bit confused when you say order, do you mean sales order or work entry order ?

/Elax

The easiest way at the moment is to use different 'location', one for each different status.
(ex : WAITING, PRINTER, etc ...)

You'll have the to update manually the location of each order manually.

/Elax

21

(12 replies, posted in Modules/Add-on's)

I think the user should be able to chose on which tab if need wigdet (and if is ok to waste time or not). My initial point was only that an additional dashboard tab is handy.

22

(12 replies, posted in Modules/Add-on's)

Why do you need to remove dashboard functionality from other tab ?
Maybe it would be just easier to hide dashboard tab when it's empty (meaning when no widget have been assigned to it) and leave the user put widget wherever he needs to

23

(8 replies, posted in Wish List)

apmuthu wrote:

Try this at first as someone asked for it in the forums a few months ago:

- Order Delivery
* add clear quantity button, so the default quantity to dispatch to 0. (usefull when you need to dispatch only a bit from a big order).

or better still just make addons / extensions of each set of features or the whole bunch as Elax Apps in a separate menu tab.

I think it was me ;-)

I thought of the module approach but pretty much all  the modification have mentioned are hard to extract to a module because most of them are small enhancement of the actual GUI.


Anyway, as I can see that nobody is interested in any of the my features, it's probably not worth wasting time on trying to integrate them into FA.

/Elax

24

(12 replies, posted in Modules/Add-on's)

I didn't do anything to make the dashboard tab appear. As I said I used the normal dashboard module, but my own theme. I understood (I might be wrong) the presence or not if the Dashboard was just a css decision.

/Elax

25

(12 replies, posted in Modules/Add-on's)

I think the dashboard should be on option. I used a custom theme and have the dashboard tab activated.
It's really usefull as a main dashboard mainly because some widgets can be slow and I don't want to slow down (too much) my day-to-day workflow with heavy widget.

Example, I need to enter a customer payment, I press Sales (which display the top 10 customers) then I press payment and pay.

I have the top 100 customers on the dashboard tab for when I need id .


/Elax