Adding a Column to PRIMS

Here are the step by step instructions to add a column to PRIMS.

  • Add column to the SQL table in the database.
  • Go to definer : Define > Table > Spreadsheet > Add column at the bottom > Save.                            (Note : when the spreadsheet opens, hit F2 to go to the query mode and then F3 to do a wild search. Save and Create)
  •  GUI designer : Provider task > Information window > POS Provider > POS Provider maintenance.At the provider maintenance > Select window > Right click to Property Inspector. Go to query (drop down list) add the required column and save.
  • Create Flat files in the Definer (Tools > flat files (.com and .ext) and Create them)
  • Create the other flat file in the GUI designer (Tools > Generate flat file (.esi))
  • Now how to check if the column is added? Go to Prod binder > Application > Inquiry > POS maintenance provider.(Provider without cc dig (give some number xxxxxxx), Hit F9.One should be able to see some value on the newly created column.
  • Copy the flat files on the server (Local -> Server). There should be 3 files Prims.con, Prims.esi, Prims.ext
Will post the screen shots if possible. :)

Thanks and good luck.                                 

Comments

Post a Comment

Popular posts from this blog

SysDictField object not initialized. - Views

One of my Colleague had this issue.. I’m using a View (with some calculated fields), as the source for another View (summed fields, so I’m working with “total” records). This 2 nd View continues to have this error message: SysDictField object not initialized. Stack trace (C)\Classes\SysTableBrowser\AddField - line 32 (C)\Classes\SysTableBrowser\showAutoFields - line 95 (C)\Classes\SysTableBrowser\run - line 67 Solution: Go to the Field Groups and delete the fields that are in the Autoreport and delete the fields that are Autoreport and not in the Field List of the View.
Read more

How to filter data for the last few weeks?

I got a task where I had to get the data for the last few weeks excluding the current week. The week begins on a Sunday and ends on a Saturday. Here is the code: { Date dateFrom; Date dateTo; date fd; ; fd = dateStartWk(systemDateGet()); // get the First day of the Week dateTo = fd - 2; // Subtracted 2 since the first day is a Monday dateFrom = dateTo - ((5 * 7) -1); // shud be 3*7 - 1 as ToDate value is also Included info(strFmt("%1-%2-%3", fd, dateTo, dateFrom)); }
Read more

Get the value of Month or YY in SysComputedCOlumns in AX views

Here is the Code: public static server str WFinvoiceDateMM() {     str sDate =         SysComputedColumn::returnfield(             tableStr (WFSyscoInvoicesV),             queryDataSourceStr (WFSyscoInvoicesQ, CustInvoiceJour),             fieldStr (CustInvoiceJour, InvoiceDate)             );     return 'Month(' + SysComputedColumn::fromUtcDateToDate(sDate) + ')' ; }
Read more