HI All Experts, Need Help..... When you enter any Accounting Entry and when you debit a Ledger A/c..... I want to set condition.... if that ledger belongs to "Sundry Debtors" then on after inputing the Amount, the Form should pop-up, else continue onwards. Either the Debit Ledger A/c or Vch DrAmt Field will do..... Any help / guidance please. Accounting Entry=Payment,Receipt,Journal,Purchase,Sales,DNote and CNote. Regards Amit Kamdar
You have to add a Sub Form in Amount Field with Condition like Sub Form : SubFormName : Condition (to check current Ledger Field having group Sundry Debtors)
[#Field : Vch DrAmt] Sub Form : Dep NotesDr : NOT $$IsLedOfGrp:$LedgerName:$$FixedAssets Like above?? ...not working.... Maybe because i am using "Vch DrAmt" and since amount is not ledger...above condition is not working..... Before the Debit Amount....I would be Debiting Ledger A/c..... wot method/way to use that as a condition.....when i input Ledger Name and enter...so before going to Amount field... it would check for condition whether that Ledger belongs to Fixed Assets or Sundry Debtors and if satisfies the condition, the Form would pop up. Ideas???
you may try like this Code: [#Field : Vch DrAmt] Sub Form : Dep NotesDr : $Parent:Ledger:$LedgerName="Sundry Debtors" [Report: Dep NotesDr] ;;...remain codes for popup report try like this, here condition checking current ledger group is "sundry debtor" than your form popup. Regards
[#Field : Vch DrAmt] Sub Form : Dep NotesDr OpenDepNotesDrSubForm : $Parent:Ledger:$LedgerName="Sundry Debtors" [#Field : Vch DrAmt] Sub Form : Dep NotesDr : $Parent:Ledger:$LedgerName="Sundry Debtors" Tried both methods above...not working....if i have sub-group ... If all are classified under GRANDPARENT Group like "Fixed Assets" or "Sundry Debtors" it is working.... Is there a grandparent code ????? basically I am trying to pass and identify entries for depreciation..... like ---- 1) is it purchase of assets? 2) is it sale of assets? 3) is it year end depreciation??.... so far as per my codes the subform is popping at all Debit n Credits irrespective of ParentGroup. I need to identify only for "Fixed Assets" , Debtors and Creditors. For the timebeing even if "Fixed Assets" filtering works...it is enuff for my code.
you may achieve, with this Code: ;; For Journal [#Field: VCH DrAmt] Add: Sub Form : DepNotesDrSubForm: #VCHParticulars=@@IsUnderDebtorCreditorFA ;; For Receipt or Payment [#Field: ACLSAmt] Add: Sub Form : DepNotesDrSubForm: #ACLSLED=@@IsUnderDebtorCreditorFA [System: Formulae] IsUnderDebtorCreditorFA : $$IsBelongsTo:$$GroupSundryDebtors OR $$IsBelongsTo:$$GroupSundryCreditors OR $$IsBelongsTo:$$GroupFixedAssets try this Regards
Above suggestions..........It did not work..... Sub Form : Dep NotesDr : $Parent:Ledger:$LedgerName="Fixed Assets" --- This Works but only if all ledgers are under this and not other sub-group. Also....tried this variation as below...... Works for "Vehicles" but not for others......wonder WHY?? Maybe coz it is last condition.....!! Sub Form : Dep NotesDr : $Parent:Ledger:$LedgerName="Fixed Assets" Sub Form : Dep NotesDr : $Parent:Ledger:$LedgerName=$$LocaleString:"Office Equipments" Sub Form : Dep NotesDr : $Parent:Ledger:$LedgerName=$$LocaleString:"Furniture & Fixtures " Sub Form : Dep NotesDr : $Parent:Ledger:$LedgerName=$$LocaleString:"Tools & Equipments" Sub Form : Dep NotesDr : $Parent:Ledger:$LedgerName="Vehicles" Similarly for Debtor/Creditor I can control easily by creating one sub-group related to Sale/Purchase of Fixed Assets. But for Fixed Assets.... the various sub-groups under "Fixed Assets" is a necessity and required.
[#Field : Vch DrAmt] Sub Form : Dep NotesDr : $GrandParent:Ledger:$LedgerName="Fixed Assets" OR $Parent:Ledger:$LedgerName="Fixed Assets" [#Field : Vch CrAmt] Sub Form : Dep NotesCr : $GrandParent:Ledger:$LedgerName="Fixed Assets" OR $Parent:Ledger:$LedgerName="Fixed Assets" This works.......thanks for your assist....and valuable time.......