Spica Tech, Author at Spica Tech

by Spica Tech

October 15, 2024

Business Solution

COMPLEX QUERY

INTRODUCTION A complex query in the IBM Sterling Order Management System retrieves and processes multiple layers of data related to orders, customers, products, inventory...

Read Details

by Spica Tech

April 25, 2024

Business Solution

END OF FILE

INTRODUCTION During the full load inventory process, EOF (End Of File) is used to indicate the completion of item inventory information for particular node....

Read Details

by Spica Tech

March 18, 2024

Business Solution

CASH ON DELIVERY ORDERS

INTRODUCTION Cash on Delivery is one of the payment method which allows the customer to settle their order amount at the time of receiving...

Read Details

by Spica Tech

March 6, 2024

Business Solution

FINANCIAL RULES AND ATTRIBUTES

INTRODUCTION Sterling Order Management System (OMS) allows users to configure financial attributes to manage the financial aspects of sales orders and return orders. The...

Read Details

by Spica Tech

February 27, 2024

Business Solution

INVOICE PROCESSING

INTRODUCTION Invoice is a certified document that records the list of products purchased by the customer, amount to be collected for the ordered quantity...

Read Details

by Spica Tech

January 19, 2024

Business Solution

COOLING OFF HOLD EXECUTION

INTRODUCTION For a short period of time, order will be put on hold by not executing any further fulfillment process for a given period...

Read Details

by Spica Tech

January 9, 2024

Business Solution

PAYMENT PROCESSING – WALLET

Introduction Payment processing has three main steps. Authorization, Invoicing and Settlement. Payment Rule Configuration Step 1: Go to SBC – Move to your organization...

Read Details

by Spica Tech

December 22, 2023

Business Solution

AGENT SERVER ARCHITECTURE

INTRODUCTION Agent Server is Time Triggered Transaction. Agent has two methods which is GetJob and ExecuteJob. Get Job will collect all Pending Jobs. Execute...

Read Details

by Spica Tech

December 12, 2023

Business Solution

CREDIT CARD PAYMENT PROCESSING

Scenario : CreateOrder : Output : <Order DocumentType=”0001″ EnterpriseCode=”Matrix” OrderHeaderKey=”20230825130846254017″ OrderNo=”526″/> Console : Charge Transaction Table : After creating the order the Authorization record is in “open” status...

Read Details

by Spica Tech

June 5, 2023

Business Solution

Bulk Inventory Load into OMS

Inventory load is a two-step process, where the inventory is loaded into YFS_INVENTORY_SUPPLY_TEMP table is the first step and Syncing the inventory is second.When...

Read Details

Get In Touch

Gallery

COMPLEX QUERY

END OF FILE

CASH ON DELIVERY ORDERS

FINANCIAL RULES AND ATTRIBUTES

INVOICE PROCESSING

COOLING OFF HOLD EXECUTION

PAYMENT PROCESSING – WALLET

AGENT SERVER ARCHITECTURE

CREDIT CARD PAYMENT PROCESSING

Bulk Inventory Load into OMS

Quick Links

Opening Hours

Popular Updates

COMPLEX QUERY

END OF FILE