Full Revenue
Written by Brandy Burch
Updated at January 17th, 2025
Overview
We have added the ability to import a file from Open Invoice. Open Invoice will compile the submitted data into this new import format. The user has to have a relationship with Open Invoice, just like they do for CDEX imports. The user must tell them what format they want their file to have. There is some setup involved in using this new import format.
Setup
We have added a new field to the Revenue Account Maintenance for accounts with the category of Taxes or Other. This field is used to identify the CDEX transaction code that should be associated with the Tax category and Other deductions category accounts. The drop-down box has the options accepted by Open Invoice. These descriptions are tied to a specific transaction code in the Oildex Revenue Detail (CDEX) Data Guide.
A new column has been added to the Check Stub > Company Maintenance > Stub Line Items menu to associate the Taxes and Other deductions transaction codes to the stub line items.
The selected type is validated against the Type of Item and the Type of %. A Tax must be set to Taxes and Tax. Other deductions must have the Type of Item set to Other and the Type of % to Revenue.
Use
Two new menu items have been added to the Import Menu – Full Revenue List and Full Revenue Import. These both function similarly to the CDEX and General Imports.
Full Rev List can be used to review the file before importing it.
Full Revenue Import can be used to import the file.
