Class: LedgerEntriesController

Inherits:
CrmController show all
Defined in:
app/controllers/ledger_entries_controller.rb

Overview

== Schema Information

Table name: ledger_entries

id :integer not null, primary key
ledger_transaction_id :integer not null
ledger_company_account_id :integer not null
currency :string(3) not null
description :string(255)
creator_id :integer
updater_id :integer
created_at :datetime
updated_at :datetime
ledger_detail_project_id :integer
amount :decimal(12, 2)
company_exchange_rate :float
company_amount :decimal(12, 2)
consolidated_exchange_rate :float
consolidated_amount :decimal(12, 2)
business_unit_id :integer
reconciled :boolean default(FALSE)
reconciled_by_id :integer
reconciled_at :datetime
bank_date :date

Constant Summary

Constants included from Controllers::ReferenceFindable

Controllers::ReferenceFindable::ID_EMBEDDED_PATTERNS

Constants included from Controllers::AnalyticsEvents

Controllers::AnalyticsEvents::MAX_QUEUED_EVENTS, Controllers::AnalyticsEvents::SESSION_KEY

Constants included from Controllers::ErrorRendering

Controllers::ErrorRendering::NON_CONTENT_PATH_PREFIXES

Instance Method Summary collapse

Methods inherited from CrmController

#access_denied, #context_id, #context_object, #crm_home_path, #current_ability, #default_url_options, #download_temp, #get_tempfile_path_for_download, #init_status_job_collector, #initialize_crm_lazy_chunks, #persist_enqueued_status_jobs, #record_not_found, #redirect_to_job_or_fallback, #render_edit_action, #set_context, #set_download_path, #stash_file_for_temp_download, #sync_admin_presence_cookie, #touch_employee_last_seen

Methods inherited from ApplicationController

#account_impersonated?, #add_to_flash, #after_sign_in_path_for, #bypass_forgery_protection?, #chat_enabled?, #cloudflare_cleared?, #default_catalog, #default_url_options, #enable_turbo_frames, #find_publication, #fix_invalid_accept_header, #init_js_utils, #is_globals_call?, #layout_by_resource, #locale_store, #redirect_to, #require_employee_for_crm, #set_base_host, #set_real_ip, #set_report_errors_for, #should_render_layout?, #skip_layout_for_turbo_frame?, #stamp_impersonation_context, #tab_frame_breakout_request?, #warmlyyours_canada_ip?, #warmlyyours_ip?, #y

Methods included from Controllers::ReturnPathHandling

#check_for_return_path, #redirect_to_return_path_or_default

Methods included from Controllers::AnalyticsEvents

#consume_queued_analytics_events, #registration_lead_type, #track_event

Methods included from Controllers::DeviceDetection

#device_detector, #is_ie?

Methods included from Controllers::SubdomainDetection

#is_crm_request?, #is_www_request?, #json_request?

Methods included from Controllers::TurboSafeRedirect

#redirect_to

Methods included from Controllers::TrackingDetection

#bot_request?, #gdpr_country?, #gdpr_country_data, #prevent_bots, #set_tracking_cookie, #track_visitor?

Methods included from Controllers::AcceleratedFileSending

#send_file_accelerated, #send_upload_accelerated

Methods included from Controllers::ErrorRendering

#excp_string, #mail_to_for_error_reporting, #render_400, #render_404, #render_406, #render_410, #render_500, #render_invalid_authenticity_token, #render_ip_spoof_error, #render_unpermitted_parameters, #safe_referer_or_fallback

Methods included from Controllers::TurnstileVerification

#load_turnstile_script_tag, #turnstile_lazy_widget, #turnstile_script_tag, #turnstile_widget, #validate_turnstile!

Methods included from Controllers::CloudflareCaching

edge_cached, #edge_cached_action?, #reset_cloudflare_cache, #set_cloudflare_cache, #skip_edge_cache!, #skip_session

Methods included from Controllers::Webpackable

#preload_webpack_fonts, #webpack_css_include, #webpack_css_url, #webpack_js_include, #wpd_is_running?

Methods included from Controllers::Localizable

#cloudflare_country_locale, #determine_request_locale, #geocoder_locale, #guest_user_locale_check, #locale_optional_www_auth_path?, #param_locale, #set_locale, #set_request_locale, #skip_localization?, #warmlyyours_ip_locale

Methods included from Controllers::Authenticable

#access_denied, #authenticate_account, #authenticate_account!, #authenticate_account_from_login_token!, #check_is_a_manager, #check_is_a_sales_manager, #check_is_an_admin, #check_is_an_employee, #check_party, #clear_mismatched_guest_user, #create_guest_user, #credentials?, #current_or_guest_user, #current_or_guest_user_id_read_only, #current_user, #devise_mapping, #fully_logged_in?, #generate_bot_id, #guest_user, #identifiable?, #init_current_user, #initialize_guest, #load_context_user, #logging_in, #resource, #resource_name, #restrict_access_for_non_employees, #scrubbed_request_path, #user_object, #warn_on_session_guest_id_leak

Methods included from UrlsHelper

#catalog_breadcrumb_links, #catalog_link, #catalog_link_for_product_line, #catalog_link_for_sku, #cms_link, #delocalized_path, #path_to_sales_product_sku, #path_to_sales_product_sku_for_product_line, #path_to_sales_product_sku_for_product_line_slug, #product_line_from_catalog_link, #protocol_neutral_url, #sanitize_external_url, #valid_external_url?

Instance Method Details

#do_po_reconcile ⇒ void

This method returns an undefined value.

Applies the PO reconciliation selections: builds a balanced journal LedgerTransaction
(materials-in-transit vs receipts-not-vouchered) when the totals offset, marks the
selected entries reconciled, and redirects to the PO reconcile worksheet or to the
ledger transaction review when a balance remains.



145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
 
# File 'app/controllers/ledger_entries_controller.rb', line 145

def do_po_reconcile
  reconciliation_date = params[:po_reconcile_save][:reconciliation_date].present? ? params[:po_reconcile_save][:reconciliation_date].to_date : Date.current
  materials_in_transit_le = params[:materials_in_transit_ledger_entries].to_h
  receipts_not_vouchered_le = params[:receipts_not_vouchered_ledger_entries].to_h
  mit_ids = materials_in_transit_le.filter_map { |id, attrs| id.to_i if attrs[:vcr_reconciled].to_i.positive? }.uniq
  rnv_ids = receipts_not_vouchered_le.filter_map { |id, attrs| id.to_i if attrs[:po_reconciled].to_i.positive? }.uniq
  mit_company = materials_in_transit_le.filter_map { |_id, attrs| attrs[:company_id] if attrs[:vcr_reconciled].to_i.positive? }.uniq
  rnv_company = receipts_not_vouchered_le.filter_map { |_id, attrs| attrs[:company_id] if attrs[:po_reconciled].to_i.positive? }.uniq

  if mit_company.many? || rnv_company.many? || (mit_company.present? && rnv_company.present? && mit_company != rnv_company)
    flash[:error] =
      '<p>The selected values are in different company account. Materials in transit and Recaipts not vouchered must be in the same company account.</p>'
    redirect_back_or_to root_path
    return
  end

  mit_selected = LedgerEntry.where(id: mit_ids)
  rnv_selected = LedgerEntry.where(id: rnv_ids)

  if params[:po_reconcile_save][:company_id].present?
    company_id = params[:po_reconcile_save][:company_id].to_i
  elsif mit_company.present? && rnv_company.present?
    company_id = (mit_company + rnv_company).uniq.first.to_i
  elsif mit_company.present? && rnv_company.empty?
    company_id = mit_company.uniq.first.to_i
  elsif mit_company.empty? && rnv_company.present?
    company_id = rnv_company.uniq.first.to_i
  end
  # tr_company = rnv_ids.present? ? receipts_not_vouchered_le.map{ |id,attrs| attrs[:company_id].to_i if attrs[:po_reconciled].to_i.positive? }.compact.uniq.first : materials_in_transit_le.map{ |id,attrs| attrs[:company_id].to_i if attrs[:vcr_reconciled].to_i.positive? }.compact.uniq.first
  # tr_currency = rnv_ids.present? ? receipts_not_vouchered_le.map{ |id,attrs| attrs[:currency] if attrs[:po_reconciled].to_i.positive? }.compact.uniq.first : materials_in_transit_le.map{ |id,attrs| attrs[:currency] if attrs[:vcr_reconciled].to_i.positive? }.compact.uniq.first
  tr_currency = Company.find(company_id).currency
  description = if mit_ids.present?
                  materials_in_transit_le.filter_map do |_id, attrs|
                    attrs[:description] if attrs[:vcr_reconciled].to_i.positive?
                  end.uniq.first
                else
                  receipts_not_vouchered_le.filter_map do |_id, attrs|
                    attrs[:description] if attrs[:po_reconciled].to_i.positive?
                  end.uniq.first
                end

  if mit_ids.present? || rnv_ids.present?
    if mit_ids.present?
      mit_total = mit_selected.sum(&:company_amount)
      bu = mit_selected.filter_map(&:business_unit_id).uniq.first.nil? ? BusinessUnit.find_by(number: (company_id * 10_000)) : BusinessUnit.find(mit_selected.filter_map(&:business_unit_id).uniq.first)
    else
      mit_total = 0
    end

    if rnv_ids.present?
      rnv_total = rnv_selected.sum(&:company_amount)
      bu = rnv_selected.filter_map(&:business_unit_id).uniq.first.nil? ? BusinessUnit.find_by(number: (company_id * 10_000)) : BusinessUnit.find(rnv_selected.filter_map(&:business_unit_id).uniq.first)
    else
      rnv_total = 0
    end

    balance = mit_total.abs - rnv_total.abs
    reconciled = mit_total.abs == rnv_total.abs
    lca_mit = LedgerCompanyAccount.where(company_id: company_id, ledger_detail_account_id: LedgerAccount.find_by(number: 1415).id).first
    lca_rnv = LedgerCompanyAccount.where(company_id: company_id, ledger_detail_account_id: LedgerAccount.find_by(number: 4120).id).first
    ledger_transaction = LedgerTransaction.new(company_id: company_id, transaction_type: 'JOURNAL_ENTRY', transaction_date: reconciliation_date,
                                               currency: tr_currency)
    ledger_transaction.ledger_entries << LedgerEntry.new(ledger_company_account: lca_rnv, amount: mit_total, business_unit: bu,
                                                         description: description, reconciled: reconciled)
    ledger_transaction.ledger_entries << LedgerEntry.new(ledger_company_account: lca_mit, amount: rnv_total, business_unit: bu,
                                                         description: description, reconciled: reconciled)

    if balance.zero? && mit_total.abs.positive? && rnv_total.abs.positive?
      ledger_transaction.save!
      mit_selected.update_all(reconciled: true)
      rnv_selected.update_all(reconciled: true)

      flash[:info] =
        "<p>Ledger Transaction <b>#{ledger_transaction.id}</b> was successfully created. Materials in Transit ids (#{mit_selected.map(&:id).join(',')}) and Receipts Not Vouchered ids (#{rnv_selected.map(&:id).join(',')}) were successfully reconciled.</p>"
      redirect_to po_reconcile_ledger_entries_path({ po_reconcile_params: params[:po_reconcile_save].merge({ reconciliation_date: reconciliation_date }) })
    elsif mit_total.abs.zero? && rnv_total.abs.zero? && mit_selected.present? && rnv_selected.present?
      mit_selected.update_all(reconciled: true)
      rnv_selected.update_all(reconciled: true)

      flash[:info] =
        "<p>Materials in Transit ids (#{mit_selected.map(&:id).join(',')}) and Receipts Not Vouchered ids (#{rnv_selected.map(&:id).join(',')}) were successfully reconciled.</p>"
      redirect_to po_reconcile_ledger_entries_path({ po_reconcile_params: params[:po_reconcile_save].merge({ reconciliation_date: reconciliation_date }) })
    elsif mit_total.abs.zero? && rnv_total.abs.zero? && (mit_selected.present? || rnv_selected.present?)
      if mit_selected.present?
        mit_selected.update_all(reconciled: true)
        notice_message = "<p>Materials in Transit ids (#{mit_selected.map(&:id).join(',')}) were successfully reconciled.</p>"
      elsif rnv_selected.present?
        rnv_selected.update_all(reconciled: true)
        notice_message = "<p>Receipts Not Vouchered ids (#{rnv_selected.map(&:id).join(',')}) were successfully reconciled.</p>"
      end
      flash[:info] = notice_message
      redirect_to po_reconcile_ledger_entries_path({ po_reconcile_params: params[:po_reconcile_save].merge({ reconciliation_date: reconciliation_date }) })
    else
      flash[:error] = "<p>There is still a balance of #{number_to_currency(balance)} that has to be reviewed.</p>"
      company_criteria = params[:po_reconcile_save][:company_id]
      params[:po_reconcile_save][:company_id] = company_id.to_s
      redirect_to review_reconcile_ledger_transactions_path(company_criteria: company_criteria,
                                                            tr_currency: tr_currency,
                                                            bu_id: bu.id,
                                                            description: description,
                                                            rnv_total: -rnv_total,
                                                            mit_total: -mit_total,
                                                            balance: balance,
                                                            mit_ids: mit_ids,
                                                            rnv_ids: rnv_ids,
                                                            po_reconcile_params: params[:po_reconcile_save].merge({ reconciliation_date: reconciliation_date }))
    end
  else
    flash[:error] = '<p>You must select at least a record either from materials in transit or receipts not vouchered.</p>'
    redirect_back_or_to root_path
  end
end

#do_reconcile ⇒ void

This method returns an undefined value.

Applies reconciliation changes submitted from the worksheet in params[:ledger_entries],
stamping reconciled_by/reconciled_at on newly reconciled entries and clearing them
(plus bank_date) on unreconciled ones, then redirects back.



77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
 
# File 'app/controllers/ledger_entries_controller.rb', line 77

def do_reconcile
  params[:ledger_entries]&.each do |id, attrs|
    attrs[:reconciled] ||= '0'
    le = LedgerEntry.find(id)
    le.attributes = attrs
    if le.reconciled_changed? && le.reconciled?
      le.reconciled_by = @context_user
      le.reconciled_at = Time.current
      begin
        le.save!
      rescue StandardError => e
        flash[:error] = "Unable to save all ledger entries, message : #{e}"
      end
    elsif le.reconciled? && le.bank_date_changed?
      begin
        le.save!
      rescue StandardError => e
        flash[:error] = "Unable to save all ledger entries, message : #{e}"
      end
    elsif !le.reconciled?
      le.reconciled_by = nil
      le.reconciled_at = nil
      le.bank_date = nil
      begin
        le.save! if le.changed?
      rescue StandardError => e
        flash[:error] = "Unable to save all ledger entries, message : #{e}"
      end
    end
  end
  redirect_back_or_to root_path
end

#index ⇒ void

This method returns an undefined value.

Renders the ledger entries index page.



31
 
# File 'app/controllers/ledger_entries_controller.rb', line 31

def index; end

#po_reconcile ⇒ void

This method returns an undefined value.

Renders the purchase-order reconciliation worksheet: materials-in-transit and
receipts-not-vouchered ledger entries for the filters in params[:po_reconcile_params].



113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
 
# File 'app/controllers/ledger_entries_controller.rb', line 113

def po_reconcile
  init_params = {
    company_id: '1',
    mit_gl_date_gteq: Date.current.beginning_of_month,
    mit_gl_date_lteq: Date.current.end_of_month,
    rnv_gl_date_gteq: Date.current.beginning_of_month,
    rnv_gl_date_lteq: Date.current.end_of_month,
    po_number_ref: '',
    reconciled: 'false',
    reconciliation_date: Date.current
  }

  params[:po_reconcile_params] ||= init_params
  @po_reconcile_params = OpenStruct.new(params[:po_reconcile_params])

  @company_id = @po_reconcile_params[:company_id]
  @mit_gl_date_gteq = @po_reconcile_params[:mit_gl_date_gteq]
  @mit_gl_date_lteq = @po_reconcile_params[:mit_gl_date_lteq]
  @rnv_gl_date_gteq = @po_reconcile_params[:rnv_gl_date_gteq]
  @rnv_gl_date_lteq = @po_reconcile_params[:rnv_gl_date_lteq]
  @po_number_ref = @po_reconcile_params[:po_number_ref]
  @reconciled = @po_reconcile_params[:reconciled]
  @reconciliation_date = @po_reconcile_params[:reconciliation_date]
  @materials_in_transit = LedgerEntry.get_materials_in_transit(@company_id, @mit_gl_date_gteq, @mit_gl_date_lteq, @po_number_ref, @reconciled)
  @receipts_not_vouchered = LedgerEntry.get_receipts_not_vouchered(@company_id, @rnv_gl_date_gteq, @rnv_gl_date_lteq, @po_number_ref, @reconciled)
end

#reconcile ⇒ void

This method returns an undefined value.

Renders the bank reconciliation worksheet: filtered ledger entries, book balance,
outstanding debits/credits, and the adjusted bank balance for the selected account.



36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
 
# File 'app/controllers/ledger_entries_controller.rb', line 36

def reconcile
  params[:reconcile_params] ||= { company_account_id: ['', LedgerCompanyAccount.get_by_identifier('100.1122').id.to_s], reconciled: false }
  @reconcile_params = OpenStruct.new(params[:reconcile_params])
  @account_ids = BankAccount.all.map(&:ledger_company_account_id)
  @accounts = LedgerCompanyAccount.quick_list("ledger_company_accounts.id in (#{@account_ids.join(',')})")

  @ledger_entries = LedgerEntry.filter(params[:reconcile_params])

  @book_balance = @ledger_entries.sum('ledger_entries.company_amount')
  @outstanding_debits = @ledger_entries.where(reconciled: false).where('ledger_entries.company_amount > 0').sum(:amount)
  @outstanding_credits = @ledger_entries.where(reconciled: false).where('ledger_entries.company_amount < 0').sum(:amount)

  @bank_balance = if params[:reconcile_params][:bank_balance].present?
                    BigDecimal(Heatwave::Normalizers.chain(params[:reconcile_params][:bank_balance],
                                                            :currency))
                  else
                    BigDecimal(0)
                  end
  @adjusted_bank_balance = @bank_balance.nil? ? nil : @bank_balance + @outstanding_debits + @outstanding_credits
  @amount_to_reconcile = @adjusted_bank_balance.nil? ? nil : @adjusted_bank_balance - @book_balance

  params[:reconcile_params][:reconciled] = params[:reconcile_params][:reconciled].to_b if params[:reconcile_params][:reconciled].present?
  @ledger_entries = @ledger_entries.where(ledger_entries: { reconciled: params[:reconcile_params][:reconciled] }) if [false, true].include?(params[:reconcile_params][:reconciled])
  @pagy, @ledger_entries = pagy(@ledger_entries, limit: 500)
  @ledger_entries = @ledger_entries.preload(
    :ledger_detail_project,
    :business_unit,
    { ledger_company_account: %i[company ledger_detail_account] },
    { ledger_transaction: [
      :company, :invoice, :credit_memo, :voucher, :shipment_receipt, :item_ledger_entries,
      { outgoing_payment: %i[supplier checks] },
      { receipt: :customer },
      { landed_cost: :purchase_order }
    ] }
  )
end