Vendor Balance Conversion

The Vendor Balance Conversion file is used by the Vendor Conversion program to convert vendor balance records to the Lawson Accounts Payable system. When you run AP510 (Vendor Conversion), the system reads records in this file for conversion into the Vendor Balance file. When Vendor Balance Conversion records are successfully converted, they are purged from this file.
UPDATED BY

AP51.1

AP51.2

AP510

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CVB-VENDOR-GROUP Element: Vendor Group	Alpha 4 Required. The vendor group. Must be a valid record in the Vendor Group file.
CVB-VENDOR Element: Vendor	Alpha 9 (Right Justified) The vendor number. Required if not using automatic vendor numbering.	AP510
CVB-LOCATION-CODE Element: Location Code	Alpha 4 The alternate vendor location. Represents an alternate remittance or purchasing location for the vendor.
CVB-COMPANY Element: Company	Numeric 4 Required. The company number associated with the vendor. Must be a valid record in the Accounts Payable Company file.
CVB-OLD-VENDOR Element: Vendor	Alpha 9 (Right Justified) Required if using automatic vendor numbering. The vendor's number as it existed before conversion to the Lawson Accounts Payable system.
CVB-LAST-PMT-DATE Element: Last Pmt Date	Numeric 8 (yyyymmdd) The date of the last payment made to the vendor or alternate vendor location.
CVB-LAST-PUR-DATE Element: Date	Numeric 8 (yyyymmdd) The date of the last purchase made by the vendor or alternate vendor location.
CVB-HIGHEST-BAL Element: Intl Amt	Signed 18.2 The highest open purchase balance ever reached for the vendor or alternate vendor location.
CVB-CURRENT-BAL Element: Intl Amt	Signed 18.2 The current open purchase balance (the amount of released, or open, invoices) for the vendor or alternate vendor location.
CVB-CY-INC-WH Element: Intl Amt	Signed 18.2 The amount of reportable income withholding (such as 1099 reportable income) for the vendor for the current vendor group year.
CVB-LY-INC-WH Element: Intl Amt	Signed 18.2 The amount of reportable income withholding (such as 1099 reportable income) for the vendor for the last vendor group year.
CVB-CP-PURCH Element: Intl Amt	Signed 18.2 Occurs 14 Times The amount of purchase activity for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store purchase activity dated after the end of the current vendor group year. When you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to period one of the new vendor group year.
CVB-LY-PURCH Element: Intl Amt	Signed 18.2 Occurs 13 Times The amount of purchase activity for the vendor or alternate vendor location for each period of the last vendor group year.
CVB-CP-PAYMENT Element: Intl Amt	Signed 18.2 Occurs 14 Times The amount of payment activity for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store payment activity dated after the end of the current vendor group year. When you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to period one of the new vendor group year.
CVB-LY-PAYMENT Element: Intl Amt	Signed 18.2 Occurs 13 Times The amount of payment activity for the vendor or alternate vendor location for each period of the last vendor group year.
CVB-CP-DSCTAKE Element: Intl Amt	Signed 18.2 Occurs 14 Times The amount of the discounts taken for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store discounts taken activity dated after the end of the current vendor group year. When AP199 (Vendor Balance Year End) is run, any balance in the 14th period will be transferred to period one of the new vendor group year.
CVB-LY-DSCTAKE Element: Intl Amt	Signed 18.2 Occurs 13 Times The amount of the discounts taken for the vendor or alternate vendor location for each period of the last vendor group year.
CVB-CP-DSCLOST Element: Intl Amt	Signed 18.2 Occurs 14 Times The amount of the discounts lost for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store discounts lost activity dated after the end of the current vendor group year. When you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to period one of the new vendor group year.
CVB-LY-DSCLOST Element: Intl Amt	Signed 18.2 Occurs 13 Times The amount of the discounts lost for the vendor or alternate vendor location for each period of the last vendor group year.
CVB-CP-GAINLOS Current Period Gain or Loss	Signed 18.2 Occurs 14 Times The amount of the currency gain or loss activity for the vendor or alternate vendor location for each period of the current vendor group year. Note: The 14th period is used to store currency gain and loss activity dated after the end of the current vendor group year. When you run AP199 (Vendor Balance Year End), any balance in the 14th period will be transferred to period one of the new vendor group year.
CVB-LY-GAINLOS Last Year's Gain or Loss	Signed 18.2 Occurs 13 Times The amount of currency gain or loss activity for the vendor or alternate vendor location for each period of the last vendor group year.
CVB-CP-NBR-PMTS Element: Nbr Pmts	Signed 6.0 Occurs 14 Times
CVB-LY-NBR-PMTS Element: Nbr Pmts	Signed 6.0 Occurs 13 Times

APCVENBAL FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.