Thank you Joe. Upgraded to 2.4.11
1 01/05/2022 05:13:02 pm
Re: Tax Inquiry - Purchase (Input )Taxes shown as Sales (Output) Taxes (3 replies, posted in Report Bugs here)
2 12/27/2021 03:28:45 pm
Topic: Tax Inquiry - Purchase (Input )Taxes shown as Sales (Output) Taxes (3 replies, posted in Report Bugs here)
FA 2.4.10
I have come across 2 issues on Tax Inquiry and 1 issue on Tax Report:
1. Input Taxes are treated as Output Taxes:
Purchases/Supplier Invoice
Line:
Shipping Expenses $90
GST / TPS 5% Paid $4.50
QST / TVQ 9.975% Paid $8.98
Banking and General Ledger/Inquiries and Reports/Tax Inquiry
GST / TPS 5% Charged on sales (Output Tax): 4.50 90.00
GST / TPS 5% Paid on purchases (Input Tax): 0.00 0.00
QST / TVQ 9.975% Charged on sales (Output Tax): 8.98 90.03
QST / TVQ 9.975% Paid on purchases (Input Tax): 0.00 0.00
Expected outcome:
GST / TPS 5% Charged on sales (Output Tax): 0.00 0.00
GST / TPS 5% Paid on purchases (Input Tax): -4.50 -90.00
QST / TVQ 9.975% Charged on sales (Output Tax): 0.00 0.00
QST / TVQ 9.975% Paid on purchases (Input Tax): -8.98 -90.00
2. Tax base amounts ae being calculated instead of reflecting the actual invoice amount. Tax base in the above example is $90 but the tax base for 9.975 was calculated as 8.98/0.09975 resulting in 90.03. The same result on Tax reports. This creates a discrepancy in our tax filings where we need to report the tax bases as well.
3 12/10/2021 01:04:42 am
Re: FA2.4.10 Sales Quotation Modification - Can not edit header fields (11 replies, posted in Report Bugs here)
I think you are on earlier version of FA. These are not editable on 2.4.10
4 12/08/2021 04:13:25 pm
Re: FA2.4.10 Sales Quotation Modification - Can not edit header fields (11 replies, posted in Report Bugs here)
It didn't fix the issue. These fields are still not editable:
5 11/25/2021 06:36:15 pm
Re: FA2.4.10 Sales Quotation Modification - Can not edit header fields (11 replies, posted in Report Bugs here)
This quotation had not yet been converted to sales order so it should still be editable.
6 11/25/2021 04:48:33 pm
Re: FA2.4.10 Tax Report not showing Tax details of Credit Notes (3 replies, posted in Report Bugs here)
Hi Joe
Thank you for looking. I think I was able to trace the issue.
Tax report captures credit note taxes when they are calculated. They are ignored when entered manually.
https://u.cubeupload.com/andijani/CreditNote.jpg
https://u.cubeupload.com/andijani/creditnotetaxesclacu.jpg
7 11/25/2021 02:36:04 pm
Topic: FA2.4.10 Tax Report not showing Tax details of Credit Notes (3 replies, posted in Report Bugs here)
FA2.4.10
Tax Report is not showing the tax details of credit notes. Not tried it with Supplier credit notes.
Current printout:
Customer Credit Note C210090 11/18/2021 Daniel Customer -169.50 0.00 0.00
Expected printout:
Customer Credit Note C210090 11/18/2021 Daniel Customer -150.00 13.00 -19.50
https://u.cubeupload.com/andijani/GLTranscationfromCre.jpg
https://u.cubeupload.com/andijani/TaxReportCreditNoteT.jpg
8 11/25/2021 02:24:56 pm
Re: FA2.4.10 Sales Quotation Modification - Can not edit header fields (11 replies, posted in Report Bugs here)
Here are the screenshots:
https://u.cubeupload.com/andijani/FA2326QuoteModify.jpg
https://u.cubeupload.com/andijani/FA2410QuoteModify.jpg
Also notice the branch selection filed is missing on FA 2.4.10
9 11/23/2021 03:45:52 pm
Topic: FA2.4.10 Sales Quotation Modification - Can not edit header fields (11 replies, posted in Report Bugs here)
FrontAccounting 2.4.10
Sales Quotation Modification Header fields are not editable: Customer, Payment, Price List, Quotation Date
They are editable in FrontAccounting 2.3.26
10 11/21/2018 05:06:02 pm
Re: Revaluation amount is getting posted wrongly (9 replies, posted in Banking and General Ledger)
I confirm the same result as mugao-em. The posting is not correct. The balance of USD account in home currency should increase on the date of valuation.
Chequing USD (exchnage rate 1.32 CAD/USD)
Customer Payment 1 001/2018 11/21/2018 DR: 27,874.84
Revaluation Run (exchnage rate 1.33 CAD/USD)
Journal Entry 1 001/2018 11/22/2018 CR: 475.16 27,399.68 Exchange Variance
11 11/20/2018 09:44:26 pm
Topic: Inconsistency on 0_crm_persons table name name 2 (1 replies, posted in FA Modifications)
I have come across this inconsistency in the customer and supplier contact names on the
0_crm_persons table. Customer contact names are populated in "name" and "name2" but supplier contact names are combined in "name" column only.
name name2
John Doe
John Doe
12 11/20/2018 03:56:57 am
Re: Wrong conversion of deferred Income on Delivery of Prepaid Order (2 replies, posted in Report Bugs here)
I have uploaded Git Master code. Sales Order Items are not available on Sales Order to be able to reproduce the above problem.
13 11/19/2018 06:05:29 pm
Topic: Wrong conversion of deferred Income on Delivery of Prepaid Order (2 replies, posted in Report Bugs here)
Delivery of prepaid order is not calculating the amount of Deferred Income correctly when Foreign Currency is involved in FA 2.4.4.
Opening Balance - 05/01/2018 0.00
Sales Invoice 1 001/2018 11/19/2018 4,665.49 -4,665.49
Sales Invoice 2 002/2018 11/19/2018 1,166.37 -5,831.86
Delivery Note 1 001/2018 11/19/2018 17,371.24 11,539.38
Sales Invoice 3 003/2018 11/19/2018 7,348.14 4,191.24
Ending Balance - 11/19/2018 4,191.24
14 11/17/2018 10:03:14 pm
Re: Dimension not posted from Supplier Invoice/Credit Note GL Items (3 replies, posted in Report Bugs here)
I saw that post before and it's not related to my finding. The Supplier Invoice has GL items with Dimension drop-down field. One would assume the transaction would be posted to selected Dimension as a result but it's not. Some supplier invoices are not worth creating a Purchase Order with Item type of charges. It's easier to create a Supplier Invoice with Expense type of accounts from GL.
15 11/17/2018 03:53:16 pm
Topic: Dimension not posted from Supplier Invoice/Credit Note GL Items (3 replies, posted in Report Bugs here)
Fresh Install FA 2.4.4
Supplier Invoice or Credit Note with GL Items is not posting to selected Dimension.
Tested with Bank Payments/Deposits Direct Sales/Purchase without issues.
16 11/17/2018 04:44:46 am
Re: FA with Batch/Serial/Lot Number Tracking System (19 replies, posted in FA Modifications)
I gave it a try and found one issue. Received two batches from supplier. Batch-A 10 PC and Batch-B 10 pcs.
Sales order for 20 pcs. When creating a delivery against sales order there is no option to select a second line to add additional batch. Entered 20 from Batch A and it went through even though Batch A had 10 pcs. Basically oversold Batch A.
Is this module available to download to test locally?
17 11/14/2018 01:33:19 pm
Topic: Revaluation of Currency Accounts multiplies by 2 (0 replies, posted in Report Bugs here)
FA 2.4.4 Fresh Install.
Had some amount in Foreign Currency Bank Account on Day 1.
Ran Revaluation of Currency Account on Day 2. The amount on the blank doubled. With each running of evaluation the blance keeps doubling.
18 11/13/2018 05:05:57 pm
Topic: Sales Tax s not accounted for foreign exchnage variances. FA 2.4.4 (0 replies, posted in Modules Add-on's)
I am testing a fresh install of FA 2.4.4 with default US Chart of Accounts.
Sales Tax s not accounted for foreign exchnage variances. You can see the sequence of entries and this imbalance was resulted.
Default currency is CAD and invoice currency is USD.
https://drive.google.com/file/d/1mqwY8mVn1kQIP-Zin2A8oKI6KvqMiF8Q/view?usp=sharing
19 11/11/2018 05:17:14 pm
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
So Payment Advice does not print a cheque. I am wondering if Check Printing extension by Tom Hallman, USA can be integrated to print payroll cheques as well. Currently it can print only Supplier Payments or Bank payments made to Suppliers as cheques.
20 11/11/2018 03:23:35 pm
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
I noticed the Payment Advice calculates the Wages Payable based on days or hours worked instead of taking this amount directly from the Payment Slip. Suppose I adjusted the Wages Payable on the Payment Slip window. I would expect the same adjusted amount on Payment Advice instead of calculating it again based on the actual work days or hours.
21 11/11/2018 03:10:10 pm
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
Hi Phuong
Great extension!
Does Payment Advice prints a cheque? It's throwing this error.
TCPDF error: Could not include font definition file: dejavu.php
Thank you
Jack
22 04/04/2018 08:21:45 pm
Re: Exchange Variance - Creates unknown Journal Entry (2 replies, posted in Banking and General Ledger)
I am getting this redundant journal entries when performing Bank Payments and Deposits with the foreign currency account.
Here are the results for the same entries in both FA 2.3.22 and FA 2.4.3
Bank Payment 1015 BP0391 03/29/2018 165.90 TST Inspection (this is USD)
Accounting entries (All numbers are in CAD):
FA 2.3.22
Bank Payment 1015 03/29/2018 TST Inspection 217.33
Journal Entry 173 03/29/2018 TST Inspection 344.20 Exchange Variance
FA 2.4.3
Bank Payment 1016 03/29/2018 217.33
Journal Entry 87 03/29/2018 171,300.56 Exchange Variance
The balances in foreign currency accounts are way off especially in FA 2.4.3 and in each case the Bank Payment or Deposit were involved.
23 03/07/2018 02:40:53 pm
Topic: FA 2.4.3 Sales Quotation can not edit the header fields. (1 replies, posted in Accounts Receivable)
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
24 11/27/2017 12:41:25 am
Re: How to allocate the Payment to Supplier A to the Invoice of Supplier B (3 replies, posted in Accounts Payable)
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).
25 11/24/2017 11:12:58 pm
Topic: How to allocate the Payment to Supplier A to the Invoice of Supplier B (3 replies, posted in Accounts Payable)
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