Issue trade statements
You can create the Purchase Invoice or Purchase Credit Memo to pay to the Trade Partners.
When the Trade Partner Source Type is selected as Customer, the related Sales Invoice or Credit Memo is created. When the Trade Partner Source Type is selected as Vendor, the corresponding Purchase Invoice or Credit Memo is created from the trade statements. A trade statement cannot be issued if the For Document Line No. field is zero on the Trade Statement lines when the Header option is selected in the Applies-To field of the Trade Plan Card.
-
On the Trade Statements page, on the action bar, select Issue Trade Statement.
The Issue Trade Statements report request page opens. -
In the Use default values from field, select the required option from the drop-down menu. For more information, see Report settings.
-
On Group Name FastTab, in the Date of Issue field, enter the related date.
-
Turn on the Post Sales/Purchase Document toggle to create and post the sales/purchase document.
-
Turn off the Post Sales/Purchase Document toggle to only create the sales/purchase document.
-
Turn on the Retain Source Dimensions toggle to use the dimensions from a trade statement line, which is carried over to the sales document created for a trade partner. However, this happens only when the source document’s number on the trade statement line matches the customer for whom the sales document is generated to record accrued amounts. You can also retain source dimensions for purchase invoices or purchase credit memos resulting from a trade statement.
If the Retain Source Dimensions toggle is turned on,- The resulting Purchase and Sales Credit Memo or Invoice will include separate lines for each Dimension Set ID associated with the trade accruals.
- For each Purchase and Sales Credit Memo or Invoice line created when retaining source dimensions, the individual dimension values will match those of the source document line.
- For trade statement lines with the For Document Line No. field value set to 0, the Retain Source Dimensions toggle on the Issue Trade Statements page is turned off and non-editable.
-
Click OK.
When a trade statement is created from a purchase order, the Applies-To field is set as Header, and the For Document Type field on the Lines FastTab of the Trade Statement Card displays Posted Purchase Receipt. In the case of trade statements created from sales orders, the For Document Type field displays Posted Sales Invoice.
Manage report settings
- In the Use default values from field, select the required option from the drop-down menu. It includes one or more saved settings that can be applied to the report from the request page.
If you select the Last used options and filters option, Business Central automatically saves the last used options and filters to issue the trade statement.
You can also customize your option by clicking Select from full list. The Select – Report Settings page opens. - Select New. The Pick Report page opens.
- In the Name field, customize filters by entering a report name.
- Select OK.
On the Select - Report Settings page, the newly created customized report option will be present.
The Trade Partner for the Tade Statement should have the Source Type as Customer. You cannot issue the trade statement by retaining the source dimensions for the vendor or purchase documents.
If the trade statement is eligible, the system checks the type of the trade statement and the total amount granted in the trade statement.
If the Total Amount Granted field on the trade statement lines has a positive value, the related Purchase Invoice document is created. If the Total Amount Granted field has a negative value, the related Credit Memo document is created.
Now, the purchase invoice is created, or created and posted based on the Post Sales/Purchase Document toggle.
The Source No., Document Date, Posting Date, Currency Code, Currency Factor, and the External Document No. (Trade Statement No.) information is copied to the invoice from the trade statement.
The system creates the invoice line for each trade statement line with the following information:
- Quantity
- Item Charge No.
- Unit Cost
- Post the invoice or credit memo.
The Issued checkbox is selected.
The system reverses the expected costs and value entry of the expected charge.
After the Trade Statement is issued and the trade statement is moved to the Issued Trade Statements page.
When a non-posted purchase invoice or credit memo is deleted, the system shows the following warning: This invoice was created from a Trade Statement. Do you really want to delete the document?
- Select Yes to issue the trade statement and delete the invoice or credit memo.
You can also select multiple trade statements from the Trade Statements page by clicking the Issue Trade Statement action.