Skip to main content
Question

Pre-Posting info

  • January 13, 2025
  • 2 replies
  • 40 views

Forum|alt.badge.img+3

Hello,

 

We are using IFS Applications 9. I need to generate a report and am wondering where the division and product information of pre-posting is sourced from. Could you please let me know the table or view name that contains this data? Thank you!

 

 

2 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1303 replies
  • January 13, 2025

@agovindarajan this info is defined in finance.

Basically in Finance you have Account and the you have other code parts from B to J that the business could user according to what they wanna track in GL.

So, your code B to J will have it’s own tables/views → CODE_B | CODE_C | …. | CODE_J

 

Now, coming to your question on CO Line preposting, the data comes from the pre_accounting view. You’ll need to join CO Line with Pre_Accounting on pre_accounting_id column.


Chanu_Yazi
Hero (Partner)
Forum|alt.badge.img+12
  • Hero (Partner)
  • 151 replies
  • January 13, 2025

Hi ​@agovindarajan 

 

Product

 

The Division field is generally associated with the COMPANY table, which stores company-related information, including divisions. In the context of customer orders, this information might also be referenced from the CUSTOMER_ORDER_LINE_TAB view. (This has to be check from the application)

 

Regards,

Chanuka.D