Hello everyone, I want to create a collection which gives me the closing value for each stock item for each day. I am using this tdl : [Collection: Voucher Collection] Type : Voucher [Collection: ClosingBalance] Source Collection : Voucher Collection Walk : All Inventory Entries By : StockItem: $StockItemName By: Date:$Date Fetch : StockItemName, OpeningBalance, ClosingBalance, Billed Qty But the closing and opening balance columns are empty with null values. Please help me with this.
Hello everyone, I have still not figured out why this issue is occurring, and hence my project is delayed. Can somebody from the experts help me with this?
[Collection:NEW COLL] Type:VOUCHER [Collection:CLS] Source Collection:NEW COLL Walk:INVENTORY ENTRIES Compute Var:STKITEM:String:$stoCKITEMNAME Compute Var:GDW:String:$GODOWNNAME Compute Var:CLOSINGBAL:Number:$$GodownItemValue:##GDW:##STKITEM$$Number:$CLOSINGBALANCE) By:ITEM:##STKITEM By:GD:##GDW Compute:COLS:##CLOSINGBAL Compute:AMT:$AMOUNT
Hello, Thank you for your help, but I am getting the final (current) values for each stock item, I was trying to get the daily closing balance of each stock item, tried to change your tdl a little bit, but did not get the desired result. I am attaching a photo which shows how I wanted the table. Can you please help me with that?
Use Filter at collection level Example: [Collection: MyCollection] Type: StockItem Filter: MyFilter [System: Formula] MyFilter: ;;;Paste Your Conditions Here
thank you himanshu sir, as I am new to tdl and not exactly a developer, I don't know how can I use this filter to get the required data, can you help me with that, by giving me an example.
Example: [Collection: VoucherCollection] Type: Vouchers Fetch: Date Filter: MyDateFilter [System: Formula] MyDateFilter: $Date = $$MachineDate