Finance (Financials)

This will include the questions related to Financials.

  • 4,262 Topics
  • 11,747 Replies

4262 Topics

R
Do Gooder (Customer)
RvdBosDo Gooder (Customer)
asked in Finance (Financials)

Period Allocation Supplier Invoice

Hi All, Can someone please tell me how to use the function Period Allocation in Manual Supplier invoice as when I clic kon the box of Period Allocation it doesnt mark it. Even when I create a line with the account and Cost Cent it doesnt allow me also nothing when I do RMB on the line it doesnt pop up. Even in Posted Status it doesnt work. Is there some step by step setup guide to get this working? We already created voucher type X in all the periods for the year etc.  

6
C
Do Gooder (Customer)
2 months ago
F
Do Gooder (Partner)
FekSebasDDo Gooder (Partner)
asked in Finance (Financials)

Payment files to Kyriba

Hello, Could you tell me if IFS is able to send files for supplier payment in the format expected by Kyriba?Best regards

3
T
Do Gooder (Customer)
5 months ago
IsuruHimself
Do Gooder (Employee)
IsuruHimselfDo Gooder (Employee)
asked in Finance (Financials)

Finally Calculated status on Customer Order Commission Lines

How do we get Customer Order Commission Lines to reach a status of “Finally Calculated?

1
S
Do Gooder (Partner)
1 year ago
K
Do Gooder (Customer)
KWPCFODo Gooder (Customer)
asked in Finance (Financials)

Customer Analysis Ratios

I am looking for where and how I might be able to analyze a customers payment performance.  Specifically, I am looking for ratio’s on prior their prior payment performance.  In Customer Credit Analysis the Customer DSO and ART ratios show zero unless the customer has an open balance in A/R.So if a customer has no A/R then there are no payment performance ratios available.  Which means “inactive” customers or current customers with no A/R can’t be reviewed.Any suggestions?

2
K
Do Gooder (Customer)
1 year ago
K4uLinalM
Sidekick (Partner)
K4uLinalMSidekick (Partner)
asked in Finance (Financials)

"Rollback Partial Payment" is greyed out ("Rollback supplier payment")

Hello, I have a question about the "Rollback Partial Payment". In the "Rollback supplier payment" screen, when the payment is of automatic type, sometimes the rollback partial payment is not greyed out and sometimes it is greyed out and I can't understand why. Could you please help me with this? Thank you very much.Lina

1
Chirantha
Hero (Employee)
1 year ago
J
Do Gooder (Customer)
janickfDo Gooder (Customer)
asked in Finance (Financials)

Cloud: Use API to import accounting vouchers

HelloI can’t figure how to import data into accounting vouchers using the API”s. First I looked at the  VoucherHandling API but there are only GET functions and some PATCH but no POST to insert data in the Voucher entity.I suppose that this table is protected and I tried to use the ExternalVoucherHandling to insert data in the ExternalVoucheSet as the file import in IFS does.There is a POST function to insert lines in the ExternalVoucheSet but it ends up with the following error:":"ORA-20111: ExtLoadInfo.FND_RECORD_NOT_EXIST: The Ext Load Info does not exist." So I supposed that I needed to create first an ExtLoadInfoSet as a title for the lines.In this API there are no POST functions with a json payload but a function called ExtLoadInfo_DoCreateVoucher.I have tried to call this function with 2 parameters:  Company = XXX , LoadId=2 but I get this error:Payload: {"error":{"code":"ODP_RESOURCE_NOTFOUND","message":"Resource not found."}} This seems to indicate that the function does not e

3
jaryskorys
Sidekick (Customer)
1 month ago
V
Do Gooder (Partner)
Vinoy HeshanDo Gooder (Partner)
asked in Finance (Financials)

CuurentActivityContext has been garbage collected

Our users get this error message when using lobbies that are connected to forms/tbws . This appears every day, sometimes several times a day for some users. We tried to look in to this and the answer we got from the end users is that it could have something to do when many work on the same lobby simultaneously OR that the lobby wasn´t updated which means that the information somewhere in the lobby is old. We also got from our users that it appeared at the same time during the day (for example around 10 a clock).   

10
D
Do Gooder (Customer)
1 day ago
J
Do Gooder
jillkersDo Gooder
asked in Finance (Financials)

User Group has to be changed manually when approving JEs

We are using IFS 9 and have come across an issue and wonder if anyone else has seen it. We have user group JEP (prepares JE) and JER (reviews/approves JE). After the JEP enters a JE to be approved, the JER goes to into that company and the User Group for Approval automatically changes to JER and they can approve. However, once they switch to another company it no longer automatically changes to JER and they have to manually change it. If they log out of IFS and back in and go to that company again, it automatically changes to JER. Obviously, this is an annoyance and not a showstopper but I am wondering if anyone else has had that issue and if so, were you able to resolve it.I appreciate any insight you can provide.Jill

5
R
Hero (Customer)
1 year ago
S
Sidekick (Customer)
SMcLeesSidekick (Customer)
asked in Finance (Financials)

Bank reconcilliatioin - Automatic Transaction matching

When using the bank statement template/upload function for bank reconciliation, how can I upload a Cust/Supp ID on the bank statement for automatic matching?

1
N
Hero (Employee)
1 year ago
E
Sidekick (Customer)
EDCLISASidekick (Customer)
asked in Finance (Financials)

Customer Repayment SQL statement for Laser Check

Does anyone have a SQL statement for the Customer Payment Check for the Laser Check.   We have a Crystal report that is only considering Supplier Payments.   I can get the check to print out on the IFS Standard Report so trying to figure out why the Crystal report is not printing the Customer Repayment Check.  The IFS Standard report looks like it uses tables Supplier_Checks, Suppplier_Check_Items, Supplier_Check_ItemHere is our Crystal Report SQL Statement. SELECT "SUPPLIER_CHECK_TRANSACTIONS_"."PAYMENT_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."DISC_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."FULL_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."CHECK_AMOUNT", "LEDGER_ITEM_SU_QRY_"."VOUCHER_NO", "SUPPLIER_CHECK_TRANSACTIONS_"."SUPPLIER_NAME", "ADDRESS_DEFINITION_V2_"."ADDRESS", "SUPPLIER_CHECK_TRANSACTIONS_"."PAY_DATE", "SUPPLIER_CHECK_TRANSACTIONS_"."CURRENCY", "LASER_PRINT_CHECK_REP_"."CHECK_NO", "LASER_PRINT_CHECK_REP_"."RESULT_KEY", "SUPPLIER_INFO_ADDRESS_PAY_LOV_"."DEF_ADDRESS" FROM   ((("IF

2
E
Sidekick (Customer)
2 years ago
N
Do Gooder (Partner)
NayLanLaDDo Gooder (Partner)
asked in Finance (Financials)

External Tax Interface for Canadian Company on App 10

My customer uses external tax system Zip2Tax to interface with their current ERP system Oracle application to look up/pass sales and use tax rate to Oracle. While their US company only uses external tax system to pass sales tax rate to customer order/invoice, their Canadian company uses the external system for both sales tax on customer order and use tax on purchase order.  They are implementing IFS app 10 and will have to replace Zip2Tax with Vertex or Avalara. Can anyone tell me if IFS App 10 external tax interface with Vertex/Avalara work for passing Canadian sales tax (GST, PST, HST) to customer order and use tax to purchase (order) for Canadian companies? I cannot find documentation that indicates so. Any power-point slides and documentation I have read so far says customer order side only.If interface does not exist to pass tax rate onto customer order/PO/invoice for Canadian company, we have to develop interface with their current external tax system or users manually input/trac

1
T
Superhero (Employee)
2 years ago
D
Do Gooder (Employee)
Devindya SathsaraniDo Gooder (Employee)
asked in Finance (Financials)

Query functionality in posting proposals Page - IFS Cloud

Hi Team,In the posting proposal window, when you use the option "Show invoice: I'm Next authorizer", is the system supposed to filter records by Status message ID "Awaiting Authorization"?This is not the same behavior when the user uses "Show invoice: My Only".What is the reason for this design?  

3
M
Do Gooder
11 months ago
A
Do Gooder (Customer)
andrei.borromeoDo Gooder (Customer)
asked in Finance (Financials)

Two Year Closing Periods in a Fiscal Year?

Hello. Our fiscal year 2022 starts in October 2021. At the end of December, there will be a change of owners / acquisition so we would like to do a year close to clear the income statement (Period 1 to Period 3  FY2022) to retained earnings. At the start of January 2022 (Period 4 FY2022), we will manually upload balances under this new ownership. Then at at then of September 2022 (Period 12 FY2022), will do a year close to clear the income statement to retained. So essentially, we would like to do close to mark the ownership change/acquisition then a another close to end the year. As such, we will have two year closings (ie. two year closing periods in FY2022).  Is this possible? I would appreciate any thoughts on this or other alternatives. Thank you.

1
T
Superhero (Employee)
2 years ago
N
Hero
Nagah.khaledHero
asked in Finance (Financials)

UNABLE TO CLOSE ACCOUNTING PERIOD

I’M TRYING TO CLOSE ACCOUNTNIG PERIOD FEB-2023, BUT SYSTEM RAISED THE BELOW ERROR. 

1
G
Superhero (Partner)
1 year ago
R
Do Gooder (Employee)
runiseDo Gooder (Employee)
asked in Finance (Financials)

Peppol in Cloud

Hi,I have received a question from a customer, does Cloud support Peppol for EInvoicing? Is there some documentation available that I can refer?Thank you.Kind regardsRutuja

1
S
Do Gooder (Partner)
4 months ago
Shanuka Lashan
Superhero (Employee)
Shanuka LashanSuperhero (Employee)
asked in Finance (Financials)

How to enable LoV button in Manual Supplier Invoice screen.

Hi All, Can someone help me to understand, how we can enable the LoV button in Manual Supplier Invoice screen?  Thank you in advance.Kind regards,Shanuka.

4
Shanuka Lashan
Superhero (Employee)
1 year ago
C
Do Gooder (Partner)
CBKLeasureDo Gooder (Partner)
asked in Finance (Financials)

CUCHECK doc number series

I mistakenly have set up a payment document number series for payment document CUCHECK.  I need to remove this to allow alphanumeric values for the payment number but I am unable to delete or expire the series numbers.  Any suggestions on how to disable or delete this?  

9
cperdue
Hero (Partner)
1 year ago
S
Do Gooder (Partner)
sood33Do Gooder (Partner)
asked in Finance (Financials)

Change format to percentage

Hi Team  - I am facing a very typical issue. The value which should be displayed in percent like xx.yy% are getting displayed as 0.xx Example 88.77% is getting displayed as 0.8877 and 20% is displayed as 0.2. Please suggest a remedy to resolve this

5
AkilaR
Hero (Partner)
3 years ago
T
Sidekick (Partner)
TopMalinGSidekick (Partner)
asked in Finance (Financials)

Capture labour cost through time registration window

Hi All,In my case, employee register their project wise time through time registration window.When time registration is authorized, project transaction is created under TIME project code. It records only time figure but no costing figures.If I RMB on the record, go to posting there are two valid records. But there is no amount. There is not any voucher created for this record.My requirement is to add employee costing figures to application. Where do I enter those costing figures. Can I use Standard Cost window?If I put costing figures somewhere, will it create a voucher when time registration is authorized?Any help document for this requirement?Regards,Malinda 

2
T
Sidekick (Partner)
1 year ago
JJäthing
Hero (Partner)
JJäthingHero (Partner)
asked in Finance (Financials)

CAMT053 Supplier invoice payment charge

In the process of setting up basic data for bank charges the first I run into is a supplier invoice payment charge. I create the pseudo code and enter it on the tab ‘Definition of Identifiers’ and the only ‘Transaction Type’ option is ‘Direct Cash Trans’.  It is not possible to connect it to the message code ICDT.Is there any a solution for this?

1
JJäthing
Hero (Partner)
2 years ago
A
Do Gooder (Partner)
AbdessamadDo Gooder (Partner)
asked in Finance (Financials)

Tolerance posting proposal

Hello,  I have a question about the tolerance in the posting proposal. Is there a way to block the posting proposal modification if the difference between the invoice and the PO is above tolerance values ?  Best regards.  

3
X
Superhero (Employee)
1 year ago
T
Do Gooder (Customer)
taenarenDo Gooder (Customer)
asked in Finance (Financials)

Customer Statement is emailed out when previewed

Hello,Customer Statement of Account APPS9When the user runs the Customer Statement of Account and hits the preview button the statements get emailed out immediately. Has anyone had the same issue?   

5
T
Do Gooder (Customer)
2 years ago
S
Sidekick (Customer)
SMcLeesSidekick (Customer)
asked in Finance (Financials)

Account Matching - Intercompany & accounts

We have G/l accounts that balance between entities each month.  They are different g/l code numbers depending on the entity. Is it possible to match of transactions between these so that reconcilliation at end of month is easier? We usually have a balance that needs investigated to work out what it is etc, be good if we could match off and see exactly what any issues are 

0
S
Sidekick (Customer)
3 years ago
N
Do Gooder (Customer)
NPHAHMEDJUMADo Gooder (Customer)
asked in Finance (Financials)

Return Cheque

Customer submit for me one check today 10-Aug and check date is 01-Sep which mean it’s PDC.now after i record it and match it with some invoices, in 01-Sep it’s return from the bank!! how i can handle this because the cancellation will not help especially he will give another Check “new” and we need to match this new check with old one?And i need the financial entry to be like thisDr Bounced Cheque Account  / CustomerCr Bank Account.

2
A
Do Gooder
3 years ago
J
Do Gooder (Customer)
jdowneyDo Gooder (Customer)
asked in Finance (Financials)

Currency Rate entered incorrectly

The currency rate for a certain day was entered incorrectly.  The rates for USD and EUR were reversed.  I have several customer invoices that I need to correct.  What is the best way to do this?  I went into the customer invoice and entered the correct rate in currency rate correction.  Then I tried to create a correction invoice, but nothing happened.  The background job has a warning that says the Invoice ID does not exist in Company 14.  I’m not sure why it isn’t working, because I’ve done this before.

1
J
Do Gooder (Customer)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings