Proposal for Implementing P2P Workflows

Requirement EVersum has expressed their desire to establish an approval process that efficiently manages the purchase invoice, proforma invoice, and payment approval process. The process aims to provide a streamlined and efficient approach for managing the approval process while ensuring appropriate financial control and oversight. Each step needs to be done only by authorized users,… Continue reading Proposal for Implementing P2P Workflows

CSV Import-To update the Class field value on Expense Line under Vendor Bills

Scenario Create multiple file CSV Import to update the Class field value on Expense Line under Vendor Bills Solution Create a CSV Import file: Primary File Internal ID Expense File Internal ID Line ID Class Expense Category Navigate to Setup > Import/Export > Import CSV Records Import Type = Transactions Record Type = Vendor Bill/Supplier Bill Select Multiple files to upload Primary File – Vendor… Continue reading CSV Import-To update the Class field value on Expense Line under Vendor Bills

Exchange Rate Fluctuations on Advanced payment applied Vendor Bills

The difference in exchange rate may cause difference in amount in vendor prepayment and vendor bill. Suppose if the vendor has multiple currencies and the price of the Item is $2500. On creating the PO, the exchange rate was 3.75. But when applying a vendor prepayment having exchange rate 3.73, the amount difference is around… Continue reading Exchange Rate Fluctuations on Advanced payment applied Vendor Bills

PART 3.2 – Vendor/Purchase Transaction GL Impact

Purchase orders are non-posting transactions that are sent to a vendor to keep track of items that are expected to be delivered. They include the associated price and quantity.  2. Item receipts are used to match against an open purchase order when items have been received. The GL impact will show an increase in the asset account… Continue reading PART 3.2 – Vendor/Purchase Transaction GL Impact

Bulk Vendor Bill Approval

Go to Transactions > Payables > Approve Bills. Select a vendor to filter the list of bills. Select a date range to filter the list of bills that show. The date range you select is reflected in the From and To fields. If you enter a different range in the From and To fields, the Date field automatically shows Custom. Check the box in the Approve column next… Continue reading Bulk Vendor Bill Approval

Calculate TDS Automatically on Vendor Bill

Requirement: Calculate the amount on the vendor bill automatically based on the TDS % on the vendor record. Solution: A new field will be created to store the India Tax Section Code on vendor records. Also will create a new transaction line checkbox field “Tax Code Update” on a bill to record whether a different… Continue reading Calculate TDS Automatically on Vendor Bill

Disabling the standard functionality for billing the purchase orders before you receive them

We can disable the standard functionality for billing the purchase orders before you receive them.For accomplishing this we have to uncheck a feature.Go to, Setup>Accounting>Accounting PreferencesUnder Order Management, Receiving>Uncheck Bill in advance of receipt After disable this feature NetSuite itself won’t allow as to bill purchase orders before receiving them.