Adding a subtotal to a document.
To create a subtotal in a document similar to the following
Step 1.
Create a new item group.
for Type set it to 'Remark'
for Subtotal Level set it to 'Level 1 Reset'
- there are 9 grouping levels to use.
- 'Reset' means to reset the count.
- 'Accumulate' will display the sum of all the above row. unless there is a 'Reset' in which case the values will be up to the last reset.
Tick the 'Subtotal for Amount'
if you want to sum up the quantity you can tick the 'Subtotal for Quantity'
Step 2.
Create a new item.
Select the item group created in the previous step.
Step 3.
Using the subtotal in the document.
Related Articles
2.0. Change Printout Format for Quotation
How to Change Quotation Printout Format? Changing the printout format for a quotation in OCi SAM allows you to customize how the quotation document appears when printed or exported. This is important for presenting a professional image to customers, ...
Document Import XML format
Version: 2.0.4 Date: 2023-04-12 XML format documentation 1. Invoice The follow sections describe the format of the Sales Invoice XML file. XML Mandatory Description <?xml version="1.0" encoding="UTF-8" standalone="yes"?> Y XML Declaration. <ociac10> ...
Changing my Item's default posting
When you need an item to post to a specific account you can create up an item group to specify the posting. In the following example, i want to post to rental account whenever i choose the rental account. Under Setup -> Item details -> Item Group ...
9.0. Item Categories
What Are Categories For? Categories are for grouping of your stock items for reporting purpose. Following is an example how you can make use of it. How Do You Setup Uncontrolled Categories? STEPS: Click SETUP activity Click ITEM DETAILS Click ITEM ...
7.0. Items Setup
Creating Items Items are used in the content of your document like your Quotation, Delivery Order, Sales Invoices, Purchase Order, Supplier’s Invoice, etc. Creating New Service Item 1 STEPS: Click SETUP activity Click ITEM DETAILS Click ITEM module ...