[go: up one dir, main page]
Scribd
Upload
52 views1 page

Sales Explode

The document outlines various collections related to sales vouchers and orders, including their types, filters, and data fetching methods. It details the structure of collections like VcSalesVouchersSrc, VcSalesDetailsColl, VcOrderDetailsColl, and VcOrderColl, specifying how data is organized and accessed. Additionally, it includes system formulas for filtering and computing relevant fields within these collections.

Uploaded by

Dileep Mishra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
52 views1 page

Sales Explode

The document outlines various collections related to sales vouchers and orders, including their types, filters, and data fetching methods. It details the structure of collections like VcSalesVouchersSrc, VcSalesDetailsColl, VcOrderDetailsColl, and VcOrderColl, specifying how data is organized and accessed. Additionally, it includes system formulas for filtering and computing relevant fields within these collections.

Uploaded by

Dileep Mishra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

[Collection : VcSalesVouchersSrc]

Type : Vouchers : VoucherType


Child Of : $$VchTypeSales
Belongs To : Yes
Filter : ChkParty

[Collection : VcSalesDetailsColl]

Source Collection : VcSalesVouchersSrc


Walk : Inventory Entries
By : VoucherNumber : $VoucherNumber
By : PartyLedgerName : $PartyLedgerName
By : StockItemName : $StockItemName
Fetch : StockItemName, BilledQty, Rate, Amount
Fetch : VoucherNumber, Date, PartyLedgerName, OrderNo;, OrderDueDate
Filter : CheckItem
Filter : CheckOrder

[System : Formulae]
ChkParty : #VcPartyName = $PartyLedgerName
CheckItem : #VcItemName = $StockItemName
CheckOrder : #VcOrdNo = $OrderNo

;; Sales Order Details Collection


[Collection : VcOrderDetailsColl]
Source Collection : VcOrderColl
Fetch : BilledQty, Amount, StockItemName, PartyLedgerName
Compute : Date : $date
Walk : InventoryEntries
By : VoucherNumber : $VoucherNumber
By : PartyLedgerName : $PartyLedgerName
By : StockItemName : $StockItemName
Sort : @@Default : $Date, $VoucherNumber, $PartyLedgerName

;; Sales Order Master Collection


[Collection: VcOrderColl]
Type : Voucher
Fetch : PartyLedgerName, Date, VoucherNumber, Amount
Filter : VcIsSalesOrder
Sort : Default : $Date, $PartyLedgerName

[System: Formula]
VcIsSalesOrder : $$IsSalesOrder:$VoucherTypeName
VcInvoiceFilter : $$IsSales:$VoucherTypeName

You might also like