Following this discussion. These 3 distinct dates are there for separation, aren't they ?

I have got a scenario like this :

My company owed an invoice that's due 30 November 2018. But the finance department forgot to pay it until recently on 28 February 2019.

What would the journal be in this case ?

Do I put journal date 30 November 2018 and transaction/event date on 28 February 2019 ?

27

(30 replies, posted in Fixed Assets)

Thanks very much @mugao-em,

I think this answers my question. I think you are right. Rate is annualized regardless wether you select Yearly or Monthly. Now that I have fiddled around more I think that's what it means

So for Depreciation starts actually start 1 period after Depreciation starts are kinda confusing, but I get it now. Maybe for future revision of FA we can do better /w choosing the right word as to not potentially introduce more ambiguity

28

(30 replies, posted in Fixed Assets)

Ok. After fiddling aroud a bit I think I understand more how to use Depreciation features on FA ...

However, there are 2 things that still confused me

1. The correct rate to use for straight line
Example I want to deprecate item "A" of value 1,200,000 for example for 2 years ( 1,200,000 / 24 = 50,000 each month ).
Now 50,000 / 1,200,000 is about 4.167% or 4.2% in FA's straight line

If I enter 4.2% in straight line method and process depreciation for "A", how come the depreciation value is 4,200 ? while I should be expecting 50,000 each month ?


2. How does FA decides when it starts to depreciate ?
On Fixed Asset item definition, you are provided field "Depreciation Starts" and I enter 1/1/2018.
And on purchase this particular Fixed Asset dated on 1/1/2018

When you want to start Process Depreciation however, the "Starting From Month" is February 2018 or March 2018 in some cases, but never on January 2018

Thanks
I don't think wiki covers this

29

(30 replies, posted in Fixed Assets)

Hi guys, I'm using FA2.4.3 and at the moment I'm trying / studying the Fixed Asset feature in its relation to Depreciation etc

I can add/deprecate fine, it's not a problem. What seems to be a problem is the following

1. That when you input fixed asset purchase, say, on 3-01-2018 ... The depreciation only started 2 months later ( March 2018 onward ). Is there a way to set this to deprecate 1 month after ?
2. And what more alarming is that, you can ONLY deprecate for the remaining 10 months until December 2018. The item that I want to deprecate has probably 10 years lifecycle, like a production machine

Is this currently the limitation of using FA, or is there a setting that I need to adjust in order to make multi-Financial year depreciation ? I don't think 2.4.4 address this already, does it ?

At the moment, the only way to address multi-year depreciation is by entering manually on Journal Entry just like old days /w Excel ...

Thanks Guys,

30

(14 replies, posted in Setup)

This sounds great too. Maybe in conjunction with import transaction extension but probably friendlier to execute

While it's recognized and listed, I could not activate it.

Whenever I put a tick on the checkbox and save, FA says it is saved succesfully while it actually not

Upon logout and login back again the checkbox won't be ticked

I'm definitely interested in trying out some of these newer extension, especially Sales Map since I'm developing somewhat similar to like this using Leaflet (https://leafletjs.com/) to map out company customers and such

I'm new to FA environment and started only recently using FA24. Anyway, How do you get manually installed extensions such as the one @apmuthu hosts here to work correctly ?

I have modify ./installed_extensions.php to include the new module and update $next_extension_id correctly. for example :

5 =>
    array (
    'name' => 'Bank GL Inquiry (new)',
    'package' => 'bank_gl_inquiry',
    'version' => '2.4.0-4',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/bank_gl_inquiry',
  ),

I have also made sure appropriate permissions are already assigned to bank_gl_inquiry for www-data

On Setup => Install/Activate Extensions, the new modules are listed but it's unknown in the column Installed and Available

What steps am I missing ?

Cheers

33

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

Alright. Got it. Cheers

So FA24's dashboard is already included, unlike FA23 where it was as Extensions etc

I suggest we can either update or remove the Wiki entry.
It was quite confusing, because it suggests before you use Dashboard you need to enable and set permissions accordingly ... which you no longer need to do that in FA24, right ?

Also, Can you modify the dashboard from FA24 web interface ? The Wiki seems to suggest you can select Dashboard Setup and Dashboard Reminders. Or is this no longer relevant from FA24 ?

34

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

My repo is pointing at :

$repo_auth = isset($SysPrefs->repo_auth) ? $SysPrefs->repo_auth :
array(
     'login' => 'anonymous',
     'pass' => 'password',
     'host' => 'repo.frontaccounting.eu', // repo server address
     'branch' => '2.4'    // Repository branch for current sources version
);

This is the correct repo address for extension and themes, isn't it ?

35

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

Yeah, I don't think Dashboard extension is included in my FA24 repo. The following are the only options available when I want to
'Install/Activate Extensions' from the Setup page

Extension    Modules provided    Options provided    Installed    Available        
Auth_LDAP            None    2.4.0-3        
Inventory Items CSV Import            None    2.4.0-3        
Import Multiple Journal Entries            None    2.4.0-3        
Import Paypal transactions            None    2.4.0-1        
Import Transactions            None    2.4.0-5        
osCommerce Order and Customer Import Module            None    2.4.0-3        
Annual balance breakdown report            None    2.4.0-3        
Annual expense breakdown report            None    2.4.0-1        
Cash Flow Statement Report            None    2.4.0-1        
Check Printing based on Tom Hallman, USA            None    2.4.0-3        
Check Printing based on Tu Nguyen, Canada            None    2.4.0-1        
Dated Stock Sheet            None    2.4.0-1        
Inventory History            None    2.4.0-1        
Sales Summary Report            2.4.0-1    2.4.0-1        
Bank Statement w/ Reconcile            None    2.4.0-1        
Tax inquiry and detailed report on cash basis            None    2.4.0-1        
Report Generator            None    2.4.0-4        
Requisitions            None    2.4.0-3        
zen_import            None    2.4.0-4        

I don't see option to install Dashboard from these

Is it actually supposed to be there or this is something that you do manually ( ie download from the master's link that you provide and goes from there ) ?

36

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

*Update
Found it :

https://github.com/apmuthu/frontaccounting/tree/master/extensions/Extensions/dashboard
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Themes/dashboard_theme

is this something that you install manually ? or you can get it off from the official extension Repo ?
also probably, a better question to ask is, is this still compatible with the current FA 2.4.3 or 2.4.4 and working ?

37

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

Hi team,

I'm currently on FA 2.4.3 and was wondering what is the current 'state' of the Dashboard feature ?

The Wiki (https://frontaccounting.com/fawiki/index.php?n=Main.Extension-CompanyDashboard) suggests that it's something
that you download as both extension and themes separately and activated the appropriate user access before it can pop-up
as one of the Tabs above

On FA 2.4.3 there is already 'Dashboard' button next to preference and such. So I guess the day where you need install extension
and themes for dashboard is no longer viable from this version and up, yes ?

On the other hand, some search from google and FA's forum seem to suggest that you can, modify the dashboard to your needs and such just like how you write your own report format etc

How do I get started on dashboard ?
I seem to stumble upon apmuthu's FA24 extension list that has dashboard on it, but somehow could not find it again

Cheers,

38

(20 replies, posted in Banking and General Ledger)

Yes. I am not sure yet. Only this installation somewhat misbehave ... My other installations seem to be doing fine.

Will post more when I know more

I am using Indonesian's COA btw

Cheers

39

(20 replies, posted in Banking and General Ledger)

@apmuthu : alright. thanks. there is no correlation between what I did earlier ( adding a field 'memo_' to budget_trans ) to somewhat the disappearance of date_picker.js, is there ?

If so, what might contribute a 404 error ?

*Update : I did purge. However whenever there is a select date From and To. The To will use datepicker but with 'undefined' Month, whereas the value should've been July / August / other months accordingly

code wise, there may be some mini error to 'TransToDate' function ?

from gl_trial_balance.php

<td><input type="text" name="TransToDate" class="date"  size="10" maxlength="12" value="31/07/2018" > 
<a tabindex='-1' href="javascript:date_picker(document.getElementsByName('TransToDate')[0]);">    
<img src='../../themes/default/images/cal.gif' style='vertical-align:middle;padding-bottom:4px;width:16px;height:16px;border:0;' alt='Click Here to Pick up the date'></a>

40

(20 replies, posted in Banking and General Ledger)

This scenario happens to me too. and thanks to brucek@pelhamhs.org's, the missing 'memo_' field on budget_trans is the culprit

I'm using v2.4.3 with Indonesian's 4 Digit COA. I can confirm that in apmuthu's GitHub the 'memo_' field is there, it's probably didn't make way to official sourceforge yet ? That's the FA version that I downloaded and what currently in use

After adding the 'memo_' field, I now notice something FUNNY with datepicker.js ( It complains 404 ! when you want to pick a date ). I have no idea where it comes from; I swear the only modification I made was adding the 'memo_' field to my budget_trans table. There's no correlation between these two, right ?

Paginated entries. We can stick to the way as it is, with <<First Prev Next Last>> as usual. That's option 1. We can improve to option 2 but I guess it's for different topic forum

Whatever User moves to Next or even Last pagination, it doesn't matter. The summary table will stay afloat the same regardless, which is below the main table

The summary table will gave you summary / simple statistics according to search parameter that user has set before like
( ie. between these dates, show sales invoice only, etc )

The good thing about this addition is that you can apply to almost all Inquiry in FA : Sales Quote, Sales Order, Purchase Order, Journal Entry, etc

Just I thought it's very useful to have some simple statistics to summarize your search

FA doesn't seem, at the moment, have a summary table which you can put underneath Sales Order / Quotation Inquiry whenever user inquire about them, does it ?

https://preview.ibb.co/jg4SZ8/Screenshot_2018_07_13_at_14_37_01.png

*Adding summary table below that will make it easier to see some simple statistics, like
- how many quote produced this period ?
- what is the total ?
- what is the average, for example ...

Is this already there, but hidden somewhere ? Or do we have extension that can do that ?

Hi team,


I have tried to look in Setup/ Company Setup and such but I just could not find it.

How do you set the account for which 'Cash Only' Payment will go ?
At the moment it's always goes to 'USD Cash' ... I would like to change to different account,
as for Cash only payment we receive in different currency

44

(5 replies, posted in Setup)

Hi @apmuthu, I don't think I understand yet. I know that we can create/clone role and modify permissions as such. However, it seems that you are suggesting that you can

apmuthu wrote:

create one for switching off the add/view purchase price permission as well which needs to be instantiated in the role instanciation script as well.


How do we go about it ... creating add/view purchase price permission ?
What role instanciation script ?
Maybe you can point out to some development notes / wiki that covers this and I can chase it up

45

(5 replies, posted in Setup)

A quick search of the word 'price' on Access Setup just gave me 3 result(s):


1. Sales configuration -> Sales prices edition
2. Sales related reports -> Sales prices listing
3. Purchase configuration -> Purchase price changes


@apmuthu, do you mean to toggle off result no.3 ?

46

(5 replies, posted in Setup)

Hi team,


In my client's company there is a Purchasing division who consists of
1. Purchasing manager ( the head )
2. Purchasing admin ( the underling )

Now, Purchasing admin is only supposed to input purchase order whenever there's request from production floor. let's say, for example production floor needs more banana for which later approved by Purchasing manager. This is simple workflow

The policy in place is that Purchasing admin is not handling price nor have knowledge about how much banana is from supplier A or B and such. What Purchasing admin needs to know is that he/she needs to input PO and that's it. he/she doesn't or not supposed to care about price and such

I know that the solution that I'm looking for is probably to delve straight into codes and make slight adjustment, similar maybe to what this post was
https://frontaccounting.com/punbb/viewtopic.php?id=3514


Before I do that though, I'm hoping there are more elegant solution to this scenario ?

Purchasing admin doesn't need to know to about price. Hence when he/she input FA's Purchase Order Entry, we would like to 'hide' price or just not put it to display at all. He/She just need to input how many banana are needed

Later on, Purchasing manager can login to FA and starts reviewing the PO that was inputted and made decision wether to aprrove or not

Well, this is an extension to previous wish list that's now been implemented. I would love to see if this can be extended to apply
to Report option as well which you'd normally access it from

http://localhost/frontaccounting/reporting/reports_main.php


Original wish list :
Hide Menu options if not authorized
https://frontaccounting.com/punbb/viewtopic.php?id=1128

Maybe it's far stretch from now. But the motivation is the same, for those users who are not authorized it's better that :

a) we hide higher-level access completely from their menu or report; rather than having
b) greyed-out or make it avalable but then there will be warning that users are not authorized to do so



What you can't see, you can't fiddle around with it
If you can see, there are temptation to fiddle around with it

48

(20 replies, posted in Banking and General Ledger)

Ditto. same here. Entering budget in Budget Entry doesn't save it.
Same goes after you select GET after choosing Financial Year and Dimension

version 2.4.3 - new installation. not an upgrade from previous version

I'm using Indonesian's Chart of Accounts. Any chance that may be the 'culprit' ?

49

(10 replies, posted in Setup)

poncho1234 wrote:

If you have created documents/transactions using that prefix you will not be able to edit it
If you have not created any documents/transaction using that prefix you will be able to edit it

Yes, I understand this now. However, think of the following

If you have created documents/transactions using that prefix, you can change by editing the Reference Pattern field
If you have not created any documents/transaction using that prefix, you can change by editing the Reference Pattern field

Hence, there is no use to mention the field 'Prefix' at all IMHO since it plays no role at all.

Prefix is supposedly already a 'part' of Reference Pattern normally, therefore there is no need to
separate them nor give illusion that you can edit them separately

50

(2 replies, posted in Accounts Payable)

Hi Iljas, I'm not sure what do you want to achieve here ?

What does it mean to 'reverse' supplier invoice exactly ? if voiding it means reverse, as you mentioned, it's just the same with voiding the supplier invoice and hence render it not valid isn't it ?