Manage posted document trade lines
When creating an invoice or credit memo, you can add an invoice line manually or use the Get Shipment Lines or Get Receipt Lines action. In that case, the document trade lines are copied from the order to the invoice or credit memo. When posting the invoice, the available document trade lines are posted as well.
After posting document trade lines with a price rule, the system creates value entries on the Trade Price Rule Entries page. For more information, see Trade price value entries.
After posting document trade lines with an accrual type and lines added from a shipment/receipt, a trade cost order is created and directly posted in the background. For more information about the trade cost order, see Trade Cost Order. After posting the trade cost order, value entries are created on the Value Entries page. Depending on the accrual type, this is a value entry with the Trade Cost Posting Type field set to Empty or Expected. For the value entries with the Trade Cost Posting Type field set to Expected, after posting the actual cost or revenue, the entries will be reversed and new entries will be created with the actual cost or revenue.
Create and post the trade cost order manually
The following instructions outline the process for creating and posting the trade cost order manually for the posted document trade lines within a sales invoice. These steps can be applied similarly to other sales and purchase documents.
- Select the Search icon
, enter Posted Sales Invoices, and then choose the related link.
The Posted Sales Invoices page opens. - Select the required No. to open the Posted Sales Invoice page.
-
On the Lines FastTab, select Line > Document Trade Lines.
The Posted Sales Document Trade Lines page opens.
You can view the relevant document trade lines that are posted along with the sales invoice.While posting an invoice or credit memo, it is possible for an error to occur when generating the cost order in the background. However, this error will not prevent the system from proceeding with the posting of the invoice or credit memo. Once the error is resolved or the necessary setup is configured, you can create and post the trade cost order through the posted sales invoice or sales credit memo.
- On the action bar, select Post Trade Cost Order.
It creates and posts the trade cost order for the selected document trade line only if the error has been resolved, or the necessary setup has been configured for the specific line.
Post sales return accrual reversals as non-inventoriable cost
When you post sales return accruals, the system can post the reversal to inventory or as non-inventoriable cost. The following steps explain how to set up and validate this behaviour.
-
Select the Search icon
, enter Trade Management Setup, and then choose the related link.The Trade Management Setup page opens.
-
On the General FastTab, in the Sales Return Value Entry Cost Type field, select the required option. The available options are:
- Actual Cost: Resulting value entries use the Cost Amount (Actual) and Cost Amount (Expected) field values, and accrual reversal is posted through inventory-related accounts.
- Non-Inventoriable: Resulting value entries use the Cost Amount (Non-Invtbl.) field value, and accrual reversal is posted through the Trade Account Non-Invtbl. accounts on the General Posting Setup page.
To validate the setup with a posted sales return, follow these steps:
- Create and post a sales order with trade accruals.
- Create and post a sales credit memo for the posted sales order.
- Open the posted sales credit memo.
- On the Lines FastTab, select Line > Document Trade Lines.
The Posted Sales Document Trade Lines page opens. - Review the related value entries and G/L entries for the posted document.
- When the Sales Return Value Entry Cost Type field value is set to Actual Cost, the system creates value entries in the Cost Amount (Actual) and Cost Amount (Expected) fields, and the accrual reversal updates the inventory value.
- When the Sales Return Value Entry Cost Type field value is set to Non-Inventoriable, the system creates value entries in the Cost Amount (Non-Invtbl.) field, posts the accrual reversal to the Trade Account Non-Invtbl. accounts, and does not change the inventory value.