FAGL_FCV – Filter Open Items by Reconciliation Account

I would like to explain two issues that we faced in the transaction FAGL_FCV when we filter open items by reconciliation account.

1. Filtering by dynamic selection “reconciliation account” under “Vendor or Customer Company Code”, doesn’t return the desired results during the “open items – subledger” valuation in transaction code FAGL_FCV. The valuation program doesn’t consider or filter by the specific reconciliation accounts entered in the dynamic selection. 

According to the standard design, the valuation logic FAGL_FCV is designed to perform the valuation of payables/receivables based on the valuation of vendor/customer open items. This means that  the valuation of payables/receivables  is according to the balances represented by the related vendor/customer reconciliation accounts. Therefore FAGL_FCV will not propose valuation when program is executed for “balance valuation”. 

If you want FAGL_FCV to filter  by customer or vendor reconciliation account, then  use the Dynamic Selections for category  “Customer/Vendor  Line Items”
Then enter the desired Reconciliation Account under field “G/L Account” to restrict the postings to this particular reconciliation account.

Tab Open Items: Subledger -> Vendor/ Customer Selection -> Selections -> Vendor/Customer line items–> G/L Account -> here you can include or exclude posting for a specific reconciliation account.

Reference Note: 3519891 

2. Dynamic selections for reconciliation accounts are not working properly in FAGL_FCV.

When using the free selections of FAGL_FCV, different categories of selections exist:

Customer MasterCustomer Company CodeCustomer Line Items

Field reconciliation account of category Customer Company Code selects (or excludes) all postings of all customers to which the entered reconciliation account has been assigned to. In case of postings with special GL indicators to these customers, also these postings are selected even though they may have been posted to different GL accounts.

When using the free selection reconciliation account of Customer Company Code all postings of all customers to which this reconciliation account has been assigned to plus all postings with special GL indicator to these customers to different GL accounts are selected (or excluded).

In case you would only like to exclude the postings to the entered reconciliation account, you should use the free selections G/L Account in category Customer Line Items. If the reconciliation account is entered in this selection, only the postings to this particular reconciliation account are excluded.

Please follow these settings:

 

Tab Open Items: Subledger -> Customer Selection -> Selections -> Customer line items–> G/L Account -> here you can exclude a specific reconciliation account.

This way it will not appear in the output list.

Reference Note: 3142560 

 

​ I would like to explain two issues that we faced in the transaction FAGL_FCV when we filter open items by reconciliation account.1. Filtering by dynamic selection “reconciliation account” under “Vendor or Customer Company Code”, doesn’t return the desired results during the “open items – subledger” valuation in transaction code FAGL_FCV. The valuation program doesn’t consider or filter by the specific reconciliation accounts entered in the dynamic selection. According to the standard design, the valuation logic FAGL_FCV is designed to perform the valuation of payables/receivables based on the valuation of vendor/customer open items. This means that  the valuation of payables/receivables  is according to the balances represented by the related vendor/customer reconciliation accounts. Therefore FAGL_FCV will not propose valuation when program is executed for “balance valuation”. If you want FAGL_FCV to filter  by customer or vendor reconciliation account, then  use the Dynamic Selections for category  “Customer/Vendor  Line Items”Then enter the desired Reconciliation Account under field “G/L Account” to restrict the postings to this particular reconciliation account.Tab Open Items: Subledger -> Vendor/ Customer Selection -> Selections -> Vendor/Customer line items–> G/L Account -> here you can include or exclude posting for a specific reconciliation account.Reference Note: 3519891 2. Dynamic selections for reconciliation accounts are not working properly in FAGL_FCV.When using the free selections of FAGL_FCV, different categories of selections exist:Customer MasterCustomer Company CodeCustomer Line ItemsField reconciliation account of category Customer Company Code selects (or excludes) all postings of all customers to which the entered reconciliation account has been assigned to. In case of postings with special GL indicators to these customers, also these postings are selected even though they may have been posted to different GL accounts.When using the free selection reconciliation account of Customer Company Code all postings of all customers to which this reconciliation account has been assigned to plus all postings with special GL indicator to these customers to different GL accounts are selected (or excluded).In case you would only like to exclude the postings to the entered reconciliation account, you should use the free selections G/L Account in category Customer Line Items. If the reconciliation account is entered in this selection, only the postings to this particular reconciliation account are excluded.Please follow these settings: Tab Open Items: Subledger -> Customer Selection -> Selections -> Customer line items–> G/L Account -> here you can exclude a specific reconciliation account.This way it will not appear in the output list.Reference Note: 3142560    Read More Technology Blog Posts by Members articles 

#SAP

#SAPTechnologyblog

You May Also Like

More From Author