Just looking at the MISO report.
We noticed the client fields for the below we incorrectly loaded at sequence 1 & 2 which I have now changed for you:
The rules of sequencing for column F on the report as specified in the original brief are:
Sequence 4 - Purchase Order.
The report then tries to find the client fields in this order:
Seq 3 - Cost Centre Code
Seq 8 - Business Unit
Seq 10 - Staff/Employee Number
Thereafter there is a catch-all for any of the following client fields, it takes the first one it finds in no particular order:
Seq 1 - Department Code
Seq 2 - Team/Office Location
Seq 5 - Line Manager
Seq 6 - Account Code
Seq 7 - PID (Personal Identification Number)
Seq 9 - BPA (Blanket Purchase Agreement) or PO Number
If we identify 3 lines on the report:
1. PST 19830/1
2. PST 511066/1
3. PST 512626/1
With the examples I have given above the rules have been adhered to.
1. Do we need to review the sequencing?
2. Would you like to revise the 2nd part of the rule which is quite random re which field is displayed?
Thereafter there is a catch-all for any of the following client fields, it takes the first one it finds in no particular order:
Seq 1 - Department Code
Seq 2 - Team/Office Location
Seq 5 - Line Manager
Seq 6 - Account Code
Seq 7 - PID (Personal Identification Number)
Seq 9 - BPA (Blanket Purchase Agreement) or PO Number