Search Optifacts User Documentation
Table of Contents (on this page)
Introduction
This document provides instructions for setting up XML Statements.
Procedure
From the Optifacts main menu:
Type 3 - Editor Utilities and press enter.
Type 1 - Customer Database and press enter.
Type 13 - Configure Stmt/Faktura and press enter.
- Enter all applicable information pressing enter past each field.
- Press escape to save the data.
- Type E to exit the screen.
There are 3 screens for the XML Statement.
Field Definitions
Account Number - Customer Account Number
Statement Format Name - Name of file that holds the format commands (don't include suffix .fo or .xsl)
Delivery Note Format Name - Name of file that holds the format commands (don't include suffix .fo or .xsl)
Stock Invoice Format Name - Name of file that holds the format commands (don't include suffix .fo or .xsl)
Weekly/Bi-Weekly/Monthly - (1-4): Daily, W: Weekly, B: Bi-Weekly, M: Monthly (dflt), 0: Anytime
Accounting Code -
General Ledger Group - GL Group assignment. This entry should match a group in the GL Account Editor.
Value Added Tax # -
Per Day Shipping/Handling - Postal Charges for each day for which a job was shipped.
VAT Regime -
Payment Form - Payment Form for Reference
Billing PO - Billing PO Number for Statement
Payment Term Days - Payment Term in days (30, 60, 90, or 120)
Note Pricing Display - Delivery Note: S: Suppress Price, L: List Price, N: Net Price
Currency Code - Currency Code for this customer. Must exist in Currency Editor.
ASN File Flag - Create ASN files for bulk orders? (E)xternal customer, (I)nternal, (N)o.
Delivery Note Language - Language to print on the Delivery Note for this customer.
Main Price List Name - Price List name for Commercial Agreement for customer's primary price list.
Discount from Main List - Discount Percentage off of Main List to be applied on the delivery note.
Statement Groups
Assign customer to the appropriate Faktura groups. Some accounts are weekly, monthly, etc. There are four daily grouping that can be set up.
Example:
Grouping 1 might be run in the morning and grouping 2 might be run at the end of the day.
STATEMENT/FAKTURA CONFIGURATION
Account Number: [ 1]
Statement Format Name: [ ]
Delivery Note Format Name: [ ]
Stock Invoice Format Name: [ ]
Weekly/Bi-Weekly/Monthly: [2]
General Ledger Group: [BASE ] Value Added Tax #[vat12345 ]
Per Day Shipping/Handling: [0,0 ] Payment Term Days: [120 ]
Currency Code: [DM ]
Delivery Note Language: [polish ]
Main Pricing List Name: [POLAND ]
Discount from Main List: [10,0 ]
Secondary Pricing List: [200189 ]
Bank Name: [ ]
Bank Account: [ ]
Sales Group: [ ] ID: [ ]
Buying Group: [NEW BUYING GROUP ] ID: [ ]
Chain Group: [ ] ID: [ ]
Business Type: [ ] ID: [ ]
(1-4): Daily, W: Weekly, B: Bi-Weekly, M: Monthly (default is Monthly)
When running statements pick the proper group for the Faktura (Statement) run.
From the Optifacts Main Menu:
- Type 1 – Accounts Receivable and press enter.
- Type 2 – Monthly Routines and press enter.
- Type 2 – Monthly Statements and press enter.
- Enter the information pressing enter past each field.
ACCOUNTS RECEIVABLE MONTHLY STATEMENTS REPORT
Output to screen, printer or file (S/P/F)? . . . . . . . . . . . . P
Printing GL Output, Temporary or Real statements (T/R/G)? . . . . T
New Page/Screen for every account (Y/N)? . . . . . . . . . . . . . N
Print Daily, Special, Weekly, Bi-weekly, or Monthly (1-4/S/W/B/M)? 1
Statement run will default to today’s date for both start and end dates but these dates can be altered at run time as needed.
Note: Another option is S for Special. This allows a special statement run for an account or group of accounts that will function like a daily statement run. Start and End dates will be prompted. This feature is convenient if a Faktura print is needed for a customer that stops in to pick up a set of orders. Even if the customer is typically a monthly Faktura customer, a special run can be made that will include orders that have been accumulated during the time period specified by start and end dates of the statement run.
