• In progress

    • Cost Adjustment/Settlement Wizard

    Owned by Agnes Sigurþórsdóttir (Unlicensed)
    Last updated: Feb 23, 2023
    4 min read

    When the user wishes to change values in Sales or Purchase Invoices without moving inventory through the system, the best way to do that is through item charges by using the Cost Adjustment/Settlement Wizard.

    If incorrect information is noticed after the posting of a Receipt or Delivery Agreements, the Cost Adjustment/Settlement Wizard is programmed to assists users through a step by step guide to change and correct the values.

    The Wizard can be used to change values, currency and/or customer/vendor.

    Open the Cost Adjustment/Settlement Wizard

    The Wizard is programmed to function through the agreements so the first thing the user must do is find the number of the agreement he wants to change.

    When the appropriate Agreement has been found and opened select Cost Adjustment/Settlement Wizard from the Action tab on the ribbon.

    Step 1

    On the first page of the Cost Adjustment/Settlement Wizard, seen below, fill out the appropriate fields and than click Next.

     

     

    Field

    Description

    Item Charge No.

    Here the user selects the item charge he wants to use. Item charges are created from the item charge list and can then be selected for the wizard.

    Creation Document Type

    Here the user selects whether he is creating a credit memo or an invoice.

    Line Creation Methods

    Here the user selects whether he wants to create 2 lines (1 debet and 1 credit) or one line with the difference.

    Copy Text Lines Below Item Lines

    If there is some text in the agreement below the item lines and the user wants that text to appear on the new invoice/credit memo, a checkmark should be placed in this box.

    Application Methods

    Here the user selects whether he wants to apply the new entry against a document or with a document. Credit memos are usually applied against an invoice.

    Allow Currency Substitution in Document Creation

    If the user wants to change currencies in the agreement he should place a checkmark in this box.

    Substitution Currency Code

    If the user wants to change currencies here he select the substitution currency.

    Allow Customer Substitution in Document Creation

    If the user wants to change customers/vendors in the agreement he should place a checkmark in this box.

    Substitution Customer No

    Here the code of the new customer/vendor that is to be substituted in the agreement is   selected.

     

    If the user wishes to change currency or customer/vendor he only needs to fill out the first page of the wizard and check the box with either the currency or customer/vendor option and select which currency or customer/vendor he wishes to substitute. Then he simply selects the option „Create Credit & Debit Documents in a Single Step on Selected Substitutions Options“ and the wizard then creates an invoice and a credit memo, which the user can check and then post if everything is alright.

    Step 2

    On the second page of the wizard, select the lines that need to be changed. Bold fields can be changed.

    There are 5 fields that can be changed in this form: Quantity, Unit price excl. VAT, Diff. Quantity, Diff. Unit Price and Diff.

     

    When fields are changed from the original amount the wizard/system calculates the related fields automatically. The wizards changes either the amount or the price in the line.

    If the field Quantity has been changed from 110 to 105 the wizard calculates the new amount from the new quantity multiplied with the old price and displays the amount in the field Amount. The wizard also displays the difference in quantity in the field Diff. Quantity and the difference in amount from the old amount in the field Diff. Amount. In the second line the field Unit Price Excl. VAT has been changed from 120 to 115 and the result is similar to line one except that the difference is displayed in the Diff. Unit Price field. In the third line the total amount to be credited has been entered into the field Diff. Amount and the wizard changes the field Unit Price Excl. VAT to match the total amount.

    The user can also input the amount or price that he wishes to be changed directly into the fields „Diff. Quantity“ or „Diff. Unit. Price“. For example if the user wishes to credit the equivalent of 75 boxes, instead of subtracting 75 boxes from the original quantity and putting that number in the „Quantity“ field, he can simply input -75 boxes in the „Diff. Quantity“ field and the system will change the „Quantity“ field accordingly and calculate the difference in amount.

    Create the Debit or Credit Document.

    When the user is satisfied with the changes he has made he selects the action „Create Document for Adjustment/Settlement“ from the top of the ribbon and that will create an invoice or credit memo, depending on the selection on the first page of the wizard, with the item charges assigned to corresponding inventory. The user can check the document to see if everything is correct and then post it like a regular invoice or credit memo.

    leiðsögn kostn.uppgjörgs/-breytinga

    Â