826

(7 replies, posted in Reporting)

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? wink

@joe: want to make it a rep603.php or as an extension for printing all rep601's.

827

(2 replies, posted in Modules Add-on'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.

828

(3 replies, posted in Installation)

containers seem to be a custom module.

829

(3 replies, posted in Setup)

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.

830

(7 replies, posted in Accounts Receivable)

Check the wiki for the last entry in Pre-Requisites.

Thanks @paul. Wiki-ed.

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?

835

(11 replies, posted in Reporting)

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

836

(11 replies, posted in Reporting)

Your modded rep101.php has been whitespace synched with the original and attached to your post.

Does your rep10112.php render properly without error?

837

(11 replies, posted in Reporting)

There is no report like 10112

838

(11 replies, posted in Reporting)

State which reports.
Are the individual reports getting generated without any crashes?

839

(11 replies, posted in Reporting)

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.

FA 2.5 may have some straight forward ways to do this.
@joe: any workarounds for now?

Your supplier company's account is in USD
Your home currency is PKR
Purchase Invoice is in USD and needs to be settled in USD at a specific exchange rate.
Your local expenses are in PKR
Make the entry to be:

By Supplier Company Invoice Cr. USD 100
By Local Expenses on Supplier Invoice Cr. PKR 25
To Purchases Dr. (USD 100 converted to PKR + PKR 25)

This should make sure the inventory Qty is properly costed including the local expenses.

Anyone know of a better idea?

Convert to local currency and then enter the expense and the supplier account will have differences in exchange rate gain/loss that gets adjusted with exchange rate on prevailing date entered.

Deposit money into Bank using Bank Deposit Menu if you wish to allocate it to sales / purchases. Journal Entry is generally for non bank/cash entires.

848

(5 replies, posted in Setup)

The attached file has the necessary language files for es_ES.

Use PO Edit tool to generate the .mo file from the .po file

C:\Program Files\Poedit\GettextTools\bin>msgfmt es_ES-2.4.1-3.po -o es_ES-2.4.1-3.mo

Wonder why the version got bumped up when there were no significant changes upstream.

849

(4 replies, posted in Report Bugs here)

yes

850

(4 replies, posted in FA Modifications)

Checkout the code in the existing themes.