Wikiied it!

What OS are you on (MySQL in Linux is case-sensitive)?

How did you do the upgrade?

Did you synch the db schemas correctly?

Check out SimpleAPI for FA in the Wiki.

5,779

(1 replies, posted in FA Modifications)

Yes a sortable listing of Suppliers, Customers, Sales and Purchase Orders will certainly be nice.

Possibly an option to have the reports available for an extra destination "Screen" with links to their view/edit pages would be a simple workaround for now pending full fledged menu items for them.

Move to another less taxed country wink or buy/elect a cheaper govt big_smile.

5,781

(23 replies, posted in Wish List)

@ed10: Double quotes is okay. Two single quotes will be a blank value. The double quotes are to ensure closing the string.

To keep with the coding convention, it can be:

hyperlink_no_params("$path_to_root/sales/inquiry/customer_allocation_inquiry.php?customer_id=", _("Go to Allocation Inquiry"));

Should the hyperlink have some parameter to dictate the customer_id? If not, then we use the blank one like:

hyperlink_no_params("$path_to_root/sales/inquiry/customer_allocation_inquiry.php?customer_id=''", _("Go to Allocation Inquiry"));

The blank parameter expanded with spaces for forum display of the above will be ......customer_id='  ' "

5,782

(23 replies, posted in Wish List)

Thanks Janusz, the  $auto_create_branch switch was missing. Looks like backward compatibility did me in! Updated config.php page on the Wiki to reflect all variables as on date in the English version. Offline PDF version available.

Also corrected some small typos and included extra variable / necessary comments in the config.default.php file and am attaching the diff patch from Mer 3119.

5,783

(22 replies, posted in Accounts Receivable)

Thankyou tclim - very explicitly put. Have referenced this post in the SimpleAPI page on the Wiki.

5,784

(23 replies, posted in Wish List)

Default Branch is created automatically when a new Customer is added, but is not automatically associated with the Customer as yet.

Wikied the rest.

5,785

(23 replies, posted in Wish List)

This kind of workflow can use the SimpleAPI extension to create a single web form which posts directly into FA.

If I understand you correctly, in the QB scenario, you did not have the Customer info in QB to start with and after invoicing as well, you do not have a separate Customer record for each customer - just the invoices with several customer names.

FA can simulate the above using a dummy web / cash customer where the Delivery to can be the real customer and his info. That way you need not add customers for each invoice. Just use the dummy one for all such invoices.

5,786

(0 replies, posted in Installation)

Referring to my creation of new page and edits on 21st Nov, it appears that the user who made the changes is listed as admin instead of apmuthu.

Refer history of pages:

https://frontaccounting.com/fawiki/index.php?n=Help.InventoryValuationReport?action=diff

https://frontaccounting.com/fawiki/index.php?n=Help.ReportsAndAnalysis?action=diff

Has the Wiki db been compromised?

Binary Shift values -  php operator

The last 8 bits (LSB) are reserved for System / Later use and hence the <<8 in almost if not all permissions.

5,788

(7 replies, posted in Reporting)

Thanks Joe.

Setting 2 dec places in Items and Inventory -> Standard Costs did the job. Wikied it.

5,789

(4 replies, posted in Reporting)

Any change in status for printing POS payment receipts onto thermal printers / ejecting cash drawers?

5,790

(23 replies, posted in Wish List)

Even in FA it is just one place and one time for each customer / invoice.
Refer Wiki Pages on Add and manage Customers and Sales Quotation Entry (and then convert to Invoice).

Please state the sequence of operations in FA that you used to achieve your end so that we may check on alternative quick modes to achieve the same to match or better QB.

5,791

(7 replies, posted in Reporting)

Yes I figured that out and filed Bug 1906 since the prices_dec field in the #_users table was not being respected for displaying the Unit Cost in the Inventory Valuation Report (rep301.php) as seen from the attachement in the first post in this topic for one item that has 10 decimals in it's Unit Cost.

5,792

(7 replies, posted in Reporting)

Attempting to fix includes/current_user.inc by replacing Line 310:

function price_decimal_format($number, &$dec)

with

function price_decimal_format($number, $dec)

by omitting the pass by reference, the Unit Cost column now has no decimals.

Even any forced value of $dec in Line 312 does not provide any decimals at all in the above attempted fix.

C.po

What happened on browser?

5,794

(7 replies, posted in Reporting)

FA v2.3.13 Mer 3109

File: reporting/rep301.php lines 148 to 158 place the individual detail entries for the Inventory Valuation Report. The decimal formatting is not respected as the deprecated

&$dec

is used.

Lines 310 - 312 of includes/current_user.inc:

function price_decimal_format($number, &$dec)
{
    $dec = user_price_dec();

clearly do not take in the $dec from the function parameter.

This results in the kind of multi-decimal output in the report snapshot attached.

5,795

(6 replies, posted in Setup)

Check the SQL schema diffs between before and after backup/restore

lang\new_language_template\LC_MESSAGES\empty.po
needs to be copied to
lang\C\LC_MESSAGES\C.po

Beware of case sensitivity and all paths are relative to the FA folder in the webroot.

This is probably specific to Win7 installs.

Copy over the empty.po as C.po.
Create a faillog.php file in the webroot.

It is most certainly a permissions issue on the folders.

Which versions of XAMPP / Uniform server are you using?

5,798

(5 replies, posted in Setup)

Refer Forum Post for both the changed file sets (v2.3.12 to v2.3.13 and from v2.3.13 to Mercurial 3109) and overwrite your existing files.

There are no db changes.

Just check the difference between your config.default.php and your config.php file for newer options and update config.php accordingly. Use WinMerge2 for the job if you're on Windows.

5,799

(6 replies, posted in Announcements)

Since the release of FA v2.3.13, a few fixes have been made especially those that deal with module installation requiring sql updates. Attached is the Mercurial Build 3131.

Weight can be a unit of the item and it will be shown in the invoice if the price of the item is based on the Weight then it would appear in the Quantity column.