Finance (Financials)

This will include the questions related to Financials.

  • 4,231 Topics
  • 11,690 Replies

4231 Topics

H
Do Gooder (Customer)
hketDo Gooder (Customer)
asked in Finance (Financials)

Error while printing final invoice for customer order with paid advance invoice

Hello, I have made an advance invoice for customer order and the advance is paid. When I try to make the final invoice for the order, I get this error message.We are running IFS APP 10 UPD 8. I read from another case “Error message during printing an instant invoice”, which also had something to do with advance invoice, that there might be a bug in UPD8 (151458). Is this a totally different case? Any solution? 

2
H
Do Gooder (Customer)
1 year ago
M
Sidekick (Partner)
MelTanyaSSidekick (Partner)
asked in Finance (Financials)

Update inventory transaction after change of price on PO

Hello, Whenever my customer receives a supplier invoice, before registering, she checks that the unit price on the purchase order is the same as invoice; if not the case, then they reopen the article line on PO to change price and close it again so that the right price gets mapped on the invoice. She prefers to proceed in this way rather than registering price difference on invoice. But when the arrival of PO was registered, it has been done with the initial price of PO (and not the updated one), so the inventory transaction showing a debit of M1 and credit of M10 are created with initial price and then transferred to accounting/ finance with a daily task; their status is “transferred”, code 3.How can i proceed with an update of these transactions on ARRIVAL event (M1 and M10) after having changed the price on PO line, so that finance gets updated too? Thank youTanya

5
G
Superhero (Partner)
1 year ago
N
Do Gooder (Customer)
nstacktkDo Gooder (Customer)
asked in Finance (Financials)

Customer Analysis - Invalid Table Name for Specific User

When a specific user tries to load customers on the customer analysis screen, they receive the error “Invalid Table Name. Failed executing query (ORA-00903: invalid table name)”.This issue only affects this user who has all the permissions that seem necessary and on a test database can access this fine.When I look at the query being ran that throws the error, for the user the table name “ledger_item_cu_det_qry_cfv” is missing. For any other user this table name is present in the query and they can load customers on this screen. Any ideas?

2
R
Hero (Customer)
1 year ago
H
Do Gooder (Partner)
hayley.cairnsDo Gooder (Partner)
asked in Finance (Financials)

Group Consolidation - Historical Consolidation Rates

Hi, I’m trying to setup the Historical Rate Consolidation to ensure that certain balances in the consolidation are retained at the historical rate. I have setup the Historical Rate Consolidation page for the accounts in question but when running the consolidation process I’m expecting posting controls GCP23 and GCP24 to be triggered to make the relevant adjustment, however  no vouchers are being created.What setup is required to ensure these posting controls are triggered on consolidation. Thanks!

1
ThushanWij
Do Gooder (Employee)
1 year ago
G
Hero
GayanDHero
asked in Finance (Financials)

Non-supplier payments

Hi All,I am wandering whether Non-Supplier Payments are supported with ISO20022 file format in App 10 or Cloud?ThanksGayan

1
G
Hero
1 year ago
P
Sidekick (Customer)
PriceWarrenSidekick (Customer)
asked in Finance (Financials)

Supplier check layout not printing correctly

We are on Apps10 UPD 16, using Aurena exclusively. We’re developing our supplier check layout, and having a lot of trouble getting it to print properly. What I mean is, when the layout prints to different printers, the margins, scaling, positions change, sometimes significantly. We are printing on blank check stock, which means MICR coding and everything else is printed, and must be in exactly the same position each time. We have checked printer drivers, reset printer settings, everything we can think of. What’s even more bizarre to me is if we preview the check, then print it to PDF 100% scaled, it again displays differently. The MICR could be off the bottom of the page, the fonts are way too big, etc. Has anyone else run into this, and what have you done to fix it? It’s the inconsistency between printers that is most troublesome, I don’t want a layout that only works on one printer, that’s a single point of failure and won’t scale to other locations.Appreciated.Warren

1
L
Do Gooder (Customer)
1 year ago
S
Sidekick
SwatiSidekick
asked in Finance (Financials)

Customer rebate -

Dear CommunityWe have customer rebates that they accrued as when customer is invoiced.My question is: when we receive customer claim ie (invoice from customer) this is posted  against the rebate agreement. but if would like further analysis ie when invoice is posted against rebate agreement how can make sure the invoice relates previous month or qtr, previous year - as some customer invoice monthly, quarterly or annually for their claim. so we can do view what this the balance accured balance for previous year and be able to run report. Any suggestion how this can be done? would be greatly appreciated. Many Thanks Swati 

0
S
Sidekick
1 year ago
S
Sidekick
SwatiSidekick
asked in Finance (Financials)

Posting control M180

Dear CommunityHappy New to you all.I have quick question on posting control M180 - can someone please whats the difference between M180 to posting control M120/121as the posting from M180 are currently getting posted to 41004 -Standard Cost Variance, just need to understand why, should this get posted to material usage variance 41001 ? Look forward in hearing from you. Thanking you in advanceKind regardsSwati

1
T
Superhero (Employee)
1 year ago
E
Do Gooder (Customer)
ECVPTOFTNERDo Gooder (Customer)
asked in Finance (Financials)

SAF-T Norway - using GroupingCategory RF-1167 and corresponding GroupingCodes

I find this question to have been posted earlier, but without a definite reply or a reference to a solution.  It is in reference to the SAF-T file and the use of GroupingCategory in conjunction with GroupingCodes instead of StandardAccountID as the mapping option. Background:We are based in Norway and need to comply with the Norwegian SAF-T regulation.  These regulations allows us to choose how we want to map our GL-accounts. However, the SAF-T file has to correspond to how we report taxes, and since we report taxes using schema RF-1167, we need to map our GL-accounts to these RF-1167 codes.  In other words, we cannot map our GL-accounts towards the Standard SAF-T accounts.  The Norwegian SAF-T Financial Data - technical description (see norwegian-saf-t-financial-data---technical-description.pdf (skatteetaten.no) pages 12-13 explains how this can be done by using the tags GroupingCategory (value = RF-1167) in conjunction with the corresponding set of codes in the GroupingCode tag.  The

0
E
Do Gooder (Customer)
1 year ago
R
Do Gooder (Partner)
RLGroenerDo Gooder (Partner)
asked in Finance (Financials)

Create correction Tax report.

Dear All,How can you make a Correction Tax Proposal? What does the correction Proposal Select? All transactions or only the transactions that are changed and later fetched  transaction via Fetch Tax ledger Info? Thanks in advance for your reaction.Regards Raymond

6
M
Sidekick (Partner)
1 year ago
B
Sidekick (Partner)
BRSASidekick (Partner)
asked in Finance (Financials)

Cost Center as logical Code Part in Define Code String

HiThere is an option in the Define Code string view to select Cost Center as logical Code Part.Can somebody explain the advantage and posibilities of using this functionality ?   

2
T
Superhero (Employee)
1 year ago
D
Do Gooder (Customer)
DKSSIDo Gooder (Customer)
asked in Finance (Financials)

Handling of customer bankruptcy

Hihow do you handle customer bankruptcy in IFS.When a customer files for bankruptcy I would like the system to:-provision the amount due-block the customer in the dunning system, so they don’t get dunned-exclude the customers from the customer age analysis etcas it can take year before the lawyer are finished with closing the bankruptcy case. Is there a function or a used process in IFS when customer bankruptcy happens.I know that there is a bad debt system but it doesn't seem to solve the issue or have I overlooked something. ThanksSøren

1
Ralph Gericke
Hero (Employee)
1 year ago
S
Hero (Employee)
Samuel JokinenHero (Employee)
asked in Finance (Financials)

Business planning - Currency rate type error

I have watched the IFS Business planning videos in academy and when trying to execute the planning rule for AR balances I get an error ‘’ The currency code GBP is not valid in the currency rate type 1 in company...’’I have checked that the GBP currency is valid in the currency type 1, and I have also updated the currency rates. Also, the same currency rates and type 1 is used for the business plan that I’m using. See attachments for more info.

2
S
Hero (Employee)
1 year ago
V
Do Gooder (Customer)
VALRHONDAVEEDo Gooder (Customer)
asked in Finance (Financials)

Non-supplier payments

Sometimes we need to write a check to a customer that doesn’t take their credits.  Currently we create a supplier & write a check that way.  Is there another way to write a check without having to add a supplier?Looking for answers for IFS9 & IFS10

5
T
Superhero (Employee)
7 months ago
C
Sidekick (Customer)
craryitSidekick (Customer)
asked in Finance (Financials)

GL Balance Analysis - Budget -> Planning

Hello, We went from 9 to 10 recently. One of our users used to see a budget amount, difference, diff.(%) on the GL Balance Analysis screen. As far as I can tell, the name has now changed to planning. The problem we are having is that it’s completely blank though. Any ideas on what’s going on?   

2
MikeArbon
Hero (Customer)
1 year ago
S
Do Gooder (Customer)
sandra.waudDo Gooder (Customer)
asked in Finance (Financials)

AP error when trying to finalize an invoice

Getting this error at Final Invoice Posting - any help would be appreciated

1
T
Superhero (Employee)
1 year ago
A
Do Gooder (Partner)
AlperenDo Gooder (Partner)
asked in Finance (Financials)

How can I do IFRS reporting?

Hello,We want to do IFRS reporting for the first time in our company.How can I use the Internal Ledger to do IFRS reporting? At what stage and activity can I use Parallel Currency?Is there a document about this?The general ledger we keep in the country and the ledger we keep for ifrs will be separate for now.However, if we provide sufficient conditions in the future, we will be able to make IFRS reporting within the country. Can we keep a single ledger by removing the distinction between general ledger and internal ledger in the future?Asking for IFS 10 Apps

8
A
Do Gooder (Partner)
2 months ago
K
Hero (Employee)
Kanishka MadushankaHero (Employee)
asked in Finance (Financials)

XML file with format pain.001

Is it possible to get a XML file with format pain.001 from customer version of IFS? they need supplier payments information in this file to send to the bank.

1
L
Sidekick (Partner)
1 month ago
S
Sidekick (Customer)
SMcLeesSidekick (Customer)
asked in Finance (Financials)

Secure folder - Windows 10

How can I set up a folder in windows 10 that can only be saved to direct from IFS (i.e can’t be changed after file is created)

3
cperdue
Hero (Partner)
1 year ago
A
Sidekick
AlanSSidekick
asked in Finance (Financials)

BACS to CHAPS Apps 10

In June 2021 our UK plant switched from the BACS system to CHAPS.Prior to the switch the UK would upload details of their supplier payment runs to the bank via a file upload.Since the switch they have not been able to do so - no file being created to upload to the bankWe were advised that there was no difference between the two systems and that the setup currently in place for Payment Format BACS and Payment Method BACS OUT should remain in place for suppliers being paid through BACS and that processing would continue as normal.  This is not the case as this has become a manual effort in terms of sending the payment information to the bank.If anyone in the community has come across a similar situation when using these two systems any information that you can provide in terms of adding/changing Payment  Formats and Payment Methods would be much appreciated. Thanks AS .

2
A
Sidekick
1 year ago
R
Do Gooder (Partner)
RLGroenerDo Gooder (Partner)
asked in Finance (Financials)

2 voucher related to same voucher source

Hello All, Can some explain the funciton of the field Mpccom_Accounting_id in the view: GEN_LED_VOUCHER_ROW_UNION_QRY. I have a situation where 2 different voucher_number which have the same voucher_type (MPR)have the same value in the Mpccom_Accounting_idOn voucher is created in Oktober 2022 and the otherone in November 2022.Is it normal that there duplicates in the field Mpccom_Accounting_id when vocuher number are different?How can that happen?How to solve that?Regards,Raymond

2
R
Do Gooder (Partner)
1 year ago
M
Do Gooder (Customer)
matthew_sutherland2891Do Gooder (Customer)
asked in Finance (Financials)

Automate deffered revenue posting

Hi there,Hopefully someone can help.I need to raise the invoice 15 days prior the start of each billing period. I have confirmed with my team that  that we do not future date the invoice and use the actual date that we issue but doing this will trigger posting to revenue then I will need to do manual entries monthly to reclass this as deferred income on the balance sheet.How can I automate this procedure to post revenue as deferred and then reclass the posting to the P&L on the 15th on the following month?

7
T
Superhero (Employee)
1 year ago
R
Do Gooder (Customer)
reimccabeDo Gooder (Customer)
asked in Finance (Financials)

Undoing write-off supplier invoice

Hello, we have a situation where our AP group entered some write-off supplier invoices in error.  Their practice is to enter manual invoices that net to 0 and they are in state PaidPosted in closed accounting periods.  They would now like to undo those invoices and enter new ones for payment.  I am aware of supplier payment rollbacks, but I’m assuming that method wouldn’t work with a 0 value invoice since no payment was generated.  Is it possible to undo these invoices and enable the receipts to be matched normally?  Also, is there a better method of doing write-offs?   Thanks.

2
R
Do Gooder (Customer)
1 year ago
A
Sidekick (Customer)
ArendSidekick (Customer)
asked in Finance (Financials)

Preliminary Invoices - prevent from authorization

Hi all, On IFS10, UPD9. We use Posting Proposals - and inherit authorizers from the PO. This also means, that authorizers could already be assigned to the Invoice, before the Invoice has been reviewed and Posted by the Accounts Payable team.  Now the team has asked us to prevent users from handling the Invoices, before the AP Team have Posted the Invoices. Is there anyone who has a smart solution or idea to prevent such invoices to be available for the users?We use a lobby to navigate to Posting Proposals window, so we can add this as a filter in the Lobby, but users can still just populate all records in Posting Proposals.  

1
eqbstal
Superhero (Partner)
1 year ago
M
Sidekick (Partner)
MonaLSidekick (Partner)
asked in Finance (Financials)

Lease accounting

Hi ThereCompliments of the season!can lease accounting in IFS APPS10 be used on the following conditions.• A lease contract over a period of example 10 years with an annual payment and not monthly payments • A lease contract of example 5 years with the lease installment paid in advance in the beginning of the contract." Thank YouMona

2
M
Sidekick (Partner)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings