Bug 176 - modifications required in customer report
Summary: modifications required in customer report
Status: RESOLVED FIXED
Alias: None
Product: MANAGEMENT INFORMATION SYSTEM
Classification: 01.IMIS
Component: MIS FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: PC Windows
: Normal normal
Assignee: Sharad
URL:
Depends on:
Blocks:
 
Reported: 2019-07-03 18:31 IST by kk
Modified: 2019-08-08 13:28 IST (History)
1 user (show)

See Also:
Database: DPPC
Module ID: Not given

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Comment 5 Shreya Jha 2019-08-08 13:28:19 IST 
I had replied on 31st July on this; guess there were 2 codes created. Anyway:

For daily report, required columns:
1.	Company Code
2.	DD/SS
3.	Customer Code
4.	Customer Name
5.	Depot name (all depots where Sale Allowed is Y for customer should come here)
6.	Contact Person
7.	Address
8.	Postal Code
9.	Mobile number
10.	Email
11.	Tin number
12.	FSSAI no.
13.	GST regn type
14.	GST Number
15.	Class
16.	Group
17.	Country
18.	State
19.	City as per census
20.	City as per sales
21.	Created by
22.	Created on
23.	Status
24.	ASM HQ (we have a predefined list of ASM HQ¿s. only those cities will be in this column. The values here may or may not be equal to city name)
25.	Status Since
26.	Dr Balance
27.	CR balance
28.	Last Bill date

FSSAI validity will be a monthly report which will have the FSSAI number, validity to and from date; this will not be a part of the daily report
Comment 4 kk 2019-07-22 17:58:39 IST 
New report has been made and sample sent. Need information on user interface and frequency of report. Shreya ji pls respond.
Comment 3 Sharad 2019-07-12 14:34:40 IST 
a. Mr. Shirish.pathak@baba.in & devender.rawat@baba.in added in IMIS generated customer report.
Comment 2 Sharad 2019-07-05 10:09:46 IST 
Dear Madam,
Please Provide the Employee code of Mr. Shirish Pathak for System Generated file - ORCL_ARCL0002_CUSTOMERS
Comment 1 kk 2019-07-03 18:39:36 IST 
Ms. Shreya,
Pls give name of report / module. this is usually printed at the end of the report. If not give the title of the report as printed on top of each page or give the menu option that you are using to print the report.
Description kk 2019-07-03 18:31:37 IST 
IMIS generated customer report: Few modifications required for that report:

a.      These IDs to be added: Shirish.pathak@baba.in; devender.rawat@baba.in

b.      Add the following columns

i.     DD/SS
ii.     Depot to which the customer is mapped
iii.     Contact Person
iv.     Address
v.     Postal Code
vi.     Mobile no.
vii.     Email
viii.     Tin No.
ix.     GST
x.     FSSAI
xi.     GST Regn type ¿ Composite, Exempted