NetSuite has a Paired Intercompany Transaction field that will help link the respective intercompany invoices and vendor bills together. This function is very similar to the Manage Intercompany Sales Order function, which links the intercompany purchase order to the sales order. If you create standalone intercompany invoices and vendor bills, this is a best practice… Continue reading How to link a stand alone intercompany invoice to Bill
Author: Chinchu Sadanandan
Balance difference in bank accounts in NetSuite and actual bank balance due to currency exchange rate fluctuation
Client came with the requirement to balance the amount in particular bank a/c in a subsidiary which showed different amount than the actual bank balance in balance sheet due to the exchange rate variation. Solution: Go to Transaction> Financial > Revalue Open Currency Balance(admin role) Select the period and the subsidiary in which the account… Continue reading Balance difference in bank accounts in NetSuite and actual bank balance due to currency exchange rate fluctuation
Merging of accounts
We can merge one account into another if they are the same account type and the account we want to merge has no attached subaccounts. You can combine an account with a parent account or with a subaccount. To merge accounts: Go to Setup > Accounting > Manage G/L > Chart of Accounts (Administrator) Click… Continue reading Merging of accounts
Intercompany clearing account shows balance.
In this particular scenario the client wants to transfer amount between the subsidiaries(same currency and different currency) When these entries passed, intercompany clearing a/c showed balance. Solution: In the intercompany clearing a/c record, change the general rate to historical and put check mark for revalue open period option.After running the period close task the balance… Continue reading Intercompany clearing account shows balance.
Intercompany vendor not listed in Advanced JE line level
When an intercompany JE-advance created, Intercompany vendor is not listed solution: The currency in the advance JE should be added to the intercompany vendor currency list. Then only it will list as vendor name in the drop down at line level of JE
SKUs-How to list Item groups with its components.
item groups with sku
Vendor statement
vendor_statement_customization
Customer statement
We can send statements to remind customers to pay their invoices. Customer statement can be generated for multiple customers and as individual statements. By NetSuite standard, it will be in PDF or HTML formats. To print the customer statements for multiple customers: Go to Transactions > Customers > Generate Statements(admin) and select all the customers… Continue reading Customer statement
Free gift item is not added to the Sales order
There are some instances when the free gift is not added to the Sales order 1.A free gift cannot be added to an order automatically if mandatory information regarding the free gift is missing. For example, a free gift promotion offers a warranty that requires a value to be entered in the Amount column in… Continue reading Free gift item is not added to the Sales order
Suite promotion for adding free gift item to sales order only for first time order customers
1.Create a saved search to target the customers to whom we are providing Free gift item. 2.Create a dynamic customer group using the above said saved search 3.Add a base price in the free gift item record or custom price in line level of Sales order. 4.Create promotion by adding the free gift item and… Continue reading Suite promotion for adding free gift item to sales order only for first time order customers