Solid Waste Fee Report

Overview

• AATC needs to collect Solid Waste Fees for about 25 items.

• There are two types of fees:

  • Tire Solid Waste Fee, per unit charge, $1

  • Battery Solid Waste Fee, per unit charge, $1.5

• AATC could collect both fees for certain items.

• AATC collects a Tire Solid Waste Fee when selling trailers for the number of tires that the trailer has.

  • On Item page, enter No. of Tires field.

• Both fees are taxable

Setups

• On the Item page, add two check box fields:

  • Collect Tire Solid Waste Fee

  • No. of Tires (for Trailer items)

  • Collect Battery Solid Waster Fee

• On the Company Setup page, add 4 fields:

  • Tire Solid Waste Fee Service Item, an item lookup field.

    • Must point to a Liability GL Account on APS for the item. (ask AATC)

  • Battery Solid Fee Service Item, an item lookup field.

    • Must point to a Liability GL Account on APS for the item (ask AATC)

  • Tire Solid Waste Fee Amount

  • Battery Solid Waste Fee Amount

Saving Sales Quote/Order

• System will automatically create Sales Lines for the Tire Solid Waste Fee and Battery Solid Waste Fee.

• Users can update both service lines manually.

Sales Invoice Process

• When creating Sales Invoices from Sales Orders, test to make sure the Tire Solid Waste Fee and Battery Solid Waste Fee are added with the right amount.

• When posting Sales Invoices, test to make sure the Tire Solid Waste Fee and Battery Solid Waste Fee are added with the right amount.

• Users can update both service lines manually.

Accounting Variable1

• Write a trigger on the Sales Invoice Line to populate Accounting Variable 1 using the Warehouse name on the Sales Invoice Header. Done, used the warehouse name to find a match in accounting variables.

• Turn on Accounting Variable 1 Required for all Income Statement GL Accounts and certain Liability and Fixed Asset GL Accounts. (ask AATC), waiting for AATC

  • AATC uses Fixed Asset GL Accounts to run tangible tax reports.

Solid Waste Reports

• Reports can be created using the GL Entries for the specific Liability GL Accounts, grouped by Accounting Variable 1.

• Users can create AP Invoices to record the payable for the month to offset the Liability GL Accounts.

• Users can then pay the AP Invoices.