If you were using this value to calculate Invoice then you would be under-invoicing......... it is better to divide the Sq.Ft by 10.76 ........ i.e. 100/10.76 .... instead of using factorial multiplication. In the screenshot above..... adopt the division by 10.76 and check the results. 10.76 is a standard, ignoring the rest of the decimals as is the normative practice followed all over.
Thank you for suggestion. Actually this conversion factor given by customer. Let me ask customer if he is ok then we shall implement it. but we can use it for other sq.mt conversion factor.
Closing balance is calculating correctly but previous balance & current bill amount is not capturing. If i disabled customised invoice tld and attach previous balance tdl then it is working fine. Please guide. [Field: prevbald] Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : "Prev. Balance:" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : If ($$IsDr:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) + then($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)-$$abs:#EXPINVTOTAL else + ($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)+$$abs:#EXPINVTOTAL Local : Field : Amount Field : Format : "Symbol,DrCr" [Field: Billamtd] Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info :$$LocaleString:"Bill Amount:" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : #EXPINVTotal Local : Field : Amount Field : Format : "Symbol,DrCr" [Field: Clobal] Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : "Net Balance :" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : $$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries Local : Field : Amount Field : Format : "Symbol,DrCr"
Problem is...might be there is no value in #EXPINVTOTAL ................ as a R&D, remove all #EXPINVTOTAL and see....if the other figures come....................
Yes removed #EXPINVTOTAL and added: $$CollAmtTotal:LedgerEntries:$Amount. after that total value is not coming. only gross amount is coming.
what is ur field name of the Invoice Total??? I did not ask you to add anything....just remove something......and then see.
If I removed #EXPINVTOTAL then showing error in Set As: Invoice total field is [Line:OTS Invoice Amount] Field: Name Field, Amount Field Local:Field: Name Field: Set as: "INVOICE TOTAL" Local:Field: Name Field: Style: Large Bold Local:Field: Name Field: Width:22.6 Local:Field: Name Field: Align: Right Local:Field: Amount Field: Set as: $Amount Local:Field: Amount Field: Style: Large Bold Local:Field: Amount Field: Width: 9 Local: Field: Amount Field: Align: Right Border: Thick Top Space Top: 2.5 Space Bottom: 0.5
study the file from where u copied the SET AS for the mini statement........... it is using a "local formula" to compute then referring to that formula in the SET AS........... you use it the same way.
Amitjee.. #EXPINVTOTAL replaced with $Amount. Code is working fine. [Field: prevbald] Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : "Prev. Balance:" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : If ($$IsDr:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) + then($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)-$$abs:$amount else + ($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)+$$abs:$amount Local : Field : Amount Field : Format : "Symbol,DrCr" [Field: Billamtd] Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info :$$LocaleString:"Bill Amount:" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : $amount Local : Field : Amount Field : Format : "Symbol,DrCr" [Field: Clobal] Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : "Net Balance :" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : $$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries Local : Field : Amount Field : Format : "Symbol,DrCr"
1) I have created class given multiple gst rate & other charges. if my other charges is 0 then it should not show in invoice print. [Part: OTS Bottom Part 1 Right] Line: OTS Invoice Ledger Entries Repeat: OTS Invoice Ledger Entries:LedgerEntries Bottom Line: OTS Invoice Amount Common Border: Yes Border: Thick Left [Line: OTS Invoice Ledger Entries] Field: Name Field, Amount Field Local: Field: Name Field: Set as:if $$Isempty:$LedgerName then "" else $LedgerName ; Local: Field: Name Field:Invisible : $$Isempty:$LedgerName Local: Field: Name Field: Style: O9 Local: Field: Name Field: Width:22.6 Local: Field: Name Field: Align: Right Local: Field: Amount Field: Set as:$Amount;$Amount Local: Field: Amount Field: Style: O9B Local: Field: Amount Field: Border: Thick Left Local: Field: Amount Field: Width:9 Remove if: $LedgerName contains $PartyLedgerName Invisible : if $$Isempty:$LedgerName then "" else $LedgerName Space Top:0.25 2) 2) Second query is i have disabled : Enable supplimentary details: No. Then party address & GSTIN is not printing.
@amit Kamdarji and all..please guide. 1) I have created class given multiple gst rate & other charges. if my other charges is 0 then it should not show in invoice print. it is taking too much space. [Line: OTS Invoice Ledger Entries] Field: Name Field, Amount Field Local: Field: Name Field: Set as:if $$Isempty:$Amount then "" else $LedgerName 2) Second query is i have disabled : Enable supplimentary details: No. Then party address & GSTIN is not printing.
1) I have created class given multiple gst rate & other charges. if my other charges is 0 then it should not show in invoice print. it is taking too much space. [Line: OTS Invoice Ledger Entries] Field: Name Field, Amount Field Local: Field: Name Field: Set as:if $$Isempty:$Amount then "" else $LedgerName ; Seen default code of accouting details line [Line: EXPINV AccDetails] Taken lot of time to resolve this issue. Empty : $$IsEmpty:$Amount AND $RemoveZeroEntries Now, this issue has been resolved.
2) Second query is i have disabled : Enable supplimentary details: No. Then party address & GSTIN is not printing. This issue also resolved.
As per your condition specified, you are coding it .... to remove "If empty - ledgername", instead you sud give condition $$IsEmpty:#Amountfield or #Amountfield=0 As for 2nd query ......you need to force Tally to accept the "enable" in printmode.....check/scan the default code in TDE of Partyaddress and GSTIN and why it is being preventing printing when supplementary details is disabled.