The issue here is to make the hardcoded Petty Cash Account as a dropdown set of bank accounts for Cash term sales documents. Otherwise, should a default hardcoded account to receive payments into be set in the Payment Terms for Cash Type using an extra field?
2,202 12/22/2017 04:36:08 pm
Re: Credit Card Sale (16 replies, posted in Accounts Receivable)
Setup => payment Terms => create new payment terms as Cash type but name it credit card. make an account code similar to cash and call it credit card. Make it a bank account - your merchant bank account.
It appears that the first non default cash type of account in the bank accounts gets hard coded in creating a direct invoice.
Quick Entries as in this post may be useful.
@joe: What is the correct way to make a "Cash" sale (Payment Terms) for a credit card transaction.
2,204 12/22/2017 04:12:02 pm
Re: how i can make the Tax calculate exactly? (3 replies, posted in Reporting)
Tax is set to be included in your price so 5000 * 0.05 / 1.05 = 238.10 SR. Setting it to be Tax Excluded will result in 250 SR = 5000 * 0.05. This setting is in Sales => Sales Types => Tax Incl (checkbox).
2,205 12/22/2017 03:38:37 pm
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
Then it should be a browser and version issue / OS issue.
2,206 12/22/2017 03:32:06 pm
Re: new report (21 replies, posted in Reporting)
Unzip into modules folder and a subfolder called rep_customer_ledger will get created. Now in your default company (generally company #0) go to Setup => Install/Update Extensions and "Install" the extension rep_customer_ledger. Then in the top dropdown box, choose Activate for target company and tick checkbox there. Logout and now login to your target company. Read the wiki.
2,207 12/22/2017 03:27:58 pm
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
Does the Ajax work for the Item field?
2,208 12/22/2017 03:19:58 pm
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Updated extension in last post with heading line fixed in template. I thought there was an export feature in it. The import_items extension has it though.
2,209 12/22/2017 03:07:22 pm
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Overwrite the corresponding files in <FA webRoot>/modules/import_transactions folder with the ones updated and attached here.
Export a set of transactions and use that format for importing transactions.
2,210 12/22/2017 03:01:38 pm
Re: is there youtube showing this? (2 replies, posted in Reporting)
You have quoted from the Wiki.
There is no YouTube video for this. You can create one and paste the link here.
2,211 12/22/2017 02:50:26 pm
Re: Reverse order of dropdown list from input box (9 replies, posted in FA Modifications)
In the text box before the dropdown select box for Items, only the item code can be typed. The dropdown will show the item name only and will be prefixed with the item code only if the "Show Item Codes" checkbox is ticked in the Preferences menu. Where do you get/see "symbols"?
If however, in Setup => Company Setup, the Search Items checkbox is ticked, then the textbox besfore the Items dropdown can be searched by Item Name when by Ajax, the dropdown will get filtered.
2,212 12/22/2017 07:31:26 am
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
Yes. The Ajax should be out of the "if" construct.
Attached is the "beautified" page.
2,213 12/22/2017 03:37:13 am
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
It is possible that somewhere in your code prior to displaying the form field, you are doing something like this:
$_POST['item'] = '';
or
$_POST['item'] = $myrow["item"]; // which may be blank
Also, if the third parameter of the function text_row() is null, then the value of the field is automatically taken from the $_POST array as seen in the function text_input's second parameter which it becomes in includes/ui/ui_input.inc file.
2,214 12/22/2017 01:35:31 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Your import file does not have the data in the correct format - the third ($memo) and last but one ($person_id) fields are missing in your data file's records.
The function get_standard_cost() was available in FA 2.3, being defined in it's includes/db/inventory_db.inc and can be inserted somewhere in the module's file: modules/import_transactions/includes/import_sales_order_entry.inc as:
function get_standard_cost($stock_id)
{
$sql = "SELECT (material_cost + labour_cost + overhead_cost) AS std_cost
FROM ".TB_PREF."stock_master s WHERE stock_id=".db_escape($stock_id);
$result = db_query($sql, "The standard cost cannot be retrieved");
$myrow = db_fetch_row($result);
return $myrow[0];
}
where you can replace the function name with it in the module's file.
If you wish to use the current code base, the above function has now been superseeded (on 2016-02-23 in FA 2.4 RC1) in the same file by:
function get_unit_cost($stock_id)
{
$sql = "SELECT material_cost
FROM ".TB_PREF."stock_master
WHERE stock_id=".db_escape($stock_id);
$result = db_query($sql, "The standard cost cannot be retrieved");
$myrow = db_fetch_row($result);
return $myrow[0];
}
The unit labour cost and unit overhead cost are also used now and hence the unit cost is sought to denote the unit material cost only.
Try the attached one that follows the latter code that leverages the currently available function.
@joe: which method is recommended?
2,215 12/21/2017 04:08:39 pm
Re: Load Error of Items in Items Tab (4 replies, posted in Items and Inventory)
Compare your php.ini and my.cnf / my.ini files between the ubuntu 16 and debian 9 installs. Timeouts may be an issue with php.ini settings. MySQL sql mode strict settings too can be an issue.
2,216 12/21/2017 03:13:26 pm
Re: new report (21 replies, posted in Reporting)
The updated extension is attached with whitespace synch with rep101.php and all CRLF converted to LF line endings.
Added to the FA24extensions repo.
2,217 12/21/2017 03:11:35 pm
Re: Auto Fill List of Values in a Text Input Fields (30 replies, posted in Modules Add-on's)
You may have to create / use a $_SESSION variable for it and / or enable autofill in the browser settings.
2,218 12/21/2017 03:08:26 pm
Re: Reverse order of dropdown list from input box (9 replies, posted in FA Modifications)
Which dropdown are you referring to and where?
2,219 12/21/2017 02:28:28 pm
Re: Can i create partner account for his equity on expense and sale base? (1 replies, posted in Banking and General Ledger)
Share Capital is what you are looking for. Profit/Loss distribution to the respective partners is like passing a shareholders dividend journal entry. Yes, FA fully supports partnership firms / partners accounting.
2,220 12/21/2017 02:26:44 pm
Re: Customers visible after inactive (4 replies, posted in Accounts Receivable)
This must be used with caution when there are transactions for the inactive customers / suppliers and when needed to be in future journal transactions.
2,221 12/20/2017 12:35:56 pm
Re: new report (21 replies, posted in Reporting)
A salesman is allotted to each customer branch. All sales to that customer branch will be under the specified salesman's log for commission / reporting purposes. If a sales order / invoice is made out to a customer's branch, the salesman can be looked up.
Report 101 does not have any salesman's column at all. The sql that generates the transaction list for the report is from lines 74 to 88 in the rep101.php - you can choose to link the cust_branch table in to filter the salesman you want.
2,222 12/19/2017 10:36:45 am
Re: Discount on Purchase Order, Receive, Supplier Invoice (11 replies, posted in Accounts Payable)
FA does not support discount on line items for purchases - it is there in sales invoices and reports.
An extension is currently needed to accommodate purchase order discounts for line items.
Purchase Invoice discounts are entered when payment is made for the whole invoice unless you choose to pay per line item when what you need gets accommodated as amounts and not as % discount.
2,223 12/19/2017 10:29:04 am
Re: how to increase dimension levels more than two (9 replies, posted in Dimensions)
All months in 2017 is best done using the date range in the reports.
The cost centres can be assigned Dimension 1 and can be filtered from there and / or with date range filter.
Using Summary choice in reports will give what you need as well.
The tags will be useful to track a certain set of transactions say pertaining to one specific tour group even across fiscal years.
2,224 12/19/2017 04:38:01 am
Re: Slim REST API module for FA 2.4.x - No Composer (18 replies, posted in Modules Add-on's)
Latest attached.
2,225 12/19/2017 04:36:27 am
Topic: Installed Third Party extension version display (1 replies, posted in Modules Add-on's)
Attached is mod to display the version of third party extensions by including a _init/config file in the module.
@joe: can commit it.