Contents
Quantity confirmation of POR and IR+ documents – FIFO/LIFO
The functionality of quantity confirmation allows for providing an item for sales begore specifying its correct value. After receiving a purchase document, a user can enter an appropriate value in a POR document and then confirm the document, upon which values of resources and purchase costs are updated in unposted documents for released items. In posted documents, the update of purchase costs will be executed by generating a CC.
In a document with confirmed quantity, the following fields can be modified:
- Regular Price (POR), Discounted Price (POR, IR+), Discount (POR), Value (POR, IR+), Price Type (POR),
- Modification of exchange rate and currency, unless a quantity correction is not generated to a document (POR).
- Date of issue, date of receipt, reference number, delivery method
- Description
Other fields are not subject to modification on a document with confirmed quantity.
From a POR/IR+ with confirmed quantity it is not possible to generate a value correction.
Parameter Prime sales cost determined and Fixed value of delivery
Parameter Prime sales cost determined is only available on warehouse documents: SOR, IR-, WM-, WM+ and on quantity corrections. It is editable on SOR, IR- and WM- documents. For other documents, the value of the parameter is transferred from the source document and it is not subject to edition. After checking the parameter in a document and saving the document, it is not possible to change the parameter value.
If in a document, the parameter Prime sales cost determined is:
- checked – costs on the document are actual A document can be posted, after changing the value in an IR+/POR document, a cost correction is generated.
- unchecked – cost on the document has not been determined. It is not possible to post a document until the parameter is checked.
In order to be able to modify the parameter Fixed value of delivery in a confirmed SOR, IR-, WM- document, the operator group to which the currently logged-in operator belongs must have permission Determining of prime sales cost granted, which is available from the level of Configuration → Company Structure → Operator Groups → edition of selected operator group → tab Other Permissions.
The parameter Fixed value of delivery is available in IR+, PZ and cost corrections and it is not subject to edition.
The parameter does not regard: trade documents, orders, quotes and inquiries.
When confirming a SOR, IR- or WM- document, all document subitems are verified, if value of the delivery is:
- determined – the parameter is checked automatically
- not determined – the parameter will not be checked
The parameter is update during the update of costs on a document upon confirmation of POR/IR+.
In case of updating price/value on a document with confirmed quantity, the change is saved only for a given item and document value. The value of an item remains unchanged until a complete confirmation of a POR/IR+ document (status Confirmed).
Changing value of subitem on POR/IR+
Updating values of item and subitem on a document with confirmed quantity and confirmed entirely:
Quantity Price Item Value Document Value Subitem Value Document Status Comment
10 pcs 5 USD 50 USD 50 USD 50 USD Confirmed Quantity Total Document with confirmed quantity
10 pcs 7 USD 70 USD 70 USD 50 USD Confirmed Quantity Total Modification of price on document and its saving
10 pcs 8 USD 80 USD 80 USD 80 USD Confirmed Modification of price on document and its permanent confirmation
Updating resources and costs
Upon changing status of POR document from Confirmed Quantity Total to Confirmed, the system:
- Updates purchase costs on warehouse documents for released items and their quantity corrections with status Unconfirmed, Initiated and Confirmed if Prime sales cost determined parameter is unchecked on SOR, IR-, WM-, WM+, SORQC and IR-QC documents.
- Generates cost corrections to warehouse documents for released items and their quantity corrections with status Confirmed if Prime sales cost determined parameter is checked on SOR, IR-, WM-, WM+, SORQC and IR-QC documents.
- Updates PORQC document.
- Changes value of resource remaining in warehouse(s).
Updating costs and resources: Warehouse W1 and Warehouse W2 Unconfirmed SOR3 from W2 – 1 pcs
Step Quantity Price/Value Document Value Subitem Value Comment
1. 10 pcs 12 USD/120 USD 120 USD 120 USD -
2. 2 pcs 12 USD/22 USD 24 USD 24 USD Update of resource
3. 2 pcs 10 USD/20 USD 20 USD 20 USD Cost correction for 4 USD is generated
4. 1 pcs 12 USD/12 USD 12 USD 12 USD Update of resource
5. 1 pcs 10 USD/10 USD 10 USD 10 USD Cost correction for 2 USD is generated
6. 1 pcs 12 USD/12 USD 12 USD 12 USD Update of resource
7. 2 pcs 12 USD/24 USD 24 USD 24 USD Update of resource on WM-/WM+
8. 1 pcs 12 USD/12 USD 12 USD 12 USD Update of resource
9. 4 pcs 12 USD/48 USD - - Resource value in warehouse
Generating PI from POR document with confirmed quantity
In case of generating a PI document from a POR, standard rules for generating documents described in category Generation of documents apply, with exclusion of the following rules:
- in case of selecting several POR with confirmed quantity, in which different currency exchange rates are registered, during generation of a PI, the system displays window with question referring to aggregation of exchange rates:
- upon approving the aggregation, those exchange rate type and value are retrieved onto the invoice, which are determined by settings in PI document definition in a center in which the document is being generated
- upon selecting the option without aggregation, as many invoices are generated as there are different currency exchange rates registered in the selected documents
Upon generating a PI from a PO receipt with confirmed quantity, it is not possible to:
- modify document items
- confirm or confirm and post POR
- generate a correction to the POR if the invoice status is Unconfirmed.
In an invoice document, the following fields can be modified:
- Regular Price – the permission Modification of regular price is controlled for an operator group
- Discounted Price
- Discount
- Value
- Exchange Rate Type and Exchange Rate Value
When confirming a PI document, the POR document is also confirmed and the following elements are updated:
- purchase value on subitems
- regular and discounted price, discount, values on an item
- VAT table
- values and parameters referring to currency (exchange rate, exchange rate type, date type, date, conversion calculators) in the document header
Once the PI is confirmed, standard mechanism of updating purchase cost is started, the same as in case of changing status of POR from Confirmed Quantity Total to Confirmed.
Canceling a document with confirmed quantity
The rules applying to the cancellation of documents with confirmed quantity are the same as in the case of cancelling a confirmed POR/IR+ document. Conditions verifying during an attempt to cancel a POR/IR+ document with Confirmed Quantity Total status:
- Quantity correction – if there is a correction with a status different than Canceled, the system does not allow to cancel the document.
- Item sale – verification whether the merchandise from the document which is to be canceled, has been released. If yes, the system does not allow to cancel the document.