Customer Invoice Postings Analysis relate to Part No

Hopefully this helps to explain. I’ve obviously had to blank out most of the information.

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,

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.