Skip navigation

Different states, countries or locations may have specific laws or regulations governing products that can or cannot be sold to and used by consumers or businesses within their jurisdiction. In these circumstances users of JD Edwards EnterpriseOne Software need a way to setup the system to allow a product to be sold and shipped to one geographical location but to prevent a sales order from being created and shipped to a different geographical location where the product is prohibited.


We have always offered the ability to create an item exclude list, but that feature only works to restrict the sale by sold to customer address which is a significant limitation.


If you are allowed to ship an item to a customer in Colorado but prohibited from shipping it to the same customer in another state, you need a different approach. An innovative solution that will return a hard error at sales order entry when the ship to address is in a prohibited location has been adopted by many customers. For details on how to setup this functionality, please refer to Case Study – Restricting the Sale of Prohibited Items (Doc ID 2210855.1).

If you take credit cards, cash or check payments at the time of sales order entry, the sales order is prepaid and there is no need to collect a payment from the customer to retire their open accounts receivable invoice.


Normally Sales Update will automatically create an AR Ledger Record and a Debit to the AR Trade G/L Account even if the order has been prepaid.


If the Prepayment Tab processing options are set correctly the AR Batch Draft Creation (R03B671) will create Preauthorized Drafts at the time of Sales Update to retire the Accounts Receivable obligation automatically. When the AR Batch Draft Creation (R03B671) runs, it will record the payment against the AR Ledger invoice created by Sales Update and will also create a Credit Entry against AR Trade G/L Account leaving a net balance of $0 so that no money need be collected from the customer.

For details on how to setup this functionality, please refer to Case Study: How to Create Drafts at Sales Update for Prepaid Cash Sales Invoices (Doc ID 2361275.1). Although the example shown is for a Cash Sale, the functionality works equally well with Sales prepaid by Credit Card or Check.

Filter Blog

By date: By tag:

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see for instructions.