Company: Link Technologies
Case No: L08561. Project: 08.20: LinkSOFT Version 8.2
Logged By: Vineet (Link Business Solutions) on 29 May 2017 03:37PM
Priority: High
Product: Point of Sale
Group: Change Request
Time Taken: 14.00 (Weight: 14.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Vineet
Resolve By: Tuesday, 30 May 2017 12:00 AM [2970 days since logged date]
Status: Closed
Subject: Migrate customized Outstanding Purchase Order Report from version 6513 to 70175
Summary:    

Report parameters:  (Old and new report parameters are the same)

  1. Select Warehouse Group
  2. Select Report Style
  3. Select Sort Order
  4. Select P/O status
  5. Select Physical Warehouse
  6. Select Logical Warehouse 
  7. Due by
  8. Select Starting Part No
  9. Select Ending Part No 
  10. Always show non-stock item
  11. Select Starting Creditor Account.
  12. Select Ending Creditor Account.
  13. Starting Inventory Classification
  14. Ending Inventory Classification

PO Status Uncommitted as at 31/12/2015



PO Status Committed as at 31/12/2015





Audit Notes:
29 May 201710:57AM Comment 1 by Vineet (Link Business Solutions) Case 8561 added to project Customization-Client
31 May 201702:38PM Comment 2 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 31-05-2017 02:38 PM Time Taken: 8.00
Development work for this case has been completed.
The change will be available in version: 8.12
Documentation update required(Yes/No. Add change details below)
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Designed report in FMSPORTAL. See sample screenshot below.

Documentation details:
 

04 Jun 201706:28PM Comment 3 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-06-2017 12:00 AM

Hi Rashna

Please kindly test these report in 8.12. You can get the FMS Portal link for 8.12 from Alvis as he has hosted this on Dev Server. This link points to Client upgraded DB on QA4

Regards
Vineet Ram

 

20 Jun 201702:28PM Comment 4 by Alvis (Link Technologies) Case 8561 removed from project Customization-Client
20 Jun 201702:31PM Comment 5 by Alvis (Link Technologies) Case 8561 added to project 8.12
28 Jun 201708:13AM Comment 6 by Alvis (Link Technologies) Case 8561 removed from project 8.12
28 Jun 201708:13AM Comment 7 by Alvis (Link Technologies) Case 8561 added to project LINKFJ
29 Jun 201701:44PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 29-06-2017 01:44 PM Time Taken: 3.00
1. Was this test completed using Demo / New / Other database?  Client Database
2. Did the test pass or fail? Failed
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N?A
4. Data verified, saved, edit, delete/void? 
5. Documentation update required? 
Additional Details (Risks, issues, special conditions required for this test to pass etc): 

Hi Alvis,

When I generate the report with the filters stated in the image below. I get the following error.

"Invalid object name 'LT_JIWA_1001PO_Main'"

The setup is QA1 with database FMIS.



29 Jun 201702:16PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 29-06-2017 02:16 PM Time Taken: 1.00
Development work for this case has been completed.
The change will be available in version: 8.12
Documentation update required(Yes/No. Add change details below)
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information): 
Corrected issue with report error message.

Update on ftp: FMSPORTAL_8120.000.BETA1_20170629.zip


Documentation details:
  

11 Jul 201709:07AM Comment 10 by Alvis (Link Technologies) Case 8561 removed from project LINKFJ
11 Jul 201709:07AM Comment 11 by Alvis (Link Technologies) Case 8561 added to project 8.12
20 Jul 201701:33PM Comment 12 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-07-2017 01:33 PM Time Taken: 2.00

UAT and documentation completed on the case.

Documentation updated at Financial Management System -- Business Intelligence -- JIWA Purchase Orders As At


Attachments:
General Documents - Case: 8561:003 - Purchase Order Close status.sql
004 - Purchase Order Not Invoiced As At.sql
POINF020 - Outstanding Purchase Orders.rpt
POINF020 - Purchase Orders Not Invoiced As At.rpt
If you have any queries regarding this support incident, please email Support@LinkTechnologies.com.au and include the Case No: L08561 in the subject line of all emails regarding this issue.

Document size: 6.1 KB
For call complaints, please contact the Managing Director of the company using this form