Aplicar modificador a uma ordem de venda existente

Nesse post irei mostrar como aplicar um modificador a uma ordem de venda existente via API. Execute o script abaixo para criar o modificador DECLARE l_header_rec OE_ORDER_PUB.Header_Rec_Type; l_line_tbl OE_ORDER_PUB.Line_Tbl_Type; l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; l_header_adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type; l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_Type; l_header_scr_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type; l_line_scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type; l_request_rec OE_ORDER_PUB.Request_Rec_Type; l_return_status VARCHAR2 (1000); l_msg_count NUMBER; l_msg_data VARCHAR2 (1000); p_api_version_number NUMBER := 1.0; p_init_msg_list VARCHAR2... Continuar Lendo →

3 03America/Sao_Paulo junho 03America/Sao_Paulo 2019 0

Criar Percurso via API

Nesse post irei mostrar como criar percurso/distribuição via API Execute o script abaixo para criar o percurso e distribuição ao mesmo tempo DECLARE lv_return_status VARCHAR2 (1); ln_msg_count NUMBER; lv_msg_data VARCHAR2 (400); ln_trip_id VARCHAR2 (20); lv_trip_name VARCHAR2 (30); l_line_tbl WSH_UTIL_CORE.id_tab_type; l_del_rows_tbl WSH_UTIL_CORE.id_tab_type; i NUMBER := 1; l_msg_index_out NUMBER; CURSOR cur_trip IS SELECT delivery_detail_id FROM wsh_delivery_details a,... Continuar Lendo →

3 03America/Sao_Paulo junho 03America/Sao_Paulo 2019 0

Schedule Ship Date x Schedule Arrival Date

There are many option on this setup that be considered to determinate th source and delivery destiny. Internal Determinated froo warehouse and internal customer organization. External Determinated from customer address. Region Determinated from setup of customer region Zone Determinated from setup customer zone. The example that we will simulate it's based on internal time transit.... Continuar Lendo →

17 17America/Sao_Paulo setembro 17America/Sao_Paulo 2018 0

Pick Slip with full quantity in stock

In this post I will show you how to configure within the system the option to make the pick slip only with the full amount of the items in the sales order. Example: Sales order with an item X with quantity 4. Quantity in stock: 2. In the normal Oracle configuration process at the time... Continuar Lendo →

19 19America/Sao_Paulo julho 19America/Sao_Paulo 2018 0

Order Management Prepayment Setup

In this article I will demonstrate one more functionality of Oracle. Within the Order Management module it is possible to make pre-payments before even generating the final invoice for the product. Suppose a customer makes a purchase of a product and half of the production is necessary to 20% down. Within OM it is possible... Continuar Lendo →

15 15America/Sao_Paulo fevereiro 15America/Sao_Paulo 2018 1

Order Management Row Changes

In this article I will demonstrate functionality within Order Management to make changes to more than one line. There are cases and many where you need to make changes to several or all order management lines. This can give a whole work. The example below has 1088 rows. Suppose you need to change the schedule... Continuar Lendo →

16 16America/Sao_Paulo janeiro 16America/Sao_Paulo 2018 0

Setup Returnable Item

In this article I will show that to make a return within the Order Management it is necessary to make a setup inside the Master Items. The example below shows the message when you try to record a return in Order Management. In this case it is necessary to make the setup below in the... Continuar Lendo →

5 05America/Sao_Paulo janeiro 05America/Sao_Paulo 2018 0

Split Lines in Delivery Transactions

In this post I will show that there is the possibility of split lines in the sales orders deliveries. In the images below it shows how the process is done. Order Management -> Shipping -> Transactions Right click inside the record you want to do the split, then in the Split line option. Put the... Continuar Lendo →

28 28America/Sao_Paulo dezembro 28America/Sao_Paulo 2017 0