Thank you Joe. Upgraded to 2.4.11

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.

I think you are on earlier version of FA. These are not editable on 2.4.10

It didn't fix the issue.  These fields are still not editable:

This quotation had not yet been converted to sales order so it should still be editable.

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

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

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

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

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

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

I have uploaded Git Master code. Sales Order Items are not available on Sales Order to be able to reproduce the above problem.

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

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.

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.

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?

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.

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

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.

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.

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

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.

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