Jcurve Support Articles

Resolve Error: "Please enter missing price(s)"

On the item record, upon manually updating the item quantity pricing information the above error was received.

Manufacturing

Customize Assembly Item Form > Manufacturing Subtab Missing

The manufacturing subtab is not showing in the list of subtabs when trying to customize an Assembly Item Form or Standard Group Item Form.

Update Pricing Based on Quantity Pricing Schedule

To update the pricing of Items using a Quantity Pricing Schedule, do the following:

Inventory Adjustment > Click Inventory Detail > Enter Inventory Detail > The Total Inventory Detail must Be NaN

With Advanced Bin/Numbered Inventory Management enabled, create an Inventory Adjustment for an Inventory with Inventory Detail.

Source Transaction Line Fields from Line on Sales Order onto Body Fields for Linked Work Order using SuiteScript

The User would like to source values of custom Transaction Line Fields from respective lines on a Sales Order onto Body Fields for the Linked Work Order possibly created in the following manner:

Advanced Accounting

Enabling Advanced Taxes

Warning: If you enable Advanced Taxes, you cannot disable it in the future.

Order to Cash

Manual Credit Hold Not Working

Navigate to Setup > Accounting > Accounting Preferences > General tab > Accounts Receivable portlet

Saved Search to Filter Transactions Created by Specific Role/s

User wants to create a Saved Search to filter transactions using specific role/s.

Transaction Saved Search to Show Related Sales Order Status of Item Fulfillment

Create aTransaction Saved Searchthat would show the status ofItem Fulfillment's related order.

Return User Error on Transaction Deletion not Working

A user wants to return a user error via workflow whenever a user tries to delete purchase orders that are not created by them.

Add a Custom Column (Checkbox) in the Inventory Location Sublist on Item Records

On the item record, a user wants to flag an item by having a custom checkbox, but only specific to certain locations and not all locations.

Enable/Disable Oracle Guided Learning Preference

The user wants to remove the newly added button at the middle-right part of the dashboard.

Payroll

Salary Sacrificing Super

The Superannuation is deducted against the Base Salary amount of the employee after the Salary Sacrifice is deducted. The customer wants the Superannuation to be deducted against the Base Salary amount before the Salary Sacrifice.

Basic Accounting

Asset Split

Asset split enables a specified quantity to be separated from the original asset and creates new asset records. The Quantity field on the Maintenance subtab of the asset record tracks the number of individual elements that form the asset.

Order to Cash

Quantity Committed is Greater than Quantity On Hand in Reallocate Inventory Page

Why is the Quantity Committed appears higher than Quantity On Hand in Reallocate Items page?

The Quantity Committed appears higher than Quantity On Hand is because it already includes the Quantity Picked. This also happens when there are frequent changes made on the Accounting Preference: Fulfill Based on Commitment per Audit Trail of Preferences via Setup > Accounting > Accounting Preferences > More (located at upper right side of the page) > Audit Trail. When the Accounting Preference: Fulfill Based on Commitment is set to Allow Uncommitted, and a Sales Order, from which the quantity is on back order, is fulfilled to Picked Status, the Quantity Committed increases while the Quantity on Hand remains.

Order to Cash

Resolve Users Who are Allowed to Fulfill More than the Quantity on hand When Fulfill based on Commitment setting is set to Limit to Committed

System allows fulfilling of Sales Orders more than current Quantity On Hand even if Fulfill based on Commitment setting is set to "Limit to Committed" and the user is fulfilling items using the Standard Sales Order Form.

Create Search for all Customers with no Transactions

Scenario

Create a saved search that will show all customers with no related transactions.

Solution

1. Navigate toLists>Search>Saved Searches>New
2. ClickCustomer
3.Search Title:EnterTitle
Example:Customers With No Related Transactions
4. ClickCriteria
5. ClickStandard
6.Filter:

Note:For every required field use the drop-down menu to select it and once adjusted click Add if

needed.

SelectStage

Stage:SelectCustomer
ClickSet

7. ClickSummary

Summary Type:SelectSum
Field:SelectFormula (Numeric)
1. Formula (Numeric):Select isequal
2. ClickSet
Formula:EnterDecode ({transaction.number},NULL, 0,1

8. ClickResults
9.Field:

Note:For every required field use the drop-down menu to select it and once adjusted click Add if

needed.

SelectName
- Summary Type:SelectGroup
SelectFormula (Numeric)
- Summary Type:SelectSum
- Formula:EnterDecode ({transaction.number},NULL, 0,1)

10. ClickSave & Run

Saved Search on Inventory Count of Lot Numbered Items to Show the Inventory Numbers and Quantities on Snapshot Detail and Count Detail

Scenario

Users want to show in a single saved search theInventory Numbersand their quantities on theSnapshot DetailandCount Detail.

Solution

Navigate toLists>Search>Saved Searches>New
SelectTransaction
Search Title:EnterTitle
ClickResults
ClickStandard
Filter:
- SelectType
  - SelectInventory Count
- SelectItem
  - Selectnot none
- SelectStatus
  - SelectInventory Count:Approved,Inventory Count:Completed/Pending Approval
- SelectItem fields...
  - SelectIs Lot Number
    - SelectYes
- SelectFormula(Numeric)
  - Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' or {transactionlinetype} = 'Count Quantity' THEN 1 ELSE 0 END
    - Formula (Numeric):Selectequal to
    - Value:Enter1
ClickResults
ClickColumns
Field:
- SelectDate
- SelectDocument Number
- SelectItem
- SelectFormula(Text)
  - Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' THEN {inventorydetail.inventorynumber} ELSE null END
  - Custom Label:EnterSnapshot Lot Number
- SelectFormula(Text)
  - Formula:EnterCASE WHEN{transactionlinetype} = 'Snapshot Quantity' THEN {inventorydetail.quantity} ELSE null END
  - Custom Label:EnterSnapshot Quantity
- SelectFormula(Text)
  - Formula:EnterCASE WHEN {transactionlinetype}='Count Quantity' THEN {inventorydetail.inventorynumber} ELSE null END
  - Custom Label:EnterCount Lot Number
- SelectFormula(Text)
  - Formula:EnterCASE WHEN {transactionlinetype}='Count Quantity' THEN {inventorydetail.quantity} ELSE null END
  - Custom Label:EnterCount Quantity
ClickAdd
ClickSave & Run