It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by jonathan46
Thanks.
I suspected that was the reason, initially but I could not find an easy way to find my location transfers, and it is listed in the drop down box.
If I cannot find them under Journal Entry how can I find them, apart from looking for a movement of an individual item?
Jonathan
When I try to review a Location Transfer I select "Journal Enquiry" on the"Banking and General Ledger" page. Then I choose "Location Transfer" from the type drop down box and an appropriate date range and click "search".
With my set up no transfers are found, though several exist.
Banking and General Ledger > Journal Enquiry > type: Location Transfer
This selection does not find my Location Transfers.
It has not worked on versions 2.3.9, 2.3.10, 2.3.11
My home currency is GB£.
I have paid a supplier in US$ and the supplier balance is quoted in $.
A month later I enter an invoice for exactly the same number of $.
When I try to allocate payment I see a figure in £ at the top, and a figure in $ on the line.
When I click on "all" the £ figure appears beside the $ figure in the line, and results in about a 1% shortfall.
How can I allocate the $ balance to the $ invoice?
I have cancelled auto update of exchange rate, but exchange rate should not be involved any way.
Thanks for the lightening reply.
It is the Inventory Valuation that I want to reflect the inbound shipping and other costs. Should I do this for each delivery by manually adjusting each item's cost, after Front Acc. has averaged the invoiced cost with the old stock?
I was hoping GRN provision did something along these lines automatically.
So can I set Delivery Over-Receive Allowance to say 3% to achieve this,
or is it Invoice Over-Charge Allowance
Jonmathan
What is GRN Provision?
Google, and my local accountant don't help, so perhaps there is another name I could search for.
What does Front Acc. do with them, and what should I do?
If I want my inventory valuation to reflect shipping and other expenses, should I adjust the individual item costs or is this a function of GRN Provision?
Sorry for the barrage of questions, but I expect they would follow on from your first response.
Jonathan46
Hi,
My sales put the vat in the Right hand column of the vat account.
My purchases put the tax in the Left hand column of the VAT account.
I make Journal Entries for payments direct to the Inland Revenue for imports, and they appear on the Left of the VAT account, and the right of the bank account.
I believe this is as it should be but the <Banking and General Ledger> <Tax enquiry> adds the two columns to reach the Net Tax Payable where I expect to find the difference.
Have I misunderstood something or is my setup wrong?
Type Description Amount Outputs/Inputs
VAT 20% Charged on sales (Output Tax): 7,411.07 37,052.66
VAT 20% Paid on purchases (Input Tax): 5,589.16 27,945.81
VAT 20% Net payable or collectible: 13,000.23
Total payable or refund: 13,000.23
Jonathan
How easy is it to modify the Invoice form to provide these extra features required in the UK?
the invoice date
the time of supply (also known as tax point) if this is different from the invoice date - see below
the unit price or rate, excluding VAT
the rate of VAT that applies to what's being sold (on each item)
the total amount payable, excluding VAT
Jonathan
Sales > Customer and sales reports > Salesman listing
If an individual salesman's list runs over to the next page, the total given for that person is of only the entries that appear on the last page.
The final total of all salesmen is correct, but the individual totals are not.
Is this a fault or have I misunderstood something?
Does FrontAccounting use FIFO, LIFO or Averaging when working out stock valuation?
Thanks Joe. That worked a treat.
Jonathan
Yes I have, but it won't let me change or delete any years after the dummy year.
I have set it to use a dummy year, just before my starting period, but It won't delete any of the later years so I can enter the dates I need.
I have tried a fresh install so there are no entries anywhere.
Has any one done this?
FrontAccounting forum → Posts by jonathan46
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.