Debit Memo (ARR024)
- 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Debit Memo (ARR024)
- Updated on 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
This report was implemented in CMS Wave and will be updated in Financials Wave. The information in this article is the planned design for Financials Wave.
This report displays all deposits that have been returned to Florida PALM by the bank. Deposits are returned for various reasons (e.g., insufficient funds, credit card disputes, or closed accounts). Returned deposits are processed as debit memos (negative deposits) and applied to the respective agency revenue accounts within Florida PALM. The Debit Memo report will generate one PDF for each transaction within the parameters. This report is used to account for fully processed (e.g., journal generated and reconciled) debit memo deposits that have been returned to the State by the Bank. Agencies can utilize this report to verify and update their legacy systems.
The interface file with returned items from the Banks is imported and processed in Florida PALM. The Debit Memo report extracts the deposit and payment details for the returned items. Deposit Types are used to differentiate the type of debit memo (Paper Check, Foreign Paper, EFT/ACH, Credit Cards) on the report and to determine which fields are displayed. Agencies can utilize this report to verify and update their legacy systems.
Additional fields for Financial Segment: New ChartFields, Supplier ID, Asset ID Reference, AR Item, and Customer.
Report Navigation: Main Menu > Reports > AR > DebitMemo
See the sample layout report below.
Business Roles
The following business roles have access to this report:
- Agency AR Deposit Processor
- Agency AR Deposit Spreadsheet Upload Processor
- Agency AR Deposit Approver
- Agency AR Deposit Reporter
- DFS CM Bank Reconciliation Processor
- DFS Same Day Deposit Approver
- DFS AR Deposit Processor
Business Process Models
This report can be found in the following business processes:
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
Deposit BU | Required – Prompt with security |
From Date | Required – Deposit Accounting Date |
To Date | Required – Deposit Accounting Date |
From Amount | Optional – Deposit Amount |
To Amount | Optional – Deposit Amount |
Agency Deposit Number | Optional |
Deposit ID | Optional |
Bank Code | Optional – Prompt with security |
Bank Account Number | Optional – Prompt with Security |
Check box for Deposit Type | Optional |
Organization | Optional |
Payment ID | Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
Deposit ID | DEPOSIT_CONTROL.DEPOSIT_ID |
Received Date | DEPOSIT_CONTROL.RECEIVED_DT |
Agency Deposit Number | FLP_DEP_NUM_TBL.FLP_AGEN_DEP_NO |
Location | DEPOSIT_CONTROL.BANK_ACCT_NUM |
Deposit Type | DEPOSIT_CONTROL.DEPOSIT_TYPE Description of the Deposit Type (DEPOST_TYPE_TBL) |
Bank Transaction Date | BANK_STMT_TBL. RECON_BANK_DT |
Bank Code | DEPOSIT_CONTROL.BANK_CD |
Bank Account | DEPOSIT_CONTROL.BANK_ACCOUNT_NUM |
Bank Acct Key | DEPOSIT_CONTROL.BANK_ACCT_KEY |
Accounting Date | DEPOSIT_CONTROL.ACCOUNTING_DT |
Reconciliation Type | PAYMENT.RECON_TYPE |
Reconciliation Date | PAYMENT.RECON_STATUS |
Statement ID | PAYMENT.RECON_CYCLE_NBR |
User ID | DEPOSIT_CONTROL.OPRID |
Payment ID | PAYMENT.PAYMENT_ID |
Amount | PAY_MISC_DST.FOREIGN_AMOUNT |
GL Business Unit | PAY_MISC_DST.BUSINESS_UNIT_GL |
Organization | PAY_MISC_DST.DEPTID |
Account | PAY_MISC_DST.ACCOUNT |
Fund | PAY_MISC_DST.FUND_CODE |
Budget Entity | PAY_MISC_DST.BUDGET_REF |
Category | PAY_MISC_DST.PRODUCT |
State Program | PAY_MISC_DST.CHARTFIELD2 |
Grant | PAY_MISC_DST.PROGRAM_CODE |
Contract | PAY_MISC_DST.CHARTFIELD1 |
OA1 | PAY_MISC_DST.CLASS_FLD |
OA2 | PAY_MISC_DST.CHARTFIELD3 |
PC Business Unit | PAY_MISC_DST.BUSINESS_UNIT_PC |
Project | PAY_MISC_DST.PROJECT_ID |
Activity | PAY_MISC_DST.ACTIVITY_ID |
PC Source Type | PAY_MISC_DST.RESOURCE_TYPE |
PC Category | PAY_MISC_DST.RESOURCE_CATEGORY |
PC Subcategory | PAY_MISC_DST.RESOURCE_SUB_CAT |
Company Name | FLP_ACH_NOC_HDR.FLP_BOA_COMP_NAME |
Company ID | FLP_ACH_NOC_HDR.FLP_BOA_COMPANY_ID |
Transaction Code | FLP_ACH_NOC_LN.FLP_ACH_NOC_TR_CD |
Company Entry Description | FLP_ACH_NOC_HDR.FLP_BOA_CO_ENT_DES |
Identification Number | FLP_ACH_NOC_LN.FLP_BOA_CO_ENT_DES |
Receiving Name | FLP_ACH_NOC_LN.FLP_CORR_RECV_NAME |
Trace Number | FLP_ACH_NOC_LN.FLP_BOA_TRACE_NBR |
Return Reason Code | FLP_ACH_NOC_LN.FLP_RET_REASON_CD |
Original Entry Trace Number | FLP_ACH_NOC_LN.FLP_ORG_ENT_TR_NUM |
Original Receiving DFI | FLP_ACH_NOC_LN.FLP_ORIG_DFI_ID |
Immediate Origin | FLP_ACH_NOC_HDR.FLP_BOA_IMMED_ORG |
Effective Entry Date | FLP_ACH_NOC_HDR.FLP_EFF_ENTRY_DT |
Originating DFI | FLP_ACH_NOC_HDR.FLP_ORIG_DFI_ID |
Receiving DFI ID | FLP_ACH_NOC_LN.FLP_BOA_RCV_DFI_ID |
Receiving DFI Check Digit | FLP_ACH_NOC_LN.FLP_BOA_CHK_DIGIT |
Date of Death | FLP_ACH_NOC_LN.DT_OF_DEATH |
Addenda Trace Number | FLP_ACH_NOC_LN.FLP_BOA_TRACE_NBR |
SEC | FLP_ACH_NOC_LN.FLP_BOA_CLS_CD STMT_CODE_TBL.DESCR50 (Ex. CCD - credit card standard entry) |
DFI Account Number | FLP_ACH_NOC_LN.FLP_COR_DFI_ACTNBR |
Maker Name | FLP_AR_RCHK_LN.FLP_DEPOSITED_BY |
Maker Routing Number | FLP_AR_RCHK_LN.FLP_ITEM_BANK_ID |
Maker Account | FLP_AR_RCHK_LN.FLP_ITEM_ACC_NUM |
Maker Check Date | FLP_AR_RCHK_LN.FLP_ECHK_AUTH_DATE |
Check Deposit Date | FLP_AR_RCHK_LN.FLP_DEPOSIT_DATE |
Return Reason | FLP_ACH_NOC_LN.FLP_RETURN_REASON |
Version History
Date | Revision Description |
12/01/2023 | Original Version |
Was this article helpful?
