Anchor | ||||
---|---|---|---|---|
|
Search Optifacts User Documentation
Live Search | ||||
---|---|---|---|---|
|
Table of Contents (on this page)
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Introduction
This document provides instructions for setting up XML Statements.
Procedure
Statement Configuration
From the Optifacts main menu:
Type Select Option 3 - Editor Utilities and press enterEnter.
Type Select Option 1 - Customer Database and press enterEnter.
Type Select Option 13 - Configure Stmt/Faktura and press enterEnter.
- Enter all applicable information pressing enter past each field.
- Press escape 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 the file that holds the format commands (
don'tdon’t include suffix .fo or .xsl)
Delivery Note Format Name - Name of the file that holds the format commands (
don'tdon’t include suffix .fo or .xsl)
Stock Invoice Format Name - Name of the file that holds the format commands (
don'tdon’t include suffix .fo or .xsl)
Weekly/Bi-Weekly/Monthly - (1-4): Daily, W: Weekly, B: Bi-Weekly, M: Monthly (dflt.), 0: Anytime
Accounting
CodeCode -
Leave Empty
General Ledger Group - GL Group assignment. This entry should match a group in the GL Account Editor.
Value Added Tax # -
VAT tax ID used in Europe
Per Day Shipping/Handling -
Postal ChargesPer day Postage, shipping, or handling charges for each day
for which a job wasthat jobs were shipped.
VAT Regime
-- Leave Empty - in Europe, they may use for sales indicator as an inside country, outside country, or EU
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 customerthe Customer. Must exist in Currency Editor.
ASN File Flag - Create ASN files for bulk orders?
(E)xternal customer, (I)nternal, (N)o“E” External Customer, “I” Internal, “N” No.
Delivery Note Language - Language to print on the Delivery Note for this
customerCustomer.
Main Price List Name - Price List name for Commercial Agreement for
customer'sCustomer’s primary price list.
Discount from Main List - Discount Percentage off of Main List to be applied on the delivery note.
Sales Group - Sales Group for Reference
ID - Sales ID Number for reference.
Buying Group -
BuyingEnter the Buying Group for reference.
ID - Buying ID Number for reference.
Chain Group
- Chain– Enter the Chain Group for reference.
ID - Chain ID Number for reference.
Business Type - Business Type for reference.
ID -Business ID Number for reference.
Bank Name
- Bank– Enter the Bank Name for reference on the billing statement.
Bank Account - Bank Account Number for reference on the billing statement.
Inactive Customer
- I– Enter“I” for Inactive
, Aor “A” for active.
Inactive Since
- Date the customer is– The date the Customer put on Inactive Status (for reference only).
E-Mail Address -
Customer'sCustomer’s E-Mail address.
E-Mail Address 2 -
Customer'sCustomer’s E-Mail address.
E-Mail Address 3 -
Customer'sCustomer’s E-Mail address.
E-Mail Address 4 -
Customer'sCustomer’s E-Mail address.
E-Mail Address 5 -
Customer'sCustomer’s E-Mail address.
Fax Number -
Customer'sCustomer’s Fax Number.
Warehouse ID - Numeric Warehouse ID
Credit Code - Code for the credit reason
Bonus - Calculate Bonuses M: Monthly, Q: Quarterly, Y: Yearly
District - District for reference
Route - Route for the seller to use
Public Price List Catalogs - Number of Public Price List Catalogs
Private Price List Catalogs -Number of Private Price List Catalogs
Register ID -
Account'sAccount’s business register ID
Automated Confirmation Format ID - Format ID for file output for confirmations
Faktura Sequence Group - Group for Faktura sequence, prefix, and printing
Instrument Main Pricing List - Price List name for the primary price list for instruments.
Instrument Secondary Pricing List
- Secondary– The Secondary price list for instruments to add to the primary list.
Second Value Added Tax # -
Second VAT tax ID used in Europe
Secondary Pricing List (long prompt) - Price List name for
customer'sCustomer’s secondary price list to add to the primary list. Use format xxxxx,xxxxx,xxxxx (price list name precisely as entered in the price list editor, with a comma between names and no spaces before or after the comma.
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.To view and download these instructions as a PDF file, click on the following document image.
View file | ||||
---|---|---|---|---|
|