image_pdfimage_print

Sales Order view allows user to create and manage sales order documents.

Below actions are available under “Sales Order”:

Samooha icon2  Create new sales order; update, delete, view and search for sales order details

Samooha icon2  Export and import sales order

sales-order-list-view

sales-order-items-articles

sales-order-taxes

sales-order-notes-and-attachements

sales-order-applied-promotions

Field Name
Explanation
Mandatory Information
Type  Document Type

Y

Document Date  Date of the sales order

Y

Document Number Number of the sales order

Y

Reference Number  A unique number on sales order

Y

Branch  A location, other than the main office, where business is conducted.

Y

Customer  Company’s customers

Y

Customer Location  Company’s location

Y

Contact Person  Person in charge

N

Deliver To  Self-explanatory

Y

Delivery Location Self-explanatory

Y

Ship From Self-explanatory

Y

Ship Via  Transportation method

N

Payment Term Payment rules imposed by suppliers on their customers.

N

Inco Term  Commonly used in both international and domestic trade contracts.

Y

Analytical Group Trade type

N

Tax  A compulsory contribution to state revenue, levied by the government on workers’ income and business profits, or added to the cost of some goods, services, and transactions.

Y

Representative Internal representative

N

Delivery Date The final date by which the underlying commodity for a futures contract must be delivered in order for the terms of the contract to be fulfilled.

N

Description Description

N

Invoice Rule  Immediate or After Delivery

Y

Priority  The fact or condition of being regarded or treated as more important than others

Y

Items/Articles – Product  Name of product

Y

Items/Articles – Description Description

N

Items/Articles – UOM  Type of product – Unit of Measure

Y

Items/Articles – Ordered Qty Self-explanatory

N

Items/Articles – Confirmed Qty Self-explanatory

N

Items/Articles – Unit Price Self-explanatory

N

Items/Articles – Discount A deduction from the usual cost of something.

N

Items/Articles – Nett Price Self-explanatory

N

Items/Articles – Total Amount Self-explanatory

Y

Items/Articles – Tax Rate Self-explanatory

N

Items/Articles – Change Reason Change reason to be entered when confirmed quantity is less than ordered quantity (i.e Out of Stock, Limited Stock, etc) 

Depend on system setting / preference

Items/Articles – Expense Type  Expense type of free / gift / marketing product  

N

Create New Sales Order

1. Click on “Create New” at the top right of screen of “Sales Orders List” tab, it will open “Sales Order” tab with empty form

Sales Order - create new

2. Select a customer from the “Customer” drop-down list on top left side of screen. It will fill up the form with the customer’s info

3. Fill up sales order’s information on the top half of screen

Sales Order - header

Sales order details

4. Click “Save” button at the bottom right side of screen to save

Products can only be entered when information in the top part (header) of the document has been properly entered. The credit check functionality will only be available when all the top part fields have been entered and the save button pressed.

Sales Order - credit check button

Sales Order - credit check preview

5. Filter the products list by selecting a brand from “Product Brand” drop-down list. Add product into the sales order by searching for the product from the product drop-down list in the table on “Items / Articles” tab

6. Enter the product’s info and click plus_button button or press ENTER to add the product into the sales order

Sales Order - add products

7. Repeat steps 5-6 to add more products into the sales order

8. Optional: Click on “Notes / Attachments” tab at the middle of screen to add notes or files attachment for the sales order

9. Click on “Save” button at the bottom right of screen when completed

10. Click on “Confirm Sales Order” button at the bottom of screen to confirm the sales order

Sales Order - confirm

The system will check whether any UOM Conversion is needed for the ordered product(s). If so the system will generate UOM Conversion document, with list of product(s) to be converted, for user to process first to fulfill the Sales Order. After the UOM Conversion process is successfully completed, user to confirm the Sales Order document again.

Sales Order - create UOM Conversion

Optional: User may change the Reserved Stock for a particular product to a different batch if they wish to do so, after the Sales Order confirmation. On the “Reserved Stock” tab, click “Modify Batch#” button. It will open a window for user to select a different batch for ordered product. Click on a batch # from the list and press ENTER. Click OK button to commit the change.

Note: For “Immediate” invoice rule, user may modify batch at the corresponding Proforma Invoice document instead

Sales Order - modify batch

The selection of batch / lot of products are based on the Picking Method as set in the Product master.
For example, FEFO (First Expired First Out) method will reserve expiring product batch / lot first. If expiry date was not entered for a product batch, but there is Shelf Life (In Days) defined in the Product master, system will calculate the product’s expiry date based on the Received On / Manufacturing Date plus shelf life and then reserve the first expiring product for the Sales Order.

Sales Order - modify batch - list

The system will automatically check if there is any promotion(s) applied for the customer for the period of the created Sales Order document date. If so, the promotion(s) will be displayed in the “Applied Promotions” tab, and any free gift / discount added in the “Items / Articles” tab.

Example 1: Allow Discount by X Spent promotion scheme

Sales Order - promo1 - applied

Sales Order - promo1 - items

Example 2: Free Gift By Purchase Qty promotion scheme

Sales Order - promo2 - applied

Sales Order - promo2 - items

11. Click on “Approve Sales Order” button at the bottom of screen to approve the sales order. Tax entries applicable for the sales order will be automatically created under “Taxes” tab if any

Sales Order - items to tax

Sales Order - items taxes

12. If ”After Delivery” invoice rule was chosen, a link to “Delivery Order” transaction (Inventory module – Outbound) will be created at the bottom left of screen to process delivery order for the sales order.

Sales Order - link DO

If ”Immediate” invoice rule was chosen, click arrow on generate_doc_button button and select “Generate Proforma Invoice” option to generate a new proforma invoice. “Delivery Order” will be created from “Proforma Invoice” instead

Sales Order - generate proforma

13. Click arrow on generate_doc_button button and select “Generate Similar Sales Order” option to generate a new copy of the sales form

Sales Order - generate similar SO

 

Update Sales Order Details

1. Click on “Sales Orders List” tab at the bottom of screen

2. Double click on sales order to be updated, it will bring up the details on “Sales Order” tab for the selected order. If a sales order’s status is “Confirmed” or “Approved”, right click on the order and reopen / undo approval of the order first

Sales Order - list options

3. Make change(s) on the sales order information

4. Click on “Save” button at the bottom right of screen to save

5. Click on “Revert” button at the bottom right of screen or refresh icon at the top of the screen to roll back the changes

6. Click on “Confirm Sales Order” button at the bottom of screen to confirm the sales order

7. Click on “Approve Sales Order” button at the bottom of screen to approve the sales order

 

Delete Sales Order

1. Click on “Sales Orders List” tab at the bottom of screen

2. Double click on sales order to be deleted, it will bring up the details on “Sales Order” tab for the selected order. If a sales order’s status is “Confirmed” or “Approved”, right click on the order and reopen / undo approval of the order first

3. Click on “Delete” button at the bottom right side of screen

4. Click on “Yes” button on the pop-up window to confirm sales order deletion

Sales Order - delete

 

View and Search for Sales Order Details

1. Click on “Sales Orders List” tab at the bottom of screen.

2. Enter search parameter to filter the result, i.e. type in which customer to search for in the “Customer” text field box or select from drop-down list

Sales Order - list filters

3. Result can be sorted alphabetically by clicking the fields’ columns

4. Double click on sales order to view full details of the order, it will bring up the details on “Sales Order” tab for the selected order

 

Export & Import Sales Order 

At many places within Samooha, user will see these 2 buttons import-csv  export-csv which indicate that user is able to import / export data from / to CSV (comma-separated values) file for that document view. Data in CSV file can be viewed using Excel or Notepad program.

There are 2 types of export & import feature for Sales Order in Samooha:

A. Document level

B. Product line level

Note: user is recommended to export data to a CSV file first and then use the exported file as import file template

 

A. Document level

Click on “Sales Orders List” tab at the bottom of screen. At the top right of screen there are 2 buttons; export-csv button to export approved Sales Order documents as CSV file, while import-csv button to import CSV file into Samooha as drafted Sales Order documents.

Sales Order - list - import export buttons

I. Export Sales Order to CSV File:

1. To export sales order, select approved Sales Order document row(s) from the list, then click export-csv button, or right-click on the Sales Order row to show options window then click on “Export Sales Order(s) – Detailed”. User can select multiple rows to export multiple Sales Order documents in a single CSV file

Note: only approved Sales Order can be exported

Sales Order - approved list options

2. On the “Export File Chooser” window, click on “Browse” button to select file location and file name to save the exported data. User may select different format of the data to be exported:

  • Header and Lines
  • One Row per Item
  • With Quantity Only (for sending data to 3PL)

Sales Order - export file chooser

Sales Order - export file chooser - list

3. Click OK button to confirm and export the selected Sales Order document(s) to CSV file.

4. Open the folder where the file was saved. Below is example of the same Sales Order document exported as CSV file in different formats:

  • Header and Lines

Sales Order - export sample - header format

  • One Row per Item

Sales Order - export sample - rows format

  • With Quantity Only (for sending data to 3PL)

Sales Order - export sample - qty format

 

II. Import Sales Order from CSV File:

1. To import sales order, click import-csv button in the Sales Order list view. User can import multiple Sales Order documents in a single CSV file. Sales Order document will be imported into Samooha as drafted in status.

Note: user to ensure there is no duplicate document number for the imported data, i.e. the document number is not already in Samooha list of Sales Order

2. On the “Import File Chooser” window, click on “Browse” button to select file location and file name to load the import data from. User to select the correct format of the data to be imported:

  • Header and Lines
  • One Row per Item

Sales Order - import file chooser

Sales Order - import file chooser - list

Below is example of the same multiple Sales Order documents (with different document numbers), imported as CSV file in different formats:

  • Header and Lines

Sales Order - import sample - header format

  • One Row per Item

Sales Order - import sample - rows format

3. Click OK button to confirm and import the selected CSV file as Sales Order document(s).

4. Click Search button on top right of the list view to refresh the list. If successfully imported, the document(s) status will be shown as drafted.

Sales Order - import sample - list

B. Product line level

In Sales Order view, user is able to export list of products in the sales order or import list of products to be part of the sales order.

Sales Order - details- import export buttons

I. Export Sales Order Product Lines Data to CSV File:

Scenario: Export list of products data from a sales order document to csv file

1. Open “Sales – (Sell In Transactions) Sales Orders” view

2. Double click on a sales order from the sales orders list, it will bring up the details on “Sales Order” tab for the selected order.

3. On right side of “Items / Articles” tab, click on export-csv button to export the list of products to csv file. It will pop up a window, select folder to save and enter the file name of the csv data file. Default file name is document#.csv

Sales Order - export products

Sales Order - exported product file

Note: User may need to change numbers (e.g. “Product #“, “Barcode“) as custom type in the excel application, for it to show properly. This is due to excel application displaying long numbers as scientific notation (e.g. 1.2408E+12). To change data type in excel, select the column, right click, Format cells, select Custom category and choose type = 0

 

II. Import Sales Order Product Lines Data from CSV File:

Scenario: Import list of products data into a sales order document from csv file

Note: User is recommended to export data first to create a data template with example to use as data import creation template. This will help reduce likelihood of mistakes in preparing the data to be imported into GOOMI application

1. Open “Sales – (Sell In Transactions) Sales Orders” view

2. Double click on a sales order from the sales orders list, it will bring up the details on “Sales Order” tab for the selected order. User can only enter / import product lines data when the Sales Order document status is “Drafted“. If a sales order’s status is “Confirmed” or “Approved”, reopen / undo approval of the Sales Order first. This is to allow user to modify the document

3. On right side of “Items / Articles” tab, click on import-csv button to import the list of products from csv file. It will pop up a window, select folder to load and choose the csv file to *import the data from

Sales Order - import products

*Note: User may need to change numbers (e.g. “Product #“, “Barcode“) in the csv data file as custom type in the excel application, for it to save properly as csv file. This is due to excel application changing long numbers replacing it with zeros at the back (e.g. 45315060300881becomes 45315060300000). To change data type in excel, select the column, right click, Format cells, select Custom category and choose type = 0

4. Compare the imported data in the sales order against the csv file

Sales Order - imported products

Sales Order - exported product file