TDL for Previous & current Balance on invoice ( not in Excise but in normal)

Another home work I have done.


Please check and correct me if any code is wrong.

[*Part: EXPINV Words]
Lines : EXPINV WordTitle , EXPINV AmtInWords,prevbal,Billamt,Closingbal
Space Bottom: 0.25
Option : WithVATValue : (@@IsSales OR @@IsPurchase) AND @@IsIndianVATVch AND @@InvVATAnalysis
Option : WithExciseValue : @@IsSales AND @@IsIndian AND NOT $$IsEmpty:$ExciseRegn:Company:##SVCurrentCompany AND ##ICFGExcisePrinting
Option : WithServiceTaxValue: (@@IsSales OR @@IsPurchase OR @@IsReceipt OR @@IsPayment OR @@IsPurcOrder OR @@IsSalesOrder OR @@IsDebitNote OR @@IsCreditNote) AND @@IsIndianServiceTax AND $$STXCanUpdateDutyLed



[Part:lastbal]
Line: prevbal
Line:Billamt
Line:Closingbal1
[Line: prevbal]
Fields: Prevbalt,prevbald1
[Line: Billamt]
Fields: Billamtt, Billamtd
[Line:Closingbal]
Field:Closingbalt,Closingbald
[Field: Prevbalt]
Info:"Prev.Balance"
Width:10
[Field: prevbald1]
Use:Amount Field
Set as: ($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)-$$abs:#EXPINVTOTAL
[Field: Billamtt]
Info:"Bill Amount"
Width:10
[Field: Billamtd]
Use:Amount Field
Set as:#EXPINVTotal
[Field:Closingbalt]
Info:"Curr.Balance"
Width:10
[Field:Closingbald]
Use:Amount Field
Info:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries

 

Dear Experts,

Any one can help how to display pending no. of days besides the previous Balance i.e., from the previous balance first bill date to current date difference

Thanks in advance

Srini

 

In your case if there is 100 invoices is pending it will be ugly .Better attach age wise analysis statement.

 

Dear Experts,

Not to display all of the bills & days. only the first bill due days out of 100 the first one even if 1 rupee pending. (Screenshot attached)

And also tell how to add discount column (line wise) in the regular ledger voucher display, when show inventory details also enabled or using shift enter.

Thanks in advance,

Srini

 

good work !!!!

but friend the said tdl does not take care of Dr and credit
hence, its showing adverse results, will you please correct it

 

Thank you for your feedback.

I am working on it. I have found some other problem also

 

Please check the tdls. Please tell me if any other error is there in my Tdl.

Previous Balance on Invoice Opt A.txt is useful when there is one invoice to single party in a day.( one invoice each to different parties no problem)
Previous Balance on Invoice Opt b.txt is useful when there is multiple invoice to single party. ( if we use first tdl when we take print out of invoice in alter mode it will give wrong info when there is more than one invoice to a single party)

 

I also request experts to give another idea to solve the problem of multiple invoice in a day.

I like to know is there any function to know the balance based on invoice number.

 

i will check it
thank you very much for your quick reply

 

Good code but Mr. Srinivasa Rao requerment is Bill Wise Outstaning Report In Invoice...

 

grt

 

please tell me is this tdl ok

 

john thank you for correction!!!!
but i have created one of voucher type as cash sales (ledger:cash) where in
your above tdl is showing our current cash balance in closing balance so
can you please add some filters for voucher type where in for cash sales
your tdl should be de activated

thanking you in advance

 

john will please let me know how to add exception to specific ledger(cash) or voucher type ( like cash sales) in your above previous balance tdl as the same is not needed for above types.....Thanks in advance

 

Use this line : Remove If : $LedgerName = "Cash" in every line then you will not see the effect of previous balance tdl.

 

Thank you Mr. kirantikare for your valuable suggestions.

Thank you Mr.Gopal Rajbhandari. Actually I could not get time to find out a solution (since auditing is started ). Thank you very much from the bottom of my Heart.

Jobimon

 

Thank you gopal sir , i will try it , have a nice day....

 

Dear Admin / Experts,

Can help me in by providing syntax for 1st bill due days out of the total pending bills.
only the first bill due days out of 100, the first one even if 1 rupee pending.
(Screenshot attached)

And also tell how to add discount (line wise) column in the regular ledger voucher display, when show inventory details also enabled or using shift enter.

Thanks in advance,

 

I have created a TDL in which I have been able to add a salesman field in sales voucher and it shows as well in the columnar sales report. I also need to view the current closing balance of the respective debtors , which apparently I am not been able to view.

Please let me know what is wrong with my code.

 

HELLO COLLEAGUES

Pls Sove my problem

I add a Logical Field in Basic Company
Field Name :Is showroom ?
storage=companylocation logical

in sales voucher or Receipt Voucher
if showroom is set "NO" then salesperson is inactive in sale and receipt Voucher

what is the code for this logic

Please Help me

 

Please share the codes.

 

Sir, nice code
Thanks

Ravi Bansal

 

Hello Mr. John,

First of all thanks for sharing the code.

It is indeed very good piece of work by you, I have seen it and checked it, it is not taking care of the Sales Return Entry while passing the Sales return Entry it is showing wrong Previous Balance. As in the attached file sales return shows wrong prev balance, but current balance is OK.

 

This code is meant for sales entry only .to disable the same in credit note please add following code

Code:

Invisible:not $$IsSales