Hi, I want to add a custom field to the Purchase Requisition Lines view, which is based on two criteria to make the search unique.I've made a Read Only Custom Field with one of the key variables, but make it work for each line I need to add a second variable to my select statement. Problem is: I get an error when I want to finish creating the Custom Field.This is the field I want to add to Purchase Requisition Lines:Operation_DescriptionThis is what I got so far. SettingsSelect Statement:SELECT Operation_Description FROM Shop_Order_Operation WHERE Order_No = :Demand_Order_No AND Outside_Op_Item = :Part_No This is the Error that appears after clicking on ‘Finish’: And these are the results when I only use the Shop Order number as criteria:1) Description of the first line on de Shop Order 2) second criteria to make search uniqueDoes someone know what I am missing here?
Hi, For a few of our suppliers we need to add a document text on the Purchase Order. This information needs to be added every time. That is why we want it automatically shown on the Purchase Order when one of the few suppliers is selected.We have set a document text on the supplier, but don't know how to implement that field on the Purchase Order lay-out in Report Designer.We used this functionalityIn Report Designer I think this is the the field we need: But I cannot drag that field on the lay-out. I only get the invalid cursor as shown below.Has anyone dealt with this kind of problem before?
I want to change the translation of a field, but I don't know how to do it.In Report Designer I added the field ‘CUST_REF’. The default description is the same as the field above ‘CUST_REF’. How can I change the description of this field on this report?
Hi, I tried to update our Purchase Order lay-out with Report Designer, but the results are disappointing.I want to show the edited description of the charge on the PO lay-out.These are the charges I want to show: Two charges of the same Charge TypeI have put the fields on the lay-out in Report DesignerThis is the result‘Transport To Location’ is not on the correct line.How can I resolve this issue?
Hi, When I try to add a Custom Field to the tab ‘Charges’ on the Purchase Order I get this Error: What do I need to do to solve this?
Hi there, I want to create a Read Only Custom Field which refers to another Custom Field.Only problem is that I keep getting Errors. Does anyone have a clue on how to resolve this?This is tee Select Statement I used:This is the Error that appears: I've already looked at another topic on the community where a similar issue was presented. This however was an issue unresolved for APS9. (see link below)
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.