1,601 Reply by apmuthu

(5 replies, posted in FA Modifications)

Is there any other js / ajax / php check for such duplicates in the Customer Short Name scripts that needs to be put in for the Supplier scripts as well apart from the unique key?

Go to forum: FA Modifications

1,602 Reply by apmuthu

(6 replies, posted in Jobs wanted/offered, non-free offers)

Whilst the Denali version uses the MS SQL server, what database does the legacy version use?
Could not trace the old legacy version to study it.

You can run VMWare Player in your Win7+ workstations and run WinXP in a Virtual Machine in it where your legacy CMS client can run. That way, you will not need to change the software and the way you run your business.

Have you setup your Chart of Accounts in FA and tailored it to suit your existing one in the legacy CMS?
You will need to use the latest FA v2.4.4+ Git Master as it sorts out quite a bit of issues.

Perform one batch of one type of transaction with just one transaction in it and compare the before and after backups of the sql - you can then figure out how to frame the SQL statements to import a full batch.

Go to forum: Jobs wanted/offered, non-free offers

1,603 Reply by apmuthu

(6 replies, posted in Jobs wanted/offered, non-free offers)

Can be done purely as SQL statements in order without any user intervention - bash/sql/cron - at specific times.
WHat is the legacy accounting used?
Do the legacy accounting program and FA reside on the same machine?

Go to forum: Jobs wanted/offered, non-free offers

1,604 Reply by apmuthu

(4 replies, posted in Accounts Payable)

Committed.
Kindly verify if the functionality is okay.

Go to forum: Accounts Payable

1,605 Reply by apmuthu

(3 replies, posted in Report Bugs here)

Looks like a rollback of this commit is in order if no new workaround is found.

Go to forum: Report Bugs here

1,606 Reply by apmuthu

(3 replies, posted in Accounts Receivable)

Make an extension for it. Hopefully all entries for the customer are in place before the extension triggers these entries.
A Quick Entry based on manual calculation may be in order till then.

Go to forum: Accounts Receivable

1,607 Reply by apmuthu

(1 replies, posted in FA Modifications)

This is necessary as the last function in it (function parse_notes_params) is needed in some instances.
See the Wiki.

Go to forum: FA Modifications

1,608 Reply by apmuthu

(13 replies, posted in FA Modifications)

Try clearing the js and other browser cache and try it.

Go to forum: FA Modifications

1,609 Reply by apmuthu

(9 replies, posted in FA Modifications)

@kvvaradha: Since you are making a LEFT JOIN for the voided entries, there could be many null voided entries in the result set that would have the v.date_ field as NULL anyway!

@joe: can polish it up and check and include it if needed.

Go to forum: FA Modifications

1,610 Reply by apmuthu

(3 replies, posted in Report Bugs here)

@joe: the whole commit can be reviewed instead of the fixed part alone.

Go to forum: Report Bugs here

1,611 Reply by apmuthu

(7 replies, posted in Reporting)

I think he means to include the description of items inside the report.

Go to forum: Reporting

1,612 Reply by apmuthu

(1 replies, posted in Banking and General Ledger)

This generally occurs when there is a forex rate difference and may be dynamic / computed on the fly. Check if it differs each time the forex rate changes.

Go to forum: Banking and General Ledger

1,613 Reply by apmuthu

(18 replies, posted in Setup)

Replace each instance of 

'

with an apostrophe (single quote) and then execute the SQLs in order in some MySQL client like phpMyAdmin, SQLyog, etc.

Chances are that the db user you created does not have sufficient write permissions.

Go to forum: Setup

1,614 Reply by apmuthu

(18 replies, posted in Setup)

The first user is "admin". The second user is "jimmyc". Try logging in with "admin".
It is possible that the Chart of Accounts you used may not be updated to the schema for the default Charts.

Try a fresh install with the sql/en_US-new.sql chart.

Go to forum: Setup

1,615 Reply by apmuthu

(4 replies, posted in Reporting)

@joe: Can commit this. Makes sense.

Go to forum: Reporting

1,616 Reply by apmuthu

(7 replies, posted in Reporting)

Yes - modify the report in question.

Go to forum: Reporting

1,617 Reply by apmuthu

(11 replies, posted in Accounts Payable)

Debit Note / Credit Note?

Go to forum: Accounts Payable

1,618 Reply by apmuthu

(10 replies, posted in Items and Inventory)

@joe: is this specific to certain versions of js or can it be included in the core?

Go to forum: Items and Inventory

1,619 Reply by apmuthu

(14 replies, posted in Setup)

Make a new extension for it.

Go to forum: Setup

1,620 Reply by apmuthu

(6 replies, posted in Banking and General Ledger)

A credit/debit note may be in order.

Go to forum: Banking and General Ledger

1,621 Reply by apmuthu

(14 replies, posted in Installation)

There is no direct link to the Forum Messaging module in the main menu though the PM links are there in every post. Also the forum message notifications do not work after the version upgrade.

Check your PM now.

Go to forum: Installation

1,622 Reply by apmuthu

(13 replies, posted in Report Bugs here)

Shall we replace it with x-rates.com? The bash code for it is:

wget -q -O- "https://www.x-rates.com/table/?from=USD&amount=1" | \
grep "http://www.x-rates.com/graph/?from=" | \
cut -c71-1000 | \
sed -e 's#</a></td>##' | \
sed -e 's#&amp;to=# #' | \
sed -e "s#'># #" | \
sort -u > output.txt

Go to forum: Report Bugs here

1,623 Reply by apmuthu

(4 replies, posted in Banking and General Ledger)

@joe: Does this make it to the core?

Go to forum: Banking and General Ledger

1,624 Reply by apmuthu

(3 replies, posted in Banking and General Ledger)

Caveat: Provided you have not closed any of the succeeding fiscal years.

Go to forum: Banking and General Ledger

1,625 Reply by apmuthu

(25 replies, posted in Modules Add-on's)

"Unknown" is okay for third party extensions.

Go to forum: Modules Add-on's