Modifier

Partager via


Third party miscellaneous charges

This article explains how to handle services that are purchased though a separate invoice as miscellaneous charges. The cost of these services can be included in the cost price of the purchased goods or written off as a cost, like the miscellaneous charges that are defined in the invoice for the purchase of goods. Additionally, the debt on these services can be redrawn to third parties, such as customers or vendors. In this case, a facture is created that won't be included in the sales book or purchase book.

You must purchase an item of the Service type to do the accounting as a miscellaneous charge that you will allocate later. You must also specify item-related parameters for the miscellaneous charges code.

There are three modes of miscellaneous charges allocation:

  • Include to the cost price – Allocate miscellaneous charges to other item invoices, so that the allocations can be included in an item's cost price. The allocation base is the invoice lines. The allocation causes the item's cost to be adjusted.
  • Redraw debt – Allocate miscellaneous charges to redraw debt to third parties. The allocation base is the counteragent (customer or vendor) that the debt is reissued on. The allocation causes the system to create invoices for payment and factures for the selected counteragent.
  • Write-off to cost – Allocate miscellaneous charges to the ledger account. The allocation base is the ledger account. The allocation causes the charges amount to be written off to the selected account.

Setup

Set up a charges code

  1. Go to Accounts payable > Charges setup > Charges code.

  2. Select New to create a charges code.

  3. In the Charges code field, enter a code for the charges.

  4. In the Description field, enter a description of the charges.

  5. Optional: In the Item sales tax group field, select an item sales tax group.

  6. In the Maximum amount field, enter the maximum amount that is allowed for this charges code. This field is used to validate charges for vendor invoices.

    Note

    To turn on the functionality for validating charges, on the Accounts payable parameters page, on the Invoice validation tab, set the Enable invoice matching validation option to Yes.

  7. On the Posting FastTab, in the Debit section, follow these steps:

    a. In the Type field, select Ledger account to post the purchased service as a miscellaneous charge.

    b. In the Posting field, select Allocation as the posting type for the debit account.

    c. In the Account field, select the account number that the amount on the purchase order or invoice journal line should be debited to.

  8. In the Credit section, in the Type field, select Customer/Vendor.

  9. Select Save.

Charges code page.

Create a released product for a service item

  1. Go to Product information management > Products > Released products to open the Released product details page.
  2. Create a product.
  3. In the Product type field, select Service.
  4. In the Item model group field, select the item model group for non-stocked items, and in the Item group field, select the item group for services.
  5. In the Tracking dimension group field, select a dimension group.
  6. In the Charges code field, select the charges code that you created earlier.

Released products page.

Set up a sales tax group that has exempt tax codes

If you must redraw debt for services that are provided to a third party, you can create a facture for redrawn amounts that isn't reflected in the purchase book or sales book. Set up the sales tax group so that it has the sales tax codes, and make sure that the Exempt check boxes are selected. After you complete this setup, the system won't generate ledger transactions for tax. However, the appropriate tax rate must be specified for the sales tax codes, to help guarantee that the printed form of the reissued invoice will reflect the tax.

  1. Go to Tax > Sales tax > Sales tax groups.
  2. Create a sales tax group.
  3. On the Setup FastTab, in the Sales tax code field, select the sales tax codes for all value-added tax (VAT) rates.
  4. For each sales tax code, select the Exempt check box to indicate that sales tax isn't calculated.
  5. Select Save.

Sales tax groups with tax exempt codes.

Define a transit tax group for a sales tax group

The transit tax group is used in the invoice that is created during the redraw debt transaction.

  1. Go to Tax > Sales tax > Sales tax groups.
  2. Create a sales tax group.
  3. On the General FastTab, in the Transit tax group field, select the sales tax group that has an exempt tax code that is used to redraw the charges.
  4. On the Setup FastTab, in the Sales tax code field, select the sales tax code.
  5. Select Save.

Sales tax groups with transit tax.

Set up a transit account

The transit general ledger account is the account that will be credited when transactions are redrawn to the third party. You must set up the ledger account to redraw charges to third parties.

  1. Go to Accounts payable > Setup > Accounts payable parameters.
  2. On the General tab, in the Transit account field, select the transit general ledger account to use during the redraw debt transaction.
  3. On the Number sequence tab, in the Number sequence code field, select a number sequence code for the Charges voucher, Allocation transaction, External vendor invoice, and Invoice for payment references.

Purchase services (charges) for allocation

You can purchase services for allocation either from the invoice journal or through a purchase order.

Purchase services (charges) from the invoice journal

  1. Go to Accounts payable > Invoices > Invoice journal.

  2. Create an invoice journal.

  3. Select Lines, and create a line.

  4. On the General tab, follow these steps:

    a. In the Sales tax section, select a sales tax group and an item sales tax group.

    Note

    If you redraw debt to third parties, you might want to select the sales tax group that has exempt tax codes.

    b. In the Charges section, in the Charges code field, select the charges code that you created in the Set up a charges code section.

Vendor invoice journal page.

  1. Specify other details, and then post the journal.

Purchase services (charges) through a purchase order

  1. Create a purchase order.

  2. On the purchase order lines, select the service that you created earlier.

  3. On the Setup tab, follow these steps:

    a. In the Sales tax section, select an item sales tax group and the sales tax group that you created earlier.

    Note

    If you redraw debt to third parties, you might want to select the sales tax group that has exempt sales tax codes.

    b. In the Charges section, in the Charges code field, verify that the charges code that you created earlier is selected.

    c. In the Posting section, in the Ledger account field, verify that the debit account that you specified for the charges code that you created earlier is selected.

All purchase orders page, Setup tab.

  1. On the Product tab, in the Inventory profile field, select an inventory profile.

All purchase orders page, Product tab.

  1. Specify other purchase order details, and post the invoice.

Allocate charges

You can allocate miscellaneous charges on the Charges allocation page. This page has three parts:

  • The Allocation source section shows the invoice lines that will be allocated.
  • In the Allocation base section, you can select the invoice lines that miscellaneous charges from the Allocation source section will be allocated to.
  • The lower-right part shows the result of the allocation of source lines amounts on the base line.

Allocate miscellaneous charges to the item cost price

  1. Go to Accounts payable > Inquiries and reports > Invoice > Invoice journal.

  2. Select the invoice for the purchase order that you created earlier that includes the service. Then select Charges > Allocation.

    Invoice journal page, Charges drop-down.

  3. On the Charges allocation page, select Edit.

    Edit the Charges allocation page.

  4. In the Charges allocation field, select one of the following methods for allocating miscellaneous charges:

    • Net amount – Charges are allocated according to each line amount, relative to the total net amount of the service invoice.
    • Quantity – Charges are allocated according to the number of units for each line, relative to the total number of units for the service invoice.
    • Gross weight – Charges are allocated equally, according to the gross weight of the items that are received.
    • Volume – Charges are allocated equally, according to the volume of the items that are received.
  5. In the Posting date field, select the posting date.

  6. In the Allocation mode field, select one of the three modes of miscellaneous charges allocation:

    • Include to the cost price
    • Redraw debt
    • Write-off to cost

    To allocate charges to the cost price of the products, select Include to the cost price.

  7. In the Allocation base section, select Choose to specify the selection criteria that are used to transfer the invoice lines to the allocation base.

  8. In the Choose dialog box, select Add to add a line, and enter the following line details:

    • In the Table field, select a value.
    • In the Field field, select the field that you're specifying the criteria for. In the Criteria field, enter the criteria.
  9. Select OK. The allocation base lines are created.

  10. In the Allocation source section, select the Select check box for a posted miscellaneous charges invoice. In the Available for allocation field, you can change the amount that is available for allocation.

  11. In the Allocation base section, select the Select check box for the invoice lines that the miscellaneous charges should be allocated to.

  12. Select Allocation to allocate the miscellaneous charges. The amounts on the selected source lines are allocated to all the selected base lines. You can view the result of the allocation in the lower-right part of the page. For every line from the allocation base, the allocation amount and the miscellaneous charges code are shown.

    Note

    • You can change the method of allocation in the Allocation method field as you require. You will then receive a message that prompts you to recalculate the lines of the allocation result. Select Yes to recalculate the result.
    • You can manually adjust the allocation result in the Amount field in the lower-right part of the page. If the value that you enter exceeds the total amount that is available for allocation, you receive an informational message.
  13. Select Post to post the allocation transaction.

  14. Select Inquiries > Voucher to view the transactions that are created because of allocation.

Allocate miscellaneous charges to redraw debt to third parties

  1. On the Invoice journal page, select the invoice for the purchase order that you created earlier that includes the service. Then select Charges > Allocation.

    Charges allocation page to allocate miscellaneous charges.

  2. In the Charges allocation field, select a method for allocating miscellaneous charges.

  3. In the Posting date field, select the posting date.

  4. In the Allocation mode field, select Redraw debt.

  5. In the Allocation base section, specify whether the customers or vendors can redraw debts automatically or manually:

    a. Automatic: Select Choose, specify the selection criteria, and then select OK. The allocation base lines are automatically created.

    Note

    Allocation base lines are grouped by the Counteragent type, Agreement ID, and Posting profile fields. If there are invoices for one counteragent, but the values of these parameters differ, there will be several lines for that counteragent in the allocation base.

    b. Manual: To manually create allocation base lines, select New. In the Counteragent type field, select Customer or Vendor. In the Account number field, select the number of counteragent account. You can also select values in the Agreement ID and Posting profile fields.

  6. Select the source and base lines for the allocation, and then edit the Available for allocation field as you require.

  7. Select Allocation to allocate the miscellaneous charges. The amounts on the selected source lines are allocated to all the selected base lines. You can view the result of the allocation in the lower-right part of the page. For every line from the allocation base, the allocation amount and the miscellaneous charges code are shown.

    Note

    • For manually created allocation base lines, the result of the allocation is 0 (zero). In this case, you must manually enter the miscellaneous charges amounts in the Amount field in the lower-right part of the page. You can also change the amounts for automatically created allocation base lines. If the value that you enter exceeds the total amount that is available for allocation, you will receive an informational message.
    • You can change the method of allocation in the Charges allocation field. For automatically created allocation base lines, the amounts will be recalculated. For manually created allocation base lines, the amounts that you entered will be set to 0 (zero).
  8. Select Post to post the allocation transaction.

  9. In the Posting dialog box, follow these steps:

    a. Set the Credit correction option to Yes to post the allocation as a storno transaction. Otherwise, the allocation will be created as a reverse transaction.

    b. Set the Create invoice for payment option to Yes to create an invoice for payment when the allocation is posted.

    c. Select OK. The operation for reissuing debt to counteragents is performed. Transactions will be created for all selected lines in the allocation result.

    Because of posting, one of the following events occur, depending on whether the invoice that includes the service for allocation was created from the vendor invoice journal or through a purchase order:

  • If the invoice was created from the vendor invoice journal:

    • If you redraw debt to vendors, the invoice journals are automatically created and posted. If you set the Create invoice for payment option to Yes, the invoice for payment will automatically be posted.

    • If you redraw debt to customers, free text invoices are automatically created. The invoices for sales orders and payments are automatically posted.

  • If the invoice was created through a purchase order:

    • If you redraw debt to vendors, the purchase orders that invoices will be posted on are automatically created. If you set the Create invoice for payment option to Yes, the invoice for payment will automatically be posted,

    • If you redraw debt to customers, sales orders are automatically created. The invoices for sales orders and payments will automatically be posted.

  1. Select Inquiries > Voucher to view the transactions that are created because of allocation.

Example

  1. Create a sales tax group that is named VAT18-1 and that has sales tax code VAT18.

    Sales tax groups page with selected tax group and tax code.

  2. Create an exempt sales tax group that has standard sales tax code VAT18, and select the Exempt check box.

    Exempts check box selected.

  3. For the sales tax group, in the Transit tax group field, specify the exempt sales tax group.

    Sales tax groups page, Transit tax group field.

  4. Create an item sales tax group that has sales tax code VAT18.

    Item sales tax group.

  5. Set up transit account 76.511. For instructions, see the Set up a transit account section.

  6. Set up the following two charges codes. For instructions, see the Set up a charges code section.

    Charges code Account
    Loading 76.511
    Unloading 26.1
  7. Create two released products that have the same names as the charges codes that you created in the previous step. For each released product, in the Charges code field, specify the charges code that has the same name.

  8. Create a purchase order for services (miscellaneous charges) that has the following two lines.

    Item number Quantity Unit price Sales tax group Item sales tax group
    Loading 1 1,000
    Unloading 1 2,000 VAT18-1 VAT18
  9. Post the invoice for the service (miscellaneous charges) purchase, where the total amount is 3,360 Russian rubles (RUB). This amount includes a VAT amount of 360 RUB. The following transactions are generated on the invoice.

    Ledger account Corr. Account Currency Amount in transaction currency Amount Date
    76.511 60.11 RUB 1,000 1,000 10/18/2019
    26.1 60.11 RUB 2,000 2,000 10/18/2019
    19.3 60.11 RUB 360 360 10/18/2019
  10. On the Invoice journal page, select Charges > Allocation.

  11. On the Charges allocation page, in the Posting date field, specify 10/18/2019.

    Charges allocation page, Posting date field.

  12. In the Allocation mode field, select Redraw debt.

  13. In the Allocation base section, manually create the following line.

    Counteragent type Account number Name Posting profile
    Customer RUF-000002 Звукоряд ТД Общий
  14. Select the source line that has the Loading reference in the Item field, select the base line for the allocation, and then select Allocation.

  15. In the lower-right part of the page, in the Amount field, enter 1000 for allocation for charges code Loading.

  16. Select Post.

  17. In the Posting dialog box, follow these steps:

    a. Set the Credit correction option to No.

    b. Set the Create invoice for payment option to Yes.

    c. Select OK.

    After the allocation is posted, you receive a message that contains information about the sales order that was created for the customer. You can then open the sales order to view the invoice transactions that were generated and the following voucher.

    Date Ledger account Corr. Account Currency Amount in transaction currency Amount
    10/18/2019 62.11 76.511 RUB 1,000.00 1,000.00

    Because of posting, the corrective invoice for the amount of redrawn debt was created. This invoice isn't included in the sales book.

  18. To view the information about the allocation of debt, on the Invoice journal page, select Charges > Misc. charges allocation history. Then, in the Allocation mode field, select Redraw debt.

Allocate miscellaneous charges to the ledger account

  1. On the Invoice journal page, select the invoice for the purchase order that you created earlier that includes the service. Then select Charges > Allocation.

    Charges allocation page to allocate miscellaneous charges to the ledger account.

  2. In the Charges allocation field, select a method for allocating miscellaneous charges.

  3. In the Posting date field, select the posting date.

  4. In the Allocation mode field, select Write-off to cost.

  5. In the Allocation base section, specify the ledger accounts that miscellaneous charges will be written off on.

  6. Select New to create the allocation base line.

  7. In the Main account field, select a main account.

  8. Select the source and base lines for the allocation, and then edit the Available for allocation field as you require.

  9. Select Allocation to allocate the miscellaneous charges. The system creates lines where the amount is 0 (zero). For each selected allocation base line, in the Amount field in the lower-right part of the page, enter the amount of the miscellaneous charges.

    Note

    If the value that you enter exceeds the total amount that is available for allocation, you will receive an informational message.

  10. Select Post to post the allocation transaction. The operation for writing off miscellaneous charges to the ledger account is performed. Transactions are created for all selected lines in the allocation result.

  11. Select Inquiries > Voucher to view the transactions that are created because of allocation.

View the miscellaneous charges that are allocated to the item's cost price

The cost price of an item can be adjusted many times by using the functionality for miscellaneous charges allocation. You can view the transactions that adjust the cost of an item on the Settlements and Cost explorer pages. A warehouse closing operation must be done first.

  1. Go to Product information management > Products > Released products to open the Released product details page.

  2. Select an item, and then, on the Action Pane, on the Manage Costs tab, in the Cost transactions group, select Transactions to open the Inventory transactions page.

  3. Select the transaction on the receipt item that you want to explore the cost structure for.

  4. To view inventory cost adjustment transactions, on the Action Pane, on the Inventory tab, in the Costing group, select Settlements. The Settlements page includes the following fields:

    • Charges code – The miscellaneous charges code that has been allocated to the item receipt transaction.
    • Vendor account – The account of the vendor that the miscellaneous charges were purchased from.
    • Invoice – The invoice number of the miscellaneous charges purchase.

    Settlements page.

    Note

    If the Vendor account and Invoice fields aren't filled in, the cost adjustment operation was done by the standard method for miscellaneous charges allocation.

  5. To view more information about the list and the amounts of miscellaneous charges that have been included in the cost price of the posted item, on the Inventory transactions page, on the Action Pane, on the Inventory tab, in the Costing group, select Cost explorer.

    Cost explorer page.

View the allocation history for miscellaneous charges

View the allocation history from the invoice journal

  1. On the Invoice journal page, select purchase invoice that you created earlier that includes the service.

  2. Select Charges > Misc. charges allocation history to open the Charges allocation page. The Allocation base section shows the allocation base and allocation result, depending on the value in the Allocation mode field. To change the allocation mode, select Edit, and then, in the Allocation mode field, select a new value.

    Charges allocation page, Allocation base section.

  3. On the header of the Charges allocation page, set the Show cancelled operations option to Yes to show the miscellaneous charges allocation transactions that have been canceled and the transactions that adjust them.

  4. Select Inquiries > Voucher to view the transactions that were created because of allocation.

View the allocation history

The allocation history can be shown either for a specific invoice or for all invoices that the miscellaneous charges allocation operation was performed on.

  1. Go to Accounts payable > Inquiries and reports > Misc. charges allocation history.

  2. Select Edit, and then, in the Start date and End date fields, specify a period to filter the invoices for the purchase of miscellaneous charges.

    The Allocation source section shows the source lines for all invoices from the period. The Allocation base section shows the allocation base and allocation result.

    Charges allocation page, Allocation source section.

Cancel miscellaneous charges allocation

  1. Go to Accounts payable > Inquiries and reports > Misc. charges allocation history. Alternatively, on the Invoice journal page, select Charges > Misc. charges allocation history.

  2. In the Allocation mode field, select the allocation mode to cancel the allocation for.

  3. Select the lines to cancel.

    Note

    Lines that were created by one allocation operation can't be partially canceled. If you select one line from an allocation operation, all lines from that operation are automatically selected.

  4. In the Date of cancellation field, enter the date of cancellation.

    Charges allocation page, Date of cancellation field.

  5. Select Cancel.

    Note

    • If the date of cancellation is before the date of at least one transaction that is marked for cancellation, the operation won't be performed, and you will receive an error message.
    • If the redrawing of debt is being canceled, you will receive an informational message that contains links to the documents that were created for customers or vendors.
  6. Select Inquiries > Voucher to view the transactions that were created because of allocation cancellation.