Hello All,

I'm using FA ver 2.4.4.
I think Dimension works properly, as I input many Bank Transaction which is Expenses.
When I reporting "Profit Loss Drildown" and choose specific Dimension, it shows me "Bank Payment" transaction also.
So Dimension is working on Bank Statement.

My actually problem is When I see "Bank Account Inquiry". I saw there is no "Dimension" column.
So it is difficult for me to know which one is the transaction with/without Dimension.
I have to click small button "GL Trans View" just to see the Dimension. It makes me work slower.

I want to add "Dimension" column to the "Bank Account Inquiry" report.
Anyone knows how?
Thank's

Best regards,
Agus Widi.

Hello,

I need to see "Dimension" on Bank Statement.
For now I have to click small button "GL Trans View" just to see the Dimension.

How do I add Dimension Column on Bank Statement?

Thank's

Regards,
Agus Widi

Hello,

I'm using FA 2.4.4

I experiencing cannot edit transaction in General Ledger Inquiry.
I chose "Expense Account" which most of them  are Bank Payments.
The small edit button on the right are missing.
I checked every Expense account cannot be edit here.

BUT this is the strange :
The edit button appear when I select "Sales Account" Inquiry.

Why is edit button are missing.
Any setting for that?

Regards,
Agus Widi

4

(2 replies, posted in Setup)

Helo,

Dear Apmuthu.
How do I upgrade my FA 2.4.3 to 2.4.4 the best way?

Can I do this:
Backup Database of each company from FA 2.4.3 (using Backup Restore).
Then I install fresh copy of FA 2.4.4.
And then Restore my 2.4.3 backup files within FA 2.4.4.
Is it safe that way?

Or maybe there is another easy way?

Thank's

5

(30 replies, posted in Fixed Assets)

apmuthu wrote:

This should not be done. A stock item is not a fixed asset item. We are now using a different function for the checks here: check_db_has_depreciable_fixed_assets()

Where should I change to use :
check_db_has_depreciable_fixed_assets

Since I'm a new beginner. It's too complicated for me, please explain more. Like, which file, and row number. smile

Regards,
Agus Widi

Dear Apmuthu,

It works, thank's a million.

(Agus Widi)

7

(30 replies, posted in Fixed Assets)

Hello,

Dear Joe and Apmuthu.

Thanks for the the update below:
https://github.com/FrontAccountingERP/FA/commit/2e95a5672e4cabeaba603da7ac1105c3acb865ea


I follow and tested the script. 
The Process Depreciation is working, I'm using the original file of "data_checks.inc".
Now I go to Manage > Fixed Assets.
Usually I can select Fixed Asset that I have inputed before (I have several).
But Now I cannot see this : ---> Select an item: (which is usually placed on top).
So it makes me cannot modify an Fixed Asset.

Fortunately, I did following (AGAIN):

I've looking for the source code : 'data_checks.inc'

ON line 251, I 've found  this code :
function db_has_stock_items()
{
    return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag!='F'");
}


I changed it to :

function db_has_stock_items()
{
    return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag='F'");
}


Now, I can manage Fixed Asset.
I can select Fixed Asset and edit them.

I guess this problem related to "Process Depreciation" problem that I have submitted before.


Regards,
Agus Widi

8

(30 replies, posted in Fixed Assets)

Hello Dear Apmuthu.
I guess you mean is : process_depreciation.php. (Yes, stands corrected now. Thanks).

BTW. I follow your suggestion. It works.
I think this is the best update so far.
Thank you.

Hello,

I'm From indonesia.
I'm using : Banking and General Ledger > Transaction > Journal Entry.
I need to increase width for text input of Amount Debit and Credit cause our currency often has 8 digit numbers. It is uncomfortable to see the number only a half after input.

How do I change width?

Regards,
Agus Widi

10

(4 replies, posted in Translations)

Hello,

Is any body able to add line to po file?

I'm Indonesian, and need translate some part.

Regards,
Agus Widi

11

(30 replies, posted in Fixed Assets)

Hello,

Yes I see the function db_has_depreciable_fixed_assets().
But my issue was not that one.
As I mention the errror message was : "There are no active fixed asset defined in the system."
And it refer to Function : db_has_stock_items().

I still go on with changed script.
I see The Process Depreciation work well, as it should.
I'll inform the further problem.

Regards,
Agus Widi

12

(30 replies, posted in Fixed Assets)

Hello,

Dear apmuthu,
I've looking for the source code : 'data_checks.inc'

ON line 251, I 've found  this code :
function db_has_stock_items()
{
    return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag!='F'");
}


I changed it to :

function db_has_stock_items()
{
    return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag='F'");
}

Now 'Process Depreciation' works.
Still I'm confused and worried, is there any consequence on another module if I change this.
Is this a BUG?

Regards,
Agus Widi

13

(30 replies, posted in Fixed Assets)

Helo,

Thank you apmuthu for the reply.
FYI I logged in as System Administrator which is Checked for everything in Setup --> Role, including Fixed Assets.
I'm All ready input : Fixed Assets Class, Categories, Location, And Fixed Assets itself.
Also After that I Already input : Fixed Assets > Transactions > Fixed Asset Purchase.
So I can see the Fixed Asset Item listed on 'Fixed Asset Valuation Report'

Now the problem is I cannot 'Process Depreciation'.
It keeps saying  : "There are no active fixed asset defined in the system."

FYI :
My fiscal Year Start 01-01-2017
My fiscal Year End 31-12-2017
I input one purchase on date : 01-01-2017

What should I do?

Regards,
Agus Widi

14

(30 replies, posted in Fixed Assets)

Dear All

I cannot process depreciation. It said :
"There are no active fixed asset defined in the system."
But in --> Fixed Assets Valuation Report. I See the Fixed Assets was there.

I'm using 2.4.3 version.
Don't know what to do.

Please help,
Regards,
Agus Widi

It makes me confused, I tried using new COA USA, and try the same test using USD as home currency. It works fine with The end date 27-11-2017. Hmmm?

I have this situation too, my preferencess DD-MM-YYYY.
Already logout, Clear Browser cache. Then login.
Still the datepicker output is MM/DD/YYYY.

I tried this on Inventory Valuation Report.

How to fix this?

No Joe. It is not the decimals.

Here I found just now.
I created new company and start with empty data.
I inputed Direct Supplier Invoice using date 27-11-2017.
When I access Inventory Valuation Report with end date 27-11-2017 it shows 0 (zero) on Unit Cost.
But when I put End Date 28-11-2017 or 30-11-2017 the Unit Cost shows the value.

Don't you think if I put 27-11-2017 The unit cost allready should have value?

joe wrote:

Yes it is related to the currency. Try to increase the currency decimals in user preferences, f.i. 6.

Joe

Unfortunately it doesn't help. The problem persist.
Any ideas?

Hello,

I facing all the item showing zero on Unit Cost.
I'm using Indonesian Currency,
My Preferences :
Date Format:DDMMYYY   
Date Separator:    -
Thousand Separator: .
Decimal Separator: ,

I 'm not sure what may causes, but when I created new company using USA standar Account, it works. Is it related to currency?