Skip to main content
office-kit.com main content

Cell Name Reference

- Document for Excel Invoice Manager

 Share This Page

This version of the document, "Cell Name Reference", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.

1. When you click the Customer-Selection icon button and select a customer, certain fields in the Customer table are written to the Invoice worksheet. The following chart shows you all field names and their matching cell names.

Field NameCell Name
CustomerIdoknWhoID
CustomerNameoknWhoName
AddressoknWhoAddress
PhoneoknWhoPhone
CountryoknWhoCountry
EmailoknWhoEmail
AccountBalanceoknAccountBalance
CityState, ZipoknWhoCityStateZip
CreditoknCredit
AccountBalanceoknAccountBalance
CategoryoknWhoCategory
(All custom fields)okn(Field Name)

2. When you click the Product-Selection icon button and select a product, certain fields in the Product table are written to the Invoice worksheet. The following chart shows you all field names and their matching cell names. ("**" in the chart indicates line number in the invoide body.)

Field NameCell Name
ProductIDoknProductID_**
ProductNameoknProductName_**
PriceoknPrice_**
CostoknCost_**
TaxableoknTaxable_**
(All custom fields)okn(Field Name)_**

3. In Excel Invoice Manager, cells on the worksheets are identified by names. This design allows you to move the cells to a proper position you like. Each worksheet has its own predefined cell name prefix.

WorksheetCell Name Prefix
Invoiceokn
Sales ReportoknRs
Customer ReportoknRc
Product ReportoknRp
Customer StatementoknCs
Sales Rep. ReportoknRr
Payment ReportoknPr