Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 35 of 246)
If you wish to proceed the way you want then FA is not for you.
If you wish to accomodate your request within FA, then make sure you have an account from which monies come out and go into.
When you start a fresh company in FA with no opening balances, then where did the Bank's Opening balance come from and whom should it be repaid to when the said bank account is closed?
Make a list of all opening balances you wish to transfer into FA and make a journal entry for all of them with the balance appropriated to the cash account. Make sure that the cash account balance is in debit as it should be returned to the shareholders and other stakeholders should the company close. Otherwise make a cash receipt entry from someone who has loaned you the amount to balance your books.
Please learn Double Entry Book Accounting or take professional Accountant's advice before attempting FA - there are some good tutorial links in the Wiki too.
FA is a double entry accounting system that accomodates single entry forms where the contra entry can be the cash account.
Since you are creating a new FA installation, make a copy of the sql/en_US-new.sql file and edit it to remove what accounts you do not want and inject new ones taking care to ensure that any references to the old account code in the sys_prefs table is properly accounted for and then use this new sql to create your company.
Opening balances must necessarily be entered as journals from your old balance sheet and / or by credit/debit notes.
Do not delete such ledger accounts as there will be an audit trail and next reference records associated with it besides subsequent account codes thereafter.
When such a bank balance is available it will be part of the balance sheet that came from the period just before you started on FA. Place all balance sheet entries in one Journal entry and they should contra one another. If you are doing it in parts, then use an intermediary "Suspense Account" which will zero itself out when all such balance sheet entries are imported in. In case allocations need to be done, use Debit Note / Credit Note for such bank / cash balances for the apportioned amounts.
@sewkar: Just kidding. If you can afford it, kindly contribute to the project. It will in part pay for the hosting, and other expenses. Thanks for the feature request - that is what makes Open Source worth pursuing and preserving - peer group vetted best way forward.
We can explore where else the "All" can be implemented.
Possibly an option in the PARAM_0 to have ALL might be all that is necessary without having a new report altogether.
Also the page numbers caveat should be noted - all pages are in sequence with no page reset when account changes.
The bank_accounts.id field is chosen in the rep601.php's request form as the PARAM_0.
If the line 28 in the said report print_bank_transactions() is cycled through all such ids in the bank accounts table, then we get what you want. Check out the attachment.
How much do you want to pay? 
@joe: want to make it a rep603.php or as an extension for printing all rep601's.
Install the extension needed and make changes in the modules files - no need to install anything. Only if you need to have the original extension also working together with the new one, do you need to copy it to another name and make entries for it in the installed_extensions.php file for it.
containers seem to be a custom module.
Set the next reference to be 12001 in the 0_refs table.
Check with the following SQL for next references:
SELECT * FROM 0_refs ORDER BY RIGHT(`reference`, 4), `type`, `id`;
The above assumes the 0_reflines.pattern to be {001}/{YYYY} which is the default.
Check the wiki for the last entry in Pre-Requisites.
Quote your time line and bounty and the appropriate devs may bite. This is not a recruitment forum.
In such a case, migrating the entire trial balance is done in two steps involving a temporary Suspense Account as the contra Account.
1. Move all (non allocatable) Non Supplier / Non Customer Balance Sheet / TB entries into FA using Journal Entry
2. Use Credit Note / Debit Note to bring forward allocatable payments for the Customer / Supplier balances
@joe: any better practice?
Does the opening balance not come calculated by default in FA? Is it not generally done using a Journal Entry at the start of FA?
If you are using linux, then the following posts will be useful for generating your reports on FA CLI and then merging the PDFs:
https://frontaccounting.com/punbb/viewtopic.php?pid=36003#p36003
https://frontaccounting.com/fawiki/index.php?n=Devel.ManualCURLInFA
Your modded rep101.php has been whitespace synched with the original and attached to your post.
Does your rep10112.php render properly without error?
There is no report like 10112
State which reports.
Are the individual reports getting generated without any crashes?
Each report can have different parameters - how do you hope to reconcile them when merging into a single report?
Create a new report with code pilfered from each report and take a union of all the parameters for both reports.
@joe & @itronics will surely find a way forward in FA 2.5 which will probably get released in a few months/years unless someone is willing to sponsor development in that direction to hasten the pace of development. This will certainly take into account your suggestions as well.
Other topics that discuss this issue are:
Cost Of Service in FA 2.4.6 only after Sales Invoice posting
Handling, Shipping & Clearance
Landed Costing of Inventory Items
The Wiki and the Forum are the best places to search for "Documentation".
Change the word "Supplier" in the translated string in the .po file and compile and use the .mo file.
Here is what I used in bash:
grep "Supplier" empty.po > msgid.txt
grep "Supplier" empty.po | sed -e "s/Supplier/Vendor/g" | sed -e "s/^msgid/msgstr/g" > msgstr.txt
msgunfmt -i en_US.mo -o en_US.po
## Append the output of the following to en_US.po
exec 6<"msgstr.txt"
while read -r line
do
read -r f2line <&6
echo
echo "${line}"
echo "${f2line}"
done <"msgid.txt"
exec 6<&-
## Re-compile the .mo file
msgfmt en_US.po -o en_US.mo
The resultant output is attached for use.
Thanks @joe.
How do we propose to handle it in FA 2.5? Additional fields or addition line items to Purchase Invoice as re-imbursables or onsite payables to third parties?
The said link in the post above is PDFed here.
Posts found: 851 to 875 of 6,143
