HiThe error appears to be referring to the ‘Supplier for Purchase Part’, not the PO itself.The ‘Supplier for Purchase Part’ is site specific. Is the supplier on the PO set up as a supplier for each part on the PO for the new site?Hope this helps!
Hi @kvbeWe’ve been able to view the IC_ tables using quick reports without any problems. You don’t need the _TAB at the end of the name. If you still get permission problems, have you tried when you’re logged in as IFSAPP?I don’t know what the overall limit on attributes would be, hopefully someone else can help you with that.
I think you may need to define the Coach Name as a Read Only field rather than a persistent one. Then you can define the SQL or an expression to get the name of the coach.You don’t actually need to store the name, storing the ID will be enough so it’s ok to have the name as read only.Hope this helps!
Hi @jgraceI’m sorry, but I can’t see the screenshots, only the one associated with your last message.We have navigation to Inventory Part In Stock from a list in a lobby which is using a custom view, hence the slightly different names, but this also has a page parameter and the navigation works fine.The navigation link is defined slightly differently to yours as shown in your earlier screenshot, with no path element and no semi-colons: page/InventoryPartInStock/List?$filter=PartNo eq $[Part No] and Contract eq $[Contract] and ProjectId eq $[Project Id]We’re using 22R2 but the lobby was defined and worked in 21R2.
Hi @jgrace We have found that the name of the column being passed is case sensitive, so using your screenshots it should be $filter=PartNo eq $[PART_NO]
Sorry, this ended up being a silly question! In case it helps anyone else, create the entry from the dropdown and then edit it. If you use the ‘get expression’ option you can enter the Crystal Report layout and it works.
Hi @neethasoman I migrated the invoices using the External File Assistant in the end, and didn’t use a data migration job. I used the STDCIN2 template which worked fine. You can use the same approach for suppliers with the STDSIN2 template. This was in 21R2 but I guess the option will also be available in Apps 10.Hope this helps.
HiI believe the problem is the fixed value of SEQ_NO in the migration job. It needs to be set with EMPLOYEE_WORK_LOCATION_SEQ.NEXTVAL The above job works fine in 21R2, I haven’t tried it in 22R1.I hope this helps you.
Hi @Mathias Dahl Many thanks for your quick response.I hadn’t looked there and I should have done! I was using the wrong API to upload the file, I should have been using MediaLibraryAttachmentHandling.svc/MediaItemSet(ItemId=1013)/MediaObject with the appropriate headers for octet-stream.Thanks again for pointing me in the right direction!
Hi, we got this error when the currency ‘valid from’ date was after the transaction date. Just backdating the ‘valid from’ sorted the problem.
In case it helps anyone, I’ve updated the migration job to use the IC_ROW_NO column as the sequence, added to a start value :This is on 21R2.
Hi @GaSoGB Ah, good point. I’m using 21R2.
In case this is useful for anyone, I’ve used CUSTOMER_INFO_ADDRESS_API.Get_Next_Address_Id(customer_id, ‘’) successfully as the default value for the ADDRESS_ID column, where customer_id is the column name in the source view. A blank company id seems to work fine.
Hi ChristopheDid you ever find an answer to this? I am having a similar problem when trying to migrate employee information, such as Employee_Work_Location, where there is also a SEQ field.I wondered if there is an API call which would give the next sequence number (similar to that discussed under the “IFS Cloud 22R1: Data Migration Manager - Number series functions” query posted 2 days ago. The solution posted there seems to involve deployment steps under the Smart Data Manager rather than straight data migration jobs and I haven’t been able to find any other suggestions.Thanks!
Already have an account? Login
No account yet? Create an account
Enter your 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.