{"id":19603,"date":"2019-07-23T10:50:38","date_gmt":"2019-07-23T05:20:38","guid":{"rendered":"http:\/\/tenthplanet.in\/compiere\/?p=19603"},"modified":"2020-12-28T11:03:05","modified_gmt":"2020-12-28T05:33:05","slug":"cash-management","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/compiere\/cash-management\/","title":{"rendered":"Compiere Cash Management"},"content":{"rendered":"

Compiere Cash Management contains below steps<\/p>\n

View Allocation<\/h4>\n

The View Allocations window is used to see the Allocations that were generated when a Payment was linked to an Invoice or Invoices via Payment, Payment Selection or Payment Allocation. Please refer sales and purchase block for payment allocation and selection.<\/p>\n

This is a read-only record that indicates the Payment Allocation that has been processed. The Transaction Date, Account Date, and Currency are updated from the Payment. The Approval Amount indicates the amount that was not paid either via a Discount taken or Write off.<\/p>\n

UI \/Report Layout<\/strong><\/p>\n

\"TenthPlanet_Compiere_Distribution_Cash_Management_View_Allocation\"<\/p>\n

\"TenthPlanet_Compiere_Distribution_Cash_Management_View_allocation_2\"<\/h4>\n

Bank Statement<\/h4>\n

The Bank Statement is used to reconcile the Payment transactions entered in Payment or generated in Payment Selection, with the equivalent information from your bank.<\/p>\n

When Payments are entered or generated, the Bank-In-Transit account for a given Bank Account. As you recall, for Payment and Payment Selection you are required to select a Bank Account.
\nThe Bank Statement reflects the real Statement: Receipts are displayed with a payment. The Statement amount is made up by the Transaction Amount plus\/minus Charges plus\/minus Interest. The Bank Statement window allows you to reconcile your Bank Statements.<\/p>\n

Business Rules<\/strong><\/p>\n

    \n
  • All cash receipts should be reconciled on the same day<\/li>\n<\/ul>\n

    UI \/Report Layout<\/strong><\/p>\n

    \"TenthPlanet_Compiere_Distribution_Cash_Management_Bank_Statement\"<\/p>\n

    \"TenthPlanet_Compiere_Distribution_Cash_Management_Bank_Statement<\/p>\n

    The Bank Statement – Accounting Consequences<\/h4>\n

    When Bank Statements are posted, the Organization used in the accounting transactions for each Bank Statement Line is the Organization defined for the Bank Account selected in the Bank Statement. If, however, a Charge is selected in the Bank Statement Line, the Organization of the Bank Statement Document is used in the accounting transactions. Any required intercompany entries will be created.
    \nThe following outlines the accounting transactions generated for Bank Statement.<\/p>\n\n\n\n\n\n\n\n\n\n
    Cash Type<\/b><\/td>\nDR<\/b><\/td>\nCR<\/b><\/td>\n<\/tr>\n
    Charge (Income)<\/td>\nBank Asset<\/td>\nCharge revenue<\/td>\n<\/tr>\n
    Charge (Expense)<\/td>\nCharge Expense<\/td>\nBank Account<\/td>\n<\/tr>\n
    Interest (Income)<\/td>\nBank Asset<\/td>\nBank Interest Income<\/td>\n<\/tr>\n
    Interest (Expense)<\/td>\nBank Interest Expense<\/td>\nBank Asset<\/td>\n<\/tr>\n
    Payment \u2013 AR<\/td>\nBank Asset<\/td>\nBank in transit<\/td>\n<\/tr>\n
    Payment \u2013 AP<\/td>\nBank in transit<\/td>\nBank Asset<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Currency Gain\/Loss<\/h4>\n

    A Currency Gain or Loss is generated when you have Payable or Receivable transactions in a currency other than your accounting currency and there is a change in the currency conversion rate. The Unrealized Gain or Loss is generated based on Open Payable and Receivables. The Realized Gain or Loss is generated when a Payment is made in a currency other than your accounting currency and the currency conversion rate is different at payment time then when the document was posted.<\/p>\n

    Business Rules<\/strong><\/p>\n

      \n
    • Unrealized gain and loss is required to have entries available for manual posting, a report about re-valuation monetary item is able to view before posting<\/li>\n
    • Realized gain and loss should be posted during the settlement<\/li>\n<\/ul>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Currency_Gain_Loss\"<\/p>\n

      Open Items<\/h4>\n

      This report displays all unpaid invoices. Select a Business Partner and a range of Due Dates. A negative number indicates invoices that are due on a future date and positive number indicates invoices that are already overdue. The number of days is subtracted or added to the current date to determine the invoices to include.<\/p>\n

      Select the Sales Transaction checkbox to generate a report on Customer Invoice transactions. Leaving the Sales Transaction checkbox unselected will generate a report on Vendor Invoice transactions. Note that Invoices that are paid in Cash will appear on the Open Items Report until the Cash Journal is processed.<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Currency_Open_Item\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Currency_Open_Item<\/p>\n

      Aging<\/h4>\n

      This report displays Open Items classified in different Aging ‘buckets’. These include, but are not limited to, 1-7 days, 8-30 days, 31-60 days, >31 days, >61 days etc. You may select a Due Date, Currency, Business Partner Group, and Business Partner. Select the List Invoices checkbox to indicate that the report should list the specific Invoices.<\/p>\n

      Select the Sales Transaction checkbox to generate a report on Customer Invoice transactions. Leaving the Sales Transaction checkbox unselected will generate a report on Vendor Invoice transactions. When the report displays there will be numerous aging ‘buckets’, therefore Open Invoices will appear in more than one bucket. The buckets are defined invoices that are both past and those that are due at a future date<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Aging\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Aging<\/p>\n

      Payment Allocation<\/h4>\n

      This report displays all Payments that have been allocated. You may select a Business Partner and an Invoice. The report will list the Payment or Cash Journal Line, Invoice, Payment Allocation, Amount, and any Write-off or Discount. If a Payment has not been associated with an Invoice, then the Invoice field will be blank.<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Payment_Allocation\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Payment_Allocation<\/p>\n

      Unrecognized Payments<\/h4>\n

      This report displays all Payments that have not been reconciled with a Bank Statement.<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Unrecognized_Payments\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Unrecognized_Payments<\/p>\n

      Unallocated Invoices<\/h4>\n

      This report displays all unallocated invoices.<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Unallocated_Invoices\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Unallocated_Invoices<\/p>\n

      Unallocated Payments<\/h4>\n

      This report displays all unallocated payments.<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Unallocated_Payments\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Unallocated_Payments<\/p>\n

      Payment Details<\/h4>\n

      This report displays the adjusted payments with allocated and available amounts.<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Payment_Details\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Payment_Details<\/p>\n

      Business Partner Open Amount<\/h4>\n

      The report lists open invoices and payments of selected customer or vendor.<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Business_Partner_Open_Amount\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Business_Partner_Open_Amount<\/p>\n

      Invoice Tax<\/h4>\n

      The report list invoice tax lines with partner tax information.<\/p>\n

      UI \/Report Layout<\/strong><\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Invoice_Tax\"<\/p>\n

      \"TenthPlanet_Compiere_Distribution_Cash_Management_Invoice_Tax_2\"<\/p>\n","protected":false},"excerpt":{"rendered":"

      Compiere Cash Management contains below steps View Allocation The View Allocations window is used to see the Allocations that were […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[33,34],"tags":[],"class_list":["post-19603","post","type-post","status-publish","format-standard","hentry","category-solution","category-distribution"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts\/19603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/comments?post=19603"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts\/19603\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/media?parent=19603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/categories?post=19603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/tags?post=19603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}