Jiwa

Would like to Add Column to Sales Order Batch Process screen, doesnt look like the procedure GetlistOfSalesOrdersToProcess will help.

Customer wants to be able to check if the order has been sent to the Distribution warehouse, before processing. Have view which can pick this up.

Any tips, or does anybody have a plugin they can share.. Thx,

Hi Ernst,

Ths can be done but not necessarily that easily the things you would need to do are:

Add a column to CandidatesJiwaGrid as in CandidatesJiwaGrid.AddColumn
Add a handler for BatchProcess.ProcessCandidates.Added how the add handler code does it is below
As part of the _BatchProcess_ProcessCandidates_Added code it displays the candidate so you would only need to fill in the extra column in your handler, the row that just got displayed will be the last row in the grid.

Code: Select all

this._BatchProcess.ProcessCandidates.Added += new IJiwaCollection.AddedEventHandler<ProcessCandidate>(this._BatchProcess_ProcessCandidates_Added);

  private void _BatchProcess_ProcessCandidates_Added(ProcessCandidate item)
        {
            SheetView activeSheet = this.CandidatesJiwaGrid.ActiveSheet;
            activeSheet.RowCount = checked(activeSheet.RowCount + 1);
            this.CandidatesJiwaGrid["RecID", checked(this.CandidatesJiwaGrid.ActiveSheet.RowCount - 1)] = item.RecID;
            this.DisplayCandidate(item, checked(this.CandidatesJiwaGrid.ActiveSheet.RowCount - 1));
            this.DisplayCandidateTotals();
        }


OK, I'm not sure where in your code, is the new column or what its name is, Let say I wanted to just load the altaccountno into a column, do you have a plugin for that. Or any other working plugin, that add a column.
I used to have one in JIWA6, thats added the branch, from the sales order, but of course that does not work in J7.

Its quite common for the processing staff wanting to see more.

Add column would be in a form plugin setup and would look something like this, add the handler in the setup as well

Code: Select all

CandidatesJiwaGrid.AddColumn("altaccountno", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), "alt acc no", 10, false, false, false, true);


You set the cell in the handler with something like this

Code: Select all

CandidatesJiwaGrid.set_GridText("altaccountno", row, valueToSet);


Ive found I can adjust usp_JIWA_GetListOfSalesOrdersToProcess, on the Name field, and that will flow through to the screen. SO ive added a '***" in front of the name, if that invoice had not been sent to Distribution warehouse.