Bug 6025

Dear Sir,

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

Please check & confirm.

Dear Sir,

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

Please check & confirm.

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

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

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

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

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

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

Dear Sir,

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

Please check & confirm.

-- Make master form of related group master. Detail as given below:- 

1. APMF0140 - Related Group Master

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

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.

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