276

(2 replies, posted in Accounts Receivable)

Hi
what do you exactly need ? FA is "only" an accounting software so It' probably won't remind you when somenone needs to pay.
However as selling something (dispatch) is not coupled to payment , it's easy to deliver and and invoice something to someone, and then enter the payment when the customer pay it. You could have either one 'customer' per real customer  or one customer for everyone.

If you really want an invoice per payment, I think you can "split" you item in bit and do an invoice with a different due date for each payment.

Does that help ?

/Elax

277

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

Hi, not sure this the right section to post this.

Anyway, I fixed a bug in the overdue invoice  report of the executive theme (on the sales pages).
It displays invoice which have been payed , but the remainder is not 0 but 1e-14 (it appears on invoice with a discount).

The fix is to replace the '> 0' conditions by '> 1e-6' (or anything sensible)  in  themes/exclusive/renderer.php:303.

(As it's an external module I don't know who is charge to do it)
/Elax

If you want fixed discount, do as Joe suggested, create a service Item called discount, then enter a negative price on it with the value of your discount (You'll have to configure the tax properly so the VAT will take into account the VAT or not)

/Elax

279

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

Can you see it under Items -> Items and Inventory -> Mainteance -> Import CSV Items ?

If not, you need not activate it for the roles you need. So go to Setup -> Access setup. Select a role (preferably a one you have so System Adminitrator) then check the "Import CSV Items:" , (to enable the module) then check the "Import CSV item" just underneath (to enable the "import csv items" features of the "Import CSV Items").

/Elax

280

(1 replies, posted in Announcements)

Hi
Not sure if it's in a good category, but could the new release of FA be announced on this forum please?
(or is there anyway I can get a  feeds from the frontaccounting NEWS ?)

/Elax

Hi tclim,

I used CVS and SVN for years and switched to GIT. I will never go back to SVN. To manage merges, diff between branches etc, reapplying some commits etc, GIT is amazing (you can't do anything similar with CVS or SVN). However hg seems to offers pretty much the same features as git so as front accounting is host with hg , I would go for hg. But switching to one of them is definitely worthing it

/Elax

I personnaly use vim and git (and tig) (maybe I should switch to hg).
So to manage a FA release I just copy it to my current directory and discard then change which modify my customisations.

If you are familiar with git, that's pretty easy.

/Elax

283

(2 replies, posted in FA Modifications)

Is there anyway so modify FA to tell him (via company set up)  to use the rate of the first of the months or the last one if some are missing ?

/Elax

joe wrote:

I don't understand this. The allocations and amounts is in the customer currency. How can you have leftovers here?

/Joe

For example , I have to 34000 USD (X)  to a supplier. For that the bank make me pay 22,258.11 (Y) GBP.

In FA I have to give the amount in my currency and the exchange rate which are 22,258.11/34,000 = 0.654650...
So I use 0.654650... as an exchange rate. Unfortunately 22,258.11/0.654650 = 34,000.02 (X')

When I try to allocate the payment I ended up with .02 left.

So, yes I could have entered more decimal in the exchange rate but anyway, things will be easier (and accurate ) if I didn't need to calculate the exchange rate as the only things which matters are the amount in my current and the one in the foreign one.

/Elax

285

(2 replies, posted in FA Modifications)

Hi

In the UK it's recommended to use a monthly rate. The government publish an official rate for the month and that the one to be use to determine import duty. Therefore it's easier to use this rate for the whole month.

How can I acheive that in FA without having to manually add the exchange rate to every single day ?


Thanks

/Elax

Hi

Would that be possible to able to enter, when doing a payment in a foreign currency, to specify the exact amount in (both currency ) rather than an exchange rate. (I'm speaking in supplier and customer payment).

What usually happend is , I have an invoice from a supplier for an amount of X. I pay it, that cost me Y + C (charge).
To enter the payment I have to enter in FA
Amount : Y
Charge  : C
  rate     : X/Y or Y/X (I never know)
Then exchange rate is usually truncated meaning that what 's credited to the supplier is X' instead of X. The difference between X and X' is usually something like a pence but that' s really annoying because then I can allocate properly the payment to the invoice and the payment or the invoice  (depending which way the error has been made ) stay for ages in the list of unallocated stuff.


/Elax

287

(21 replies, posted in Accounts Receivable)

The actual way of automatically create a branch from an existing customer (via add or edit customer in the new customer form) seems to work pretty well , isn't it ?
I understand though it's a pain to have to do it for every single customers.

288

(2 replies, posted in Items and Inventory)

How do you choose which type of taxes is applied ?
If it depends on the supplier and the customers then just configure each supplier to use either CST or VAT and the product to use all of them.

289

(6 replies, posted in Banking and General Ledger)

If 0 rate work for invoices (from Suppliers AND customers) that will solve 90% of my problem. I didn't create a 0 % VAT because I thought it didn't work (because of the payment thing, so didn't check for invoices).
I have only a few things which are 0-VAT that I use Bank Payment for, so I guess I can just create a different GL account for them (like food-0-VAT). Just need to know that I have to do it. For bigger things I'll use a 0-VAT group or a dimension.

/Elax

290

(6 replies, posted in Banking and General Ledger)

I mean payment as "Bank payment" in (Banking and General Ledger). I'm not speaking here of invoices but just payment without supplier, as small stationary of food. That works well for small stationary (I create 2 lines one for the net amount and another one for the VAT) but I can't for the 0-VAT as the total amount is 0.
Does that make more sense ?

/Elax

291

(6 replies, posted in Banking and General Ledger)

I've tried and that doesn't work.
If enter a payment, without any VAT item nothing appears in the VAT report, and If I had a 0-VAT vat type,
when I tried to enter a line for the VAT on the payment, it complains that the amount is null. (which is normal, it's 0-VATed therefore the amount going in the 0-VAT account is null)

What else can I try ?
/Elax

292

(6 replies, posted in Banking and General Ledger)

Hi
I need (that's the law in the UK) to add 0-VAT things in the VAT report.
The solution should be easy , I create a new tax type cat 0-VAT with a rate of 0 and assign to items.
However, when I'm not buying items but do a payment instead, I need to add a line with an amount of 0 (going into the 0-VAT) account.
I can' do that as the FA refuses to enter a null line. I guess I can't remove this 'guard', but I'm wondering how FA would guess the amount which has been taxed.

Any idea ? I would be happy with any other way allowing me to add the 0-VAT in the VAT report.
(That's a major issue)

/Elax

I tried your patch, seems to work , well done and thank you very much Joe!
/Elax

That would be brilliant , thanks!

joe wrote:

Remember that when saving a Sales Invoice the transactions go into the GL as well.
That's my problem, I often forgot to set the dimension on Sales invoices, and there is no way you can correct or edit a Sales invoices. That make sense except for the dimension.

I'll probably endup updating the dimension via SQl, but I don't like it at all. Moreover, if do this mistake often maybe I'm not the only one, so other could benefit of a way to do it.

joe wrote:

Another approach is to void the Sales Invoice and enter it again with the correct dimension.

That's what I want to avoid, they are often quite long, and we make already enough mistake (between item variant) to not have to enter them twice.

Thanks anyway

nobody ?
I really need to modify dimension afterward (to fix mistakes)

It would be nice to be able to see the movement for location at the same time and
be able the see the movements (and great total) of all items matching a regexp (or sql like string).
I have some product with variant  and that would be handy to spot errors when another variant has been delivered by mistake.

Hi
Does any body know how to do invoice with prompt payment in THE UK ?
Apparently the VAT needs to be calculated on the discounted amount meaning I have to set the discount beforehand even though the customer doesn't take discount.

Any idea ?

Hi
In order to solve my promp discount probleme I tried the following :
- Go to customer payment
- allocate some payment (of the amount of the discount I want to offer)
- set a discount equal to the allocated payment
-submit

The idea is to "allocate| a discount without paying anythin . The problem is the systeme refuse to do it because the final payment is null
(which is what I want, I just want to allocate a discount ).

I  it should be fairly easy to change the null payment validation if a discount amount is present. However I was wondering if it safe to do so or if the systeme is expecting somewhere else payment to be not null ?

/Elax

Anyone ?

I was thinking of solution but I'm not really happy with that. I can create a bank account link to a discount GL account so I can simulate a payment from that customer to it . However that means I have to have 2 different discount GL account, as I can't use a bank one as a normal one, can I ?