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 elax
I know it's not really a frontacconting question, but it's related (as FA is not providing a payroll module and I might to a module to integrate it ;-) ).
Which payroll software do you use for the UK, is there any one similar to FA (I mean that you can access online).
/Elax
What would be nice, is just something which clear the pending quantities (set to 0 or the delivered quantity) and (eventually save) the order. Yes it can be done manually but what you seem to not realize (do you ever use FA or just develop it) is some order can be really really big (in my case ...
SELECT count( * ) AS num
FROM 0_sales_order_details
GROUP BY order_no
ORDER BY num DESC
LIMIT 0 , 30returns
num Ascending
259
222
205
175
160
152
152
...Cancelling a partially deliver order of 200 items , meaning for each one, editing the line, setting the quantity to the delivered quantity, validating, waiting for the AJAX call to be finished etc ... is nearly 2s.
times 200 = 400 s, that's nearly 7 minutes of faffing around with the GUI just to cancel and order.
FA is great (and I'm really happy with it) but it's not really made manage big order (which is a shame because a part from little problems like that everything works perfectly).
(200 items in a order is only for sales order, if I look at my biggest purchases order I got: 495, 437 etc ... (and only because I split them, I'll get 2000 otherwise).
Thanks apmuthu. Just be aware that price_list.csv is not part of front accounting (yet?) but it's an example of a report returning a CSV. You might be able to download that way a proper FA report by setting the appropriate parameters specific to the report, but I haven't tried it.
/Elax
My mistake, is `user_name_entry_field` not `user_name_entry`.
found it:
curl -F 'user_name_entry=<username>' -F 'password=<password>' -F 'company_login_name=<company number>' urlThis allow to log at every request.
Too keep a session alive (easier for manual request) use, the -c and -b option of curl.
curl -c my_session -F 'user_name_entry=<username>' -F 'password=<password>' -F 'company_login_name=<company number>' url for the first time
then
curl -b my_session url(reuse the cookie stored in my_session.
Hi
I need to add to FA some pages which I want to access not from a Web browser but from curl/wget.
Those pages are some kind of report which I probably could do in pure SQL but that would be safer to the php code from FA.
For example I need a csv with a price list, and ideally I would go something line
wget www.fa.com/price_list.csvThe problem is I need to create a session or something. Is there a to "disable" session for certain page (I don't really care about security, I would even be happy to just do
php price_list.csv.php > price_list.csvfrom the current on FA directory (on the localhost)
But I have still this problem of session.
So the question, how can I write a php page which can include all FA db settings, and access to its functions, without having to use session (or is there a way to emulate this session somehow)
/Elax
I'm not changing this account setting.
I'm trying to change something else and I get this error, because I have never set this account.
I can try to change it in the dabase, but that seems to be either a bug, or that a data migration is needed.
/Elax
Hi
I've just upgradaded frok 2.3.11 to 2.3.13, i tried to change the allow negative inventory checkbox in the gl_setup and I get the following error message
Before GRN Clearing Account can be changed all GRNs have to be invoiced
I guess it's because I haven't set a supplier GRN clearing account and the following line
if ((get_post('grn_clearing_act') != $grn_act) seems to not work when it hasn't been set.
The previous code was
if ((get_post('grn_clearing_act',0) != $grn_act)Why this change ?
Ok
I think "closing a year" should give option (2) whatever the checkbox is marked or not. I'm not saying in the general case but
in Brought forward columns, when I am on the first day of the fiscal year.
Moreover, I'm not saying that the 'brought forward' column should only show the balance and don't have a debit and credit column.
What I mean is the part corresponding to the previous fiscal year should be "balanced".
Basically, if I look at my current bank account (for example), what I need to see in the brought forward is the closing balance of this account.
As example seems to be useless I'll give you the pseudo code which I think should be :
rather than displaying :
balance(begin, from)["debit"] | balance(begin,from)["credit"]
The trial balance should display something like
balance(begin, from)["debit"] - opening_balance | balance(begin,from)["credit"] -opening_balance
with opening_balance = balance('000, begin)["debit"] - balance(000, begin)["credit"]
(Once again, it's pseudo code but I hope you get the idea)
/Elax
@joe
Is think my question is clear and I don't understand why people can't answer it. In my example below, which is behavior is expected (1) or (2) ???
/Elax
If it's a non-balance account, you should see 0 brought forward.
If you read my question carrefully, you should notice that I said
I know that non-balance account show 0 as opening balance if selected from the beginning of the year.
My question is about balance account ...
Therefore I don't need any explanation about non-balance account.
I said "balance account", like a bank account or anything which is
What is the type and class of the account?
Do you mean stock as in common shares? If so, wouldn't this be properly accounted under equity or liabilities?
The problem appears with any-type of balance account so for example Bank current account (class : Current Asset)
/Elax
I think we are not understanding each other.
I know that non-balance account show 0 as opening balance if selected from the beginning of the year.
My question is about balance account and I don't know if the current behavior is correct or if its bug.
So my question is :
Let's say I have at the end of the year in bank : debit 150 credit 50 before closing the year.
After closing the year (imagine I have no other transaction ) what should I see as brought forward
(1) Debit 150 Credit 50
or
(2) Debit 100 Credit 0.
/Elax
That's what I've done.
However. It seems that what I want is deleting a year would do (but without deleting it).
I had a look at the code and nothing (neither in closing year bit or the trial balance code) is calculating the opening balance at the begining of the fiscal year.
I explain, let's say last year I have
Stock 150 | 50
and I have done this year (but before the end of the period) 20 | 10
I expect the Trial balance to be
Stock 120 | 10 ( I started with 100 | 0 and add 20 | 10 to it ) instead of
Stock 170 | 60
Obviously if I start the report at the beginning of the year I expect
Stock 100 | 0 20 | 10
but I get
Stock 150 | 50 20 | 10
/Elax
I'm not sure what you mean by done correctly (or how can I check it).
I selected the fiscal year, set close to yes and saved it.
That generated one journal entry from Profit and Lost to Retained Earning which seems.
My problem is when I go to Trial Balance (not trial report) starting at the beginning of the fiscal year, I am expectind the Brought Forward value to be the opening balance with either Debit or Credit being null but that's not the case.
All the non balance are reset to 0 which is fine, but for the example the Stock show, 150 | 50 instead of 100 | 0.
It's the same for the bank accounts anything else.
/Elax
Hi
I've just closed my first fiscal year with front accounting. Everything looks fine and the temporay account have been clear.
However the general account haven't been balanced, I mean, the debit and credits 've been brought forward separately instead of just bringing the balance forward.
Is it normal ? (or a bug or is there a setting to only bring the balance ? )
/Elax
from last year, ed10: Is it possible to have include a search on another field? For example, name and postal code?
I have a similar problem. I supply hat shops, and they all had the brilliant idea to call their shop 'Hat box'. So I add the beginning of the Postal code in the shortname 'Hat box Ca' for hat box cambrige etc .. (I guess you can write a SQL query to update the shortname in the database).
Basically the problem is : when I do the cheque-in the bank transfer the money to my bank account.
So there is an entry on the bank statement
Cheque 100
Then 3 days later, they realize that the cheque bounced, so they take the money out of my account.
Cheque bounced -100.
If I just cancel the payment in FA, then real bank statement and one in bank doesn't match.
The real one show
Cheque 100
Cheque bounced -100
the FA one shows
Customer A 0.
So my idea was to create this -100 entry in FA by me "paying" the customer. I can do that by going in bank/payment and select customer.
At this stage the transaction on the customer side are
1 - Payment 100
2 - Invoice 100
3 - Payment -100
So the customer still owes me 100. However payment-1 is allocated to invoice-2 wereas invoice-2 hasn't been paid.
In fact it works, so I put my answer here for other people having the problem.
Payment 3 doesn't appear in the list of payment to allocate, because it's a payment from me so I can't allocate it to an invoice.
However it acts like an invoice, so if I can reallocate payment-1 from invoice-2 to payment-3.
I'll have this problem, unfortunately voiding messes up the bank statement (as you have two entries on the real bank statement one for the check in , and one for the the "refund".
Is it possible to enter a payment to the customer (to cancel its payment) and allocate it to the corresponding invoice (to cancel the payment again ) ?
/Elax
You will have to void the payment.
/Joe
I'll have this problem, unfortunately voiding messes up the bank statement (as you have two entries on the real bank statement one for the check in , and one for the
Thanks
Elax
Ok thanks
Elax
I don't want to do it manually, I just want to know when it's doing automatically.
Elax
I saw there is a button to manually Revaluate currency account, and there is an option to 'auto' revaluated them.
However, I didn't find anywhere what triggers a auto evaluation ?
Also, do this only reavaluate bank account or supplier overdue invoices ?
/Elax
I have this strange behavior : some GL post on the exchange variance account on transactions in the home currency.
Everything is in the home currency (payment and invoice) so I don't really know why we are here using the exchange variance account.
However, those particular transaction use a discount, and it seems that the amount posted as exchange variance correspond to the difference between the sum of the rounded discount and rounded sum of the discount.
The current transaction looks like
4000 Sales 1 Summer 2012 9.50
4000 Sales 1 Summer 2012 2.38
4000 Sales 1 Summer 2012 9.50
4000 Sales 1 Summer 2012 2.38
4000 Sales 1 Summer 2012 9.50
4000 Sales 1 Summer 2012 2.38
4000 Sales 1 Summer 2012 9.50
4000 Sales 1 Summer 2012 2.38
4000 Sales 1 Summer 2012 9.50
4000 Sales 1 Summer 2012 2.38
4000 Sales 1 Summer 2012 9.50
4000 Sales 1 Summer 2012 2.38
4000 Sales 1 Summer 2012 9.50
4000 Sales 1 Summer 2012 2.38
1100 Debtors Control Account 59.89
2200 VAT (20.0%) 9.98
4920 Foreign Exchange Gain 0.07
Total 76.55 76.55 7 items are sold for 9.50 with 25% discount (2.38 ). On the invoice they appears with a price of 7.13 and the total of the invoice is 59.89 which correspond to the line : Debtors Control Account, 59.89
However 9.50 - 2.38 is 7.12 (instead of the 7.13 invoiced) so I guess the FX gain of 0.7 correspond to 7 times this 0.10 difference.
So that's not a big deal, everything is pretty much alright. I'm just wondering why do we need to use this Exchange variange account instead of posting the correct discount : ie
If the price of the item is 9.50 and we apply 25% discount (2.375) resulting in a rounded price of 7.13, shouldn't the discount be
9.50 - 7.13 (ie price - rounded(price*(1-discount)) rather than
2.38 (rounded(price*discount))(or as the price is round up the discount should be rounded down ...).
I understand anyway, than it's wise to add at the end a stage to fix any rounded error and post them in a exchange variable account (even though I'm not sure that's the right one) but couldn't amount be right at the first plate ?
So my question is, is this a bug or a know issue which is considered as irrellevant (or does that need a different GL account)
/Elax
Found it. Apparently it's not by default on the admin role (as I didn't have this privilege, being an admin and haven't (as far as I remember) unticked it).
Anyway it works thank. What was a bit strange is after granting myself the prilivege, it didn't show up straight away, then magically appears. Is there some kind of caching somewhere ?
Elax
FrontAccounting forum → Posts by elax
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.