When an item is manufactured from raw material, a part gets manufactured say as "BUCKET" into inventory whist some either gets written off as wastage or gets into inventory as a Manufactured item called "REUSABLE WASTE" with zero value since it has been accounted for in the raw material issued earlier. When a new "BUCKET" is to be manufactured, a little less raw material is issued whilst the rest is taken as the "REUSABLE WASTE" item with zero value.
3,501 06/28/2016 05:42:59 am
Re: Reusable of waste material (3 replies, posted in Accounts Receivable)
3,502 06/28/2016 05:29:12 am
Re: A Logical Bug in Profit and Loss Calculation (7 replies, posted in Report Bugs here)
Never edit data in the tables directly. FA is an ERP with security provisions and audit trails along with storage of computed values. Void or contra the entry and then make the correct one.
Take a backup. make a new entry and then take another backup and compare where all the changes happened and then manually reverse / alter the changes as needed.
3,503 06/26/2016 07:00:10 pm
Re: GST Reporting for Singapore (2 replies, posted in Reporting)
Copy nearest Singapore GST equivalent FA reports and modify it to suit your formats.
3,504 06/26/2016 06:51:09 pm
Re: Reusable of waste material (3 replies, posted in Accounts Receivable)
Manufacture "Reusable Item"
3,505 06/26/2016 06:41:19 pm
Re: Migrated Close Period function from 2.4.RC1 to 2.3.25 (4 replies, posted in FA Modifications)
The entered date is closed or not in fiscal year.
can be
The entered date is not in active fiscal year.
3,506 06/26/2016 06:38:50 pm
Re: Start and End Date on Print Statement (10 replies, posted in Reporting)
Reports that have no date ranges are for the entire period from the beginning of the active fiscal year till date. The Active Fiscal Year is set in the Company Setup.
3,507 06/26/2016 06:37:14 pm
Re: Getting grasp of FA (1 replies, posted in FA Modifications)
TCPDF is for reporting only.
FA uses it's own framework.
3,508 06/20/2016 03:48:54 pm
Topic: Adminer for FA (0 replies, posted in Modules Add-on's)
Adminer can be used effectively for FrontAccounting. The Adminer Editor can be leveraged to getting data into specific FA tables. It is available in GitHub.
phpLeaveManager is my example/tutorial for Adminer Editor that can be used as a template for managing FA Tables.
3,509 06/20/2016 03:44:19 pm
Re: Account Payable (1 replies, posted in Accounts Payable)
You have asked many questions to which you may find answers by consulting the wiki. Also search the forums here. Take support from consultants for implementation.
3,510 06/20/2016 03:40:03 pm
Re: EXCHANGE RATE SOURCE (3 replies, posted in Banking and General Ledger)
Refer this commit.
3,511 06/20/2016 06:38:54 am
Re: Database Error - Voided Customer Payment (10 replies, posted in Report Bugs here)
When a direct invoice has been voided what policy do you expect for any payments received for that invoice till then?
Actually any payments received from the customer for that invoice should be either voided or re-assigned to be advances received on account before voiding any associated direct invoice.
Check the customer ledger account to see if the customer payment is still there and void it there if necessary.
@joe: What is the policy on treating customer payments received on voiding associated direct invoice?
3,512 06/18/2016 11:13:27 am
Re: How can I edit opening balance (bank account) via phpmyadmin? (3 replies, posted in Setup)
If there is an error in the opening balance of one account where did the contra entry go? The Balance Sheet should balance out and the difference might get into Cash on Hand. Pass a Journal Voucher to correct the error as on the first day of 2015.
Alternatively, re-open the previous year, make corrections there and then close the previous year and see what gives.
3,513 06/18/2016 11:09:57 am
Re: Database Error - Voided Customer Payment (10 replies, posted in Report Bugs here)
Anything in the error logs?
3,514 06/17/2016 11:23:59 am
Re: How can I edit opening balance (bank account) via phpmyadmin? (3 replies, posted in Setup)
Pass a Journal Voucher correcting it.
How did you get the opening balance - by closing the previous year or by entering a JV in the current year?
3,515 06/17/2016 11:21:52 am
Re: ERROR IN MYSQL WHEN A CUSTOMER PAYMENT IS VOID (3 replies, posted in Report Bugs here)
Make a separate clean install of FA v2.3.25 and take a backup of the sql schema.
Compare the sql with that of your pre-upgrade v2.3.22 and see if there are any settings change.
Compare the sql/en_US-new.sql in FA v2.3.25+ with your Singapore CoA and see what differs.
3,516 06/17/2016 11:02:38 am
Re: Frontaccounting expert custom support and Training (1 replies, posted in Jobs wanted/offered, non-free offers)
Provide an ERD schema of the new tables your module has introduced along with a workflow diagram.
Where is the GitHub repo for others to take it forward?
What licence does it come with?
3,517 06/17/2016 10:55:26 am
Re: how to enter payments from customer with same check number? (5 replies, posted in Accounts Receivable)
In plain vanilla FA, there is no cheque number field. It must exist only in the Memo / Description field. You can make a module extension for yourself for the new field in the forms / reports with new tables in a 1:1 relationship with existing ones or extend the table schema for a new field. Such changed will break your upgradeability unless you also upgrade your module extension.
Attempting to live within the Memo / Description field can be done using the Inventory Bin hack listed in the wiki.
3,518 06/17/2016 10:48:41 am
Re: Database Error - Voided Customer Payment (10 replies, posted in Report Bugs here)
Is there anyone facing this issue?
If there is a customer payment or bank deposit involved the amount should not be 0 (!=0). So where is the problem?
3,519 06/15/2016 06:25:55 am
Re: how to enter payments from customer with same check number? (5 replies, posted in Accounts Receivable)
Then treat the payment as on Account and pay by allocation with check number which would be searchable. For reporting by cheque number, you will have to parse it out into a custom report.
3,520 06/13/2016 02:12:23 pm
Re: Single, double quotes and other special characters replacements (8 replies, posted in Reporting)
@joe: what parts need to make it to the core?
3,521 06/12/2016 05:53:11 pm
Re: Release 2.1 - Extensions to FrontAccounting. How to? (6 replies, posted in Modules Add-on's)
Best way:
1. Take sql backup.
2. Manually make 1 entry.
3. Take another sql backup
4. Compare the backups and see what changed
5. Generate and execute MySQL statements (in phpMyAdmin, SQLyog, etc) to simulate these changes (Inserts / Updates) for all other entries to be imported.
3,522 06/12/2016 05:50:10 pm
Re: ERROR IN MYSQL WHEN A CUSTOMER PAYMENT IS VOID (3 replies, posted in Report Bugs here)
Which version of FA are you using?
The current stable one is v2.3.25+.
Which Chart of Account are you using?
Since it is related to another post, it is best if posted in that thread itself.
3,523 06/12/2016 05:44:13 pm
Re: FA 2.4RC1--Do not retrieve DB data in UTF (3 replies, posted in Setup)
In the Charts itself?
3,524 06/12/2016 05:43:07 pm
Re: how to enter payments from customer with same check number? (5 replies, posted in Accounts Receivable)
Use the Memo box with wordings being "Part of Ch No...."
3,525 06/12/2016 05:39:41 pm
Re: Career opportunity for an INTERNAL AUDITOR (opened to relocation) (1 replies, posted in Jobs wanted/offered, non-free offers)
Does the client use FrontAccounting or do they intend to do so?
This is not a general employment forum but specific to FA related work.