526

(14 replies, posted in Setup)

Ok so that worked: The inactive tax type now cannot be seen:-

File: \includes\ui\ui_lists.inc
1237:     
 - $sql ="SELECT id, name FROM ".TB_PREF."item_tax_types";
 + $sql ="SELECT id, name, inactive FROM ".TB_PREF."item_tax_types";

Questions:-

Is this a bug?
If not what is the intended functionality?

527

(14 replies, posted in Setup)

So to investigate, the inactive flag is being posted to the server, so all tax, tax type, tax group are ok, and unlikely to have same bug in all three..

So File: \inventory\manage\items.php
394:     item_tax_types_list_row(_("Item Tax Type:"), 'tax_type_id', null);

calls to

via function item_tax_types_list_cells

File: \includes\ui\ui_lists.inc

1235: function item_tax_types_list($name, $selected_id=null)
1236: {
1237:     $sql ="SELECT id, name FROM ".TB_PREF."item_tax_types";
1238:     return combo_input($name, $selected_id, $sql, 'id', 'name', array('order' => 'id') );
1239: }
1240: 

I cannot see anything with inactive in here, comparing to other similar functions in ui_lists.inc; should line # 1237 read something like:-

$sql ="SELECT id, name, inactive FROM ".TB_PREF."item_tax_types";

I will try it

528

(14 replies, posted in Setup)

I even tried on a different browser

529

(14 replies, posted in Setup)

I did that, still can see the new tax type.

530

(14 replies, posted in Setup)

Hi,
Clean install with 'Standard new company American COA (4 digit)
No other entries made.

Created a tax, tax group and tax type

In create new item, tax type: new tax type can be selected from drop-down list, did not create item.

Then inactivate the new tax, tax group and tax type.

Return to create items and the new tax type is still available and can be selected and used?

Checked the database and inactive is 1 for the three taxes.

Server cache cleared
Browser cache cleared

Not sure if I'm doing something wrong or this is a bug?

531

(2 replies, posted in Setup)

Thanks apmuthu thats a lot clearer now

532

(2 replies, posted in Setup)

Hi, I've searched for in the wiki and here in the forum and cannot find anything about Tax Algorithm in Setup -> System and General GL Setup there's two options: Taxes from totals & Sum per line taxes?

I'm guessing it has something to do with rounding?

Any help appreciated.

533

(9 replies, posted in Wish List)

Yes, you are right, a cust_branch is required.

Thanks for the strike-through tip Thats needs to be edited in BBCode as it just says /[del/]/[/del/]

534

(9 replies, posted in Wish List)

The current Customer Detail Listing report lists each customer followed by all branches of that customer, so the actual output of the report is fine (with the exception of no sales group).

535

(9 replies, posted in Wish List)

How can you assign a branch to more than one sales group?

536

(9 replies, posted in Wish List)

@apmuthu, you can assign a different sales group by branch if that's what you mean? Thinking about it that may be not what you meant. But branches are listed when you print the customer detail report

@apmuthu how do you write strike-through text? Google says [s][/] but this doesn't work as you can see.

537

(9 replies, posted in Wish List)

From what I can see sales groups are only used in recurrent invoices; for sending a recurrent invoice to multiple customers: To manage this or to see which customer will get a recurrent invoice, it is necessary to wade through every customer to see which if any sales group they are assigned to; or keep a separate spreadsheet with this information on: Neither option is ideal and both leave plenty of room for human error. Its difficult with 50 customers, with hundreds...???

Proposal: Modify the existing Customer Detail Listing report to include sales group in the details shown and provide a drop-down menu in the Customer Detail Listing report to show by sales group (there is already 2 available - Sales areas & Sales persons) It would then be easy to see which customer is in which sales group.

No you have sold an item for 95.24 + 5% sales tax = 100

FA lets you have tax included or excluded.

You have chosen to sell the item using the retail sales type, go to Sales -> Sales Types, and you will see 'Retail' uses included taxes, edit this or create a new sales type.

For additional info on sales types, look in the Wiki

The correct way to hide any menu item is change the line

$hide_inaccessible_menu_items = 0;
to
$hide_inaccessible_menu_items = 1;

in config.php

Then any menu item not accessible to the user as defined in Setup -> Access Setup will not be visible

@ joe ??? the sidebar link should go to https://frontaccounting.com/fawiki/index.php?n=Help.Fixed-Assets shouldn't it?

At the moment the sidebar link is to here:- https://frontaccounting.com/fawiki/index.php?n=Help.FixedAssets

The eleven other pages are already created linking from https://frontaccounting.com/fawiki/index.php?n=Help.Fixed-Assets

541

(3 replies, posted in Setup)

Thanks Janusz

542

(3 replies, posted in Setup)

A little more info, from includes/references.inc line 55:-

$refline_placeholders = array(
    'MM' => 'date',
    'YY' => 'date',
    'YYYY' => 'date',
    'UU' => 'user',
    'P' => 'pos',

So user number would be from users - _users id.

Still uncertain about {P}, my reading of the code states its _user pos, which I believe is Point of Sale - Please confirm

In Transaction References, the only placeholders allowed are {UU},{P},{MM},{YYYY} & {YY}

So MM is month - 10
YY is year - 17
YYYY is year - 2017

But what are {UU}&{P} for?

I tried using them and they came out as 01 & 1 respectively, and they did not update for the next transaction?

544

(6 replies, posted in Banking and General Ledger)

Just so we're on the same page.. FA 2.42 go to setup - Transaction References - edit a reference copy an paste the following:- {YY}{MM}-{001} exactly as it is written with curly brackets and YY & MM. This works for me. My pasted example gives 1710-001, my next entry was 1710-002, etc....

545

(6 replies, posted in Banking and General Ledger)

Hi, just tried this,... {MM}{YYYY}/{001} Which gives 102017/001, next invoice  updates to 002, So for your case JV-{YY}{MM}-{001} will work.

Placeholders can only be {UU},{P},{MM},{YYYY} & {YY}


Not sure what the {UU}&{P} are for; they give 01 & 1 respectively.

Go to Setup then company setup, on the right you will see a section labeled 'Optional Modules' Uncheck Manufacturing, click update button, log-out then log-in

547

(5 replies, posted in Wish List)

@joe & @apmuthu I have written the bare bones of the fixed assets wiki, the main page is here:-

https://frontaccounting.com/fawiki/index.php?n=Help.Fixed-Assets

And the eleven other pages linking from this page... Do you need the links posted here?

In the interests of full disclosure "I am not an accountant"

Therefore someone with accounting knowledge needs to review and edit what I written as soon as possible to avoid any dis-information.

To reiterate it is only the bare bones, with a little fleshing out here and there.

What needs to be done:-

1. As apmuthu mentions the link needs to be added to the wiki sidebar, I have tried to edit the sidebar myself, but it just asks me for my login repeatedly, I can only assume that I do not have the necessary permissions or I'm doing something wrong?

2. Full review by an accountant of ALL pages (I have tested what I have written but in no-way 100% certain)

Still to do:-

3. Screenshots need to be added for all pages.

4. Additional examples for the four basic depreciation types need to be added to the main fixed asset page, this should reduce fixed asset posts in the forum. Also I'm not sure if different examples need to be added for nil-value at end of depreciation term and a value at end of depreciation term, for example a car after 3 years; or would an accountant understand how to do this?

5. Additional tips and tricks and FAQ's need to be added where necessary, forum users should help with that.

6. Relevant links to any forum posts need to be added, I have searched, but could not find much?

7. The link to the reports wiki page needs to be added, I (admittedly briefly) tried to find out how to do it, but could not see it anywhere. I think it requires some sort of re-direct link like the other reports links in the other module pages

8. The reports wiki page need to be updated with link to relevant screenshot of the report (there's only one!)

9. Ask existing forum users for their experiences, feedback, etc of using the fixed asset module, and edit pages accordingly: If they are unsure of the wiki mark-up, they can just write in plain text, someone can format it later, or add a post in the forum and someone can edit the wiki accordingly.

548

(5 replies, posted in Wish List)

@apmuthu, Now that the fixed asset module is part of the core, would it help users if fixed assets had its own category in this forum?

There is possibly an argument for dashboard as well? But I'm not so sure about this?

@urnexgen - Just to backup what kvvaradha says:

The instructions included in the package - FrontAccounting-Mobile-Edition.pdf state in item 3.

We assume that you have install a new version of FrontAccounting 2.3.4 / 2.3.5 / 2.3.6 /2.3.7
without any modification.

So FA 2.4.2 would be incompatible with this mobile version

What is the end result you are trying to achieve?

Hi, where did you get the mobile version from? Please give the URL