Customer Reconciliations Sub-Tab

This section includes the fields and descriptions for the Customer Reconciliations sub-tab.

Field Description
Removed Reconc. Date If an approved reconciliation was removed, this shows the date it was removed.
Entry Date This field shows the date on which the entry was registered in the A/R or the G/L module.
Trans. No. This field shows the entry’s transaction number. If the entry is from a general journal, the number was entered manually. If the entry is from invoicing or crediting in the sales orders module, the transaction number is the same as the invoice or credit memo number which was given automatically by Maconomy from the “Invoice” or “Credit Memo” system numbers. If the entry is an interest entry or reminder charge, the number was given automatically from the “Interest Notice” system numbers.
Trans. Type This field shows the transaction type of the customer entry against which the customer entry in the card part was reconciled.
Description This field shows the text assigned to the entry.
Orig. Amount This field shows the entry amount in the original currency.
Original Currency This field shows the original currency of the entry.
Reconciled, Original This field shows the amount reconciled on the original entry. The amount is displayed in the currency used on the entry in question.
Cash Discount, Original This field shows the cash discount amount registered on the entry, if any. The amount is displayed in the currency used on the entry in question.
Cust. Paym. Variance, Original This field shows the payment variance amount registered on the entry, if any. The amount is displayed in the currency used on the entry in question.
Type This field shows the customer entry type, which can be one of the following:
  • Invoice from invoicing in the Sales Orders module.
  • Credit memo from crediting in the Sales Orders module.
  • Interest from approval of interest charge selection in the A/R module.
  • Reminder from approval of reminder selection in the A/R module.
  • Payment, a credit entry made in the window General Journal.
  • Payment, a debit entry made in the window General Journal.
  • Cash Discount Positive, a cash discount entered in the window Customer Open Entry Reconciliation.
  • Currency Variance Positive, currency gain entered in the window Customer Open Entry Reconciliation or the window General Journal.
  • Currency Variance Negative, currency loss entered in the window Customer Open Entry Reconciliation or the window General Journal.
Reconciliation Currency This field shows the currency in which reconciliation of the current line has been made.
Debit, Standard This field shows the entry amount in the customer’s standard currency, if the entry is a debit entry.
Credit, Standard This field shows the entry amount in the customer’s standard currency, if the entry is a credit entry.
Reconciled, Standard This field shows the amount reconciled of the original entry. The amount is displayed in the customer’s standard currency.
Cash Discount, Standard This field shows the cash discount amount registered on the entry, if any. The amount is displayed in the customer’s standard currency.
Cust. Paym. Variance, Standard This field shows the payment variance amount registered on the entry, if any. The amount is displayed in the customer’s standard currency.
Debit, Base This field shows the entry amount in the base currency, if the entry is a debit entry.
Credit, Base This field shows the entry amount in the base currency, if the entry is a credit entry.
Reconciled, Base This field shows how much of the original entry has been reconciled. The amount is displayed in the base currency.
Cash Discount, Base This field shows the cash discount amount registered on the entry, if any. The amount is displayed in the base currency.
Cust. Paym. Variance, Base This field shows the payment variance amount registered on the entry, if any. The amount is displayed in the base currency.
Open/Closed This field shows whether the entry is open or closed.
Due Date This field shows the entry’s due date. If the entry is an invoice, the due date is calculated on the basis of the invoice date and the customer’s terms of payment. Otherwise the due date is the entry date.
Date Posted This shows the date the entry was posted.
Journal No. This field shows the number of the posting journal in which the entry was posted.
Company of Origin This field shows the name of the company responsible for the invoice, credit memo, general journal or interest or reminder selection that has caused the current customer entry. On invoices, credit memos, and general journals, the responsible company can be specified in the field “Company No.” in the island Company whereas the responsible company on customer entries created upon approval of the interest or reminder selection is automatically transferred from the field “Company No.” in the island Settling Company on the relevant customer information card.
Company No. This field shows the value of the dimension Company on the current customer entry. The value is transferred from the field “Company No.” in the island Settling Company on the information card of the current customer.
Location This field shows the value of the dimension Location on the current entry. If the entry is caused by an invoice or a credit memo, the value is transferred from the field “Location” in the card part of the current invoice or credit memo. If the customer entry is caused by a general journal, the value is transferred from the field “Location” on the general journal line with the customer entry. If the customer entry is caused by an interest or reminder selection, the value is transferred from the field “Location” on the information card of the current customer.
Entity The functionality of this field is similar to that of the field “Location” above.
Project The functionality of this field is similar to that of the field “Location” above.
Purpose The functionality of this field is similar to that of the field “Location” above.
Spec. 1-3 The functionality of these fields is similar to that of the field “Location” above.
Local Spec. 1-3 The functionality of these fields is similar to that of the field “Location” above.