Paul,Great information, will pass this along to my team.Thanks again for all your expert help!!
We hope to upgrade to Apps10 in 2021 and are torn on which method will be best, as mentioned earlier each have there good and bad attributes.
We are still on Apps 8, so is this still the case, using “online mode"?You mentioned it had been 10 years since you used Crystal, so is Report Designer your preferred method for Report/Forms?
Thank you Paul,I had previously tested the use of a custom field on the Company for this Remit to information, but had not gone as far as adding the field to a form report, but will sure give it a try.Thanks again, always a great pleasure to work with you!!
Hello Paul,We actually use both Crystal Reports and Report Designer, have challenges with both :(So is the “pay remit to A” hard coded text on the form report or is there a holding place somewhere else on an IFS screen where this information can be entered/maintained for each company?
Hello Paul,So great to hear from you!!!Thank you for this information. Our challenge is that we want to use one Form Report Layout for all Companies, but each has their own payment Remit to information and up until now we have been forced to use hard code text for all this Remit to information, as we have not found a good place holder in IFS for this other than the use of Document Text Phrase. We have attempted to use Document Footer, but we have too much information, plus we are finding it hard to get the Document Footer added to Crystal Reports.
CONTRACT did not work, but replacing CONTRACT with SITE did workThe actual resolution was the following for Apps8:[&Site_api.Get_company('[@CUSTOMER_ORDER_CONF_REP\SITE]')]
Hello Jouni,Thank you for your suggestion.We are currently on Apps8 and it appears that for the CUSTOMER_ORDER_CONF_REP that SITE is not an option.I have tried several things, including select in this Expression 1 (above) without any success. I can get it to work for one company/one report layout, but then when I create another rule for a separate company/report layout it will not work. I would have thought that creating a report rule for Customer Order Confirmation would have been more straight forward especially since this is a standard report.We may have to just wait until the upgrade to Apps10 as it appears that SITE will be an option there.
I even tried setting the Report Rule to specify Company 7 as the Expression and still did not work
Print scene to show set upWith no other Report Rules for Customer Order Confirmation enabled Report Definition for Customer Order Confirmation detailsIntent with the Report Rule is to have the Prince US Crystal - Order.rpt be the default for Company 7, but Prince_UK is the one that keeps showing up. Prince_UK will be the default for another company.
Mukesh,I tried setting up a new Report Rule in our Apps 8 test environment exactly like your print screens above and have had no luck.
Yes, that is what we are finding too that they are empty, but would like to utilize the functionality to add various text on the forms, but just do not know where or how to identify the source or where to even add information in IFS to text.
Hello Mukesh,This information has been very helpful as now we know where to set up the Document Footer.Can you provide more detailed information about which of the ‘Text##’ (numbered 1-40) fields get populated when the footer document is used and also which table or view these numbered texts appear?Thank you and Best Regards,Renea Kurfman
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.