Hi,
THE monitory and stastical values entered
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT Rs
C1 D1 L1 P1 A1 1000 0
C1 D1 L1 P1 A2 1800 0
C1 D1 L1 P1 A3 1300 0
C1 D1 L1 P1 A 0 250
C1 D2 L2 P1 A1 1500 0
C1 D2 L2 P1 A1 1600 0
C1 D2 L2 P1 A 0 300
WE WANT FSG LIKE THIS
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT
C1 D1 L1 P1 A1 1000 250
C1 D1 L1 P1 A2 1800 250
C1 D1 L1 P1 A3 1300 250
C1 D1 L1 P1 A 0 250
C1 D2 L2 P1 A1 1500 300
C1 D2 L2 P1 A1 1600 300
C1 D2 L2 P1 A 0 300
OR
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT
C1 D1 L1 P1 A1 1000 250
C1 D1 L1 P1 A2 1800 250
C1 D1 L1 P1 A3 1300 250
C1 D2 L2 P1 A1 1500 300
C1 D2 L2 P1 A1 1600 300
ROWS WITH INR ZERO DO NOT APPEAR
INR RS COLUMN(column 6) THE VALUE OF AMOUNT ENTERED
FOR THE COMBINATION OF COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT
STAT COLUMN IS STASTCAL VALUE FOR THE
COMBINATION OF COMPANY DEPARTMENT LOCATION PRODUCT AND ACCOUNT A
Doubt on FSG
The actuals
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT Rs
C1----- D1------------- L1----------- P1----- A1---- 1000--- 0
C1----- D1------------- L1----------- P1----- A2----- 1800--- 0
C1----- D1------------- L1----------- P1----- A3----- 1300--- 0
C1----- D1------------- L1----------- P1----- A----- 0------ 250
C1----- D2------------- L2----------- P1----- A1----- 1500--- 0
C1----- D2------------- L2----------- P1----- A1----- 1600--- 0
C1----- D2------------- L2----------- P1----- A------ 0-------300
WE WANT FSG LIKE THIS
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT
C1----- D1------------- L1----------- P1----- A1---- 1000--- 250
C1----- D1------------- L1----------- P1----- A2----- 1800--- 250
C1----- D1------------- L1----------- P1----- A3----- 1300--- 250
C1----- D1------------- L1----------- P1----- A----- 0------ 250
C1----- D2------------- L2----------- P1----- A1----- 1500--- 300
C1----- D2------------- L2----------- P1----- A1----- 1600--- 300
C1----- D2------------- L2----------- P1----- A------ 0-------300
OR
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT
C1----- D1------------- L1----------- P1----- A1---- 1000--- 250
C1----- D1------------- L1----------- P1----- A2----- 1800--- 250
C1----- D1------------- L1----------- P1----- A3----- 1300--- 250
C1----- D2------------- L2----------- P1----- A1----- 1500--- 300
C1----- D2------------- L2----------- P1----- A1----- 1600--- 300
THE monitory and stastical values entered
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT Rs
C1----- D1------------- L1----------- P1----- A1---- 1000--- 0
C1----- D1------------- L1----------- P1----- A2----- 1800--- 0
C1----- D1------------- L1----------- P1----- A3----- 1300--- 0
C1----- D1------------- L1----------- P1----- A----- 0------ 250
C1----- D2------------- L2----------- P1----- A1----- 1500--- 0
C1----- D2------------- L2----------- P1----- A1----- 1600--- 0
C1----- D2------------- L2----------- P1----- A------ 0-------300
WE WANT FSG LIKE THIS
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT
C1----- D1------------- L1----------- P1----- A1---- 1000--- 250
C1----- D1------------- L1----------- P1----- A2----- 1800--- 250
C1----- D1------------- L1----------- P1----- A3----- 1300--- 250
C1----- D1------------- L1----------- P1----- A----- 0------ 250
C1----- D2------------- L2----------- P1----- A1----- 1500--- 300
C1----- D2------------- L2----------- P1----- A1----- 1600--- 300
C1----- D2------------- L2----------- P1----- A------ 0-------300
OR
COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT INR Rs STAT
C1----- D1------------- L1----------- P1----- A1---- 1000--- 250
C1----- D1------------- L1----------- P1----- A2----- 1800--- 250
C1----- D1------------- L1----------- P1----- A3----- 1300--- 250
C1----- D2------------- L2----------- P1----- A1----- 1500--- 300
C1----- D2------------- L2----------- P1----- A1----- 1600--- 300
THE monitory and stastical values entered
-
- Posts: 256
- Joined: Thu Aug 07, 2008 3:48 am
- Location: USA
-
- Posts: 59
- Joined: Fri Oct 05, 2007 1:15 am
- Location: Saudi Arabia
Thanks for all,
For our peculiar requirement , I got a solution.
First
with INR for COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT combination FSG is taken. In other FSG, for same COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT combination with STAT curency is taken.
In both the FSGs COMPANY DEPARTMENT LOCATION PRODUCT (excludig ACCOUNT ) are concatnated and a column for stat value is added in first INR FsG through vlookup from STAT FSG>
Thank GOD
For our peculiar requirement , I got a solution.
First
with INR for COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT combination FSG is taken. In other FSG, for same COMPANY DEPARTMENT LOCATION PRODUCT ACCOUNT combination with STAT curency is taken.
In both the FSGs COMPANY DEPARTMENT LOCATION PRODUCT (excludig ACCOUNT ) are concatnated and a column for stat value is added in first INR FsG through vlookup from STAT FSG>
Thank GOD
-
- Posts: 80
- Joined: Sat Feb 21, 2009 11:40 am
- Location: Pakistan
Who is online
Users browsing this forum: Ahrefs [Bot], Google Adsense [Bot] and 1 guest