Dear Experts There is a difference in adding the opening and closing balance in ledger voucher and opening balance is not fetching the details in Print. Secondly there is a Subtraction in NW and Metal it is okay in Ledger Voucher but not fetching in print....Pls help.. Code: ;=========================================LEDGER REPORT FOR PRINT ==================================== [#Line : LV Title] Add : Field : After : LEDMailName : LVOpngTitle, LVOpngBal [Field : LVOpngTitle] Info : "LBS / LBG :" Width : 15 Align : Left Color : Yellow Background : Goodwill3 [Field : LVOpngBal] Use : Number Field Set as : $$Total:NWAmt-$$Total:MAmt Width : 15 Format : Decimal:3 Storage : LDRTOTAL Align : Left Color : Yellow Background : Goodwill3 [System:UDF] LDRTotal:Number:6589
Have you defined the TOTAL in Part level (of the Print code) -- if not -- you cannot use the Function $$Total ---- If appearing in Ledger but not in Print -- means the total has not been defined in the Print code. If in your report and the Print-report the Fields are the same -- then use the Field Name to get the values. e.g. -- #Fld1 - #Fld2
Sir I had already use the total in Part level but unable to take the results...but still $$total function is not working Can I send you the code on your email
Sir there is difference in closing balance total and why the opening balance is not fetching from LV Part.... secondly the difference of LBG/ LBS from LV part is not fetching in print.... the code suing for print is given below: [#Line: LV ClosingBalance] Add: Line :Before : LVFCThreeSP VchRDClgTitle [LineSP VchRDClgTitle] LineSP VchRDTitle [LineSP VchRDTitle] Invisible : NOT $$InPrintMode Fields:Simple Prompt, DSPLPD1, DSPLPD2, DSPLPD3, DSPLPD4 Local:Field:Simple Prompt:Info:"Closing Balance" Local:Field:Simple Prompt:Style:Extra Large Bold Local:Field:Simple Prompt:Space Left:6 Border:Thin top Bottom [FieldSPLPD1] Use:Number Field Formatecimal:3 Space Left:2.7 Set as:$$Total:GWAmt Set Always:Yes [FieldSPLPD2] Use:Number Field Formatecimal:3 Space Left:6.5 Set as:$$Total:NWAmt Set Always:Yes [FieldSPLPD3] Use:Number Field Formatecimal:3 Space Left:3.5 Set as:$$Total:MAmt Set Always:Yes [FieldSPLPD4] Use:Number Field Formatecimal:2 Space Left:6.5 Set as:$$Total:LbrAmt Set Always:Yes [#Part: DSP VchTitle] Add: Line : BeforeSP VchTitleSP VchRVTitle Option: JWDSPT : @@IsJewelSft [!Part: JWDSPT] TotalSPLD1, DSPLD2, DSPLD3, DSPLD4 [!Line:JWDSPT] Invisible: Not $$InPrintMode [LineSP VchRVTitle] Invisible : NOT $$InPrintMode Left Fields:Simple Prompt, DSPLD1, DSPLD2, DSPLD3, DSPLD4 Right Fields: Medium Prompt, DSP VchLD2 Local:Field:Simple Prompt:Info:"Opening Balance" Local:Field:Simple Prompt:Style:Extra Large Bold Local:Field:Simple Prompt:Space Left:6 Local:Field:Medium Prompt:Info:"Lbs / Lbg :" Local:Field:Medium Prompt:Style:Extra Large Bold Local:Field:Medium Prompt:Space Right:30 [FieldSPLD1] Use:Number Field Formatecimal:3 Space Left:3.7 Set as:$$Total:LEDNARR Style: Normal Bold [FieldSPLD2] Use:Number Field Formatecimal:3 Space Left:7 Set as:$$Total:LEDNARR1 [FieldSPLD3] Use:Number Field Formatecimal:3 Space Left:4.8 Set as:$$Total:LEDNARR2 [FieldSPLD4] Use:Number Field Formatecimal:2 Space Left:7 Set as:$$Total:LEDNARR3 [FieldSP VchLD2] Use : Amount Field Set as : $$String:$LDRTOTAL Width : 15
Pls let me know what is the error in this code ..so that the new opening balance in ledger voucher will show in print