Supplier Maintenance

Document path Reference Contents > Suppliers > Supplier Maintenance

On selection of any Suppliers Menu function, the Supplier Maintenance window will open.

The window contains a number of panes of supplier details with a series of common control buttons at the bottom of the window.

Button

Action

Index indicator

The text shows which index the next/previous will operate on. By double-clicking on this you can cycle through the indexes and change the next/previous sequence.

Previous

Finds the preceding value of the field alongside. By repeatedly clicking, you can cycle through the file. After the file's first record, an audible tone will sound and the last record on file will be found.

Tip TIP: Double-click on the text message of the current index (E.g. Supplier code), and you can step through the alternatives, changing the effect of the "Next" and "Previous" commands.

Next

Finds the next value of the field alongside. By repeatedly clicking, you can cycle through the file. After the file's last record, an audible tone will sound and the first record on file will be found.

Revert to Saved

To revert any changes to the previously saved version.

Save as Shown

To save the changes you have made to the data file.

Cancel

Aborts the process currently in session. The keyboard equivalent is the Esc key for Windows computers and Command-.(full stop or period) for the Mac.

OK

The OK button updates the data you have entered, or confirms the selection and/or processes the function you have called.

The window has six tab panes.

Business

Addresses

Contacts

Financial

Texts

Banking and Others

Business

This pane shows business details and code classifications.

Field

Description

Supplier Code

Suppliers. Supplier unique code identifier. {SUPFILE.SUPCODE char 6}

A 6 character code that uniquely defines the Supplier record. You should have a reasonably recognizable code system for suppliers, as this helps when selecting them throughout the program.

Tip TIP: The best code system is CAL002, or similar, for Caliach, being the second supplier starting with CAL entered into the system. Do not number them CAL1, CAL2, etc., as they will not sort numerically if you reach CAL10. The result will be that CAL10 comes between CAL1 and CAL2! If you plan to have more than 10,000 customers or so, a different scheme may be more advisable.

Supplier Name

Suppliers. Supplier company name. {SUPFILE.SUPNAME char national 40}

Do not use

Suppliers. Do not use this supplier. {SUPFILE.SUPBAR boolean}

Index 1 Code

Suppliers. Index 1 code. {SUPFILE.SUPIDX1 char 4}

An alpha-numeric code assigned to the Supplier that can be used throughout the system to select or sort. For example, it can be used to group Suppliers into classes such as Good, Bad, Excellent, New, etc.. Index Codes must be pre-defined in the Index and Other Code Maintenance window before being assigned to a Supplier.

Index 1 Description

Index and Other Codes. Index code, scrap reason or QA test description (must have at least 1 character). {IDXFILE.IDXDESC char 255}

Show

Click this button to display a list of alternatives for the field alongside the button. Double-clicking on a list line will enter the value from the list.

Index 1 Popup List

Lists all supplier index 1 codes. Double-click on a code line to insert that code.

Index 2 Code

Suppliers. Index 2 code. {SUPFILE.SUPIDX2 char 4}

Index 2 Description

Index and Other Codes. Index code, scrap reason or QA test description (must have at least 1 character). {IDXFILE.IDXDESC char 255}

Show

Click this button to display a list of alternatives for the field alongside the button. Double-clicking on a list line will enter the value from the list.

Index 2 Popup List

Lists all supplier index 2 codes. Double-click on a code line to insert that code.

User Reference

Suppliers. User reference index code. {SUPFILE.SUPUREF char 10}

This is an additional indexed field that the user can use for additional selection or sort purposes. Up to 10 characters of any type can be used. This field is available in both Print and Global Change selection setup selections.

Customisation CUSTOM CAPABILITY: With the oCustom1.$SupurefAfter() method you can apply a custom method to verify what is entered in the User Reference field. This can enable you to enforce a coding policy amongst many users.

Address

Suppliers. Supplier address. {SUPFILE.SUPADDR char 250}

Address and contact

The selected address and contact, the default when first read. You can change this in the Addresses pane and also the elements included. See Address Maintenance Subwindow for more help.

Right-click on this field to obtain print functions for the currently selected address and contact:

Address and Contact additional context menu functions.

Print Standard Letter opens the Standard Letter Selection window and Print 4x4 Label opens the 4 by 4 Label Position window.

Note NOTE: For help on formatting of addresses with contacts and the control you have over what elements are included and any text enhancements, see "Formatting Addresses for Printing" section in the Address Maintenance Subwindow topic.

Last Value Change

Suppliers. Last modified date and time of values. {SUPFILE.SUPMODV date datetime 8}

Last Modified

Suppliers. Last modified date and time of master data. {SUPFILE.SUPMODM date datetime 8}

Last Modified User

Suppliers. Last modification of master settings user. {SUPFILE.SUPMODU char 3}

Button

Action

View or Add to Marketing

Opens the Marketing Data Maintenance window with the linked marketing record for the current supplier, if available, or creates one, if not. Linking a supplier to a marketing record provides powerful Supplier Relationship Management capabilities.

Back to top

Addresses

Default address and alternative addresses.

Addresses are maintained in the Address Maintenance Subwindow. See that for help.

Back to top

Contacts

Contact details for the address selected.

Contacts are maintained in the Contact Maintenance Subwindow. See that for help.

Back to top

Financial

Field

Description

Tax Identification

Suppliers. Tax identification reference. {SUPFILE.SUPTAXN char 30}

You can enter here the tax code of the supplier. This is useful when you want to use the Purchase Trade Statistics function.

Default Tax Regime

Suppliers. Tax Regime code default for A/P invoices. {SUPFILE.SUPTAMC char 6} See the Tax Maintenance window for full details of the tax handling system.

Currency

Suppliers. Default currency code for POs. {SUPFILE.SUPCUR char 3}

The default currency for Purchase Orders. You can only enter a currency symbol that is defined in the File -- System Manager -- Currencies or Ledgers -- General Ledger -- Currency Control function, or the default currency symbol as defined in File -- System Manager -- Company Details.

Default Posting G/L Account

Suppliers. Default G/L account for posting invoices. {SUPFILE.SUPDACC char 10}

You can enter here a General Ledger Purchase type account which will act as the default during the posting of invoices received from this supplier. This is useful when the supplier's trade is not subject to Purchase Orders, such as utility companies.

Payment Days

Suppliers. Default payment days. {SUPFILE.SUPPAY integer shortint}

You can enter here a number from 0 through 255 to act as the default payment days for invoices received from suppliers. If you leave the value zero, the default payment days from the Ledger Manager settings will apply. The value is used in the Ledgers -- Accounts Payable -- Invoices and Credits function.

Factoring Supplier Code

Suppliers. Alternative account for A/P ledger postings (Factoring account). {SUPFILE.SUPALTC char 6}

Leave this blank or enter a valid Supplier Code of another Supplier. If a valid Supplier Code is entered, when you post an Invoice or Credit Note to the Supplier, the alternative suppliers account in the Accounts Payable ledger will be posted with the transactions involved. For example, if supplier AAA001 has supplier BBB005 entered in the Factoring Supplier code, when an invoice is entered for AAA001, BBB005's account will be posted in the A/P. This is useful where the Supplier (AAA001) is appropriate for the Purchase Order, Purchase history and maybe Tracking, etc. but where payment will be made to a totally different organisation, for example, a factoring company. When deleting a supplier, the system will not check that the supplier you are deleting is referred to in another supplier record.

Note NOTE: The Purchase Order supplier, not the posting supplier, is recorded with the received purchase value for the period.

Account Number

Suppliers. Supplier's account number for the user. {SUPFILE.SUPACNO char national 15}

Account Details

Suppliers. Account details with supplier. {SUPFILE.SUPACDE char 40}

Minimum order value

Suppliers. Minimum order value in local currency. {SUPFILE.SUPMINV number 2dp}

If a value is set here, a warning will be presented to the user when a purchase order is created for this supplier to warn the user of the suppliers minimum order rules (below). When a purchase order is saved and its balance value is less than the minimum value, a further warning will be given.

Minimum order rules

Suppliers. Minimum order rules message to users. {SUPFILE.SUPMINM char 150}

Order Value Limit in Local

Suppliers. On-order value limit (exclusive of tax) in local currency. {SUPFILE.SUPLIMT number 3dp}

This field must be used to set an upper order limit for a supplier. Placing or extending an order such that the value limit is exceeded will be prevented. The value can be set in Global Changes.

On-Order Value in Local

Suppliers. Current on-order value (exclusive of tax) in local currency. {SUPFILE.SUPORDR number 3dp}

This is an automatically maintained value based on all currently un-received purchase orders. This value can be re-set using File -- Advanced -- Re- set Data Files Re-set supplier current values.

Account Debit Balance in Local

Suppliers. Current account balance in local currency. {SUPFILE.SUPCBAL number 2dp}

This is an automatically maintained value based on all Accounts Payable transactions for the supplier. This value can be re-set using File -- Advanced -- Re- set Data Files Re-set supplier current values. (Only applicable if your application includes the Ledgers option.)

Account Debit Balance in Currency

Suppliers. Current account balance in supplier default foreign currency. {SUPFILE.SUPCBALF number 2dp}

Last Value Changed Date and Time

Suppliers. Last modification date and time of values. {SUPFILE.SUPMODV date datetime 8}

Received Purchase Values

See the Supplier Periods subwindow for details.

Back to top

Texts

Supplier texts.

Field

Description

Comments

Suppliers. Comments text for supplier. {SUPFILE.SUPCOTX char 32000}

A variable length field that can be used for any descriptive text relating to the supplier record. This text is not used elsewhere in the system but can be printed out to act as any aide-memoir you wish, e.g. history of performance, etc..

Purchase Order Header Individual Text

Suppliers. Standard Purchase Order header text. {SUPFILE.SUPPOTX char 32000}

A variable length field that can contain text, unique to this supplier, that will appear at the head of every purchase order created for this supplier.

Purchase Order Header Standard Text Code

Suppliers. Standard purchasing text code. {SUPFILE.SUPTXP char 4}

Standard text, that applies to many suppliers and maintained as Standard Text, can be selected for this supplier using it's code. The standard text will appear after any individual text (described above) in the header of each purchase order.

Show

Click this button to display a list of alternatives for the field alongside the button. Double-clicking on a list line will enter the value from the list.

Standard Text Popup List

List of all standard purchase texts.

Standard Text

Standard Texts (E,P,S,W). Text. {TXTFILE.TXTTEXT char 10000000}

Back to top

Banking and Others

This pane covers the supplier's banking and other details.

Field

Description

 

Banking Details.

Six text field are available to store banking information appropriate for electronic payment, such as BACS. This data is not used for any specific function in the program, but the data can be extracted in Custom Functions and on custom searches and reports and Ad Hoc reports or ODBC.

Bank Name

Suppliers. Bank name. {SUPFILE.SUPBANM char 40}

Branch

Suppliers. Bank branch. {SUPFILE.SUPBABR char 30}

Sort Code

Suppliers. Bank sort code. {SUPFILE.SUPBASO char 8}

Account Number

Suppliers. Bank account number. {SUPFILE.SUPBAAC char 15}

Reference

Suppliers. Bank reference. {SUPFILE.SUPBARE char 20}

Flag

Suppliers. Bank flag. {SUPFILE.SUPBAFL char 3}

 

User Defined Fields

These fields are available for any use you wish to put them. They are not used or reported by the system and are provided for use with custom searches or reports or Ad Hoc reports. There are 4 character fields that are limited to 1, 4, 18, and 30 characters respectively. These fields can be set in Global Changes. The field descriptions are set in File -- System Manager -- Company Details Maintenance window Descriptions tab pane.

Tip TIP: You can selectively get the system to inherit supplier record user defined field data onto Purchase Orders. This is done by setting the following system option

  • optPOInheritsUserFields

The option value is set to 1234, or any combination of those numbers. It will cause those PO user defined fields to be inherited from the supplier fields.

User 1

Suppliers. User character field 1 (single character). {SUPFILE.SUPUSE1 char 1}

User 2

Suppliers. User character field 2 (4 characters). {SUPFILE.SUPUSE2 char 4}

User 3

Suppliers. User character field 3 (18 characters). {SUPFILE.SUPUSE3 char 18}

User 4

Suppliers. User character field 4 (30 characters). {SUPFILE.SUPUSE4 char 30}

Button

Action

Export or Import Supplier

Opens the Supplier Master and Related Export and Import window in which you can export a supplier and it's related master records or import from an export file from another datafile.

Note NOTE: 3Com Palm III Organiser Data Transfer: A File -- Advanced -- Special Function -- Export Data to Palm III Organiser is available that can be used to export Marketing, Customer and Supplier data in a form that can be imported into Palm III organiser software.

Back to top

See also: -

Compiled in Program Version 3.10. Help data last modified 22 MAY 2008 04:51. Class wSupEdit last modified 9 FEB 2012 09:44:41.

Document path Reference Contents > Suppliers > Supplier Maintenance