Valid Setup Examples

You can use many different setup scenarios to bill units.

The effect on the various tables depends on the function codes used and the unit cost of sales method. Several valid scenarios, along with their effect on the General Ledger Detail and Open Billing Detail tables, are presented below:

Valid Scenario #1

  • Incurred Cost of Sales Method
  • UNITS Function Code (on the Manage Account Groups screen) to record unit usage on the Manage Unit Usage screen.
  • Cost of Sales Account, Warranty Accrual Account, and Warranty Expense Account Transaction Type on the Set Up Sales Group Abbreviations screen to record COGS and warranty expense accrual

Unit Usage Posting

General Ledger:

Item Value Value
Dr. Units Cost of Goods Sold 1,000
     Cr. Units Clearing 1,000
Dr. Warranty Expense 150
     Cr. Warranty Accrual 150

Open Billing Detail:

Only the unit usage is posted to the Open Billing Detail table and is eligible for inclusion on a standard bill. Costpoint determines the amount billed by multiplying the unit quantity by the unit price. These records in the Open Billing Detail table have a UNITS Transaction Type on the Manage Open Billing Detail screen and have the Units group box and Units subtask completed. COGS and warranty expense accruals do not populate the Open Billing Detail table because they use a UNITS Function Code.

Valid Scenario #2

  • Incurred Cost of Sales Method
  • NON-LABOR Function Code (on the Manage Account Groups screen) to record unit usage
  • Cost of Sales Account, Warranty Accrual Account and Warranty Expense Account Transaction Type on the Set Up Sales Group Abbreviations screen to record COGS and warranty expense accrual

Unit Usage Posting

General Ledger:

Item Value Value
Dr. Units Cost of Goods Sold 1,000
     Cr. Units Clearing 1,000
Dr. Warranty Expense 150
     Cr. Warranty Accrual 150

Open Billing Detail:

Only unit COGS and warranty expense records are posted to Open Billing Detail. Costpoint determines the amount billed by the amount of COGS and warranty expense recorded. These records in the Open Billing Detail table have a COST Transaction Type on the Manage Open Billing Detail screen and have the Cost group box completed. The unit usage does not populate the Open Billing Detail table because it uses a NON-LABOR Function Code.

Valid Scenario #3

  • Billed Cost of Sales Method
  • UNITS Function Code (on the Manage Account Groups screen) to record unit usage
  • Cost of Sales Account, Warranty Accrual Account and Warranty Expense Account Transaction Type on the Set Up Sales Group Abbreviations screen to record COGS and warranty expense accrual

Unit Usage Posting

General Ledger:

No effect until the bill is posted.

Open Billing Detail:

Unit usage records are posted to the Open Billing Detail table when the unit usage is posted. The COGS and warranty expense accruals do not populate the Open Billing Detail table because they have a UNITS Function Code.

Bill Posting

Item Value Value
Dr. Billed A/R 2,350
     Cr. Unbilled A/R (or Sales) 2,000
     Cr. Sales Tax 50
     Cr. Other Charges 300
Dr. Units Cost of Goods Sold 1,000
     Cr. Units Clearing 1,000
Dr. Warranty Expense 150
     Cr. Warranty Accrual 150