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 apmuthu
What is the input you are providing to extract the related "loc_code"?
The "loc_code" is looked up in the "locations" table to get the "location_name".
The "stock_moves" table records the "loc_code" for the transaction.
The "loc_stock" table records the "loc_code" where an item is stocked.
An ERD of the new tables (schema) that will be used in the extension should be set out for reference.
The install link must first be clicked and then the activation must be done for the company intended. The administrator and other users in the company (for which the extension was activated) should have their roles and permissions appropriately set.
At the close of the year, you should have a list of negative inventory items that you need to account for since your vendor has not invoiced you yet. This list of negative inventory items have actually been supplied by the vendor but stands to be invoiced. You can pass the necessary Supplier Invoices for such inventory as if you have received the invoices, with a note in the memo part to indicate the invoice status.
As in your case, this routinely happens, you can enter the supplier invoice when the goods arrive and then you can invoice your customer for the goods sold. When the vendor's invoice finally arrives, the reference numbers and memo updates can be done.
Either you use your own page counter variable in the report file and increment it just before each AddPage() (or FA's NewPage()) or use TCPDF's (reporting/includes/tcpdf.php) page variables ($page is the class property for the current page number, $pages is an array of the pdf pages) that the FA reporting engine uses.
Whilst $this->pageNumber is correct, the $this->totalPageNumber is not used in FA.
As the pdf generation progresses, the max number of pages in the document till then is $this->getAliasNbPages().
You need to be logged in as the said user before it can get it.
The said function is defined in lines 489-493 of includes/current_user.inc
function user_theme()
{
return isset($_SESSION["wa_current_user"]) ?
$_SESSION["wa_current_user"]->prefs->get_theme() : 'default';
}It is already available in the wiki - look at the section - Add Page to Report.
You can have a generic PDF included into the invoice. Alternatively, you can have a link in the Invoice pointing to a PDF file hosted at your site. Use the TCPDF page number variables at will in the report.
You need to choose the display language for the logged in user or as default for the company.
Answered in this thread.
https://frontaccounting.com/punbb/viewtopic.php?id=5169
https://frontaccounting.com/punbb/misc.php?action=pun_attachment&item=211&download=1
https://frontaccounting.com/punbb/viewtopic.php?id=6623
The reporting/rep107.php report file outputs the Invoice with the column formatting in $cols and $aligns arrays. The reporting/includes/doctext.inc file (included in the report file indirectly) populates the variable $aux_info with the necessary elements at line 104 - case ST_SALESINVOICE:.
Updated Wiki with the Tax Inclusion info.
FA provides Roles that can be used to provide specific modules access to any user assigned to the specific role.
However, out of the box, FA does not support segregation of POS to specific salesman - this means that if a Salesman is assigned to a POS, he can operate on any POS location. One or more POS are assigned to a specific location. But one POS cannot be assigned to more than one location at a time.
As this is specific to very few installs, please use the suggested workaround in the 12th post in this thread referring to includes/session.inc file.
@cambell: Your commit is quite nice. You might want to restrict the use of the TB_PREF to the FROM table alone and not in the other parts of the select statement. The WHERE clause can check for on or before instead of just before date.
$sql = "SELECT supp_trans.trans_no,
supp_trans.type,
supp_trans.supplier_id,
supp_trans.tran_date,
supp_trans.ov_amount,
bank_trans.ref AS bank_ref,
bank_trans.amount AS bank_amount,
bank_accounts.id AS bank_id,
bank_accounts.bank_name,
bank_accounts.bank_account_name,
bank_accounts.bank_curr_code
FROM " . TB_PREF . "supp_trans supp_trans INNER JOIN
" . TB_PREF . "bank_trans bank_trans ON (supp_trans.trans_no = bank_trans.trans_no
AND supp_trans.type=bank_trans.type) INNER JOIN
" . TB_PREF . "bank_accounts bank_accounts ON (bank_trans.bank_act = bank_accounts.id)
WHERE supp_trans.supplier_id=" . $supplier_id . "
AND supp_trans.tran_date <= '" . $date . "'
AND supp_trans.type=" . ST_SUPPAYMENT . "
ORDER BY supp_trans.tran_date DESC
LIMIT 1";@joe: Want to pull it in?
No customisation, no extensions.
Plain vanilla install of FA 2.3.25+ from official GitHub Master.
en_US-demo.sql - CoA with US demo data.
Test Environment:
Server and client (localhost) on WinXPSp3, XAMPP 1.7.3 having:
MySQL Server & Client version: 5.1.41
Apache/2.2.14
PHP Version 5.3.1
Browser FireFox v37.0.2
This change is important as there could be some instances where during some var scope / js / function execution, the value of a POSTed checkbox variable is set to 0 as would obtain when "cleaning" of POST variables occur. In such an instance, mere checking for the existence of the POST variable would be insufficient, it's value must be 1 (for single checkbox value as prevalent in all if not most of FA) or some pre-set value (some have the audacity to make it -1 when not chosen) and at the very least, that, if present, it should be checked if (not) zero.
Since no change is effected on the POSTed checkbox variable by the code using this function, please let me know how batch invoicing / delivery processing would be affected - do they change the value of the POSTed checkbox variable?
Fixed in my repo.
@joe: Please fix in both versions.
Try this:
Setup => Company Setup => Save
Even though the checkbox "Delete Company Logo" is unchecked and there is no change in the logo file that exists, the changes in other fields do not get saved and the error: The existing image could not be removed arises.
This is due to the fact that the function check_value() only checks if the checkbox element exists in the $_POST and not if it's value is set to 1 - some browsers (versions) and windows OSes tested in FA 2.3.x (test on other combinations and even in FA 2.4.x for corrections like this) need the said function in includes/ui/ui_input.inc:
function check_value($name)
{
if (!isset($_POST[$name]))
return 0;
return 1;
}to be
function check_value($name)
{
if (!isset($_POST[$name]) || !$_POST[$name])
return 0;
return 1;
}0 is generally evaluates false and if 1 is the value of a ticked checkbox enforced throughout FA, then a NOT check of 1 can be used.
In fact, a very thorough check to accomodate unlike variable type comparisions would entail:
function check_value($name)
{
if (!isset($_POST[$name]) || ($_POST[$name]+0) === 0)
return 0;
return 1;
}Setup -> Payment Terms.
The Wiki link in the 2nd post in this thread has a typo.
Direct Invoice should create a Sales Order and on Delivery, the Invoicing occurs. Hence payment is a separate entry for such tracking.
Shipping can be used for the excess and worded so or transferred by JV.
Sell Cylinder at say $10 per piece and credit-back as and when returned. If there is no price, tracking is difficult in the db.
Make a cash receipt for the amount you want to show in "Recovery" and allocate it to the appropriate partially unpaid invoice. Keep the rest of the cash for the cash invoice allocation.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.