[Type here]
FUNCTIONAL DESIGN DOCUMENT –
<NEW FUNCTIONALITY-SERVICE ORDER MANAGEMENT>
Confidential Document – For private circulation only Page 1 of 11
[Type here]
INDEX
1. Version Management .................................................................................................................................................................................................. 3
2. Requirement Explanation ........................................................................................................................................................................................... 3
3. Current Scenario ........................................................................................................................................................................................................... 3
4. Solution Fitment ........................................................................................................................................................................................................... 4
1. Advantages .................................................................................................................................................................................................................... 8
2. Mandatory Requirement ............................................................................................................................................................................................ 9
3. Deployment Strategy ................................................................................................................................................................................................ 10
4. Test Cases .................................................................................................................................................................................................................... 10
5. Estimation Days .......................................................................................................................................................................................................... 10
6. Out of Scope ............................................................................................................................................................................................................... 10
7. Technical Constraint .................................................................................................................................................................................................. 11
8. Customer Sign Off / Remarks ................................................................................................................................................................................. 11
Confidential Document – For private circulation only Page 2 of 11
[Type here]
1. VERSION MANAGEMENT
# VERSION DATE DESCRIPTION PREPARED BY REQUIREMENT BY
1 V2.0 06-12-2022 WORK ORDER FUNCTIONALITY VIPUL PATEL SHREE GANESH CORPORATION
2
3
4
2. REQUIREMENT EXPLANATION
(Requirement Explanation: Write down requirement of customer in detail.)
To replace existing Functionality of work order
3. CURRENT SCENARIO
(Current Scenario Explanation: Write down Current Scenario of customer.)
Currently SGC is using work order functionality of CETAS
Followings are the reasons to replace it
Confidential Document – For private circulation only Page 3 of 11
[Type here]
1. They are not getting resource wise Billing
2. They can not edit BOQ lines in the work order, this point is not feasible to change every time BOQ, because BOQ can be changed multiple times
3. Outstanding quantity doesn’t match
4. There are some bug while entering multiple same lines in the BOQ Lines
4. SOLUTION FITMENT
(Solution Fitment: Write down Solution Fitment in NAV.)
Functionality / Report Description
1. Service order Page
A new page of the Service order to be created same as purchase order (Excluding type with item) with following changes
1. Resource Code, Resource Description columns will be created in the line page
2. Remaining billable Quantity to be shown in the line
3. Billed Quantity of that order should be shown
4. Internal /External Service Order type is required on header page
5. No. series would be separated
✓ Required Lines Details would be as below
Confidential Document – For private circulation only Page 4 of 11
[Type here]
Cumm
.
Order
QTY. Rate Amount
Thi
s Unit Direct
GST GST GST Total Bill Bal Bill of Unit Line
Grou Grou HSN/ Base GST Locati ed . ed Meas Cost Amoun Billed Bal.
p p SAC Amou Amou on Quant QT QT QT ure Excl. t Excl. Amou Amou
Type No. Code Type Code nt nt Description Code ity Y. Y. Y. Code Tax Tax nt nt
SGCC0 GST- Servi ### ### J- ### ####
G/L 135 18 ce 4407 ## ## WOODEN LAFA 0046 ## KGS 12.00 ##
✓ Approval of the Service order
1. Approval of the Service order should be required as per the project wise approval chain
✓ Posting of Service order
1. User will enter Billed Quantity and post it on the Separate page of Service Receipt
2. After posting of order Service order Service receipt note should be created
3. Automatic Consumption of the Job Journal line to be generated while creating Service Receipt note in a particular job journal worksheet
✓ Pages for the Service order receipt
1. Posted Service receipt header
2. Posted Service receipt Line
✓ Posting of Service Invoice
1. To post service Invoice user must get Service receipt lines
2. User will verify quantity and post it
Confidential Document – For private circulation only Page 5 of 11
[Type here]
✓ Posting of Entries
1. General Ledger Entries
2. Posted Service Invoice
3. All Supported tables of Posted purchase invoice
4. GST Ledger Entries
✓ Report of work order printing
A new report with existing format will be developed
✓ Retention Amount Calculation
Retention amount should be calculated on the invoice Amount.
1. User will enter percentage on the header part of Service Invoice
2. System will calculate retention amount on the invoice save to invoice header
3. After posting of Service invoice, retention amount will be posted in the vendor ledger entries
Functional/Technical review
Following Pages will be created
1. Service order header
2. Service Order line
3. Service Order list page
4. Posted Service receipt Header
5. Posted Service receipt line
6. Posted Service Receipt List page
7. Posted Service Invoice Header
8. Posted Service Invoice line
9. Posted Service Invoice List page
Confidential Document – For private circulation only Page 6 of 11
[Type here]
Following tables would be modified
1. Purchase Invoice Line
2. Purchase Invoice header
3. Purchase Line
4. Purchase header
Process Flow Document as required By Customer
Confidential Document – For private circulation only Page 7 of 11
[Type here]
1. ADVANTAGES
Confidential Document – For private circulation only Page 8 of 11
[Type here]
(Advantage: The following would be advantage after development)
[Link] will get resource wise invoicing
[Link]. work order will be reduced
[Link] will get outstanding quantity
2. MANDATORY REQUIREMENT
(Mandatory Requirement: Write Down the mandatory requirement)
Test cases - All types of work order details
Required Objects like tables and pages will be purchased by SGC
Confidential Document – For private circulation only Page 9 of 11
[Type here]
3. DEPLOYMENT STRATEGY
(Deployment Strategy: The following would be deployment strategy after development)
On approval & Sign off of this Document, we will start develpoment on your testing database. On test approved by you, We will Deploy
Same in LIVE.
4. TEST CASES
(Test Cases: Write down the test cases for Development)
Existing work orders
5. ESTIMATION DAYS
(Estimation Days: The following would be estimation days for new development)
1) Requirement Gathering & Analysis
2) Design / Development –8 Days
3) Testing – 2 Days
4) Deployment – 1 Day
6. OUT OF SCOPE
(Out of scope: The following requirement would be out of scope of this project)
- Additional requirement During training & UAT
- User manual
Confidential Document – For private circulation only Page 10 of 11
[Type here]
7. TECHNICAL CONSTRAINT
(Limitation: Write down any technical impossibility of this project)
8. CUSTOMER SIGN OFF / REMARKS
(Requirement Estimation Sign Off)
Confidential Document – For private circulation only Page 11 of 11