Author: Divya Unnikrishnan

Accounting Period close and Quick close feature

Permissions related to Accounting Period management Prior to accessing accounting period management, relevant permissions need to be assigned to the Roles.   Edit or Full level of the Manage Accounting Periods permission is required to set up, edit, lock transactions for the period close, or reopen accounting periods. Users with the View level of this permission can see the Manage Accounting Periods page… Continue reading Accounting Period close and Quick close feature

Reversing balance on vendor prepayment account on receipt of refund in case of unapplied and partially applied transactions

Scenario: When a vendor prepayment deposit has been made but part or whole of the amount is unapplied on the invoice and will be refunded by the vendor, the balance in the Vendor Prepayment account needs to be reversed and the GL trail must be precise. Currently, Vendor prepayment can only be applied to open… Continue reading Reversing balance on vendor prepayment account on receipt of refund in case of unapplied and partially applied transactions

Currency conversion in Workbook

When the currency column in the Workbook consists of multiple currencies, we may need to convert it to a single currency to maintain comparison and consolidation accuracy. We can use the currency conversion option directly in the workbook for the same. Note: This option is only available for amount columns in Workbook. It will not… Continue reading Currency conversion in Workbook

Application of Bill to Vendor Prepayment transaction to nullify open balance

Scenario: A Purchase Order was created and a vendor prepayment transaction was made. Later, the vendor prepayment was no longer valid as neither the Item receipt nor the refund was possible. The period is closed and the purchase order is in closed status. The vendor prepayment transaction is in paid status. It can’t be voided… Continue reading Application of Bill to Vendor Prepayment transaction to nullify open balance

FAM-specific Permissions for User Roles

Under the Permissions tab of User Role, we may provide the following permissions depending on the Role’s responsibilities:  Transaction Subtab:  Fixed Asset Depreciation Entry  Fixed Asset Disposal Entry  Fixed Asset Revaluation Entry  Fixed Asset Transfer Entry  Lists Subtab:  Fixed Assets Register  Custom Record subtab:  FAM Alternate Depreciation   FAM Alternate Methods   FAM Asset   FAM Asset Proposal  … Continue reading FAM-specific Permissions for User Roles

Display Main line criteria, Body-level location, and Line-level location in transaction saved search using Formula

Scenario: To display main line criteria, body-level location, and line-level location in the transaction search result, we may use the following formulas Mainline condition formula : Formula(text) – Case When {mainline}=’*’ then ‘True’ else ‘False’ end Body level location: Formula(text) – CASE WHEN (Case When {mainline}=’*’ then ‘True’ else ‘False’ end) = ‘True’ THEN {location}… Continue reading Display Main line criteria, Body-level location, and Line-level location in transaction saved search using Formula

Item rate behavior in Saved Search with respect to multiple units of measure in transactions

In a Saved Search, the default Item rate field will display results in the base unit rather than in the transaction unit. For instance, in a Sales Order where the rate is 200 per KIT and the conversion rate for KIT is 20 UNITS, the default Item rate in search will display 10. The Item… Continue reading Item rate behavior in Saved Search with respect to multiple units of measure in transactions