Purchase order analysis
The client required faster Purchase pending order report
from tally using analytics for its entire Tally data over 15 years.
The purchase order pending report has the following TDL code
The end client desired a single fast view for Purchase order
pending across 15 years of Tally data from multiple companies. The client
desired to minimize the impact of split of the companies and have very fast
multiple reports on a single screen. The following collections of Purchase
order pending were made into a single table for the purpose of the project.
a.) PendingStkGrpPurcOrderExtractSrc
b.) PendingStkGrpPurcOrderDetailsSrc
c.) OpeningStkGrpPendingPurcOrderDetailsSrc
d.) PendingStkGrpPurchaseOrdersSrc
e.) PendingStkGrpPurchasePendingOrderDetails
f.) PurchaseOrderSourcePnd
g.) PurchaseOrderSourceOp
h.) PendingGroupPurchasePendingOrderDetails
i.) PurchaseOrderLedgerDetailsExtract
j.) PendingLedPurchaseOrderDetailsSrc
k.) PendingGrouppurchaseOrdersSrc
l.) PendingLedPurchaseClearedOrderDetails
m.) PendingpurchaseOrderExtractSrc
n.) PendingPurchaseOrderDetailsSrc
o.) OpeningPurchaseSalesOrdersSrc
p.) OpeningPendingpurchasePendingOrderDetails
Filter Parameters- The report is filtered by Item Name, Party
Name, and Date. These are report level filter and page level filter is
Vouchertypeparent= Purchase order
Fields-
Order Number
Item Name
Party Name
Tracking ID
Purchase Order Quantity
PreClosed Quantity
Purchase Invoiced Quantity
Rate
Pending Quantity
Pending purchase quantity:
DAX Code
Preclosed_qty
=
This shows the preclosed order quantity
by partyname, companyname, orderno and stockitemname. We have used the row
level and filter level contexts for the same. The analysis has been done at
stockitem batch inventory movement details
/*This shows the total purchase
quantity per orderno*/
vAR PARTYNAME=Stockitembatchinventorydetails[partyname]
vAR COMPANYNAME=Stockitembatchinventorydetails[Company_Name]
VAR ORDER_NO=Stockitembatchinventorydetails[OrderNo]
VAR STOCKITEMNAME=Stockitembatchinventorydetails[StockItemName]
VAR Purchase_order=Calculate(sum(Stockitembatchinventorydetails[Billedqty]),FILTER(ALL(Stockitembatchinventorydetails),Stockitembatchinventorydetails[partyname]=PARTYNAME
&& Stockitembatchinventorydetails[Company_Name]=COMPANYNAME
&&Stockitembatchinventorydetails[StockItemName]=STOCKITEMNAME
&& Stockitembatchinventorydetails[OrderNo]=ORDER_NO
&& Stockitembatchinventorydetails[VoucherTypeParent]="Purchase
Order"))
VAR Purchase_qty=Calculate(sum(Stockitembatchinventorydetails[Billedqty]),FILTER(ALL(Stockitembatchinventorydetails),Stockitembatchinventorydetails[partyname]=PARTYNAME
&& Stockitembatchinventorydetails[Company_Name]=COMPANYNAME
&&Stockitembatchinventorydetails[StockItemName]=STOCKITEMNAME
&& Stockitembatchinventorydetails[OrderNo]=ORDER_NO
&& Stockitembatchinventorydetails[VoucherTypeParent]="Purchase"))
VAR PREORDER_CLOSE=Calculate(sum(Stockitembatchinventorydetails[Orderpreclosureqty_num]),FILTER(ALL(Stockitembatchinventorydetails),Stockitembatchinventorydetails[partyname]=PARTYNAME
&& Stockitembatchinventorydetails[Company_Name]=COMPANYNAME
&&Stockitembatchinventorydetails[StockItemName]=STOCKITEMNAME
&& Stockitembatchinventorydetails[OrderNo]=ORDER_NO))
RETURN
IF(PURCHASE_QTY>PURCHASE_ORDER,-PURCHASE_QTY+PURCHASE_ORDER,PREORDER_CLOSE)
net
qty purchase = This is the difference between billed
quantity and pre closed quantity
var a
=Stockitembatchinventorydetails[Billedqty]
var b
=Stockitembatchinventorydetails[Preclosed_qty]
var c=(a-b)
return
c
partyname
= Here we look up the party name from voucher
inventory based on item name, company name and masterid.
LOOKUPVALUE('Stockitem_view'[Partyledgername],'Stockitem_view'[ItemName],Stockitembatchinventorydetails[STOCKITEMNAME],'Stockitem_view'[Masterid],Stockitembatchinventorydetails[Masterid],'Stockitem_view'[Companyname],Stockitembatchinventorydetails[Company_Name])
Pending_purchase_order_quantity
= This shows the total pending purchase quantity by
each party name, company name, Order no, Item name
vAR PARTYNAME=Stockitembatchinventorydetails[partyname]
vAR COMPANYNAME=Stockitembatchinventorydetails[Company_Name]
VAR ORDER_NO=Stockitembatchinventorydetails[OrderNo]
VAR STOCKITEMNAME=Stockitembatchinventorydetails[StockItemName]
VAR Purchase_order=Calculate(sum(Stockitembatchinventorydetails[Billedqty]),FILTER(ALL(Stockitembatchinventorydetails),Stockitembatchinventorydetails[partyname]=PARTYNAME
&& Stockitembatchinventorydetails[Company_Name]=COMPANYNAME
&&Stockitembatchinventorydetails[StockItemName]=STOCKITEMNAME
&& Stockitembatchinventorydetails[OrderNo]=ORDER_NO
&& Stockitembatchinventorydetails[VoucherTypeParent]="Purchase
Order"))
VAR Purchase_qty=Calculate(sum(Stockitembatchinventorydetails[Billedqty]),FILTER(ALL(Stockitembatchinventorydetails),Stockitembatchinventorydetails[partyname]=PARTYNAME
&& Stockitembatchinventorydetails[Company_Name]=COMPANYNAME
&&Stockitembatchinventorydetails[StockItemName]=STOCKITEMNAME
&& Stockitembatchinventorydetails[OrderNo]=ORDER_NO
&& Stockitembatchinventorydetails[VoucherTypeParent]="Purchase"))
VAR PREORDER_CLOSE=Calculate(sum(Stockitembatchinventorydetails[Orderpreclosureqty_num]),FILTER(ALL(Stockitembatchinventorydetails),Stockitembatchinventorydetails[partyname]=PARTYNAME
&& Stockitembatchinventorydetails[Company_Name]=COMPANYNAME
&&Stockitembatchinventorydetails[StockItemName]=STOCKITEMNAME
&& Stockitembatchinventorydetails[OrderNo]=ORDER_NO))
RETURN
If(Purchase_order-if(isblank(Purchase_qty),0,Purchase_qty)-IF(ISBLANK(PREORDER_CLOSE),0,PREORDER_CLOSE)<0,0,Purchase_order-if(isblank(Purchase_qty),0,Purchase_qty)-IF(ISBLANK(PREORDER_CLOSE),0,PREORDER_CLOSE))
Trackingnumber_voucherinventory
= We pick the tracking number based on the master id
vAR A=Stockitembatchinventorydetails[MasterID]
VAR B=CALCULATE(MIN(Stockitem_view[Trackingnumber_voucherinventory]),FILTER(ALL(STOCKITEM_VIEW),Stockitem_view[MasterID]=A))
RETURN
B
Appendix A
;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri
Durgaji : Sri Venkateshwara
<DefType: Collection>
/*
Collection
PendingPurcOrderGroupDetailsExtract
used in
Purchase Order Group outstanding report
to
calculate Opening, Inward, Outward and Closing Orders
*/
[Collection: PendingPurcOrderGroupDetailsExtract]
Source
Collection :
PendingGroupPurcOrderDetailsSrc, OpeningGroupPendingPurcOrderDetailsSrc
Source
Var :
svOpeningBalance :
Quantity : If $IsOpeningColl
Then $OpeningBalance Else $$InitValue:"Quantity"
Source
Var :
svOpeningValue :
Amount : If $IsOpeningColl
Then $OpeningValue Else $$InitValue:"Amount"
Source
Var :
svInwardQty :
Quantity : If $IsOpeningColl
Then $$InitValue:"Quantity" Else
$InwardQty
Source
Var :
svInwardValue :
Amount : If $IsOpeningColl
Then $$InitValue:"Amount" Else $InwardValue
Source
Var :
svClosingBalance :
Quantity : If $IsOpeningColl
Then $$InitValue:"Quantity" Else $ClosingBalance
Source
Var :
svClosingValue :
Amount : If $IsOpeningColl
Then $$InitValue:"Amount" Else
$ClosingValue
Source
Var :
svOutwardQty :
Quantity :
$$NettQty:($$NettQty:##svOpeningBalance:##svInwardQty):$$Negative:##svClosingBalance
Source
Var :
svOutwardValue :
Amount :
$$NettAmount:($$NettAmount:##svOpeningValue:##svInwardValue):$$Negative:##svClosingValue
By :
Parent :
$Parent
Aggr
Compute : OpeningBalance :
Sum : ##svOpeningBalance
Aggr Compute : OpeningValue :
Sum : ##svOpeningValue
Aggr
Compute : InwardQty :
Sum : ##svInwardQty
Aggr
Compute : InwardValue :
Sum : ##svInwardValue
Aggr
Compute : OutwardQty :
Sum : ##svOutwardQty
Aggr
Compute : OutwardValue :
Sum : ##svOutwardValue
Aggr
Compute : ClosingBalance :
Sum : ##svClosingBalance
Aggr
Compute : ClosingValue :
Sum : ##svClosingValue
Search
Key : $Parent
/*
The
Collections
1.
PendingGroupPurcOrderDetailsSrc
2.
PendingGroupPurcOrdersSrc
3.
PendingGroupPurcPendingOrderDetails
4.
PendingGroupPurcClearedOrderDetails
used in
Purchase Order Group outstanding report
to
calculate Inward and Closing Orders
*/
[Collection: PendingGroupPurcOrderDetailsSrc]
Source
Collection :
PendingGroupPurcOrdersSrc
By :
Parent :
$Parent
Compute :
IsOpeningColl :
No
Aggr
Compute : InwardQty :
Sum : If
@@ForOrderPeriod Then ($PurchaseOrderQty) Else $$InitValue:"Quantity"
Aggr
Compute : InwardValue :
Sum : If @@ForOrderPeriod Then
($PurOpeningActualValue) Else $$InitValue:"Amount"
Aggr
Compute : ClosingBalance :
Sum : $ClosingBalance
Aggr
Compute : ClosingValue :
Sum : $ClosingValue
[Collection: PendingGroupPurcOrdersSrc]
Collection :
PendingGroupPurcPendingOrderDetails, PendingGroupPurcClearedOrderDetails
[Collection: PendingGroupPurcPendingOrderDetails]
Type : Purchase Orders
Filter : IsItemBelongstoSelectedAccGrp
Filter : PositiveClosingBalance
Cleared : No
[Collection: PendingGroupPurcClearedOrderDetails]
Type : Purchase Orders
Filter : IsItemBelongstoSelectedAccGrp
Filter : PositiveClosingBalance
Cleared : Yes
/*
The
Collections
1.
OpeningGroupPendingPurcOrderDetailsSrc
2.
OpeningGroupPendingPurcOrdersSrc
3.
GroupPurcPendingOrderDetails
4.
GroupPurcClearedOrderDetails
used in
Purchase Order Group outstanding report
to
calculate Opening Orders
*/
[Collection: OpeningGroupPendingPurcOrderDetailsSrc]
Source
Collection :
OpeningGroupPendingPurcOrdersSrc
By :
Parent :
$Parent
Compute :
IsOpeningColl :
Yes
Aggr
Compute : OpeningBalance :
Sum : $ClosingBalance
Aggr
Compute : OpeningValue :
Sum : $ClosingValue
[Collection: OpeningGroupPendingPurcOrdersSrc]
Parm
Var : SVToDate : Date :
@@OpeningOrderToDate
Collection : GroupPurcPendingOrderDetails
[Collection: GroupPurcPendingOrderDetails]
Parm
Var : SVToDate : Date : @@OpeningOrderToDate
Type : Purchase Orders
Cleared : No
Filter : IsItemBelongstoSelectedAccGrp
Filter : PositiveClosingBalance
;;Calculation Of Purchase Order Ledger Outstanding Report
/*
Collection
PurcOrderLedgerDetailsExtract
used in
Purchase Order Ledger outstanding report
to
calculate Opening, Inward, Outward and Closing Orders
*/
[Collection: PurcOrderLedgerDetailsExtract]
Source
Collection :
PendingLedPurcOrderDetailsSrc, OpeningLedPendingPurcOrderDetailsSrc
Source
Var :
svOpeningBalance :
Quantity : If $IsOpeningColl
Then $OpeningBalance Else $$InitValue:"Quantity"
Source
Var :
svOpeningValue :
Amount : If $IsOpeningColl
Then $OpeningValue Else $$InitValue:"Amount"
Source
Var :
svInwardQty :
Quantity : If $IsOpeningColl
Then $$InitValue:"Quantity" Else
$InwardQty
Source
Var :
svInwardValue :
Amount : If $IsOpeningColl
Then $$InitValue:"Amount" Else $InwardValue
Source
Var :
svClosingBalance :
Quantity : If $IsOpeningColl
Then $$InitValue:"Quantity" Else $ClosingBalance
Source
Var :
svClosingValue :
Amount : If $IsOpeningColl
Then $$InitValue:"Amount" Else
$ClosingValue
Source
Var :
svOutwardQty :
Quantity :
$$NettQty:($$NettQty:##svOpeningBalance:##svInwardQty):$$Negative:##svClosingBalance
Source
Var :
svOutwardValue :
Amount :
$$NettAmount:($$NettAmount:##svOpeningValue:##svInwardValue):$$Negative:##svClosingValue
By :
Parent :
$Parent
Compute : TrackLedger : $TrackLedger
Aggr
Compute : OpeningBalance :
Sum : ##svOpeningBalance
Aggr
Compute : OpeningValue :
Sum : ##svOpeningValue
Aggr
Compute : InwardQty :
Sum : ##svInwardQty
Aggr
Compute : InwardValue :
Sum : ##svInwardValue
Aggr
Compute : OutwardQty :
Sum : ##svOutwardQty
Aggr
Compute : OutwardValue :
Sum : ##svOutwardValue
Aggr
Compute : ClosingBalance :
Sum : ##svClosingBalance
Aggr
Compute : ClosingValue :
Sum : ##svClosingValue
Search
Key : $Parent
/*
The
Collections
1.
PendingLedPurcOrderDetailsSrc
2.
PendingLedPurcOrdersSrc
3.
PendingLedPurcPendingOrderDetails
4.
PendingLedPurcClearedOrderDetails
used in
Purchase Order Ledger outstanding report
to calculate
Inward and Closing Orders
*/
[Collection: PendingLedPurcOrderDetailsSrc]
Source
Collection :
PendingLedPurcOrdersSrc
By :
Parent :
If $TrackLedger = ##LedgerName Then $Parent
Else ""
Compute : TrackLedger : $TrackLedger
Compute :
IsOpeningColl :
No
Aggr
Compute : InwardQty :
Sum : If
@@ForOrderPeriod Then ($PurchaseOrderQty) Else $$InitValue:"Quantity"
Aggr
Compute : InwardValue :
Sum : If
@@ForOrderPeriod Then ($PurOpeningActualValue) Else
$$InitValue:"Amount"
Aggr
Compute : ClosingBalance :
Sum : $ClosingBalance
Aggr
Compute : ClosingValue :
Sum : $ClosingValue
[Collection: PendingLedPurcOrdersSrc]
Collection : PendingLedPurcPendingOrderDetails,
PendingLedPurcClearedOrderDetails
[Collection: PendingLedPurcPendingOrderDetails]
Type : Ledger Purchase Orders
Child
Of : ##LedgerName
Filter : PositiveClosingBalance
Cleared : No
[Collection: PendingLedPurcClearedOrderDetails]
Type : Ledger Purchase Orders
Child
Of : ##LedgerName
Filter : PositiveClosingBalance
Cleared : Yes
/*
The
Collections
1.
OpeningLedPendingPurcOrderDetailsSrc
2.
OpeningLedPendingPurcOrdersSrc
3.
LedPurcPendingOrderDetails
4.
LedPurcClearedOrderDetails
used in
Purchase Order Ledger outstanding report
to
calculate Opening Orders
*/
[Collection: OpeningLedPendingPurcOrderDetailsSrc]
Source
Collection :
OpeningLedPendingPurcOrdersSrc
By :
Parent :
If $TrackLedger = ##LedgerName Then $Parent
Else ""
Compute : TrackLedger : $TrackLedger
Compute :
IsOpeningColl :
Yes
Aggr
Compute : OpeningBalance :
Sum : $ClosingBalance
Aggr
Compute : OpeningValue :
Sum : $ClosingValue
[Collection: OpeningLedPendingPurcOrdersSrc]
Parm
Var : SVToDate : Date :
@@OpeningOrderToDate
Collection : LedPurcPendingOrderDetails
[Collection: LedPurcPendingOrderDetails]
Parm
Var : SVToDate : Date :
@@OpeningOrderToDate
Type : Ledger Purchase Orders
Child
Of : ##LedgerName
Cleared : No
Filter : PositiveClosingBalance
;; End-of-file
Appendix B
List of collections
;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri
Durgaji : Sri Venkateshwara
<DefType: Collection>
;; The below collection used to filter the voucher type list
belongs to parent voucher type specified in VoucherTypeName variable.
[Collection: Specific VoucherTypeList]
Type : VoucherType
Child
Of : ##VoucherTypeName
Belongs
To : ##FamilyVoucherFlag
Fetch : UseForJobwork,
IsForJobWorkIn, StatVal, CancVal
[Collection: PO Ledger Browser]
<unitgroup:orderoutstandings>
Use :
List of Ledgers
Title : $$LocaleString:"List of
Ledgers"
Parm
Var : GroupCash : String : $$GroupCash
Parm
Var : GroupBank : String : $$GroupBank
Parm
Var : GroupBankOD : String : $$GroupBankOD
Parm
Var : GroupSundryDebtors : String : $$GroupSundryDebtors
Parm
Var : GroupSundryCreditors : String : $$GroupSundryCreditors
Parm
Var : GroupBranches : String : $$GroupBranches
Fetch : Name
Fetch : ReserveName
Variable : Ledger Name
Report : PO Ledger
Trigger : POLedger Outstandings Browser
Filter : IsPartyAccountVchRE
[Collection: PO Ledger]
<unitgroup:orderoutstandings>
Use : Extract Alias Collection
Title : $$LocaleString:"List of
Ledgers"
Parm
Var : GroupCash : String : $$GroupCash
Parm
Var : GroupBank : String : $$GroupBank
Parm
Var : GroupBankOD : String : $$GroupBankOD
Parm
Var : GroupSundryDebtors : String : $$GroupSundryDebtors
Parm
Var : GroupSundryCreditors : String : $$GroupSundryCreditors
Parm
Var : GroupBranches : String : $$GroupBranches
Source
Collection : List of Ledgers
Fetch : Name
Fetch : ReserveName
Variable : Ledger Name
Report : PO Ledger
Trigger : POLedger Outstandings
Filter : IsPartyAccountVchRE
[Collection: PO Group]
<unitgroup:orderoutstandings>
Use : ExtractAlias Collection
Title : $$LocaleString:"List
of Groups"
Parm
Var : GroupCash : String : $$GroupCash
Parm
Var : GroupBank : String : $$GroupBank
Parm
Var : GroupBankOD : String : $$GroupBankOD
Parm
Var :
GroupSundryDebtors : String : $$GroupSundryDebtors
Parm
Var : GroupSundryCreditors : String : $$GroupSundryCreditors
Parm
Var : GroupBranches : String : $$GroupBranches
Source
Collection : List of Groups
Fetch : Name
Fetch : ReserveName
Variable : Group Name
Report : PO Group
Trigger : POGroup Outstandings
Filter : IsPartyAccountVchRE
[Collection: OrderMethodTable]
Title : $$LocaleString:"Particulars"
Object : OrderMethodName
Object : OrderMethodStockName
Object : OrderMethodDate
Object : OrderMethodLedgerName
Object : OrderMethodGodownName
Object : OrderMethodBatchName
Object : OrderMethodOpeningBalance
Object : OrderMethodClosingBalance
Object : OrderMethodClosingValue
Align : Centre
Format : $UserMethodName,15
Client
Only : Yes
Option : OrderBilledMethod : ##ShowBilledQty
[!Collection:
OrderBilledMethod]
Add : Object :
OrderMethodBilledQty
Delete : Format
Add : Format : $UserMethodName,18
[Collection: DSPOrderAgeColumns]
Title :
$$LocaleString:"Ageing Methods"
Object :
DSPOrderAgeWise, DSPOrderDueAgeWise
ClientOnly : Yes
[Collection: SaleCldOrderOfCompany]
Use : SalePosOrderOfCompany
Delete : Source Collection : SalePosOrderOfCompany Src
Add : Source
Collection :
SaleCldOrderOfCompany Src
Search
Key : $OrderID
[Collection: SaleCldOrderOfCompany Src]
Use :
SalePosOrderOfCompany Src
Collection : SaleCldNegOrderOfCompany
Cleared : Yes
Delete : Filter : PositiveClosingBalance
Delete : Filter : OrderDueOnlyFilter
[Collection: SaleCldNegOrderOfCompany]
Use : SalePosOrderOfCompany
Delete : Source Collection : SalePosOrderOfCompany Src
Add : Source
Collection :
SaleNegOrderOfCompany Src
Filter : IsEmptyNegNettBal
[Collection: SaleNegOrderOfCompany]
Use :
AllOrderTemplate
Source
Collection :
SaleNegOrderOfCompany Src
Option :
OrderSalePosOrderOfCompany :
##OrderOutstanding
Option :
SaleNegOrderOfCompany Browser :
$$InMobileBrowserExport
Filter :
IsNOTEmptyNegNettBal
[!Collection: SaleNegOrderOfCompany Browser]
Compute :
BrOverdueDays : @@OrderOverDue
Compute : BrDueDays : $$Date:$OrderDueDate
Compute :
BrOrigQty :
@@BrOriginalQty
[Collection: SaleNegOrderOfCompany Src]
Use :
SalePosOrderOfCompany Src
Delete : Filter : PositiveClosingBalance
Add : Filter :
NegativeClosingBalance
[Collection: SalePosOrderOfCompany Src]
Type : Sales Orders
Filter : PositiveClosingBalance,
OrderDueOnlyFilter
Filter : OrderOfStockItemName,
OrderOfLedgerName, OrderWithinDateFilter
[Collection: PurcCldOrderOfCompany]
Use : PurcPosOrderOfCompany
Delete : Source Collection : PurcPosOrderOfCompany Src
Add : Source
Collection :
PurcCldOrderOfCompany Src
Search
Key : $OrderID
[Collection: PurcCldOrderOfCompany Src]
Use : PurcPosOrderOfCompany
Src
Collection : PurcCldNegOrderOfCompany
Cleared : Yes
Delete : Filter : PositiveClosingBalance
Delete : Filter : OrderDueOnlyFilter
[Collection : PurcCldNegOrderOfCompany]
Use :
PurcPosOrderOfCompany
Delete : Source Collection : PurcPosOrderOfCompany Src
Add : Source
Collection :
PurcNegOrderOfCompany Src
Filter : IsEmptyNegNettBal
[Collection: PurcPosOrderOfCompany]
Use :
AllOrderTemplate
Source
Collection :
PurcPosOrderOfCompany Src
Compute :
PurchaseOrderQty :
$OrderOpeningBalance
Option :
POBilledQty :
##CmpHasDiffActualQty
Option :
OrderSalePosOrderOfCompany :
##OrderOutstanding
Option :
PurcPosOrderOfCompany Browser :
$$InMobileBrowserExport
[!Collection: PurcPosOrderOfCompany Browser]
Compute :
BrOverdueDays : @@OrderOverDue
Compute :
BrDueDays : $$Date:$OrderDueDate
Compute :
BrOrigQty :
@@BrOriginalQty
[!Collection:
POBilledQty]
Fetch : OrderBilledQty
Compute : PurchaseOrderBilledQty : $OrderBilledQty
[!Collection:
OrderSalePosOrderOfCompany]
Add
: Filter :
IsOrderBelongstoSelectedAccGrp
[Collection: PurcNegOrderOfCompany]
Use :
AllOrderTemplate
Source
Collection : PurcNegOrderOfCompany
Src
Filter :
IsNOTEmptyNegNettBal
Option :
PurcNegOrderOfCompany Browser :
$$InMobileBrowserExport
[!Collection: PurcNegOrderOfCompany Browser]
Compute :
BrOverdueDays : @@OrderOverDue
Compute :
BrDueDays : $$Date:$OrderDueDate
Compute :
BrOrigQty :
@@BrOriginalQty
[Collection: PurcNegOrderOfCompany Src]
Type : PurchaseOrders
Fetch : OrderPreclosureQty,
OrderPreclosureDate, OrderClosureReason
Filter : NegativeClosingBalance,
OrderDueOnlyFilter
Filter : OrderOfStockItemName,
OrderOfLedgerName, OrderWithinDateFilter
[Collection: IndentPIsofCompany]
Type :
Indent
Child
of : ##StockItemName
Filter : OrderOfStockItemName, WithinDateFilter
Filter : PositiveClosingBalance,
IndentDueOnlyFilter
[Collection: SalePosOrderOfCompany]
Use :
AllOrderTemplate
Source
Collection :
SalePosOrderOfCompany Src
Compute :
SaleOrderQty :
$OrderOpeningBalance
Option :
SOBilledQty :
##CmpHasDiffActualQty
Option :
OrderSalePosOrderOfCompany :
##OrderOutstanding
Option :
SalePosOrderOfCompany Browser :
$$InMobileBrowserExport
[!Collection: SalePosOrderOfCompany Browser]
Compute :
BrOverdueDays : @@OrderOverDue
Compute :
BrDueDays : $$Date:$OrderDueDate
Compute :
BrOrigQty :
@@BrOriginalQty
[!Collection:
SOBilledQty]
Fetch : OrderBilledQty
Compute : SaleOrderBilledQty : $OrderBilledQty
[Collection: OpeningBalanceNettSalesOrderDetails]
Source
Collection :
OpeningBalanceNettSalesOrderDetailsSrc
By :
Parent : "AllStk"
Aggr
Compute :
OriginalQuantity :
Sum :
$$CollQtyTotal:ledgerEntries:@@CalcOrdrQty1
Aggr
Compute : OrigBilled
Quantity : Sum : $$CollQtyTotal:ledgerEntries:@@CalcOrdrQty3
Aggr
Compute :
PendingQuantity :
Sum : $ClosingBalance
Aggr
Compute : PendingValue :
Sum : $ClosingValue
Search
Key :
$Parent
[Collection: OpeningBalanceNettSalesOrderDetailsSrc]
Type : Sales Orders
Cleared : No
Child
Of : ##StockItemName
Filter : PositiveClosingBalance,
OrderLedWiseOpBal
[Collection: OpeningBalanceNettPurOrderDetails]
Source
Collection :
OpeningBalancePurPendingOrderDetailsSrc
By :
Parent : "AllStk"
Aggr
Compute : OriginalQuantity :
Sum :
$$CollQtyTotal:ledgerEntries:@@CalcOrdrQty1
Aggr
Compute :
OrigBilledQuantity :
Sum :
$$CollQtyTotal:LedgerEntries:@@CalcOrdrQty3
Aggr
Compute :
PendingQuantity :
Sum : $ClosingBalance
Aggr
Compute : PendingValue :
Sum : $ClosingValue
Search
Key :
$Parent
[Collection: OpeningBalancePurPendingOrderDetailsSrc]
Type : Purchase Orders
Cleared : No
Child
Of : ##StockItemName
Filter : PositiveClosingBalance,
OrderLedWiseOpBal
[Collection: PartialPendingPurOrdCldQuantityDetails]
Source
collection: PartialPendingPurOrdCldQuantitySrc
WALK : Ledger Entries
Compute
Var : LedEntryDate : Date : $Date
Compute
Var :
IsWithinDateRange : Logical : (##LedEntryDate >=
@@DSPFromDate AND ##LedEntryDate <= @@DSPToDate)
By :
Parent :
If ##IsWithinDateRange Then $$Owner:$Parent Else ""
By :
ClearedOrderDate : If ##IsWithinDateRange Then ##LedEntryDate Else ""
Filter
: OrderEmptyParent
[Collection: PartialPendingPurOrdCldQuantitySrc]
Type : Purchase Orders
Cleared : Yes
Child
Of : ##StockItemName
Filter : PositiveClosingBalance ,
OrderLedWiseOpBal
Filter : PrevOrderWithinDate
[Collection: PurOrderPendingSummaryColl]
Source
Collection :
PurOrderPendingSummaryCollSrc
By :
Parent :
$Parent
Aggr
Compute :
ClearedQuantity :
SUM :
$PendingQuantity
Aggr
Compute : ClearedValue :
SUM :
$PendingValue
Aggr
Compute :
PendingQuantity :
SUM : If $$Date:$Date
<= (@@DSPFromDate -1) Then $PendingQuantity Else
$$InitValue:"Quantity"
Aggr
Compute : PendingValue :
SUM : If $$Date:$Date
<= (@@DSPFromDate -1) Then $PendingValue Else
$$InitValue:"Quantity"
Search
Key : $Parent
[Collection: PurOrderPendingSummaryCollSrc]
Source
Collection :
PartialPendingPurOrdQuantitySrc
Compute
Var :
svOpeningQuantity :
Quantity : If
$$IsEmpty:$PurchaseOrderQty Then $$InitValue:"Quantity" Else
$PurchaseOrderQty
By :
Date :
$Date
By :
Parent :
$Parent
Aggr
Compute :
PendingQuantity :
Sum : If
##svOpeningQuantity = $ClosingBalance
Then $$InitValue:"Quantity" Else $ClosingBalance
Aggr
Compute : PendingValue :
Sum : If
##svOpeningQuantity = $ClosingBalance
Then $$InitValue:"Amount" Else $ClosingValue
Search
Key : $Parent
[Collection: PartialPendingPurOrdQuantitySrc]
Type : Purchase Orders
Cleared : No
Child
Of : ##StockItemName
Filter : PositiveClosingBalance, OrderLedWiseOpBal
[Collection: PartialPendingQPurOrdQtySrcDetails]
Source
Collection :
PartialPendingPurOrdQuantitySrc
By :
Parent : $Parent
Aggr
Compute :
PendingQuantity :
Sum : $ClosingBalance
Aggr
Compute : PendingValue :
Sum : $ClosingValue
Search
Key :
$Parent
[Collection: PartialPendingSaleOrdCldQuantityDetails]
Source
collection: PartialPendingSaleOrdCldQuantitySrc
WALK : Ledger Entries
Compute
Var : LedEntryDate : Date : $Date
Compute
Var : IsWithinDateRange : Logical :
(##LedEntryDate >= @@DSPFromDate AND ##LedEntryDate <= @@DSPTODate)
By :
Parent :
If ##IsWithinDateRange Then $$Owner:$Parent Else ""
By :
CleareddOrderDate : If ##IsWithinDateRange Then ##LedEntryDate Else ""
Filter :
OrderEmptyParent
[Collection: PartialPendingSaleOrdCldQuantitySrc]
Type : Sales Orders
Cleared : Yes
Child
Of : ##StockItemName
Filter : PositiveClosingBalance,
OrderLedWiseOpBal
Filter : PrevOrderWithinDate
[Collection: SalesOrderPendingSummaryColl]
Source
Collection :
SalesOrderPendingSummaryCollSrc
By :
Parent :
$Parent
Aggr
Compute :
ClearedQuantity :
SUM :
$PendingQuantity
Aggr
Compute : ClearedValue :
SUM :
$PendingValue
Aggr
Compute :
PendingQuantity :
Sum : If $$Date:$Date
<= (@@DSPFromDate -1) Then $PendingQuantity Else
$$InitValue:"Quantity"
Aggr
Compute : PendingValue :
Sum : If $$Date:$Date
<= (@@DSPFromDate -1) Then $PendingValue Else $$InitValue:"Quantity"
Search
Key : $Parent
[Collection: SalesOrderPendingSummaryCollSrc]
Source
Collection : Partial
PendingQuantitySrc
Compute
Var :
svOpeningQuantity :
Quantity : If
$$IsEmpty:$SaleOrderQty Then $$InitValue:"Quantity" Else
$SaleOrderQty
By :
Date :
$Date
By :
Parent :
$Parent
Aggr
Compute :
PendingQuantity :
Sum : If
##svOpeningQuantity = $ClosingBalance
Then $$InitValue:"Quantity" Else $ClosingBalance
Aggr
Compute : PendingValue :
Sum : If
##svOpeningQuantity = $ClosingBalance
Then $$InitValue:"Amount" Else $ClosingValue
Search
Key : $Parent
[Collection: Partial PendingQuantitySrc]
Type : Sales Orders
Cleared : No
Child
Of : ##StockItemName
Filter : PositiveClosingBalance,
OrderLedWiseOpBal
[Collection: Partial PendingQuantitySrcDetails]
Source
Collection : Partial
PendingQuantitySrc
By :
Parent : $Parent
Aggr
Compute :
PendingQuantity :
Sum : $ClosingBalance
Aggr
Compute : PendingValue :
Sum : $ClosingValue
Search
Key :
$Parent
[Collection: SRC Coll For Order ClosureNeg]
Source
Collection : MainSRC CollForOrder
ClosureNeg
KeepSource :
().
Fetch :
Name,Parent,TrackLedger,OrderDueDt,OrderBatch,OrderGodown
Fetch :
Date,StockItemName,ClosingBalance,PreClosureQty,Rate,ClosingValue,OrderPreclosureQty,Discount
Fetch : OrigQty
Client
Only : Yes
[Collection: MainSRC CollForOrder ClosureNeg]
Source
Collection : DATA For
OrderClosure
Fetch : Name, TrackLedger,
Parent, OrderDueDate, GodownName, BatchName, ClosingBalance, Rate,
ClosingValue, Discount
By :
Name :
$Name
By :
Parent :
$Parent
By :
TrackLedger :
$TrackLedger
By :
OrderDueDt :
$OrderDueDate
By : OrderBatch : $BatchName
By :
OrderGodown : $GodownName
By :
Date :
$Date
Compute : StockItemName : $Parent ;;This
is required to create dependency...without this focus of closing balance field
is not going to next field.
Compute : ClosingBalance : $ClosingBalance
Compute : PreClosureQty : $ClosingBalance
Compute : OrigQty :
@@OrdOrigQty
Compute : Rate :
$Rate
Compute : ClosingValue : $ClosingValue
Compute :
OrderPreclosureQty: $OrderPreclosureQty
Compute : Discount : $Discount
Filter : IsEmptyOrigQty,
NotEmptyOrder, FCORDPendingNegZeroPndgQty
Client
Only : Yes
[Collection: SRC Coll For Order Closure]
Source
Collection : MainSRC CollForOrder
Closure
KeepSource :
().
Fetch : Name,Parent,TrackLedger,OrderDueDt,OrderBatch,OrderGodown
Fetch :
Date,StockItemName,ClosingBalance,PreClosureQty,Rate,ClosingValue,OrderPreclosureQty,Discount
Fetch : OrigQty
Client
Only : Yes
[Collection: MainSRC CollForOrder Closure]
Source
Collection : DATA For
OrderClosure
Fetch : Name, TrackLedger,
Parent, OrderDueDate, GodownName, BatchName, ClosingBalance, Rate,
ClosingValue, Discount
By :
Name :
$Name
By :
Parent :
$Parent
By :
TrackLedger :
$TrackLedger
By :
OrderDueDt :
$OrderDueDate
By :
OrderBatch :
$BatchName
By :
OrderGodown : $GodownName
By :
Date :
$Date
Compute : StockItemName : $Parent ;;This
is required to create dependency...without this focus of closing balance field is
not going to next field.
Compute : ClosingBalance : $ClosingBalance
Compute : PreClosureQty : $ClosingBalance
Compute : OrigQty :
@@OrdOrigQty
Compute : Rate :
$Rate
Compute : ClosingValue : $ClosingValue
Compute : OrderPreclosureQty:
$OrderPreclosureQty
Compute : Discount :
$Discount
Filter : NotEmptyOrder,
NotEmptyOrigQty, NotEmptyClosingBal
Client
Only : Yes
[Collection: DATA For OrderClosure]
Switch : OrdersForClosure : SelectedOrders : NOT $$IsEmptyCollection:OrdersSelectedforClosure
Switch : OrdersForClosure : CurrentOrder :
$$IsEmptyCollection:OrdersSelectedforClosure
Client
Only : Yes
[!Collection:
SelectedOrders]
Collection : Orders Selected for Closure
[!Collection:
CurrentOrder]
Collection : Current Order for Closure
;;To repeat the selected orders in subform
[Collection: Orders Selected for Closure]
Data
Source : Parent Report : Selected
Option : NumItemsforPreClosureSel :
Not ##IsPreClosureReport
[!Collection
: NumItemsforPreClosureSel]
Data
Source : Report : Selected
[Collection: Current Order for Closure]
Data
Source : Parent Report :
All
Option : NumItemsforPreClosure : Not
##IsPreClosureReport
[!Collection
: NumItemsforPreClosure]
Data
Source : Report : All
[Collection: FC Pending ORDERS]
New
Object : FC Pending ORDERSNewObj
Client
Only : Yes
[Collection: FC Pending ORDERSNeg]
New
Object : FC Pending ORDERSNewObjNeg
Client
Only : Yes
[Collection: StockGroup Period Collection]
Use : Period Template
Compute : SortPosition : 1
Switch : StockSummaryPeriod : StockGroup PeriodColl : NOT @@IsPrimaryStockGroup
Switch : StockSummaryPeriod : StockCompany PeriodColl : @@IsPrimaryStockGroup
[!Collection:
StockGroup PeriodColl]
Compute : StkOutQty : $StkOutQty:StockGroup:##StockGroupName
Compute : StkInQty : $StkInQty:StockGroup:##StockGroupName
Compute : StkOpBalance : $OpeningBalance:StockGroup:##StockGroupName
Compute : StkClBalance :
$StkClBalance:StockGroup:##StockGroupName
Compute : TBalDebits :
$TBalDebits:StockGroup:##StockGroupName
Compute : TBalCredits : $TBalCredits:StockGroup:##StockGroupName
Compute :
TBalNettCredits:$TBalNettCredits:StockGroup:##StockGroupName
Compute : TBalOpening : $TBalOpening:StockGroup:##StockGroupName
Compute
: TBalClosing : $TBalClosing:StockGroup:##StockGroupName
;; in
case of 'Primary' Stock Group, get the values from Company object
[!Collection:
StockCompany PeriodColl]
Compute : StkOutQty : $StkOutQty:Company:##SVCurrentCompany
Compute : StkInQty : $StkInQty:Company:##SVCurrentCompany
Compute : StkOpBalance : $OpeningBalance:Company:##SVCurrentCompany
Compute :
StkClBalance :
$StkClBalance:Company:##SVCurrentCompany
Compute : TBalDebits : $TBalDebits:Company:##SVCurrentCompany
Compute : TBalCredits : $TBalCredits:Company:##SVCurrentCompany
Compute : TBalNettCredits:$TBalNettCredits:Company:##SVCurrentCompany
Compute : TBalOpening : $TBalOpening:Company:##SVCurrentCompany
Compute
: TBalClosing : $TBalClosing:Company:##SVCurrentCompany
[Collection: StockGroupItemChildOfGroupName]
Collection : StockGroupChildOfGroupName
Collection : StockItemChildOfGroupName
ColumnVar : DSPOrderCombo, DSPGodownName
Sort : @@Default : $$Type, @@DSPAccName
Sort : @@SortAlphaIncr : $$Type, @@DSPAccName
Sort : @@SortAlphaDecr : $$Type, -@@DSPAccName
Sort : @@AmountWiseIncr : $$Abs:@@AmountSort
Sort : @@AmountWiseDecr : -$$Abs:@@AmountSort
Sort : @@QtyWiseIncr : $$Abs:@@QuantitySort
Sort : @@QtyWiseDecr : -$$Abs:@@QuantitySort
Sort : @@RatewiseIncr : @@RateSort
Sort : @@RatewiseDecr : -@@RateSort
[Collection: StockGroupChildOfGroupName]
Type : Stock Group
Child of : #StockGroupName
Fetch : Name, IsBatchWiseOn,
BSDebits, PartNo, Description, Closing Rate, Opening Balance, Opening Value,
Opening Rate,+
Inward
Quantity, Outward Quantity, Inward Value, Outward Value
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject OR
@@IsEmptyGodownItemValue
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias : $$Alias
Compute : PNAlias :
$$PNAlias
Compute : TBalOpening : $TPG_TBalOpening
Compute : TBalClosing : $TPG_TBalClosing
Compute : StkOpBalance : $TPG_StkOpBalance
Compute : StkClBalance : $TPG_StkClBalance
Compute : TBalDebits : $TPG_TBalDebits
Compute : TBalCredits : $TPG_TBalCredits
Compute : TBalNettCredits : $TPG_TBalNettCredits
Compute : StkInQty :
$TPG_StkInQty
Compute : StkOutQty :
$TPG_StkOutQty
Compute : ClosingBalance : $TPG_ClosingBalance
Compute : ClosingValue : $TPG_ClosingValue
/*This method is used for sorting on inwards or outwards or
opening or closing balance in inventory reports like
stock summary, category summary , group summary, Godown
summary*/
Compute : SortColumn : ##SVSortMethodBase
ColumnVar : DSPOrderCombo, DSPGodownName
/*This method is added for stock summary report
When
stock group is not having any item and balance is zero.
Then
the line should not appear any time (in case of "Show all Items (incl.
Zero Balance" Also)
*/
Compute : IsWithItems :
$$NumItems:StockItemsBelongsToStockGroup > 0
/* This Method is Added To Find out if the stock item has
any transactions passed for it.
If it has no
transactions and its closing balance is zero only then that line should appear
in Stock summary
(in case when
exclude item with zero balance with no transactions)*/
Compute : IsWithVouchers : Yes
/* This
Collection is added for stock summary report to get the number of items belongs
to stock group
When
stock group is not having any item and balance is zero.
Then
the line should not appear any time (in case of "Show all Items (incl.
Zero Balance" Also)
*/
;;Browser
related method to check whether line has to be removed from the UI or not
Option : BrStockSummary : $$InMobileBrowserExport
[Collection: StockItemsBelongsToStockGroup]
Type : Stock Item
Child
of : $Name
Belongs
To : Yes
[Collection: StockItemChildOfGroupName]
Type : Stock Item
Child of : #StockGroupName
Fetch : Name, IsBatchWiseOn,
PartNo, Description, Closing Rate, Opening Balance, Opening Value, Opening
Rate,+
Inward
Quantity, Outward Quantity, Inward Value, Outward Value
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject OR @@IsEmptyGodownItemValue
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias :
$$Alias
Compute : PNAlias :
$$PNAlias
Compute : TBalOpening : $TPG_TBalOpening
Compute : TBalClosing : $TPG_TBalClosing
Compute : StkOpBalance : $TPG_StkOpBalance
Compute : StkClBalance : $TPG_StkClBalance
Compute : TBalDebits : $TPG_TBalDebits
Compute : TBalCredits : $TPG_TBalCredits
Compute : TBalNettCredits : $TPG_TBalNettCredits
Compute : StkInQty :
$TPG_StkInQty
Compute : StkOutQty :
$TPG_StkOutQty
Compute : ClosingBalance : $TPG_ClosingBalance
Compute : ClosingValue : $TPG_ClosingValue
/*This method is used for sorting on inwards or outwards or
opening or closing balance in inventory reports like
stock summary, category summary , group summary, Godown
summary*/
Compute : SortColumn : ##SVSortMethodBase
ColumnVar : DSPOrderCombo, DSPGodownName
/*This method is added for stock summary report
When
stock group is not having any item and balance is zero.
Then
the line should not appear any time (in case of "Show all Items (incl.
Zero Balance" Also)
*/
Compute : IsWithItems : Yes
/* This Method is Added for stock summary report To Find out
if the stock item has any transactions passed for it.
If it has no
transactions and its closing balance is zero only then that line should appear
in Stock summary
(in case when
exclude item with zero balance with no transactions)*/
Compute : IsWithVouchers : NOT $$IsEmpty:$FirstVoucherDate
;;Browser
related method to check whether line has to be removed from the UI or not
Option : BrStockSummary : $$InMobileBrowserExport
[!Collection: BrStockSummary]
Compute : BrIsEmptyLine :
@@BrIsEmptyStockLine
[Collection: StockCatItemChildOfStockCategoryName]
Collection : StockCategoryChildOfStockCategoryName,
StockItemInStockCategoryName
ColumnVar : DSPOrderCombo
Sort : @@Default : $$Type, @@DSPAccName
Sort : @@SortAlphaIncr : $$Type, @@DSPAccName
Sort : @@SortAlphaDecr : $$Type, -@@DSPAccName
Sort : @@AmountWiseIncr : $$Abs:@@AmountSort
Sort :
@@AmountWiseDecr :
-$$Abs:@@AmountSort
Sort : @@QtyWiseIncr : $$Abs:@@QuantitySort
Sort : @@QtyWiseDecr : -$$Abs:@@QuantitySort
Sort : @@RatewiseIncr : @@RateSort
Sort : @@RatewiseDecr : -@@RateSort
[Collection: StockCategoryChildOfStockCategoryName]
Type : StockCategory
Child of : #StockCategoryName
ColumnVar : DSPOrderCombo
Fetch : Name, Closing Rate,
Opening Balance, Opening Value, Opening Rate,+
Inward
Quantity, Outward Quantity, Inward Value, Outward Value
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias :
$$Alias
Compute : IsWithItems : Yes
Compute : IsWithVouchers : Yes
Compute : StkClBalance : $TPG_StkClBalance
Compute : StkOpBalance : $TPG_StkOpBalance
Compute : StkInQty :
$TPG_StkInQty
Compute : StkOutQty :
$TPG_StkOutQty
Compute : TBalClosing : $TPG_TBalClosing
Compute : TBalOpening : $TPG_TBalOpening
Compute : TBalDebits : $TPG_TBalDebits
Compute : TBalCredits : $TPG_TBalCredits
Compute : TBalNettCredits : $TPG_TBalNettCredits
/*This method is used for sorting on inwards or outwards or
opening or closing balance in inventory reports like
stock summary, category summary , group summary, Godown
summary
*/
Compute : SortColumn : ##SVSortMethodBase
[Collection: StockItemInStockCategoryName]
Type :
Stock Item
Filter : ChildOfStockCategoryName
ColumnVar : DSPOrderCombo
Fetch : Name, Closing Rate,
Opening Balance, Opening Value, Opening Rate,+
Inward
Quantity, Outward Quantity, Inward Value, Outward Value
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias :
$$Alias
Compute : PNAlias :
$$PNAlias
Compute : IsWithItems : Yes
Compute : IsWithVouchers : NOT $$IsEmpty:$FirstVoucherDate
Compute : StkClBalance : $TPG_StkClBalance
Compute : StkOpBalance : $TPG_StkOpBalance
Compute : StkInQty :
$TPG_StkInQty
Compute : StkOutQty :
$TPG_StkOutQty
Compute : TBalClosing : $TPG_TBalClosing
Compute : TBalOpening : $TPG_TBalOpening
Compute : TBalDebits : $TPG_TBalDebits
Compute : TBalCredits : $TPG_TBalCredits
Compute : TBalNettCredits : $TPG_TBalNettCredits
/*This method is used for sorting on inwards or outwards or
opening or closing balance in inventory reports like
stock summary, category summary , group summary, Godown
summary
*/
Compute : SortColumn : ##SVSortMethodBase
;;ItemBatchSummary
[Collection: Batch Periodic Details]
Collection : Opening Balance, Batch Period
Collection
Sort : @@Default : $SortPosition
ColumnVar : StockItemName, DSPBatchName
[Collection: Batch Period Collection]
Use : Period Template
ColumnVar : StockItemName
Compute : StkOutQty :
$BatchStkOutQty:StockItem:##StockItemName
Compute : StkInQty :
$BatchStkInQty:StockItem:##StockItemName
Compute : StkOpBalance :
$BatchStkOpBalance:StockItem:##StockItemName
Compute : StkClBalance :
$BatchStkClBalance:StockItem:##StockItemName
Compute : TBalDebits :
$BatchTBalDebits:StockItem:##StockItemName
Compute : TBalCredits :
$BatchTBalCredits:StockItem:##StockItemName
Compute :
TBalNettCredits:$BatchTBalNettCredits:StockItem:##StockItemName
Compute : TBalOpening :
$BatchTBalOpening:StockItem:##StockItemName
Compute
: TBalClosing :
$BatchTBalClosing:StockItem:##StockItemName
;;ItemBatchodown Summary
[Collection: BatchGdwn Periodic Details]
Collection : Opening Balance, BatchGdwn Period
Collection
Sort : @@Default : $SortPosition
ColumnVar : StockItemName, DSPBatchName
[Collection: BatchGdwn Period Collection]
Use : Period Template
ColumnVar : StockItemName
Compute : StkOutQty :
$BatchGdwnStkOutQty:StockItem:##StockItemName
Compute : StkInQty :
$BatchGdwnStkInQty:StockItem:##StockItemName
Compute : StkOpBalance :
$BatchGdwnStkOpBalance:StockItem:##StockItemName
Compute : StkClBalance :
$BatchGdwnStkClBalance:StockItem:##StockItemName
Compute : TBalDebits :
$BatchGdwnTBalDebits:StockItem:##StockItemName
Compute : TBalCredits :
$BatchGdwnTBalCredits:StockItem:##StockItemName
Compute : TBalNettCredits:$BatchGdwnTBalNettCredits:StockItem:##StockItemName
Compute : TBalOpening :
$BatchGdwnTBalOpening:StockItem:##StockItemName
Compute
: TBalClosing :
$BatchGdwnTBalClosing:StockItem:##StockItemName
;;StockSummaryGodownwise
[Collection: StkSummGdwn Periodic Details]
Collection : Opening Balance, StkSummGdwn
Period Collection
Sort : @@Default : $SortPosition
ColumnVar : StockItemName, DSPBatchName
[Collection: StkSummGdwn Period Collection]
Use : Period Template
ColumnVar : StockItemName
Compute : StkOutQty :
$GdwnStkOutQty:StockItem:##StockItemName
Compute : StkInQty : $GdwnStkInQty:StockItem:##StockItemName
Compute : StkOpBalance : $GdwnStkOpBalance:StockItem:##StockItemName
Compute : StkClBalance :
$GdwnStkClBalance:StockItem:##StockItemName
Compute : TBalDebits :
$GdwnTBalDebits:StockItem:##StockItemName
Compute : TBalCredits :
$GdwnTBalCredits:StockItem:##StockItemName
Compute :
TBalNettCredits:$GdwnTBalNettCredits:StockItem:##StockItemName
Compute : TBalOpening : $GdwnTBalOpening:StockItem:##StockItemName
Compute
: TBalClosing : $GdwnTBalClosing:StockItem:##StockItemName
[Collection: Job SummaryInCollection]
Source
Collection : Job PurchaseSummaryCollection,
Job StockJrnlInSummaryCollection
By :
JobName :
$JobName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
ForJobCosting :
$ForJobCosting
By :
ForMfgJournal :
$ForMfgJournal
By :
ForLocationTransfer :
$ForLocationTransfer
Aggr
Compute : JobGrossCost : Sum : $JobGrossCost
Aggr
Compute : JobActualCost : Sum : $JobActualCost
[Collection: Job PurchaseSummaryCollection]
Source
Collection : Job
PurchaseSummaryCollectionBase
By :
JobName :
$JobName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
ForJobCosting :
$ForJobCosting
By :
ForMfgJournal :
$ForMfgJournal
By :
ForLocationTransfer :
$ForLocationTransfer
Aggr
Compute : JobGrossCost : Sum : $JobGrossCost
Aggr
Compute : JobActualCost : Sum : $JobActualCost
[Collection: Job StockJrnlInSummaryCollection]
Source
Collection : Job
StockJrnlInSummaryCollectionBase
By :
JobName :
$JobName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
ForMfgJournal :
$ForMfgJournal
By :
ForLocationTransfer :
$ForLocationTransfer
Aggr
Compute : JobGrossCost : Sum : $JobGrossCost
Aggr
Compute : JobActualCost : Sum : $JobActualCost
[Collection: Job PurchaseSummaryCollectionBase]
Source
Collection : Job
PurchaseVoucher, Job DebitNoteVoucher, Job JV As Purchase Voucher
Walk :
All Ledger Entries, Inventory Allocations, BatchAllocations
By :
JobName :
$JobName:Godown:$GodownName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
BatchName :
$BatchName
By :
ForJobCosting :
$$ClassLogicalValue:$VoucherTypeName:$ClassName:$ForJobCosting
By :
ForMfgJournal :
@@AsMfgJrnlVch
By :
ForLocationTransfer :
$$ClassLogicalValue:$VoucherTypeName:$ClassName:$UseForGodownTransfer
Aggr
Compute : JobGrossCost : Sum : If $$IsEmpty:@@JobGrossCost Then 0 Else
@@JobGrossCost
Aggr
Compute : JobActualCost : Sum : $Amount
[Collection: Job StockJrnlInSummaryCollectionBase]
Source
Collection : Job
StockJournalVoucher
Walk :
Inventory Entries In, BatchAllocations
By :
JobName :
$JobName:Godown:$GodownName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
BatchName :
$BatchName
By :
ForMfgJournal :
@@AsMfgJrnlVch
By :
ForLocationTransfer :
$$ClassLogicalValue:$VoucherTypeName:$ClassName:$UseForGodownTransfer
Aggr
Compute : JobGrossCost : Sum : If $$IsEmpty:@@JobGrossCost Then 0 Else
@@JobGrossCost
Aggr
Compute : JobActualCost : Sum : $Amount
[Collection: Job PurchaseVoucher]
Type : Vouchers : VoucherType
Child
of : $$VchTypePurchase
Belongs
To : Yes
Filter : IsNOTOptionalVch
[Collection: Job DebitNoteVoucher]
Type : Vouchers : VoucherType
Child
of : $$VchTypeDebitNote
Belongs
To : Yes
Filter : IsNOTOptionalVch
[Collection: Job JV As Purchase Voucher]
Type : Vouchers : VoucherType
Child
of : $$VchTypeJournal
Belongs
To : Yes
Compute : IsSalesJV : No
Compute : IsCreditJV : No
Filter : IsNOTOptionalVch,
IsVCHWithPurchLedger
[Collection: Job StockJournalVoucher]
Type : Vouchers : VoucherType
Child
of : $$VchTypeStockJrnl
Belongs
To : Yes
Filter : IsNOTOptionalVch
[Collection: Job SummaryOutCollection]
Source
Collection : Job
SalesSummaryCollection, Job StockJrnlOutSummaryCollection
By :
JobName :
$JobName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
ForJobCosting :
$ForJobCosting
By :
ForMfgJournal :
$ForMfgJournal
By :
ForLocationTransfer :
$ForLocationTransfer
Aggr
Compute : JobGrossCost : Sum : $JobGrossCost
Aggr
Compute : JobActualCost : Sum : $JobActualCost
[Collection: Job SalesSummaryCollection]
Source
Collection : Job
SalesSummaryCollection Base
By :
JobName :
$JobName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
ForJobCosting :
$ForJobCosting
By :
ForMfgJournal :
$ForMfgJournal
By :
ForLocationTransfer :
$ForLocationTransfer
Aggr
Compute : JobGrossCost : Sum : $JobGrossCost
Aggr
Compute : JobActualCost : Sum : $JobActualCost
[Collection: Job StockJrnlOutSummaryCollection]
Source
Collection : Job
StockJrnlOutSummaryCollectionBase
By :
JobName :
$JobName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
ForJobCosting :
$ForJobCosting
By :
ForMfgJournal :
$ForMfgJournal
By :
ForLocationTransfer :
$ForLocationTransfer
Aggr
Compute : JobGrossCost : Sum : $JobGrossCost
Aggr
Compute : JobActualCost : Sum : $JobActualCost
[Collection: Job SalesSummaryCollectionBase]
Source
Collection : Job
SalesSummaryCollectionBaseSrc
Fetch :
Date, JobName, VoucherTypeName, GodownName, BatchName, StockItemName, ActualQty,
BilledQty, ForJobCosting
Fetch :
ForMfgJournal, ForLocationTransfer, JobActualCost, IsSalesJV, IsCreditJV
Compute
Var : JobName : String : $JobName
Compute
Var : JobGrossCost : Amount : If NOT $$IsSysName:##JobName Then @@JobGrossCost
Else $$InitValue:"Amount"
Compute
Var :
ConsumptionQty :
Quantity :
$$AsOutQty:$ActualQty
Compute
Var :
ConsumptionValue :
Amount : (If (NOT
$$IsEmpty:##ConsumptionQty AND ##ConsumptionQty > 0) Then $$AsDrAmt:$$Negative:##JobGrossCost
Else +
If
(##ConsumptionQty < 0 AND $$IsDr:##JobGrossCost) Then
$$Negative:##JobGrossCost Else +
If
(##ConsumptionQty < 0 AND NOT $$IsDr:##JobGrossCost) Then
$$AsDrAmt:##JobGrossCost Else +
$$AsAmount:0)
Compute :
JobGrossCost :
If $$IsEmpty:##ConsumptionValue Then $$InitValue:"Amount" Else
##ConsumptionValue
[Collection: Job StockJrnlOutSummaryCollectionBase]
Source
Collection : Job
StockJournalVoucher
Walk :
Inventory Entries Out, BatchAllocations
By :
JobName :
$JobName:Godown:$GodownName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
StockItemName :
$StockItemName
By :
BatchName :
$BatchName
By :
ForJobCosting :
$$ClassLogicalValue:$VoucherTypeName:$ClassName:$ForJobCosting
By :
ForMfgJournal :
@@AsMfgJrnlVch
By :
ForLocationTransfer :
$$ClassLogicalValue:$VoucherTypeName:$ClassName:$UseForGodownTransfer
Compute
Var : JobName : String :
($JobName:Godown:$GodownName)
Compute
Var : JobGrossCost : Amount : If Not
$$IsSysName:##JobName then @@JobGrossCost Else $$InitValue:"Amount"
Compute
Var :
ConsumptionQty :
Quantity : $$AsOutQty:$ActualQty
Compute
Var :
ConsumptionValue :
Amount : (If (NOT
$$IsEmpty:##ConsumptionQty AND ##ConsumptionQty > 0) Then
$$AsDrAmt:$$Negative:##JobGrossCost Else +
If
(##ConsumptionQty < 0 AND $$IsDr:##JobGrossCost) Then $$Negative:##JobGrossCost
Else +
If
(##ConsumptionQty < 0 AND NOT $$IsDr:##JobGrossCost) Then
$$AsDrAmt:##JobGrossCost Else +
$$AsAmount:0)
Aggr
Compute : JobGrossCost : Sum :
If $$IsEmpty:##ConsumptionValue then $$InitValue:"Amount" Else
##ConsumptionValue
Aggr
Compute : JobActualCost : Sum : $Amount
/* The below 2 collection are used to Compute the Residual
Value based on Group By StockItem, Godown, Batch and Aggr Quantity.
This approach is
taken When Same item is being used more than once in Inventory Entries for the
same voucher.
The Collection is
being used in Job Work Analysis Reports
*/
[Collection: Job SalesSummaryCollectionBaseSrc]
Source
Collection : Job SalesVoucher,
Job CreditNoteVoucher, Job JV As Sales Voucher
Walk :
Inventory Entries, BatchAllocations
Fetch :
IsCreditJV, IsSalesJV
By :
Date :
$Date
By :
JobName :
$JobName:Godown:$GodownName
By :
VoucherTypeName :
$VoucherTypeName
By :
GodownName :
$GodownName
By :
BatchName :
$BatchName
By :
StockItemName :
$StockItemName
By :
ForJobCosting :
$$ClassLogicalValue:$VoucherTypeName:$ClassName:$ForJobCosting
By :
ForMfgJournal :
@@AsMfgJrnlVch
By :
ForLocationTransfer : $$ClassLogicalValue:$VoucherTypeName:$ClassName:$UseForGodownTransfer
Aggr
Compute : BilledQty :
Sum : $BilledQty
Aggr
Compute : ActualQty :
Sum : $ActualQty
Aggr
Compute : JobActualCost : Sum : $Amount
[Collection: Job SalesVoucher]
Type : Vouchers : VoucherType
Child
of : $$VchTypeSales
Belongs
To : Yes
Filter : IsNOTOptionalVch
[Collection: Job CreditNoteVoucher]
Type : Vouchers : VoucherType
Child
of : $$VchTypeCreditNote
Belongs
To : Yes
Filter : IsNOTOptionalVch
[Collection: Job JV As Sales Voucher]
Type : Vouchers : VoucherType
Child
of : $$VchTypeJournal
Belongs
To : Yes
Compute : IsSalesJV : Yes
Compute : IsCreditJV :
$$IsDr:$AllLedgerEntries[1,@@IsSalesAccount].Amount
Filter : IsNOTOptionalVch,
IsVCHWithSalesLedger
[Collection: Job OutwardExtractAll]
Source
Collection : Job
OutwardCollectionAll
By :
JobName :
$JobName
By :
GodownName :
$GodownName
Aggr
Compute : JobGrossCost : Sum : $JobGrossCost
Aggr
Compute : JobActualCost : Sum : $JobActualCost
Search
Key :
$JobName + $GodownName
Keep
Source :
Yes
[Collection: DSPJobWorkAutoColumns]
Title : $$LocaleString:"Column
Details"
Collection : Periodicity
Object : DSPCurrentCompany
Object : DSPAllValuation, DSPJobWorkCostCentre,
DSPCostCategory, DSPOrderPosition, DSPEmployee
ClientOnly : Yes
Filter : Belongs
[Collection: Job OutwardCollection]
Source
Collection : Job
SummaryOutCollection
By :
JobName :
$JobName
By :
VoucherTypeName : If
$ForMfgJournal Then $$LocaleString:"Manufacturing Journal" Else If
$ForLocationTransfer Then
$$LocaleString:"Inter Project Transfer" Else "Other
Transfer"
Aggr
Compute : JobGrossCost : Sum : If NOT ($ForJobCosting OR @@IsSalesVch OR
@@IsCreditNoteVch OR @@IsJournalVch) Then $JobGrossCost Else 0
Aggr
Compute : JobActualCost : Sum : If NOT ($ForJobCosting OR @@IsSalesVch OR
@@IsCreditNoteVch OR @@IsJournalVch) Then $JobActualCost Else 0
Search
Key :
$JobName + $VoucherTypeName
Keep
Source :
Yes
Filter :
NotIsEmptyGrossCost
[Collection: Job InwardCollection]
Source
Collection : Job
SummaryInCollection
By :
JobName :
$JobName
By :
VoucherTypeName : If
@@IsPurchaseVch OR @@IsDebitNoteVch OR @@IsJournalVch Then
$$LocaleString:"Purchase" Else If $ForMfgJournal Then $$LocaleString:"Manufacturing
Journal" Else If $ForLocationTransfer Then $$LocaleString:"Inter
Project Transfer" Else "Other Transfer"
Aggr
Compute : JobGrossCost : Sum : $JobGrossCost
Aggr
Compute : JobActualCost : Sum : $JobActualCost
Search
Key :
$JobName + $VoucherTypeName
Keep
Source :
Yes
Filter :
NotIsEmptyGrossCost
[Table: DSPOrderCombo]
Title : $$LocaleString:"Type of Values
"
Object : CurrentStr, SOTotal, POTotal
Object : DispStock, CurrentDisp
Sort : @@Default : $SortPosition
Format : $DSPOrderCombo,18
Format : $DescStock,25
Client Only : Yes
[Table: StockBalTypes]
Title : $$LocaleString:"Type of Values
"
Object : StockBalAll, BalTypeStockInHand,
StockBalNettStock, StockBalStockwithus
Object : StockBalStockwithThirdParty,
StockBalThirdPartyStockwithus
Sort : @@Default : $SortPosition
Format : $DSPOrderCombo,36
Client
Only : Yes
[Collection:
OrderLedgerColl Src]
Parm Var : GroupSundryDebtors : String :
$$GroupSundryDebtors
Parm
Var : GroupSundryCreditors : String : $$GroupSundryCreditors
Parm
Var : GroupBranches : String : $$GroupBranches
Parm
Var : GroupCash : String : $$GroupCash
Parm
Var : GroupBank : String : $$GroupBank
Parm
Var : GroupBankOD :
String : $$GroupBankOD
Type : Ledger
Title : $$LocaleString:"List of
Ledgers"
Fetch :
Name, Language Name, ReserveName
Filter : IsDebtCredBankCashAcc
[Collection: OrderLedgerColl]
Option : OrderLedgerColl Server : NOT $$IsRemoteCompany
Option : OrderLedgerColl Remote : $$IsRemoteCompany
[!Collection: OrderLedgerColl Server]
Use : List of Ledgers
Include : Group : $$GroupSundryDebtors
Include
: Group : $$GroupSundryCreditors
Include : Group : $$GroupBranches
Include : Group : $$GroupCash
Include : Group : $$GroupBank
Include : Group : $$GroupBankOD
[!Collection: OrderLedgerColl Remote]
Use :
ExtractAlias Collection
Title : $$LocaleString:"List of
Ledgers"
Source
Collection : OrderLedgerColl
Src
Fetch :
Name
Client Only : Yes
[Collection : SalesOrderVchSummaryColl]
Source
Collection : SalesOrderVchSrc
Walk :
ALLInventoryEntries, BatchAllocations
By :
Order ID : $OrderID
By :
StockItemName : $StockItemName
;;
Gives the ordered Actual quantity
AggrCompute
: SOOrderQty : SUM : $ActualQty
;;
Gives the ordered Billed quantity
AggrCompute :
SOBilledQty : SUM :
$BilledQty
Search
Key :
$OrderID
[Collection : PurchaseOrderVchSrc]
Type : Vouchers : Voucher type
Child
of : $$VchTypePurcOrder
Belongs
To : Yes
Fetch :
IsOptional,IsStkGrpItemPresent
Filter : IsNotOptionalVch,IsSelGrpItemExist
[Collection : PurchaseOrderVchSummaryColl]
Source
Collection :
PurchaseOrderVchSrc
Walk :
ALLInventoryEntries, BatchAllocations
By :
Order ID : $OrderID
By :
StockItemName : $StockItemName
;;
Gives the ordered Actual quantity
AggrCompute
: POOrderQty : SUM : $ActualQty
;;
Gives the ordered Billed quantity
AggrCompute
: POBilledQty : SUM : $BilledQty
Search
Key :
$OrderID
[Collection : SalesOrderVchSrc]
Type : Vouchers : Voucher type
Child
of : $$VchTypeSalesOrder
Belongs
To : Yes
Fetch :
IsOptional,IsStkGrpItemPresent
Filter : IsNotOptionalVch,IsSelGrpItemExist
;;Collection
;; Sales Order Collections
/*
Collection
1. OrderStockGroupItemChildOfGroupName
2. OrderStockGroupChildOfGroupName
3. OrderStockItemChildOfGroupName
Used
for stock group repeation in Stock Group Order Outstanding Report
*/
[Collection: OrderStockGroupItemChildOfGroupName]
Collection : OrderStockGroupChildOfGroupName
Collection : OrderStockItemChildOfGroupName
ColumnVar : DSPOrderCombo, DSPGodownName
Sort : @@Default : $$Type, @@DSPAccName
Sort : @@SortAlphaIncr : $$Type, @@DSPAccName
Sort : @@SortAlphaDecr : $$Type, -@@DSPAccName
Sort : @@AmountWiseIncr : $$Abs:$OrderClValue
Sort : @@AmountWiseDecr : -$$Abs:$OrderClValue
Sort : @@QtyWiseIncr : $$Abs:$OrderClQty
Sort : @@QtyWiseDecr : -$$Abs:$OrderClQty
Sort : @@RatewiseIncr : $ClosingRate
Sort : @@RatewiseDecr : -$ClosingRate
[Collection: OrderStockGroupChildOfGroupName]
Type : Stock Group
Child
of : #StockGroupName
Fetch : Name
Compute : OrderQty : if
$$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if ##DSPDueOrders then $SODue else $SOTotal
else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODue else $POTotal else +
if $$IsSysNameEqual:IndentsOutstanding:##DSPOrderCombo
then if ##DSPDueOrders then $IODue else $IOTotal else +
if $$IsSysNameEqual:NettStock:##DSPOrderCombo
then $NettDisposable else If $$IsSysNameEqual:StockinHand:##DSPOrderCombo Then
$$AsSignedQty:$ClosingBalance Else $CurrentDisposable
Compute : OrderVal
: if $$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $SODueValue else $SOTotalValue else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODueValue else $POTotalValue else +
if
$$IsSysNameEqual:NettStock:##DSPOrderCombo then $NettDisposableVal Else If
$$IsSysNameEqual:StockinHand:##DSPOrderCombo Then $$AsSignedQty:$ClosingValue
else $CurrentDisposableVal
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias : $$Alias
Compute : PNAlias :
$$PNAlias
Compute : TBalClosing : $TBalClosing
Compute : IsWithItems :
$$NumItems:StockItemsBelongsToStockGroup > 0
Option : OrderStockGroupOpeningOrders : ##DSPShowOpening
Option : OrderStockGroupOrdersBooked : ##DSPShowInwards
Option : OrderStockGroupClearedOrders : ##DSPShowOutwards
[Collection: OrderStockItemChildOfGroupName]
Type : Stock Item
Child
of : #StockGroupName
Fetch : Name, PartNo, Description
Compute : OrderQty : if
$$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if ##DSPDueOrders then $SODue else $SOTotal
else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODue else $POTotal else +
if
$$IsSysNameEqual:IndentsOutstanding:##DSPOrderCombo then if ##DSPDueOrders then
$IODue else $IOTotal else +
if $$IsSysNameEqual:NettStock:##DSPOrderCombo
then $NettDisposable Else If $$IsSysNameEqual:StockinHand:##DSPOrderCombo Then
$$AsSignedQty:$ClosingBalance else $CurrentDisposable
Compute : OrderVal
: if $$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $SODueValue else $SOTotalValue else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODueValue else $POTotalValue else +
if
$$IsSysNameEqual:NettStock:##DSPOrderCombo then $NettDisposableVal Else If
$$IsSysNameEqual:StockinHand:##DSPOrderCombo Then $$AsSignedQty:$ClosingValue
else $CurrentDisposableVal
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias : $$Alias
Compute : PNAlias :
$$PNAlias
Compute : TBalClosing : $TBalClosing
Compute : IsWithItems : Yes
Option : OrderStockGroupOpeningOrders : ##DSPShowOpening
Option : OrderStockGroupOrdersBooked : ##DSPShowInwards
Option : OrderStockGroupClearedOrders : ##DSPShowOutwards
[!Collection:OrderStockGroupOpeningOrders]
Fetch :
OrderOpeningQty, OrderOpeningValue, OrderClQty, OrderClValue
[!Collection:OrderStockGroupOrdersBooked]
Fetch :
OrderInwardQty, OrderInwardValue, OrderClQty, OrderClValue
[!Collection:OrderStockGroupClearedOrders]
Fetch :
OrderOutwardQty, OrderOutwardValue, OrderClQty, OrderClValue
/*
Collection
1. OrderStockCatItemChildOfStockCategoryName
2.
OrderStockCategoryChildOfStockCategoryName
3. OrderStockItemInStockCategoryName
Used
for stock category repeation in Stock
category Order Outstanding Report
*/
[Collection: OrderStockCatItemChildOfStockCategoryName]
Collection : OrderStockCategoryChildOfStockCategoryName
Collection : OrderStockItemInStockCategoryName
ColumnVar : DSPOrderCombo, DSPGodownName
Sort : @@Default : $$Type, @@DSPAccName
Sort : @@SortAlphaIncr : $$Type, @@DSPAccName
Sort : @@SortAlphaDecr : $$Type, -@@DSPAccName
Sort : @@AmountWiseIncr : $$Abs:$OrderClValue
Sort : @@AmountWiseDecr : -$$Abs:$OrderClValue
Sort : @@QtyWiseIncr : $$Abs:$OrderClQty
Sort : @@QtyWiseDecr : -$$Abs:$OrderClQty
Sort : @@RatewiseIncr : $ClosingRate
Sort : @@RatewiseDecr : -$ClosingRate
[Collection: OrderStockCategoryChildOfStockCategoryName]
Type : StockCategory
Child of : #StockCategoryName
ColumnVar : DSPOrderCombo
Fetch : Name, OrderQty, OrderVal
Compute : DSPOrderCombo : ##DSPOrderCombo
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias : $$Alias
Compute : PNAlias :
$$PNAlias
Compute : TBalClosing : $TBalClosing
Compute : IsWithItems : Yes
Option : OrderStockGroupOpeningOrders : ##DSPShowOpening
Option : OrderStockGroupOrdersBooked : ##DSPShowInwards
Option : OrderStockGroupClearedOrders : ##DSPShowOutwards
[Collection: OrderStockItemInStockCategoryName]
Type : Stock Item
ColumnVar : DSPOrderCombo
Fetch : Name, PartNo,
Description, OrderQty, OrderVal
Compute : DSPOrderCombo : ##DSPOrderCombo
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias : $$Alias
Compute : PNAlias :
$$PNAlias
Compute :
TBalClosing :
$TBalClosing
Compute : IsWithItems : Yes
Option : OrderStockGroupOpeningOrders : ##DSPShowOpening
Option : OrderStockGroupOrdersBooked : ##DSPShowInwards
Option : OrderStockGroupClearedOrders : ##DSPShowOutwards
Filter :
ChildOfStockCategoryName
/*
The
Collection StockItemOutstandings
Used in
Stock Item Order Outstanding Report to Stock Items
*/
[Collection:
StockItemOutstandings]
Type : Stock Item
Filter : OrderStkItem
Fetch : Name, PartNo, Description
Compute :
StockItemName : ##StockItemName
ColumnVar : DSPOrderCombo
Compute : DSPOrderCombo : ##DSPOrderCombo
Compute : OrderQty : if
$$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if ##DSPDueOrders then $SODue else $SOTotal
else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODue else $POTotal else +
if
$$IsSysNameEqual:IndentsOutstanding:##DSPOrderCombo then if ##DSPDueOrders then
$IODue else $IOTotal else +
if $$IsSysNameEqual:NettStock:##DSPOrderCombo
then $NettDisposable Else If $$IsSysNameEqual:StockinHand:##DSPOrderCombo Then
$$AsSignedQty:$ClosingBalance else $CurrentDisposable
Compute : OrderVal
: if $$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $SODueValue else $SOTotalValue else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODueValue else $POTotalValue else +
if $$IsSysNameEqual:NettStock:##DSPOrderCombo
then $NettDisposableVal Else If $$IsSysNameEqual:StockinHand:##DSPOrderCombo
Then $$AsSignedQty:$ClosingValue else $CurrentDisposableVal
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias : $$Alias
Compute : PNAlias :
$$PNAlias
Compute : TBalClosing : $TBalClosing
Compute : IsWithItems : Yes
Option : OrderStockGroupOpeningOrders : ##DSPShowOpening
Option : OrderStockGroupOrdersBooked : ##DSPShowInwards
Option : OrderStockGroupClearedOrders : ##DSPShowOutwards
Sort : @@Default : $$Type, @@DSPAccName
Sort : @@SortAlphaIncr : $$Type, @@DSPAccName
Sort : @@SortAlphaDecr : $$Type, -@@DSPAccName
Sort : @@AmountWiseIncr : $$Abs:$OrderClValue
Sort : @@AmountWiseDecr : -$$Abs:$OrderClValue
Sort : @@QtyWiseIncr : $$Abs:$OrderClQty
Sort : @@QtyWiseDecr : -$$Abs:$OrderClQty
Sort : @@RatewiseIncr : $ClosingRate
Sort : @@RatewiseDecr : -$ClosingRate
Option : BrOrderOutstandings : $$InMobileBrowserExport
[Collection: Stock Group Summary]
Option : Stock Group Summary Extract Server :
NOT $$IsRemoteCompany
Option : Stock Group Summary Extract Remote :
$$IsRemoteCompany
[!Collection:
Stock Group Summary Extract Server]
Use :
List of Stock Groups ;;Group
Title : $$LocaleString:"List
of Stock Groups"
Collection :
Primary
Fetch : Name
Variable : Stock Group Name
Report : Stock Group Summary
Trigger : Stock Group Name
[!Collection:
Stock Group Summary Extract Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List
of Stock Groups"
Source
Collection : List of StockGroups
Collection :
Primary
Fetch : Name
Variable : Stock Group Name
Report : Stock Group Summary
Trigger : Stock Group Name
[Collection: Stock Group MonthlySummary]
Use : Stock
Group Summary
Option : Stock Group MonthlySummary Report
[!Collection:
Stock Group MonthlySummary Report]
Report : Stock Group MonthlySummary
;; used for Negative Stock Exception report in Inventory
reports Ctrl+J
[Collection: Stock Group NegStock]
Option : Stock Group NegStock Extract Server :
NOT $$IsRemoteCompany
Option : Stock Group NegStock Extract Remote :
$$IsRemoteCompany
[!Collection:
Stock Group NegStock Extract Server]
Use :
List of Stock Groups
Title : $$LocaleString:"List
of Stock Groups"
Collection :
Primary
Fetch : Name
Variable : Stock Group Name
Report : Negative Stock
Trigger : Stock Group Name
[!Collection:
Stock Group NegStock Extract Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List
of Stock Groups"
Source
Collection : List of StockGroups
Collection :
Primary
Fetch : Name
Variable : Stock Group Name
Report : Negative Stock
Trigger : Stock Group Name
[Collection: StockAgeing]
<unitgroup:stockageing>
Option : StockAgeing Extract Server : NOT
$$IsRemoteCompany
Option : StockAgeing Extract Remote :
$$IsRemoteCompany
[!Collection:
StockAgeing Extract Server]
Use :
List of Stock Groups ;;Group
Title : $$LocaleString:"List of Stock
Groups"
Collection :
Primary
Fetch : Name
Variable : Stock Group Name
Report : StockAgeing
Trigger : Stock Group Name
[!Collection:
StockAgeing Extract Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List
of Stock Groups"
Source
Collection : List of StockGroups
Collection :
Primary
Fetch : Name
Variable : Stock Group Name
Report : StockAgeing
Trigger : Stock Group Name
/* Job Work Out Stock Ageing Analysis */
[Collection: JobWorkOut Stock Ageing]
<unitgroup:jwstockageing>
Option : JobWorkOut Stock Ageing Server : NOT
$$IsRemoteCompany
Option : JobWorkOut Stock Ageing Remote :
$$IsRemoteCompany
[!Collection:
JobWorkOut Stock Ageing Server]
Use :
List of Stock Groups
Title :
$$LocaleString:"List of Stock Groups"
Collection :
Primary
Fetch : Name
Variable :
Stock Group Name
Report :
JobWorkOut Stock Ageing
Trigger :
Stock Group Name
[!Collection:
JobWorkOut Stock Ageing Remote]
Use :
Extract Alias Collection
Title : $$LocaleString:"List of
Stock Groups"
Source
Collection : List of StockGroups
Collection :
Primary
Fetch :
Name
Variable :
Stock Group Name
Report :
JobWorkOut Stock Ageing
Trigger :
Stock Group Name
/* Job Work In Stock Ageing Analysis */
[Collection: JobWorkIn Stock Ageing]
Option : JobWorkIn Stock Ageing Server : NOT
$$IsRemoteCompany
Option : JobWorkIn Stock Ageing Remote : $$IsRemoteCompany
[!Collection:
JobWorkIn Stock Ageing Server]
Use :
List of Stock Groups
Title :
$$LocaleString:"List of Stock Groups"
Collection :
Primary
Fetch : Name
Variable :
Stock Group Name
Trigger : Stock Group Name
Report :
JobWorkIn Stock Ageing
[!Collection:
JobWorkIn Stock Ageing Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List of
Stock Groups"
Source
Collection : List of StockGroups
Collection :
Primary
Fetch :
Name
Variable :
Stock Group Name
Report :
JobWorkIn Stock Ageing
Trigger :
Stock Group Name
;;Reorder Status
[Collection: ReOrder Status]
<unitgroup:reorderstatus>
Option
: ReOrder Status Extract Server : NOT $$IsRemoteCompany
Option : ReOrder Status Extract Remote :
$$IsRemoteCompany
[!Collection:
ReOrder Status Extract Server]
Use :
List of Stock Groups ;;Group
Title : $$LocaleString:"List of Stock
Groups"
Collection :
Primary
Fetch : Name
Variable : Stock Group Name
Report : ReOrder Status
Trigger : Stock Group Name
[!Collection:
ReOrder Status Extract Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List
of Stock Groups"
Source
Collection : List of StockGroups
Set
as :
$FirstName
Fetch : Name
Collection :
Primary
Variable : Stock Group Name
Report : ReOrder Status
Trigger : Stock Group Name
[Collection: ReOrder Status Reorder Only]
<unitgroup:reorderstatus>
Option : ReOrder Status Extract Reorder Only
Server : NOT $$IsRemoteCompany
Option : ReOrder Status Extract Reorder Only
Remote : $$IsRemoteCompany
[!Collection:
ReOrder Status Extract Reorder Only Server]
Use :
List of Stock Groups ;;Group
Title : $$LocaleString:"List
of Stock Groups"
Collection :
Primary
Fetch : Name
Variable : Stock Group Name
Report : ReOrder Status Reorder Only
Trigger : Stock Group Name
[!Collection:
ReOrder Status Extract Reorder Only Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List
of Stock Groups"
Source
Collection : List of StockGroups
Set
as :
$FirstName
Fetch : Name
Collection :
Primary
Variable : Stock Group Name
Report : ReOrder Status Reorder Only
Trigger : Stock Group Name
[Collection: ReOrder StatusCategory]
<unitgroup:reorderstatus>
Option : ReOrder Status ExtractCat Server : NOT
$$IsRemoteCompany
Option : ReOrder Status ExtractCat Remote :
$$IsRemoteCompany
[!Collection:
ReOrder Status ExtractCat Server]
Use :
List of Stock Categories
Title : $$LocaleString:"List
of Stock Categories"
Collection :
Primary
Fetch : Name
Variable : Stock Category Name
Report : ReOrder Status Category
Trigger : Stock Category Name
[!Collection:
ReOrder Status ExtractCat Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List
of Stock Categories"
Source
Collection : List of
StockCategories
Collection :
Primary
Fetch : Name
Set
as :
$FirstName
Variable : Stock Category Name
Report : ReOrder Status Category
Trigger : Stock Category Name
[Collection: ReOrder StatusCategory ReOrderOnly]
<unitgroup:reorderstatus>
Option : ReOrder Status ExtractCat ReOrderOnly
Server : NOT $$IsRemoteCompany
Option : ReOrder Status ExtractCat ReOrderOnly
Remote : $$IsRemoteCompany
[!Collection:
ReOrder Status ExtractCat ReOrderOnly Server]
Use :
List of Stock Categories
Title : $$LocaleString:"List
of Stock Categories"
Collection :
Primary
Fetch : Name
Variable : Stock Category Name
Report : ReOrder Status Category
ReOrderOnly
Trigger : Stock Category Name
[!Collection:
ReOrder Status ExtractCat ReOrderOnly Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List
of Stock Categories"
Source
Collection : List of
StockCategories
Collection :
Primary
Fetch : Name
Set
as :
$FirstName
Variable : Stock Category Name
Report : ReOrder Status Category
ReOrderOnly
Trigger : Stock Category Name
[Collection: Monthly Stock Item Vch]
Use : Monthly Stock Item
Report : Item Vouchers Monthly Summary
[Collection: Monthly Stock Item]
<unitgroup:itemmonthly>
Use : Extract Alias Collection
Title : $$LocaleString:"List of
Stock Items"
Source
Collection : List of Stock Items
Collection : StockItem With PartNo
Fetch : Name
Variable : StockItemName
Report : Item Monthly Summary
Trigger : Stock Item Name
[Collection: CV Stock Item Daily]
Use : Extract Alias Collection
Title : $$LocaleString:"List of Stock
Items"
Source
Collection : List of Stock
Items
Collection : StockItem With PartNo
Fetch : Name
Variable : StockItemName
Report : Item Daily
Trigger : Stock Item Name
[Collection: STKI Purchase Orders]
Use :
Monthly Stock Item
Collection : All Items
Report : Purchase Orders DueOnly
[Collection: STKI Sales Orders]
Use :
Monthly Stock Item
Collection : All Items
Report : Sales Orders DueOnly
[Collection: Stock Item Vouchers]
Use :
Monthly Stock Item
Report : Stock Vouchers
[Collection: Batch Summary Item Vouchers]
Use :
Monthly Stock Item
Report : Batch Summary Item Vouchers
[Collection: PendingBillsStockItem]
Use : Monthly Stock Item
Report : PendingBillsStockItem
Collection : All Items
Delete : Trigger
Add :
Trigger : Stock Item Name
All Items
[Collection: BillstoReceiveStockItem]
Use :
PendingBillsStockItem
Report : BillstoReceiveStockItem
[Collection: BillstoSendStockItem]
Use :
PendingBillsStockItem
Report : BillstoSendStockItem
[Collection: SalesBills StockPending]
Use :
PendingBillsStockItem
Report : Outward Tracking Details
[Collection: PurchaseBills StockPending]
Use :
PendingBillsStockItem
Report : Inward Tracking Details
[Collection: GoodstoSendStockItem]
Use :
PendingBillsStockItem
Report : GoodstoSendStockItem
[Collection: GoodstoReceiveStockItem]
Use :
PendingBillsStockItem
Report : GoodstoReceiveStockItem
/* To get Part numbers for Stock items*/
[Collection: StockItem With PartNo]
Title :
$$LocaleString:"List of Stock Items"
Use :
Master Name Method Format
Source
Collection : StockItem
PartNoSrc
Walk :
MailingName
Compute :
Name : $MailingName
Compute : FirstName : $..Name
Align :
Right
FullHeight :
Yes
Set as : $FirstName
[Collection: StockItem PartNoSrc]
Type : Stock Item
Fetch : Name, MailingName
[Collection: Group Analysis]
<unitgroup:groupanalysis>
Option : Group Analysis Server : NOT
$$IsRemoteCompany
Option : Group Analysis Remote :
$$IsRemoteCompany
[!Collection:
Group Analysis Server]
Use :
List of Groups
Parm
Var : GroupCash : String : $$GroupCash
Parm Var : GroupBank : String : $$GroupBank
Parm Var : GroupBankOD : String : $$GroupBankOD
Parm Var : GroupSundryDebtors : String : $$GroupSundryDebtors
Parm Var : GroupSundryCreditors : String : $$GroupSundryCreditors
Parm Var : GroupBranches : String : $$GroupBranches
Variable : Group Name
Report : Group Analysis
Trigger : Group Analysis Name
Filter : IsPartyAccountVchRE
[!Collection:
Group Analysis Remote]
Use : ExtractAlias Collection
Title : $$LocaleString:"List
of Groups"
Parm Var : GroupCash : String : $$GroupCash
Parm Var : GroupBank : String
: $$GroupBank
Parm Var : GroupBankOD : String : $$GroupBankOD
Parm Var : GroupSundryDebtors : String : $$GroupSundryDebtors
Parm Var : GroupSundryCreditors : String : $$GroupSundryCreditors
Parm Var : GroupBranches : String : $$GroupBranches
Source
Collection : List of Groups
Fetch : Name
Fetch : ReserveName
Set as : $FirstName
Variable : Group Name
Report : Group Analysis
Trigger : Group Analysis Name
Filter : IsPartyAccountVchRE
[Collection: Ledger Analysis]
<unitgroup:ledanalysis>
Option : Ledger Analysis Server : NOT
$$IsRemoteCompany
Option : Ledger Analysis Remote :
$$IsRemoteCompany
[!Collection:
Ledger Analysis Server]
Use :
List of Ledgers
Parm
Var : GroupCash : String : $$GroupCash
Parm Var : GroupBank : String : $$GroupBank
Parm Var : GroupBankOD : String : $$GroupBankOD
Parm Var : GroupSundryDebtors : String : $$GroupSundryDebtors
Parm Var : GroupSundryCreditors : String : $$GroupSundryCreditors
Parm Var : GroupBranches : String : $$GroupBranches
Variable : Ledger Name
Report : Ledger Analysis
Trigger : Ledger Analysis Name
Filter : IsPartyAccountVchRE
[!Collection:
Ledger Analysis Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List of
Ledgers"
Parm
Var : GroupCash : String : $$GroupCash
Parm Var : GroupBank : String : $$GroupBank
Parm Var : GroupBankOD : String : $$GroupBankOD
Parm Var : GroupSundryDebtors : String : $$GroupSundryDebtors
Parm Var : GroupSundryCreditors : String : $$GroupSundryCreditors
Parm Var : GroupBranches : String : $$GroupBranches
Source
Collection: List of Ledgers
Fetch : Name
Fetch : ReserveName
Variable : Ledger Name
Report : Ledger Analysis
Trigger : Ledger Analysis Name
Filter : IsPartyAccountVchRE
[Collection: Stock Category Summary]
Option :
Stock Category Summary Server :
NOT $$IsRemoteCompany
Option :
Stock Category Summary Remote :
$$IsRemoteCompany
[!Collection:
Stock Category Summary Server]
Use :
List of StockCategories
Variable : Stock Category Name
Report : Stock Category Summary
Trigger : Stock Category Name
Option : With PrimaryCollection
[!Collection:
Stock Category Summary Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List of
Stock Categories"
Source
Collection : List of StockCategories
Fetch : Name
Variable : Stock Category Name
Report : Stock Category Summary
Trigger : Stock Category Name
Option : With PrimaryCollection
[Collection: Stock Category MonthlySummary]
Use : Stock Category Summary
Option : Stock Category Monthly Summary Report
[!Collection:
Stock Category Monthly Summary Report]
Report : Stock Category Monthly Summary
[Collection: Cost Estimation Display]
Option :
Cost Estimation Display Server : NOT
$$IsRemoteCompany
Option :
Cost Estimation Display Remote :
$$IsRemoteCompany
[!Collection:
Cost Estimation Display Server]
Use :
List of StockGroups
Collection : Primary
Variable : Stock Group Name
Trigger : BOM StockGroupName
Report : BOM Estimate
[!Collection:
Cost Estimation Display Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List of
Stock Groups"
Source
Collection : List of StockGroups
Fetch : Name
Collection : Primary
Variable : Stock Group Name
Trigger : BOM StockGroupName
Report : BOM Estimate
[Collection: Stockable GodownExtarct]
Option : Stockable GodownExtarct Server
: NOT $$IsRemoteCompany
Option : Stockable GodownExtarct Remote
: $$IsRemoteCompany
[!Collection:
Stockable GodownExtarct Server]
Use :
Godown
Fetch :
HasNoSpace, ItemClBalance, GodownItemClBal
Format :
@@StkGdwItemBalance :
"Base"
Filter :
StockableGodownFilter
/* the existing collection code has been modified due to
support Multi Mfgr Journal voucher
.. to
aviod send multible requiest */
[!Collection:
Stockable GodownExtarct Remote]
Title :
@@GodownTitle
Use :
Master Name Method Format
Collection
:
Stockable Godown onRemote
Fetch : Name, ItemClBalance,
GodownItemClBal
Set
as : $FirstName
FullHeight : Yes
Align : Right
Format :
$GodownItemClBal : "Base"
Client
Only :
Yes
Keep
Source : ...
[Collection: Stockable Godown onRemote]
Title :
@@GodownTitle
Source
Collection : Stockable Godown
Walk :
Language Name, Name
Fetch :
Name, ItemClBalance, GodownItemClBal, JobName
Compute : First
Name : $..Name[1].Name
Keep Source :
().
Client
Only :
Yes
Format : $Name, 15
; Format :
$JobName, 20
Format :
$GodownItemClBal : "Base"
Full
Height : Yes
Align : Right
[Collection: JOB Stockable Godown Extract]
Option : Job Stockable GodownExtarct
Server : NOT $$ExclEvaluate:$$IsRemoteCompany
Option : Job Stockable GodownExtarct
Remote : $$ExclEvaluate:$$IsRemoteCompany
[!Collection:
Job Stockable GodownExtarct Server]
Use : Godown
Fetch : Name, Language Name, JobName,
ItemClBalance, GodownItemClBal
Format : $JobName,20
Format : @@StkGdwItemBalance : "Base"
Filter : StockableGodownFilter
[!Collection:
Job Stockable GodownExtarct Remote]
Title :
@@GodownTitle
Collection
:
JobRem Stockable Godown onRemote
;;Stockable GodownOnRemote
Format :
$Name, 15
Format :
$JobName,20
Format : $GodownItemClBal,10 : "Base"
Fetch :
Name, JobName, ItemClBalance, GodownItemClBal
Keep
Source : ...
Client
Only : Yes
Full
Height :
Yes
Align :
Right
[Collection: JobRem Stockable Godown onRemote]
Title :
@@GodownTitle
Source
Collection : Stockable Godown
Walk :
Language Name, Name
Fetch :
Name, ItemClBalance, GodownItemClBal, JobName
Compute :
First Name : $..Name[1].Name
Keep Source :
().
Client
Only :
Yes
Format : $Name, 15
Format :
$JobName, 20
Format :
$GodownItemClBal : "Base"
Full
Height : Yes
Align : Right
/*
The
Collection Order Ledger Outstandings
Used in
Order Ledger outstanding and Order Acc Group Outstanding group
*/
[Collection: Order Ledger Outstandings]
Type : Stock Item
Column
Var : Stock Item Name, DSP Order
Combo
Fetch : Name, PartNo, Description
Fetch : OrderClQty,
OrderClValue , OrderInwardQty,
OrderInwardValue
Fetch : OrderOpeningQty, OrderOpeningValue,
OrderOutwardQty, OrderOutwardValue
Compute : GroupName :
##GroupName
Compute : LedgerName :
##LedgerName
Compute : NumChildren :
$$NumChildren
Compute : IsEmptyObject :
$$IsEmptyObject
Compute : StartingFrom :
$StartingFrom
Compute : IsIntegrated :
$$IsIntegrated
Compute : Alias :
$$Alias
Compute : PNAlias :
$$PNAlias
Sort : @@Default : $$Type, @@DSPAccName
Sort : @@SortAlphaIncr : $$Type, @@DSPAccName
Sort : @@SortAlphaDecr : $$Type, -@@DSPAccName
Sort : @@AmountWiseIncr : $$Abs:$OrderClValue
Sort : @@AmountWiseDecr : -$$Abs:$OrderClValue
Sort : @@QtyWiseIncr : $$Abs:$OrderClQty
Sort : @@QtyWiseDecr : -$$Abs:$OrderClQty
Sort : @@RatewiseIncr : $ClosingRate
Sort : @@RatewiseDecr : -$ClosingRate
Option : BrOrderOutstandings :
$$InMobileBrowserExport
[!Collection : BrOrderOutstandings]
Compute : BrOrderAmt : IF (NOT (##IsOrderLedWise OR
##IsGrpOrderReport )) Then $OrderVal else
If ##DSPOrderCombo = @@POTotal Then $$AsDrAmt:$OrderClValue Else
$$AsCrAmt:$OrderClValue
Compute : BrOrderQty : IF (NOT (##IsOrderLedWise OR ##IsGrpOrderReport ))
Then $OrderQty else $OrderClQty
Compute : BrIsEmptyLine : @@BrIsEmptyOrderLine
/*
The
Collection Order StockGroupItemWiseOutStandings
Used in
Itemwise report(Button F5) of stock group order outstanding report
*/
[Collection: Order StockGroupItemWiseOutStandings]
Type : Stock Item
Child
of : ##StockGroupName
Belongs
To : Yes
ColumnVar : DSPOrderCombo
Fetch : Name, PartNo, Description
Fetch : OrderOpeningQty,
OrderOpeningValue, OrderInwardQty, OrderInwardValue
Fetch : OrderOutwardQty,
OrderOutwardValue, OrderClQty, OrderClValue
Compute : DSPOrderCombo : ##DSPOrderCombo
Compute : OrderQty : if
$$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if ##DSPDueOrders then $SODue else $SOTotal
else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODue else $POTotal else +
if
$$IsSysNameEqual:IndentsOutstanding:##DSPOrderCombo then if ##DSPDueOrders then
$IODue else $IOTotal else +
if $$IsSysNameEqual:NettStock:##DSPOrderCombo
then $NettDisposable Else If $$IsSysNameEqual:StockinHand:##DSPOrderCombo Then
$$AsSignedQty:$ClosingBalance else $CurrentDisposable
Compute : OrderVal
: if $$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $SODueValue else $SOTotalValue else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODueValue else $POTotalValue else +
if
$$IsSysNameEqual:NettStock:##DSPOrderCombo then $NettDisposableVal Else If
$$IsSysNameEqual:StockinHand:##DSPOrderCombo Then $$AsSignedQty:$ClosingValue
else $CurrentDisposableVal
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias : $$Alias
Compute : PNAlias :
$$PNAlias
Compute : TBalClosing : $TBalClosing
Compute : IsWithItems :
Yes
/*
The
Collection Order StockCatItemWiseOutStandings
Used in
Itemwise report(Button F5) of stock Category order outstanding report
*/
[Collection: Order StockCatItemWiseOutStandings]
Type : Stock Item
Belongs
To : Yes
ColumnVar : DSPOrderCombo
Fetch : Name, PartNo, Description
Fetch : OrderOpeningQty,
OrderOpeningValue, OrderInwardQty, OrderInwardValue
Fetch : OrderOutwardQty,
OrderOutwardValue, OrderClQty, OrderClValue
Fetch : OrderQty, OrderVal
Compute : DSPOrderCombo : ##DSPOrderCombo
Compute : OrderQty : if
$$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if ##DSPDueOrders then $SODue else $SOTotal
else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODue else $POTotal else +
if
$$IsSysNameEqual:IndentsOutstanding:##DSPOrderCombo then if ##DSPDueOrders then
$IODue else $IOTotal else +
if $$IsSysNameEqual:NettStock:##DSPOrderCombo
then $NettDisposable Else If $$IsSysNameEqual:StockinHand:##DSPOrderCombo Then
$$AsSignedQty:$ClosingBalance else $CurrentDisposable
Compute : OrderVal
: if $$IsSysNameEqual:SalesOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $SODueValue else $SOTotalValue else +
if
$$IsSysNameEqual:PurchaseOrdersOutstanding:##DSPOrderCombo then if
##DSPDueOrders then $PODueValue else $POTotalValue else +
if
$$IsSysNameEqual:NettStock:##DSPOrderCombo then $NettDisposableVal Else If
$$IsSysNameEqual:StockinHand:##DSPOrderCombo Then $$AsSignedQty:$ClosingValue
else $CurrentDisposableVal
Compute : NumChildren : $$NumChildren
Compute : IsEmptyObject : $$IsEmptyObject
Compute : StartingFrom : $StartingFrom
Compute : IsIntegrated : $$IsIntegrated
Compute : IsGroupStock : $$IsGroupStock
Compute : Alias : $$Alias
Compute : PNAlias :
$$PNAlias
Compute : TBalClosing : $TBalClosing
Compute : IsWithItems : Yes
Filter : BelongsToStockCategoryByName
/*
The
Collection OrderStockItemChildOfStockGroup used to get the Stock Item belongs
to selected Stock category
*/
[Collection: OrderStockItemChildOfStockCategory]
Type : Stock Item
Belongs
To : Yes
Fetch : Name, PartNo, Description
Option : OrderStockGroupOpeningOrders : ##DSPShowOpening
Option : OrderStockGroupOrdersBooked : ##DSPShowInwards
Option : OrderStockGroupClearedOrders : ##DSPShowOutwards
Filter : OrderBelongsToStockCategoryByName
;Calculation Of Purchase Order Stock Group/Category
Outstanding Report
/*
Collection
PendingStkGrpPurcOrderExtractSrc
used in
Purchase Order Stock Group/Category
outstanding report
to
calculate Opening, Inward, Outward and Closing Orders
*/
[Collection: PendingStkGrpPurcOrderExtractSrc]
Source
Collection :
PendingStkGrpPurcOrderDetailsSrc, OpeningStkGrpPendingPurcOrderDetailsSrc
Source
Var :
svOpeningBalance :
Quantity : If $IsOpeningColl
Then $OpeningBalance Else $$InitValue:"Quantity"
Source
Var :
svOpeningValue :
Amount : If $IsOpeningColl
Then $OpeningValue Else $$InitValue:"Amount"
Source
Var :
svInwardQty :
Quantity : If $IsOpeningColl
Then $$InitValue:"Quantity" Else
$InwardQty
Source
Var :
svInwardValue :
Amount : If $IsOpeningColl
Then $$InitValue:"Amount" Else $InwardValue
Source
Var :
svClosingBalance :
Quantity : If $IsOpeningColl
Then $$InitValue:"Quantity" Else $ClosingBalance
Source
Var :
svClosingValue :
Amount : If $IsOpeningColl
Then $$InitValue:"Amount" Else
$ClosingValue
Source
Var :
svOutwardQty :
Quantity :
$$NettQty:($$NettQty:##svOpeningBalance:##svInwardQty):$$Negative:##svClosingBalance
Source
Var :
svOutwardValue :
Amount :
$$NettAmount:($$NettAmount:##svOpeningValue:##svInwardValue):$$Negative:##svClosingValue
By :
Parent :
$Parent
Aggr
Compute : OpeningBalance :
Sum : ##svOpeningBalance
Aggr
Compute : OpeningValue :
Sum : ##svOpeningValue
Aggr
Compute : InwardQty :
Sum : ##svInwardQty
Aggr
Compute : InwardValue :
Sum : ##svInwardValue
Aggr
Compute : OutwardQty :
Sum : ##svOutwardQty
Aggr
Compute : OutwardValue :
Sum : ##svOutwardValue
Aggr
Compute : ClosingBalance :
Sum : ##svClosingBalance
Aggr
Compute : ClosingValue :
Sum : ##svClosingValue
Search
Key : $Parent
/*
The
Collections
1.
PendingStkGrpPurcOrderDetailsSrc
2.
PendingStkGrpPurcOrdersSrc
3.
PendingStkGrpPurcPendingOrderDetails
4.
PendingStkGrpPurcClearedOrderDetails
used in
Purchase Order Stock Group/Category outstanding report
to
calculate Inward and Closing Orders
*/
[Collection: PendingStkGrpPurcOrderDetailsSrc]
Source
Collection :
PendingStkGrpPurcOrdersSrc
Source
Var : SvInwardQty : Quantity : If
$$IsEmpty:$PurchaseOrderQty then $$InitValue:"Quantity" Else
$PurchaseOrderQty
Source
Var : SvInwardValue : Amount : If $$IsEmpty:$PurOpeningActualValue then
$$InitValue:"Amount" Else $PurOpeningActualValue
Source
Var : SvClBal : Quantity : If
$$IsEmpty:$ClosingBalance then $$InitValue:"Quantity" Else
$ClosingBalance
Source
Var : SvClValue : Amount
: If $$IsEmpty:$ClosingValue then $$InitValue:"Amount" Else
$ClosingValue
By :
Parent :
$Parent
Aggr
Compute : InwardQty :
Sum : If
@@ForOrderPeriod Then ##SvInwardQty Else $$InitValue:"Quantity"
Aggr
Compute : InwardValue :
Sum : If
@@ForOrderPeriod Then ##SvInwardValue Else $$InitValue:"Amount"
Aggr
Compute : ClosingBalance :
Sum : ##SvClBal
Aggr
Compute : ClosingValue :
Sum : ##SvClValue
Compute :
IsOpeningColl :
No
[Collection: PendingStkGrpPurcOrdersSrc]
Collection :
PendingStkGrpPurcPendingOrderDetails, PendingStkGrpPurcClearedOrderDetails
[Collection: PendingStkGrpPurcPendingOrderDetails]
Source
Collection : PurchaseOrderSourcePnd
Fetch :
Date, Parent, ClosingBalance, ClosingValue, PurchaseOrderQty,
PurOpeningActualValue
[Collection: PendingStkGrpPurcClearedOrderDetails]
Source
Collection : PurchaseOrderSourceCld
Fetch :
Date, Parent, ClosingBalance, ClosingValue, PurchaseOrderQty,
PurOpeningActualValue
[Collection: PurchaseOrderSourcePnd]
Type : Purchase Orders
Cleared : No
Filter : IsItemBelongstoSelectedStkGrp,
PositiveClosingBalance
[Collection: PurchaseOrderSourceCld]
Type : Purchase Orders
Cleared : Yes
Filter : IsItemBelongstoSelectedStkGrp,
PositiveClosingBalance
/*
The
Collections
1.
OpeningStkGrpPendingPurcOrderDetailsSrc
2.
OpeningStkGrpPendingPurcOrdersSrc
3.
StkGrpPurcPendingOrderDetails
4.
StkGrpPurcClearedOrderDetails
used in
Purchase Order Stock Group/Category outstanding report
to
calculate Opening Orders
*/
[Collection: OpeningStkGrpPendingPurcOrderDetailsSrc]
Source
Collection : OpeningStkGrpPendingPurcOrdersSrc
Source
Var : SvOpBal : Quantity : If
$$IsEmpty:$ClosingBalance then $$InitValue:"Quantity" Else
$ClosingBalance
Source
Var : SvOpValue : Amount
: If $$IsEmpty:$ClosingValue then $$InitValue:"Amount" Else
$ClosingValue
By :
Parent :
$Parent
Aggr
Compute : OpeningBalance :
Sum : ##SvOpBal
Aggr
Compute : OpeningValue :
Sum : ##SvOpValue
Compute :
IsOpeningColl :
Yes
[Collection: OpeningStkGrpPendingPurcOrdersSrc]
Parm
Var : SVToDate : Date :
@@OpeningOrderToDate
Collection : StkGrpPurcPendingOrderDetails
[Collection: StkGrpPurcPendingOrderDetails]
Parm
Var : SVToDate : Date :
@@OpeningOrderToDate
Source Collection :
PurchaseOrderSourceop
Fetch :
Date, Parent, ClosingBalance, ClosingValue, PurchaseOrderQty,
PurOpeningActualValue
[Collection: PurchaseOrderSourceop]
Parm
Var : SVToDate : Date :
@@OpeningOrderToDate
Type : Purchase Orders
Cleared : No
Filter : IsItemBelongstoSelectedStkGrp, PositiveClosingBalance
;;Calculation Of Purchase Order Stock Item Outstanding
Report
/*
Collection
PendingPurcOrderExtractSrc
used in
Purchase Order Stock Item outstanding report
to
calculate Opening, Inward, Outward and Closing Orders
*/
[Collection: PendingPurcOrderExtractSrc]
Source
Collection :
PendingPurcOrderDetailsSrc, OpeningPendingPurcOrderDetailsSrc
Source
Var :
svOpeningBalance :
Quantity : If $IsOpeningColl
Then $OpeningBalance Else $$InitValue:"Quantity"
Source
Var :
svOpeningValue :
Amount : If $IsOpeningColl
Then $OpeningValue Else $$InitValue:"Amount"
Source
Var :
svInwardQty :
Quantity : If $IsOpeningColl
Then $$InitValue:"Quantity" Else
$InwardQty
Source
Var :
svInwardValue :
Amount : If $IsOpeningColl
Then $$InitValue:"Amount" Else $InwardValue
Source
Var :
svClosingBalance :
Quantity : If $IsOpeningColl
Then $$InitValue:"Quantity" Else $ClosingBalance
Source
Var :
svClosingValue :
Amount : If $IsOpeningColl
Then $$InitValue:"Amount" Else
$ClosingValue
Source
Var :
svOutwardQty :
Quantity :
$$NettQty:($$NettQty:##svOpeningBalance:##svInwardQty):$$Negative:##svClosingBalance
Source
Var :
svOutwardValue :
Amount :
$$NettAmount:($$NettAmount:##svOpeningValue:##svInwardValue):$$Negative:##svClosingValue
By :
Parent :
$Parent
Aggr
Compute : OpeningBalance :
Sum : ##svOpeningBalance
Aggr
Compute : OpeningValue :
Sum : ##svOpeningValue
Aggr
Compute : InwardQty :
Sum : ##svInwardQty
Aggr
Compute : InwardValue :
Sum : ##svInwardValue
Aggr
Compute : OutwardQty :
Sum : ##svOutwardQty
Aggr
Compute : OutwardValue :
Sum : ##svOutwardValue
Aggr
Compute : ClosingBalance :
Sum : ##svClosingBalance
Aggr
Compute : ClosingValue :
Sum : ##svClosingValue
Compute : OrderDueDate : $OrderDueDate
Compute :
DSPDueOrders : ##DSPDueOrders
Compute :
Date :
$Date
Search
Key : $Parent
/*
The
Collections
1.
PendingPurcOrderDetailsSrc
2.
PendingPurcOrdersSrc
3.
PendingPurcPendingOrderDetails
4.
PendingPurcClearedOrderDetails
used in
Purchase Order Stock Item outstanding report
to
calculate Inward and Closing Orders
*/
[Collection: PendingPurcOrderDetailsSrc]
Source
Collection :
PendingPurcOrdersSrc
By :
Parent :
$Parent
Aggr
Compute : InwardQty :
Sum : If
@@ForOrderPeriod Then ($PurchaseOrderQty) Else $$InitValue:"Quantity"
Aggr
Compute : InwardValue :
Sum : If
@@ForOrderPeriod Then ($PurOpeningActualValue) Else
$$InitValue:"Amount"
Aggr
Compute : ClosingBalance :
Sum : $ClosingBalance
Aggr
Compute : ClosingValue :
Sum : $ClosingValue
Compute :
IsOpeningColl :
No
[Collection: PendingPurcOrdersSrc]
Collection : PendingPurcPendingOrderDetails,
PendingPurcClearedOrderDetails
[Collection: PendingPurcPendingOrderDetails]
Type : Purchase Orders
Child
Of : ##StockItemName
Cleared : No
Filter : PositiveClosingBalance
[Collection: PendingPurcClearedOrderDetails]
Type : Purchase Orders
Child
Of : ##StockItemName
Cleared : Yes
Filter : PositiveClosingBalance
/*
The
Collections
1.
OpeningPendingPurcOrderDetailsSrc
2.
OpeningPendingPurcOrdersSrc
3.
OpeningPendingPurcPendingOrderDetails
4.
OpeningPendingPurcClearedOrderDetails
used in
Purchase Order Stock Item outstanding report
to
calculate OpeningOrders
*/
[Collection: OpeningPendingPurcOrderDetailsSrc]
Source
Collection :
OpeningPendingPurcOrdersSrc
By :
Parent :
$Parent
Aggr
Compute : OpeningBalance :
Sum : $ClosingBalance
Aggr
Compute : OpeningValue :
Sum : $ClosingValue
Compute :
IsOpeningColl :
Yes
[Collection: OpeningPendingPurcOrdersSrc]
Parm
Var : SVToDate : Date : @@OpeningOrderToDate
Collection :
OpeningPendingPurcPendingOrderDetails
[Collection: OpeningPendingPurcPendingOrderDetails]
Parm
Var : SVToDate : Date : @@OpeningOrderToDate
Type : Purchase Orders
Cleared : No
Child
Of : ##StockItemName
Filter : PositiveClosingBalance
/*
The
Collection OrderStockItemChildOfStockGroup used to get the Stock Item belongs
to selected Stock Group
*/
[Collection: OrderStockItemChildOfStockGroup]
Type : Stock Item
Child
of : $Name
Belongs
To : Yes
Fetch : Name, PartNo, Description
Option : OrderStockGroupOpeningOrders : ##DSPShowOpening
Option : OrderStockGroupOrdersBooked : ##DSPShowInwards
Option : OrderStockGroupClearedOrders : ##DSPShowOutwards
[Collection: StkVchFilter]
Title : $$LocaleString:"Stock
Entries"
Object : AllVouchers, InwardEntries,
OutwardEntries
Client Only : Yes
[Collection: StockItemOfGroup]
Type : Stock Item
ChildOf
: $Name
[Collection: PendingSalesOrderList]
Type : Sales Orders
Filter : PositiveClosingBalance, DueOnlyFilter,
WithinDateFilter
;; Stock Voucher Template
[Collection: Stock Voucher Template]
Fetch : Date, VoucherNumber, Narration,
IsInwardTrack, PendingQty, SortPosition, CurLangVoucherTypeName,
IsPndgTrackLine
Fetch : MasterId, IsVCHOfStockJrnl, PartyName
Fetch : AllLedgerEntries.StockAffects
Fetch :
AllLedgerEntries.InventoryAllocations.BatchAllocations.BatchName, AllLedgerEntries.InventoryAllocations.BatchAllocations.GodownName
Fetch :
AllLedgerEntries.InventoryAllocations.BatchAllocations.ActualQty,
AllLedgerEntries.InventoryAllocations.BatchAllocations.BilledQty
Fetch : AllInventoryEntries.GodownAutoActualQty,
AllInventoryEntries.GodownAutoAmount
Fetch : AllInventoryEntires.BatchAutoActualQty,
AllInventoryEntries.BatchAutoAmount
Fetch : AllInventoryEntries.StockItemName,
AllInventoryEntries.ItemDSPName,AllInventoryEntries.ActualQty,
AllInventoryEntries.Rate, AllInventoryEntries.Amount,
AllInventoryEntries.BatchAllocations.BatchName
Fetch :
AllInventoryEntries.BatchAllocations.GodownName,
AllInventoryEntries.BatchAllocations.ActualQty,
AllInventoryEntries.BatchAllocations.BilledQty
Fetch : ResidualValueForVoucher
Compute : ResidualValueForVoucher : IF ((##IsItemBatchReport OR
##IsGodownReport OR ##IsItemBatchGdwnReport) AND NOT @@IsPhysStockVch AND NOT
@@IsStockJrnlVch) Then $ResidualValueForVoucher Else $$AsAmount:0
Compute : IsPhysicalStock : @@IsPhysStockVch
Compute : IsRejIn : @@IsRejInVch
Compute : IsRejOut : @@IsRejOutVch
Compute : IsCreditNote : @@IsCreditNoteVch
Compute : IsDebitNote : @@IsDebitNoteVch
Compute : IsMemo : @@IsMemoVch
Compute : IsRevJrnl : @@IsRevJrnlVch
Compute : IsPayroll : @@IsPayrollVch
Compute : IsAttendance : @@IsAttendanceVch
Compute : IsIndentVoucher : @@IsIndentVoucherVch
Compute : IsPurcOrder : @@IsPurcOrderVch
Compute : IsSalesOrder : @@IsSalesOrderVch
Compute : IsInventoryVch : @@IsInventoryVch
Compute : IsStockJournal : @@IsStockJrnlVch
Compute : IsPayment : @@IsPaymentVch
Compute
: IsDelNote : @@IsDelNoteVch
Compute :
IsRcptNote : @@IsRcptNoteVch
Compute
: IsJournal : @@IsJournalVch
Compute : IsVchInvVoucher : $IsInventoryVch AND NOT $IsSalesOrder AND
NOT $IsPurcOrder
Compute
: IsSales :
@@IsSalesVch
Compute :
IsPurchase : @@IsPurchaseVch
Compute
: IsReceipt :
@@IsReceiptVch
Compute : ItemInActQty : If (##IsGodownReport) Then
$$FilterQtyTotal:InventoryEntries:OwnItemInEntries:$GodownAutoActualQty +
Else If ##IsItemBatchReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemInEntries:$BatchAutoActualQty +
Else If ##IsItemBatchGdwnReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemInEntries:$GdwnBatchAutoActualQty +
Else If (##IsMultiPage AND NOT
##InNewPages)Then
$$FilterQtyTotal:InventoryEntries:AllOwnItemInEntries:$TPG_ActualQty+
Else
$$FilterQtyTotal:InventoryEntries:OwnItemInEntries:$TPG_ActualQty
Compute : ItemInAutoQty : If
##IsGodownReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemInRevEntries:$GodownAutoActualQty +
Else If ##IsItemBatchReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemInRevEntries:$BatchAutoActualQty +
Else If ##IsItemBatchGdwnReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemInRevEntries:$GdwnBatchAutoActualQty +
Else If (##IsMultiPage AND NOT
##InNewPages)Then
$$Negative:$$FilterQtyTotal:InventoryEntries:AllOwnItemInRevEntries:$TPG_ActualQty
+
Else
$$FilterQtyTotal:InventoryEntries:OwnItemInRevEntries:$TPG_ActualQty
Compute : ItemOutAccQty : If
##IsGodownReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemOutEntries:$GodownAutoActualQty +
Else If ##IsItemBatchReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemOutEntries:$BatchAutoActualQty +
Else If ##IsItemBatchGdwnReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemOutEntries:$GdwnBatchAutoActualQty +
Else If (##IsMultiPage AND NOT
##InNewPages)Then
$$FilterQtyTotal:InventoryEntries:AllOwnItemOutEntries:$TPG_ActualQty +
Else
$$FilterQtyTotal:InventoryEntries:OwnItemOutEntriesExclMTO:$TPG_ActualQty
Compute : ItemOutAutoQty : If ##IsGodownReport Then $$FilterQtyTotal:InventoryEntries:OwnItemOutRevEntries:$GodownAutoActualQty
+
Else If ##IsItemBatchReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemOutRevEntries:$BatchAutoActualQty +
Else If ##IsItemBatchGdwnReport Then
$$FilterQtyTotal:InventoryEntries:OwnItemOutRevEntries:$GdwnBatchAutoActualQty
+
Else If (##IsMultiPage AND NOT
##InNewPages)Then
$$Negative:$$FilterQtyTotal:InventoryEntries:AllOwnItemOutRevEntries:$TPG_ActualQty
+
Else $$FilterQtyTotal:InventoryEntries:OwnItemOutRevEntries:$TPG_ActualQty
Compute : PhysInValDiff : If
(##IsItemBatchReport) Then
$$FilterAmtTotal:InventoryEntries:StkGodownItem:$BatchInValDiff Else +
If ##IsGodownReport then
$$FilterAmtTotal:InventoryEntries:StkGodownItem:$GodownInValDiff else +
If ##IsItemBatchGdwnReport Then
$$FilterAmtTotal:InventoryEntries:StkGodownItem:$GdwnBatchInValDiff Else +
If (##IsMultiPage AND NOT ##InNewPages)Then
$$PhysInValDiff:$StockItemName:##SVStockBalType Else
$$PhysInValDiff:#StockItemName:##SVStockBalType
Compute : PhysOutValDiff : If (##IsItemBatchReport) Then
$$FilterAmtTotal:InventoryEntries:StkGodownItem:$BatchOutValDiff Else +
If ##IsGodownReport then
$$FilterAmtTotal:InventoryEntries:StkGodownItem:$GodownOutValDiff else +
If ##IsItemBatchGdwnReport Then
$$FilterAmtTotal:InventoryEntries:StkGodownItem:$GdwnBatchOutValDiff Else +
If (##IsMultiPage AND NOT ##InNewPages)Then
$$PhysOutValDiff:$StockItemName:##SVStockBalType Else
$$PhysOutValDiff:#StockItemName:##SVStockBalType
Compute : PhysInDiff : If (##IsItemBatchReport) Then
$$FilterQtyTotal:InventoryEntries:StkGodownItem:$BatchInDiff Else +
If ##IsGodownReport then
$$FilterQtyTotal:InventoryEntries:StkGodownItem:$GodownInDiff else +
If ##IsItemBatchGdwnReport Then
$$FilterQtyTotal:InventoryEntries:StkGodownItem:$GdwnBatchInDiff Else
$$PhysInDiff:#StockItemName:##SVStockBalType
Compute : PhysOutDiff : If (##IsItemBatchReport)
Then $$FilterQtyTotal:InventoryEntries:StkGodownItem:$BatchOutDiff Else +
If ##IsGodownReport then
$$FilterQtyTotal:InventoryEntries:StkGodownItem:$GodownOutDiff else +
If ##IsItemBatchGdwnReport Then
$$FilterQtyTotal:InventoryEntries:StkGodownItem:$GdwnBatchOutDiff Else
$$PhysOutDiff:#StockItemName:##SVStockBalType
Compute : TBalStkClosing : If (##IsItemBatchReport) Then
@@BatchTBalStkClosing Else If (##IsItemBatchGdwnReport)
Then @@BatchGdwnTBalStkClosing Else
$$AsSignedQty:$$ToValue:$Date:$TPG_TBalClosing:StockItem:#StockItemName
Compute : FirstInvName : If
$IsPhysicalStock Then $$LocaleString:"Physical Stock" Else +
If $IsStockJournal Then
$$FirstContraInv:#StockItemName Else $$FirstInvPartyName:#StockItemName
Compute : InVchAmt : If (##IsItemBatchReport)
Then (@@StkBatchInAmt) Else +
If ##IsGodownReport Then (@@StkGodownInAmt)
Else +
If ##IsItemBatchGdwnReport Then
(@@StkBatchGdwnInAmt) Else +
If (##IsMultiPage AND NOT ##InNewPages)Then
@@TPG_AllInVchAmt Else $TPG_StkItemInAmt
Compute : OutVchAmt : If (##IsItemBatchReport) Then
(@@StkBatchOutAmt) Else +
If ##IsGodownReport Then (@@StkGodownOutAmt)
Else +
If ##IsItemBatchGdwnReport Then
(@@StkBatchGdwnOutAmt) Else +
If (##IsMultiPage AND NOT ##InNewPages)Then
@@TPG_AllOutVchAmt Else $TPG_StkItemOutAmt
Compute : NettOutVchAmt : If (##IsItemBatchReport)
Then (@@StkBatchNettOutAmt) Else +
If ##IsGodownReport Then
(@@StkGodownNettOutAmt) Else +
If ##IsItemBatchGdwnReport Then
(@@StkBatchGdwnNettOutAmt) Else +
If (##IsMultiPage AND NOT ##InNewPages)Then
@@TPG_AllNettOutVchAmt Else $TPG_StkItemNettOutAmt
Compute : NettInVchAmt : If (##IsItemBatchReport) Then
(@@StkBatchNettInAmt) Else +
If ##IsGodownReport Then
(@@StkGodownNettInAmt) Else +
If ##IsItemBatchGdwnReport Then
(@@StkBatchGdwnNettInAmt) Else +
If (##IsMultiPage AND NOT ##InNewPages)Then
@@TPG_AllNettInVchAmt Else $TPG_StkItemNettInAmt
[Collection: Vouchers of Stock Item]
Use : Stock Voucher Template
ParmVAR : pvsStockItemName : String : #StockItemName
Type : Vouchers : Stock Item
Collection : StockPendingTrack
Child of : ##pvsStockItemName
;; The
Below 3 computes are added to ensure that, appropriate Method Names and its
Default values are available in the Collection definition before its been
locally modified in Report definition
Compute : TNetSAAuditStatus :
""
Compute : TNetSAAuditNote :
""
Compute : ManualSampling :
""
Sort : @@Default : $IsPndgTrackLine,
$Date ;;;, $SortPosition
Sort : @@SortAlphaIncr : @@FirstContraName, $Date
Sort : @@SortAlphaDecr : -@@FirstContraName, $Date
;; Sort : @@QtyWiseIncr : $$Abs:@@TotalItemVchQty,
$Date
;; Sort :
@@QtyWiseDecr :
-$$Abs:@@TotalItemVchQty, $Date
Option : Vouchers of
Stock Item Browser : $$InMobileBrowserExport
Filter : InOutFilter, IsVCHGodownExist,
IsVCHBatchExists, IsVchGodownBatchExist, IsBatchGodownVouchers
[!Collection: Vouchers of Stock Item Browser]
Compute : BrClQty : $$AsInQty:@@NettInOutTotal
Compute : BrShowClQty : NOT
##DSPShowQty
Compute : BrOutQty
: if
@@IsTreatEnable Then ($$AsOutQty:(If @@IsRejOutVch Then 0 Else If @@IsCreditNoteVch Or
@@IsSalesVch OR @@IsStockJrnlVch OR @@IsRejInVch OR @@IsDelNoteVch Then $$NettQty:$ItemOutAutoQty:$ItemInAutoQty
Else +
$$Negative:$$NettQty:$ItemOutAutoQty:$ItemInAutoQty)) Else (If
@@IsPhysStockVch then $$AsOutQty:$PhysOutDiff else +
If @@IsRejOutVch OR @@IsDebitNoteVch OR
@@IsPurchaseVch OR @@IsRcptNoteVch then 0 else +
If @@IsStockJrnlVch OR @@IsJournalVch OR
@@IsPaymentVch OR @@IsJobMaterialReceiveVch OR @@IsJobMaterialIssueVch Then
$$AsOutQty:$ItemOutAccQty Else
$$AsOutQty:($$AsOutQty:$$NettQty:$ItemOutAccQty:$ItemInActQty))
Compute : BrInQty :
If @@IsTreatEnable Then $$AsInQty:($$AsInQty:(If @@IsRejInVch Then 0 Else If
@@IsCreditNoteVch OR @@IsSalesVch OR @@IsStockJrnlVch OR @@IsDelNoteVch Then $$Negative:$$NettQty:$ItemOutAutoQty:$ItemInAutoQty
Else $$NettQty:$ItemOutAutoQty:$ItemInAutoQty)) +
Else (If @@IsPhysStockVch then
$$AsInQty:$PhysInDiff else +
If @@IsRejInVch OR @@IsCreditNoteVch Or
@@IsSalesVch OR @@IsDelNoteVch then 0 else +
If @@IsStockJrnlVch OR @@IsJournalVch OR
@@IsReceiptVch OR @@IsPaymentVch OR @@IsJobMaterialReceiveVch OR
@@IsJobMaterialIssueVch Then $$AsInQty:$ItemInActQty Else
$$AsInQty:($$AsInQty:$$NettQty:$ItemOutAccQty:$ItemInActQty))
Compute : BrInVal :
if @@IsDebitNoteVch Then (IF (NOT
$$IsEmpty:($$AsOutQty:$ItemInActQty) AND NOT $$IsEmpty:($$AsOutQty:$ItemOutAccQty)
)Then $$NettAmount:$OutVchAmt:$InVchAmt
Else +
if NOT $$IsEmpty:$OutVchAmt then
$$AsDrAmt:$OutVchAmt else $$AsDrAmt:$InVchAmt) Else if @@IsPurchaseVch Then (IF (NOT
$$IsEmpty:($$AsOutQty:$ItemInActQty) AND NOT
$$IsEmpty:($$AsOutQty:$ItemOutAccQty) )Then
$$AsDrAmt:($$NettAmount:$OutVchAmt:$InVchAmt) Else $$AsDrAmt:$InVchAmt ) Else +
if @@IsPhysStockVch then
$$AsDrAmt:$PhysInValDiff else if @@IsSalesVch OR @@IsRejInVch OR @@IsDelNoteVch
OR @@IsCreditNoteVch then 0 else +
if @@IsRejOutVch then $$AsDrAmt:$OutVchAmt
else $$AsDrAmt:$InVchAmt
Compute : BrOutVal :
If @@IsCreditNoteVch Then (If (NOT $$IsEmpty:($$AsOutQty:$ItemInActQty) AND NOT
$$IsEmpty:($$AsOutQty:$ItemOutAccQty) )Then
$$NettAmount:$NettInVchAmt:$NettOutVchAmt Else +
If NOT $$IsEmpty:$NettInVchAmt
Then $$AsCrAmt:$NettInVchAmt Else $$AsCrAmt:$NettOutVchAmt) Else If
@@IsSalesVch Then (If (NOT $$IsEmpty:($$AsOutQty:$ItemInActQty) AND NOT
$$IsEmpty:($$AsOutQty:$ItemOutAccQty) )Then
$$AsCrAmt:($$NettAmount:$NettInVchAmt:$NettOutVchAmt) Else
$$AsCrAmt:$NettOutVchAmt) Else +
If @@IsPhysStockVch Then
$$AsCrAmt:$PhysOutValDiff Else If @@IsPurchaseVch OR @@IsRejOutVch OR
@@IsDebitNoteVch OR @@IsRcptNoteVch Then $$AsAmount:0 Else +
If @@IsRejInVch Then $$AsCrAmt:$InVchAmt Else
$$AsCrAmt:$NettOutVchAmt
Compute : BrShowZeroEntry :
$UseZeroEntries:VoucherType:$VoucherTypeName
[Collection: StockNamePendingTrack]
Object
: StockNameInPending, StockNameOutPending
Filter : TrackInOutFilter
[Collection: StockPendingTrack]
Object : StockInPending, StockOutPending
Filter : TrackInOutFilter
[Collection: Item BatchGodown Voucher]
<unitgroup:itembatchgodownvch>
Use : Master
Name Method Format
Use :
List of ExtractBatchStockItems
Title :
$$LocaleString:"List of Items"
Trigger : Batch Items
Variable : StockItemName
Report : Batch Stock Vouchers
Align :
Right
FullHeight : Yes
Fetch : Name, IsBatchWiseOn, MfdOn,
ExpiryPeriod, HasMfgDate, IsPerishableOn
Filter : IsItemBatchEnabled
;;Collections
[Collection: Item BatchSummary]
Use :
List of ExtractBatchStockItems
Use : Master
Name Method Format
Title :
$$LocaleString:"List of Items"
Variable : StockItemName
Align : Right
FullHeight : Yes
Fetch : Name, IsBatchWiseOn
Filter : IsItemBatchEnabled
[Collection: Item Negative BatchSummary]
Use : Item
BatchSummary
Collection : All Items
Report : STKI Negative Batch Summary
[Collection: List of ExtractBatchStockItems]
Use :
Extract Alias Collection
Title :
$$LocaleString:"List of Stock Items"
Source
Collection : List of Stock
Items
Collection :
BatchStockItem With PartNo
Fetch :
Name
Report :
Stock Item
Variable :
SStockItem
Trigger :
SStockItem
[Collection: Item BatchGodown Summary]
Use :
List of ExtractBatchStockItems
Use : Master
Name Method Format
Title :
$$LocaleString:"List of Items"
Trigger : Item Batch StockItemName
Variable : StockItemName
Report : Item Batch Summary
Align : Right
FullHeight : Yes
Fetch : Name, IsBatchWiseOn, MfdOn,
ExpiryPeriod, HasMfgDate, IsPerishableOn
Filter : IsItemBatchEnabled
[Collection: Item Batch Summary Expired]
Use : Item
BatchGodown Summary
Delete : Report
Add : Report : Item Batch
Summary Expired
[Collection: BatchStockItem With PartNo]
Title :
$$LocaleString:"List of Stock Items"
Use :
Master Name Method Format
Source
Collection : StockItem
PartNoSrc
Walk :
MailingName
Source
Var : IsBatchWiseOn : Logical :
$IsBatchWiseOn
Compute :
Name : $MailingName
Compute : FirstName : $..Name
Compute
:
IsBatchWiseOn : ##IsBatchWiseOn
Align :
Right
FullHeight :
Yes
Set as : $FirstName
;;Collections
[Collection: BatchChildOfItems]
Title : $$LocaleString:"List
of Batches"
Type : Batch
Child
of : ##StockItemName
Fetch : Name, MfdOn, ExpiryPeriod
Full
Height : Yes
Switch : BatchTitle :
NoMfgDtExpiryDtBatchItems : NOT $HasMfgDate:StockItem:#StockItemName AND NOT
$IsPerishableOn:StockItem:#StockItemName
Switch : BatchTitle :
MfgDtExpiryDtBatchItems : $HasMfgDate:StockItem:#StockItemName AND
$IsPerishableOn:StockItem:#StockItemName
Switch : BatchTitle :
MfgDtBatchItems : $HasMfgDate:StockItem:#StockItemName AND NOT
$IsPerishableOn:StockItem:#StockItemName
Switch : BatchTitle :
ExpiryDtBatchItems : NOT $HasMfgDate:StockItem:#StockItemName AND
$IsPerishableOn:StockItem:#StockItemName
Filter : IsItemBatchEnabled
[!Collection:
NoMfgDtExpiryDtBatchItems]
Subtitle : $$LocaleString:"Name"
Format : $$Name, 30
[!Collection
: MfgDtExpiryDtBatchItems]
Subtitle : $$LocaleString:"Name"
Subtitle : $$LocaleString:"Mfg Date"
Subtitle : $$LocaleString:"Expiry Date"
Format : $$Name, 10
Format : $MfdOn, 10
Format : $ExpiryPeriod, 10
[!Collection:
MfgDtBatchItems]
Subtitle : $$LocaleString:"Name"
Subtitle : $$LocaleString:"Mfg Date"
Format : $$Name, 10
Format : $MfdOn, 20
[!Collection:
ExpiryDtBatchItems]
Subtitle : $$LocaleString:"Name"
Subtitle : $$LocaleString:"Expiry Date"
Format : $$Name, 10
Format : $ExpiryPeriod, 20
[Collection: BatchPrimary]
Title :
$$LocaleString:"List of Batches"
Subtitle : $$LocaleString:"Name"
ListName
: $$LocaleString:"Primary
Batch"
Full
Height : Yes
Format : $$Name, 30
ClientOnly : Yes
[Collection: ItemBatchInGodownName]
Title :
$$LocaleString:"List of Batches"
Type : Batches in Godown
Child of : ##DSPGodownName ;;;
$$FieldVar repalced for remoting
Fetch : Name, MfdOn, ExpiryPeriod
Full
Height : Yes
Switch : BatchTitle :
NoMfgDtExpiryDtBatchItems : NOT $HasMfgDate:StockItem:#StockItemName AND NOT
$IsPerishableOn:StockItem:#StockItemName
Switch : BatchTitle :
MfgDtExpiryDtBatchItems : $HasMfgDate:StockItem:#StockItemName AND
$IsPerishableOn:StockItem:#StockItemName
Switch : BatchTitle :
MfgDtBatchItems : $HasMfgDate:StockItem:#StockItemName AND NOT
$IsPerishableOn:StockItem:#StockItemName
Switch : BatchTitle :
ExpiryDtBatchItems : NOT $HasMfgDate:StockItem:#StockItemName AND
$IsPerishableOn:StockItem:#StockItemName
Filter : StockItemNameIsParent
[Collection: BatchGdwnSummaryChildOfItems]
Title :
$$LocaleString:"List of Batches"
Type : Batches in Godown
Child
of : #DSPGodownName ;;; $$FieldVar
repalced for remoting
Fetch : GodownName, BatchName,
IsBatchWiseOn, Nam
Fetch : Name, StkClBalance,
StkOpBalance, StkInQty, StkOutQty, TBalClosing, TBalOpening, TBalDebits,
TBalCredits
Compute : IsGodown : $$IsGodown
Compute : IsStockItem : $$IsStockItem
Compute : IsEmptyObject : $$IsEmptyObject
Compute : IsWithItems : Yes
ColumnVar : DSPGodownName
Sort : @@Default : $BatchName
Sort : @@SortAlphaIncr : $$Type, @@DSPAccName
Sort : @@SortAlphaDecr : $$Type, -@@DSPAccName
Sort : @@AmountWiseIncr : $$Abs:$TBalClosing
Sort : @@AmountWiseDecr : -$$Abs:$TBalClosing
Sort : @@SortMfgDtIncr : $$Abs:$MfdOn
Sort : @@SortMfgDtDecr : -$$Abs:$MfdOn
Sort : @@SortExpiryDtIncr :
$$Abs:$ExpiryPeriod
Sort : @@SortExpiryDtDecr : -$$Abs:$ExpiryPeriod
Sort : @@QtyWiseIncr : $$Abs:$StkClBalance
Sort : @@QtyWiseDecr : -$$Abs:$StkClBalance
Sort : @@RatewiseIncr : $ClosingRate
Sort : @@RatewiseDecr : -$ClosingRate
Filter : StockItemNameIsParent
Filter : BatchMfgDtFltr , BatchExpDtFltr,
BSExpiredBatches
;;Exploding Godown from Batch Summary
[Collection: GodownChildOfOwner]
Type : Batch
Child
of : #StockItemName
Fetch : GodownName, BatchName,
IsBatchWiseOn, Name, OpeningBalance
Fetch : OpeningValue,
StkClBalance, TBalClosing, StkOpBalance, TBalOpening, TBalCredits, StkOutQty,
StkInQty, TBalDebits
Fetch : ClosingRate
Compute : IsEmptyObject : $$IsEmptyObject
Compute : IsWithItems : Yes
Sort : @@Default : $GodownName
Filter : BatchIngdwn, IsGodownofBalType
[Collection : StkItemVchColl]
Source
Collection :
StockBatchChildOfOwner
By :
BatchName :
$BatchName
Aggr
Compute : BatchOpBal : Sum :
$OpeningBalance
Aggr
Compute : BatchOpValue : Sum :
$OpeningValue
Search
Key :
$BatchName
[Collection : StockBatchChildOfOwner]
Type : Batch
Childof :
#StockItemName
Fetch : BatchName, TBalDebits,
StkInQty, TBalCredits, TBalNettCredits, StkOutQty, TbalClosing, StkClBalance,
OpeningBalance, OpeningValue
Filter : IsGodownofBalType
[Collection: StkVchGdwnBatchOPBal]
Source
Collection : StkVchStockItems
Walk :
BatchAllocations
By :
StockItemName : $$Owner:$Name
By
: BatchName : $BatchName
By :
GodownName : $GodownName
Aggr
Compute : OpeningValue : Sum : $OpeningValue
Search
Key :
$StockItemName + $GodownName +
$BatchName
[Collection : StkItemGdwnVchColl]
;source
collection parmvar called in form calling collection then only remote relevant
details are coming
ParmVAR : pvsGodownName : String : If $$IsEmpty:$GodownName
Then #DSPGodownName Else $GodownName
Source
Collection : BatchInGodownName
By :
BatchName :
$BatchName
Aggr
Compute : BatchOpBal : Sum :
$OpeningBalance
Aggr
Compute : BatchOpValue : Sum :
$OpeningValue
Aggr
Compute : BatchTInVal : Sum :
$TBalDebits
Aggr
Compute : BatchTInQty : Sum :
$StkInQty
Aggr
Compute : BatchTOutVal : Sum :
$TBalNettCredits
Aggr
Compute : BatchTOutQty : Sum :
$StkOutQty
Aggr
Compute : BatchTBalVal : Sum :
$TBalClosing
Aggr
Compute : BatchTBalQty : Sum :
$StkClBalance
Search
Key :
$BatchName
[Collection: StkVchStockItems]
Type:
Stock Item
[Collection: InwardTrackOfCompanySrc]
Type : Inwards Tracking Numbers
[Collection: InwardPosTrackOfCompany]
Source
Collection : InwardTrackOfCompanySrc
Fetch : Date, Name, Parent, ClosingBalance, Rate,
ClosingValue, PendingValue, TrackLedger, OpeningBalance, BatchName, GodownName,
Discount
Fetch : LedgerEntries.MasterId,
LedgerEntries.IsVCHOfStockJrnl, LedgerEntries.Date, LedgerEntries.VoucherNumber
Fetch :
LedgerEntries.EffectiveDate, LedgerEntries.VoucherTypeName,
LedgerEntries.IsInvoice ;; Mandatory for Alt+I and Alt+A keys
Fetch :
LedgerEntries.AllocTrackQty
Fetch :
LedgerEntries.AllocTrackValue
Fetch :
LedgerEntries.AdditionalName
Fetch :
LedgerEntries.IsInventoryVch
Fetch : PendingBilledQty,
OpeningBilledQty
Fetch : TrackID
Compute : TrackLedgerAlias : $$ReptField:Name:2:Ledger:$TrackLedger
Compute :
StkItemParentAlias : $$ReptField:Name:2:StockItem:$Parent
Compute :
StkItemParentPNAlias :
$$ReptField:MailingName:2:StockItem:$Parent
Compute :
StkItemParentPNName :
$PartNo:StockItem:$Parent
Compute :
StkItemParentDesc : $Description:StockItem:$Parent
Search
Key : $TrackId
Sort : @@Default : $Date, $Name
Sort : @@SortAlphaIncr : $Parent
Sort : @@SortAlphaDecr : -$Parent
Sort : @@PartyWiseIncr : $TrackLedger
Sort : @@PartyWiseDecr : -$TrackLedger
Sort : @@AmountWiseIncr : $$Abs:$PendingValue
Sort : @@AmountWiseDecr : -$$Abs:$PendingValue
Sort : @@QtyWiseIncr : $$Abs:$ClosingBalance
Sort : @@QtyWiseDecr : -$$Abs:$ClosingBalance
Filter : PositiveClosingBalance
Filter : OrderOfStockItemName, OrderOfLedgerName
Option : BrBillsPendingInfo : $$InMobileBrowserExport
[Collection: InwardNegTrackOfCompany]
Source Collection : InwardTrackOfCompanySrc
Fetch : Date, Name, Parent, ClosingBalance, Rate,
ClosingValue, PendingValue, TrackLedger, OpeningBalance, BatchName, GodownName,
Discount
Fetch : LedgerEntries.MasterId,
LedgerEntries.IsVCHOfStockJrnl, LedgerEntries.Date, LedgerEntries.VoucherNumber
Fetch :
LedgerEntries.EffectiveDate, LedgerEntries.VoucherTypeName,
LedgerEntries.IsInvoice ;; Mandatory for Alt+I and Alt+A keys
Fetch : LedgerEntries.AllocTrackQty
Fetch :
LedgerEntries.AllocTrackValue
Fetch :
LedgerEntries.AdditionalName
Fetch :
LedgerEntries.IsInventoryVch
Fetch : PendingBilledQty,
OpeningBilledQty
Fetch : TrackID
Compute : TrackLedgerAlias : $$ReptField:Name:2:Ledger:$TrackLedger
Compute :
StkItemParentAlias : $$ReptField:Name:2:StockItem:$Parent
Compute :
StkItemParentPNAlias :
$$ReptField:MailingName:2:StockItem:$Parent
Compute :
StkItemParentPNName :
$PartNo:StockItem:$Parent
Compute :
StkItemParentDesc :
$Description:StockItem:$Parent
Search
Key : $TrackId
Sort : @@Default : $Date, $Name
Sort : @@SortAlphaIncr : $Parent
Sort : @@SortAlphaDecr : -$Parent
Sort :
@@PartyWiseIncr : $TrackLedger
Sort : @@PartyWiseDecr : -$TrackLedger
Sort : @@AmountWiseIncr : $$Abs:$PendingValue
Sort : @@AmountWiseDecr : -$$Abs:$PendingValue
Sort : @@QtyWiseIncr : $$Abs:$ClosingBalance
Sort : @@QtyWiseDecr : -$$Abs:$ClosingBalance
Filter : NegativeClosingBalance
Filter : OrderOfStockItemName, OrderOfLedgerName
Option : BrBillsPendingInfo : $$InMobileBrowserExport
[Collection: InwardCldTrackofCompanySrc]
Type : Inwards Tracking Numbers
Cleared
: Yes
[Collection: InwardCldTrackofCompany]
Source
Collection: InwardCldTrackofCompanySrc
Fetch : Date, Name, Parent,
ClosingBalance, Rate, OpeningValue, ClosingValue, PendingValue, TrackLedger,
OpeningBalance, BatchName, GodownName, Discount
Fetch : LedgerEntries.MasterId,
LedgerEntries.IsVCHOfStockJrnl, LedgerEntries.Date, LedgerEntries.VoucherNumber
Fetch :
LedgerEntries.EffectiveDate, LedgerEntries.VoucherTypeName,
LedgerEntries.IsInvoice ;; Mandatory for Alt+I and Alt+A keys
Fetch :
LedgerEntries.AllocTrackQty
Fetch :
LedgerEntries.AllocTrackValue
Fetch :
LedgerEntries.AdditionalName
Fetch :
LedgerEntries.IsInventoryVch
Fetch : PendingBilledQty,
OpeningBilledQty
Fetch : TrackID
Compute : TrackLedgerAlias : $$ReptField:Name:2:Ledger:$TrackLedger
Compute :
StkItemParentAlias : $$ReptField:Name:2:StockItem:$Parent
Compute :
StkItemParentPNAlias :
$$ReptField:MailingName:2:StockItem:$Parent
Compute :
StkItemParentPNName :
$PartNo:StockItem:$Parent
Compute :
StkItemParentDesc :
$Description:StockItem:$Parent
Search
Key : $TrackId
Sort : @@Default : $Date, $Name
Sort : @@SortAlphaIncr : $Parent
Sort : @@SortAlphaDecr : -$Parent
Sort : @@PartyWiseIncr : $TrackLedger
Sort : @@PartyWiseDecr : -$TrackLedger
Sort : @@AmountWiseIncr : $$Abs:$PendingValue
Sort : @@AmountWiseDecr : -$$Abs:$PendingValue
Sort : @@QtyWiseIncr : $$Abs:$ClosingBalance
Sort : @@QtyWiseDecr : -$$Abs:$ClosingBalance
Filter : OrderOfStockItemName, OrderOfLedgerName
[Collection: OutwardTrackOfCompanySrc]
Type : Outwards Tracking Numbers
Filter : IsJobworkTrackEnabled
[Collection: OutwardPosTrackOfCompany]
Source
Collection :
OutwardTrackOfCompanySrc
Fetch : Date, Name, Parent,
ClosingBalance, Rate, ClosingValue, PendingValue, TrackLedger, OpeningBalance,
BatchName, GodownName, Discount
Fetch : LedgerEntries.MasterId,
LedgerEntries.IsVCHOfStockJrnl, LedgerEntries.Date, LedgerEntries.VoucherNumber
Fetch :
LedgerEntries.EffectiveDate, LedgerEntries.VoucherTypeName,
LedgerEntries.IsInvoice ;; Mandatory
for Alt+I and Alt+A keys
Fetch :
LedgerEntries.AllocTrackQty, OrderPreclosureQty, OrderPreclosureDate,
OrderClosureReason
Fetch :
LedgerEntries.AllocTrackValue
Fetch :
LedgerEntries.AdditionalName
Fetch :
LedgerEntries.IsInventoryVch
Fetch : PendingBilledQty,
OpeningBilledQty
Fetch : TrackID
Compute : TrackLedgerAlias : $$ReptField:Name:2:Ledger:$TrackLedger
Compute :
StkItemParentAlias : $$ReptField:Name:2:StockItem:$Parent
Compute :
StkItemParentPNAlias :
$$ReptField:MailingName:2:StockItem:$Parent
Compute :
StkItemParentPNName :
$PartNo:StockItem:$Parent
Compute :
StkItemParentDesc :
$Description:StockItem:$Parent
Search
Key : $TrackId
Sort : @@Default : $Date, $Name
Sort : @@SortAlphaIncr : $Parent
Sort : @@SortAlphaDecr : -$Parent
Sort : @@PartyWiseIncr : $TrackLedger
Sort : @@PartyWiseDecr : -$TrackLedger
Sort : @@AmountWiseIncr : $$Abs:$PendingValue
Sort : @@AmountWiseDecr : -$$Abs:$PendingValue
Sort : @@QtyWiseIncr : $$Abs:$ClosingBalance
Sort : @@QtyWiseDecr : -$$Abs:$ClosingBalance
Filter : PositiveClosingBalance
Filter : OrderOfStockItemName, OrderOfLedgerName
Option : BrBillsPendingInfo : $$InMobileBrowserExport
[Collection: OutwardNegTrackOfCompany]
Source Collection : OutwardTrackOfCompanySrc
Fetch : Date, Name, Parent,
ClosingBalance, Rate, ClosingValue, PendingValue, TrackLedger, OpeningBalance,
BatchName, GodownName, Discount
Fetch : LedgerEntries.MasterId,
LedgerEntries.IsVCHOfStockJrnl, LedgerEntries.Date, LedgerEntries.VoucherNumber
Fetch :
LedgerEntries.EffectiveDate, LedgerEntries.VoucherTypeName,
LedgerEntries.IsInvoice ;; Mandatory
for Alt+I and Alt+A keys
Fetch :
LedgerEntries.AllocTrackQty
Fetch :
LedgerEntries.AllocTrackValue
Fetch :
LedgerEntries.AdditionalName
Fetch :
LedgerEntries.IsInventoryVch
Fetch : PendingBilledQty,
OpeningBilledQty
Fetch : TrackID
Compute : TrackLedgerAlias : $$ReptField:Name:2:Ledger:$TrackLedger
Compute :
StkItemParentAlias : $$ReptField:Name:2:StockItem:$Parent
Compute :
StkItemParentPNAlias :
$$ReptField:MailingName:2:StockItem:$Parent
Compute :
StkItemParentPNName :
$PartNo:StockItem:$Parent
Compute :
StkItemParentDesc :
$Description:StockItem:$Parent
Search
Key : $TrackId
Sort : @@Default : $Date, $Name
Sort : @@SortAlphaIncr : $Parent
Sort : @@SortAlphaDecr : -$Parent
Sort : @@PartyWiseIncr : $TrackLedger
Sort : @@PartyWiseDecr : -$TrackLedger
Sort :
@@AmountWiseIncr :
$$Abs:$PendingValue
Sort : @@AmountWiseDecr : -$$Abs:$PendingValue
Sort : @@QtyWiseIncr : $$Abs:$ClosingBalance
Sort : @@QtyWiseDecr : -$$Abs:$ClosingBalance
Filter :
NegativeClosingBalance
Filter : OrderOfStockItemName, OrderOfLedgerName
Option : BrBillsPendingInfo : $$InMobileBrowserExport
[!Collection: BrVchDateCompare]
Fetch :
LedgerEntries.BrIsVchDateGreater
[!Collection: BrBillsPendingInfo]
Use :
BrVchDateCompare
Fetch :
LedgerEntries.BrAdditionalName
[Collection: OutwardCldTrackOfCompanySrc]
Type :
Outwards Tracking Numbers
Cleared : Yes
[Collection: OutwardCldTrackofCompany]
Source Collection : OutwardCldTrackOfCompanySrc
Fetch : Date, Name, Parent,
ClosingBalance, Rate, OpeningValue, ClosingValue, PendingValue, TrackLedger,
OpeningBalance, BatchName, GodownName, Discount
Fetch : LedgerEntries.MasterId,
LedgerEntries.IsVCHOfStockJrnl, LedgerEntries.Date, LedgerEntries.VoucherNumber
Fetch :
LedgerEntries.EffectiveDate, LedgerEntries.VoucherTypeName,
LedgerEntries.IsInvoice ;; Mandatory
for Alt+I and Alt+A keys
Fetch :
LedgerEntries.AllocTrackQty
Fetch :
LedgerEntries.AllocTrackValue
Fetch :
LedgerEntries.AdditionalName
Fetch :
LedgerEntries.IsInventoryVch
Fetch : PendingBilledQty,
OpeningBilledQty
Fetch : TrackID
Compute : TrackLedgerAlias : $$ReptField:Name:2:Ledger:$TrackLedger
Compute :
StkItemParentAlias :
$$ReptField:Name:2:StockItem:$Parent
Compute :
StkItemParentPNAlias :
$$ReptField:MailingName:2:StockItem:$Parent
Compute :
StkItemParentPNName :
$PartNo:StockItem:$Parent
Compute :
StkItemParentDesc :
$Description:StockItem:$Parent
Search
Key : $TrackId
Sort : @@Default : $Date, $Name
Sort : @@SortAlphaIncr : $Parent
Sort : @@SortAlphaDecr : -$Parent
Sort : @@PartyWiseIncr : $TrackLedger
Sort : @@PartyWiseDecr : -$TrackLedger
Sort : @@AmountWiseIncr : $$Abs:$PendingValue
Sort : @@AmountWiseDecr : -$$Abs:$PendingValue
Sort : @@QtyWiseIncr : $$Abs:$ClosingBalance
Sort : @@QtyWiseDecr : -$$Abs:$ClosingBalance
Filter : OrderOfStockItemName, OrderOfLedgerName
[Collection: AllOrderTemplate]
Fetch : Discount,
Date,Name,TrackLedger,Parent,OpeningBalance,ClosingBalance,Rate,ClosingValue,OrderDueDate,PendingValue
Fetch : OpeningValue, BatchName,
GodownName, OrderPreclosureQty, OrderPreclosureDate, OrderClosureReason
Fetch : OrderOpeningBalance
Fetch : LedgerEntries.MasterId,
LedgerEntries.IsVCHOfStockJrnl, LedgerEntries.Date,
LedgerEntries.VoucherTypeName, LedgerEntries.VoucherNumber,
LedgerEntries.CurLangVoucherTypeName
Fetch :
LedgerEntries.AllocOrderQty
Fetch :
LedgerEntries.AllocIndentQty
Fetch :
LedgerEntries.IsSalesOrder
Fetch :
LedgerEntries.IsCreditNote
Fetch : LedgerEntries.IsRejOut
Fetch : LedgerEntries.IsPurcOrder
Fetch : LedgerEntries.IsDebitNote
Fetch : LedgerEntries.IsRejIn
Fetch :
LedgerEntries.IsInventoryVch
Fetch : OrderID
Compute : IsPurcOrder :
@@IsPurcOrderVch
Compute : IsSalesOrder :
@@IsSalesOrderVch
Compute :
CurLangVoucherTypeName: $Name:VoucherType:$VoucherTypeName
Compute : TrackLedgerAlias : $$ReptField:Name:2:Ledger:$TrackLedger
Compute :
StkItemParentAlias : $$ReptField:Name:2:StockItem:$Parent
Compute :
StkItemParentPNAlias : $$ReptField:MailingName:2:StockItem:$Parent
Compute :
StkItemParentPNName :
$PartNo:StockItem:$Parent
Compute :
StkItemParentDesc :
$Description:StockItem:$Parent
Search
Key : $OrderID
Sort : @@Default : $Date, $$Name
Sort : @@SortAlphaIncr : $Parent
Sort : @@SortAlphaDecr : -$Parent
Sort : @@PartyWiseIncr : $TrackLedger
Sort : @@PartyWiseDecr : -$TrackLedger
Sort : @@AmountWiseIncr : $$Abs:$PendingValue
Sort : @@AmountWiseDecr : -$$Abs:$PendingValue
Sort : @@QtyWiseIncr : $$Abs:$ClosingBalance
Sort : @@QtyWiseDecr : -$$Abs:$ClosingBalance
Filter : OrderAgeFilter
Option : BrVchDateCompare : $$InMobileBrowserExport
[Collection: PurcPosOrderOfCompany Src]
Type : Purchase Orders
ColumnVar : AgeFrom, AgeTo
Filter : PositiveClosingBalance,
OrderDueOnlyFilter
Filter : OrderOfStockItemName,
OrderOfLedgerName, OrderWithinDateFilter
[Collection: Item Movement Analysis]
<unitgroup:itemmovementanalysis>
Use : List of StockItems
Variable : Stock Item Name
Report : Item Movement Analysis
Trigger : MovStockItemName
Fetch : Name
[Collection: Category Analysis]
<unitgroup:categanalysis>
Use : List of StockCategories
Collection : Primary
Variable : Stock Category Name
Report : Category Analysis
Trigger : MovStock Category Name
[Collection: Transfer Analysis]
<unitgroup:transferanalysis>
Use :
Extract Alias Collection
Title :
$$LocaleString:"List of Voucher Types"
Source
Collection : Transfer
AnalysisSrc
Variable : Voucher Type Name
Report : Transfer Analysis
Trigger : Voucher Analysis Name
Full Height : No
Fetch : Name
[Collection: Transfer AnalysisSrc]
Collection : TransferVchStockJrnl
[Collection: TransferVchStockJrnl]
Use : Voucher Type
Child of : $$VchTypeStockJrnl
Belongs To : Yes
[Collection: BatchChildOfOwner]
Type : Batch
Child of : #StockItemName
Fetch : GodownName, BatchName, IsBatchWiseOn, Name,
TrPurcQty, TrPurcValue, TrAvgPurcPrice
Fetch : TrAvgPurcCost, TrSaleQty, TrSaleValue,
TrAvgSalePrice, OpeningBalance
Fetch : OpeningValue, StkClBalance, TBalClosing,
StkOpBalance, TBalOpening, TBalCredits, StkOutQty, StkInQty, TBalDebits
Fetch : ClosingRate,BSDebits, MFdOn,
Expiry Period, StockItemName, TBalNettCredits
Compute : IsEmptyObject : $$IsEmptyObject
Compute : IsWithItems : Yes
Compute : HasMfgDate : $$Owner:$HasMfgDate
Compute : IsPerishableOn:
$$Owner:$IsPerishableOn
Sort : @@Default :
$BatchName, $GodownName
Filter : IsNotThirdPartiesGodown
;; Stock Ageing
[Collection: BatchInGodownName]
Type : Batches in Godown
Child
of : ##pvsGodownName ;;; $$FieldVar
repalced for remoting
Filter : StockItemNameIsParent
Fetch : Name, StkClBalance,
StkOpBalance, StkInQty, StkOutQty, TBalClosing, TBalOpening, TBalDebits,
TBalCredits, TBalNettCredits, MfdOn, ExpiryPeriod, GodownName, IsBatchWiseOn,
BatchName
ParmVAR : pvsGodownName : String : If $$IsEmpty:$GodownName
Then #DSPGodownName Else $GodownName
Compute : HasMfgDate : $$Owner:$HasMfgDate
Compute : IsPerishableOn:
$$Owner:$IsPerishableOn
Compute : IsGodown : $$IsGodown
Compute : IsStockGroup : $$IsStockGroup
Compute : IsStockItem : $$IsStockItem
Compute : IsEmptyObject : $$IsEmptyObject
Compute : IsWithItems : Yes
ColumnVar : DSPGodownName
[!Collection:
With PrimaryCollection]
Collection : Primary
[Collection: JobWorkMaterial]
Type : VoucherType
Child
Of : ##VoucherTypeName
Belongs
To : Yes
Fetch : UseForJobwork,
IsForJobWorkIn, IsActive
Filter : IsJobWorkVchTypeActive
[Collection: JobWorkInMaterial]
Source
Collection : JobWorkMaterial
By :
IsJobWorkIn : If
$$IsEmpty:$IsForJobWorkIn Then No Else $IsForJobWorkIn
[Collection: StockGroupPending]
Option : StockGroupPending Server : NOT $$IsRemoteCompany
Option : StockGroupPending Remote : $$IsRemoteCompany
[!Collection:
StockGroupPending Server]
Use : Alias
Collection
Title : $$LocaleString:"List
of Stock Groups"
Type : Stock Group
Collection : Primary
Fetch : Name
Variable : Stock Group Name
Trigger : Stock Group Name
IsODBCTable : Yes
[!Collection:
StockGroupPending Remote]
Use :
Extract Alias Collection
Title :
$$LocaleString:"List of Stock Groups"
Source
Collection : List of
StockGroups
Collection :
Primary
Variable :
Stock Group Name
Trigger :
Stock Group Name
Fetch :
Name
[Collection: StockCategoryPending]
Option : StockCategoryPending Server : NOT $$IsRemoteCompany
Option : StockCategoryPending Remote : $$IsRemoteCompany
[!Collection:
StockCategoryPending Server]
Use : Alias
Collection
Title :
$$LocaleString:"List of Stock Categories"
Type : Stock Category
Fetch : Name
Variable : Stock Category Name
Trigger : Stock Category Name
IsODBCTable : Yes
Option : With PrimaryCollection : NOT
##DSPShowMonthly
[!Collection:
StockCategoryPending Remote]
Use : Extract Alias Collection
Title : $$LocaleString:"List of
Stock Categories"
Source
Collection : List of
StockCategories
Variable : Stock Category Name
Trigger : Stock Category Name
Fetch : Name
Option : With PrimaryCollection : NOT ##DSPShowMonthly
; ========================================
; Basis of Values
Collection - Inventory
; ========================================
[Collection: BOV Type of Grouping]
Use : DSP Basis of Values Table
Template
Objects : Cfg OrderGroupingType Bov
[Collection: BOV Item Stock Query]
Use : DSP Basis of Values
Table Template
Objects : Cfg ShowAllPartyVouchers Bov, Cfg
ShowNettRate Bov
[Collection: BOV Cost Track Closure]
Use : DSP Basis of Values
Table Template
Objects : Cfg CostTrackType Bov
[Collection: BOV Receipt Variance Job Work]
Use : DSP Basis of Values
Table Template
Object : Cfg
ShowGoodsDelOrdNotRaised Bov, Cfg ShowProductDets Bov
[Collection: BOV Item Batch Summary]
Use : DSP Basis of Values
Table Template
Objects : Cfg IncExpiredBatch Bov, Cfg
IncBatchManufacture Bov
Objects : Cfg IncBatchExpiry Bov
Objects : Cfg GodownType Bov, Cfg ScaleFactor BOV
Explode : Bov Item Batch Summary BatchMfg : $$Type = Cfg IncBatchManufacture Bov
Explode : Bov Item Batch Summary BatchExp : $$Type = Cfg IncBatchExpiry Bov
[Collection:
Bov Item Batch Summary BatchMfg]
Use : DSP Basis of Values
Table Template
Object : Cfg BatchMfgPeriod
[Collection:
Bov Item Batch Summary BatchExp]
Use : DSP Basis of Values
Table Template
Object : Cfg ExpiryPeriod
[Collection: BOV Stock Summary]
Use : DSP Basis of Values
Table Template
Objects : Cfg StkValuationMethodMain Bov, Cfg
CurStockPos, Cfg UseDueOrd Bov
Objects : Cfg GodownType StkSum, Cfg ScaleFactor BOV
[Collection: BOV Job Orders and Components]
Use : DSP Basis of Values
Table Template
Objects : Cfg Type of Grouping Inv Bov, Cfg
ShowCldJobOrders Bov
Objects : Cfg ShowPreClosedOrd Bov, Cfg ShowForexTransLayer
Bov
[Collection: BOV PO and SO Outstanding Common]
Use : DSP Basis of Values
Table Template
Objects : Cfg ScaleFactor BOV, Cfg CurStockPos, Cfg
UseDueOrd Bov
[Collection: BOV PO and SO AllOrders]
Use : DSP Basis of Values
Table Template
Objects : Cfg Type of Grouping Inv Bov, Cfg
ShowPreClosedOrd Bov, Cfg ShowForexTransLayer Bov
[Collection: BOV ScaleFactor and GodownType Common]
Use : DSP Basis of Values
Table Template
Objects : Cfg GodownType Bov, Cfg ScaleFactor BOV
[Collection: BOV CostTrack and ScaleFactor Common]
Use : DSP Basis of Values
Table Template
Objects : Cfg CostTrackType All Bov, Cfg ScaleFactor
BOV
[Collection: BOV Stock Valuation and GodownType Common]
Use : DSP Basis of Values
Table Template
Objects : Cfg VchEntryType Bov, Cfg
StkValuationMethodMain Bov, Cfg GodownType Bov
[Collection: BOV Top Buyers and Sellers]
Use : DSP Basis of Values
Table Template
Object : Cfg ShowNoOfBuyerSeller Bov, Cfg
IncBranchDivisions Bov
[Collection: BOV TypeOfVchEntries and GodownType]
Use : DSP Basis of Values
Table Template
Object : Cfg VchEntryType Bov, Cfg GodownType Bov
[Collection: BOV GodownType Common]
Use : DSP Basis of Values
Table Template
Object : Cfg GodownType Bov
;; End-of-file
No comments:
Post a Comment