Bug 6025 - Related Party's - Sale & Purchases
Summary: Related Party's - Sale & Purchases
Status: RESOLVED USER TO VERIFY
Alias: None
Product: IMIS PURCHASE
Classification: 01.IMIS
Component: IMIS PURCHASE FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: PC Windows
: --- critical
Assignee: Sharad
URL:
Depends on:
Blocks:
 
Reported: 2021-03-12 17:27 IST by Sanjay Gupta
Modified: 2021-08-31 12:05 IST (History)
2 users (show)

See Also:
Database:
Module ID:


Attachments
SS_0893_IMIS_Against call id - 6025 (254 bytes, text/plain)
2021-05-31 18:31 IST, Sharad
Details
SS_0893_IMIS_Against call id - 6025 (263 bytes, text/plain)
2021-06-01 10:31 IST, Sharad
Details
ARMF5065_SUPPLIER_DETAILS.CSV (4.53 KB, application/vnd.ms-excel)
2021-06-04 14:34 IST, Sharad
Details
ARMF5065_SUPPLIER_SUMMARY.CSV (1.16 KB, application/vnd.ms-excel)
2021-06-04 14:34 IST, Sharad
Details
ARMF5065_CUSTOMER_SUMMARY (1.43 KB, application/vnd.ms-excel)
2021-06-08 17:09 IST, Sharad
Details
ARMF5065_CUSTOMER_DETAILS.CSV (18.01 KB, application/vnd.ms-excel)
2021-06-08 17:12 IST, Sharad
Details

Note You need to log in before you can comment on or make changes to this bug.
Comment 15 Sharad 2021-08-31 12:05:06 IST
Dear Sir,

Rights given to Mr. Sanjay Gutpa for "APMF5065 - Related Party Sales / Purchase"

Please check & confirm.
Comment 14 Sharad 2021-08-31 12:04:45 IST
Dear Sir,

Rights given to Mr. Sanjay Gutpa for "APMF5065 - Related Party Sales / Purchase"

Please check & confirm.
Comment 11 Sharad 2021-06-08 17:12:28 IST
Created attachment 1939 [details]
ARMF5065_CUSTOMER_DETAILS.CSV

Dear Sir ,

As per discussed with Mr. Sanjay Gupta provide report number in this format. Detail as given below:-

2. SALR5140 - (Sales Details by Interunit Customer )

Please find the attachment.

Detail as given below:-

1. ARMF5065_CUSTOMER_DETAILS.CSV
Comment 10 Sharad 2021-06-08 17:09:25 IST
Created attachment 1938 [details]
ARMF5065_CUSTOMER_SUMMARY


Dear Sir ,

As per discussed with Mr. Sanjay Gupta provide report number in this format. Detail as given below:-

1. SALR6015 - (Sales Summary by Interunit Customer). 
Please find the attachment.

Detail as given below:-

1. ARMF5065_CUSTOMER_SUMMARY
Comment 9 Sharad 2021-06-08 17:06:16 IST
On 08-06-2021 10:18, Sanjay Gupta wrote:

Party ledger account not match with this report.

Plz. check 300759 unit B-59

Thanks & Regards,
Sanjay Gupta
Dharampal Premchand Limited.
Mail-sanjay.gupta@baba.in
Land-line : +91-120-4624600 Extn .:654
Comment 8 Sharad 2021-06-04 14:34:43 IST
Created attachment 1933 [details]
ARMF5065_SUPPLIER_SUMMARY.CSV

Dear Sir ,

As per discussed with Mr. Sanjay Gupta provide report number in this format. Detail as given below:-

3. PURR3010 - (Purchase Summary by Interunit Supplier) & (Purchase Summary by Interunit supplier with Item Detail) {Existing Report}

Please find the attachment.

Detail as given below:-

1. ARMF5065_SUPPLIER_SUMMARY.CSV
Comment 7 Sharad 2021-06-04 14:34:03 IST
Created attachment 1932 [details]
ARMF5065_SUPPLIER_DETAILS.CSV

Dear Sir ,

As per discussed with Mr. Sanjay Gupta provide report number in this format. Detail as given below:-

3. PURR3010 - (Purchase Summary by Interunit Supplier) & (Purchase Summary by Interunit supplier with Item Detail) {Existing Report}

Please find the attachment.

Detail as given below:-

1. ARMF5065_SUPPLIER_DETAILS.CSV
Comment 6 Sharad 2021-06-01 10:31:01 IST
Created attachment 1921 [details]
SS_0893_IMIS_Against call id - 6025


-- Create new table of related group master "LINK_INTERUNIT_PARTIES"

1. SS_0893_IMIS_Against call id - 6025
Comment 5 Sharad 2021-05-31 19:06:16 IST
Dear Sir,

Right given to Mr. Sanjay Gupta (APMF0140 - Group Company Master)..

Please check & confirm.
Comment 4 Sharad 2021-05-31 18:40:49 IST
-- Make master form of related group master. Detail as given below:- 

1. APMF0140 - Related Group Master
Comment 3 Sharad 2021-05-31 18:31:24 IST
Created attachment 1920 [details]
SS_0893_IMIS_Against call id - 6025

-- Create new table of related group master "Link_supplier"

1. SS_0893_IMIS_Against call id - 6025
Comment 2 Sharad 2021-03-25 14:16:53 IST
As per discussed with Mr. Sanjay Gupta provide report number in this format. Detail as given below:- 

1. SALR6015 - (Sale summary by Customer) {Existing Report}
     Column Added 
      a. Customer name
      b. Customer Code
      c. Pan Number
      d. GST Number 
      e. Taxable Amount
      f. IGST Amount
      g. CGST Amount
      h. SGST Amount
      i. Cess Amount
      j. Bill Amount
 
Sale summary by Related Party & Purchase Summary by Related Party {New report will be given}

2. SALR5140 - (Sale Summary by customer, Product Type for All Customer ) {Existing Report}
3. PURR3010 - (Purchase Summary by Supplier) {Existing Report}
     (Purchase Summary by Related Party) {New report will be given}

If any report please provide.
Comment 1 Mahender 2021-03-22 15:48:16 IST
CREATE TABLE LINK_SUPPLIER (CUSTOMER_CODE	VARCHAR2(10) NOT NULL
						  , SUPPLIER_CODE	VARCHAR2(10) NOT NULL
						  , STATUS			VARCHAR2(1) NOT NULL
						  , CREATED_BY		VARCHAR2(10)NOT NULL
						  , CREATED_ON		DATE NOT NULL
						  , LAST_UPD_BY		VARCHAR2(10)
						  , LAST_UPD_ON		DATE
			,CONSTRAINT LINK_SUPP_PK PRIMARY KEY (CUSTOMER_CODE, SUPPLIER_CODE)
			);

1. CREATE NEW FORM  AS COPY ALL_CUSTOMER ONLY FIST BLOCK AND BELOW ADD ABOVE TABLE AND GIVE LOV OF ALL_CUSTOMER TABLE

2. MAKE NEW FORM OF TRAIL BALANCE SAME AS EXISTING ONLY ADD TAB BASE FOR SUPPLIER AND CUSTOMER TRAIL IN ONE FORM
Description Sanjay Gupta 2021-03-12 17:27:14 IST
Dear Mahender

As discussed with you provide the report of sale, purchase & services to & from related parties / group companies (Directory Wise & Consolidated).

also provide LOV & Report as below:

- Company wise sale & purchase
- Period wise sale & purchase
- GSTIN wise sale & purchase
- Consolidated.