Replies posted by Viraj Sandaruwan

47 Replies

General Ledger Report Counter Account

hi @jessica.john Ideally dialog should be opened with current accounting year and accounting period.But I’m not sure why system doesn't fetch the accounting period value for both “from period” and “to period”. How did you remove the default values of periods? Have you changed the accounting year manually ?Check whether you have defined accounting periods for 2020 and please send me a screen print of initially loaded dialogThanks and regards,Viraj

2 years ago

InesSidekick (Partner)

asked in Finance (Financials)

Final year end : balance accounting currency not equal to zero

hi @Ines , Requirement:Balance of Assets and liability accounts should be equals to 0.In your case, there is a balance of -13434.34 in the statistic accounts. that is the reason why Assets and liability balances are not equal to the zero. So you may have to transfer the balances of statistic account to correct account by creating a manual voucher first.Thanks and regards,Viraj

2 years ago

InesSidekick (Partner)

asked in Finance (Financials)

Final year end : balance accounting currency not equal to zero

hi @Ines You may have to transfer the balance of those accounts (999940 & 999941) to relevant correct account before doing the final year end.Thanks and regards,Viraj

2 years ago

InesSidekick (Partner)

asked in Finance (Financials)

Final year end : balance accounting currency not equal to zero

hi @Ines It seems like there is a balance in statistics accounts. you may have to transfer them to relevant accounts before running the final year end.Go to GL balance analysis window and check the balances by account type. you can RMB on statistic accounts line and check the voucher information.OR You can use below query to identify those voucher rows.select voucher_type,voucher_no,row_no,account from gen_led_voucher_row_tab where company='XXX' and accounting_year=2018 and account_api.Get_Logical_Account_Type_Db(company,account)='S'Replace XXX with company id.BTW send me the results for the following query as well.select Distinct t.accnt_type from accounting_code_part_value_tab t where code_part='A' and t.logical_account_type='S' and company='XXX';Thanks and regards,Viraj

2 years ago

InesSidekick (Partner)

asked in Finance (Financials)

Final year end : balance accounting currency not equal to zero

hi @InesPlease check whether you have performed the ‘Clear revenue/cost’ process. If yes, send me the results for the below query.select account_api.get_accnt_type_db(company,account),sum(amount_balance),sum(third_currency_amount_balance) from accounting_balance where company='xxx' and accounting_year=2018Group by account_api.get_accnt_type_db(company,account)Replace xxx with correct company id.Thanks and regards,Viraj

2 years ago

BayoSidekick (Partner)

asked in Finance (Financials)

The Balance in Accounting Currency and Parallel Currency

Hi Bayo,As we checked, There was an account with mismatching logical account type and account type.This has to be fixed via data repair to solve the issue.Please let us know the feedback.Thanks and regards,Viraj

2 years ago

BayoSidekick (Partner)

asked in Finance (Financials)

The Balance in Accounting Currency and Parallel Currency

Hi BayoHave you used the correct company id?select account_api.get_accnt_type_db(company,account),sum(amount_balance),sum(third_currency_amount_balance) from accounting_balance where company='MTNZW' and accounting_year=2020Group by account_api.get_accnt_type_db(company,account)Could you please send me a screen print of the results?Thanks and regards,Viraj

2 years ago

BayoSidekick (Partner)

asked in Finance (Financials)

The Balance in Accounting Currency and Parallel Currency

hi @Bayo Could you please check the result for below query?select account_api.get_accnt_type_db(company,account),sum(amount_balance),sum(third_currency_amount_balance) from accounting_balance where company='MTNZW' and accounting_year=2020Group by account_api.get_accnt_type_db(company,account)Thanks and regards,Viraj

2 years ago

AryShaDo Gooder (Partner)

asked in Finance (Financials)

Object Transaction with Status "ExternallyCreated"

Hi @ArySha Then we may have to correct it via data repair. Thanks and regards,Viraj

2 years ago

AryShaDo Gooder (Partner)

asked in Finance (Financials)

Object Transaction with Status "ExternallyCreated"

hi @ArySha You may have to activate that transaction from “Add investment progress” window.Thanks and regards,Viraj

2 years ago

IZMJFINNEYDo Gooder (Customer)

asked in Finance (Financials)

kimsiangDo Gooder (Customer)

asked in Finance (Financials)

Supplier Invoice (Error 20105: Object XXX has been existing accounting...)

hi @kimsiang Could you please let me know the status of faobject?I hope it is in “investment” status. According to the App7.5 implementation, we cannot have different code strings for an acquisition transaction. I’m not sure why we don't have the same code string when cancelling the supplier invoice.As a workaround maybe you can try to activate the object and deactivate it first.then try to cancel the supplier invoice. Thanks and regards,Viraj

2 years ago

RakeshSidekick (Partner)

asked in Finance (Financials)

Not Able to close Accounting Year due to existing Currency Balance

Hi @Rakesh , Currency balances will only be updated if your account is a currency balance account. So the balance of transaction currency might not be equals to zero for a particular period and It is not an issue. Thanks and regards,Viraj

2 years ago

RLGroenerDo Gooder (Partner)

asked in Finance (Financials)

How to rollback active fixed assets

Hi @RLGroener Go to the “Depreciation proposal” window and check whether you have unhandled depreciation proposals (status with Created) for those objects. if yes, you may have to cancel them first. Thanks and regards,Viraj

2 years ago

KochrimSidekick (Customer)

asked in Finance (Financials)

Insert GROUP_ID into IDENTITY_INVOICE_INFO

Hi @lagrarif Maybe you have to verify the data in the INVOICE_PARTY_TYPE_GROUP_TAB first.You should have a record with group id “0” for the given company and party type. Please check the values of the party type column. (It should be either “CUSTOMER” or “SUPPLIER” in capital letter) SELECT * FROM invoice_party_type_group_tab WHERE company = '&company_' AND party_type = '&party_type_db_' AND group_id ='&group_id_'; Thanks and regards,Viraj

2 years ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Specific Day Payment terms

Hi @SMcLees It seems like @Nancy Fink ‘s answer is a good workaround to sort out your issue.Maybe you can use the attached script to insert data into the payment vacation window via back end.You have to provide the values for from_date, to_date, day_of_the_week, company,payment_mehod and customer_id when you execute the script.It will automatically calculate the start date , finish date and the new due date for the given period. Hope this will save your time. Thanks and regards,Viraj

2 years ago

RakeshSidekick (Partner)

asked in Finance (Financials)

Not Able to close Accounting Year due to existing Currency Balance

Hi @Rakesh If you check the balances, you can see that -6542314.02 (-34113062.91+27570748.89) balance in the Revenue/Cost accounts. Actually, this amount should be posted as GP8 posting when you run the “Clear revenue/cost” process. Please check whether you have updated the Clear/cost revenue voucher to the GL.if yes, May be you can try to execute the “Clear revenue/cost” process again and follow the same steps. Thanks and regards,Viraj

2 years ago

steve_stadnikDo Gooder

asked in Finance (Financials)

Posting Error in IFS Lease

Hi @steve_stadnik May I know the exact error message and what was the action you haveperformed to get this error message. Thanks and regards,Viraj

2 years ago

RakeshSidekick (Partner)

asked in Finance (Financials)

Not Able to close Accounting Year due to existing Currency Balance

Hi @Rakesh Hope you have updated all vouchers to the GL. :) Could you please run the below query in “SQL Query Tool” window and let me know the results. select account_api.Get_Logical_Account_Type_Db(company,account) acc_type ,sum(amount_balance) dom_balance,sum(third_currency_amount_balance ) thid_bal from accounting_balance where company='&company'and accounting_year='&from_accounting_year'Group by account_api.Get_Logical_Account_Type_Db(company,account) Thanks and regardsViraj

2 years ago

ROXTOBBRISidekick (Customer)

asked in Finance (Financials)

New Manual Supplier Invoice Aurena posting line problem

Hi @ROXTOBBRI Maybe you can try with 0.22(decimal point) rather than 0,22 (comma). Thanks and regards,Viraj

2 years ago

RakeshSidekick (Partner)

asked in Finance (Financials)

Not Able to close Accounting Year due to existing Currency Balance

Hi @Rakesh No need to run the preliminary year-end. You can directly run the Clear revenue/cost process and perform the year-end process. Thanks and regards,Viraj

2 years ago

RakeshSidekick (Partner)

asked in Finance (Financials)

Not Able to close Accounting Year due to existing Currency Balance

Hi @Rakesh No need to open all the accounting periods. year end period would be enough.Thanks and regards,Viraj

2 years ago

Page 1 / 2

Replies posted by Viraj Sandaruwan

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded