Articles in this section

Migration to Header Level Posting (HLP) - AS Native Tax

  • Updated
Follow

Overview

For existing Accounting Seed users, migrating from Billing and Payable Line Level Posting (LLP) to Header Level Posting (HLP) will require some changes in your settings. The majority of the migration steps are related to page layouts. After you complete the steps in this article, contact Customer Support to enable HLP. 

Note: If you have the Orders & Inventory module installed, in order to enable Header Level Posting (HLP), you must be using the Weighted-Average Cost methodology.

Note: If you are installing Accounting Seed for the first time with our Iris release, HLP is the system default. Therefore, the migration process is unnecessary. 

Note: For information about using HLP, refer to the Billing Header Level Posting and Payable Header Level Posting articles. 

As part of the migration process, you should perform the following:

  1. Modify Existing in-use PDF Formats
  2. Update the Page Layout Configuration
  3. Modify Reports (include Billing and Payable fields)
  4. Post all Billings/Payables that have used AS Native Tax LLP
  5. Close out Prior Periods under LLP
  6. Contact Customer Support to switch over from LLP to HLP

Migration to Header Level Posting (HLP)

Modify Existing in-use PDF Formats

Modify any existing in-use PDF formats to reference the new Billing PDF pages for Product and Service. Otherwise, create new PDF formats to reference the new PDF pages for the following:

Note: For more information, refer to the Create a Custom PDF Format knowledge article.

Visualforce name:  

  • BillingProductIrisPDF 
  • BillingServiceIrisPDF

Update Page Layout Configuration 

For help with editing page layouts, refer to the Edit Standard Page Layouts Manually knowledge article.

Return to top

Billing

  1. Remove the following:
      1. Calc Tax (Accounting Seed Native Tax only) button
      2. Sales Tax (Existing field API name: AcctSeed.Sales_Tax2) field.
  2. Add the following fields:
      1. Sub-Total
      2. Sales Tax (New field API name: AccSeed.Sales_Tax3)
      3. Total.
  3. Add the Transactions related list.
    Note: In addition to the above, if you are using Salesforce Lightning, edit the Lightning page to add the Transactions related list. To add this related list, select the “Related List - Single” component. For more information refer to the Add a Single Related List section of the Edit Page to add a Lightning Component article. 
  4. Modify the Billing Lines related list properties to make sure the following are included:
    Note: Up to ten fields can be selected. Therefore, to add the below fields, you might need to remove some existing fields in the Related List Properties - Billing Lines dialog box. 
      1. Tax Group
      2. Sub-Total
      3. Tax Amount
      4. Total.

HLP_Migration_05.png

Billing Line

  1. Remove the Transactions related list.
  2.  Add the following fields:
      1. Tax Group
      2. Sub-Total
      3. Tax Amount
      4. Total.
  3. Edit the following to the MassAddEditRows field set:
      1. Sub-Total
      2. Tax Group
      3. Tax Amount.

After you complete the changes above, the Billing Line related list on the Billing screen should look similar to the below example screen. Also, the Transactions related list should be available.

HLP_Migration_01.png
Note: Click here to view the above image in full screen. 

Return to top

Product

  1. Remove the following fields:
      1. Tax Type
      2. Tax Rate.
  2. Remove the Taxes related list. 
  3. Add the Tax Group field.

Payable

  1. Remove the following:
      1. Calc Tax (AS Native Tax only) button
      2. Purchase Tax (Existing field API name: AcctSeed.Purchase_Tax2) field.
  2. Add the following fields:
      1. Sub-Total
      2. Purchase Tax (New field API name: AcctSeed.Purchase_Tax3)
      3. Total.
  3. Add the Transactions related list.
    Note: In addition to the above, if you are using Salesforce Lightning, edit the Lightning page to add the Transactions related list. To add this related list, select the “Related List - Single” component. For more information refer to the Add a Single Related List section of the Edit Page to add a Lightning Component article. 
  4. Modify the Payable Lines related list properties to make sure the following are included:
    Note: Up to ten fields can be selected. Therefore, to add the below fields, you might need to remove some existing fields in the Related List Properties - Payable Lines dialog box. 
      1. Unit Cost
      2. Sub-Total
      3. Tax Amount
      4. Total.

HLP_Migration_06.png

Payable Line

  1. Remove the Transactions related list.
  2. Add the following fields:
    1. Unit Cost
    2. Sub-Total
    3. Tax Amount
    4. Total (Existing field API name: AcctSeed.Amount).
      Note: This was previously labeled “Amount” and may already be on your page layout as “Total.”
  3. Edit the MassAddEditRows field set to include the following:
    1. Quantity
    2. Unit Cost
    3. Sub-Total
    4. Tax Group
    5. Tax Amount
    6. Total (Existing field API name: AcctSeed.Amount).

After you complete the changes above, the Payable Line related list on the Payable screen should look similar to the below example screen. Also, the Transactions related list should be available.

HLP_Migration_02.png
Note: Click here to view the above image in full screen. 

Return to top

Opportunity

  1. Add the Calc Tax button.
    Note: This is added for the Opportunity, but it is removed for the Billing and Payable objects. 
  2. Add the following fields:
      1. Tax Amount
      2. Total with Tax.
  3. Modify the Product related list to add the following: 
    Note: Up to ten fields can be selected. Therefore, to add the below fields, you might need to remove some existing fields. 
      1. Sub-Total
      2. (Optional) Discount
      3. (Optional) Total Price
      4. Tax Amount
      5. Total with Tax
      6. Tax Group.

Opportunity Product (line)

  1. Add the following fields:
      1. Sub-Total
      2. (Optional) Discount
      3. (Optional) Total Price
      4. Tax Amount
      5. Total with Tax
      6. Tax Group.

Recurring Billing

  1. Remove the Sales Tax (Existing field API name: AcctSeed.Sales_Tax) field.
  2. Add the following fields:
      1. Sub-Total
      2. Sales Tax 
      3. Total.
  3. Modify the Recurring Billing Lines related list to add the following:
    Note: Up to ten fields can be selected. Therefore, to add the below fields, you might need to remove some existing fields. 
      1. Sub-Total
      2. Tax Amount
      3. Tax Group.

Recurring Billing Line

  1. Add the following fields:
      1. Tax Group
      2. Sub-Total
      3. Tax Amount
      4. Total (Existing field API name: Acct.Total).

After you complete the changes above, the Recurring Billing Line related list on the Recurring Billing screen should look similar to the below example screen.

HLP_Migration_03.png
Note: Click here to view the above image in full screen. 

Recurring Payable

  1. Remove the Purchase Tax (Existing field API name: AcctSeed.Purchase_Tax) field.
  2. Add the following fields:
      1. Sub-Total
      2. Purchase Tax
      3. Total.
  3. Modify the Recurring Payable Lines related list to add the following:
    Note: Up to ten fields can be selected. Therefore, to add the below fields, you might need to remove some existing fields. 
      1. Unit Cost
      2. Sub-Total
      3. Tax Amount
      4. Total
      5. Tax Group.

Recurring Payable Line

  1. Remove the Transaction's related list. 
    Note: If you are using Salesforce Lightning, the Transaction related list should also be removed from the Lightning record page. 
  2. Add the following fields:
      1. Unit Cost
      2. Tax Group
      3. Sub-Total
      4. Tax Amount (Existing field API name: AcctSeed.Amount2).

After you complete the changes above, the Recurring Payable Line related list on the Recurring Payable screen should look similar to the below example screen.

HLP_Migration_04a.png
Note: Click here to view the above image in full screen. 

Return to top

Transaction

  1. Add the following fields:
      1. Billing
      2. Payable.

Modify Reports (include Billing and Payable fields)

  1. Transaction Detail by GL Account
  2. Project Net Profit

Post all Billings/Payables that have used AS Native Tax LLP 

It is necessary to post all Billings/Payables that have calculated taxes using Accounting Seed (AS) Native Tax LLP functionality. This is because of the two different ways that taxes are determined under Line Level Posting (LLP) versus Header Level Posting (HLP). If the taxes are not being calculated, then this is not necessary. However, it is considered a best practice to establish a cut-off in migrating from LLP to HLP. 

Close out Prior Periods under LLP

Best Practice: Close out prior periods under LLP.  Implement HLP at the inception of a new accounting period.

Contact Customer Support to switch over from LLP to HLP

After completing the migration process, contact Customer Support to switch over from Line Level Posting (LLP) to Header Level Posting (HLP). 

Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.