Doesn't the dash board give some of this info?
It gives top 10.
You could use this as a starting base for the report?
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 poncho1234
Doesn't the dash board give some of this info?
It gives top 10.
You could use this as a starting base for the report?
Though if treated as a block - single asset; if one becomes damaged/sold/etc then you have a problem...
@cowlas suggest you add to the 'Wish List' sub-forum
Yes it's quite a large modification and beyond my capabilities, changes to core sales and purchasing modules to assign a tax by item. Also the 2 taxes per item (9/9%) will add complexity. I’m not sure if this is possible as an extension. Reports also would have to be modified. Changes to the GL may have to be made too.
Maybe apmuthu has a suggestion? Or you could ask for a quote in the Jobs Wanted sub forum or the 'Wish' list
Two items?
Coolant Valve - 1 Inch (9%)
Coolant Valve - 1 Inch (18%)
Inventory issue - 1 stock only' Coolant Valve - 1 Inch (9%)', before sale of 'Coolant Valve - 1 Inch (18%)' negative adjustment 'Coolant Valve - 1 Inch (9%)', then positive adjustment to 'Coolant Valve - 1 Inch (18%)'
or allow negative inventory if inventory management is not required?
If this is for occasional use then its workable
Someone else may have a better idea?
Does Paul Shipley's Australian Tax Invoice extension resolve the tax type /amount per item? Or does it require further modification? (I've not installed it so not sure what is included?)
Thanks apmuthu, that's a very good idea, i'll check those out tomorrow
If not please give detail, there may be another work around???
@apmuthu - also is this module relevant here?
Is there a way to disable server side caching temporarily for development?
Its time consuming to delete the server side cache after every change in code
@apmuthu - I think maybe I have misunderstood, but if i create a item 'Oranges' I can sell oranges in Texas to a customer for 5% and the same product item to another customer or branch in Maryland at 3% using FA - Tax Groups which is assigne in customer/branches.
What have I missed?
@apmuthu - This proposal is for pdf docs only
You can assign tax by customer; so if a customer located in one state can be assigned say a 3% tax, then a different customer located in a different state can be assigned a different tax of 5%
You may have a customer with different branchs in different states, a different tax can be assigned to each branch of the customer
We feel that a lot more people should know about FrontAccounting.
Everyday tens if not hundreds of documents are produced/printed sent to suppliers, customers, accountants, banks, etc using a FA installation – this is an opportunity to directly target potential FA users.
Currently in the default legal text it states www.frontaccounting.com, but this can easily be deleted/changed and the legal text does not appear in all documents
The vast majority of pre-printed invoices etc have the name of the printer/program used on them; so why not FA?
So if we hardcode the following:-
$this->SetX(15);
$this->SetY(150);
$this->SetFont('helvetica', 'B', 8);
$this->SetTextColor(153, 211, 245);//That’s the blue from FA icon
$this->StartTransform();
$this->Rotate(270);
$this->Cell(0,10,'Generated & Printed by www.frontaccounting.com Open Source Accounting, Inventory management and ERP for your business', 0, 0, 'C', 0, 'http://www.frontaccounting.com/');
$this->StopTransform();
$this->SetTextColor(0, 0, 0);
Note on script: ‘$link’ in tcpdf seems to be for internal document links, not urls; but most pdf readers will pick www.etc as a link (firefox pdf will not, chrome pdf does). Even if it is not picked up as a clickable link the words are there to be seen.
Also I had to include it in Header, Header2 and Header3 for it to be visible in all documents, is there a way for it to be included in all documents without repeating the code 3 times?
This will print in the left hand margin, this can easily be changed to the right hand margin if required.
If it is used at the bottom it will be viewed as “small print” and most people (yes wrongly) do not read the small print. Also there may be paper feed issues.
On either left or right margin it will stand out as different – font, print direction, size, decoration, and font colour. Which should draw a readers eyes to it.
Developers or code savvy users will debrand, but they will do that anyway: But the majority of users will not.
Users may have custom margins for their documents, so the script results may not appear: But again the majority of users will not.
Edit:-
Also this needs to be translated:-
$txt = '_("Generated & Printed by www.frontaccounting.com Open Source Accounting, Inventory management and ERP for your business")';
$this->Cell(0, 10, $txt, 0, 0, 'C', 0, 'http://www.frontaccounting.com/');
To be tested
"It's not a bug, it's a feature"
Please compare your config.php with config.default.php and this will reveal why every page shows the sql queries.
To produce the report did you filter by catergory or location?
Something else that may help is go to Items & Inventory -> Inventory Item Movement select the item you have a problem with, select the time frame and post the screen shot of the result
Hi, you can obtain a backup copy of the database as described here in the wiki
You need to give us more info for us to help you -
Upload attachments somewhere and provide link here. Check MySQL / apache error logs for hints.
In config.php find this line:-
$show_sql = 0; // show all sql queries in page footer for debugging purposes
Change it to this:-
$show_sql = 1; // show all sql queries in page footer for debugging purposes
Now the sql for each page will show at the bottom.
Will not work for reports; a possible solution is to find the same functionality in the program that matches the report you want.
The sql trail info is kept in the database in a table called 'yourprefix_sql_trail'
To list the sales group for each customer/branch add the following to Line 278 of rep103.php
if ($myrow['group_no'] != 0) {
$rep->NewLine();
$rep->TextCol(2, 3, _('Group') . ": " . (get_sales_group_name($myrow["group_no"])));
}
This works, however:-
For cust/bran. not assigned to a sales group nothing is written; this may be the preferred option as Sales Groups do not seem to be widely used, it can just be documented in the wiki.
Alternatively the following can be added to the above:-
else {
$rep->NewLine();
$rep->TextCol(2, 3, _('Group') . ": " . _('No assigned Sales Group'));
}
Also I'm not entirely happy with the position, but out of the 4 columns, the 3rd seems to be the best option; an alternative would be to give the sales group as a ‘sub-title’ on its own line? Unless anyone else has any other ideas?
File: \reporting\rep103_ original new.php
is:-
258: $rep->TextColLines(1, 2, _("Gereral Notes:")." ".$myrow['notes'], -2);
It should say:-
258: $rep->TextColLines(1, 2, _("General Notes:")." ".$myrow['notes'], -2);
Also to be ‘picky’ the capitalization of Notes does not look correct either; could be construed as a name, so:-
“The army that invaded Smurfland was led by General Notes”, but the meaning is clearly understood.
Whereas ‘General notes’ = notes in general which is the intended meaning.
But the rest of the labels are capitalized, so your call?
I think you've enabled search in setup->company setup bottom right corner under User Interface Options:-
Short Name and Name in List
Search Item List
Search Customer List
Search Supplier List
Untick Search Customer List Update and you will see your customers
Or to use the search, tap the space bar enter the 1st character of the customer you are searching for.
Its all in the Wiki
A couple of non-gettext strings in the following official extensions:-
Cash Flow Statement
Annual Balance Breakdown - Detailed
Annual Expense Breakdown – Detailed
The months and the string ‘Account’ in the header row will not translate; the following fix works:-
File: modules\rep_cash_flow_statement\reporting\rep_cash_flow_statement.php
change
251: $headers2[0] = 'Account';
to
251: $headers2[0] = _('Account');
And to translate the months
In the same file: modules\rep_cash_flow_statement\reporting\rep_cash_flow_statement.php
change
260: $headers2[] = substr($header_row[$i], 0, $wrap_point);
to
260: $headers2[] = _(substr($header_row[$i], 0, $wrap_point));
File: modules\rep_annual_expense_breakdown\reporting\rep_annual_expense_breakdown.php
Lines 275 & 284 respectively
File: modules\rep_annual_balance_breakdown\reporting\rep_annual_balance_breakdown.php
Lines 273 & 282 respectively
sql/en_US-demo.sql has sample data including customer names, sales orders, suppliers, purchase orders, etc.
sql/en_US-new.sql has no customers, no suppliers, no purchase orders, no sales orders...nothing - just a blank chart of accounts.
I cannot understand how you went from 3 to 4? Unless you made a cash sale?
After 3) Then " Invoice Against Sales Delivery " you have to enter a customer payment: because:-
before you can allocate a payment, there has to be a payment.
Have you entered the customer payment?
FA is an excellent accounting program, but you do need to read the Wiki to get the most out of it.
@seahawk aka Wynand
1. For Items:- What happens if you have different rates of VAT eg 8% 10% & 19% then you would have a different item tax type for each rate, so on the day of the C/O create the new different taxes, 9%, 11% & 20% and assign the relevant item tax type to its new tax rate, not tried this, but no individual item setting would be touched.
To clarify:-
2. For Suppliers & Customers:- each customer is assigned with a tax group, lets say this is called VAT with a rate of 14%, then create a new tax for 15%, assign this to the tax group VAT, so now all customers and suppliers will be charged VAT @ 15%. Should you need to create a credit note, create a new tax group call 'VAT@14%' with an assigned tax of 14% change the relevant supplier/customer to this tax group, create the credit note, change supp./cust. tax group back.
I like your idea of taxes by date.
@Joe, Janus & apmuthu, thank you!
@apmuthu: Do I have to add deferred_income_act into sys_prefs?
Without adding it: In System and General GL Setup no account is selected, instead it states 'Not used', I can then assign an account to it, update and it saves. Am I missing something?
No problem, hope it helps someone.
It was 2 years ago now, from memory I only did what needed to be done... 1st new tax, then how it is applied.
As always create a backup 1st.
So for Wynand's credit note case, revert tax for customer, create credit note, then change tax back to new tax will work.
FrontAccounting forum → Posts by poncho1234
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.