Help & Support Knowledge Base
SHEET USED AS EXAMPLE FOR THIS ARTICLE
List of buyers with the number of items purchased:
Pivot Tables
Pivot tables provide a powerful interface to summarise info into groups.
Open File
Move cell cursor inside the data block
Click "Data "
Click "PivotTable and PivotChart reports"
Click Finished
Drag from "Field List" and drop in "row fields"
Drag from "Field List" and drop in "column fields"
Drag the numeric value from "Field List" and drop in "Data Items"
Optional: Drag the other fields from "Field List" en drop in "page fields"
The rows/columns and pages can be manipulated in any way for different reports.
AutoFilter
AutoFilter is 'n powerful tool to see only a subset of all the data based on some criteria
Open a file
Move cell cursor inside the data block
Click "Data "
Click "Filter"
Click "AutoFilter"
Subtotals
Subtotals is a powerful tool to group rows based on a change in value
Open a file
Move cell cursor inside the data block
Sort on the column you want to use as main field
Click "Data "
Click "Subtotals"
Select the columns to use for your summary and page breaks.
=oOo=
"KOPER" and "BUYER" substituted interchangeably
"GETAL" and "QTY" substituted interchangeably
This article is NOT verified or spellchecked
Please click the link below to read the related article.
Export invoices to Pastel
Update from an e-mailed UFZ file
Network setup
Printer setup
DEBTOR SYSTEM
Excel Tips
MEAT Processing Overview
Adding Event Expenses or Income
Change RMLA Rates
How to make a backup
How to get the Beta release
Create an event with lots from another event
How to clear all bids, buyers and prices
Automatically invoice buyers/sellers
Important VAT Notes
How to Update to the newest version
Sending us a FXE
How to do Multi-Owner Purchases
How to install FlexiAuction from a CD (New Customer)
How to move FlexiAuction to another computer
Start capturing lots
Adding a new event
How to Capture a lot
How to add a customer
Assigning buyer numbers
Entering the lot prices
Multiple Buyers
Changing date and currency format
Changing invoice variables
Balancing an auction
Invoice Buyers and Sellers
SUBJECT TO CONFIRMATION
Reprinting Invoices
Making changes to multiple lots
Shuffle Lots
Invoice payment CONTRAs
Main window
Login
Settings
Customers
Requirements
Events
Items/Stock
Users/Clerks
Definitions
Change Log
Working with SA Studbook assistant
Maintain Your Website
Creating pages on your website
Importing Lots From Excel
Working with the Store
Agents
Agent Commission
CRM GUIDE
Delete Generated Files
Setting up Your email in FlexiAuction
How to Stop/Start SQL Server
How to setup you domain at HETZNER
Transaction Summary
Printing cheques on a dot-matrix printer
Change Paytype on issued invoices
Warehouse
Stock Keeping module
License Verification Code
Change company details for document printing
Thank you for visiting our website. Copyright © 2005. All rights reserved.
Wibakor CC 1997/035379/23 T/A FLEXIAUCTION