"Balance (LCY)" & "Balance Due (LCY)&quot

Jyoti_Kapoor
Jyoti_Kapoor Member Posts: 56
edited 2005-06-03 in NAV/Navision Classic Client
In 2.x version, fields "Balance Due (LCY)" in customer and vendor table on drill down, used to show the open cust. ledger enties and was the sum of "remaining amount (LCY)" field of that table. And the field "Balance (LCY)" used to show all the entries.
But in 370, the calcformula of the both the fields "Balance (LCY)" & "Balance Due (LCY)" has been changed to be the sum of the "Amount (LCY)" field of the "detailed cust. ledger entry". Now, "Balance Due (LCY)" shows the whole list, not the ones as it used to in 2.x versions. But the field "Balance (LCY)" field shows less no. of entries. Can some one explain the reason for this.

Thanks & Regards,
Jyoti

Comments

  • Sbhat
    Sbhat Member Posts: 301
    You are referring a change from 2.x to 3.70, there has been a considerable amount of changes in 3.70 where you have value entries and the way Balance field drills down is quite different to 2.x.

    SB.
  • Savatage
    Savatage Member Posts: 7,142
    One of the changes I made was create a new command button on the customer card that just shows the open entries.

    RunObject: Form Customer Ledger Entries
    RunFormView: SORTING(Entry No.) ORDER(Ascending) WHERE(Open=FILTER(Yes))
    RunFormLink: Customer No.=FIELD(FILTER(No.))

    This way we don't have to weed thru hundreds of entries to see what's open at the click of a button
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org

Categories