...
ACCOUNT LOCALIZATION FORM
WHAT IS ACCOUNT LOCALIZATION FORM?
The On Account Localization feature lets users configure Posting Form, the user can configure the posting Logics based on Global settings. It involves configuring the accounting rules based on Posting Document Types and Transaction screens. This setup contains all the posting logic, including conditions that the system will execute when a transaction is posted within the system. PRE-REQUISITES FOR ACCOUNT LOCALIZATION FORM
To set the flow of Account Localization Form in VA there are some pre-requisites required:
...
As per the selection of the above fields, respective Table and column will be available in the Dropdown of Transaction Date Table and Transaction Date column, respectively.
Select the value from the ‘Transaction Date Column’ field and Transaction Date column field. The transaction date column contains the transaction screen table. The Fact_Acct table [Ledger Account Detail] contains two date columns: Account Date and Transaction Date. The Account Date is always populated with the date from the 'Account Date' field of the corresponding transaction, and this logic is fixed. However, for the Transaction Date, users have the flexibility to determine which date to post. Users can select the desired table and column for the Transaction Date while defining the posting logic.
Select the value from the ‘Transaction Date Column’ field and Transaction Date column field. It indicates the date on which the user wants to post the entries.
Click the Save button to save the record.
...
For example, Sales Order screen Contains multiple document types, once a user configures the posting rule, posting logics, and conditions for a Point of Sale (POS) posting document type, they may desire to apply the same posting logic and conditions to the Prepay Order posting document type. In this scenario, the user can select the POS posting document as the reference posting rule.
To Delete, Copy and or Edit the Posting Rule, Click on the Action Button.
...
Suppose the user selects Amount as entity type, it means user want to take Amount from defined Tab & Table under Posting Tab, by referring to Table and Column in this Tab.
The The process shall follow to create a Posting Entity in the system:
Click on Posting Entity to view, add and edit the entities.
...
Click on to Add New record.
Click on to Edit record.
Click the to delete record.
Click on Add New button to add Posting Entity.
...
Posting Rule field will be auto populated by the system based on the Posting Rule defined in the Posting Rule Tab.
Select Entity Type from the drop-down.
Based on the entity Type selected, the user fills the other columns, as described below.
Sr. No. | Entity Type | Columns to be filled |
Amount | Name, Table, Column | |
Budget | Name, Table, Column | |
Cost | Name, Table, Column | |
Forced | Entity | |
Invoiced Price | Name, Table, Column | |
Fixed Logic | Name | |
Master | Master | |
Org Reference | Name, Table, Column | |
PO Price | Name, Table, Column | |
10. | Quantity | Name, Table, Column |
Amount: The amount entity type is chosen to specify the amounts to be posted. Users can designate the table and column from which the amount should be extracted.
Budget – The budget entity type is chosen to define the budget that will be posted.
Cost - The cost entity type is chosen to specify the cost amount of a product to be posted. Users can designate the table and column from which the cost should be extracted. Cost is essential in certain postings related to Material Management, such as Goods Receipt Notes, Physical Inventory, Inventory Move, etc. The cost entity is displayed within the amount entity of the posting logic.
Forced - Forced entity shows all the screens in entity field.
Invoice Price - The invoice price entity type is selected to specify the amounts to be posted on invoices. Users can designate the table and column from which the invoice amounts should be extracted.
Fixed Logic - The fixed logic entity is employed to define static posting logic.
Master - In the master entity all the master screens are shown.
Org Reference - "Org reference" generally denotes an organizational reference entity, encompassing attributes such as organization name or pertinent information utilized for distinguishing and managing different entities or branches within an organization.
PO Price - The PO price entity type is selected to specify the amounts to be posted on Purchase order. Users can designate the table and column from which the Purchase order amounts should be extracted.
Quantity – Quantity entity is selected to specify the quantity to be posted for Material Management, such as Goods Receipt Notes, Physical Inventory, Inventory Move, etc.
...
Click the Save button to save the record.
ACCOUNT ENTITY
In Account Entity, there are two types: master and forced. In master entities, all the master screen tables and columns are displayed, while in forced entities, all the transaction screen tables and columns are shown. After creating an account entity, users can proceed to create conditions based on their requirements.
...
If more than one condition is required to satisfy, then Start bracket in the Start Select 
in the Start Bracket field, Or in ‘AND OR’ field and End Bracket from in the 
‘End Bracket’ field may be chosen, as shown in the example below:
...
Fig. 23