Month: March 2022

Amazon Vendor Central SFTP Connection Making

EDI Integration of Amazon Vendor Central can be made using SFTP Connection. For connecting with SFTP server. Need to create a connection from the connection dashboard. It can be a production or test connection. Select SFTP connection from the pop box come after this. Need to create 2 public keys, for receiving and sending. Need… Continue reading Amazon Vendor Central SFTP Connection Making

Delete All Hidden Rows or Columns in Excel

If you want to delete all hidden rows or columns in Excel, just do the following steps: 1. click File tab, and select Info menu from the popup menu list. 2. click Check for Issues button in the Info page. And select Inspect Document from the drop-down list. The Document Inspector dialog box will appear. 3. click Inspect button in the Document Inspector window. 4. click Remove All button in the Hidden Rows and Columns section.

SMT AREAS

SMT Means SITE MANAGEMENT TOOLS SMT having mainly 3 areas All Pages Areas Page Type Areas This Page Areas The sample codes used for illustrating these areas are listed below 1.All Pages Areas 2.Page Type Areas 3. This Pages Areas Notes Create a new folder and download the theme tool zip[Documents -> Files -> File… Continue reading SMT AREAS

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

Special Purchase Order and Sales Order is not allocated to each other

In a setup where Supply Allocation is enabled, Special Purchase Order and Sales Order is not allocated to each other.  This usually happens if the location on the orders does not match, the Allocation Strategy used does not consider future inventory for allocation, a special purchase order is closed or the expected receipt date is… Continue reading Special Purchase Order and Sales Order is not allocated to each other

Inventory Worksheet Import Limitations

Each import can create one new inventory worksheet. We cannot use the inventory worksheet import to update an existing NetSuite inventory worksheet or to create multiple inventory worksheets at one time.  Each inventory worksheet import can import data for one combination of class, department, location, and, if applicable, subsidiary values. You must do multiple import… Continue reading Inventory Worksheet Import Limitations

Receive button is not available on the Customer Return Authorization

Using a Custom Role, the Receive button is not available on a Customer Return Authorization record.  Check the Custom Role   Navigate to Setup > Users/Roles > Manage Roles  Click ‘Edit‘ beside the Custom Role.   On Permissions tab > Transactions sub-tab, ensure that the following permissions are present:   Receive Returns = Full  Return Authorization = Full   If users have full access to those transaction permissions… Continue reading Receive button is not available on the Customer Return Authorization