Scenario: While cancelling the Sales Orders users are getting this message, even though no fulfilments are associated By design, only Sales Order with Pending Approval status can be Cancelled. However, when a Customer Deposit with Fully Applied status is found on the Sales Order, the system will not allow the order to be cancelled. Solution Please… Continue reading “You can only cancel orders without shipped fulfillments.”
Tag: Sales order
To approve a sales order
Go to Transactions > Sales > Approve Sales Orders (Administrator) A list of orders shows at the bottom of the page. In the Supervisor field, select a name to filter the sales order list by supervisor. Clear this field to show all sales orders pending approval. Check the box in the Approve column for each… Continue reading To approve a sales order
How to Get the Percentage of Fulfilled Quantity Out of Ordered Quantity
Navigate to Lists > Search > Saved Searches > New >Transaction. Under Criteria tab, set the following:Type- Sales OrderDate- (specify a specific period)Main Line-falseTax Line-falseCOGS Line-falseShipping Line-false Under Results tab NumberNameQuantityQuantity Fulfilled/ReceivedFormula (Percent) > Formula = nvl({quantityshiprecv},0)/nullif(nvl({quantity},0),0) Enter a Search Title. 5.Save & Run.
Auto Populate Ship date in Sales Order using script
CSV Import: Sales Order > Error: Invalid item reference key xx.
Recommendations: 1. The CSV Import file shouldcontain the same Item Name format as shown in Transactions > Sales > Enter Sales Orders > Items tab > Items subtab> Item drop down field. 2. Internal ID can also beused instead of Item Name. Just make sure that on the field mapping page, clickon the pencil icon beside the Item field and ChooseReference Type = Internal ID. 3. Verify if theItem is Inactive. If the Item record… Continue reading CSV Import: Sales Order > Error: Invalid item reference key xx.
Remove Backorder Quantity On Item Records
Remove Backorder Quantity On Item Records
Get a field value from Item fulfilment using sales order internal id
Suppose we have sales order internal id, and using that need to show a value from a specific field of item fulfilment. Solution:Use saved and export the search and use the same in suitescript. Adding sample search below. Kindly note that if used “applyingTransaction” in search result, the use the same while taking field value… Continue reading Get a field value from Item fulfilment using sales order internal id
Transform sales order to item fulfillment
For a sales order with committed line items can be converted by setting default value as inventory location. Kindly refer to the transform code below. let trecord = record.transform({ fromType: “salesorder”, fromId: salesOrderId, toType: “itemfulfillment”, defaultValues: { ‘inventorylocation’: locationInternalId } }); If the sales order is uncommitted and the feature “Allow uncommitted” is enabled in… Continue reading Transform sales order to item fulfillment
Saved search criteria to fetch sales order records that were created or edited within the last 24 hours (including line level).
Sales order can be fulfilled if the item quantities were back ordered in the transaction
The sales order can be fulfilled if the item quantities were back ordered in the transaction by enabling the enable feature below. Under Setup > Accounting > Accounting Preference Click Order Management Fulfill Based On Commitment:Set to Ignore Commitment or Allow Uncommitted This Preference allows creation of Item Fulfillment on Sales Orders even when Items are back-ordered. The quantities in Sales Order will remain as back… Continue reading Sales order can be fulfilled if the item quantities were back ordered in the transaction