Hello,
Fresh install of 2.4.3.
When attempting to modify the price list on sales quotation that are already created I have noticed the fields on the header section are greyed out except for the Reference field.
Thanks
Jack
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by andijani
Hello,
Fresh install of 2.4.3.
When attempting to modify the price list on sales quotation that are already created I have noticed the fields on the header section are greyed out except for the Reference field.
Thanks
Jack
Thank you for suggestions. I was able to close the loop by creating a supplier credit note Supplier A (freight forwarder) for Foreign Exchange Gain/Loss Account. (original invoice is for Freight account)
This same Foreign Exchange Gain/Loss account was used to create Supplier Invoice for Supplier B (forex broker).
Hello,
We are using a 3rd party currency exchange broker to pay our supplier overseas. Looking for a solution to allocate these transactions.
Supplier A sends us their invoice for GBP 1000 for services provided. We then exchange CAD to GBP with Supplier B and create Payment to Supplier B for CAD 1800. Supplier B wires the payment on our behalf to Supplier A.
Has anyone come across the situations like this? How do we go about allocations?
Thank you,
Jack
The Tax Inquiry and General Ledger Inquiry produce inconsistent results for taxes. General Ledger Inquiry results are correct while Tax Inquiry is omitting Bank Payment and Deposit type of transactions.
FA 2.4.2 Tax summing is not correct in Tax Inquiry page. Supplier invoice taxes also show up as sales invoice taxes and they are added instead of being subtracted.
Example.
Type Description Amount Outputs/Inputs
GST / TPS 5% Charged on sales (Output Tax): 82.80 1,656.00
GST / TPS 5% Paid on purchases (Input Tax): 82.80 1,656.00
GST / TPS 5% Net payable or collectible: 165.60
This is not the case with FA 2.3.22 where all tax details are pulled by the TAX Report.
All postings from these documents are expected to show up on TAX Report.
Transcation Type
Journal Entry 0
Bank Payment 1
Bank Deposit 2
Sales Invoice 10
Customer Credit Note 11
Supplier Invoice 20
Supplier Credit Note 21
Please see my latest post. Even Invoices are not populating reg_type files if GL entries are used. And with reg_type field as NULL the Tax Report shows no results.
On Supplier Invoice
Items Received Yet to be Invoiced - Tax Report shows the taxes incurred
GL Items for this Invoice - Tax Report doesn't show the taxes incurred
I just posted another supplier invoice using a quick entry and the reg_type filed on tax detail table was not populated. This could be due to quick entries.
I am using quick entries in bank payments with taxes. And these postings don't show up on tax reports.
Correction to my post. Direct Invoice is ok. Only Bank Payment taxes are affected.
FA 2.4.2 Tax Report not complete
I noticed the Tax Report is not reporting all tax postings from trans_tax_details table. Every time I record a Direct Invoice or Bank Payment the Tax Report is not showing the taxes posted by these forms.
Here is how my table looks like:
Trans_Type 20 Reg-Type 1
Trans_Type 10 Reg-Type 0
Trans_type 13 Reg_Type Null
Trans_type 11 Reg_Type Null
Trans_type 1 Reg_Type Null
BLOB fields were not export/imported properly. I set the charset to UTF-8 and exported as sql instead of excel or text. Now everything shows up normally.
However this din't fix the duplicate lines of one particular bank payment. This duplicate line only appears on General Ledrer view without affecting the account balance in general.
Hello,
I would like to report this problem on Frontaccounting 2.4.2.
My data was imported from excel from FA 2.3 using Navicat import/export feature.
On General Ledger Inquiry screen the Person/Item field looks gibberish (Customer [0x333135eJ¼aE]) for imported entries and shows only person id (230) instead of name for new entries.
Also, when drilling down to General Ledger Inquiry view there could be duplicates of entries.
Bank Payment 734 07/04/2017 Customer [0x3830354eJ\X] 45.00 2,380.80
Bank Payment 734 07/04/2017 Customer [0x3830354eJ\X] 45.00 2,335.80
Yes, it worked when I changed rep_check_print.php with the one on your repo.
Appreciate your help.
Thank you. I was able to install and activate the extension. But as Alaa stated the printing part is not working.
Hello,
Installed the extension on FA 2.4.2 but the module not showing up on Purchaser Reports.
Do we need to make some changes in this code to make it work in 2.42?
<?php
global $reports, $dim;
$reports->addReport(RC_SUPPLIER, "_cheque_print",'&Cheque Printing',
array( 'Cheque No.' => 'TEXT',
'Payment' => 'REMITTANCE'));
?>
Thank you for your help.
Jack
thank you for more information. The only thing I was not able to change is the line height just before charge to delivered to line. I wanted to make this line black and bolder.
I figured this out.
To change the color of the document title I changed the codes using http://www.color-hex.com/color/d1199b
// Document title
$this->SetTextColor(190, 190, 190);
To make phone and fax normal I change 'italic' to 'normal':
// Company data
$this->TextWrapLines($ccol, $icol, $this->company['postal_address']);
$this->Font('italic');
Thank you for your quick help. This worked for me.
Do you know the lines for these 2 changes?
Color and line weight on the header? I want to make it bolder and black.
Phone number, Fax, Email are in italics. How to make them normal?
Thank you
Jack
Hi developers,
First, thank you for this awesome program. I am glad that I gave FA a try. I have been using Adempiere for the past 5 years and decided to switch to something lightweight and easier to learn. After using it for 1-2 weeks I already started to feel comfortable with it . It is fast and has many features that simply function.
I have few questions concerning document modification if you can help with.
Font size of "Charge to" and "Delivered to" appear too small to read. How to increase it?
How can I change the color and line weight on the header?
Phone number, Fax, Email are in italics. How to make them normal?
If you can point at the php file and line number that affect these I would appreciate it.
Thank you
Jack
FrontAccounting forum → Posts by andijani
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.