Defining Inventoried Product GL Accounts

This task is used to define receivable, pre-payment liability, write-off, cancellation, and discount transactions, as well as the pay priority of a given product within an order. Also, this task defines tax categories (e.g. US, GST, and VAT).

Details associated with this task should not be defined without input from the Accounting/Finance department.

The accounts pre-populate based on the default accounts defined for the INV subsystem on the Organizational Unit Maintenance > Product Accounts screen. You can, however, use the links to search for other accounts related to the product.

Once an order line exists for this product with the same effective date as the one setup here, with Line Status not equal to 'C', then the GL accounts for that effective date cannot be changed for this product.

To define the General Ledger accounts:

1. From the Personify360 main toolbar, select Products > Product Central.
The Product Maintenance search screen displays.

2. Click Search to find a product or click Create New Product.

3. From the Product Definition task category, click Define GL Accounts.
The General Ledger Accounts screen displays with a GL account row already added to the table, as shown below.

4. If necessary, change the Begin Date.

5. Enter the Pay Priority.

6. Click the Receivable Account link to search for a receivable account.
The Prepayment Liability account populates automatically based on the AR-PPL account pairs set up in System Setup.

7. Click the Writeoff Account link to search for a write-off account.

8. Click the Cancellation Account link to search for a cancellation account.

9. Click the Discount Account link to search for a discount account.

10. Click the Deferred Discount link to search for a deferred discount.

11. Click the Agency Discount link to search for an agency discount.

12. Click the Deferred Agency link to search for a deferred agency.

The options in the Tax/VAT Control section will be enabled or disabled depending on your organization unit setup. For more information, please see Configuring Tax Defaults for more information.

13. If the product uses sales tax, perform the following:

a. From the Tax/VAT Control, select the Taxable checkbox.

b. Select the Tax Category from the drop-down.

14. If the product uses VAT tax, perform the following:

a. From the Tax/VAT Control, select the Taxable checkbox.

b. Select the VAT Category from the drop-down.

15. If the product uses both VAT and sales tax, perform the following:

a. From the Tax/VAT Control, select the Taxable checkbox.

b. Select the Tax Category from the drop-down.

c. Select the VAT Category from the drop-down.

16. If the product uses VAT tax for every customer purchasing the product, regardless of the ship-to address, from an EU (European Union) country, perform the following:

a. From the Tax/VAT Control, select the Charge VAT to All Customer checkbox.

b. Select the VAT Country from the drop-down.

c. Select the VAT Category from the drop-down.

17. In the Revenue Recognition section, select the Recognition Method from the drop-down.

18. If you selected “On Specific Date,” then select the Recognition Date from the drop-down.

19. Click Save.

Screen Element	Description
General Ledger Accounts
Define Accounts	Button. When clicked, an Effective Date row is added to the table and another set of General Ledger accounts are added to the product.
Effective Date	Table row. Represents a General Ledger account associated with the product. The date listed is correlated with the Begin Date value.
Delete Account	Button. When clicked, the highlighted row and the General Ledger account is deleted from the product.
Account Detail
Begin Date	Drop-down. The start date for the General Ledger account. The Begin Date of the first set of GL Accounts defined defaults to the Available from date from the General Product Setup screen. The Begin Date of each additional set added after the first defaults to today’s date.
End Date	Read-only. The end date is automatically populated to one day before the next Begin Date of the next set of GL accounts.
Pay Priority	Text box. Establishes the order by which line items on a multi-product order are paid. Associations that discount inventoried prices on items may assign products a preferred priority to ensure the inventory line item is paid prior to line items from other subsystems. The lowest priority number is paid first, with zero being paid before any other. Additional system pay priorities may be defined at the system level for the Inventoried Products subsystem.
Receivable Account	Link. When clicked, you can search for the appropriate AR and prepayment account pairs, as defined on the Organization Unit Maintenance screen (see Defining AR and Prepayment Account Pairs).
Prepayment Liability	Read-only. Defaults based on the receivable account identified above. This is the account that is used to store payments prior to invoicing.
Writeoff Account	Link. When clicked, you can search for the appropriate write-off account. When a write-off of an open balance (including tolerance write-offs) is created, the transaction is DR Write-off Account, CR Accounts Receivable. The account must be either an income or expense account.
Cancellation Account	Link. When clicked, you can search for the appropriate cancellation account. When cancellation fees are charged, this account is used. It is typically an unearned income account, though it may also be defined as an expense account.
Discount Account	Link. When clicked, you can search for the appropriate discount account. When a discount is granted for this product, this account number is used. It reduces the AR number while maintaining the full revenue account amount. It may be either a revenue or expense account.
Deferred Discount	Link. When clicked, you can search for the appropriate deferred discount account. When a deferred revenue transaction is created, this account is used. If no deferred transactions are expected, this account should be the same as the discount account.
Agency Discount	Link. When clicked, you can search for the appropriate agency discount account. When a discount is granted to the agency for this product, this account number is used. It reduces the AR number while maintaining the full revenue account amount. It may be either a revenue or expense account.
Deferred Agency	Link. When clicked, you can search for the appropriate deferred agency account. When a deferred revenue transaction is created for an agency, this account is used. If no deferred transactions are expected, this account should be the same as the agency discount account.
Tax/VAT Control
Taxable	Checkbox. When checked, indicates the product is taxable for sales tax. If this is checked and the product uses sales tax, select the Tax Category. If this is checked and the product uses VAT tax, select the VAT Category. If this is checked and VAT tax should be charged for all customer regardless of ship-to address, select the Charge VAT to All Customer checkbox and select VAT Country and VAT Category.
Charge VAT to All Customers	Checkbox. When checked, indicates the product is taxable for value-added tax. This checkbox is only enabled if the Taxable checkbox is selected. If this is checked, select the VAT Country and VAT Category.
Tax Category	Drop-down. Further defines how taxes will be calculated. This checkbox is only enabled if the Tax/VAT Control drop-down on the Organization Unit Maintenance screen is set to B or N and if the Taxable checkbox is selected. If HST or GST tax is collected for this product, setup the country and state code in a tax category that is also used for US state tax on the Sales Tax Maintenance (ORD199) screen. Values in the drop-down are populated based on the non-fixed codes defined for the ORD "TAX_CATEGORY" system type.
VAT Country	Drop-down. The country in which the value-added tax will be used for this product. This checkbox is only enabled if the Tax/VAT Control drop-down on the Organization Unit Maintenance screen is set to B or Y and if the Taxable checkbox is selected.
VAT Category	Drop-down. Indicates which type of value-added tax is charged for this product. Values in the- drop-down are populated based on the non-fixed codes defined for the ORD "VAT_CATEGORY" system type.
Revenue Recognition
Recognition Method	Drop-down. Controls how revenue recognition for the order will be handled. Options include: · On Invoice: selected by default for inventoried products. · On Specific Date: typically not used for inventoried products. · At Year End: refers to the fiscal year end; typically not used for inventoried products. Values in the drop-down are populated based on the fixed codes defined for the INV "REVENUE_RECOG_METHOD" system type.
Recognition Date	Drop-down. Enabled when Recognition Method value is “On Specific Date.” Indicates the specific date that revenue should be recognized. After this date, sales transactions will hit the real revenue account rather than the deferred revenue account. As of 7.6.1, if the Recognition Method is set to "On Specific Date" and a date has NOT been defined, you will NOT be able to validate the product.