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
Treat the VAT Office as a supplier/vendor (even though citizens who do not get their taxes worth are entitled to consider them dacoits selling thin air 
). Make each VAT claim a supplier's invoice. Make each re-payment from the VAT Office as a Debit Note first and then fulfilled by their re-payment by allocation.
@joe: any SOP for it?
Wiki-ed it.
You need to install the it_IT locale in Ubuntu on the console first.
The function scroll_down() is defined in @braathwaate's version of includes/ui/ui_controls.inc:
function scroll_down($div)
{
global $Ajax;
$js = "
var objDiv = document.getElementById('" . $div . "');
objDiv.scrollTop = objDiv.scrollHeight;
";
if (in_ajax()) {
$Ajax->addScript(true, $js);
} else
add_js_source($js);
}You can include the above function in the bank_gl_inquiry.php file or comment the scroll_down() call as @braathwaate stated.
Windows or Linux server?
All the $ variables need to be populated and then the sql needs to be extracted.
Read the Troubleshooting page in the Wiki.
Try to display the sql after the sql. The where clause addresses the issue of absence of voided entry.
Are you using the new method of pattern based document numbering or is it based on the old v2.3 method?
File: admin/db/transactions_db.inc line 183+:
function get_systype_db_info($type)
{
switch ($type)
{
case ST_JOURNAL : return array(TB_PREF."journal", "type", "trans_no", "reference", "tran_date");
case ST_BANKPAYMENT : return array(TB_PREF."bank_trans", "type", "trans_no", "ref", "trans_date");
..
..File: includes/references.inc Line 183:
$db_info = get_systype_db_info($type);
## For a Journal entry, it will be:
## $_db_info = array(TB_PREF."journal", "type", "trans_no", "reference", "tran_date");Line 170+ in the same file:
$sql = "SELECT MAX(CAST(SUBSTR($ref_fld, ".(strlen($prefix)+1).",LENGTH($ref_fld)-".(strlen($postfix)+strlen($prefix)).") AS UNSIGNED))"
." FROM `$trans_table` tbl
LEFT JOIN ".TB_PREF."voided v ON tbl.`$tno_fld`=v.id AND v.type=$type"
." WHERE ISNULL(v.id)"
.($type_fld ? " AND tbl.`$type_fld`=$type" : '')
." AND `$ref_fld` REGEXP ".db_escape('^'.preg_quote($prefix).'[0-9]*'.preg_quote($postfix).'$');@joe: anything wrong here?
What I meant was for on-the-fly cost estimation. In your case, you would create a separate manufacturing work order and then zero the output and treat it as fulfilled and keep it like a template for future use.
Actually it will the other way around. When a form is filled in, it acquires the cost data from the tables and outputs it.
Sales => Customer Payments => make the customer deposit and not through journal.
Then Sales => Allocate Customer Payments or Credit Notes => and allocate what you want to the XYZ invoice.
If your Administrator Role has the permissions to change old entries, you then can.
See Attachment.
Logout and Login again for permission changes to take effect.
As long as each tax is named uniquely, they should all be added correctly. What does the UI now show? Make sure that the tax on tax is configured as desired. Maybe you want a Tax Group to be assigned.
@oakstreet1: Thank for the feedback.
Stands Wiki-ed.
Provide sample cost estimation sheet and what fields from it need to go into what fields in the which form in FA.
@braathwaate has provided an item category filter mod that can be included in the core.
The attachment has the diff file and the file set for the current core version.
@joe: want to include it into the core?
Unzip the attached file into your <FA_webroot>/lang folder.
Just add a stanza for your language in lang/installed_languages.inc.
Now you are good to go.
Preferences => Italian
@jkent3rd: Thanks for the info.
Stands Wiki-ed.
@braathwaate has been good enough to release a few of his modules.
The FA community is requested to test them out and provide feedback.
Use DownGit to download just the modules you wish to test out.
The modules are:
Sales Map - Interactive map of customers with active sales history
Customer Statement Report - enhanced
Picklist for deliveries - US Packing List
Sales Type Summary Report
Bank GL Inquiry - with memo
The Italian Language files for FA 2.4.x is in my repo which may have some additional strings since the official repo was updated.
The Italian chart of accounts has default VAT set at 22% and A4 paper and has been added to my repo. You may have to set your decimal and thousands separators as needed in the user preferences / company defaults / config defaults.
Download en_IT-general.sql and place in your sql folder and use for creating your company.
Upload an annotated screenshot somewhere and post the link here.
Also make sure you are using the latest Git Master FA codebase. The changed file list from FA v2.4.3 to v2.4.4 is available in this post (not needed for you now as your are already on FA 2.4.4) and the subsequent changed files are in a succeeding post in the same thread.
@joe: any headway?
In a prepayment, we may not know the freight cost then. Whatever way you import, it is best to edit them later to reflect actuals.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.