ORFM has its own Foundation Data and shares with Merchandising. The foundation data has to be configured for the proper functioning of the ORFM application.
This chapter covers the following sections:
ORFM Foundation Data Setup includes setting up the utilization codes, related parameters, and document type codes.
Requisition Type indicates the type of transaction that ORFM supports. ORFM supports the following requisition types:
Purchase Order (PO) – applicable when there is movement of merchandise from a supplier to retailer's location.
Transfer (intra-company) – applicable when there is movement of merchandise from one location to another, either a warehouse or a store.
Intercompany Transfer – applicable when there is a movement of merchandise between companies.
Return to Vendor (RTV) – applicable when the merchandise is returned to the vendor.
Repairing – applicable when merchandise is sent out to the external finisher or the supplier for finishing work (such as printing, dyeing, and embroidery) or repair (in the case of damaged goods).
Return Merchandise Authorization (RMA) – applicable when the retailer to pick up merchandise that is being returned from the customer.
Inventory Adjustment (STOCK) – applicable when it is necessary to adjust quantity in inventory quantity for one or more item/locations.
Direct NF (DNF) - applicable when used to distinguish StandAlone NFs from Other NFs created within ORFM.
Free Form NF (FFNF) - applicable when the user wishes to add generic items/services that are not present in RMS to the NF or use fiscal entities that are not defined in RMS. This is a StandAlone NF that is not related to any RMS transaction.
Customer Order Drop Ship - applicable to support customer orders which will be shipped directly from the supplier to the customer, often referred to as drop ship orders.
Sales - applicable to support any customer order transaction.
Return NF (RNF) - applicable to support automatic return to vendor NF generated, based on discrepancy treatment at receiving.
PO for Rural Producer (RPO) - applicable to support generation of Entry NF called 'contra-nota' for Rural Producers and ORFM issues an electronic Nota Fiscal (NF-e) to entry goods.
Nature of Operation (NOP) is a term used in Tax Engine. The nature of operations represents the transactions used to deduce the Código Fiscal de Operações e Prestações (CFOP) codes in tax rules. There can be more than one utilization for the same NOP. For each Tax Engine call to retrieve taxes, ORFM returns the NOP related to the transaction to Tax Engine.
Note: ORFM and RMS are integrated with Tax Engine to get the tax break up for the NF. Tax Engine requires NOP to derive the CFOP before tax calculations. Therefore, ORFM maintains the list of NOP and enables you to link utilization and NOP. |
Mode indicates whether the NF is being created for inbound, or outbound operations. The possible values for Mode are Inbound (Entry), and Outbound (Exit).
All merchandise in ORFM is associated with a utilization code. This code provides information about the transaction type and the NF related to the transaction. This information is used to determine the appropriate taxes for the merchandise as well as the impact on warehouse stock and on costs.
Each utilization code is linked to a Requisition Type, a NOP, and one or more document types.
To add a Utilization Code, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then Fiscal Configuration.
In the Contents Of Fiscal Configuration, select Fiscal Utilization.
In the Contents Of Fiscal Utilization window, click Edit. The Fiscal Utilization Setup window opens.
Note: Click View in the Contents Of Fiscal Utilization window to view the fiscal utilization codes. In the View mode, the multi-record block is non-editable, and the Add and Delete buttons are disabled. |
On the Fiscal Utilization Setup window, click Add. A highlighted blank row appears.
Enter the Utilization Code, and Description. The Utilization Code is the unique identifier for each utilization. The Description column describes the fiscal utilization.
Select the Requisition Type from the list in the Requisition.Type column. The requisition types available are: Purchase Order, Transfer, Return to Vendor, Return Merchandise Authorization, Stock Out, PO for Rural Producer, InterCompany Transfers, Repairing, Return NF, Direct NF, FreeForm NF, Customer Order Dropship, and Sales.
Select the Issue type from the list in the Issue column. The issue types are: Issue or Include. The drop-down is enabled if the Requisition Type is either, Direct NF or Free from NF. The drop-down value of Issue indicates that the utilization code is relevant for cases wherein the Retailer is issuing the NF. When utilization codes classified as Issue are used for StandAlone NF creation, the Fiscal number, Serial, and Sub Serial Number fields are populated based on Location sequencing Logic. The drop-down value Include, indicates that the NF is issued by an external system. StandAlone NFs using utilization code classified as Include will have a mode type of entry and it allows for manual entry of the Fiscal number information.
Select the Nature of Operation.
Enter the mode of operation (Entry or Exit).
The Fiscal Utilization Options menu consists of the following items:
Document Type
Parameters
Reason Code
The utilization code is linked to one or more document types, and each fiscal document type has to be associated with a utilization code.
To add Doc Type to the Utilization Code, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then select Fiscal Configuration.
In the Contents Of Fiscal Configuration window, select Fiscal Utilization.
In the Contents Of Fiscal Utilization window, click Edit. The Fiscal Utilization Setup window opens.
Note: Click View in the Contents Of Fiscal Utilization window to view the fiscal utilization codes. In the View mode, the multi-record block is non-editable, and the Add and Delete buttons are disabled. |
In the Fiscal Utilization Setup window, select the Utilization Code for which Doc Types are being defined.
From the Options menu, select Doc Type. The Fiscal Utilization Document Type window opens.
Click Add. A highlighted blank row is displayed.
From the Doc Type ID LOV, select the value.
Click OK to exit the window.
To delete document types, do the following in the Fiscal Utilization - Document Type window:
Select the doc type that you want to delete. Click Delete in the Fiscal Utilization - Document Type window.
A message appears. Click Yes to delete the document type.
Click OK to exit the window.
Parameters are defined for each of the utilization codes.
To associate the parameters with the utilization codes, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then select Fiscal Configuration.
In the Contents Of Fiscal Utilization, select Edit. The Fiscal Utilization Setup window opens.
On the Fiscal Utilization Setup window, click the Options menu.
Select Parameters. The Fiscal Utilization Attributes window opens.
Select or deselect the check boxes to configure the parameters for every Utilization Code.
Table 2-1 provides the list of parameters, and their description.
Table 2-1 Parameters of Fiscal Utilization Attributes
Field | Description |
---|---|
Complementary NF |
Indicates this utilization is used to Complementary NF when you select the Complementary NF check box, the Complementary NF Type list is enabled. This field can be editable only if there is no NF using this utilization code. After this, this parameter will be dimmed. |
Complementary NF Type |
Choose the Complementary NF type from the Complementary NF Type list:
|
ICMS-ST Recovery |
Select this check box to indicate that the particular transaction maintains records for recovery of the Imposto sobre Circulação de Mercadorias e Serviços - Substituição Tributária (ICMS-ST) tax. This flag is used for entry or exit transactions and when it is selected, the flag for entry or exit utilization is selected, the FlagGravaHistorico field is sent as the following values:
|
Item Utilization |
This field is sent to Tax Rules when populating the Freight Object. Click the Item Utilization LOV to obtain the following values.
|
Automatic NF Approval |
Select this check box to validate and approve the fiscal documents automatically. Automatic NF approval is relevant only for outbound NFs generated by ORFM. The user can set it by utilization, so, it is possible to approve all intra-company NFs automatically but manually approve RTV NFs. |
Allow Receiving |
This indicator is only used for inbound NFs. Select this check box to enable the schedule submission message flow to the Warehouse Management System (RWMS) or the Store Inventory Management System (SIM). In case of complementary NFs, since there is no physical receiving, this indicator is disabled. |
NF e Manifest |
Indicates if utilization has NF-e manifest for inbound NFs. |
Choose NF |
Select this check box to choose the referential Fiscal Document. This indicator is relevant for RTV related utilizations only. |
Import Order NF |
Select this check box if this utilization ID is for a PO NF that will supports Importation transactions. If the Import Order Type is Direct Import, the Complementary NF cannot be setup as Triangulation as there is no Triangulation for Direct Import Order currently supported in the system. |
Import Order Type |
Choose the Import Order Type from the Import Order Type list:
|
The Reason Code is created by the retailer for inventory adjustment, only when Requisition Type is STOCK operations for other Requisition Types, this option will be dimmed.
A utilization can have any number of Reason Codes attached to it. However, the Reason Code cannot be attached to utilization if the Reason Code is already attached to any other Utilization ID. The Reason Code LOV shows only the Reason Codes that are not attached to any type of utilization ID.
To associate Reason Code with the Utilization Code, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then select Fiscal Configuration.
On the Fiscal Utilization Setup window, click the Options menu.
Select the inventory adjustment for which you want to add the Reason Code. From the Options menu, select Reason Code. The Fiscal Utilization Reason Codes window opens.
Click Add. In the highlighted row that appears, select the reason code from the list.
Click OK. The reason code is associated with the inventory adjustment.
To delete the reason code, do the following in the Fiscal Utilization Codes Reason Codes window:
Select the reason code that you want to delete. Click Delete in the Fiscal Utilization Codes Reason Codes window. A message appears. Click Yes to delete the reason code.
Click OK to exit the window.
The document type codes are defined by the fiscal authorities and each NF must have a document type code at the header level.
To associate Fiscal Document Types with a Utilization Code, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then select Fiscal Configuration.
In Contents Of Fiscal Configuration window, select Fiscal Document Types.
In Contents Of Fiscal Document Types, click Edit. The Fiscal Document Type window opens.
Select the document type from the list. The list contains the all possible Fiscal Doc Types. The list displays the Fiscal Document Type ID and Description.
Click Add to add a fiscal document type. A new highlighted row is displayed.
The Description field displays the Fiscal Document Type description.
Click OK to exit the window.
To delete the document type, do the following:
Select the document type that you want to delete. Click Delete. A confirmation message appears.
Click Yes to delete the document type.
Click OK to exit the window.
To associate the document type with the Utilization Code, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then select Fiscal Configuration.
Select the document type to which you want to associate a Utilization Code.
Click Util button in the Fiscal Document Type window. The Fiscal Doc Type Utilization window opens.
Click Add in the Fiscal Doc Type Utilization window.
A new row appears. Select the Utilization Code from the list.
Click OK to save your changes and exit the window.
To delete the utilization, do the following:
To delete a utilization, select the utilization, and click Delete.
Confirm the deletion in the message that appears. Click OK to exit the window.
Set up the system configuration variables using the System Setup link.
Variable | ALLOW_SUBMIT_DATE |
Description | Check Entry_Or_Exit Date and Exit Hour fields for all NF in a schedule during submit for receiving process is greater than system date |
Valid Value | Y: If greater than system date, user will be not able to submit schedule for receiving
N: If greater than system date, user will be able to submit schedule for receiving. |
Variable | CLEAR_CALC_STG_TABLES_ONLINE |
Description | Behavior to clear stage tables for data from tax call. |
Valid Value | Y: The delete the stg data Online after each tax call
N: The delete will be done in purge batch process later |
Variable | DEBIT_MEMO_TRAN_CODES |
Description | Tran Codes which must be posted as look up code CREDIT in AP header staging. |
Valid Value | Valid RFM Tran codes separated by comma. |
Variable | DEFAULT_ACTION_REQ_PARM |
Description | Default Action Required Parametrization list. |
Valid Value | Default value: ARBS |
Variable | DEFAULT_COST_TAX_NOP |
Description | Default cost tax calls NOP. |
Valid Value | Valid NOP. Default 001 when tax engine is TaxWeb. |
Variable | DEFAULT_COUNTRY |
Description | Default supplier country |
Valid Value | Default value: BR |
Variable | DEFAULT_CURRENCY |
Description | Default currency code |
Valid Value | Default value: BRL |
Variable | DEFAULT_NOP |
Description | Default Nature of Operation used when there is no NOP is defined in Purchase transactions. |
Valid Value | Valid NOP. Default 001 when tax engine is TaxWeb |
Variable | DEFAULT_REF_MESSAGE_ICMS_ST |
Description | ICMS-ST retido anteriormente, Base Cálculo R$ %s1, Valor Retido R$ %s2. |
Valid Value |
Variable | DEFAULT_RETAIL_TAX_NOP |
Description | Default Nature of Operation used when there is no NOP is defined in Sales transac-tions. |
Valid Value | Valid NOP. Default 002 when tax engine is TaxWeb |
Variable | ENABLE_DEBUG |
Description | Indicates whether to save the debug messages on the debug table (FM_DEBUG) |
Valid Value | Y: Enable
N: Disable |
Variable | ENABLE_LOG_RFM_TAX |
Description | Log tax payload from third-party tax engine into RFM log tables for RFM tax. |
Valid Value | Y: Enable
N: Disable |
Variable | ENABLE_LOG_RMS_TAX |
Description | Log tax payload from third-party tax engine into RFM log tables for RMS tax. |
Valid Value | Y: Enable
N: Disable |
Variable | ENABLE_PREV_CFOP_TAXCALL |
Description | Enables on FM_T_EXT_TAXES_SQL.LOAD_NF_OBJECT the execution of cursor C_GET_ORIG_CFOP_TSF. |
Valid Value | Y: Enable
N: Disable |
Variable | EXT_TAX_PROVIDER |
Description | Indicates which external tax provider is integrated with the system. |
Valid Value | TAXWEB |
Variable | FM_NOTIFY_RIB_INTEGRATION |
Description | Indicates if status integration uses RIB |
Valid Value | Y: Enable
N: Disable |
Variable | HOUR_FORMAT |
Description | Format to represent fields of hour. Must be HH24:MI or HH:MI AM. |
Valid Value | Default Value: HH24:MI |
Variable | NF_BREAKUP_TAX_REGIME |
Description | Identify the attribute for breaking the NF |
Valid Value | Default Value: ITEM_UNDER_ST_REGIME |
Variable | NUMBER_FORMAT |
Description | Value Field Format |
Valid Value | Default Value: FM9G999G999G999G990D90PR |
Variable | NUMBER_FORMAT_4 |
Description | Value Field Format for 4decimal |
Valid Value | FM9G999G999G999G999G900D9000 |
Variable | PACK_COMP_FISCAL_REPORTING |
Description | Change the way RFM and RMS handle the publication of the NFs and the stock position to SPED. |
Valid Value | PACK: by Pack
COMP: by Component |
Variable | PERCENT_FORMAT |
Description | Percentage Field Format |
Valid Value | Default Value: FM9G999G999G999G999G990D9000"%" |
Variable | QTY_FORMAT |
Description | Quantity Field Format |
Valid Value | Default Value: FM9G999G999G999G999G900D9000 |
Variable | RECOVERABLE_TAX_CST |
Description | Value related to the selected CST |
Valid Value | Default Value: 060 |
Variable | CEST_MANDATORY |
Description | Indicates if it's mandatory to inform the CEST code during NF receiving. |
Valid Value | Y: MandatoryN: Optional |
Variable | DEFAULT_FREIGHT_TYPE |
Description | Default freight type used by the process to create an EDI document based on external systems. |
Valid Value | 0 - Freight contracted by Sender (CIF)
1 - Freight contracted by Addressee (FOB) 2 - Freight contracted by Third Parties 3 - Own Carrier on behalf of the Sender 4 - Own Carrier on behalf of the Addressee 9 - No freight occurrence |
Variable | DEFAULT_NFCE_DOC_TYPE |
Description | Default Document Type for NFCe |
Valid Value | Valid document type |
Variable | DEFAULT_NFCE_MODEL_CODE |
Description | Default Document Type for Customer NFE (NFC-e) |
Valid Value | Default Value: 65 |
Variable | DEFAULT_NFE_DOC_TYPE |
Description | Default Document Type for NF-e |
Valid Value | Valid document type |
Variable | DEFAULT_NFE_IND_TYPE |
Description | Active NFe (Nota Fiscal Eletrônica) |
Valid Value | Y: Enable
N: Disable |
Variable | DEFAULT_VERSAO_NFE |
Description | Default value to be sent in RMS tax calls for the field "VersaoNFe". |
Valid Value | 4.00: NF-e Version 4.00 3.10: NF-e Version 3.10 |
Variable | DEFAULT_NFE_MODEL_CODE |
Description | Default Document Type for NF-e |
Valid Value | Default Value: 55 |
Variable | DEFAULT_PAYMENT_METHOD |
Description | Default Payment Method |
Valid Value | 01 - Cash
02 - Check 03 - Credit Card 04 - Debit Card 05 - Store Card 10 - Voucher (VA - Vale Alimentação) 11 - Voucher (VR - Vale Refeição) 12 - Gift Card 13 - Voucher (VC - Vale Combustível) 15 - Bank Slip 90 - No Payment 99 - Others |
Variable | DEFAULT_PRENF_SERIES |
Description | Default PRENF series. |
Valid Value | Default value: PNF |
Variable | EXTIPI_VALIDATION |
Description | Indicates if EX TIPI validation is required. |
Valid Value | Y: Enable
N: Disable |
Variable | FISCAL_DOC_NO_BUFFER_SIZE |
Description | Size of the buffer for Fiscal Doc Numbers generated on table FM_LOC_FISCAL_NUMBER_DETAIL |
Valid Value | Default Value: 10 |
Variable | MDEST_SEFAZ |
Description | Indicates the number of days MDest SEFAZ. |
Valid Value | Default Value: 0 |
Variable | NCM_VALIDATION |
Description | Indicates if NCM validation is required. |
Valid Value | Y: Enable
N: Disable |
Variable | NEXT_FISCAL_DOC_NO_RETRY_QTY |
Description | Number of retries to get the fiscal number if the fm_loc_fiscal_number table is locked |
Valid Value | Default Value: 5 |
Variable | NEXT_FISCAL_DOC_NO_RTRY_SLPSEC |
Description | Sleep seconds to retry to get the fiscal number if the fm_loc_fiscal_number table is locked |
Valid Value | Default Value: 5 |
Variable | NFE_LOC_NAME_SOURCE |
Description | Indicates whether the location fiscal name will be retrieved from transfer entity. |
Valid Value | Y: Enable
N: Disable |
Variable | NF_MAX_ITEM |
Description | Maximum allowable line Items on NF during the issue |
Valid Value | Valid number |
Variable | DEFAULT_COMP_57_UTIL_ID |
Description | Default Utilization for cost complementary CTe |
Valid Value | Valid utilization code |
Variable | DEFAULT_COMP_COST_TAX_UTIL_ID |
Description | Default Utilization for complementary cost NF. |
Valid Value | Valid utilization code |
Variable | DEFAULT_COMP_COST_UTIL_ID |
Description | Default Utilization for complementary cost NF. |
Valid Value | Valid utilization code |
Variable | DEFAULT_COMP_FREIGHT_UTIL_ID |
Description | Default Utilization for complementary freight NF. |
Valid Value | Valid utilization code |
Variable | DEFAULT_COMP_TAX_UTIL_ID |
Description | Default Utilization for complementary tax NF. |
Valid Value | Valid utilization code |
Variable | DEFAULT_DISCREP_LEGAL_MESSAGE |
Description | Stores the default legal message in discrepancy resolution process. |
Valid Value | Default value: Valores ajustados em observância ao contrato |
Variable | DEFAULT_ORIGIN_CODE |
Description | Retrieve Origin Code from item foundation data in case user does not inform. |
Valid Value | Y: Enable
N: Disable |
Variable | DEFAULT_PO_TYPE |
Description | Default PO Type when null in ORMS (fiscal utilization code in ORFM) |
Valid Value | Valid utilization code |
Variable | DEFAULT_RURAL_PROD_DOC_TYPE |
Description | Default Document Type for Rural Producer |
Valid Value | Valid document type |
Variable | DEFAULT_RURAL_PROD_UTILIZATION |
Description | Default Utilization ID for Rural Producer NF |
Valid Value | Valid utilization code |
Variable | DEFAULT_TRIANGULATION_UTIL_ID |
Description | Default Utilization for triangulation NF. |
Valid Value | Valid utilization code |
Variable | DOC_TYPE_PO |
Description | Default fiscal doc type code |
Valid Value | 1 - Nota Fiscal - Modelo 1, 1A |
Variable | ENABLE_AUTO_UPDATE_ORIGIN_FCI |
Description | Enables auto update for Item-Location Origin and FCI. |
Valid Value | Y: Enable
N: Disable |
Variable | ENABLE_MANUFACTURE_UF_UPDATE |
Description | Indicates when manufacture UF at item/location is updated based of value in item/supplier after receiving PO NF |
Valid Value | Y: Enable
N: Disable |
Variable | COST_MATCH_FREIGHT |
Description | Indicates use of the Freight in the cost discrepancies analysis. |
Valid Value | Y: Enable
N: Disable |
Variable | COST_MATCH_INSURANCE |
Description | Indicates use of the Insurance in the cost discrepancies analysis. |
Valid Value | Y: Enable
N: Disable |
Variable | COST_MATCH_OTHER_EXPENSES |
Description | Indicates use of the Other Expenses in the cost discrepancies analysis. |
Valid Value | Y: Enable
N: Disable |
Variable | COST_RESOLUTION_RULE |
Description | Default Resolution Action for Cost Discrepancies |
Valid Value | RECONCILE: when user decides discrepancy resolution.
SYS: system will automatically resolve discrepancy by system. NF: system will automatically resolve discrepancy by NF |
Variable | QTY_RESOLUTION_RULE |
Description | Default Resolution Action for Quantity Discrepancies |
Valid Value | RECONCILE: when user decides discrepancy resolution.
SYS: system will automatically resolve discrepancy by system. NF: system will automatically resolve discrepancy by NF |
Variable | TAX_RESOLUTION_RULE |
Description | Default Resolution Action for Tax Discrepancies |
Valid Value | RECONCILE: when user decides discrepancy resolution.
SYS: system will automatically resolve discrepancy by system. NF: system will automatically resolve discrepancy by NF |
Variable | DEAL_DEF_CMPLX_TYPE |
Description | Default Document Type for complex deals. |
Valid Value | Valid document type |
Variable | DEAL_DEF_FXMRH_TYPE |
Description | Default Document Type for merchandise fixed deals. |
Valid Value | Valid document type |
Variable | DEAL_DEF_FXNMRH_TYPE |
Description | Default Document Type for non-merchandise fixed deals. |
Valid Value | Valid document type |
Variable | DEAL_DEFAULT_UTIL |
Description | Default Utilization ID for deals. |
Valid Value | Valid utilization code |
Variable | DEFAULT_DOCUMENT_TYPE |
Description | Default document type used by the process to create an EDI document based on external systems. |
Valid Value | Valid document type |
Variable | EDI_DEF_PTNR_ID |
Description | Indicates the default partner ID when importing EDI documents |
Valid Value | Valid partner ID |
Variable | EDI_DEF_PTNR_TYPE |
Description | Indicates the default partner type when importing EDI documents |
Valid Value | Valid partner type |
Variable | DEF_COMPL_CT_DI_TYPE |
Description | Default document type used by DI process to create an Complementary DI with Cost/Tax document |
Valid Value | Valid document type |
Variable | DEF_COMPL_NM_DI_TYPE |
Description | Default document type used by DI process to create an Complementary DI with Non Merchandise Additional Cost document |
Valid Value | Valid document type |
Variable | DEF_SFTW_COMPL_CT_DI_UTIL_ID |
Description | Default Utilization ID for SOFTWAY Complementary NF with Additional Cost/Tax. |
Valid Value | Valid utilization code |
Variable | DEF_SFTW_COMPL_NM_DI_UTIL_ID |
Description | Default Utilization ID for SOFTWAY Complementary NF with Non-Merchandise Addi-tional Cost. |
Valid Value | Valid utilization code |
Variable | DEFAULT_SOFTWAY_DI_UTIL_ID |
Description | Default Utilization ID for SOFTWAY DI NFs. |
Valid Value | Valid utilization code |
Variable | DI_AUTO_VALIDATION |
Description | Enable Auto Validation for Direct Import NF |
Valid Value | Y: Enable
N: Disable |
Variable | DI_NF_SERIAL_GENERATION_IND |
Description | Indicates whether the fiscal number and series number are generated in RFM or not. |
Valid Value | Y: Generated by RFM
N: Generated by third-party system |
Variable | DI_UNIT_COST_COMP |
Description | Indicates which trading system being used for Importation. |
Valid Value | S: Softway
T: Third-party system |
Variable | PRIORITY_TSF_IPI_IMPORTED |
Description | Indicates the priority of import or non-imported stock on first exit |
Valid Value | Y: Enable
N: Disable |
Variable | CALC_TOL_TYPE |
Description | The calculation tolerance type (P/V). |
Valid Value | P: PercentageV: Value |
Variable | CALC_TOL_VALUE |
Description | The calculation tolerance value. |
Valid Value | Number value |
Variable | AVERAGE_TAX_RATE_SOURCE_ENTITY |
Description | Name of the authorized institute that provides the average cumulative tax rates for op-erations to end consumers. |
Valid Value | Default value: IBPT |
Variable | DEFAULT_REF_MESSAGE_FDSHIP |
Description | Default legal message to inform the relation between the Shipment NF and the Sale NF in a future delivery scenario. |
Valid Value | Default value: Shipment NF related to the Sale NF number %s1 |
Variable | END_CONSUMER_MAX_VALUE |
Description | Default End Customer Max Value |
Valid Value | Number value |
Variable | DEFAULT_CANCEL_MESSAGE |
Description | Default Cancel Message for NF-e Cancellation |
Valid Value | Default value: NF cancelada pelo emitente |
Variable | DEFAULT_JUSTIF_NULLIFICATION |
Description | Default Justification for NF Nullification. |
Valid Value | Default value: Númeração Inutilizada pois não será mais utilizada |
Variable | ENABLE_ACCOUTING_REVERSAL |
Description | Indicates whether to revert accounting information for cancelled Nota Fiscal. |
Valid Value | Y: Enable
N: Disable |
Variable | FISCAL_CANCEL_ROLE |
Description | Role with privilege to NF-e cancel. |
Valid Value | Valid system role |
Variable | MANUAL_APPROVAL_PROTOCOL_MASK |
Description | Manual approval protocol mask. |
Valid Value | User defined mask |
Variable | MANUAL_CANCEL_ROLE |
Description | Role with privilege to NF-e manual cancel. |
Valid Value | Valid system role |
Variable | STOCK_REVERSAL_VIRTUAL_STORE |
Description | Holds the default virtual store that will be used in the inventory reversal process to put merchandise back to the WH. |
Valid Value | Valid virtual store |
Variable | SUGGESTION |
Description | Stores the justification when the Nota Fiscal is deleted by the Retailer |
Valid Value | Default value: NF cancelada devido a desistência da operação |
Variable | DEFAULT_DRSP_CO_PO_TYPE |
Description | Default PO Type for Drop Ship Customer Order when null in ORMS (fiscal utilization code in ORFM) |
Valid Value | Valid utilization code |
Variable | DEFAULT_FD_SALE_DOC_TYPE |
Description | Default Document Type for future delivery Customer Order SALE NF. |
Valid Value | Valid document type |
Variable | DEFAULT_FD_SALE_UTIL_ID |
Description | Default utilization ID for future delivery Customer Order SALE NF. |
Valid Value | Valid utilization code |
Variable | DEFAULT_FD_SHIP_DOC_TYPE |
Description | Default Document Type for future delivery Customer Order Shipment NF. |
Valid Value | Valid document type |
Variable | DEFAULT_FD_SHIP_UTIL_ID |
Description | Default utilization ID for future delivery Customer Order Shipment NF. |
Valid Value | Valid utilization code |
Variable | DEFAULT_OUTBOUND_CUST_UTIL_ID |
Description | Default Utilization ID for outbound customer order transfers. |
Valid Value | Valid utilization code |
Variable | DEFAULT_PRESENCE_IND_CO |
Description | Default presence indicator |
Valid Value | Valid presence indicator |
Variable | DEFAULT_PRESENCE_IND_NFCE |
Description | Default presence indicator for NFCE |
Valid Value | Valid presence indicator |
Variable | DEFAULT_PRESENCE_IND_NFE |
Description | Default presence indicator for NF-e |
Valid Value | Valid presence indicator |
Variable | DEFT_MULTISITE_CO_IN_IC_DOC |
Description | Default Document Type for Multisite Customer Order Inbound IC Transfers. |
Valid Value | Valid document type |
Variable | DEFT_MULTISITE_CO_IN_IC_UTIL |
Description | Default Utilization ID form Multisite Customer Order Inbound IC Transfer. |
Valid Value | Valid utilization code |
Variable | DEFT_MULTISITE_CO_IN_TSF_DOC |
Description | Default Document Type for Multisite Customer Order Inbound Transfer. |
Valid Value | Valid document type |
Variable | DEFT_MULTISITE_CO_IN_TSF_UTIL |
Description | Default Utilization ID for Multisite Customer Order Inbound Transfer. |
Valid Value | Valid utilization code |
Variable | DEFT_MULTISITE_CO_OUT_IC_DOC |
Description | Default Document Type for Multisite Customer Order Outbound IC Transfers. |
Valid Value | Valid document type |
Variable | DEFT_MULTISITE_CO_OUT_IC_UTIL |
Description | Default Utilization id for Multisite Customer Order Outbound IC Transfers. |
Valid Value | Valid utilization code |
Variable | DEFT_MULTISITE_CO_OUT_TSF_DOC |
Description | Default Document Type for Multisite Customer Order Outbound Transfer. |
Valid Value | Valid document type |
Variable | DEFT_MULTISITE_CO_OUT_TSF_UTIL |
Description | Default Utilization id for Multisite Customer Order Outbound Transfer. |
Valid Value | Valid utilization code |
Variable | DEFT_SALE_CO_DOC_TYPE |
Description | Default Doc Type for Outbound Customer Order (intrastate) when Addressee is NOT an End Consumer or an ICMS Contributor. |
Valid Value | Valid document type |
Variable | DEFT_SALE_CO_DOC_TYPE_INTRA |
Description | Default Doc Type for Outbound Customer Order (intrastate) when Addressee must be an End Consumer and must NOT be an ICMS Contributor. |
Valid Value | Valid document type |
Variable | DEFAULT_DNF_STOCK_DOC_TYPE |
Description | Default Document Type for DNF Inventory Adjustments. |
Valid Value | Valid document type |
Variable | DEFAULT_STOCK_DOC_TYPE |
Description | Default Document Type for Inventory Adjustments. |
Valid Value | Valid document type |
Variable | ENABLE_SIM_WS_INTEGRATION |
Description | Identify if when there is a NF cancellation RFM will call the SIM Inv Adj Web Service. |
Valid Value | Y: Enable
N: Disable |
Variable | FM_DEFAULT_REASON_CODE_NEG |
Description | Default Reason Code for Negatives Stock Count NF and Auto Approve Option |
Valid Value | Valid Reason Code |
Variable | FM_DEFAULT_REASON_CODE_POS |
Description | Default Reason Code for Positives Stock Count NF and Auto Approve Option |
Valid Value | Valid Reason Code |
Variable | REASON_ID_INVADJ_SIM_WS_INT |
Description | This variable holds the reason ID used for integration with RFM/SIM by WSDL for re-versing negative inventory adjustment. |
Valid Value | Valid Reason Code |
Variable | REASON_ID_INVADJ_SIM_WS_INT_IN |
Description | This variable holds the reason ID used for integration with RFM/SIM by WSDL for re-versing positive inventory adjustment. |
Valid Value | Valid Reason Code |
Variable | IRL_ALLOWS_MULTISITE |
Description | Indicates if IRL Monitor allows multisite treatment. |
Valid Value | Y: Enable
N: Disable |
Variable | IRL_ALLOWS_WORKSHEET |
Description | Indicates if WORKSHEET option will be available in NF forms that NFs came from IRL |
Valid Value | Y: Enable
N: Disable |
Variable | IRL_AUTO_REFUSAL |
Description | Indicates if IRL allows automatic refusal in Pre-validation. |
Valid Value | Y: Enable
N: Disable |
Variable | IRL_AUTO_REFUSAL_DESCRIPTION |
Description | Indicates the default reason description to Automatic Refusal. |
Valid Value | Valid reason description |
Variable | IRL_CNAE_VALIDATE |
Description | Validate the Suppliers CNAE from the XML against the system |
Valid Value | Y: Enable
N: Disable |
Variable | IRL_CODE_DEDUCTION |
Description | Indicates the priority of RMS transactional code deduction. |
Valid Value | EAN: deduction by EANVPN: deduction by VPN |
Variable | IRL_CTE_ISSUER_DEDUCTION |
Description | Indicates the entity type priority in the CTe Issuer deduction. |
Valid Value | SUPP: deduction by SupplierPTNR: deduction by Partner |
Variable | IRL_LOGICAL_DELETION |
Description | Indicates if IRL allows logical deletion. |
Valid Value | Y: Enable
N: Disable |
Variable | IRL_PACK_VALIDATION |
Description | Account for the new taxable EAN codes in IRL validation. |
Valid Value | COM
TRIB |
Variable | IRL_REASON_DESCRIPTION |
Description | Indicates if IRL Receipt Refusal requires reason description. |
Valid Value | Y: Enable
N: Disable |
Variable | IRL_SEFAZ_VALIDATION |
Description | Indicates if IRL SEFAZ validation is required. |
Valid Value | Y: Enable
N: Disable |
Variable | IRL_XML_ARCHIVE_PATH |
Description | Indicates the definitive path of archived XML's for database upload. |
Valid Value | Valid path |
Variable | IRL_XML_DATABASE_BKP |
Description | Indicates if IRL allows storing XML into database. |
Valid Value | Y: Enable
N: Disable |
Variable | FM_FRECLASS_ACTIVE_DATE |
Description | Define minimum of days of active date to item fiscal reclassification |
Valid Value | Valid number |
Variable | FM_FRECLASS_COPY_DOWN_CHILD |
Description | In item fiscal reclassification process, copy classification from item parent to child. |
Valid Value | Y: Enable
N: Disable |
Variable | FM_FRECLASS_ONLINE_IND |
Description | Define information that can be edit in screen. |
Valid Value | Y: Enable
N: Disable |
Variable | FM_FRECLASS_VDATE |
Description | Define date to be used in Reclassification batch to process records. |
Valid Value | N: VDATE
Y: VDATE + 1 |
Variable | DEFAULT_IN_RET_IC_DOC_TYPE |
Description | Default Inbound Document Type for Return Transfers Inter Company. |
Valid Value | Valid document type |
Variable | DEFAULT_IN_RET_TSF_DOC_TYPE |
Description | Default Inbound Document Type for Return Transfers. |
Valid Value | Valid document type |
Variable | DEFAULT_IN_RETURN_IC_UTIL_ID |
Description | Default Utilization ID for Return Transfers Inter-Company. |
Valid Value | Valid utilization code |
Variable | DEFAULT_IN_RETURN_TSF_UTIL_ID |
Description | Default Inbound Utilization ID for Return Transfers. |
Valid Value | Valid utilization code |
Variable | DEFAULT_INBOUND_IC_DOC_TYPE |
Description | Default Document Type for Inbound IC Transfers. |
Valid Value | Valid document type |
Variable | DEFAULT_INBOUND_IC_UTIL_ID |
Description | Default Utilization ID for Inbound IC Transfers. |
Valid Value | Valid utilization code |
Variable | DEFAULT_INBOUND_REP_DOC_TYPE |
Description | Default Document Type for Inbound Repairing Transfers. |
Valid Value | Valid document type |
Variable | DEFAULT_INBOUND_REP_UTIL_ID |
Description | Default Utilization ID for Inbound Repairing Transfers. |
Valid Value | Valid utilization code |
Variable | DEFAULT_INBOUND_TSF_DOC_TYPE |
Description | Default Document Type for Inbound Transfers. |
Valid Value | Valid document type |
Variable | DEFAULT_INBOUND_TSF_UTIL_ID |
Description | Default Utilization ID for Inbound Transfers. |
Valid Value | Valid utilization code |
Variable | DEFAULT_OUT_RET_IC_DOC_TYPE |
Description | Default Outbound Document Type for Return Transfers Inter Company. |
Valid Value | Valid document type |
Variable | DEFAULT_OUT_RET_TSF_DOC_TYPE |
Description | Default Outbound Document Type for Return Transfers. |
Valid Value | Valid document type |
Variable | DEFAULT_OUT_RETURN_IC_UTIL_ID |
Description | Default Outbound Utilization ID for Return Transfers Inter-Company. |
Valid Value | Valid utilization code |
Variable | DEFAULT_OUT_RETURN_TSF_UTIL_ID |
Description | Default Outbound Utilization ID for Return Transfers. |
Valid Value | Valid utilization code |
Variable | DEFAULT_OUTBOUND_IC_DOC_TYPE |
Description | Default Document Type for Outbound IC Transfers. |
Valid Value | Valid document type |
Variable | DEFAULT_OUTBOUND_IC_UTIL_ID |
Description | Default Utilization ID for Outbound IC Transfers. |
Valid Value | Valid utilization code |
Variable | DEFAULT_OUTBOUND_REP_DOC_TYPE |
Description | Default Document Type for Outbound Repairing Transfers. |
Valid Value | Valid document type |
Variable | DEFAULT_OUTBOUND_REP_UTIL_ID |
Description | Default Utilization ID for Outbound Repairing Transfers. |
Valid Value | Valid utilization code |
Variable | DEFAULT_OUTBOUND_TSF_DOC_TYPE |
Description | Default Document Type for Outbound Transfers. |
Valid Value | Valid document type |
Variable | DEFAULT_OUTBOUND_TSF_UTIL_ID |
Description | Default Utilization ID for Outbound Transfers. |
Valid Value | Valid utilization code |
Variable | INCL_DISC_EXP |
Description | Indicates whether inclusion or exclusion of expenses and discounts in the last purchase price for Transfer NF |
Valid Value | Y: Inclusion
N: Exclusion |
Variable | REF_NF_MANDATORY_FREIGHT |
Description | Indicates if it is mandatory to inform the reference NF for Complementary NF Freight. |
Valid Value | Y: Enable
N: Disable |
Variable | DEFAULT_RMA_DOC_TYPE |
Description | Default Document Type for RMA |
Valid Value | Valid document type |
Variable | DEFAULT_RMA_UTIL_ID |
Description | Default Utilization ID for RMA |
Valid Value | Valid utilization code |
Variable | BALANCE_CONTROL_RTV |
Description | Indicates whether the balance control fo RTV is hold or not. |
Valid Value | Y: Enable
N: Disable |
Variable | DEFAULT_REASN_FOR_RTRN |
Description | Default Reason for a Return Document. |
Valid Value | Valid reason code |
Variable | DEFAULT_REF_MESSAGE |
Description | Default Message for Referenced NF. |
Valid Value | This NF number %s1 is referenced to the original NF %s2 issued on %s3 respectively. |
Variable | DEFAULT_REF_MESSAGE_RTV |
Description | Default Message for Referenced Return to Vendor NF. |
Valid Value | Devolution ref. the NF n½ %s1, issued on %s2, Value of R$ %s3 |
Variable | DEFAULT_REF_MESSAGE_RTV_ST |
Description | Default legal message for ST Return NF |
Valid Value | Nota Fiscal number %s1 meant for restitution of tax collected as substitution referenced to the original NF %s2 issued on %s3 |
Variable | DEFAULT_RNF_DOC_TYPE |
Description | Default Document Type for RNFs. |
Valid Value | Valid document type |
Variable | DEFAULT_RNF_DOC_TYPE_TRIANG |
Description | Default Document Type for Triangular RNFs. |
Valid Value | Valid document type |
Variable | DEFAULT_RNF_ST_NF_DOC_TYPE |
Description | Default Document Type for Return (RNF) ST NF. |
Valid Value | Valid document type |
Variable | DEFAULT_RNF_ST_NF_DOC_TYPE_TRI |
Description | Default Document Type for Return (RNF) ST NF for triangulation. |
Valid Value | Valid document type |
Variable | DEFAULT_RNF_ST_NF_UTIL_ID |
Description | Default Utilization ID for Return (RNF) ST NF. |
Valid Value | Valid utilization code |
Variable | DEFAULT_RNF_ST_NF_UTIL_ID_TRIA |
Description | Default Utilization ID for Return (RNF) ST NF for triangulation. |
Valid Value | Valid utilization code |
Variable | DEFAULT_RNF_UTIL_TRIANG_CNTF |
Description | Default Utilization ID for Triangular Return NF CNTF |
Valid Value | Valid utilization code |
Variable | DEFAULT_RNF_UTIL_TRIANG_ID |
Description | Default Utilization ID for Triangular Return NF |
Valid Value | Valid utilization code |
Variable | DEFAULT_RNF_UTILIZATION_ID |
Description | Default Utilization ID for Return NF |
Valid Value | Valid utilization code |
Variable | DEFAULT_RTV_DOC_TYPE |
Description | Default Document Type for RTVs. |
Valid Value | Valid document type |
Variable | DEFAULT_RTV_DOC_TYPE_TRIANG |
Description | Default Document Type for Triangulation RTVs. |
Valid Value | Valid document type |
Variable | DEFAULT_RTV_ST_NF_DOC_TYPE |
Description | Default Document Type ID for Return (RTV) ST NF. |
Valid Value | Valid document type |
Variable | DEFAULT_RTV_ST_NF_DOC_TYPE_TRI |
Description | Default Document Type ID for Return (RTV) ST NF for triangulation. |
Valid Value | Valid document type |
Variable | DEFAULT_RTV_ST_NF_UTIL_ID |
Description | Default Utilization ID for Return (RTV) ST NF. |
Valid Value | Valid utilization code |
Variable | DEFAULT_RTV_ST_NF_UTIL_ID_TRIA |
Description | Default Utilization ID for Return (RTV) ST NF for triangulation. |
Valid Value | Valid utilization code |
Variable | DEFAULT_RTV_UTIL_ID |
Description | Default Utilization ID for RTVs. |
Valid Value | Valid utilization code |
Variable | DEFAULT_RTV_UTIL_TRIANG_CNTF |
Description | RTV to Supplier Delivery related to Triangular PO CNTF |
Valid Value | Valid utilization code |
Variable | DEFAULT_RTV_UTIL_TRIANG_ID |
Description | Default Utilization ID for outbound RTV NF for the Supplier Delivery in a triangular operation purchase. |
Valid Value | Valid utilization code |
Variable | DEFAULT_ST_NF_DOC_TYPE |
Description | Default Document Type for Return ST NF. |
Valid Value | Valid document type |
Variable | DEFAULT_ST_NF_UTIL_ID |
Description | Default Utilization ID for Return ST NF. |
Valid Value | Valid utilization code |
Variable | REF_NF_MANDATORY_RTV |
Description | Indicates if it is mandatory to inform the reference NF for RTV NF issues. |
Valid Value | Y: Enable
N: Disable |
Variable | REFERENCE_RTV_RNF_RPO |
Description | Determine the reference NF to issue a RTV or RNF. |
Valid Value | Y: the reference is the NF RPON: the reference is the NF PO |
Variable | FM_FRECLASS_PURGE |
Description | Purge item fiscal reclassification. |
Valid Value | Valid number |
Variable | HISTORY_DAYS_GTAX_ITEM_ROLLUP |
Description | Number of days in the past that will be used for purge to TAX_ITEM_ROLLUP_HIST |
Valid Value | Valid number |
Variable | HISTORY_DAYS_HIST_TABLES |
Description | Indicates the number of days the history table can hold the records |
Valid Value | Valid number |
Variable | HISTORY_DAYS_POS_MODS_TAX_INFO |
Description | Number of days in the past that will be used for purge to POS_MODS_TAX_INFO_HIST |
Valid Value | Valid number |
Variable | HISTORY_DAYS_PROCESSED_EDI |
Description | Indicates the number of days the EDI NFs can exist in the EDI tables before getting purged. |
Valid Value | Valid number |
Variable | IRL_PURGE_DAYS |
Description | Indicates the number of days for purge the IRL tables. |
Valid Value | Valid number |
To set up the System Options, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then select System Setup.
In the Contents Of System Setup window, select System Options.
In the Contents Of System Options window, click Edit. The System Options window opens.
Click the Variable field LOV to view the description and variables.
Click Add. A new row is displayed.
Note: Adding parameters will not have any impact on the system functionality. |
Enter the details in the Variable and Description fields.
Select the Type from the list.
Enter the details in the Value field.
Click OK to exit the window.
Tolerance is the variance allowed between values in NF compared with the requisition document. If the NF is within tolerances, then the NF can be considered matched (without discrepancy). Tolerance can be managed by:
Supplier: a tolerance value is defined to a specific supplier
Company: a tolerance value is defined to a specific company
System: a tolerance value is defined to all ORFM receiving NFs
Item/Merchandise Structure: a tolerance value is defined by specific item or merchandise structure level.
ORFM supports the following three types of tolerances:
Cost Tolerance: Use it when comparing the unit cost of the item on the PO as against the unit cost of the item on the NF.
Quantity Tolerance: Use it when matching the quantity ordered, against the quantity provided in NF for each item.
Calculation Tolerance: Use it to avoid the NFs from going into discrepancies due to rounding or truncation issues.
Note: The cost, and quantity tolerances can be set in the Tolerance Maintenance screen in ORFM, and calculation can be set as a system variable. |
To set up the tolerances, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then select System Setup.
In the Contents Of System Setup window, select Tolerances.
In the Contents Of Tolerances window, click Edit. The Tolerances window opens.
In the Tolerances window, the list in the Level field has two values – Supplier and Company. Select the level applicable.
The Name field displays the list of all the Supplier names or Company names based on the level selected. Select the supplier or the company name.
Click Search. The existing tolerances for the supplier or company is displayed in the multi-record block. If there are no tolerances for the selected level, the following message is displayed: "Query caused no records to be retrieved".
If there are tolerances for the selected values, the following parameters are displayed in the multi-record block:
Tolerance Level – Choose from Line Quantity or Line Cost.
Lower Limit Inclusive – The lower limit for the range. This value is included in the range.
Upper Limit Exclusive – The upper limit for the range. This value is excluded from the range.
Tolerance Type – Select the Requisition Document Tolerance Type from the list. The list includes Percentage or Value.
Tolerance Value – Enter the tolerance value for matching between the NF and the requisition document of the NF.
Click OK to save the changes.
The other options available on the window includes:
Click Add to add a new row in the multi-record block.
Click Delete to delete the selected row from the multi-record block.
Click Refresh to clear the filter criteria, and the data in the multi-record block.
Click Cancel to not save the entered changes.
Note: Select View mode in the Contents Of Tolerances window to view the tolerances. The Add and Delete button in the Tolerances window are disabled. |
In the Contents Of System Setup window, select Tolerances.
In the Contents Of Tolerances window, click Edit. The Tolerances window opens.
In the Tolerances window, click in OPTIONS and Tolerance Exception by Item. Tolerance Exception by Item Setup window opens.
In the Tolerance by Item Setup, the list in the Level field has these values: Item, Class, Subclass, Department and Group. Depending of selection, the next field is used to filter the selection.
5 Depending of level configured, user can define tolerance by Value or Percentage in the field "Tolerance Type" and the value in the field "Tolerance Value".
6 Click OK to save the changes
The other options available on the window includes:
Click OK to save records and close the window.
Click Add to add a new row in the multi-record block.
Click Refresh to clear the filter criteria, and the data in the multi-record block.
Click Delete to delete the selected row from the multi-record block.
Click Cancel to not save the changes that it is entered.
Tolerance setup valid all NF receiving in any company in the system can be defined by ORFM System Options CALC_TOL_TYPE and CALC_TOL_VALUE.
More information about these ORFM System Options, see chapter ORFM System options in this document.
Location Fiscal Numbers are numbers assigned to a store/warehouse. In Brazil, the sequence of NF document numbers is controlled and should be correctly followed during the NF issuing process.
Each location controls its own sequence based on the following fields:
Documentation Type
Serial/Sub-serial
Sequence
Effective Date
Any transaction that involves that particular store/warehouse should contain the fiscal numbers falling within a particular range.
To add fiscal numbers, do the following:
Navigate: From the RMS Start Menu, select Fiscal Management, then System Setup. From System Setup, select Fiscal Numbers.
In the Contents Of Fiscal Numbers window, click Edit. The Location Fiscal Numbers window opens.
To add a number, select the store/warehouse from the Location LOV. Click Add. In the multi-record block, a row is highlighted as shown.
Assign values to Location, Document Type, Series Number, Subseries Number, Minimum Fiscal Number, Maximum Fiscal Number, and Effective Date.
Select the row to delete in the Location Fiscal Numbers window.
Click Delete. The following message appears:
Click Yes to delete the row.
In the Contents Of Fiscal Numbers window, click View. The Location Fiscal Numbers window opens.
In the View mode, the Add, and the Delete button are disabled. By default, the Location Fiscal Numbers displays the locations, and their fiscal numbers.
Select the location type from the Location Type list. The Location field is highlighted after selecting the location type.
Select the location from the Location LOV.
Click the filter icon. Based on the filter criteria, the multi-record block displays the Location Type, the Location, and the values associated with the Document Type, Series Number, Subseries Number, Minimum Fiscal Number, Maximum Fiscal Number, and Effective Date.