Month: February 2022
SKUs-How to list Item groups with its components.
item groups with sku
Intercompany Inventory transfer process
There should be a Destination Subsidiary and Source Subsidiary in this process. Destination subsidiary is the one which buys inventory from other subsidiary. Source subsidiary is the one which sells inventory to other subsidiary. Destination subsidiary should create an purchase order and generate a vendor bill for this transaction. Source subsidiary should create an sales… Continue reading Intercompany Inventory transfer process
Overriding Third party module in magneto 2
If we want to override a 3rd party module other than magento’s default. We need to create a di.xml with the same folder layout in the code folder. Try out the code in the di.xml And in the php file just map the location as per the code folder structure Here, [Vendor] and [Module] is… Continue reading Overriding Third party module in magneto 2
Unable to Sort Saved Search by Formula Field
Unable to Sort Saved Search by Formula Field
Tax Agency Vendor Category
In NetSuite, you can set up sales tax items and sales tax vendors to simplify the sales tax collection and payment process. To create a Tax Agency vendor record select the vendor category as ‘Tax agency. It is not possible to add multiple subsidiaries for tax agency vendors. Because tax agency vendors cannot be shared… Continue reading Tax Agency Vendor Category
Set Multiple Item Names as a criteria filter in an Item Saved Search
Set Multiple Item Names as a criteria filter in an Item Saved Search Navigate to Reports> Saved Searches> All Saved Searches> New 2. Select Item as Search Type 3. Assign a name on the Search Title field 4. On the Criteria tab > Standard sub tab> Filter column, add the following: a. Formula (Numeric) is equal to 1 then b. Formula = Case when {name}=’XXXX’ OR {name}=’XXXX’ then 1 else 0 end… Continue reading Set Multiple Item Names as a criteria filter in an Item Saved Search
Image convert to Base64
PIVOT TABLE IN EXCEL
A Pivot Table is an interactive way to quickly summarize large amounts of data. You can use a Pivot Table to analyse numerical data in detail, and answer unanticipated questions about your data. Moving rows to columns or columns to rows ( or “pivoting”) to see different summaries of the source data. HOW TO CREATE… Continue reading PIVOT TABLE IN EXCEL
How to work the formula even if some columns are blank in Saved Search
We can execute the formula even if some columns are blank in Saved Search using the following:-Navigate to1. Lists > Search > Saved Search > New 2. Select the Type of the search3. On the Results tab , Column Subtab;Field – Formula Numeric Formula : NVL({location on order},04. Save and Run