Since one location sells to another - treat them as different shops - each can make a profit from selling to the other. Alternatively use average costing and let the discount given to each customer vary. The exact acquisition cost will then be factored in the average cost. Anything specific can be treated as a different item for the FA internals with the same description - item_code and stock_id - you can also use manufacturing / assembly and kits. In the inevitable instance, make yourself an extension.
2,076 01/24/2018 05:05:54 pm
Re: Error in inventory valuation report (45 replies, posted in Report Bugs here)
2,077 01/23/2018 06:23:00 pm
Re: Error in inventory valuation report (45 replies, posted in Report Bugs here)
If you wish to track the same item with vastly varying prices, then make it two differently coded items (stock_id). There is nothing wrong with the current algorithm's outcome as the item is still one of a kind.
2,078 01/23/2018 06:19:40 pm
Re: How to set inventory physical location (bin or shelf) (7 replies, posted in Items and Inventory)
All data elements go into the appropriate db field in MySQL.
The doctext.inc file should have it's path created before being copied over and edited as needed in the web folder.
If you need professional assistance post your offer in the Job Offers board.
2,079 01/23/2018 06:08:00 pm
Re: How i can disappear some menu items? (3 replies, posted in Reporting)
Setup => Access Setup => Roles => select host
2,080 01/22/2018 04:55:18 pm
Re: Exchange Rate not working (if define manually) (5 replies, posted in Banking and General Ledger)
Attached is a set of screenshots for a forex purchase invoice and the corresponding forex converted payment along with their views and GL entries.
2,081 01/22/2018 04:25:03 pm
Re: Exchange Rate not working (if define manually) (5 replies, posted in Banking and General Ledger)
At the time of making the Supplier Invoice entry in USD, there is no conversion needed even if the company currency is in SAR except for the GL entries that would get converted in the Purchases account - check the GL entries for the transaction after Purchase Invoice entry.
Again, when making payment in USD from a cheque drawn on a USD denominated bank account, no conversion is needed except for the GL entries on the purchases / stock inventory accounts - check them as well.
You should have an Exchange Variances Account assigned in Setup => System and General Setup that will be used for Balance Sheet, P&L Account and costing / settlement purposes.
Alternatively, if you entered the exchange rate manually, try to logout and login again and then make the Supplier Invoices and the Payments to Suppliers. This is assuming you are plagued with some browser cache - set the browser options to clear cache on exit.
2,082 01/22/2018 05:22:01 am
Re: Access setup: Edit one's own transactions (6 replies, posted in Setup)
Read the Wiki.
Sales => Customer Transactions => Sales Invoices (Type) => Edit Icon.
2,083 01/22/2018 04:00:20 am
Re: Exchange Rate not working (if define manually) (5 replies, posted in Banking and General Ledger)
Since both Supplier Currency and Purchase Invoice entry are in USD, there is no conversion needed. Make sure you have entered it in USD Amounts too in both cases. Hopefully, if you pay the Supplier from your USD Bank Account, then too there will not be any exchange rate conversion. Only in the Balance Sheet and P&L Account will it reflect in Saudi Riyal after conversion. Make sure your exchange rate is entered preferably a day earlier (may be there might be some glitch there - but no one has complained so far).
2,084 01/21/2018 06:29:31 pm
Re: Error System and General GL Setup (5 replies, posted in Setup)
Just downloading the charts and overwriting the counterparts in the sql folder is good only for new companies created with them. The old companies created with the erroneous charts must be synched in schema and appropriately migrated to the new one. Just make one company with the en_US-new.sql and compare the schema with your older companies and synch the latter.
2,085 01/21/2018 04:28:27 pm
Re: Error 500 modules Report Generator FA 2.4.3 (9 replies, posted in Modules Add-on's)
PHP 5.4.x should work.
Are you on Windows or Linux?
Study the Apache and FA error logs and enable debug in your config file and see where the problem lies. Check out FA troubleshooting in the FA Wiki.
2,086 01/21/2018 04:25:37 pm
Re: Currencies of Journal Entry (3 replies, posted in Banking and General Ledger)
Enable OpenSSL in your php.ini and restart your webserver.
Do not use the Yahoo exchange rate provider as they have discontinued free service.
All future transactions will be at the exchange rate you have entered.
Your supplier / customer should have their settlement currency entered and your bank account for that currency available.
2,087 01/21/2018 04:19:54 pm
Re: Looking for POS module (6 replies, posted in Modules Add-on's)
The Slim Framework page has examples.
2,088 01/21/2018 04:16:02 pm
Re: TCPDF error: Problem in "Printer / PDF" in UTF8 encoding (3 replies, posted in Report Bugs here)
Nice work.
PHP 5.1.6 (XAMPP 1.7.3 on windows) and 5.3.3 (Debian Squeeze) do not need to remove the comment though.
2,089 01/21/2018 04:12:25 pm
Re: Error System and General GL Setup (5 replies, posted in Setup)
That chart is probably old and not updated correctly. Take an updated one from the FA24extensions repo depending on if you are using the English or Arabic one.
Read the wiki, search the forum and experience the code - live and learn.
2,090 01/21/2018 04:07:29 pm
Re: Some inquiries about warehouse items are very important (1 replies, posted in Items and Inventory)
Post your job and bounty offer on the Job Offers board.
1. Inventory report is as on the time of printing - yes, continuous.
2. Enable Barcode in the Preferences. - Yes.
3. "add a call" ??? - each item sold in multiple units should be entered as separate items or use the sales kit / assembly feature.
4. Salesman facility only.
5. Expiry Date / Batch number not in native FA as of now. Some users have built their own extensions and some sell them - search the board.
The FA project is an open source one where everyone can learn and be a developer. The project has nothing to sell and everyone works at their own cost in time. Support employees / FA users to become developers and contribute your fixes / feature sets.
2,091 01/20/2018 03:36:25 pm
Re: Error System and General GL Setup (5 replies, posted in Setup)
The Retained Earnings Account and the Profit and Loss Account must exist in your chart_master table with the correct chart_type - see the sql/en_US-new.sql file for parallels and adjust your Chart accordingly.
Setup => System and General GL Setup must have the Retained Earnings and the Profit/Loss Year accounts set properly.
2,092 01/20/2018 03:33:41 pm
Re: Looking for POS module (6 replies, posted in Modules Add-on's)
Not in the official repo. Some commercial implementations are available and the SlimREST_API can be used to design one.
2,093 01/20/2018 03:30:35 pm
Re: Error 500 modules Report Generator FA 2.4.3 (9 replies, posted in Modules Add-on's)
The official pkg when installed probably did not install fully as the file/folder permissions may have been wrong.
What is your platform and versions of PHP/MySQL/Apache?
Have you updated your FA 2.4.3 with the fixes thereafter?
Update your repgen module from the FA24extensions repo.
2,094 01/20/2018 03:26:51 pm
Re: Bug in report 110 (5 replies, posted in Report Bugs here)
@joe: Thanks for the commit.
2,095 01/20/2018 03:03:56 am
Re: Inventory location (1 replies, posted in Items and Inventory)
Not aware of this "feature" in FA as of now.
2,096 01/20/2018 02:59:34 am
Re: Bug in report 110 (5 replies, posted in Report Bugs here)
Addendum to your commit:
In rep102.php, $sign is computed and then used in the sql so it is okay.
In rep107.php $sign is assigned 1 and used and hence it can be fully eliminated unless there are some CAST issues.
In rep113.php, $sign is assigned -1 and used and may be removed likewise and the sign made inline.
In rep109.php, rep111.php and rep209.php just as in rep110.php here, $sign is not assigned anywhere in the script and hence can be removed as done herein.
2,097 01/19/2018 04:55:12 pm
Re: TCPDF error: Problem in "Printer / PDF" in UTF8 encoding (3 replies, posted in Report Bugs here)
This is a quirk of some set of PHP 5.6.x versions as listed here and here - specifically the PHP 5.6 bug.
2,098 01/19/2018 04:47:02 pm
Re: Expiry Date and Batch Number (3 replies, posted in Items and Inventory)
https://frontaccounting.com/punbb/viewtopic.php?id=1294
https://frontaccounting.com/punbb/viewtopic.php?id=4202
https://frontaccounting.com/punbb/viewtopic.php?id=1112
No standard extension in the Official PKG repo as yet.
2,099 01/19/2018 04:43:22 pm
Re: Bug in report 110 (5 replies, posted in Report Bugs here)
Replace line 161 in reporting/rep110.php:
$DisplayFreight = number_format2($sign*$myrow["ov_freight"],$dec);
with:
$DisplayFreight = number_format2($myrow["ov_freight"],$dec);
The $sign is not defined anywhere in the report and may be present through some include when a sales order is being printed. The $sign was not present in FA 2.3.x.
@joe: Should this be committed?
2,100 01/19/2018 03:22:47 am
Re: How to set inventory physical location (bin or shelf) (7 replies, posted in Items and Inventory)
In general the wiki article referred to in my post still applies but needs to be modified to suit FA 2.4.3. It was considered to be a workaround as the DB schema was frozen in FA 2.3.x then and hence we needed it to accommodate several data elements in the single description field and then parse them out when needed.
Line 22 in the same file in FA 2.4.3:
item.units, item.mb_flag
should now be changed to:
item.units, item.mb_flag, item.long_description
to use the workaround.
In FA 2.4.3, it was sought to be made native but the devs had not found enough time and sponsors to get it done and it possibly remains as an extension in some private repos only. The correct way to implement this would be to create a separate extension that would use a new table in a 1:1 relationship with the existing stock_master table used.