@TecChidaM May I ask the reason for this requirement?Are there any particular authorization steps per supplier?
@Aus S I think you can request an excel layout for the disposal report with our consulting organization.Following you see a screenshot of the report definitions of our latest release IFS Cloud.Report Definition page, IFS Cloud You can retrieve your result key from the report archive. Search for the report title “Year Disposal Report”.Again a screenshot out of our latest release IFS Cloud.Report Archive page, IFS CloudTo get the details with a quick report I think you have to SELECT * FROM YEAR_DISPOSAL_REP WHERE RESULT_KEY = [your result key].Another way would be to use the IFS Business Analytics client (APP10) or IFS Business Reporter client (IFS Cloud) if you need a specific format.Did I cover your question in the right depth?
@gcraig22 Can you please provide a screenshot of your external file template details? There you apply your Decimal Symbol and your text separator. This would be the first check if the decimal symbol in your external file template details matches the ones in your file. The difference between Column No. and Destination Column is the following.The Column No. determines the order in which your columns should be arranged in your file.The Destination Column is the data base column in the underlying table.
@SaraCrank , yes on the customer under tab credit management.
Hi @SaraCrank, with regard to the credit management topic, I suggest to apply a corporate credit relationship between your customer order customer and invoice customer. With this functionality you are able to control against which credit limit the checks will be made.
Hi @ELSMINHAJ, maybe it is due to missing permissions in finance?Check if your user has been applied to the company for which you want to order the trial balance reports. (path: Accounting Rules > User Related Data > Users per Company) Check if your user is part of the finance user group (very often AC) (path: Accounting Rules > User Related Data > Users per User Group) If not you should add your user to it. Check if you have added the user group to the accounting periods under User Groups per Period (path: Accounting Rules > User Related Data > User Groups per Period) If not add the user group to the corresponding periods. Check if you have applied the necessary permissions through the permission set for your users to be able to order the report.I hope this is helpful.
Hi @nimesh, Did you check if the company on the work order is the same company where you are registering and matching the invoice?Maybe this causes the error message. There is a setup parameter in the company basic date under tab Invoice and sub-tab PO Matching called Company on PO Line(s) not Equal to Company on Invoice. If the parameter is set to “Only Match PO line(s) with Company Correspondence” the system will throw the error message in case of any deviance.
Hi @TimJoaojS, it seems that the code string from the pre-posting will be fetched for the first screen but not the distribution. The distribution will be identified as NON INV. NO PRE-POST. As a workaround you can apply the account in the pre-posting on the purchase requisition line and the remaining code string information on which the amount should be distributed in the distribution part on the purchase requisition line.At least you will get all the amounts on an account.May I ask you what you are doing with these information? Will you create a report out of it? Best regardsBen
Hi @MonaL, the calculated field serves two purposes.First one: Before entering and approving any transactions you can compare the calculated balance with the actual opening balance which is coming from your bank statement.If the calculated balance is not equal to the opening balance from your bank statement it shows that either some bank statements have not been registered and approved through mixed payment or some postings have not been made through mixed payment but on the balance sheet accounts. Second one: After entering and approving the transactions the approved transactions will be added to the calculated opening balance. If your opening balance was correct the calculated balance plus summary of all included (approved) transactions should be equal to the actual closing balance.This gives you the possibility to recognize any missing or additional transaction amounts if the calculated balance is not equal to the closing. In your case there is a huge difference about 893,265.10 bet
Hi @MonaL ,here are some explanations. Hope these help.Best regardsBen Calculated:This field shows the cash account balance in mixed payment currency( i.e. the currency specified in Mixed Payment/General tab). It is recalculated as the opening balance on the payment date using the currency rate specified in the Mixed Payment/General tab plus summary of all included transactions.This is primarily intended for reconciling actual opening balance to the statement of account from the payment institution. For example, if a statement of account has been mislaid, the calculated balance will not match the actual opening balance. Actual Opening:The opening balance of the cash account as per the statement of account from the payment institute. This is entered manually and in mixed payment currency (i.e. the currency specified in the Mixed Payment/General tab). If no value is entered, the system automatically calculates and displays the opening balance of the cash account after payment approval.
Hi VALRHONDAVEE,I do not have a solution for your request but would propose an alternative where you can create your balance sheet directly in excel and are a lot more flexible with the report layout.The alternative I suggesting is IFS Business Analytics (APP9) - from APP10 on called Business Reporter.IFS Business Analytics is integrated with Microsoft Excel and extends Excel from a desktop productivity tool to a more full-fledged, enterprise scale client for analytical reporting and planning. The report design is more intuitive compared to the report generator and the data and security setup are coming from IFS Applications, meaning no additional work for security or data building necessary.Here an example of a Profit and Loss report to show how flexible you are regarding the layout.Best regardsBenReport based on information sources General Ledger Balance and General Ledger Period Budget.
Hi Helene800481,as another workaround you could use the instant invoice (Financials > Customer Invoice > Instant Invoice).Here it is still possible to modify the invoice in preliminary state.Furthermore you can use the template functionality to potentially save some time for entering the invoice if there are any recurring patterns like same customer with the same code string.Best regardsBen
Hi @johnw66, Yes, you can use multiple information sources within one report (Excel sheet) if you are using common dimensions.A common dimension is a dimension which exists in both information sources. For instance the dimension Company is part of many information sources and can be called a common dimension.That means you can use the dimension item company togehter with other measure items of e.g. customer invoice, supplier invoice, etc.As soon as you are using a dimension which not exists in the information sources you want to connect you will get an error.There can also be the case that you have a light item in one information source which is a dimension item in another information source. For instance the light item Identity in information source gl transcation and customer no in dimension customer of information source customer invoice. In this case you cannot connect them directly in the design and use only one repeater. Here you need to create and output for information source A
Hello Frank, The server that was hosting the PBI reports was moved to the Eindhoven office ( since the office in Utrect closed last week).Due to this the environment is not online at the moment.A ticket has been raised with CoS to start the environment again. Best regardsBen
Hello Frank, I asked the responsible team to look why the referenced environment is not available.They will look into that immediately. Best regardsBen
You need to create an open balance snap shot first. In order to do that you need a history category.Aurena:Open page “Customer Open Balances History Category” Path: Financials>>Payment Basic Data>>General Payment>>Customer Open Balances History Category Create a new record by using the plus button in the header frame. Define your individual Id. Save. Create a new record in the lower frame called “Open Balances History Companies” Apply one or more company ids which should be connected to the corresponding history id. After you saved the records open window “Customer Open Balance History” Path: Financials>>Accounts Receivable>>AR Analysis>>Customer Open Balance History Select you currently created history category. Create a new record by clicking on the plus button. Select a date as the cut-off date. Save. Use the command button on the created record and choose “Details” from the context menu. You can now see the open balances with reference to your ap
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
