Replies posted by Furkan Zengin

543 Replies

Charles-EDo Gooder (Customer)

Create a new Ledger ID

Hello @Charles-E Ledger ID represents internal ledgers and GL ledger. Let me send you an example of ledger IDs. If you do not have internal ledger defined then no sense to use GC3 control type. Coming back to your problem, unfortunately IFS does not have function to post balance based on its value. None of control type checks whether the balance is negative or positive. You need to manage it manually either by changing value of GP8 or creating a new voucher to transfer balance from account to another.Hope this helps

1 month ago

Sundara.AlagesanDo Gooder (Partner)

asked in Finance (Financials)

Voucher is Balanced at New Payment in Acknowledge Supplier Payment

Hello @Sundara.Alagesan Can you try acknowledging the payment using mixed payment? Go to mixed payment and create a new record on the date of payment date from acknowledge supplier payment order. Create new transaction and select transaction type acknowledge supplier payment order. Select the order ID and complete payment See if this resolves your issue. In the mean time you can create a support ticket to IFS for your issue.Hope this helps

1 month ago

sevoDo Gooder (Customer)

asked in Supply Chain

info about who created the supplier ?

Hello @sevo There are 2 fields in SUPPLIER_INFO_CONTACT view. created_by and changed_by. IFS will update those fields when a new record created or existing record is updated. However, if the there are multiple updates by different users then you will see only latest user. If you activate History Log for this view for Log Update then it should log all the updates with user and date.Hope this helps

1 month ago

sevoDo Gooder (Customer)

asked in Supply Chain

info about who created the supplier ?

Hello @sevo You can see logs on Record History if it is already setup. If it is not setup yet, you can setup on History Log Configuration window.

1 month ago

Rich PDo Gooder (Customer)

asked in Finance (Financials)

External Customer invoice template for STDCIN1

Hello @Rich P You can see the template on External File Templates window. Change separator ID, decimal symbol and date format according to your locale.I created a structured version and attached. Hope this helps

2 months ago

hreavisDo Gooder (Customer)

asked in Finance (Financials)

GL Balance Analysis Not Matching GL Voucher Rows Analysis

Hello @hreavis If you have include hold table selected then you will have balances for the vouchers that are not updated to GL yet.Which basically means you can see the balances on GL balance analysis but you cannot see voucher rows on GL voucher rows. Uncheck the field and compare GL balance and GL voucher rows. Additionally, complete update GL routine and compare balances once all the vouchers are updated to GL.If there are vouchers on GL voucher rows however you cannot see the balance on GL balance analysis window, I think this requires a deeper investigation to identify the reason for not updating ACCOUNTING_BALANCE_TAB. Can you check what is the voucher type for those rows? Hope this helps

2 months ago

JohnPDo Gooder (Customer)

asked in Finance (Financials)

Allowed Overdue Days - Credit Control

Hello @JohnP Yes, the allowed overdue days should resolve your issue. You can enter the allowed day on credit info section of customer. I’m copying for you the help description of the field Allowed Overdue Days:The number of overdue days that is allowed for the customer. For example, if you specify 10 days in this field, it will consider the total of unpaid invoices that have exceeded the due date by 10 days as the overdue amount. Also please refer to help from IFShttps://docs.ifs.com/ifsclouddocs/23r2/GeneralIFSApplications/ActivityEnterCustCreditInfo.htm Hope this helps

2 months ago

PaulinaPiDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick report in custom menu - a lof of companies

Hello againI got your question wrongly. Global company parameter is set on the instance (application level), you won’t have that information in DB. Therefore I don’t think that you could have as a parameter in the query of the report. I am not aware of any function to pass the global company value to a quick report. May be @dsj can comment as he is technical expert.Hope this helps

2 months ago

PaulinaPiDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick report in custom menu - a lof of companies

Hello @PaulinaPi You need to combine report with user_finance view. In where clause you can add following syntax. This will only show result for the companies connected to user who is running the reportWHERE COMPANY IN (SELECT COMPANY FROM USER_FINANCE WHERE USERID = IFSAPP.FND_SESSION_API.GET_FND_USER())Hope this helps

2 months ago

Caroline GDo Gooder (Customer)

asked in Finance (Financials)

Cash Flow Forecast - Manual Sources

Hello @Caroline G You need to refresh cash flow source after deleting/adding new items. Go to Update Cash Flow Analysis Snapshot and select values from the list. Then click OK, this should refresh the source. Hope this helps

2 months ago

bapehuSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

TopMalinGSidekick (Partner)

asked in Finance (Financials)

Connect same invoice number sequence for Instant Invoice and CO Invoice

Hello @TopMalinG You need to change Definite Number Series ID on Customer Invoice Types window for invoice type INSTINV.This will automatically use the same series ID and number sequence as customer order invoices. Hope this helps

2 months ago

oniczechDo Gooder (Partner)

asked in Finance (Financials)

How to cancel Supplier prepayment tax document

Hello @oniczech When a supplier invoice is created with 0 value, status is set to paid posted automatically, and an offset transaction is created by the system in the background. Go to supplier analysis window and find the invoice in ledger items. Click Payment per Invoice/Prepayment window and see the offset transaction with U voucher. Copy the voucher no and go to Rollback Supplier Offset window. Find the voucher and click Rollback Complete Payment. This will cancel offset and set status of the invoice to PostedAuth.Now you can cancel the invoice.Hope this helps

1 month ago

unite45Do Gooder (Partner)

asked in Finance (Financials)

Removing Comma from CSV within External File Template

Hello @unite45 As long as you have double quotes around your text there should not be problem with importing the date in case of your column separator is in somewhere in the text. I cant see your column separator from the screen shot but I assume that it is comma. In this case the row below should not create any problemCleared,1/3/2024,"ONLINE PAYMENT, THANK YOU",-500 Anyway, have you tried using REPLACE function? In function argument use below code. Basically it will remove comma from the text. You need to use this for the column where you store "ONLINE PAYMENT, THANK YOU" information.COLUMN_REF,",","" Hope this helps

2 months ago

Devanthi ShanikaDo Gooder (Partner)

asked in Finance (Financials)

Cancel/Delete I voucher type

Hello @Devanthi Shanika Unfortunately there is no way to do that in the standard functionality. Hope this helps

2 months ago

Furkan ZenginSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter 2 Information Source Issue

Hi @MelTanyaS You cannot get both GL and IL balances from single source. You must use 2 information sources.

2 months ago

Devanthi ShanikaDo Gooder (Partner)

asked in Finance (Financials)

Cancel/Delete I voucher type

Hello @Devanthi Shanika You need to cancel invoice. It will automatically create a cancellation voucher with K.Hope this helps

2 months ago

Thuzzith SMDo Gooder (Customer)

asked in Finance (Financials)

Unable to Select and Copy SUMs

Hello,Unfortunately, this function is not available yet. When you export the excel, sum rows are excluded from export file.I think the only option is either writing manually or using excel SUM formula after exporting rows.Hope this helps

2 months ago

hrdilshanSidekick (Employee)

asked in Finance (Financials)

Zero Balance Account Ralling Forward 2023 to 2024

Hello @hrdilshan You can do account matching for non AP/AR accounts.If the account is connected to AP/AR then check if open items are offset (invoices and payments are matched). After all open items are offset then system should not insert the account in OB voucher.Hope this helps

2 months ago

Alex_MeeSidekick (Employee)

asked in Supply Chain

Sales Charges with option to not Invoice

Hello @Alex_Mee On customer order charges there is column with name Collect. If you select this, the charge line is not to be invoiced to customer. See help description for the field. You can test with your case. CollectSelect this check box if the charge is not to be invoiced. If the charge line has already been invoiced, you cannot change this check box. You must also select a shipment ID (below) for every collect charge. Hope this helps

2 months ago

FABPODo Gooder (Partner)

asked in Finance (Financials)

Activation of a new code string

Hello @FABPO There is no risk at all. Just keep in mind that in case of internal ledger, Used in IL checkbox must be additionally selected for an activated code if code part value is desired in internal ledgers. Hope this helps

2 months ago

Shyamali RathnayakeDo Gooder (Partner)

asked in Finance (Financials)

Group Company Connection

Hello @Shyamali Rathnayake There was similar field in IFS10 with field name Master CompanyI am adding for you field description for the field Master Company:If Group Consolidation is used and the Chart of Accounts differ between the reporting companies and the master company, account mapping can, as an alternative to doing it in the master company, be done in each reporting company. If so, enter the identity of master company against which the account mapping should be done. List of Values can be used. Hope this helps

2 months ago

al-vDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

API functions documentation

Hello @al-v As far as I know in cloud, there is not similar window yet. There is window called Entity where you can see table fields etc. But you will not see any SQL code.Hope this helps

2 months ago

Page 3 / 22

Replies posted by Furkan Zengin

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded