Hi, Sorry to be brief, I’m late for a meeting. But if you see the customer invoice lines you can see the part number and the charge type. Both attribute values are found in the same column / attribute. In the below the part number is SP100, the charge type is X. Both are found in the invoice item column . You can get the column name from the IFS screen. See the view (this example) This is one of the views I have used in reporting. View: &AO.CUSTOMER_ORDER_INV_JOIN Best regards, Thomas Hi Thomas, sorry to be rude but I’m not sure you’ve read my question. I know how to find part numbers on the Customer Invoice Lines screen. I need to match lines on the Customer Invoice Postings Analysis screen to the Part No they relate to without having to infer using the value. In other words I need to know if there is a relationship between the lines on each posting and the Customer Invoice Lines and what that relationship is.
Hi, You can relate the invoice posting lines to the invoice lines. The invoice lines have the part number and other information. Best regards, Thomas Thanks for the response. Could you please elaborate on your answer and direct me to the views and SQL field names that could be used for this? System Info shows that the view being used for the Customer Invoice Postings Analysis line detail is INV_ACCOUNTING_ROW2 and that Customer Invoice Lines are coming from CUST_ORDER_INV_ITEM_UIV_ALL. I’ve queried both of these views and there are no references to Part No in the former or an obvious (to me) link between the two.I’ve even tried to go through the Voucher and the VOUCHER_ROW_QRY view but still can’t find any relationship.
Hi @am_44, It will be helpful if you could elaborate more on the issue you are facing here? It would be better with some screen prints. Kind regards, Shanuka. Hopefully this helps to explain. I’ve obviously had to blank out most of the information.
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.