The Get Posted Document Lines to Reverse function is useful when you need to copy one or more lines that appear in one or more posted documents. This is particularly helpful when you are creating a return order or a credit memo and you want the costs to be an exact reversal of the original order. This means that the costs on the credit memo reflect the cost that was on the original document and that the prices include any discounts that may have been applied to that order.
In the document, click Functions, Get Posted Document Lines to Reverse. If you are working with a sales document, the Posted Sales Document Lines window opens. If you are working with a purchase document, the Posted Purchase Document Lines window opens.
At the top of the window, place a check mark in the Show Reversible Quantity Only field if you want to see only lines that have quantities that have not yet been returned, or in the case of purchase lines, sold or consumed. For example, if a posted sales invoice quantity has already been returned, you may not want to return that quantity on a new sales return document. Placing a check mark in the Show Reversible Quantity Only field hides those posted document lines where the full quantities have already been returned, sold, or consumed.
This field only works for posted shipment/receipt and posted invoice lines, not for posted return or posted credit memo lines.
At the left side of the window, click the type of posted document lines you would like to use. The number in parentheses shows the number of documents available in that particular document type.
In the posted document lines, select the lines that you would like to copy to the new document.
If you use Ctrl+A to copy all lines, the program copies all lines within the filter you have set, but it will not regard the Show Reversible Quantity Only filter. For example, suppose you have filtered the lines to a particular document number with two lines, one of which has already been returned. Even if the Show Reversible Quantity Only field contains a check mark, if you press Ctrl+A to copy all lines, the program will copy two lines, instead of only the one that has not yet been reversed.
Click OK to copy the lines to the new document.
The program does the following:
For posted document lines of the type Item, the program creates a new document line that is a copy of the posted document line, with the quantity that has not yet been reversed. The program fills in the Appl.-from Item Entry field (for sales documents) or the Appl.-to Item Entry field (for purchase documents) as appropriate, with the number of the item ledger entry of the posted document line.
For posted document lines that are not of the type Item (such as item charges), creates a new document line that is a copy of the original posted document line.
Calculates the Unit Cost (LCY) field on the new line from the costs on the corresponding item ledger entries.
If the copied document is a posted shipment, posted receipt, posted return receipt, or posted return shipment, the program calculates the unit price from the item card.
If the copied document is a posted invoice or credit memo, the program copies the unit price, invoice discounts, and line discounts from the posted document line.
If the posted document line contains item tracking lines, the program fills the Appl.-from Item Entry field on the item tracking lines with the appropriate item ledger entry numbers from the posted item tracking lines.
When you copy from a posted invoice or posted credit memo, the program copies any relevant invoice discounts and line discounts as valid at the time of posting that document from the posted document line to the new document line. Be aware, however, that if the Calc. Inv. Discount option is activated in either the purchases and payables setup or the sales and receivables setup, as pertains to the situation, the invoice discount will be newly calculated when you post the new document line. It can be, therefore, that the line amount for the new line is different than the line amount for the posted document line, depending on the new calculation of the invoice discount.
Exact cost reversing of item tracking lines is not available from the purchase invoice or purchase credit memo documents.
If part of the quantity of the posted document line has already been reversed (returned) or sold or consumed, the program only creates a line for the quantity that remains in inventory or that has not been returned. If the full quantity of the posted document line has already been reversed (returned), the program does not create a new document line.
If the flow of goods in the posted document is the same as the flow of goods in the new document, the program simply creates a copy of the original posted document line in the new document. It does not fill in the Appl.-from Item Entry field (for sales documents) or the Appl.-to Item Entry field (for purchase documents) because, in this case, exact cost reversing is not possible. For example, if you use the Get Posted Document Lines to Reverse function to get a posted sales credit memo line for a new sales credit memo, the program only copies the original posted credit memo line to the new credit memo.
Assigning Exact Cost Reversing (sales)
Assigning Exact Cost Reversing (purchasing)