Search options (Page 2 of 13)

The problem with 0 VAT is only a GUI problem. First you can't enter a 0 amount corresponding to the 0-VAT GL line.
Then you can't deduce the net amount corresponding to this 0 line.
The solution is to add a column in the Payment/Deposit UI corresponding to the net amount of the transaction.
This way, let's say you have a payment for £5 + 0 VAT, you'll enter two lines, one of £5 and the other of £0 with a net amount of £5.

With this, FA can save properly the information in the gl_trans table and everything works fine.

I made a patch with modify the GUI this way, with some javascript to automatically calcul the net amount on VAT account.
I submitted it and thought it has been merged but it hasn't. I'm not sure why.

/Elax

Files have to be patched manually. FA module system doesn't allow module to overwrite FA files (which is good).
Textcart needs someway of "hooking" into FA, I proposed a patch to FA which will had necessary hooks but it has been
rejected. At the moment the only way to patch those files manually.

I don't know about the wiki, but the installation section of the first post  explain how to patch. However, the path
where patched files are might have been changed.

/Elax

Every single table ;-) Don't do it if you don't know what you do.

/Elax

In theory. Voiding is the most source of bugs in FA. It's usually fine if you just void something you've done (and you haven't done ANYTHING else in between).
Things are getting more touchy, if you are voiding things in the past, with a different currency, involving negative stock etc ..

Do a credit note if you can ;-)

/Elax

You can use the textcart module to enter the PO. First you need to save the item/s stock_check as an excel spreadsheet.
From it, you should be able to create a column of how much you need to reorder for each style.

filter the zero and the remove the unused column and you should be able to copy paste your spreadsheet in a Purchase order.

/Elax

Yes, adjusting the stock also generates some GL entries which are probably tricky to generate manually. I wouldn't recommend
adjusting the stock directly in the DB.

You can use the text cart module to do "bulk" adjustment (from a spreadsheet for example), even though it's has to be manual.

/Elax

Sorry for the delay. I don't check this forum very often. Are you a developper ? (that would help lots)

/Elax

Do you really need to use the cash account ? Cash payment in the front accounting world, means 'immediate' payment, ie you enter the invoice and the payment at the same time, but it's just a shortcut. You probaly can use a normal payment term even though it goes at the end in a cash account. Movereover, Paypal payment are probably not 'cash' or immediate.

/Elax

Copy it and rename it 'header3.inc' for example then change which header to use in the report itself.
In the report you should have somewhere

$rep->SetHeaderType('Header2')

change it to 'Header3'

/Elax

My question was more about, how is that possible ? I mean I enter invoices, payments, allocate payments to invoice, how come is that possible that according to the transaction page everything has been paid exactly (which is true) but one payment stills needs 0.31 ?

Anyway, I found the problem one credit note was allocated itself 0.31 . That doesn't make sense and indeed mess everything up , but I think it's not allowed anymore and was a bug which has been fixed. I'm I right ?

/Elax

I agree with you that the current way FA is dealing with reference number is weird and doesn't work really well.
(my answer is a bit long, but there is a practical solution at the end ;-))

In most countries, invoice number have to be sequencial, so the tax man can spot "missing" invoices more easily.
FA used auto id from the database and that works fine. However, that doesn't give much freedom to the user which prefers a sexier invoice number.

This is why we have also a reference number, it's a free form field use to reference the invoice. The only constraint is it, has to be unique.
In theory you enter whatever you want, like using the current month and add the sequencial number within the month or anything else.
In practice, it doesn't work because you quickly endup with the problem you have, how do I know what is the reference number or if 2 peoples are entering an invoice at the same time what stop them to use the same ?
FA provides us with last reference number to solve this, however it only works if your reference number is a number but doesn't if you are trying to follow a pattern.
Morever, it even doesn't work with number, because we have the bug you just described. Trying to fix this bug will be equivalent to have an incremental number in the database, which already what the invoice number is.
The question is, if we are forced to use sequencial reference number (and there is no real choice in FA) what not then just using the invoice id ? That would will work, avoid the bug above and don't get people confused between invoice id and invoice ref.

What would be really nice in FA would be
1 - to have an option to use the invoice id as a reference number.
2 - Or have a way to specify reference number pattern so you could do things similar to a printf and use date, user etc ... This solution should be able to use emulate option 1.

In the mean time , what you can do is, if all your users are in the office, have them speaking to each other to avoid this problem
or use a physical reference number generator (to do FA jobs") :  buy a couple of raffle book, give one to each user and ask them to use the number of the ticket as reference number. If they are not in the same city are buying themselves the raffle book, to be sure to avoid "collision" as them to add the city initial to the reference number.

/Elax