Release Note – Shark Iteration 18

 

1         Sales and Purchase

1.1      83 – POint no : 83:  Add Payroll Fee Deducted from Margin as a row in header in Payrun Sheet

 

  • Placement -> Contract Details

1

 

 

 

 

 

 

 

 

 

 

 

 

 

  • Enable Payroll Tax under Standard Deductions section
    • Select box
    • Select Yes
    • Set ’Chargeable From’ to Margin
    • Finance -> Pay Number
  • Select Pay number and click excel icon to open Payrun file

2

  • Placement Ids are sorted by Last Name, First Name
  • 3

 

 

 

 

 

 

 

 

 

 

 

 

1.2           93    Point no: 93: ticksheet header needs to be fixed

 

  • Reports-> Timesheet Live -> Tick sheet Report
  • Contractor First Name column shows Contractor’s First Name
  • 4

 

 

 

 

 

 

 

 

 

 

  • Reports-> Exports To
  • Click pdf icon or excel icon and open pdf or excel file
  • 5
  • Column H – Contractor First Name column shows Contractor’s First Name

6

 

 

 

 

 

 

1.3         112  Purchase Invoice : allow email change only and allow to post too

 

  • Finance -> Purchase Invoice List
  • Select a Posted Invoice
  • Change Email address and click Save icon
  • The Invoice will be automatically re-posted
  • Comments about Email change and reporting will be added to History Trail
  • 7

1.4          115  Point 115: Purchase Invoice Screen : Show hide column value — RCTI / REmit Email address

 

1.4.1        Client is Umbrella Company

 

  • Placement -> Client
  • Entity Type is ‘Umbrella Company’
  • 8

 

 

 

 

 

 

 

 

 

 

 

  • Finance -> Purchase Invoice List
  • Open Purchase Invoice
  • it shows Entity Type as ‘Umbrella Company’ and shows Remittance Email address9

1.4.2        Client is not Umbrella Company

 

  • Placement -> Client
  • Entity Type is ‘Company’10

 

 

 

 

 

 

 

 

 

 

 

 

  • Finance -> Purchase Invoice List
  • Open Purchase Invoice
  • it shows Entity Type as ‘Company’ and shows RCTI Email address
  • 11

1.5      124      Point No: 124: Posting Date of Invoices as per pay Period End date in which it is generated or processed

 

  • Finance -> Pay Numbers -> Open Pay number -> Pay Periods tab
  • Pay Period Frequency and Ending date
  • 13

 

 

 

 

 

 

 

  • Finance -> Purchase Invoices
    • Select Invoices to post
    • Click on Post button

 

  • Post Date depending on the Frequency of the Pay Period – If weekly – then
  • 14

1.6      155      point no: 155: reject manual timesheet submit it again or any other stage — rejection comments are not shown

 

  • Finance -> List -> Contractor Timesheet Report
  • Reject a Timesheet and add Rejection comments
  • Resubmit the timesheet and reject again with different Rejection comments

15

  • Finance -> List -> Contractor Timesheet Report
  • Rejection comments are not removed
  • 16

1.7          157  tick sheet report: If timesheet is at rejection stage then it will be highlighted in yellow

 

  • Reports -> Timesheet Live ->Tick Sheet
  • Rejected Timesheet appear in yellow
  • 17
  • Values for rejected timesheets will not be processed in Payrun

1.8          205  Contractor Timesheet scenario

 

  • This is the flow for when there is Change in pay number for any contractor
  • Process one timesheet line under any pay number and move it to batch1
  • 2 3
  • change the paynumber of that placement4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • now check all the timesheet lines of that placement in contractor timesheet screen
  • 5

 

  • outcome: we should be able to trace all timesheet lines which are in system prior to pay number change and after too and should be able to approve/ submit/ reject etc operation on them
  • 6
  • further moving forward those lines should also be available at pay timesheet level though can be under different paynumber

1.9      210      Point no: 210: Wipro specific Invoice : Consolidate Calendar Month – Single Line Per Contractortime

 

  • Client -> “Wipro Technologies”
  • Select Invoice Structure type is Consolidated Calendar Month – Client Wise – Single Line per Contractor
  • Save Client7
  • Open Placement and Client is “Wipro Technologies”8
  • Placement -> Timesheet List
  • Invoice Structure type is ‘Consolidated Calendar Month – Client Wise – Single Line per Contractor’9

1.9.1            Sales Invoice is generated

 

  • Invoice structure has new option ‘Consolidated Calendar Month – Client Wise – Single Line per Contractor’10

 

 

 

 

 

 

 

  • Ensure that the Wipro Sales Invoices are saved in Navision and their units and Amounts match with RL
  • Sales Invoice is Posted from RL
    • (for Client Wipro with Invoice structure – Invoice per PO per week ending)
  • 11
  • Sales Invoice is Posted from RL12

 

1.10      214 Export to XLS facility for Purchase Invoice List

 

  • Finance -> Purchase Invoice List
  • Click on the excel icon in right top of the screen
  • 13
  • Purchase Invoice List excel file is generated
  • 14
  • all the column in the Purchase Invoice List UI appear in the excel
  • Other columns (not appearing on UI) will be filled based on the Invoice status selected

 

 

1.11     214  Export to XLS facility for Sales Invoice List

 

  • Finance -> Sales Invoice List
  • Click on the excel icon in right top of the screen
  • Sales Invoice List excel file is generated
  • all the column in the Sales Invoice List UI appear in the excel
  • Other columns (not appearing on UI) will be filled based on the Invoice status selected

1.12    214   Export to XLS facility for Credit Note List

 

  • Finance -> Credit Notes List
  • Click on the excel icon in right top of the screen
  • Credit Note List excel file is generated
  • all the column in the Credit Notes List UI appear in the excel
  • Other columns (not appearing on UI) will be filled based on the Invoice status selected

 

1.13      217 Sort Payrun Sheet on Lastname, firstname instead of placementid

 

  • Finance -> Pay Number
  • Select Pay number and click excel icon to open Payrun file
  • 1
  • Placement Ids are sorted by Last Name, First Name
  • 2

 

1.14     238  Send Mail of Payrun Sheet to Company–> Accounts email Addresses after closure of payperiod automatically

 

  • Admin -> Company -> Details
  • Emails addresses
  • 1
  • Finance -> Pay Number
  • Select Pay number and open Pay Periods
  • Close a Pay Period2

 

 

 

 

 

 

  • 3A mail is sent to the Email Ids setup at the Company level
  • 4

1.15      268 Point no: 268: Notification email on deletion of invoice is having different time stamps in different mailboxes

 

  • Finance -> Sales Inv List / Purchase Inv List
  • Delete an Invoice (Sales / Purchase)

5

 

 

 

  • Placement -> Email History
  • date timestamp of the mail sent
  • Ensure that the date time stamp is not too different

6

 

7

 

 

 

 

1.16     274  Show amount in two decimal on salesinvoice list screen and purchaseinvoice list and creditnote list screen

 

  • Finance – Purchase Invoice List
  • The Total Amount will appear with two decimals
  • Finance – Sales Invoice List
  • The amounts will appear with two decimals
  • 8
  • 9Finance – Credit Note List
  • The Amount will appear with two decimals10

1.17     310  Point no: 310: add worksite tags in Sales Form Template

 

  • Placement -> Client
  • Worksite Details11
  • Placement -> Document -> Email to Accounts
  • Generate Sales Form or IPS Refrerral12
  • Work site tags in Sales Form13

 

 

 

 

 

 

 

 

 

 

 

 

 

  • Work site tags in IPS Referral14

 

 

 

 

 

 

 

 

 

 

 

 

1.18     315  Point no: 315: Show and Save PO number in timesheet additional line, adjustment line flow till payjournalline.

 

  • Additional line added – shows PO number
  • 1

 

 

 

 

 

 

 

  • Adjustment line shows PO number2
  • Journal Batch – shows PO number
  • 3

1.19     315  Point no: 315: New Invoice Structure Type is needed — Invoice Per PO Per Week Ending

 

  • Timesheet shows the Invoice structure type
  • 4
  • Journal Batch shows the new Invoice Structure type
  • 5
  • Timesheet shows the new Invoice structure type in Sales Invoice
  • 6

1.20     206  Point NO: 206: Import CSV TImesheet Lines –Ariba — show public holiday

 

1.20.1       Import Normal Timesheet lines7

  • Following fields appearing in Ariba csv should exist in RL
    • Candidate name
    • Candidate ID
    • Client name
    • Placement ID

 

  • The placement duration should include the timesheet week ending
  • file type is .csv
  • Once the placement is created click the Timesheet link on Top – (its mandatory)8
  • Finance-> Import ARIBA Timesheets9
  • Select the csv file to be imported file and import
  • Text log file is created – TimesheetImportResult
    • Number of records processed
    • Errors (if Any)10
  • Refresh Timesheet screen open the newly created Timesheet record in ‘Submitted’ status
    • Displays Timesheet days and hours11

1.20.2         Timesheet on Public holiday

  • Worksite Region of the Placement

13

  • Admin -> Library -> Holidays
  • Select Region and Country – same as Placement Worksite14
  • csv file has Timesheet lines for the week with the work done on Public holiday
  • 15
  • ‘Ignore Public Holiday’ box is selected – then import the csv

 

  • Timesheet with work done on Public holiday
  • ‘Ignore Public Holiday validation’ box is not selected
  • 16

 

 

 

 

 

 

  • TimesheetImport Results file shows error
  • 17

 

 

 

 

 

1.21     315  Point no: 315: Import Ariba CSV: for extra lines as timesheetadditionalline

 

  • the Timesheet ID and PO number is different but Week Start and End Date are same as already existing Timesheet1
  • The log file will show lines for Additional Timesheet
    • With details of Success or Error while importing2
  • Additional Timesheet lines are added with comment ‘Imported from Ariba’
  • 3

1.22     333  Sales history and Purchase history trail in invoices generated are showing notes for old invoices which have already been deleted

 

  • The Sales history and Purchase history trail in invoices generated will not show notes for old invoices which have already been deleted

4

1.23     334  The amount of EFT is correct in report generated from RL though it is wrongly calculated in the confirmation message.

 

  • Finance -> Journal Batch
  • Select Batch name Process and Generate Invoices
  • Confirmation message shows Insurance Amounts (PI, PL, WC) correctly
  • 5

 

 

 

 

 

1.24            335 RCTI report will show label EFT Date / Projected EFT Date

1.24.1      RCTI report show label Projected EFT Date if status invoices is not PAID

  • Finance -> Purchase Invoice List
  • Open Purchase Invoice that is not ‘Paid’
  • 6
  • RCTI report will show label Projected EFT Date

1.24.2      RCTI report show label EFT Date if status invoices is PAID

 

  • Open Purchase Invoice that is in ‘Paid’ status
  • 7
  • RCTI report show label EFT Date

 

1.24.3       EFT date on purchase invoice, which should not be less than current date.

 

  • The EFT Date will be the date in which the Purchase invoice is ‘Paid’ in Navision

1.25     348  On Invoice structure change timesheet list split week ends won’t get settled

 

  • Select Placement where Invoice Structure shows no split weeks in Timesheet List
  • Submit a Timesheet which will have a split week (after Invoice Structure change)8

 

 

  • Now change the Invoice Structure Type – where Timesheet List will show Split week Timesheets9
  • split week timesheets will appear – for the Submitted Timesheet – splir week timesheet will not be shown
  • 10

 

 

 

 

 

 

 

1.26    359 – Color band added on the deleted invoice but status of the same invoice is showing it as “Invoiced”.

 

  • Finance -> Invoice List (Sales / Purchase)
  • Deleted Invoices appear in pink color and also have status as ‘Deleted’1112

1.27     359  The status of deleted invoices in invoice list at placement level shows invoiced

 

  • The same is seen in Placement -> Invoices / Purchase Invoices tab
  • 1314

1.28    359   Having color band added on the deleted invoice line is showing it as “Invoiced”.

 

  • Finance -> Invoice List (Sales / Purchase)
  • Finance -> Invoice list Excel – Sales / Purchase
  • Deleted Invoices appear in pink color and also have status as ‘Deleted’
  • A Legend is also provided – regarding the color code

1.29     362  Due date is in editable mode and changes can be saved on invoice

 

  • Finance -> Sales Invoices
  • Open existing Sales Invoice (that is not posted)
  • Due date cannot be edited – It will only be calculated based on change in Document date1 2 3

1.30    362   Add validation for document date

 

  • Finance -> Sales Invoices
  • Open existing Sales Invoice (that is not posted)
  • Validation is added to check that Document date cannot be set as less than current date

1.31   362    Add stamping of document date

 

  • On saving the changed Document date – note is added in Sales History Trail in the Sales Invoice
  • 4
  • Changed Document date and Due date are seen in the Sale Invoice Report pdf file
  • 5

 

 

 

 

 

 

 

 

 

 

 

 

1.32    365   Please can you help to identify the reason of not getting address details in seller address field of sales invoice #9.

 

 

 

1.33      367 Point No: 367: Pay Timesheet Screen  and Pay journal Batch screen — Validate for Umbrella Company Email Address

 

  • Placement -> Contractor
  • the Contractor  is Umbrella Company

 

  • Open Umbrella Company Client
  • Client -> Address & Telephone
  • Make the first Email field empty and save the Client
  • Finance -> Timesheets -> Pay Timesheet Report
  • Select Invoice and Move to Batch
  • the message regarding Umbrella Company Client Email address is missing
  • 6
  • Add email address and proceed to Journal Batch page
  • Now empty the Umbrella Company email address again and save the client
  • Finance -> Journal Batch
  • Select Batch name and process to Generate Invoice
  • the message regarding Umbrella Company Client Email address is missing

1.34     408  hide Amount Deducted column form salesinvoice lines list from sales edit screen

 

  • Earlier Amount Deducted field was shown in Posted Sales Invoices7
  • Finance -> Sales Invoice List
  • Select any ‘Posted’ Sales Invoice
  • Now the Amount Deducted field will not be shown

8

 

1.35     409  Send PI PL WC lines to navision while sending purchase invoice xml

 

  • Finance -> Purchase Invoice
  • Open Posted Purchase Invoice with PI PL WC values1
  • View RCTI Report and check values for PI PL WC lines
  • 2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • Open Navision – Purchase -> Posted Invoices
  • Add RL Purchase Invoice number in ‘RL Document ‘
  • PI PL lines for the posted Purchase Invoice in Navision
  • 3

 

 

 

 

 

 

 

 

 

 

 

 

1.36 410      Changing comments to blank is not reflecting correctly in notification email and in placement audit list.

 

  • Finance -> Sales Invoice List
  • Open ‘Invoiced’ Sales Invoice
  • Change Comments in Sales Invoice
  • Select ‘Yes to Reflect in Placement
  • the Comments are saved in Sales History Trail in Sales Invoice
  • Placement – >Email History
  • the email is sent to Contractor regarding changes in Comments
  • 5
  • Placement -> Audit List
  • the change in Comments is recorded here
  • 7

1.37     413  Point no: 413: Add Date time in Generated on in all financial reports

 

  • Date time stamp is added in financial Reports
    • Sales Invoice List
    • Purchase Invoice List
    • Credit Notes List
    • Remittance Report
    • EVR Repot
    • Timesheet Audit Report
    • SalesEFTReport
    • Sales Register
    • TickSheetReport
    • PurchaseRemittanceReport

 

 

  • Example – Purchase Invoice Report

1.38      416 Credit Note screen shows wrong amount value

 

  • Open Finance -> Sales Invoice List
  • Click on Credit note summary icon for any Sales Invoice
  • Credit Note Amount shows two decimals and is not truncated or rounded off
  • Finance -> Credit Note List
  • Click on Credit note ID for any credit note
  • Credit Note Amount shows two decimals and is not truncated or rounded off

 

 

 

1.39     419  Parent Invoice ID and Credit Note ID(s) not showing in exported excel.

 

  • Finance -> Sales Invoice List
  • Open excel sheet
  • Parent Invoice ID and linked Credit Notes are displayed

 

1.40     421  Point: UI changes required on purchase invoice list

1.40.1    Sales invoice list and  purchase invoice list should be in descending order by invoice ids

 

  • Finance -> Invoice List (Sales / Purchase)
  • Open excel sheet
  • List is sorted in descending order of Invoice ID

1.40.2      No posting date in manual sales invoice

 

  • Posting Date field will not be shown in Manual Sales Form

 

1.41     423  wasp – sales inv – 4270 – changed document date — the history trail shows doc date and due date msg correctly

 

  • Document Date change and Due date change is seen correctly in the Sales History Trail in Sales Invoice

1.42    424   Due date should change when placement is selected in manual sales invoice screen

 

  • If Manual Sales Invoice is opened from — Finance -> Sales Invoices — Open Manual Sales Invoice — select Existing sales invoice and click ‘+’ button
    • Document date is set as current date by default
  • If Manual Sales Invoice is opened from — Finance -> Sales Invoices — Directly click ‘+’ button
    • Document date is set as current date after selection of the Placement ID

 

1.43     425  Manual sales invoice – all the values are getting rounded off in sales invoice line

 

  • Values in Manual Sales invoice are not rounded off and show 2 decimal places

 

1.44     427  Manual Sales Invoice- Document date should not be less than current date

 

  • Finance -> Sales Invoices
  • Open Manual Sales Invoice
    • Select Existing sales invoice and click ‘+’ button
    • Directly click ‘+’ button

 

  • Validation is added to check that Document date cannot be set as less than current date

1.45     434  Purchase invoices and Sales invoices are not getting posted from edit placement screen although there is post button

  • Placement -> Invoices
  • Open Invoiced Sales Invoice
  • Update details and click Post
  • the Sales Invoice gets posted
  • the Sales Invoice status changes to posted
  • Placement -> Purchase Invoices
  • Open Invoiced Purchase Invoice
  • Update details and click Post
  • the Purchase Invoice gets posted

8