Finance (Financials)

Hi, We use the Project module in IFS. When we have a Project towards customer X that has a Paying Customer Y (set on customer tab Project Report Parameters) and invoice Project Transactions, the Project Invoice is created on customer Y. So far, so good.Then we have two different addresses on the invoice, the Document Address and Delivery Address. My problem is that both these can only be fetched from the Paying Customer.We have multiple scenarios where we would like the Document Address to be from the Paying Customer, but the Delivery Address from the Project Customer.To get it right on invoices, we right now need to add all Delivery Addresses on the Paying Customer, which is messy in data management perspective. We run IFS 10 UPD 6, but what I can see from future releases this is not going to be fixed.Anyone with similar approach? Would like to know IFS thoughts about this…? This is not a problem in Customer Invoice where you have different options, which feels more developed than the

The Delivery Type in Line Information needs to be sent in xml. Which Tag of receiveEinvoiceLine is mapped to this field. Can custom filed in IFS be populated using this webservice. If yes, then please suggest the way of doing that. There are two methods in this web service. What is the purpose of the highlighted two    

Hello,I hope you can help me with your experiences.We would like to create more than one correction invoices, linked to one Customer order. (this credit notes are linked to monthly Sales of customer and some additional promotional activities, which will be financed by us.Is there any solution how we could create such Credit notes?Thank  you in advance for any suggestion.

Hi All I wonder if anyone has experienced when creating a payment proposal in 7.5 for a particular supplier which has postedauth invoices that are within the date range that no invoices display. It will allow you to add the invoices manually on the proposal? The supplier has current default bank details and no block for payment is ticked. The system is very old and we keep having these unexplained instances happen but I wanted to check that I was not missing anything obvious or whether anyone else had experienced it. Many thanksSheila

Some of our suppliers require payments in advance, therefore we create advance invoices for these down payments. I haven’t been able to find a report that will show me the open advance invoices. By open advance invoices, I mean those that have been paid, but have not yet been received/applied to a final invoice (meaning they’re still sitting in a prepaid account). Does anyone know of a report or window in IFS that would show this information. Thank you!

Wondering how to share General Ledger data to the rest of my organization through Business Reporter department/cost center variance analysis reports yet still maintain financial confidentiality. Is there a way to give users “access” to the general ledger but only give them viewer access to there specific code part, which is out code part B?Right now in the BR variance analysis reports no data shows up for Department Managers because they do not have General Ledger rights, again for confidential reasons… 

I am accustomed to creating tax reports using tax codes.  I created a tax structure to test the report function but the tax structure tab is not an option.  Am I missing a base setup item?  The company setup is on Address and the customer has the tax structure listed.  Thank you!

Has anyone used the Q Voucher for tax clearance and then the supplier payment option in a currency other than POL? Thank you!

I have a project set up that has related work activities.  Note that this activity field is a custom field.  When I want to search for an activity to attach to this particular project, the search brings up every activity in the database, for “all” projects.  Is there a way to customize this activity field or the Search to only populate the activities for the project I have assigned in the line?Just looking for a way to possibly speed up the search.

Hello I would like to check how the AR/AP netting functionality can be applied for intercompany netting.Scenario: Companies with in same group and the same instance of IFS, trade with each other and generate intercompany balances(AP in one company will be AR in another company).For the current netting functionality to be used, both AP and AR balance should be in the same company.Is there a way to net and close these AP and AR balances in different companies instead of making the remittance. ThankYou.

We use transaction based parallel currency where accounting currency is in GBP and parallel currency is in USD. Currency rates for both accounting and parallel currency are updated monthly. In this scenario, transaction and accounting currency are the same (GBP). When posting receipt of goods in Month1, Inventory is debited and GRNI is credited.  In Month2, the supplier invoice debits GRNI and credits AP, however, the GRNI amount in parallel currency is different due to a new currency rate, thus the amount in the GRNI account is not fully reversed in parallel currency.  What is the recommended solution to manage these balances when this can potentially affect thousands of transactions?  A gross month-end adjustment? There is concern this creates another set of books to reconcile every month, adding more work for the users.

We are implementing APPS10 and have an issue when Shipping Orders.There’s an inconsistency in the invoices that are generated.Some create a regular invoice and then others create collective invoices.We’ve checked the setup on the customers and on the Order tab, Invoice Type the default for all is set to Normal Invoice.Has anyone come across this issue before?ThanksAlan

Could use some help creating an event that will automatically release customer orders where ‘OBJSTATE = 'CreditBlocked' for specific company or site We have a situation where credit control is handled separately for certain companies within our IFS setup and need to switch off the credit checking for customer orders created for specific companies (We could also do at site level).I am thinking that an event could be fired that ran the 'Customer_Order_API.Start_Release_credit_Blocked' procedure where company = X but not quite sure how to handle?The problem I have is that we have a shared customer base so cant just use payment terms, or switch it off at customer level.

How can I change the forbidden character "&" in SEPA payment (XML via IFS Connect) when generating XML? German customers very often have the sign "&" in their names and this sign is prohibited in the banking specifications of SEPA ISO20022. The names of the clients cannot be changed on the system.

Does anyone know what it is that determines whether or not you see a document preview in top right of Instant Authorization screen?   Many thanks!

On APPS10 we now have the process set up for e-mailing Customer Order invoices via the Customer reference field Struggling to see where we can get an instant invoice to pull through the same details to allow us to send these direct via e-mail?

Where in IFS do you enter the companies GST tax registration number  (Canada) in order that this is printed on the shipping documents?ThanksAlan 

Hello,  In v10 UPD 8 (or even earlier) did anyone came across the following scenario:  A Customer Order has two or more tax lines The invoice payment posting creates two or more discount lines?Also, not sure how it is calculating when splitting.  

Navigation :Financials\Supplier Invoice\Invoice Workflow Basic Data\Invoice Posting Authorizer GroupsFinancials\Supplier Invoice\Posting Proposals For our invoice authorization, we are using Invoice Posting Authorizer Groups linked to our organisations. Those groups can move regularly due to new started, leavers or people changing organizations.Unfortunately, those changes don’t get reproduced automatically in the Posting Proposal/Authorize tab/View Authorizers Group Members. This creates problems as the modified users cannot access the invoices although they should now be allowed. Is there a way in IFS to deal with that problem or does it need a new program to be developped ? Thank you and Kind Regards, Anne-Sophie

/Tax Template Field Control / S089 is missing template field “OUTPUTVATEU” as a Field to select.  But OUTPUTVATEU is within Tax Template Field Control Basic.  Could you advise what might be causing this?

Dear all,Is it possible to recalculate the due date of a customer invoice when it is printed?The due date of an invoice is based on the payment that attached to the customer.When a customer has a payment term that sets the due date to for example 30 days in the future the due date will be set on 31-8 when I create the invoice on 01-08.If I don’t print it that day but for example on 05-08 the due date stays on 31-08.Due to the agreement with the customer the due date must also be set to days after 05-08So 04-09 must be the new due date.How can that be done?

When using column chooser on order lines in the customer order tab I mistakingly deleted all columns. When I right click now, the column chooser option is disabled.   How do I restore the column chooser?   Thanks.

Hi, Not sure if this is the right group to ask this question, but I am looking for a mapping between the tables for reports and their respective rows and columns and the data in the ifsapp schema.These are the tables I have referred:Row_templaterow_columnreport_templatereport_column_layoutreport_row_layoutreport_selectionreport_column_templatereport_column_template_layoutrow_columnrow_template 

Can anyone advise on where we can extract the detail for the EC Sales Listing that needs to be uploaded in the UK monthly?  

Hello,I want to find the connection between these tables. Could someone guide me to get the relation between these tables?what type of data should they contain?the template_id field exists in both tables, but the distinct counts do not match.Am I missing something here?