Question

NEW FIELD NOT SHOWING UP IN DATABSE FOR USE BY CRYSTAL REPORTS

  • 21 October 2022
  • 1 reply
  • 54 views

Userlevel 3
Badge +6
  • Do Gooder (Customer)
  • 17 replies

 custom field NOT SHOWING IN CRYSTAL REPORT

I HAVE CREATED A NEW FIELD IN INVENTORY PART (GENERAL TAB) CALLED “CUSTOMER_NO”

I WANT TO USE THIS TO CREATE A CRYSTAL REPORT THAT SHOWS INTERNAL SCRAP COSTS BY CUSTOMER. THE FIELD SHOWS UP IN IFS AND I AM MANUALLY POPULATING IT WITH THE CUSTOMER NUMBER ASSOCIATED WITH THE CORRECT INVENTORY PART. HOWEVER, I CANNOT SEE THE FIELD IN THE DATABSE WHEN I ACCESS IT VIA CRYSTAL REPORTS  (VERSION 2020)


1 reply

Userlevel 1
Badge +4

Have all of the caches in IFS been refreshed? Are you querying INVENTORY_PART_CFV rather than INVENTORY_PART?

Reply