Hi @"Hozysam" Upon checking, there is no standard report that shows the Gross Margin Return on investment. The reason for this is because these fields can be sourced on two types of reports: Sales and Inventory. As of the moment, the ability to combine these two in one report is still an enhancement: 105405 Reports >…

Hi @"4156217", Based on my understanding, you would like to compare the On Hand/Available for your items with that of the Quantity Sold over a period of time. Mayhap it will be applicable in your end to use the Sales by Item report. This report aims to show the Sales activity by item over a certain period of time: You…

Hi @"Advanced Business Solutions Corporation 3477471" With regards to the prevention of negative inventory, you may opt to see the following as lifted from our documentation: 28074: Understanding and Avoiding Underwater Inventory. These are best practices in order to prevent negative inventory ○ Always use sales orders to…

Hi @"4224806", Based on my understanding, you would like your other charge to be based on KG instead of the default hourly rate. I am assuming that you are using Manufacturing Routing am I correct? Upon checking, for Manufacturing routing, the Manufacturing Charge Item's rate is defaulted as per hour. This is because the…

No problem @"Renato Gabas"! Glad to be of help Regards, @"Herdi Rana-Oracle"

Hi @"Renato Gabas", Just to verify, this is a Customized Current Inventory Snapshot am I correct? Wherein the added Available column shows the total available and not per location is that correct? Kindly check the added column: * Open the report, then click on Return to Customization * In the Add field section kindly…

Hi @"KristinAvril", Nullif function returns a null value if the two arguments are equal, otherwise, it returns the first argument. The common error for this would be the zero divisor error, in which it would be thrown if one of the field is null: let us say that your Custom Width is 5 but the depth is null, then it will be…

Hi @"4224806", This is to acknowledge our receipt of your question. Allow us to conduct some testing in our end and we will update this thread once we finished our testing. Thank you very much! Regards, @"Herdi Rana-Oracle"

Hi @"Advanced Business Solutions Corporation 3477471", Just to reiterate my understanding to your concern, you would like to confirm if Matrix feature needs to be enabled for the SuiteApp Enhanced Validations and Defaulting > Negative Inventory to work. Based on my research, I have found cases wherein this specific error…

Hi @"Ivar_42618", As of the moment, the ability to create customer/vendor specific item descriptions is not yet an available feature and was still logged as an enhancement. Fortunately, I have found an enhancement request already filed for this: 120006 Items>Track per-customer sales descriptions. Feel free to cast your…

No worries, glad to be of help Regards, @"Herdi Rana-Oracle"

Hi @"Ivar_42618", This is to acknowledge our receipt of your question. Basically, you would like to know if it is possible to create multiple sales description per customer for one item. Allow me to conduct a testing on my end and I will update this thread on my findings. Thank you very much! Regards, Herdi Rana-Oracle Ask…

HI @"Advanced Business Solutions Corporation 3477471", This is to acknowledge our receipt of your question. Basically, you would like to verify if the Enhanced Validations and Defaultings SuiteApp's pre-requisite is to enable the Matrix feature. Allow me to conduct a testing on my end and I will update this thread on my…

Hi @"Patrick_Astris", Based on your query, you just enabled the Cross Subsidiary Fulfillment feature in your end, wherein you noted that saved searches with Sales Order does not capture specific data. Can you provide a sample Saved Search by sending the following: * Screenshot of the Criteria and Results tab * Results page…

Hi @"MSStoke", In addition to this, you may want to try including the the item saved search a criteria: Formula (Numeric):case when {name}= LOWER{name} then 1 else 0 end This would pull out all SKUs with lower case. Thank you @"Herdi Rana-Oracle"

Hi @"MSStoke", Can you clarify what you meant by tracking packages? Am I correct on my understanding that you would like to enter package information (e.g. Carton numbers) prior to Item Fulfillment stage? If what you want is to have a record/report of the packages you used in the past, then you may try this saved search:…

Hi @"Martha Hakes", Based on my understanding, you would like to base the formula on (On Hand + On Order - Qty on Sales Orders) / Product Sold am I correct? Upon checking, the existing formula is based on the On Hand, wherein the commitments from the Sales Order is still included. If you would like these formulas to be net…

Thanks for the clarification @"paul.baudouin", Basically, based on my understanding, your end goal here is to disassociate the Sales Order from the Wave am I correct. This is to make the Sales Order available again to release a new Wave is that right? May I know if your query involves the multiple sales order in one wave,…

Hi Karl Crawford, Upon checking, this is maybe related to Enhancement 252217 Manufacturing > Work Order Completion > Please expose Operation, Quantity and run time fields to transaction searches and/or reports. This specific enhancement pertains to the limitation of the results/fields available to saved searches pertaining…

Hi @"Austin.McMinn" Based on my understanding, you have an item wherein it is being held in you warehouse but this belongs to the customer, hence you would not want this to reflect in the books am I correct? May I verify my understanding as to your current business process: Customer would place an order to your company,…

Actually, the decimal place for the deducting inventory adjustment is with regards to the completion of the cost of sales recalculation. Usually this is being triggered by backdated, edited, deleted existing transactions. After the recalculation, the system would be able to post on the correct unit value for the items.…

Hi @"Msid", This is just on top of my head, but for the Item Receipt, can you try to use the Name (Internal) for both the Criteria and Results? I think this is being driven by the multiple vendors in the item record, hence using the Name (Internal) would enable the saved search to pull out the Item Name in the main level…

Hi @"4209550", Based on my understanding, you have an item wherein it is being sold and being given out as a promotional item am I correct? Note that the GL impact of a sales transaction is determined by the item record. From what I understand, you would like to have an expense account to be debited instead of COGS on some…

Thanks @"4209550", Glad to be of help Regards, @"Herdi Rana-Oracle"

Hi @"paul.baudouin" Basically, you would like to know how the Pick task, wave and Sales Order are connected, am I correct? Just to verify my understanding, you are using SCM Mobile bundle is that right? In SCM Mobile, Sales Order ready for release to the Warehouse should have Wave created and associated in it. Wave…

Thanks @"Chap Moore_32139", I noticed that the Advanced Bin Management is not enabled in your end. I was able to reproduce the same Notice on my end: If I hit save on this, Kindly input/encode the Lot/Serial number of the Assembly item under the Serial Numbers box in the Primary Information After making sure that both the…

Hi @"Tybrneryan", You may try this one: case when (((to_char({custrecordiqf1_startdatetime},'hh24')>= 6) AND (to_char({custrecordiqf1_startdatetime},'hh24')<= 18)) AND ((to_char({custrecordiqf1_startdatetime},'D')>= 1) AND (to_char({custrecordiqf1_startdatetime},'D')<= 3))) OR…

Hi @"Chap Moore_32139", May I know if the Inventory details for both the Component and the Top Level Assembly has been completely and correctly configured? Kindly send a screenshot as well of the Assembly Build and the Inventory Details (don't forget to mask/hide confidential information) Can you confirm as well if this is…

Hi @"Tybrneryan", You may try this one: case when (((to_char({custrecordiqf1_startdatetime},'hh24')>= 6) AND (to_char({custrecordiqf1_startdatetime},'hh24')<= 18)) AND ((to_char({custrecordiqf1_startdatetime},'D')>= 1) AND (to_char({custrecordiqf1_startdatetime},'D')<= 3))) OR…

Hi @"3968939", From what I understood, you have setup multiple pricing for your item am I correct? For example, in my test account, I have an item wherein I established 3 price levels, is this the same in your end (basically Base Price, Price A and Price B are different price levels?) When I expose this in an Item Saved…