Bug 6449

Summary: Stock report with opening
Product: [01.IMIS] IMIS STORES AND INVENTORY Reporter: Rajesh kr singh <rajesh.singh>
Component: IMIS INVENTORY FORMS AND REPORTSAssignee: Sharad <sharad.sharma>
Status: RESOLVED USER TO VERIFY    
Severity: enhancement CC: mahender.singh, sharad.sharma
Priority: ---    
Version: unspecified   
Hardware: PC   
OS: Windows   
Database: Module ID:
Attachments: SS_0888_IPOS_Against call id - 6449
SS_0889_IPOS_Against call id - 6449_a
SS_0890_IPOS_Against call id - 6449_b
SS_0894_IMIS_Against call id - 6449

Comment 13 Sharad 2021-06-01 18:27:38 IST
Created attachment 1924 [details]
SS_0894_IMIS_Against call id - 6449

-- Modification in Procedure PKG_SC.TG_SERIALED_STOCK. Negative stock value not calculate as per report POSR5030. Please find the attachment.

1. SS_0894_IMIS_Against call id - 6449
Comment 12 Sharad 2021-05-25 16:36:55 IST
Done

Please check & confirm.
Comment 11 Sharad 2021-05-25 13:37:08 IST
Created attachment 1910 [details]
SS_0890_IPOS_Against call id - 6449_b

-- Modification in Procedure "PKG_SC.TG_SERIALED_STOCK". Please find the attachment.

1. SS_0890_IPOS_Against call id - 6449_b
Comment 10 Sharad 2021-05-25 13:22:13 IST
On 24-05-2021 19:48, Rajesh Singh wrote:

OK, IN R2 ,

STOCK RECD. IN R3 HAS TO BE CORRECTED, PLEASE
Comment 9 Sharad 2021-05-24 18:32:50 IST
Done 

Please check & confirm.
Comment 8 Sharad 2021-05-24 15:08:28 IST
Created attachment 1907 [details]
SS_0889_IPOS_Against call id - 6449_a

-- Modification in Procedure "PKG_SC.TG_SERIALED_STOCK". Please find the attachment.

1. SS_0888_IPOS_Against call id - 6449_a
Comment 7 Sharad 2021-05-24 14:01:53 IST
Dear Mr. Sharad,

 

With reference to below mail –

1)      As per your confirmation sale should be manually  taken in total sale company wise.

2)      Stock transfer as per trial Rs. 5,05,23,574.41, 28 pcs of 303420/0  Purchase return it should be shown in other column  not to be added in stock transfer .

 

Please do the needful

Thanks & Regards

Rajesh Kr. Singh
Comment 6 Sharad 2021-05-24 13:36:24 IST
Done

Please check & confirm.
Comment 5 Sharad 2021-05-23 21:52:51 IST
Dear Mr. Rajesh,

I informed to you that no Diff. in figures as per report & trial balance  ( 01.04.20 to 31.03.21 )

Opening stock 

1219 32754328.15                                Self rectified 

2)- Purchase– 1400 pcs value 2,04,28,533.38     1400 pcs value 2,25,67,128.49 
                                                (Done)
3) sale 2463 pcs value 9,19,23,908.31 
for main Store
sale 3 pcs value 76,271.18
for Discount store                              
Total sale 2466 pcs  value  9,20,00,179.49      2463 pcs value 9,20,00,179.49

4)- Stock Transfer 1369 Pcs Value 5,05,23,574.41
 inter store Transfer 28 pcs value 3,03,420.00
Total Srock Transfer 1397 pcs value 5,08,26,994.41                                  1397 pcs value 5,05,23,574.41
Comment 4 Sharad 2021-05-23 21:43:11 IST
Created attachment 1906 [details]
SS_0888_IPOS_Against call id - 6449

-- Modification in view "VW_TG_STOCK_DETAIL". Please find the attachment.

1. SS_0888_IPOS_Against call id - 6449
Comment 3 Sharad 2021-05-23 21:39:04 IST
Dear Sharad, 

Diff. in figures as per report & trial balance  ( 01.04.20 to 31.09.21 )

    Opening stock                                                                                                              As per Trial Balance -

1219
	

32754328.15

2)-  Purchase – 1400 pcs  value 2,04,28,533.38                                                    1400 pcs  value 2,25,67,128.49


3) sale 2663 pcs  value 9,19,23,908.31                                                                      2463 pcs  value 9,20,00,179.49

4)- Srock Transfer 1397 pcs value 5,08,26,994.41                                                 1397 pcs value 5,05,23,574.41

Please check & do the needful, urgent
 

Thanks & Regards
Rajesh Kr. Singh
Comment 2 Sharad 2021-05-22 00:52:26 IST
Done 

Please check & confirm.
Comment 1 Sharad 2021-05-22 00:51:47 IST
-- Modification in form - "POSF5025 - (TG) Stock Position - With Opening, Breakup"
Description Rajesh kr singh 2021-05-21 15:15:54 IST
Dear Sharad 

as discussed please check & confirm the consolidated ( main + all other stock locations)  stock report with opening ,transactions and closing stock  

consolidated report R1 & R2 , and unit wise consolidate also.

please do the needful