You can't do this manually. You need to write a program to store it. And also you need exchange rates of each rate that you have journal entry it. If it's one or few entries you can do manually. And for more entries, You need program to do this.
402 12/17/2020 06:53:30 am
Re: How to delete Sales order? (5 replies, posted in Items and Inventory)
If you cancel the sales order. You don't see anything of it. If you made delivery for that order, you have to void the delivery and then you can cancel the order.
If you don't know how to cancel the order. Modify the order and there is a cancel order button at the bottom, use it to cancel the order. That will complete cancel the order.
403 12/16/2020 11:43:34 am
Re: Exchange Variance (7 replies, posted in Banking and General Ledger)
There is a difference between bank to bank exchange rates in real. And from exchange rate provider it has some difference. So whenever you record payment, confirm with bank and record the amount to the invoice. And bring the exchange rate values as of it's. Otherwise you will be in trouble at the end. Try to identify the more affected transactions and adjust them manually to solve the problem. Each transaction records exchange rate in its own entry. And compare them and alter your gl_trans entires.
This is the only way. And keep your developers an accountant without during the edit.
I feel there is no option without it.
404 12/16/2020 08:45:45 am
Re: Item Adjustments Note disable rounding of Unit Cost (11 replies, posted in Items and Inventory)
I am also unable to reproduce the issue. But I am strongly suggesting something to make changes In our program. As I seeing some of moderate companies are asking me why FA gives cost update entry by wrong. It happens because of the decimal values and we have double in MySql field type. That allows more decimal values to the system. That's really some dangerous values to a single item which definitely won't have that much huge value. I will get you the sample when I get similar scenario with clients. Usually the decimal values are not properly controlled from our side. We should make some changes for it.
405 12/16/2020 08:38:19 am
Re: Compatibility fix for commit on 2020-09-28 (4 replies, posted in Banking and General Ledger)
@Joe, This is required fix for this version. So apply this changes and update to changes log as well.
406 12/12/2020 05:34:34 pm
Re: GL Transaction posting in a past fiscal year. (3 replies, posted in Fixed Assets)
You are right @islamsaeid3. And don't forget to change back the config option back to 0 again.
407 12/12/2020 01:35:17 pm
Re: Item Adjustments Note disable rounding of Unit Cost (11 replies, posted in Items and Inventory)
Hello @islamsaeid3,
Its good to hear. I will check the function as well. Thank you.
408 12/08/2020 07:24:21 pm
Re: Item Adjustments Note disable rounding of Unit Cost (11 replies, posted in Items and Inventory)
There is rounding option available in Preference page. Did you change it to apply more. So it would affect here better..
409 12/08/2020 07:19:31 pm
Re: Purchase Order Receiveing (8 replies, posted in Report Bugs here)
You have given the description very lengthy. Reduce the sentence and try again. It will work for you.
410 12/02/2020 01:17:11 pm
Re: Dimensions in Balance Accounts (7 replies, posted in Dimensions)
It's a good idea to use the dimension as branches. Though you need to configure more to separate logins for branches.
Let's say bring the dimension to users table and add the dimensions to related users. And keep the super admin for main branch. And create permissions for branch company access. And customize the dimensions drop down. Like show the dimensions drop down only for admins. Other branch users doesn't see the dimensions drop down. And bring the audit trail log to connect and split the entries as per branches. And also you need to change the references function to use dimensions id in l entries. So you can get the difference as per branch.
While writing it's easy to say. But in programmatic. There are huge changes in the core level to make it work. But it's definitely workable idea to bring the branches inside one main company. Admin can login and make entries into any branches. But the branch users can login and make entry into one system.
And remember one main factor. If you are making 40 branches and making entries means more concurrent user activity in it everyday. So you need a good server to handle it. And write each queries carefully to make the system work without load. Maintain regular backup as well.
411 12/01/2020 01:37:23 am
Re: Error selecting wrong customer branch when browser javascript is off (2 replies, posted in Report Bugs here)
We have not experience such an error before. And never seen anything wrong in branch id mistakes. Probably it might cause if the database has issue with branch id
412 11/29/2020 10:43:25 am
Re: Purchase Order Receiveing (8 replies, posted in Report Bugs here)
Enable debugging mode and try to get the error before session destroyed.
Or check in your error log and get us the detailed related to this issue.
413 11/28/2020 05:28:21 am
Re: Sales Invoice Reference - Can it expand? (3 replies, posted in Modules Add-on's)
You are right. It's the decimal values to add zeros In prefix.
414 11/28/2020 05:25:42 am
Re: SMS Gateway (8 replies, posted in Modules Add-on's)
It's simple question. And simple way I am giving answer. You can write your sms sending program in pure php and trigger the php function using the FA program. Simply call from the sms function where you need. Before that add some validations and sms texts to send it to customers.
415 11/27/2020 05:22:24 pm
Re: Error: no supplier trans found for given params (4 replies, posted in Report Bugs here)
@notrinos, if you found solution for the bug. Update here. @joe will fix the bug.
416 11/27/2020 08:18:26 am
Re: Display quantity on hand on printed purchase order (1 replies, posted in FA Modifications)
Actually dude showing the quantity in stock is easy to get it like my last answer . But making it on report is a bit different. You have to update them on respective rep file, it's header.inc and doctext.inc. So this task you have to try with own risk. As we have shown how to get it, use that for reports to print one extra column.
417 11/25/2020 11:15:58 am
Re: PDF (7 replies, posted in Reporting)
By editing the pdf generator program files you can get your customized pdf. But if you want to edit an generated pdf you have to use pdf editing software's to do
418 11/24/2020 08:32:15 am
Re: OverDraft Error Showing (GL-Bank Account Transfer Module) (5 replies, posted in Banking and General Ledger)
@poncho1234 answer is correct. Unless the balance insufficient. You don't see that warning . Probably on 9th November, You might not have sufficient balance in select bank to perform it.
419 11/23/2020 05:35:08 am
Re: Fixed Asset Category cannot be added (3 replies, posted in Fixed Assets)
The category_id is a primary key and auto increment. Guess it's does not in ur server. Just try to make to it. It will work.
420 11/21/2020 03:38:21 pm
Re: Purchase Order Receiveing (8 replies, posted in Report Bugs here)
This happens, because of session destroyed. 2.4.1 is old version. May be update your FA. It might fix your issue. Else from session.inc there is preventhijacking function. There is second if statement. Comment that two lines. It will work for you.
421 11/18/2020 08:11:52 am
Re: pdf utf8 and german special chracters (6 replies, posted in Reporting)
Yes along with your utf 8 converted po and compiled mo. He has to update the installed_languages.inc with its right encoding
422 11/18/2020 08:10:34 am
Re: Work with more than one company at the same time? (5 replies, posted in Installation)
Nothing to be complicated. He just needs to use more than one company in a browser. Incognito works fine for it. We need to mask or hide ip address. Simply the access to second company. With help incognito we can login more companies like that..
423 11/18/2020 02:59:27 am
Re: pdf utf8 and german special chracters (6 replies, posted in Reporting)
Hi,
thanks for the reply.
I just checked the languagefile and found
Content information for package 'de_DE'
Charset encoding iso-8859-1
So I will have to check the mo and po files, can it be that only the PDF's are involved?
I will use po-edit and check that the languagefile is utf8, after that i will notify.
Regards,
Jan
Change the encoding to utf-8
It will work for you.
424 11/18/2020 02:56:12 am
Re: Work with more than one company at the same time? (5 replies, posted in Installation)
Another possibility, You can use incognito window to open another company like wise you can open more companies in one browser,
425 11/16/2020 08:04:30 am
Re: Search Customers Invoice by phone number (6 replies, posted in Reporting)
You need to customize it a bit to take effect. Let's try this.
From direct invoice page you can see payment term cash only. If you change the term to some other not cash payment. It will show additional fields at the bottom. There you can see contact phone no. Simply bring that field to cash only invoices. And while making invoice use that to store Phone numbers. By altering the search you can get the customer transaction of walk in customer with phone number.