1 Reply by yubrajkafle99

(7 replies, posted in Report Bugs here)

@rafat  Thank you so much . Worked .
problem solved .

Go to forum: Report Bugs here

2 Reply by yubrajkafle99

(7 replies, posted in Report Bugs here)

@rafat

I am getting this error
DATABASE ERROR : Cannot update audit gl_seq
error code : 1048
error message : Column 'fiscal_year' cannot be null
sql that failed was : UPDATE 0_audit_trail audit LEFT JOIN 0_fiscal_year year ON year.begin<='2023-11-08' AND year.end>='2023-11-08' SET audit.gl_seq = IF(audit.id=6, 0, NULL),audit.fiscal_year=year.id WHERE type='0' AND trans_no='2'

my fiscal years Starts 2022.01.01
and Ends : 2022.12.31


i had posted the journal Entry on Date 2022.12.10 and i have got this error when i try to update my Journal Entry Date to 2022.12.11

Go to forum: Report Bugs here

3 Reply by yubrajkafle99

(7 replies, posted in Report Bugs here)

@joe
$kvvaradha

please check it

Go to forum: Report Bugs here

4 Topic by yubrajkafle99

(7 replies, posted in Report Bugs here)

Dear Team,

I would like to bring to your attention that I have identified a bug in the latest version of FA.

When attempting to edit a transaction and modify the date, we encounter an issue where we are unable to save the transaction. An error message is displayed, which reads as follows:

"DATABASE ERROR: Cannot update audit gl_seq
Error code: 1048"

I have also confirmed that this issue persists in the latest FA release.

I would like to emphasize the urgency of addressing this matter promptly. Please prioritize and resolve this bug as soon as possible.

Thank you for your attention to this issue.


Step to Reproduce :
    Enable Debug Mode
Enter the Transaction and submit
reopen the same transaction for editing
change the Date
and Save .

it can be easily Reprodue in Journal and other transaction

Go to forum: Report Bugs here

5 Reply by yubrajkafle99

(3 replies, posted in Items and Inventory)

Opening stock of 15 pieces purchased at a rate of 1,637.16
Purchase of 10pieces at a rate of 1,708.85 in the last tax period
sales of 2 piece at a rate of 1712.38 in the last tax period
after sales purchase of 5 piece at a rate of 1708.85 in the last tax period
Currently, there are 28 pieces left in stock



Solution


alculate the unit cost of the item using the Weighted Average method:

Step 1: Calculate the total cost of the opening stock
Total cost of opening stock = 15 x 1,637.16 = 24,557.40

Step 2: Calculate the total cost of the purchases made in the last tax period
Total cost of purchases = (10 - 2 + 5) x 1,708.85 = 20,351.25

Step 3: Calculate the total cost of goods available for sale
Total cost of goods available for sale = Total cost of opening stock + Total cost of purchases = 24,557.40 + 20,351.25 = 44,908.65

Step 4: Calculate the weighted average cost per unit
Total units available for sale = Opening stock + Purchases - Sales = 15 + 10 - 2 + 5 = 28
Weighted average cost per unit = Total cost of goods available for sale / Total units available for sale = 44,908.65 / 28 = 1,603.16


as per my calculation unit price is 1603.16

but in front accounting 1776.1466666667



i think same issue

Go to forum: Items and Inventory

6 Reply by yubrajkafle99

(13 replies, posted in Items and Inventory)

Opening stock of 15 pieces purchased at a rate of 1,637.16
Purchase of 10pieces at a rate of 1,708.85 in the last tax period
sales of 2 piece at a rate of 1712.38 in the last tax period
after sales purchase of 5 piece at a rate of 1708.85 in the last tax period
Currently, there are 28 pieces left in stock



Solution


alculate the unit cost of the item using the Weighted Average method:

Step 1: Calculate the total cost of the opening stock
Total cost of opening stock = 15 x 1,637.16 = 24,557.40

Step 2: Calculate the total cost of the purchases made in the last tax period
Total cost of purchases = (10 - 2 + 5) x 1,708.85 = 20,351.25

Step 3: Calculate the total cost of goods available for sale
Total cost of goods available for sale = Total cost of opening stock + Total cost of purchases = 24,557.40 + 20,351.25 = 44,908.65

Step 4: Calculate the weighted average cost per unit
Total units available for sale = Opening stock + Purchases - Sales = 15 + 10 - 2 + 5 = 28
Weighted average cost per unit = Total cost of goods available for sale / Total units available for sale = 44,908.65 / 28 = 1,603.16


as per my calculation unit price is 1603.16

but in front accounting 1776.1466666667

Go to forum: Items and Inventory

7 Topic by yubrajkafle99

(13 replies, posted in Items and Inventory)

Dear Developers of Front Accounting,

I am writing to inquire about the calculation of unit cost in the inventory valuation report of Front Accounting for a particular item in my inventory. The item in question is 105aps, and I have the following information:

Opening stock of 15 pieces purchased at a rate of 1,637.16
Purchase of 65 pieces at a rate of 1,708.85 in the last tax period
Purchase of 25 pieces at a rate of 2,034.51 in the last tax period
Currently, there are 9 pieces left in stock
I have noticed that the inventory valuation report in Front Accounting shows a unit cost of 1,776.15 for this item. However, I would like to understand how this unit cost is being calculated, including the purchasing prices, opening stock price, and inventory price, as well as the final unit value price.

Could you please provide me with a detailed explanation of the calculation method used to determine the unit cost in the inventory valuation report? I would greatly appreciate it if you could also provide a breakdown of the purchasing prices, opening stock price, and inventory price that contribute to the final unit value price.

Thank you for your time and assistance in this matter. I look forward to your response."

Go to forum: Items and Inventory

8 Topic by yubrajkafle99

(0 replies, posted in Banking and General Ledger)

I just found some issue with tax inquiry.

i had installed updated fA

when i enter one journal transaction related with purchase from journal entry .
Transaction is effecting on both side of tax inquiry

Type Description Amount Outputs/Inputs
Tax 13% Charged on sales (Output Tax): 13,000.00 100,000.00
Tax 13% Paid on purchases (Input Tax): -13,000.00 -100,000.00
Tax 13% Net payable or collectible: 0.00
    Total payable or refund: 0.00


Check This one only one journal entry effecting on both side of output tax and input tax


My Journal Entry was

Journal Date Account Code Account Name Dimension Debit Credit Memo
2021.11.09 1061 Purchase Vat 13,000.00
2021.11.09 2100 00001 Accounts Payable: Khanal Surgical suppliers Pvt. 113,000.00
2021.11.09 5780 Telephone 100,000.00
Total 113,000.00 113,000.00


you can check this issue in

https://accounting.aats.com.np/2021/gl/inquiry/tax_inquiry.php?
username : admin
password : adminadminadmin




https://mantis.frontaccounting.com/view.php?id=5524

Go to forum: Banking and General Ledger

9 Topic by yubrajkafle99

(10 replies, posted in Report Bugs here)

Tax Report Showing Negative Value
I am facing Two problem with Tax in FA
Problem Number 1.

when i use same Gl for both sales and purchase tax in tax setup like Sales Tax
and enter the sales or purchase transaction through direct invoice 
it shows correct in both tax inquiry as well as tax  report
but when i post the  voucher through journal entry


Journal Date    Account Code    Account Name    Dimension    Debit    Credit    Memo
2021.11.07    2150    Sales Tax         1,300.00       
2021.11.07    2100 00001    Accounts Payable: a             11,300.00   
2021.11.07    5615    Advertising & Promotions         10,000.00       
Total        11,300.00    11,300.00   


Like this tax inquiry shows this
Where journal Transaction effects on both Charged on sales (Output Tax) and Paid on purchases (Input Tax):

Type    Description    Amount    Outputs/Inputs
Tax 13%    Charged on sales (Output Tax):    1,300.00    10,000.00
Tax 13%    Paid on purchases (Input Tax):    -1,300.00    -10,000.00
Tax 13%    Net payable or collectible:    0.00   
    Total payable or refund:    0.00   

But tax report shows correct as per sales Gl
Now my question is how to fix this error so that tax inquiry will show the correct amount as per Tax GL




Problem Number 2
when i use different  Gl for  both sales and purchase tax in tax setup like Sales Tax and Purchase Tax
and enter the sales or purchase transaction through direct invoice 
f
it shows correct in both tax inquiry as well as tax  report
but when i post the  voucher through journal entry
Journal Date    Account Code    Account Name    Dimension    Debit    Credit    Memo
2021.11.07    1200 00001    Accounts Receivables: a1         113,000.00       
2021.11.07    2150    Sales Tax             13,000.00   
2021.11.07    4010    Sales             100,000.00   
Total        113,000.00    113,000.00   


It shows Correct in Tax Inquiry
Tax 13%    Charged on sales (Output Tax):    13,650.00    105,000.00
Tax 13%    Paid on purchases (Input Tax):    -1,300.00    -10,000.00
Tax 13%    Net payable or collectible:    12,350.00   
    Total payable or refund:    12,350.00   


But in Tax Report
Tax Rate Outputs Output Tax Inputs Input Tax Net Tax
Exempt 0.00 0.00 0.00 0.00 0.00
Tax 13.00% -95,000.00 -12,350.00 -10,000.00 -1,300.00 -13,650.00
Total payable or refund -13,650.00

Journal Entry 001/2021         2021.11.07 a1 a1 -100,000.00 13.00 -13,000.00 Tax
Sales Invoice 001/2021         2021.11.07 a1 a1     5,000.00 13.00 650.00 Tax
Supplier Invoice 1             2021.11.07 a         -10,000.00 13.00 -1,300.00 Tax
The amount we enter Through Journal Entry of Sales Has been displayed in Negativ Value which is -100000

Go to forum: Report Bugs here