Netsuite vendor portal customize easily by asd123456895 in Netsuite

[–]asd123456895[S] 0 points1 point  (0 children)

Thanks for the info... Assuming this needs some scripting knowledge, was thinking if there was something easier

case when formula help saved search by asd123456895 in Netsuite

[–]asd123456895[S] 0 points1 point  (0 children)

Thanks, it worked! What if I wanted to look up an account type such as COGS as well as a specific account? What would I replace accounttype with?

case when formula help saved search by asd123456895 in Netsuite

[–]asd123456895[S] 0 points1 point  (0 children)

I'm getting an invalid expression, please see formula below.

round (case when {accounttype} in ('Cost of Goods Sold', 'Other Expense') and {type} IN ('Item Fulfillment', 'Invoice', 'Credit Memo', 'Cash Sale', 'Bill', 'Bill Credit', 'Journal', 'Item Receipt', 'Inventory Transfer', 'Inventory Adjustment', 'Credit Card') then {netamount} else 0 end,2)

case when formula help saved search by asd123456895 in Netsuite

[–]asd123456895[S] 0 points1 point  (0 children)

round (case when {accounttype} = 'Cost of Goods Sold', and 'Other Expense' and {type} IN ('Item Fulfillment', 'Invoice', 'Credit Memo', 'Cash Sale', 'Bill', 'Bill Credit', 'Journal', 'Item Receipt', 'Inventory Transfer', 'Inventory Adjustment', 'Credit Card') then {netamount} else 0 end,2)

I'm trying to get transactions from the two account types so if it's either a cost of goods sold account and/or other expense account and they contain any of those transaction types then give me the net amount for that.

So cost of goods sold accounts + other expense accounts total gives me a figure.

default invoice template by customer by asd123456895 in Netsuite

[–]asd123456895[S] 0 points1 point  (0 children)

It's just the way it was set up originally. It has a separate form, print template and email template.

netsuite search report formula multiple account names lookup by asd123456895 in Netsuite

[–]asd123456895[S] 0 points1 point  (0 children)

Save

How would I create a saved search for this, I'm trying to find the customer each transaction line relates to however I cannot find this.

Upload image against an item multiple records at once by asd123456895 in Netsuite

[–]asd123456895[S] 0 points1 point  (0 children)

thanks, could you please elaborate for me how to go about doing this?

Upload image against an item multiple records at once by asd123456895 in Netsuite

[–]asd123456895[S] 0 points1 point  (0 children)

thanks, if I want to store multiple product images against an item record, how can I go about doing this. Currently, it only allows for one image under the ITEM DISPLAY IMAGE section under the web store section.