Hi I need to restrict the length of Address1 to 30 characters due to restriction when passing data to myTNT. I think this is possible by editing the address layout per country but cant find where. Address Presentation windows just changes the display size of the fields in the address popup but doesn’t change how many characters can be entered. The Address Setup per Country window also doesnt seem to offer this facility. Is it possibe? Many thanks!
Hi I am extracting data to PowerBI.I want to extract cost of sales and revenue for all customer order shipments.I want to combine shipment & order line data with GL voucher data (account, sales group) We are on Apps 9.I can’t figure out the links to do this.I want to start from closed/completed shipment lines. COST OF SALES:SHIPMENT_ORDER_LINE_OVW → links to → SHIPMENT, CUSTOMER_ORDER_LINE & CUSTOMER_ORDER using shipment_id, order_no, line_no, rel_no & line_item_no. Easy!INVENTORY_TRANSACTION_HIST2 → links to → MPCCOM_ACCOUNTING → links to → vouchers & voucher rows on accounting_id. Easy!But what is the link from shipment lines to inv trans hist? INVENTORY_TRANSACTION_HIST2 has fields SOURCE_REF1,2,3,4 & 5.1,2,3&4 are clearly Customer Order, Line, Rel, Lini Item (for SOURCE_REF_TYPE = Customer Order)What is SOURCE_REF5… Help says its delivery reference… so I think it is the key to link back to shipment line…. but cant find where it links to.
We have the error “Records changed for xxxx" when confirming or authorizing time card day records. This is a known problem. “The reason this is happening is that the calendar date runs out in a setup table. Two Apps9 patches 140516 and 146713 needed.”The SQL check ( SELECT MAX(account_date) FROM calendar_tab ) returns date 15/09/2022.So this is definitely the problem.Is there a workaround while we wait for patches from IFS? e.g. manually entering new dates to the calendar table? Thanks
I want to bulk upload some new parts (part cat, inv part, sales part), structures & routings.I though there were some standard CSV formats & migration import jobs as part of the “Apps 9 Toolbox Standard Data Migration Jobs” that allow you to just prepare the data in a specified CVS format and then upload using a standard migration job. Is anyone aware of this? Are there such standard upload CSV templates & jobs? Thanks
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.