Down Payment Process in S4 HANA with Fiori Apps
2024-1-5 03:15:9 Author: blogs.sap.com(查看原文) 阅读量:9 收藏

This blog post will delve into the intricacies of the Down Payment Process with S4 HANA Finance. Down Payments or Advance payments, constitute a financial practice where parties pay in advance before the actual exchange of goods and services takes place. In the context of S4 HANA Finance, down payments are treated separately on the balance sheet, distinct from the conventional Accounts Payables or Accounts Receivables balances. All these down payments need to be clear once the goods and services are completed either manually or by automatic payment program. Shedding light on its significance and the steps involved in handling down payments.

  • Configuration for Down payment in SAP (Tcode: FBKP)
  • Initiate Down payment Request
  • Post Supplier Down Payment
  • Create Down Payment Invoice
    • Create Incoming Invoice (Without P.O)
    • Create Incoming Invoice (With P.O)
    • Invoice creation thru upload template
  • Clear Supplier Down Payment
  • Schedule Automatic Payments
  • Post Outgoing Payments (Manual)
  • Accounts Payable Overview
  • Aging Analysis

Configuration for Down payment in SAP (Tcode: FBKP)

Maintain Accounting configuration to create special GL accounts for Vendors and Customers

Figure%3A%201%20-%20Configuration%20Screen%20FBKP

Figure: 1 – Configuration Screen FBKP

Double click Special G/L

Creation of Down Payment Request G/L Accounts for Vendors / Suppliers

Figure%3A%201%20-%20Create%20Down%20Payment%20Request%20G/L%20Account%20for%20Vendors

Figure: 2 – Create Down Payment Request G/L Account for Vendors / Suppliers

Double click the above highlighted and assign Reconciliation Account and Special GL Account

21100000 is Vendor Reconciliation account, 12119000 is Special GL Account Vendor / Supplier Down Payment request GL Account indicated by “F

Figure%3A%203%20-%20Assign%20G/L%20Accounts%20to%20Vendor%20account%20type

Figure: 3 – Assign G/L Accounts to Vendor account type

Spl GL Description Recon A/C GL Description Alt Recon ac GL Description
F Down payment Request 21100000 Payables Domestic 12119000 Supplier Down Payment Requests

Creation of Down Payment Request G/L Accounts for Customers

Figure%3A%204%20-%20Create%20Down%20Payment%20Request%20G/L%20Account%20for%20Customer

Figure: 4 – Create Down Payment Request G/L Account for Customer

Double click the above highlighted and assign Reconciliation Account and Special GL Account

GL Account 21190000 is Customer Reconciliation Account, 12100000 is Special GL Account Customer Down Payment request GL Account indicated by “F

Figure%3A%205%20-%20Assign%20G/L%20Accounts%20to%20Customer%20account%20type

Figure: 5 – Assign G/L Accounts to Customer account type

Spl GL Description Recon A/C GL Des Alt Recon ac GL Des
F Customer Down payment 12100000 Receivable Domestic 21191000 Customer Down Payment Requests

Creation of Down Payment G/L Accounts for Vendors / Suppliers

Figure%3A%206%20-%20Create%20Down%20Payment%20G/L%20Account%20for%20Vendors%20/%20Suppliers

Figure: 6 – Create Down Payment G/L Account for Vendors / Suppliers

Double click the above highlighted and assign Reconciliation Account and Special GL Account

21100000 is Vendor Reconciliation account, 12110000 is Special GL Account Vendor / Supplier Down Payment GL Account indicated by “A

Figure%3A%207%20-%20Assign%20G/L%20Accounts%20to%20Vendor%20account%20type

Special GL Description Recon A/C GL Des Alt Recon ac GL Des
A Supplier Down payment 21100000 Payables Domestic 12110000 Supplier Down Payments

Creation of Down Payment G/L Accounts for Customers

Figure%3A%208%20-%20Create%20Down%20Payment%20G/L%20Account%20for%20Customers

Figure: 8 – Create Down Payment G/L Account for Customers

Double click the above highlighted and assign Reconciliation Account and Special GL Account

12100000 is Customer Reconciliation account, 21190000 is Special GL Account Customer Down Payment GL Account indicated by “A

Figure%3A%209%20-%20Assign%20G/L%20Accounts%20to%20Vendor%20account%20type

Figure: 9 – Assign G/L Accounts to Vendor account type

Spl GL Description Recon A/C GL Des Alt Recon ac GL Des
A Customer Down payment 12100000 Receivables Domestic 21190000 Customer Down Payments

Initiate Down payment Request (Fiori App)

This is an optional step to create note in system for down payment. No accounting document is created. Down payment can be  made based on this request

Figure%3A%2010%20-%20Down%20Payment%20Request

Figure: 10 – Down Payment Request

Showed as ‘Noted Items’ in Vendor line-item display. In contrast, the document contains no offsetting entries to other documents.

On the initial screen, you determine which line items should be displayed. For special G/L transactions, you select special G/L transactions.

If you want to display down payment requests only, you can use the selection function using the special G/L code “F”. Down payment requests are displayed in a separate column

Figure%3A%2011%20-%20Showed%20as%20Noted%20Items%20in%20Vendor%20line%20item%20display

Figure: 11 – Showed as Noted Items in Vendor line item display

Down Payment Process Flow

Figure: 12 – Down Payment Process Flow

Post Supplier Down Payment (Fiori App)

Down payment can be made with or without down payment request. System post to alternate GL account to display separately in the Balance sheet

Figure%3A%2013%20-%20Post%20Supplier%20Down%20Payment

Figure: 13 – Post Supplier Down Payment

Figure%3A%2014%20-%20Display%20Document

Figure: 14 – Display Document

Vendor line-item display with Special GL Indicator & alternate reconciliation account

Accounting entries are as below

Posting key GL Accounts Account Number Amount Currency
Dr 29A Special GL Vendor AC Supplier Down Payment 12110000  $    2,000.00 USD
Cr 50 Bank Outgoing A/C 10010000  $    2,000.00 USD

Create Down Payment Invoice (Fiori App)

Create Incoming Invoice (Without P.O)

Use this Fiori app to create a down payment Invoice without P.O. As soon as you enter the Vendor details, Invoice details will get an information message that Down payment exists for this vendor

Figure%3A%2015%20-%20Create%20Incoming%20Invoice

Figure: 15 – Create Incoming Invoice

The system generates an accounting document for the down payment invoice

Figure%3A%2016%20-%20Document%20Entry%20View

Figure%3A%2017%20-%20Document%20Ledger%20View

Figure: 17 – Document Ledger View

Accounting entries are as below

Posting key GL Accounts Account Number Amount Currency
Dr 40 Expense 65003000  $  12,000.00 USD
Cr 31 Vendor A/C Regular Payables Reconciliation Acct 21100000  $  12,000.00 USD

Import Supplier Invoices

AP Invoices thru upload template

Figure%3A%2018%20-%20Import%20Supplier%20Invoices

Figure: 18 – Import Supplier Invoices

Click Download for Template

Figure%3A%2019%20-%20Download%20Template

Figure: 19 – Download Template

After downloading the template, enter all details on the template upload the file in the system.

Figure%3A%2020%20-%20Upload%20the%20template

Figure: 20 – Upload the template

Highlight the worklist item and select “Check”  to see in simulation mode

Figure%3A%2021%20-%20Simulation%20results

Figure: 21 – Simulation results

If you are satisfied with the simulation results, click Post

Figure%3A%2022%20-%20Posted%20an%20Invoice

Figure: 22 – Posted an Invoice

Invoice is posted successfully

Figure%3A%2023%20-%20Supplier%20Invoice

Figure: 23 – Supplier Invoice

Create Incoming Invoice (With P.O)

First create a P.O with “Manage Purchase Orders”

Figure%3A%2024%20-%20Manage%20Purchase%20Orders

Figure: 24 – Manage Purchase Orders

Goods receipt with ” Post Goods Movement app

Figure%3A%2025%20-%20Post%20Goods%20Movement

Figure: 25 – Post Goods Movement

Create Supplier Invoice with reference to P.O

Figure%3A%2026%20-%20Create%20Supplier%20Invoice

Figure: 26 – Create Supplier Invoice

Figure: 27 – Create Supplier Invoice with reference to PO

Invoice posted successfully

Figure%3A%2028%20-%20Invoice%20Posted

Figure: 28 – Invoice Posted

Clear Supplier Down Payment

Once the goods and services are delivered or completed, down payments need to be cleared. Special G/L should be cleared. Down payment clearing moves the balance from alternate reconciliation account to payables reconciliation account. This can be done manually or through automatic payment program, ensuring accurate financial reconciliation. The system generates an accounting document for the clearing. From the above scenario, we received the down payment of $2000 and an expenses of $12,000

Figure%3A%2029%20-%20Clear%20Supplier%20Down%20Payment

Figure%3A%2029%20-%20Clear%20Supplier%20Down%20Payment

Figure: 29 – Clear Supplier Down Payment

Figure%3A%2030%20-%20Down%20Payment%20Clearing

Figure: 30 – Down Payment Clearing

Down Payment Clearing completed with accounting document

Figure%3A%2031%20-%20Clearing%20Document

Figure: 31 – Clearing Document

Accounting entries are as below

Posting key GL Accounts Account Number Amount Currency
Dr 26 Vendor A/C Regular Payables Reconciliation Acct 21100000  $    2,000.00 USD
Cr 29A Special GL Vendor AC Supplier Down Payment 12110000  $    2,000.00 USD

Manage Automatic Payments / Schedule Automatic Payments

With this app you can schedule payment proposals or schedule payments directly and get an overview of the proposal or payment status. The app identifies the overdue invoices and checks whether all the required payment information is complete. Run automatic payment program to clear the open items against the Vendor after clearing down payments. Either you can select the invoice document number in free selection screen or without

Figure%3A%2032%20-%20Schedule%20Automatic%20Payments

Figure: 32 – Schedule Automatic Payments

Execute the payment run and see the postings

Figure%3A%2033%20-%20Payment%20Processed

Figure: 33 – Payment Processed

The final accounting entries are as below

Posting key GL Accounts Account Number Amount Currency
Dr 25 Vendor AC Regular Payables Reconciliation Acct 21100000  $  10,000.00 USD
Cr 50 Bank Outgoing A/C 10010000  $  10,000.00 USD

Post Outgoing Payments (Manual)

With this app you can post and clear a single outgoing payment in one step. You usually perform outgoing payments automatically based on payment proposals. However, if you want to perform a payment immediately, you need to enter the payment data manually. You can clear outgoing payments with open items. You can also post an outgoing payment on account or to a G/L account.

Figure%3A%2034%20-%20Post%20Outgoing%20Payments

Figure: 34 – Post Outgoing Payments

Enter all payment details and click process open items, select only the line item you want clear the payment and post it

Figure: 35 – Process Open Items

Figure: 36 – Select the Open Item

Accounts Payable Overview

With this analytical overview app, you can monitor important accounts payable indicators and access the relevant accounts payable apps. You can use the filters to limit the data behind the indicators to the information most relevant for you. You can track down the Parked, Blocked, Posted invoices and Payable Outstanding’s, Payments etc.

Figure%3A%2037%20-%20Accounts%20Payable%20Overview

Figure: 37 – Accounts Payable Overview

Aging Analysis

With this app you can see the aging information across your organization so that you can identify negative trends in the total payable amount, the net due amount, and the overdue amount. This allows you to timely react by having your team taking appropriate actions to reverse these trends.

Figure%3A%2038%20-%20Aging%20Analysis%20Report

Figure: 38 – Aging Analysis Report

Conclusion

This blog post provides some insights on the down Payment process in S4 HANA Finance is a curial aspect of financial transactions, offering flexibility and transparency in handling advance payments. By segregating down payments on the balance sheet, organizations can maintain a clear and accurate financial records. Understanding and effectively managing the down payment process is essential for managing integrity and ensuring smooth business operations. Share your feedback in the comment section


文章来源: https://blogs.sap.com/2024/01/04/down-payment-process-in-s4-hana-with-fiori-apps/
如有侵权请联系:admin#unsafe.sh