Finance (Financials)

This will include the questions related to Financials.

  • 4,309 Topics
  • 11,860 Replies

4309 Topics

Isuru Thilina
Hero (Employee)
Isuru Thilina
asked in Finance (Financials)

ACCOUNT_GROUP_DESC error when calling GLBalanceAnalysisHandling.svc/BalPipeLineFunc

When calling GLBalanceAnalysisHandling.svc/BalPipeLineFunc via postman receive below database error is received. What am i missing here? ACCOUNT_GROUP_DESC is not a parameter in BalPipeLineFunc./int/ifsapplications/projection/v1/GLBalanceAnalysisHandling.svc/BalPipeLineFunc(Company='10',CompList=null,CompName=null,CompGroupList=null,BalanceSetId=null,IncludeHoldTable=false,SimulationVoucher=IfsApp.GLBalanceAnalysisHandling.SimulationVoucherEnum'Normal',MultiCompany=false,Attribute=null,AttribValue=null,ShowAllBalances=false,WhereStmnt=null,NavStatus='FALSE',RepMapStartYearPeriod=null,RepMapYearPeriod=null,RepMapYear=null,RepMapPeriod=null,ExcludePeriods=null,PeriodMappingExists=null,FromYear=2023,ToYear=2023,FromPeriod=2,ToPeriod=2,FromYearPeriod=null,ToYearPeriod=null){    "error": {        "code": "DATABASE_ERROR",        "message": "Database error occurred. Contact administrator.",        "details": [            {                "code": 904,                "message": "ORA-00904: \"A

0
Isuru Thilina
Hero (Employee)
2 months ago
NPGIFSJOMAII
Sidekick (Customer)
NPGIFSJOMAIISidekick (Customer)
asked in Finance (Financials)

BPA workflow for external invoices / posting proposal

We receive all our supplier invoices in the external supplier invoices view. In this view, today we spend a lot of time correcting any incorrect invoices that have not been successfully created. The same applies to invoices that have reached the posting proposal. Here, too, we pay a lot of time administrating things that normal system parameters does not cover. Does anyone have experience using BPA workflow in these views? Of course one part is to work with internal processes and our suppliers. But sometimes the default settings are not enough. Please share your experience!

0
NPGIFSJOMAII
Sidekick (Customer)
2 months ago
audreyS
Do Gooder (Partner)
audreySDo Gooder (Partner)
asked in Finance (Financials)

Copy inventory part unit cots

Hello,I would like to know how to remove the copy of the item cost when copying a stock item, as this is causing problems for my customer. on cloud version 23.1.2 Here is my article it came to put me the cost of the article I copied and I do not want Thanks

0
audreyS
Do Gooder (Partner)
3 months ago
L
Sidekick (Partner)
LakshmiMDSidekick (Partner)
asked in Finance (Financials)

How to allocate a budget automatically to a cost code

How to allocate a budget automatically to a cost code

0
L
Sidekick (Partner)
2 months ago
P
Do Gooder (Customer)
PatanmDo Gooder (Customer)
asked in Finance (Financials)

sales process in ifs 7.5 version

Hi Team, Pls explain me what the sale order process like from customer is to invoice the process which follows do’s and don’t for IFS ERP 7.5 version.  Regards,Patan M.

0
P
Do Gooder (Customer)
3 months ago
H
Do Gooder (Customer)
hzcmeisenberDo Gooder (Customer)
asked in Finance (Financials)

Aggregate Inventory Transactions per Period & the Inventory Value per Period report.

Need help understanding the Aggregate Inventory Transactions per Period & the Inventory Value per Period report.We are in Apps 10 Update 15, using Standard Costs for GL.  When running the process, Aggregate Inventory Transactions per Period & the Inventory Value per Period report, we have some products on the report with the Period End Unit Cost different than Cost Set 1 (Inventory value).  I would think this value would match.To investigate further, I zeroed out the inventory value of Cost Set 1 and reran the Aggregate Inventory Transactions per Period. I’m assuming that when I run the Inventory Value per Period report, the part should have a unit cost of zero, this is not the case, it’s off by 0.14. How do we fix this issue.

0
H
Do Gooder (Customer)
3 months ago
L
Do Gooder (Partner)
LouisDo Gooder (Partner)
asked in Finance (Financials)

Interfaces standard setup

Hi all, Is there a list of all standard interfaces available in IFS please ? 

0
L
Do Gooder (Partner)
3 months ago
T
Do Gooder (Customer)
ThushiDo Gooder (Customer)
asked in Finance (Financials)

Multi Company Invoicing

Can someone give me material documents for multi company Invoicing and voucher entries process. I don't have access to material documents.

0
T
Do Gooder (Customer)
2 months ago
arebbeadle
Hero (Customer)
arebbeadleHero (Customer)
asked in Finance (Financials)

What does this error mean? "value error during totals initialisation"

Has anybidy seen this error before?  

0
arebbeadle
Hero (Customer)
3 months ago
B
Sidekick (Partner)
BRSASidekick (Partner)
asked in Finance (Financials)

Intrastat Net Invoice Price is before discount

HiWe do experience a problem in the Intrastat reporting, where the price is fetched from the invoice before discount is deducted. IFS help is saying that it is after discount. However, the invoice does carry the price of 375,65 and the discount must be deducted to have the correct unit price and total. How can this be solved? Regards Brian

0
B
Sidekick (Partner)
2 months ago
C
Do Gooder (Partner)
Carole.B.K4UDo Gooder (Partner)
asked in Finance (Financials)

automatically affect a posting Authorizer after invoice entry/integration

Hi everyoneIs there a way to automatically affect a posting Authorizer after invoice entry/integration?In my system lots of AP invoices have been entered through external invoices but the Authorizer Assigning Rule was not in place.I have created and activated the Authorizer Assigning Rule. Now on newly entered AP invoices I can see that the authorizer is automatically assigned.But what about existing AP before Authorizer Assigning Rule has been put in place? I have ran Update Authorization Status treatment but still no Authorizer assigned on my 1 400 invoices.Is there a way to avoid manual add of an Authorizer?

0
C
Do Gooder (Partner)
2 months ago
S
Sidekick (Employee)
Shamalaka PereraSidekick (Employee)
asked in Finance (Financials)

End user access to Server output path/ Oracle directory when creating Payment Order files via Background Job process

Hi all,We have an IFS Managed App10 customer and when creating Payment Order files via Background job process, it requires Server output path/ Oracle directory to be defined which are generally accessible to FTP Admin user only. Due to this end users (Finance users) are unable to obtain the file without the support from IT.It was proposed to setup IFS Connect Mailsender to share it with the users via a routing rule. Is this viable? are we able to obtain any steps/documentation on this?Also are there any suggestions of how similar customer's are generating this file for end users without the support from IT?Thank you for the help in advance.Best regards,Shamalaka Perera

0
S
Sidekick (Employee)
3 months ago
technice1
Do Gooder (Partner)
technice1Do Gooder (Partner)
asked in Finance (Financials)

Tax problem - down payment invoice

Hi Community-Team, did anybody of you had such a case? We have a customer who has 7% tax, but only on the lines. In the charges we have selected transport costs, and these are set as non-taxable, because there are never taxes on them. In the down payment invoice, however, the tax amount is calculated on the total (i.e. including the transport costs), although these are declared as non-taxable. This is certainly not correct. Thanks for you support and kind regards,Ralph

0
technice1
Do Gooder (Partner)
2 months ago
P
Hero (Employee)
Pawel Dworzynski
asked in Finance (Financials)

using Talend Open Studio for big JPK_KR files

We are unable to use workaround solution with big JPK_KR files. We applied all steps from provided document (to use Talend Open Studio for Data Integration), unfortunetly when we want to passthrou file ~15GB company 1100, year period 202306. Application getting error. (Java heap space). We was trying with different values of -Xmx parameter but without result. How can we use workaround solution with big files?

0
P
Hero (Employee)
3 months ago
I
Do Gooder (Customer)
IZMJFINNEYDo Gooder (Customer)
asked in Finance (Financials)

Cash Flow Exposure - Detail

Hi IFS Community, hope you can help!I have been able to run a Cash Flow Exposure report out of IFS, the PDF looks great and is summarized per row by Cash Flow Source e.g. inflows/ outflows → which include sub categorizes of those inflow/outflows e.g. customer orders or purchase orders.This is great and is a good, high level report. I assume it is produced from the resulting ‘Update Cashflow Analysis Snapshot’.However my question to you helpful people is → Is there any way to view the detail behind the high level ‘Cash Flow Exposure’ report ? i.e. can I see the data that was collected as part of the ‘Update Cashflow Analysis Snapshot’ ?Best regards,James 

0
I
Do Gooder (Customer)
2 months ago
S
Do Gooder (Partner)
SilvesterDo Gooder (Partner)
asked in Finance (Financials)

Sending multiple invoices

Hello,How is it possible to add multiple invoices in 1 E-mail in IFS10? From a customer Invoice it's possible to select the option “Send invoice...”, but in the Customer Invoices tab this option doesn't exist. It's desirable to have multiple original PDF files of the invoices in 1 E-mail, which can be send at the same time, not 1 e-mail per customer invoice. 

0
S
Do Gooder (Partner)
3 months ago
G
Do Gooder (Customer)
GDFMNICHOLSDo Gooder (Customer)
asked in Finance (Financials)

Billing Fee Questions

We have a third party customer (global_name) that has requested that we send all invoices to their processing firm and take out a 3% fee off of every invoice (including taxes). I am struggling to come up with a solution and have a few questions regarding this situation and billing.1. I know there are a lot of complex settings we have not used yet regarding billing with fees and adjustments. I was looking into Billing Configurable Financials. We don't have one set up, but was wondering if I could utilize this functionality for what I am trying to accomplish or something like this?2. I am not seeing a method to calculate a fee in a way that includes taxes. We use a Vertex API Integration to make a call and stick it onto special charges. Is there a way to calculate a fee that would include special charges, really just a way to calculate a fee based on the invoice total plus taxes?3. Is there a way to put a fee against a total invoice, instead of on each individual line?4. Is there a way t

0
G
Do Gooder (Customer)
3 months ago
B
Do Gooder (Customer)
bwolbhDo Gooder (Customer)
asked in Finance (Financials)

Aurena: Error while serializing contents message in Manage Supplier Invoice

Hi! I have a problem in Aurena, in Manage Supplier Invoice. When we try to create (or edit) posting line in the invoice, we get the error message “Error while serializing contents”. I do not get the same message when doing the same in IEE. We are using app10, update 13.It seems that this error comes when adding the account to the posting line. I do not get the same error if I add other code parts to posting line, for instance profit center or cost center, or amount. If I try to post the invoice in Invoices to Authorize I get another error message; “Server error. Sorry, there was an unexpected server error” Does anyone know how to solve this? 

0
B
Do Gooder (Customer)
2 months ago
S
Do Gooder (Customer)
SylvanDo Gooder (Customer)
asked in Finance (Financials)

Avalara Tax Codes on Sales Charges

We have two specific tax scenarios which I presume would be consistent amongst any customer using the Avalara service...so hopefully I’m not breaking new ground with this question.  We have ‘freight’ and ‘sales tax credit’ setup as Sales Charge Types in IFS.  But there is no way to assign an External Tax Parameter to a Sales Charge...I only see that for Sales Parts.  Without a mechanism to assign a tax code mapping, these charges then get passed to Avalara as taxable.  How are other customers addressing this?  Are you create these as sales parts and then adding them a lines on your orders?  Is there already way method to handle this that I am missing?

0
S
Do Gooder (Customer)
3 months ago
Z
Do Gooder (Customer)
ZSBDo Gooder (Customer)
asked in Finance (Financials)

Coordinator-based weighted discount lobby

I need help about of create a “Coordinator-based weighted discount lobby”. Is there anyone who did something like this? I need to group the data and calculate it. how can i write this code? 

0
Z
Do Gooder (Customer)
3 months ago
L
Do Gooder (Customer)
LRCFRAPOSODo Gooder (Customer)
asked in Finance (Financials)

Supply Chain Financing (SCF) Payment Solution

Does IFS Cloud have supply chain finance (SCF) payment solutions? We currently have JP Morgan and PrimeRevenue SCF solutions in place . Supplier invoices are uploaded to SCF portal, suppliers get paid early and when the invoice reaches maturity, we receive a funding report back with the invoices. Based on the funding report, we automatically process the payments in IFS.  Thank-you!

0
L
Do Gooder (Customer)
2 months ago
D
Do Gooder (Customer)
dhookDo Gooder (Customer)
asked in Finance (Financials)

Payment Order Review Recommendation

Wondering how users are reviewing/auditing the Payment Orders ?Old school was a stack of invoices attached to the ACH total page.In IFS I can see all invoices on Payment Order items,  but doesn’t appear to be any right mouse buttons to take you directly to the supplier invoice to look at the attached document (invoice)

0
D
Do Gooder (Customer)
3 months ago
Manulak
Hero (Customer)
ManulakHero (Customer)
asked in Finance (Financials)

Editing accounts Description field in Accounts window

When the current translation field is edited in the company attribute translation window for an account, the account description cannot be changed from the accounts window. This behavior can be observed in other windows too: tax codes window, customer invoice types, supplier invoice types.Is it possible somehow to change such descripotions in desired languages? There is a workaround. But it is not effective too in certain instances.Workaround is:  If the account description needs to be edited, use the company attribute translation window and change the relevant row with the language code.If more languages are used as the login language, then, add them to the ‘Company attribute translations’ window and edit the current translations of those as well. Issue with the suggested workaroundIf the user login from a language which is not defined in the company attribute translation window, then the old account number is shown. (If it’s a system defined account, then the system defined descripti

0
Manulak
Hero (Customer)
2 months ago
Manulak
Hero (Customer)
ManulakHero (Customer)
asked in Finance (Financials)

Editing "Accounts Description" field in Accounts window

When the current translation field is edited in the company attribute translation window for an account, the account description cannot be changed from the accounts window. This behavior can be observed in other windows too: tax codes window, customer invoice types, supplier invoice types.Is it possible somehow to change such descriptions in desired languages? There is a workaround. But it is not effective too in certain instances.Workaround is:  If the account description needs to be edited, use the company attribute translation window and change the relevant row with the language code.If more languages are used as the login language, then, add them to the ‘Company attribute translations’ window and edit the current translations of those as well. Issue with the suggested workaroundIf the user login from a language which is not defined in the company attribute translation window, then the old account number is shown. (If it’s a system defined account, then the system defined descriptio

0
Manulak
Hero (Customer)
2 months ago
D
Do Gooder (Partner)
DeelakaDo Gooder (Partner)
asked in Finance (Financials)

Printing BOEs

Hi,  Can these 2 questions be answered if anyone in aware please?Can we re print a printed BOE? Can we re pint a cashed BOE?Thank you

0
D
Do Gooder (Partner)
3 months ago

Badges

Show all badges
Terms & ConditionsCookie settings