Replies posted by richardwoods

33 Replies

HELP URGENT - Error Details-904 view code

this tends to happen when a field isnt present on all views, for example… Register Arrivals has been adapted to Source_ref1, Source_ref2, Source_ref3, Source_ref4 etc whereas the custom fields map to the LU PurchaseOrderLine where its still order_no, line_no etc… so if you have a custom field which uses order_no it will work but only when you try to deploy to a view which have these columns… Richard Woods

5 months ago

bdoucetteHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to fix IFS Cloud Crystal report error

normally its an access issue, check permission sets, if possible use the IFSPRINT to run the report in crystal, you’ll get a more meaningful error message or at least be able to disregard that.. I’m assuming other crystal reports are working? Richhttps://www.linkedin.com/in/erppm/

7 months ago

MickDSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

No PDF Report returned from Crystal Web Services

My guess would be permission issues as you’re using an RPT file which the web service can find… have you tried running the report as IFSPRINT within crystal reports to make sure there isn’t a view or API not yet granted?

3 years ago

RajithSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Simple Migration Tool.xlsm - Error - Could not unlock memory location. Copy aborted.

Its the VBA code, basically its kinda poorly written and I’ve made a few amendments from time to time… firstly and most easy is the columns and rows… it assumes all columns are full so write a little code which finds the last column and then use this as a reference throughout the code… but its an Excel VBA issue

3 years ago

Amila SamarasingheSuperhero (Partner)

asked in Document Management (DocMan)

Uploading larger files will give an error "Object reference not set to an instance of an object"

Side question but are these “Large” files being stored in the Oracle or an FTP site? The DB storage really only benefits documents or at least files with recognised text, photos or videos etc are best stored outside of the db to prevent issues with db size which can occur…

3 years ago

clint1028Do Gooder (Customer)

asked in Products (Manufacturing, Products, Engineering)

Products and Models ownership.

Which version are you using as if you’re able to create a custom field this really is rather simple… if not its a little more tricky…

4 years ago

RutJWhalenSuperhero (Partner)

asked in Products (Manufacturing, Products, Engineering)

Incident Distribution List Email Query

I believe there is a standard event called “INCIDENT_CASE_CREATED_STATUS”, this you will need to create some actions from…. if you need a hand give a holler...

3 years ago

DIPAKPATELSidekick (Customer)

asked in HCM (Human Capital Management, Payroll)

E-mailing Reports using Event Action - Not Working for Delivery Note for Customer Order

can you send other emails / reports or is it just this type of report? Is the report being generated (PDF Archive)???

4 years ago

Jeana BarcelonaDo Gooder (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Receiving Multiple Inventory Parts from Buying 1 Purchase Part

which version are you running?

2 years ago

hhy38Hero (Customer)

asked in HCM (Human Capital Management, Payroll)

Error: ORA-00904 Lobby cant get information with API

we’ve all been there, a missed comma or full stop and end up head scratching at a fault right in front of you… something that might be of use, I try and create the lobbys from IAL’s… gives you the option to repeat the same data or schedule if its from a large data source… also, makes granting a lot easier… Just a friendly suggestion.

4 years ago

Damitha Peiris

published in Products (Manufacturing, Products, Engineering)

Tip: Could you disable the Shop Order Re-Open?

you could use a custom event partnered with a permission set, in that, when the event was triggered it checked against a user to make sure they had “REOPEN_SHOP_ORDER” this way, you can grant a very basic functional role to a limited number of users, leaving the majority unable to perform the action.

4863

4 years ago

jbernardoHero (Partner)

asked in Service (Touch Apps, MWO, MRO)

survey output as attachment

with the correct event coding (would be a little length to post) you could trigger a report to run, compiling the information into a PDF, this PDF could then either be attached to the original survey for future manual emailing or emailed automatically to the responsible person when the survey is closed or passes its closing date… just a thought if you’d like to go down this route...

3 years ago

lgerstnerDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Formatting in reports

There’s probably a much better solution than this… but this is the best I could come up with: IFS: Crystal Reports: Create a function cut down all of the tabs to just one (You may need to add more to cover all bases - I have only included up to 8 tabs in a row) replace(replace(replace(replace(replace(replace({PURCHASE_ORDER_LINE_NOPART_A.DESCRIPTION},chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9)),chr(9)+chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9)),chr(9)+chr(9)+chr(9)+chr(9)+chr(9),chr(9)),chr(9)+chr(9)+chr(9)+chr(9),chr(9)),chr(9)+chr(9)+chr(9),chr(9)),chr(9)+chr(9),chr(9)) Add text object to the report Drag the function into the text box and highlight the function inside the text box RMB - Text formatting… Set a tab stop position (you may need to adjust this value) And….. tada! Regards, Callum Would go with this answer, remove all but one tab then you know where you stand and can format the field accordingly with repeated accuracy

4 years ago

shewaDo Gooder

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

WHERE clause in Custom Field

you could try permission set filters but this could cause issues elsewhere on the system...

4 years ago

eqbstalSuperhero (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Remove companies from database

Removing a company from a Live environment (way to much of a pain for a non-permanent), first things first… has any one transacted in that company, if the answer is yes give up now, remove all access to the company and its associated sites and place two fingers in your ears when asked to remove it, you’ll pretty much spend the rest of time tracking down, trying to remove (as you cant reverse) traces this company has left on your IFS. Trust me, its not really an option unless you through a lot of money at it and get IFS involved as you’ll have to remove (eg delete) transactions from tables which will most likely invalidate any warranty you have...

9 months ago

Damitha Peiris

published in Products (Manufacturing, Products, Engineering)

Tip: Could you disable the Shop Order Re-Open?

I maybe a little off the mark here, but if someone normally says “the database should allow this and that, but only when this and that are true” it tends to lend itself to an event / action combo… the only risk you may have here is with mutating table as I’m guessing some of your criteria maybe stored on the same table??

4863

4 years ago

PROAHARSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Performance issues and background jobs (default queue)

@PROAHAR I noticed you said that the custom job was taking longer than normal to process… could you post any details as to this custom job as although creating alternative queues etc etc will stop this issue from impacting other jobs, it doesn't resolve the jobs execution time so lets also have a look at the cause…

3 years ago

svrmhuebnerDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Document Class LU control

When coding an event I hate it when technical people “hard code” variables, yes in the short term its easier but long term just means if processes adapt its a pain in the proverbial… I would create a custom view, one column referencing the possibly LU’s, another detailing (and this will depend on your processes) either which document class can be attached or which that cant, based on which option gives fewer lines, for example… If you said there was only one Document Class that wasnt permitted against a single LU, it would make more sense for this event to work on an exclusion list, if on the other hand you said the opposite I would invert it for an inclusion list. The event itself just then needs to work on the basis of if the combination of document class vs LU is allowed, blocking the transaction if it isnt. Does that make sense??

4 years ago

JurHero

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Post Deferred Call as other user

so… top of my head maybe a scheduled job could accomplish this, depending on how often you create parts and how quickly you need them to be created on the inter-sites or using IFS migrations in-house replication functionality… Which version of IFS are you using, might be able to patch something together for you

4 years ago

hwilkieDo Gooder (Customer)

asked in HCM (Human Capital Management, Payroll)

Anywhere in IFS to record engineers tools?

Ah, there is the problem, think its in IFS 9 (path maybe slightly different) but its definitely in 10 If you do a search for “Equipment” you’ll see it if you have it…

3 years ago

DevBobSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

SQL GroupBy YYYYMM over IAL fails with '(full) year must be netween -4713 and +9999 and not be 0'

Glad to have helped. Anything else you know where I am

4 years ago

hwilkieDo Gooder (Customer)

asked in HCM (Human Capital Management, Payroll)

Anywhere in IFS to record engineers tools?

HR has got an employee equipment card section where Tools can be assigned, the tools listed here are those in the “Tools and Equipment” section of service maintenance and can therefore have calibration tasks etc assigned to them

3 years ago

DevBobSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

SQL GroupBy YYYYMM over IAL fails with '(full) year must be netween -4713 and +9999 and not be 0'

I would try something like this instead… these two fields will bring back the very beginning of the year and the very last seecond of the year select trunc(sysdate, 'YEAR') begin_year, add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60 last_second_year from dual so… and OP_START_DATE between trunc(sysdate, 'YEAR') and add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60

4 years ago

RutJWhalenSuperhero (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick Report (Crystal Report) is not displaying any data

Try giving company and site access to the system default user accounts…

4 years ago

bhaktiutamaSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Any DDMRP Demand Driven MRP implemented ?

Perhaps ask IFS if they know of a reference site that could help you??

4 years ago

Page 1 / 2

Replies posted by richardwoods

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded