# Dictionaries can't find keys

**URL:** <https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488>\
**Category:** General Usage\
**Tags:** question, dictionary, dictionaries\
**Created:** [October 9, 2021, 10:22pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488 "2021-10-09T22:22:59Z")\
**Posts on this page:** 15\
**Page:** 2

<div class="post-metadata">

**Author:** ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Post date:** [October 10, 2021, 5:02pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/21 "2021-10-10T17:02:59Z")

</div>

No retained should be in credit. At this stage, I only want to know if “retained” is in “credit” or “debit”. “credit” and “debit” are important later on in determining certain calculations, but at this time, I only want to know if a key is in the Dictionary `general_ledger`.

---

<div class="post-metadata">

**Author:** ![goerch](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/goerch/32/29122_2.png) [@goerch](https://discourse.julialang.org/u/goerch)\
**Post date:** [October 10, 2021, 5:04pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/22 "2021-10-10T17:04:31Z")

</div>

This sounds like

```julia
if !haskey(general_ledger["debit"], debit_ledger_entries[i]) &&
           !haskey(general_ledger["credit"], debit_ledger_entries[i])
            return "Error -- "*debit_ledger_entries[i]*" not found"

```

would be the right check?

---

<div class="post-metadata">

**Author:** ![goerch](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/goerch/32/29122_2.png) [@goerch](https://discourse.julialang.org/u/goerch)\
**Post date:** [October 10, 2021, 5:17pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/23 "2021-10-10T17:17:51Z")

</div>

The following implementation shows my understanding of the requirements

```julia
function get_ledger_entry(general_ledger, ledger_entry)
	if haskey(general_ledger["debit"], ledger_entry)
		return general_ledger["debit"][ledger_entry]
	elseif haskey(general_ledger["credit"], ledger_entry)
		return general_ledger["credit"][ledger_entry]
	else
		return nothing
	end
end

function get_account_entry(ledger_entry, account_entry)
	if haskey(ledger_entry, account_entry)
		return ledger_entry[account_entry]
	else
		return nothing
	end
end

function transaction(memo, date,
	debit_ledger_entries=[], debit_account_entries=[],
	debit_amount_entries=[], credit_ledger_entries=[],
	credit_account_entries=[], credit_amount_entries=[],
	general_ledger=general_ledger)

	if length(credit_ledger_entries) != length(credit_account_entries)
		return "Error--there must be the same number of credit legders and accounts"
	end
	if length(credit_account_entries) != length(credit_amount_entries)
		return "Error-- each account needs a value and vice versa"
	end
	if length(debit_ledger_entries) != length(debit_account_entries)
	    return "Error--there must be the same number of debit legders and accounts"
	end
	if length(debit_account_entries) != length(debit_amount_entries)
		return "Error-- each debit account needs a value and vice versa"
	end
	if (round(Dec64(sum(debit_amount_entries)),digits=2)
	  -round(Dec64(sum(credit_amount_entries)),digits=2))!=0
		return "Error-total credits does not match total debits"
	end

	journal_entry=DataFrame(Date=[date],
							DebitedAccounts=[""],
							CreditedAccounts=[""],
							Debits=Vector{Dec64}([0.00]),
							Credits=Vector{Dec64}([0.00]),
							Balance=Vector{Dec64}([0.00]))

	i=1
	while i <= length(debit_amount_entries)
		ledger_entry = get_ledger_entry(general_ledger, debit_ledger_entries[i])
		if ledger_entry == nothing
        	return "Error -- "*debit_ledger_entries[i]*" not found"
		end
		account_entry = get_account_entry(ledger_entry, credit_account_entries[i])
		if account_entry == nothing
        	return "Error -- "*debit_account_entries[i]*" not found in"*debit_ledger_entries[i]*"."
        end

        debit_amount_entries[i]=round(Dec64(debit_amount_entries[i]),digits=2)
    	i+=1
    end

	i=1
	while i <= length(credit_amount_entries)
		ledger_entry = get_ledger_entry(general_ledger, credit_ledger_entries[i])
		if ledger_entry == nothing
			return "Error -- "*credit_ledger_entries[i]*" not found"
		end
		account_entry = get_account_entry(ledger_entry, credit_account_entries[i])
		if account_entry == nothing
			return "Error -- "*credit_account_entries[i]*" not found in"*credit_ledger_entries[i]*"."
        end

        credit_amount_entries[i]=round(Dec64(credit_amount_entries[i]),digits=2)
    	i+=1
    end

	i=1
  	while i <= length(debit_ledger_entries)
        debit_ledger_name=debit_ledger_entries[i]
        debit_amount = round(debit_amount_entries[i];digits=2)
        debit_account=debit_account_entries[i]
        calc_debit_balance!(
                    general_ledger,
                    journal_entry,
                    date,
                    debit_ledger_name,
                    debit_account,
                    debit_amount,
                    memo)
        i+=1
    end

    i=1
	while i <= length(credit_ledger_entries)
        credit_ledger_name=credit_ledger_entries[i]
        credit_account=credit_account_entries[i]
        credit_amount=floor(credit_amount_entries[i];digits=2)
        calc_credit_balance!(
                    general_ledger,
                    journal_entry,
                    date,
                    credit_ledger_name,
                    credit_account,
                    credit_amount,
                    memo)
        i+=1
    end

    push!(journal_entry,["","Total","Transaction",
                round(sum(journal_entry.Debits); digits=2),
                round(sum(journal_entry.Credits); digits=2),0])
    return (journal_entry, memo)
end;

```

and runs into

```julia
ERROR: LoadError: UndefVarError: calc_debit_balance! not defined

```

---

<div class="post-metadata">

**Author:** ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Post date:** [October 10, 2021, 5:20pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/24 "2021-10-10T17:20:23Z")

</div>

```julia
function transaction(memo, date,
	debit_ledger_entries=[], debit_account_entries=[],
	debit_amount_entries=[], credit_ledger_entries=[],
	credit_account_entries=[], credit_amount_entries=[],
	general_ledger=general_ledger)

	if length(credit_ledger_entries) != length(credit_account_entries)
		return "Error--there must be the same number of credit legders and accounts"
	end
	if length(credit_account_entries) != length(credit_amount_entries)
		return "Error-- each account needs a value and vice versa"
	end
	if length(debit_ledger_entries) != length(debit_account_entries)
	    return "Error--there must be the same number of debit legders and accounts"
	end
	if length(debit_account_entries) != length(debit_amount_entries)
		return "Error-- each debit account needs a value and vice versa"
	end
	if (round(Dec64(sum(debit_amount_entries)),digits=2)
	  -round(Dec64(sum(credit_amount_entries)),digits=2))!=0
		return "Error-total credits does not match total debits"
	end

	journal_entry=DataFrame(Date=[date],
							DebitedAccounts=[""],
							CreditedAccounts=[""],
							Debits=Vector{Dec64}([0.00]),
							Credits=Vector{Dec64}([0.00]),
							Balance=Vector{Dec64}([0.00]))

	i=1
	while i <= length(debit_amount_entries)
		if !haskey(general_ledger["debit"], debit_ledger_entries[i]) &&
           	!haskey(general_ledger["credit"], debit_ledger_entries[i])
            	return "Error -- "*debit_ledger_entries[i]*" not found"
		end
		if !haskey(general_ledger["debit"][debit_ledger_entries[i]], credit_account_entries[i]) &&
           !haskey(general_ledger["credit"][debit_ledger_entries[i]], credit_account_entries[i])
        	return "Error -- "*debit_account_entries[i]*" not found in"*debit_ledger_entries[i]*"."
        end

        debit_amount_entries[i]=round(Dec64(debit_amount_entries[i]),digits=2)
    	i+=1
    end

	i=1
	while i <= length(credit_amount_entries)
        if !haskey(general_ledger["debit"], credit_ledger_entries[i]) &&
           !haskey(general_ledger["credit"], credit_ledger_entries[i])
            return "Error -- "*credit_ledger_entries[i]*" not found"
        end
        if !haskey(general_ledger["debit"][credit_ledger_entries[i]], credit_account_entries[i]) &&
            !haskey(general_ledger["credit"][credit_ledger_entries[i]], credit_account_entries[i])
            return "Error -- "*credit_account_entries[i]*" not found in"*credit_ledger_entries[i]*"."
        end

        credit_amount_entries[i]=round(Dec64(credit_amount_entries[i]),digits=2)
    	i+=1
    end

	i=1
  	while i <= length(debit_ledger_entries)
        debit_ledger_name=debit_ledger_entries[i]
        debit_amount = round(debit_amount_entries[i];digits=2)
        debit_account=debit_account_entries[i]
        calc_debit_balance!(
                    general_ledger,
                    journal_entry,
                    date,
                    debit_ledger_name,
                    debit_account,
                    debit_amount,
                    memo)
        i+=1
    end

    i=1
	while i <= length(credit_ledger_entries)
        credit_ledger_name=credit_ledger_entries[i]
        credit_account=credit_account_entries[i]
        credit_amount=floor(credit_amount_entries[i];digits=2)
        calc_credit_balance!(
                    general_ledger,
                    journal_entry,
                    date,
                    credit_ledger_name,
                    credit_account,
                    credit_amount,
                    memo)
        i+=1
    end

    push!(journal_entry,["","Total","Transaction",
                round(sum(journal_entry.Debits); digits=2),
                round(sum(journal_entry.Credits); digits=2),0])
    return (journal_entry, memo)
end;

```

This gives me the same error, that I had before.

```julia
getindex(::Dict{String, Dict{Any, Any}}, ::String)@dict.jl:481
transaction(::String, ::String, ::Vector{String}, ::Vector{String}, ::Vector{Float64}, ::Vector{String}, ::Vector{String}, ::Vector{Float64}, ::Dict{String, Dict{String}})@AccountingProgram.jl:548
transaction(::String, ::String, ::Vector{String}, ::Vector{String}, ::Vector{Float64}, ::Vector{String}, ::Vector{String}, ::Vector{Float64})@AccountingProgram.jl:518
top-level scope@Local: 1[inlined]

```

---

<div class="post-metadata">

**Author:** ![goerch](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/goerch/32/29122_2.png) [@goerch](https://discourse.julialang.org/u/goerch)\
**Post date:** [October 10, 2021, 5:25pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/25 "2021-10-10T17:25:51Z")

</div>

It seems to me the error is missing?

Are you testing our MWE or your application?

---

<div class="post-metadata">

**Author:** ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Post date:** [October 10, 2021, 5:27pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/26 "2021-10-10T17:27:23Z")

</div>

Do you get an error, that calc\_debit\_balance is not found?

---

<div class="post-metadata">

**Author:** ![goerch](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/goerch/32/29122_2.png) [@goerch](https://discourse.julialang.org/u/goerch)\
**Post date:** [October 10, 2021, 5:27pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/27 "2021-10-10T17:27:58Z")

</div>

So I wrote.Should I repost the complete MWE or update the MWE above?

---

<div class="post-metadata">

**Author:** ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Post date:** [October 10, 2021, 5:34pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/28 "2021-10-10T17:34:48Z")

</div>

```julia

starting_balance=starting_balance=Dict(
	# Starting Balance consists of a dictionary, containing debit and credit dictionaries, containing accounts as empty dictionaries.

	#accounts are organized into credit and debit, then into subledgers based on DEALER acrynym
	
	#Debit Accounts
		#Drawings
		#Expenses
		#Assets
	#Credit Accounts
		#Liabilities
		#Equity
		#Revenue
	
		#Year End Accounts # These are used to close temporary accounts
			# Gross Revenue
			# Gross Expenses
			# Earned Income
	"debit"=>Dict(
					# balance = Σdebit - Σcredit		
		"drawings"=>Dict(),	#debit normal ledgers
		"expenses"=>Dict(),
		"assets"=>Dict()),
	"credit"=>Dict( # revenue, liabilities, equtiy, and year_end, are credit normal
					 # balance = Σcredit - Σdebit
		"liabilities"=>Dict(),
		"equity"=>Dict(),
		"revenue"=>Dict(),
			"retained"=> Dict( #Closing Accounts - No Balance Until Temp Accounts Closed
			"Retained Earnings"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
			"Gross Income"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
			"Gross Expenses"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
			"Net Income"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
			"Total Drawings"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
		)
	)
	)

function transaction(memo, date,
	debit_ledger_entries=[], debit_account_entries=[],
	debit_amount_entries=[], credit_ledger_entries=[],
	credit_account_entries=[], credit_amount_entries=[],
	general_ledger=general_ledger)

	if length(credit_ledger_entries) != length(credit_account_entries)
		return "Error--there must be the same number of credit legders and accounts"
	end
	if length(credit_account_entries) != length(credit_amount_entries)
		return "Error-- each account needs a value and vice versa"
	end
	if length(debit_ledger_entries) != length(debit_account_entries)
	    return "Error--there must be the same number of debit legders and accounts"
	end
	if length(debit_account_entries) != length(debit_amount_entries)
		return "Error-- each debit account needs a value and vice versa"
	end
	if (round(Dec64(sum(debit_amount_entries)),digits=2)
	  -round(Dec64(sum(credit_amount_entries)),digits=2))!=0
		return "Error-total credits does not match total debits"
	end

	journal_entry=DataFrame(Date=[date],
							DebitedAccounts=[""],
							CreditedAccounts=[""],
							Debits=Vector{Dec64}([0.00]),
							Credits=Vector{Dec64}([0.00]),
							Balance=Vector{Dec64}([0.00]))

	i=1
	while i <= length(debit_amount_entries)
		if !haskey(general_ledger["debit"], debit_ledger_entries[i]) &&
           	!haskey(general_ledger["credit"], debit_ledger_entries[i])
            	return "Error -- "*debit_ledger_entries[i]*" not found"
		end
		if !haskey(general_ledger["debit"][debit_ledger_entries[i]], credit_account_entries[i]) &&
           !haskey(general_ledger["credit"][debit_ledger_entries[i]], credit_account_entries[i])
        	return "Error -- "*debit_account_entries[i]*" not found in"*debit_ledger_entries[i]*"."
        end

        debit_amount_entries[i]=round(Dec64(debit_amount_entries[i]),digits=2)
    	i+=1
    end

	i=1
	while i <= length(credit_amount_entries)
        if !haskey(general_ledger["debit"], credit_ledger_entries[i]) &&
           !haskey(general_ledger["credit"], credit_ledger_entries[i])
            return "Error -- "*credit_ledger_entries[i]*" not found"
        end
        if !haskey(general_ledger["debit"][credit_ledger_entries[i]], credit_account_entries[i]) &&
            !haskey(general_ledger["credit"][credit_ledger_entries[i]], credit_account_entries[i])
            return "Error -- "*credit_account_entries[i]*" not found in"*credit_ledger_entries[i]*"."
        end

        credit_amount_entries[i]=round(Dec64(credit_amount_entries[i]),digits=2)
    	i+=1
    end

	i=1
  	while i <= length(debit_ledger_entries)
        debit_ledger_name=debit_ledger_entries[i]
        debit_amount = round(debit_amount_entries[i];digits=2)
        debit_account=debit_account_entries[i]
        calc_debit_balance!(
                    general_ledger,
                    journal_entry,
                    date,
                    debit_ledger_name,
                    debit_account,
                    debit_amount,
                    memo)
        i+=1
    end

    i=1
	while i <= length(credit_ledger_entries)
        credit_ledger_name=credit_ledger_entries[i]
        credit_account=credit_account_entries[i]
        credit_amount=floor(credit_amount_entries[i];digits=2)
        calc_credit_balance!(
                    general_ledger,
                    journal_entry,
                    date,
                    credit_ledger_name,
                    credit_account,
                    credit_amount,
                    memo)
        i+=1
    end

    push!(journal_entry,["","Total","Transaction",
                round(sum(journal_entry.Debits); digits=2),
                round(sum(journal_entry.Credits); digits=2),0])
    return (journal_entry, memo)
end;

transaction("Weird Example",
	"Jan 2 2021",
	["retained"],
	["Gross Income"],
	[100.00],
				["asset"],
				["Land"],
				[100.00],
starting_balance)

```

---

<div class="post-metadata">

**Author:** ![goerch](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/goerch/32/29122_2.png) [@goerch](https://discourse.julialang.org/u/goerch)\
**Post date:** [October 10, 2021, 5:37pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/29 "2021-10-10T17:37:47Z")

</div>

Sorry for the confusion. Here is my current complete version

```julia
using DataFrames, DecFP

starting_balance=starting_balance=Dict(
	"debit"=>Dict(
		"drawings"=>Dict(),	#debit normal ledgers
		"expenses"=>Dict(),
		"assets"=>Dict()),
	"credit"=>Dict(
		"liabilities"=>Dict(),
		"equity"=>Dict(),
		"revenue"=>Dict(),
		"retained"=> Dict( #Closing Accounts - No Balance Until Temp Accounts Closed
			"Retained Earnings"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
			"Gross Income"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
			"Gross Expenses"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
			"Net Income"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}()),
			"Total Drawings"=>DataFrame(
        date=Vector{String}(),
		memo=Vector{String}(),
        debit=Vector{Dec64}(),
        credit=Vector{Dec64}(),
		balance=Vector{Dec64}())))
)

function get_ledger_entry(general_ledger, ledger_entry)
	if haskey(general_ledger["debit"], ledger_entry)
		return general_ledger["debit"][ledger_entry]
	elseif haskey(general_ledger["credit"], ledger_entry)
		return general_ledger["credit"][ledger_entry]
	else
		return nothing
	end
end

function get_account_entry(ledger_entry, account_entry)
	if haskey(ledger_entry, account_entry)
		return ledger_entry[account_entry]
	else
		return nothing
	end
end

function transaction(memo, date,
	debit_ledger_entries=[], debit_account_entries=[],
	debit_amount_entries=[], credit_ledger_entries=[],
	credit_account_entries=[], credit_amount_entries=[],
	general_ledger=general_ledger)

	if length(credit_ledger_entries) != length(credit_account_entries)
		return "Error--there must be the same number of credit legders and accounts"
	end
	if length(credit_account_entries) != length(credit_amount_entries)
		return "Error-- each account needs a value and vice versa"
	end
	if length(debit_ledger_entries) != length(debit_account_entries)
	    return "Error--there must be the same number of debit legders and accounts"
	end
	if length(debit_account_entries) != length(debit_amount_entries)
		return "Error-- each debit account needs a value and vice versa"
	end
	if (round(Dec64(sum(debit_amount_entries)),digits=2)
	  -round(Dec64(sum(credit_amount_entries)),digits=2))!=0
		return "Error-total credits does not match total debits"
	end

	journal_entry=DataFrame(Date=[date],
							DebitedAccounts=[""],
							CreditedAccounts=[""],
							Debits=Vector{Dec64}([0.00]),
							Credits=Vector{Dec64}([0.00]),
							Balance=Vector{Dec64}([0.00]))

	i=1
	while i <= length(debit_amount_entries)
		ledger_entry = get_ledger_entry(general_ledger, debit_ledger_entries[i])
		if ledger_entry == nothing
        	return "Error -- "*debit_ledger_entries[i]*" not found"
		end
		account_entry = get_account_entry(ledger_entry, credit_account_entries[i])
		if account_entry == nothing
        	return "Error -- "*debit_account_entries[i]*" not found in"*debit_ledger_entries[i]*"."
        end

        debit_amount_entries[i]=round(Dec64(debit_amount_entries[i]),digits=2)
    	i+=1
    end

	i=1
	while i <= length(credit_amount_entries)
		ledger_entry = get_ledger_entry(general_ledger, credit_ledger_entries[i])
		if ledger_entry == nothing
			return "Error -- "*credit_ledger_entries[i]*" not found"
		end
		account_entry = get_account_entry(ledger_entry, credit_account_entries[i])
		if account_entry == nothing
			return "Error -- "*credit_account_entries[i]*" not found in"*credit_ledger_entries[i]*"."
        end

        credit_amount_entries[i]=round(Dec64(credit_amount_entries[i]),digits=2)
    	i+=1
    end

	i=1
  	while i <= length(debit_ledger_entries)
        debit_ledger_name=debit_ledger_entries[i]
        debit_amount = round(debit_amount_entries[i];digits=2)
        debit_account=debit_account_entries[i]
        calc_debit_balance!(
                    general_ledger,
                    journal_entry,
                    date,
                    debit_ledger_name,
                    debit_account,
                    debit_amount,
                    memo)
        i+=1
    end

    i=1
	while i <= length(credit_ledger_entries)
        credit_ledger_name=credit_ledger_entries[i]
        credit_account=credit_account_entries[i]
        credit_amount=floor(credit_amount_entries[i];digits=2)
        calc_credit_balance!(
                    general_ledger,
                    journal_entry,
                    date,
                    credit_ledger_name,
                    credit_account,
                    credit_amount,
                    memo)
        i+=1
    end

    push!(journal_entry,["","Total","Transaction",
                round(sum(journal_entry.Debits); digits=2),
                round(sum(journal_entry.Credits); digits=2),0])
    return (journal_entry, memo)
end;

transaction("Weird Example", "Jan 2 2021",
	["retained"], ["Gross Income"], [100.00], ["retained"],
	["Net Income"], [100.00], starting_balance)

```

resulting in

```julia
ERROR: LoadError: UndefVarError: calc_debit_balance! not defined

```

---

<div class="post-metadata">

**Author:** ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Post date:** [October 10, 2021, 5:45pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/30 "2021-10-10T17:45:30Z")

</div>

> [@goerch](#):
>
> ```julia
> using DataFrames, DecFP
> 
> starting_balance=starting_balance=Dict(
> "debit"=>Dict(
> "drawings"=>Dict(),	#debit normal ledgers
> "expenses"=>Dict(),
> "assets"=>Dict()),
> "credit"=>Dict(
> "liabilities"=>Dict(),
> "equity"=>Dict(),
> "revenue"=>Dict(),
> "retained"=> Dict( #Closing Accounts - No Balance Until Temp Accounts Closed
> "Retained Earnings"=>DataFrame(
> date=Vector{String}(),
> memo=Vector{String}(),
> debit=Vector{Dec64}(),
> credit=Vector{Dec64}(),
> balance=Vector{Dec64}()),
> "Gross Income"=>DataFrame(
> date=Vector{String}(),
> memo=Vector{String}(),
> debit=Vector{Dec64}(),
> credit=Vector{Dec64}(),
> balance=Vector{Dec64}()),
> "Gross Expenses"=>DataFrame(
> date=Vector{String}(),
> memo=Vector{String}(),
> debit=Vector{Dec64}(),
> credit=Vector{Dec64}(),
> balance=Vector{Dec64}()),
> "Net Income"=>DataFrame(
> date=Vector{String}(),
> memo=Vector{String}(),
> debit=Vector{Dec64}(),
> credit=Vector{Dec64}(),
> balance=Vector{Dec64}()),
> "Total Drawings"=>DataFrame(
> date=Vector{String}(),
> memo=Vector{String}(),
> debit=Vector{Dec64}(),
> credit=Vector{Dec64}(),
> balance=Vector{Dec64}())))
> )
> 
> function get_ledger_entry(general_ledger, ledger_entry)
> if haskey(general_ledger["debit"], ledger_entry)
> return general_ledger["debit"][ledger_entry]
> elseif haskey(general_ledger["credit"], ledger_entry)
> return general_ledger["credit"][ledger_entry]
> else
> return nothing
> end
> end
> 
> function get_account_entry(ledger_entry, account_entry)
> if haskey(ledger_entry, account_entry)
> return ledger_entry[account_entry]
> else
> return nothing
> end
> end
> 
> function transaction(memo, date,
> debit_ledger_entries=[], debit_account_entries=[],
> debit_amount_entries=[], credit_ledger_entries=[],
> credit_account_entries=[], credit_amount_entries=[],
> general_ledger=general_ledger)
> 
> if length(credit_ledger_entries) != length(credit_account_entries)
> return "Error--there must be the same number of credit legders and accounts"
> end
> if length(credit_account_entries) != length(credit_amount_entries)
> return "Error-- each account needs a value and vice versa"
> end
> if length(debit_ledger_entries) != length(debit_account_entries)
> return "Error--there must be the same number of debit legders and accounts"
> end
> if length(debit_account_entries) != length(debit_amount_entries)
> return "Error-- each debit account needs a value and vice versa"
> end
> if (round(Dec64(sum(debit_amount_entries)),digits=2)
> -round(Dec64(sum(credit_amount_entries)),digits=2))!=0
> return "Error-total credits does not match total debits"
> end
> 
> journal_entry=DataFrame(Date=[date],
> DebitedAccounts=[""],
> CreditedAccounts=[""],
> Debits=Vector{Dec64}([0.00]),
> Credits=Vector{Dec64}([0.00]),
> Balance=Vector{Dec64}([0.00]))
> 
> i=1
> while i <= length(debit_amount_entries)
> ledger_entry = get_ledger_entry(general_ledger, debit_ledger_entries[i])
> if ledger_entry == nothing
> return "Error -- "*debit_ledger_entries[i]*" not found"
> end
> account_entry = get_account_entry(ledger_entry, credit_account_entries[i])
> if account_entry == nothing
> return "Error -- "*debit_account_entries[i]*" not found in"*debit_ledger_entries[i]*"."
> end
> 
> debit_amount_entries[i]=round(Dec64(debit_amount_entries[i]),digits=2)
> i+=1
> end
> 
> i=1
> while i <= length(credit_amount_entries)
> ledger_entry = get_ledger_entry(general_ledger, credit_ledger_entries[i])
> if ledger_entry == nothing
> return "Error -- "*credit_ledger_entries[i]*" not found"
> end
> account_entry = get_account_entry(ledger_entry, credit_account_entries[i])
> if account_entry == nothing
> return "Error -- "*credit_account_entries[i]*" not found in"*credit_ledger_entries[i]*"."
> end
> 
> credit_amount_entries[i]=round(Dec64(credit_amount_entries[i]),digits=2)
> i+=1
> end
> 
> i=1
> while i <= length(debit_ledger_entries)
> debit_ledger_name=debit_ledger_entries[i]
> debit_amount = round(debit_amount_entries[i];digits=2)
> debit_account=debit_account_entries[i]
> calc_debit_balance!(
> general_ledger,
> journal_entry,
> date,
> debit_ledger_name,
> debit_account,
> debit_amount,
> memo)
> i+=1
> end
> 
> i=1
> while i <= length(credit_ledger_entries)
> credit_ledger_name=credit_ledger_entries[i]
> credit_account=credit_account_entries[i]
> credit_amount=floor(credit_amount_entries[i];digits=2)
> calc_credit_balance!(
> general_ledger,
> journal_entry,
> date,
> credit_ledger_name,
> credit_account,
> credit_amount,
> memo)
> i+=1
> end
> 
> push!(journal_entry,["","Total","Transaction",
> round(sum(journal_entry.Debits); digits=2),
> round(sum(journal_entry.Credits); digits=2),0])
> return (journal_entry, memo)
> end;
> 
> transaction("Weird Example", "Jan 2 2021",
> ["retained"], ["Gross Income"], [100.00], ["retained"],
> ["Net Income"], [100.00], starting_balance)
> 
> ```

I get “Gross Income not found in retained.”

---

<div class="post-metadata">

**Author:** ![goerch](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/goerch/32/29122_2.png) [@goerch](https://discourse.julialang.org/u/goerch)\
**Post date:** [October 10, 2021, 5:48pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/31 "2021-10-10T17:48:20Z")

</div>

Could we please get a third opinion before continuing the analysis?

---

<div class="post-metadata">

**Author:** ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Post date:** [October 10, 2021, 8:17pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/32 "2021-10-10T20:17:26Z")

</div>

> [@goerch](#):
>
> ```julia
> while i <= length(debit_amount_entries)
> if !haskey(general_ledger["debit"], debit_ledger_entries[i]) ||
> !haskey(general_ledger["credit"], debit_ledger_entries[i])
> return "Error -- "*debit_ledger_entries[i]*" not found"
> end
> if !haskey(general_ledger["debit"][debit_ledger_entries[i]], credit_account_entries[i]) ||
> !haskey(general_ledger["credit"][debit_ledger_entries[i]], credit_account_entries[i])
> return "Error -- "*debit_account_entries[i]*" not found in"*debit_ledger_entries[i]*"."
> end
> 
> debit_amount_entries[i]=round(Dec64(debit_amount_entries[i]),digits=2)
> i+=1
> end
> 
> ```

OK. when I entered the MWE it works like yours, but when I insert it into my own program, it doesn’t work.

---

<div class="post-metadata">

**Author:** ![goerch](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/goerch/32/29122_2.png) [@goerch](https://discourse.julialang.org/u/goerch)\
**Post date:** [October 10, 2021, 8:44pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/33 "2021-10-10T20:44:30Z")

</div>

Your cite is dubious. If the problem persists in your application you should be able to demonstrate them via other call setups of `transaction`, no?

Otherwise you might open another discussion.

---

<div class="post-metadata">

**Author:** ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Post date:** [October 10, 2021, 8:45pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/34 "2021-10-10T20:45:54Z")

</div>

I might, I’ll keep looking at it’ and see what my problem is.

---

<div class="post-metadata">

**Author:** ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Post date:** [October 10, 2021, 8:56pm UTC](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488/35 "2021-10-10T20:56:40Z")

</div>

Now I got everything to work. If I have everything spelled right it works, if the ledger is spelled wrong, it returns `*debit_account* not found`, but if I spell the ledger right, but misspell the account, it goes through, and I get the standard key not found error.

```julia
KeyError: key "Gross Incme" not found

getindex(::Dict{String, DataFrames.DataFrame}, ::String)@dict.jl:481
calc_debit_balance!(::Dict{String, Dict{String}}, ::DataFrames.DataFrame, ::String, ::String, ::String, ::Float64, ::String)@Other: 48
transaction(::String, ::String, ::Vector{String}, ::Vector{String}, ::Vector{Float64}, ::Vector{String}, ::Vector{String}, ::Vector{Float64}, ::Dict{String, Dict{String}})@Other: 66
top-level scope@Local: 1[inlined]

```

[Previous page](https://discourse.julialang.org/t/dictionaries-cant-find-keys/69488.md?page=1)