In this task we will book the invoiced amount for goods, that have not yet arrived, on a pre-defined goods-in-transit account. We assume that the invoice includes three purchase orders and each order includes one item.
- The first item is received on time (steps 1-7).
- The second is received some time later (steps 8-12).
- The third is not received at all (steps 13-15).
Prerequisites
The XGIT pseudo account must exist in the Pseudo account file. A voucher type which includes the APGT routine from the Routine table must exist.
Before you start the matching routine make sure that purchase orders and final A/P invoices have been created.
First item
- Select the Enter financial transactions menu item.
- On the Financial system transaction entry panel, enter a voucher type which includes the APGT routine and complete other applicable fields and click OK. For further instructions and field descriptions, see Open a new batch.
- You remain on the same panel, which is now updated, showing only the routines that are valid for the selected voucher type. Select the A/P invoices (Final) routine and click OK.
- You access A/P invoice/credit note entry. Enter the necessary invoice information and complete the following field:
- Invoice matching
- Set this field to YES.
- You access VAT amounts/default accounts entry. See step 4 in Enter an A/P invoice with VAT on G/L level for instructions and field descriptions. Click OK.
- You access A/P invoice matching, Select goods reception transactions. Follow steps 3-5 in Match a final invoice with the following exception:
- You access G/L postings entry for A/P documents. Click GIT account to automatically retrieve a goods-in-transit account that the residual unmatched amounts can be booked on. Click OK. The GIT account is now updated and you may close the batch. For more information about closing your entries, see About starting/closing manual transaction entry.
- Select the Enter financial transactions menu item and enter a voucher type including the APGT routine and then select the A/P goods-in-transit routine.
- You access Work with A/P goods-in-transit, Select final invoices. On this panel you can view the previously stored GIT amount for the invoice. Select the document and click Match to continue matching the second item.
- You access A/P invoice matching, Select goods reception transactions. In the header of this panel, the following fields apply:
- Prev matched amount
- This is the amount that was previously matched on the preliminary invoice.
- Remain unmatched amt
- This is the amount that is going to be matched for the remaining purchase order.
- Supplier
- This field is defaulted, but can be changed.
- You access A/P invoice matching.
Click OK to confirm the matching. Note: If no other selection criteria besides supplier number was made on the previous panel, then you first have to select the next order line that you want to match. The entire remaining quantity on the line will be matched and no differences will be posted. Then, click Update to update the invoice.
- Continue with step 7 above and then close the batch.
- Select the Enter financial transactions menu item and enter a voucher type including the APGT routine and then select the A/P goods-in-transit routine.
- You access Work with A/P goods-in-transit, Select final invoices. On this panel you can view the remaining unmatched amount of the invoice, the last item that was never received. Select the document and click G/L accounting only to re-account the goods-in-transit amount to an appropriate cost account.
- You access G/L postings for A/P documents where you can close your accounting. Exit the routine.
Click OK.
Click Update.
Second item
The second item has now been received and needs to be matched.
These two amounts are updated with each matching, and automatically reduce the remaining amount.
Selection
You can enter one or a combination of the fields on this panel to display a selection of order lines to match.
Note: If you select a supplier number together with any other parameter on this panel, then the purchase order lines that correspond to the entered selection criteria will be automatically selected for matching. Click OK.
Third item
The third and last item was never received. In the following steps, we will re-account the goods-in-transit amount to an appropriate cost account.
Related topics
- About matching A/P invoices and purchase orders manually
- Match a preliminary invoice
- Match a preliminary invoice with price differences
- Match a preliminary invoice with quantity differences
- Match a preliminary invoice with exchange rate differences
- Match a final invoice
- Print an invoice matching reconciliation list
- Print a supplier invoice variance analysis list
- Set up tolerance limit rules on a common level
- Define tolerance limit exceptions on suppliers
- About entering A/P invoices and credit notes manually
- About starting/closing manual transaction entry