A backup of the FA instance would provide the CoA along with your data as well. Compare it with the default standard template at sql/en_US-new.sql file and populate only the data equivalents in your backup, deleting all other data. The password hashes in the user table should be reverted to the one in the standard template. The key elements of the CoA would be your chart_master, chart_class and chart_types tables apart from user preferences in the sys_prefs tables and data in your config.php / config_db.php file sans the db and mail access credentials. The FA versions and the db sql versions are in the version.php file.
2,002 02/09/2018 08:38:44 pm
Re: Invoice Against Sales Delivery (4 replies, posted in Accounts Receivable)
When a Direct Sales Invoice is raised on Cash Payment Terms, this is what is expected to happen - casual over the counter purchases. The correct way is to
1. raise a Quote (optional),
2. make a Sales Order,
3. effect a Delivery of items,
4. Invoice the Sales Delivered on Credit payment terms,
5. Receive a Payment from the customer and then
6. Allocate it to the appropriate Invoice(s).
2,003 02/09/2018 08:34:09 pm
Re: Customer Balance (1 replies, posted in Accounts Receivable)
Pass a Journal (Adjustment) entry.
DEBIT entire credit balance less the actuals $3.93 as an adjustment entry and CREDIT the Petty cash account (or Bank Account) into which you generally receive such payments from the said customer and make sure you make up for the cash (bank) difference from your pocket!
2,004 02/09/2018 08:28:29 pm
Re: Deleting a fiscal year (4 replies, posted in Setup)
All fiscal years must be in the order of the id field as well. Only then will deletion take place. You will need to take a full backup and restore it into another install and work on the MySQL tables carefully possibly in conjunction with a MySQL client such as phpMyAdmin or SQLyog. Also make a list of the plugins and their versions in use. This is not for the faint of heart - take professional assistance if unsure. Post a bounty in the Job offers board.
How many years do you have loaded on your system? Export out the fiscal_years table and see whether the id field is in the same order as the start date of the fiscal years order.
You may also contact the Support Consultants for assistance.
2,005 02/09/2018 08:21:40 pm
Re: Credit Card Sale (7 replies, posted in Accounts Receivable)
When you installed FA, what chart of accounts did you choose?
2,006 02/08/2018 06:35:01 pm
Re: Edit Reference Number in JOURNAL ENTRY # (1 replies, posted in Banking and General Ledger)
The next available Journal Entry # autofills the field but remains editable.
2,007 02/08/2018 06:33:31 pm
Re: Edit Reference Number in Dimensions (1 replies, posted in Reporting)
Read the Wiki for Dimensions and it's uses.
2,008 02/08/2018 06:32:55 pm
Re: Journal Voucher Printing (1 replies, posted in Reporting)
The Print Button uses the javascript:window.print(); JS construct that sends the whole html page to print. You make a wrapper JS function for the print() function that removes the footer and then prints the rest.
2,009 02/08/2018 06:24:40 pm
Re: What are dimensions? (27 replies, posted in Dimensions)
Reference Numbers are given for different transaction types - Sales Orders, Sales Invoice, Purchase Order, etc. Dimensions are for Profit Centres / Departments / Divisions, etc. Where do you have a Dimension Reference Number?
2,010 02/08/2018 06:22:47 pm
Re: Customer Credit Note (3 replies, posted in Accounts Receivable)
Txn 1: When Customer paid, the payment was sent to Petty Cash instead of the specific Bank.
Txn 2: Allocations have been made from this payment into one or more Sales Invoices.
If you have a backup before and after each transaction, you may be able to revert just the payment alone to the appropriate bank account if you are unable to edit the payment itself. The backups can be compared using the likes of WinMerge.
2,011 02/08/2018 06:17:50 pm
Re: Credit Card Sale (7 replies, posted in Accounts Receivable)
Which Chart of Accounts are you using?
2,012 02/07/2018 05:33:40 pm
Re: How Can I cancel part of Purchase Order (8 replies, posted in Accounts Payable)
For now we need to do it directly in the tables as it is not yet editable in the FA Web UI.
Any FA Web UI for zeroing out and / or reducing the qty to just what is delivered?
We can edit the PO atleast as Admin.
2,013 02/07/2018 05:31:03 pm
Re: What are dimensions? (27 replies, posted in Dimensions)
Dimensions are now Profit Centres / Company Divisions / Departments where reports can be used to track filtered transactions. Reference Numbers (and their patterns) can be edited to set the next reference number. Read the Wiki.
2,014 02/07/2018 02:21:20 pm
Re: How Can I cancel part of Purchase Order (8 replies, posted in Accounts Payable)
Yes we should be able to edit a Purchase Order by adding some negative quantity items to state we do not wish to receive the undelivered items anymore!
@joe: What is the way to purge balance undelivered items in any purchase order?
2,015 02/07/2018 05:22:39 am
Re: Supplier Balances Report (201) (6 replies, posted in Report Bugs here)
Pass a correction (Journal) voucher.
2,016 02/06/2018 07:01:28 pm
Re: Supplier Balances Report (201) (6 replies, posted in Report Bugs here)
If you made your Opening balances using a single Journal Voucher in the previous fiscal and closed it and had it brought forward into the new year all should be okay.
2,017 02/06/2018 06:59:53 pm
Re: Slim REST API module for FA 2.4.x - No Composer (18 replies, posted in Modules Add-on's)
Start a project on GitHub and get others to fork and contribute.
2,018 02/06/2018 09:01:17 am
Re: Supplier Balances Report (201) (6 replies, posted in Report Bugs here)
All values are okay as per attachment.
2,019 02/06/2018 08:51:16 am
Re: Reverse order of dropdown list from input box (9 replies, posted in FA Modifications)
The ORDER BY is implemented in the array_merge() array's element of the first argument and remains the same in both FA 2.3.x and 2.4.x as:
'order' => array('c.description','stock_id')What did you change it to, in order to make it the way you wanted?
2,020 02/06/2018 04:14:25 am
Re: Credit Card Sale (7 replies, posted in Accounts Receivable)
Check what has changed in the files since then to the last version 2.3.26. Each account you want as a bank account should be declared so in Banking and General Ledger => Bank Accounts.
2,021 02/05/2018 06:55:49 am
Re: Fixed Assets (30 replies, posted in Fixed Assets)
In your previous post you listed the commit that addressed the issue. Just follow it or use the entire set of changes after the FA 2.4.3 release to overwrite them.
2,022 02/04/2018 03:35:53 am
Re: How to increase Input text for Amount Debit and Amount Credit (4 replies, posted in Banking and General Ledger)
It may be easier to state that your currency is in 1000's - are there any goods / currency notes less than 1000 denomination in Indonesia?
2,023 02/04/2018 03:32:19 am
Re: Fixed Assets (30 replies, posted in Fixed Assets)
This should not be done. A stock item is not a fixed asset item. We are now using a different function for the checks here: check_db_has_depreciable_fixed_assets()
2,024 02/03/2018 03:57:38 pm
Re: Fixed Assets (30 replies, posted in Fixed Assets)
@joe: Can commit post 12 herein.
2,025 02/03/2018 03:50:37 pm
Re: ER Diagram and Scheme (4 replies, posted in Setup)
Cascades and referential integrity constraints are not yet used in the default FA 2.4.3 for now and hence the relationships do not show up in the MySQL workbench. SQLyog is another tool to get the schema.