In D365F&O, the Brazilian localization does not provide the required reference fields to define ledger account posting rules by Fiscal Establishment.
The required configuration is needed in the following form/path:
Inventory management > Setup > Posting > Posting
In this posting setup, two fields are required, as shown in the attached screenshots:
- Fiscal Establishment Code
- Fiscal Establishment Relation
These fields are necessary to allow ledger account determination according to the fiscal establishment/site involved in the transaction.
This requirement is especially important for cooperatives. According to Brazilian Law 5.764/71 and the accounting rules applicable to cooperatives, it is mandatory to segregate cooperative acts and non-cooperative acts, which directly impacts the calculation and reporting of results.
Because of this legal and accounting requirement, the same item or operation may require different accounting treatment depending on the fiscal establishment and business context. For example, an operation related to a cooperative act must be accounted for differently from an operation with a non-cooperative customer, requiring specific ledger accounts for each scenario.
Currently, the Brazilian posting setup does not support this configuration because the fields Fiscal Establishment Code and Fiscal Establishment Relation are not available in the standard product for Brazil.
During the technical analysis, we identified that Microsoft has already implemented a similar approach for China in the standard InventPosting table, using the fields:
- SiteCode_CN
- SiteRelation_CN
We kindly request Microsoft to evaluate the possibility of providing a standard solution, extension point, or product enhancement to support Fiscal Establishment-based posting setup for Brazil, with equivalent fields such as:
- FiscalEstablishmentCode_BR
- FiscalEstablishmentRelation_BR
Business impact:
Without these fields, the customer cannot configure the required accounting posting rules by Fiscal Establishment. This may result in incorrect ledger postings, lack of proper segregation between cooperative and non-cooperative operations, non-compliance with Brazilian accounting/legal requirements, and the need for complex customizations in standard posting logic.