Help on "Last Payment Details in Invoice Entry"

DEAR DEVELOPERS,
I WANT LAST PARTY'S LAST RECEIVED AMOUNT & DATE IN INVOICE ENTRY, BUT IT'S NOT WORKING SOMETIMES WHILE CREATING INVOICE, IN ALTER MODE IT'S WORKING FINE, PLEASE HELP FOR THE FIELD "Party Last Pymt",
FILE IS ATTACHED,
THANKS IN ADVANCE

 

You are confusing with Invoice Entry Field with Invoice Print Fields

I have tried to correct it.


make changes to your code as per code attached

Code:

;;------------------------------------------------------------------------------
;; Outstanding Details
;;------------------------------------------------------------------------------

[#Part: VCH GST Analysis]
   
    Option        : VCH GST Analysis GST    : @@IsGSTOnAndAppl ;AND @@GSTInvoiceModule AND @@SameCountry
   
[!Part: VCH GST Analysis GST]
   
    Add            : Part        : VCH Party PrevBalance
   
[Part: VCH Party PrevBalance]

    Line        : EXPINV SubTitle, VCH Party PrevBalance, VCH Party Last Payment
    Local        : Line        : EXPINV SubTitle    : Local    : Field        : EXPINV SubTitle    : Info        : "Mini Statement (*Ignore if Paid)"
    Local        : Line        : EXPINV SubTitle    : Local    : Field        : EXPINV SubTitle    : Style        : Small Bold
    ;Local        : Field        : Party Last Pymt    : Set as    : $PartyLastPymt
    Space Top   : 0
    Border      : Thin Top Left Right

[Line: VCH Party PrevBalance]

    Field       : Simple Prompt, Party PrevBalance, Medium Prompt, Party Bill Value, Simple Field, Party Net Balance
    Local       : Field : Simple Prompt        : Set as : $$LocaleString:"PrevBalance :"
    Local       : Field : Simple Prompt        : Width  : 13
    Local       : Field : Medium Prompt        : Set as : $$LocaleString:"Bill Value :"
    Local       : Field : Medium Prompt        : Width     : 13
    Local       : Field : Simple Field      : Set as : $$LocaleString:"Net Balance :"
    Local       : Field : Simple Field      : Width  : 13
   
[Field: Party PrevBalance]

    Type        : Amount    : Forced
    Set as         : If $$InAlterMode then #PartyNetBalance - #EIValueTotal else $ClBalLastVchDate:Ledger:$PartyLedgerName
    Set Always    : Yes
    Storage        : Party PrevBalance
    Width       : @@AmountWidth + 5
    Style       : Normal Bold
    Format      : "No Zero, Symbol," + ##ShowForex
    Align       : Left
    Invisible    : NOT ($$InPrintMode OR $$InExportMode OR $$InMailAction) OR ($$InCreateMode OR $$InAlterMode)
   
[Field: Party Bill Value]

    Type        : Amount    : Forced
    Set as         : #EXPINVInvTotal
    Set Always    : Yes
;    Storage        : Party Bill Value
    Width       : @@AmountWidth + 5
    Style       : Normal Bold
    Format      : "No Zero, Symbol," + ##ShowForex
    Align       : Left
    Invisible    : NOT ($$InPrintMode OR $$InExportMode OR $$InMailAction) OR ($$InCreateMode OR $$InAlterMode)
   
[Field: Party Net Balance]

    Type        : Amount    : Forced
    Set as        : If $$InAlterMode then $ClBalLastVchDate:Ledger:$PartyLedgerName else #PartyPrevBalance + #EXPINVInvTotal
    Set Always    : Yes
    ;Storage        : Party Net Balance
    Width       : @@AmountWidth
    Style       : Normal Bold
    Format      : "No Zero, Symbol," + ##ShowForex
    Align       : Right
    Invisible    : NOT ($$InPrintMode OR $$InExportMode OR $$InMailAction) OR ($$InCreateMode OR $$InAlterMode)
   
[Line: VCH Party Last Payment]

    Field       : Simple Prompt, Party Last Pymt, Medium Prompt, Party Last Pymt Date
    Local       : Field : Simple Prompt        : Set as : $$LocaleString:"Last Received Payment :"
    Local       : Field : Simple Prompt        : Width  : 20
    Local       : Field : Simple Prompt        : Style     : Normal Italic
    Local       : Field : Medium Prompt        : Set as : $$LocaleString:"Dt. :"
    Local       : Field : Medium Prompt        : Width     : 3
    Local       : Field : Medium Prompt        : Style     : Normal Italic
    Local       : Field : Medium Prompt        : Inactive: $$IsEmpty:#PartyLastPymt
   
[Field: Party Last Pymt]

    Use            : Amount Field
    Type        : Amount    : Forced
    Set as         :  $$CollectionField:$Amount:1:PartyLastPayment ;else $$FilterValue:$Amount:PartyLastPayment:1:DummyFormula
    Set Always    : Yes
    ;Storage        : Party Last Pymt
    ;Width       : @@AmountWidth
    Style       : Normal Bold
    Format      : "No Zero, Symbol," + ##ShowForex
    Align       : Left
   
[Field: Party Last Pymt Date]

    Use            : Uni Date Field
    ;Type        : Date        : Forced
    Set as         : $$CollectionField:$Date:1:PartyLastPayment ;else $$FilterValue:$Date:PartyLastPayment:1:DummyFormula
    Set Always    : Yes
    ;Storage        : Party Last Pymt Date
    Width       : @@ShortDateWidth + 3
    Style       : Normal Bold
    Align       : Left
    Inactive: $$IsEmpty:#PartyLastPymt

[Collection : Party Last Payment]
   
    Parm VAR     : SVCurrentDate : Date : ##SVCurrentDate
    Parm Var    : svFromDate    : Date  : @@CMPStartDate
    Parm Var    : svToDate      : Date  : @@FinYrEnding
    ;Parm Var    : svCurrentDate : Date  : ##SVCurrentDate
    Parm Var    : pConsignee    : String: #EXPINVPartyLedName

    Type         : Vouchers : Ledger
    Child Of     : ##pConsignee ;#EIConsignee;
    Walk         : All Ledger Entries
   
    Filter       : Receipt;, SameLedger
    Sort        : @@Default        : -$Date
    Fetch        : Amount, AllLedgerEntries.Amount, Date, AllLedgerEntries.Date
   
   
[System:Formulae]
    Receipt : $$IsReceipt:$VoucherTypeName
   

 

YOU DON'T UNDERSTAND, WHAT I AM SAYING IS THAT WHEN WE CHANGE DATE OF INVOICE ENTRY, THEN CODE IS NOT WORKING, WITHOUT CHANGING DATE IT'S WORKING WELL

 

Dear Mr. Amit Kamdar, I didn't say anything wrong, but still i am sorry, can you help me or not?

 

Dear Keshav,

This was your query :

DEAR DEVELOPERS,
I WANT LAST PARTY'S LAST RECEIVED AMOUNT & DATE IN INVOICE ENTRY, BUT IT'S NOT WORKING SOMETIMES WHILE CREATING INVOICE, IN ALTER MODE IT'S WORKING FINE, PLEASE HELP FOR THE FIELD "Party Last Pymt",
FILE IS ATTACHED,
THANKS IN ADVANCE

Now you are saying:
YOU DON'T UNDERSTAND, WHAT I AM SAYING IS THAT WHEN WE CHANGE DATE OF INVOICE ENTRY, THEN CODE IS NOT WORKING, WITHOUT CHANGING DATE IT'S WORKING WELL

Can you tell me, where did you mention the "date change" part.. (I think it is there in your other post, but not this).

 

And this code is working fine even if you change date 10 times.

did you try ? I think you first made this post.. and you made another post where that date change issue is mentioned.

see the link

http://www.tdlexpert.com/index.php?threads/help-on-bank-name-in-invoice-entry-please.6544

and now your are BOLDLY describing the date change issue here .. Who is confused ??

 

Krishna = Kishan/keshav/madhav/kanhaiya........

 

I get it now, I didn't know the meaning of writing in bold letters, therefor i am extremely sorry to all, i will never do this again,

thanks for the reply, also note that problem is solved now, but i have another problem with email after save module & i will seek help for that in new thread, i hope you will help me

once again i am sorry

 

HA Ha.. good logic.

... These smilies are not smilies ..Horro Smilies

 

Yes I know, your intention was not that..with CAPITALS.

 

..
He is Kishan. Sorry.

 

Dear Amit ji,

Could you please help me with code for debtor age analysis printed on invoice.

Thanks

Pradeep

 

Amit ji,

Am a beginner, trying to learn, yet to make code on my own. Wished to have Debtor’s age wise analysis printing on invoices issued by me.
If possible, please post the code.

Thanks
Pradeep

 

In above code How to select the Last Received Payment amount and date which is received before the INVOICE created.
Example:
Invoice Date Amount
01/04/2020 10000.00
03/04/2020 15000.00
05/04/2020 16000.00
07/04/2020 20000.00

Payment Received
02/04/2020 10000.00
04/04/2020 15000.00
08/04/2020 36000.00

Now if I print the invoice of 03/04/2020 it show Last Received Payment is 36000.00 Dated 08/04/2020. (Required to show Last Received Payment is 10000.00 dated 02/04/2020)

Please Guide me changes in above Code.

Thanking you in advance.

 

Respected Experts!

Please guide if I want to add a button while printing invoice for the option to add outstanding details in invoice.

Code:

[#Form: SV Print Config]
    Add         : Top Button     : At Beginning      : Set Balance

[Button: Set Balance]

    Key         : Alt+B
    Action      : Execute : SetBalance
    Title       : $$LocaleString:"Print Balance"

[Report: SetBalance]

    Auto    : Yes
    Title    : $$LocaleString:"Set Balance"

 

OK Sir, but my idea is that the user will have the option to enable or disable it.