Solved

11569 Topics

K.mitchDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Custom Field not Available to use in Lobby SQL

I have a custom field on the Inventory Transactions History Screen which I want to use as Criteria within a lobby datasource. (Product Family=’1000’) however I am getting error of Invalid Identifier. When I select * in SQL Developer or in the SQL query tool this custom field also is not available. What would be the best way for the custom field to effectively show in the database so I can use the needed criteria? Many Thanks Kirsten

4153

2 years ago

dlevanDo Gooder (Customer)

asked in Finance (Financials)

Correcting matched receipts for invoices that are already paid

Hi, I am looking to untangle a mess that was created as a result of incorrectly matching PO receipts to the wrong invoice numbers. It has had several downstream negative effects. The issue is the the invoices are all in paid status. Is there a process to unwind the incorrect matching and re-match things correctly? Thank you!

4362

2 years ago

vs.sukeshDo Gooder

asked in Distribution (CRM, Commerce)

Delete Inventory Location

Hi, Is it allowed to delete empty Inventory locations, which had some transactions earlier?

8135

2 years ago

matthunterDo Gooder (Customer)

asked in Products (Manufacturing, Products, Engineering)

Custom Field Question

Gosh, I know I’m like the 5th person to ask something similar to this but I was hoping for an IFS guru to help me out there.I’m developing a custom field with a case clause but am getting the error“Error in validation of Custom Attribute. The column line_item_no referred to in table t is not an approved persistent Custom Attribute.”I feel like I’m 95% of the way there with this logic. Can anyone help me get the last 5%?Arguments: v.order_no,v.line_no,v.rel_no,v.line_item_noSELECT CASEWHEN (real_ship_date-promised_delivery_date+4) > 0THEN 'LATE'WHEN (real_ship_date-promised_delivery_date+4) <= 0THEN 'ON TIME'ELSE 'ON TIME'END CASEFROM customer_order_lineWHERE order_no= :order_noAND line_no = :line_noAND rel_no = :rel_noAND line_item_no = :line_item_no

7952

2 years ago

philipv

asked in Distribution (CRM, Commerce)

Customer Order sequence generation

Hi! I’m trying to create a new Coordinator Groups for customer order sequence generation.I entered Customer Order No to 1000 but when creating a customer order its starting at 5262658 I’ve checked that there is no Customer orders in this Group. Using IFS9.Am i doing something wrong?

71811

2 years ago

bear7364Do Gooder (Customer)

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

Custom field to show the sum of 2 existing fields

Hi all. I need to create a read only custom field in the Remote Warehouse Parts Planning screen that shows the result of On Hand Qty - Refill Point Qty. Is this possible on this screen ?

2512

2 years ago

Susan W.Do Gooder

asked in Distribution (CRM, Commerce)

Customer Agreement using both Price per Part and Price per Sales Group

I would like to execute a customer agreement with both a deal per part at a set unit price, and a deal per sales group for a percentage discount. Trouble is the part is a member of the group, and I don’t want the group’s %discount to apply to that part’s unit price. Aside from entering all the other group members individually, is there any setting or other structure I can use to fetch only deal per part (net price) for this one SKU, and deal per sales group (% discount off) for the other SKUs in the group. Example: SKU1 net price $500, SKUGroup discount 20%; order line applies 20% discount to $500 and returns $400.

2702

2 years ago

sinybDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Sorting of Joblist

Hi,We have just upgraded from FSM5, to FSM6. In the Joblist screen in the previous mobile app, there were a OOTB button in the bottom right corner, where you could choose what you wanted to sort the tasks by, for instance created_dttm, severity etc. In the mobile app for FSM6, I see that you can create these on your own. However, I cannot find anything related to this in the documentation, so I wonder what is the best way to solve this?And, what is the value that this list is sorted by OOTB?

862

2 years ago

MervanSidekick

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

closing the quick print

Hi,from which permission set can I remove the quick print option ? Best regards, Mervan

952

2 years ago

horst00cSidekick (Customer)

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

Availablilty of Documentation in other languages

When will there be online and field help documentation in other languages than english? Specifically in my case the interest in German but surely for other community members their respective native language? Cloud 21R1

1816

2 years ago

Manavi WeerarathneDo Gooder (Partner)

asked in Finance (Financials)

Break Received not Invoice into two accounts

Hi,My customer (A tea export company) would like to separate tea related transactions from other transactions in the received not invoice account. Is it possible? Please give suggestions to set posting controls. Regards,Pabasara

985

2 years ago

Darius GafronHero (Partner)

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

21R1 - Online Documentation in German

Hi community, does anyone know if the online documentation is available in German language? I´m using 21R1.3 and when I call the online doc I get the English version: Thanks and best regards,Darius

1853

2 years ago

AstewartDo Gooder (Customer)

asked in Upgrades & Updates

Remove Aurena From Landing Page - IFS10

We are upgrading to IFS10 and will only be using the IEE. Our people keep trying to use the Aurena option and we would like to remove it from the landing page. Is that possible?

1221

2 years ago

sordillo316Sidekick (Customer)

asked in Alliance

BOM updates on existing Product IDs & Installed Items

We have a few questions related to BOM & Product setup (running Astea v14.5) When an existing customer machine (installed item) is upgraded/retrofitted in the field, the installed item is updated to reflect most of these changes and the Product ID remains the same. If we have a new BOM for the upgraded components, what options are there to have this pulled into the installed item? When we manufacture and release a “version 2” of an existing product ID, is there a way to have a separate BOM -- one for version 1, and another for version 2 -- on the same product ID? We have found there is a section for “version” information on the Product ID but have determined any related functionality. Does this setting have any additional functionality? Thank you in advance for your help.

1092

2 years ago

MGamage

asked in Assets (Asset Management)

At what point does the current position of the serial object change from 'Under Transportation' to In Facility or Inventory?

Even though the customer order is Delivered and Invoiced, the serial object still says Under Transportation. How do we change this? Thank you in advance

2322

2 years ago

bytsophanHero (Partner)

asked in Finance (Financials)

cannot change the authorizer in window invoice to authorize

HiI have an wierd behavior in the system. When I go to posting proposal i see the option to change the authorizer in the supplier invoice. If I go to the window “invoice to authorize”, i only have these two options available. I dont know what is the cause of this variation. Does anyone have an Idea.I have set myself to an aknowledger and removed the admin user and super acess user. After this I let the someone change the Approval Task to my user. Best RegardsSophal

1984

2 years ago

MicLabElmoDo Gooder (Partner)

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

OAuth2 authentication and projections access failing

I am able to generate and use a token with Postman but I cannot replicate that behavior in .NET code.1. In Postman, I first generate a new token. 2. Authentication worked so I can proceed. 3. I copy the id_token in the clipboard and click on the 'Use Token' button. 4. Instead of using the access-token directly, I paste the id_token in the token box of a get request and send it. 5. If I do not execute step 4, the rest of the procedure does not work.6. After that step, I can query data from projections or metadata. When replicating this programmatically, I tried many different variations without success (one of my multiple attempts in image below). How can this kind of authentication be done?

3222

2 years ago

emilyk8rDo Gooder (Customer)

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

+/- Quantity variance on Purchase Order

Is there a way to allow a PO to accept a +/- variance to the ordered quantity? For example - we order 100 boxes, but supplier may have slight over-run, but we accept up to 10% over/under. Can we set the PO up to allow that automatically for receipts?

5583

2 years ago

AndryisSidekick (Partner)

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

Change from EE to AURENA

Some basic functions working on EE doesn’t work correctly on AURENA. For example, I can put an ending date of a BT on EE but not on AURENA. In such case, how do I solve the issue?Thank you

1054

2 years ago

MarianneSidekick (Customer)

asked in Document Management (DocMan)

Create new revision without view copy

How can we avoid creating a new Document Revision based on a previous Document Revision without a copy of the view copy. We only would like a copy of the original file and not the view copy file. Users forget to create a new view copy for the new document revision, and then we have a view copy which is a copy of the previous document revision and not a copy of the new original file.

2286

2 years ago

ctaylor56Hero (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Auto Load ARP Data from Scheduling Data

When using IFS Applications with PSO, all of your scheduling data is loaded into PSO with the LOAD. If you are using ARP as well, is there a way to have your scheduling data to automatically copy to ARP (Such as resources, resource types, etc...)?

2185

2 years ago

bytsophanHero (Partner)

asked in Finance (Financials)

IPD Tax Information

HiI try to figure out how this IPD tax information work. According to the help it is used when you enter a customer order with the supply code int purch dirsomehow i cannot make the system to fetch the taxcode from the IPD Tax information it always fetches the information from the supply country tab (see first printscreen). Did i forget something?

4053

2 years ago

Kavindu911Sidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

Scrap Reason on shop order operation

Is there an IFS overview or a db view to get the shop order operation scraped quantities with the entered scrap reason. ?Thank you

3194

2 years ago

roshangaSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

OP_CLOCKING & OP_MACHINE

Hi All, What are the replacements for back end tables OP_CLOCKING_TAB and OP_MACHINE_TAB in cloud? they are Operation Status Per Employee and Machine Codes screens in 7.5. But, i cannot see them in cloud altogether with components SHPEMP and SHPREP.What are the replacement pages for these in cloud 21R2?ThanksRoshanga

762

2 years ago

NarmadaHero (Employee)

asked in Finance (Financials)

The Wage Code "1" is used by 1 rows in another object (Time Reporting Association).

Hi,I’ve created new company based on existing company in customer test environment & I need to remove that due to incorrect data used.However it is not allowed me to remove the company saying that there are wage codes connected. Its get below error message when I going to delete the wage code.Kindly explain me the steps to be followed to clear up this error message.The Wage Code "10" is used by 1 rows in another object (Time Reporting Association).ThankyouBest RegardsNarmada

2822

2 years ago

Page 273 / 463

Solved

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded