Compartir a través de

Vendor Table

  • Artículo

Specifies all information about your vendors.

A company's vendors can be roughly divided into 2 main groups:

  • Vendors who sell you items and raw materials

  • Other vendors and creditors

You can use the Vendor table to manage both groups. The Vendor table contains a card for each vendor, on which you enter basic information such as name, address and the kinds of discounts that are available. Each vendor must also have a number for identification purposes. When you enter the number in vendor number fields elsewhere in the program (on purchase quotes, for example), the program will automatically use the information associated with the number.

Before you can post to a vendor, you must set up a connection from the relevant vendor card to a balance sheet account in the chart of accounts. You must set up a connection to an income statement account. You do this with posting groups, which you must enter in the Gen. Bus. Posting Group and Vendor Posting Group fields. The posting groups are set up in the Gen. Business Posting Group and Vendor Posting Group tables.

After you set up the posting groups, you can enter them in the Posting Group field on vendor cards. Then when you post to a vendor account, corresponding entries will automatically be created in the associated G/L accounts. The general ledger will therefore always agree with the vendor's balance.

You can post to a vendor in an unlimited number of currencies. The resulting vendor ledger entries will show the currency of each entry.

The program can display the vendors in 2 different windows:

  • The Vendor Card window has a card for each vendor, which contains all the fields that have been selected. You can therefore see many fields for each vendor.

  • The Vendor List window displays all the vendors, with a line for each. Therefore, fewer fields are displayed for each vendor.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
L.S.T. No. Field, Vendor Table Sales Tax
P.A.N. Reference No. Field, Vendor Table Income Tax
C.S.T. No. Field, Vendor Table Sales Tax
P.A.N. Status Field, Vendor Table Income Tax
Composition Field, Vendor Table Sales Tax
P.A.N. No. Field, Vendor Table Income Tax
Service Tax Registration No. Field, Vendor Table Service Tax
State Field, Vendor Table Sales Tax
T.I.N. No. Field, Vendor Table Sales Tax
Collectorate Field, Vendor Table Excise
ABN Field, Vendor Table New Zealand Local Functionality
Foreign Vend Field, Vendor Table New Zealand Local Functionality
WHT Registration ID Field, Vendor Table New Zealand Local Functionality
SSI Field, Vendor Table Excise
Post Dated Checks (LCY) Field, Vendor Table New Zealand Local Functionality
SSI Validity Date Field, Vendor Table Excise
WHT Payable Amount (LCY) Field, Vendor Table New Zealand Local Functionality
CURP No. Field, Vendor Table United States Local Functionality
Excise Bus. Posting Group Field, Vendor Table Excise
RFC No. Field, Vendor Table United States Local Functionality
Tax Identification Type Field, Vendor Table United States Local Functionality
UPS Zone Field, Vendor Table United States Local Functionality
Tax Area Code Field, Vendor Table United States Local Functionality
State Inscription Field, Vendor Table United States Local Functionality
Check Date Separator Field, Vendor Table United States Local Functionality
Registered Field, Vendor Table New Zealand Local Functionality
EFT Payment Field, Vendor Table New Zealand Local Functionality
Tax Liable Field, Vendor Table United States Local Functionality
Business Identity Code Field, Vendor Table Finland Local Functionality
Check Date Format Field, Vendor Table United States Local Functionality
ID No. Field, Vendor Table New Zealand Local Functionality
IRD No. Field, Vendor Table New Zealand Local Functionality
EFT Bank Account No. Field, Vendor Table New Zealand Local Functionality
Vendor Type Field, Vendor Table Excise
Balance on Date (LCY) Field, Vendor Table United States Local Functionality
Country/Region Code Field, Vendor Table Finland Local Functionality
Federal ID No. Field, Vendor Table United States Local Functionality
Balance on Date Field, Vendor Table United States Local Functionality
IRS 1099 Code Field, Vendor Table United States Local Functionality
Bank Communication Field, Vendor Table United States Local Functionality
Our Account No. Field, Vendor Table Finland Local Functionality
WHT Business Posting Group Field, Vendor Table New Zealand Local Functionality
Range Field, Vendor Table Excise
E.C.C. No. Field, Vendor Table Excise
Type of Supply Code Field, Vendor Table United Kingdom Local Functionality
Remittance Field, Vendor Table Norway Local Functionality
Recipient ref. 2 - inv. Field, Vendor Table Norway Local Functionality
BACS Account No. Field, Vendor Table United Kingdom Local Functionality
SWIFT Field, Vendor Table Norway Local Functionality
Payment Type Code Domestic Field, Vendor Table Norway Local Functionality
Own Vendor Recipient Ref. Field, Vendor Table Norway Local Functionality
Warning Text Field, Vendor Table Norway Local Functionality
SWIFT Remb. Bank Field, Vendor Table Norway Local Functionality
Bank Address 2 Field, Vendor Table Norway Local Functionality
ABN Division Part No. Field, Vendor Table New Zealand Local Functionality
Inward Reg. Balance (LCY) Field, Vendor Table Sweden Local Functionality
Telex/Fax No. Field, Vendor Table Norway Local Functionality
Transporter Field, Vendor Table India Local Functionality
BOLS Text Code Field, Vendor Table Norway Local Functionality
Recipient ref. 3 - cred. Field, Vendor Table Norway Local Functionality
Specification (Norges Bank) Field, Vendor Table Norway Local Functionality
Recipient Bank Account No. Field, Vendor Table Norway Local Functionality
Remittance Account Code Field, Vendor Table Norway Local Functionality
Recipient ref. 3 - inv. Field, Vendor Table Norway Local Functionality
Bank Address 1 Field, Vendor Table Norway Local Functionality
Rcpt. Bank Country/Region Code Field, Vendor Table Norway Local Functionality
Bank Name Field, Vendor Table Norway Local Functionality
Charges Abroad Field, Vendor Table Norway Local Functionality
Bank Address 3 Field, Vendor Table Norway Local Functionality
To Own Account Field, Vendor Table Norway Local Functionality
Recipient ref. 2 - cred. Field, Vendor Table Norway Local Functionality
Recipient Ref. Abroad Field, Vendor Table Norway Local Functionality
Telex Country/Region Code Field, Vendor Table Norway Local Functionality
Recipient ref. 1 - inv. Field, Vendor Table Norway Local Functionality
Subcontractor Field, Vendor Table India Local Functionality
Recipient Contact Field, Vendor Table Norway Local Functionality
Recipient Confirmation Field, Vendor Table Norway Local Functionality
Remittance Agreement Code Field, Vendor Table Norway Local Functionality
Recipient ref. 1 - cred. Field, Vendor Table Norway Local Functionality
Charges Domestic Field, Vendor Table Norway Local Functionality
Warning Notice Field, Vendor Table Norway Local Functionality
Payment Type Code Abroad Field, Vendor Table Norway Local Functionality
Vendor Location Field, Vendor Table India Local Functionality
Structure Field, Vendor Table India Local Functionality
Commissioner's Permission No. Field, Vendor Table India Local Functionality
Service Entity Type Field, Vendor Table Service Tax
Priority Field, Vendor Table Purchases and Payables
Invoice Disc. Code Field, Vendor Table Purchases and Payables
Credit Amount Field, Vendor Table Purchases and Payables
No. of Credit Memos Field, Vendor Table Purchases and Payables
Tax Area Code Field, Vendor Table Purchases and Payables
Payments (LCY) Field, Vendor Table Purchases and Payables
Pay-to No. of Pstd. Invoices Field, Vendor Table Purchases and Payables
Application Method Field, Vendor Table Purchases and Payables
Picture Field, Vendor Table Purchases and Payables
Responsibility Center Field, Vendor Table Purchases and Payables
Preferred Bank Account Field, Vendor Table General Ledger
Prices Including VAT Field, Vendor Table Purchases and Payables
Name Field, Vendor Table Purchases and Payables
No. of Return Orders Field, Vendor Table Purchases and Payables
Address Field, Vendor Table Purchases and Payables
Pmt. Disc. Tolerance (LCY) Field, Vendor Table Purchases and Payables
Outstanding Orders Field, Vendor Table Purchases and Payables
Pay-to No. of Return Orders Field, Vendor Table Purchases and Payables
Contact Field, Vendor Table Purchases and Payables
Language Code Field, Vendor Table Purchases and Payables
Net Change Field, Vendor Table Purchases and Payables
Post Code Field, Vendor Table Purchases and Payables
Other Amounts Field, Vendor Table Purchases and Payables
Location Code Field, Vendor Table Purchases and Payables
Fax No. Field, Vendor Table Purchases and Payables
Home Page Field, Vendor Table Purchases and Payables
Refunds (LCY) Field, Vendor Table Purchases and Payables
Currency Code Field, Vendor Table Purchases and Payables
Purchaser Code Field, Vendor Table Purchases and Payables
No. of Invoices Field, Vendor Table Purchases and Payables
Blocked Field, Vendor Table Purchases and Payables
Global Dimension 2 Code Field, Vendor Table Purchases and Payables
No. of Order Addresses Field, Vendor Table Purchases and Payables
Reminder Amounts (LCY) Field, Vendor Table Purchases and Payables
No. Series Field, Vendor Table Purchases and Payables
Non-Paymt. Periods Code Field, Vendor Table Spain Local Functionality
Inv. Discounts (LCY) Field, Vendor Table Purchases and Payables
Global Dimension 1 Filter Field, Vendor Table Purchases and Payables
E-Mail Field, Vendor Table Purchases and Payables
Buy-from No. Of Archived Doc. Field, Vendor Table Purchases and Payables
VAT Bus. Posting Group Field, Vendor Table Purchases and Payables
Pay-to Vendor No. Field, Vendor Table Purchases and Payables
Cr. Memo Amounts (LCY) Field, Vendor Table Purchases and Payables
Debit Amount (LCY) Field, Vendor Table Purchases and Payables
Pay-to No. of Pstd. Cr. Memos Field, Vendor Table Purchases and Payables
Invoice Amounts Field, Vendor Table Purchases and Payables
Country/Region Code Field, Vendor Table Purchases and Payables
Tax Liable Field, Vendor Table Purchases and Payables
Territory Code Field, Vendor Table Purchases and Payables
Lead Time Calculation Field, Vendor Table Purchases and Payables
VAT Registration No. Field, Vendor Table Purchases and Payables
Outstanding Invoices (LCY) Field, Vendor Table Purchases and Payables
Payment Days Code Field, Vendor Table Spain Local Functionality
Telex Answer Back Field, Vendor Table Purchases and Payables
Purchases (LCY) Field, Vendor Table Purchases and Payables
Global Dimension 2 Filter Field, Vendor Table Purchases and Payables
Balance Due (LCY) Field, Vendor Table Purchases and Payables
Comment Field, Vendor Table Purchases and Payables
No. of Pstd. Credit Memos Field, Vendor Table Purchases and Payables
Payment Terms Code Field, Vendor Table Purchases and Payables
Pay-to No. of Invoices Field, Vendor Table Purchases and Payables
Fin. Charge Terms Code Field, Vendor Table Purchases and Payables
Pmt. Discounts (LCY) Field, Vendor Table Purchases and Payables
Date Filter Field, Vendor Table Purchases and Payables
Base Calendar Code Field, Vendor Table Purchases and Payables
Refunds Field, Vendor Table Purchases and Payables
No. of Pstd. Invoices Field, Vendor Table Purchases and Payables
Amt. Rcd. Not Invoiced Field, Vendor Table Purchases and Payables
Debit Amount Field, Vendor Table Purchases and Payables
Pay-to No. of Blanket Orders Field, Vendor Table Purchases and Payables
No. of Blanket Orders Field, Vendor Table Purchases and Payables
Outstanding Orders (LCY) Field, Vendor Table Purchases and Payables
Shipment Method Code Field, Vendor Table Purchases and Payables
IC Partner Code Field, Vendor Table Purchases and Payables
Primary Contact No. Field, Vendor Table Purchases and Payables
Amt. Rcd. Not Invoiced (LCY) Field, Vendor Table Purchases and Payables
Net Change (LCY) Field, Vendor Table Purchases and Payables
Pmt. Tolerance (LCY) Field, Vendor Table Purchases and Payables
Pay-to No. of Orders Field, Vendor Table Purchases and Payables
No. of Pstd. Return Shipments Field, Vendor Table Purchases and Payables
Address 2 Field, Vendor Table Purchases and Payables
Phone No. Field, Vendor Table Purchases and Payables
Gen. Bus. Posting Group Field, Vendor Table Purchases and Payables
No. of Quotes Field, Vendor Table Purchases and Payables
Payments Field, Vendor Table Purchases and Payables
Credit Amount (LCY) Field, Vendor Table Purchases and Payables
City Field, Vendor Table Purchases and Payables
No. Field, Vendor Table Purchases and Payables
Pay-to No. of Quotes Field, Vendor Table Purchases and Payables
Currency Filter Field, Vendor Table Purchases and Payables
Cr. Memo Amounts Field, Vendor Table Purchases and Payables
Creditor No. Field, Vendor Table General Ledger
Other Amounts (LCY) Field, Vendor Table Purchases and Payables
Pay-to No. Of Archived Doc. Field, Vendor Table Purchases and Payables
Block Payment Tolerance Field, Vendor Table Purchases and Payables
Pay-to No. of Pstd. Receipts Field, Vendor Table Purchases and Payables
Vendor Posting Group Field, Vendor Table Purchases and Payables
Pay-to No. of Credit Memos Field, Vendor Table Purchases and Payables
Shipping Agent Code Field, Vendor Table Purchases and Payables
No. of Orders Field, Vendor Table Purchases and Payables
Balance (LCY) Field, Vendor Table Purchases and Payables
Prepayment % Field, Vendor Table Purchases and Payables
Finance Charge Memo Amounts Field, Vendor Table Purchases and Payables
Name 2 Field, Vendor Table Purchases and Payables
Partner Type Field, Vendor Table Purchases and Payables
Budgeted Amount Field, Vendor Table Purchases and Payables
Search Name Field, Vendor Table Purchases and Payables
Payment Method Code Field, Vendor Table Purchases and Payables
Inv. Amounts (LCY) Field, Vendor Table Purchases and Payables
Global Dimension 1 Code Field, Vendor Table Purchases and Payables
Our Account No. Field, Vendor Table Purchases and Payables
Outstanding Invoices Field, Vendor Table Purchases and Payables
Balance Field, Vendor Table Purchases and Payables
Last Date Modified Field, Vendor Table Purchases and Payables
Telex No. Field, Vendor Table Purchases and Payables
Statistics Group Field, Vendor Table Purchases and Payables
Reminder Amounts Field, Vendor Table Purchases and Payables
Fin. Charge Memo Amounts (LCY) Field, Vendor Table Purchases and Payables
Balance Due Field, Vendor Table Purchases and Payables
Pay-to No. of Pstd. Return S. Field, Vendor Table Purchases and Payables
No. of Pstd. Receipts Field, Vendor Table Purchases and Payables
County Field, Vendor Table Purchases and Payables
Cash Flow Payment Terms Code Field, Vendor Table General Ledger
Giro Acc. No. Field, Vendor Table Denmark Local Functionality
Soc. Sec. Company Base Field, Vendor Table Italy Local Functionality
Delivery Reminder Terms Field, Vendor Table Switzerland Local Functionality
Tax Representative Type Field, Vendor Table Italy Local Functionality
Individual Person Field, Vendor Table Italy Local Functionality
Gender Field, Vendor Table Italy Local Functionality
Contribution Fiscal Code Field, Vendor Table Italy Local Functionality
Int. on Arrears Code Field, Vendor Table Italy Local Functionality
INAIL 3 Parties Base Field, Vendor Table Italy Local Functionality
Payment in progress (LCY) Field, Vendor Table France Local Functionality
Transaction Mode Code Field, Vendor Table Netherlands Local Functionality
Tax Representative No. Field, Vendor Table Italy Local Functionality
Registration No. Field, Vendor Table Switzerland Local Functionality
Resident County Field, Vendor Table Italy Local Functionality
Fiscal Code Field, Vendor Table Italy Local Functionality
Subcontractor Procurement Field, Vendor Table Italy Local Functionality
Apply Company Payment days Field, Vendor Table Italy Local Functionality
Residence County Field, Vendor Table Italy Local Functionality
Birth County Field, Vendor Table Italy Local Functionality
Birth Post Code Field, Vendor Table Italy Local Functionality
Subcontracting Location Code Field, Vendor Table Italy Local Functionality
First Name Field, Vendor Table Italy Local Functionality
Residence Country/Region Code Field, Vendor Table Italy Local Functionality
Birth City Field, Vendor Table Italy Local Functionality
Tax Exempt Amount (LCY) Field, Vendor Table Italy Local Functionality
Residence Post Code Field, Vendor Table Italy Local Functionality
Resident Field, Vendor Table Italy Local Functionality
Soc. Sec. 3 Parties Base Field, Vendor Table Italy Local Functionality
INAIL Code Field, Vendor Table Italy Local Functionality
Residence City Field, Vendor Table Italy Local Functionality
Last Name Field, Vendor Table Italy Local Functionality
Linked to Work Center Field, Vendor Table Italy Local Functionality
Social Security Code Field, Vendor Table Italy Local Functionality
Country of Fiscal Domicile Field, Vendor Table Italy Local Functionality
Date of Birth Field, Vendor Table Italy Local Functionality
Birth Country/Region Code Field, Vendor Table Italy Local Functionality
Subcontractor Field, Vendor Table Italy Local Functionality
Residence Address Field, Vendor Table Italy Local Functionality
INAIL Company Base Field, Vendor Table Italy Local Functionality
Withholding Tax Code Field, Vendor Table Italy Local Functionality

See Also

Reference

Vendor Card