IP1 can upload and process the incoming sales interface data to generate the AR interface records. This program will allow you to enquire, validate, and delete any of the generated records. Maintenance of the data will not be allowed as it comes from an external system, however if there any set up errors, the interface file can be processed again to re-generate the interface records.
Generated interface records that are error free can be posted to generate sales invoice and the corresponding AR transaction.
- In the menu, expand Base Modules > Other options > Data Interfaces > DSR and double-click Sales Report Transactions. DSW070 Work with Sales Interface panel appears.
| Field | Description |
| Company | Specify the company to select the transactions for that specific company. |
| Status | Enter status for the transactions you wish to select: Blank=Un-posted, E=Entered, X=Error, P=Posted. |
| System | This is the sub-ledger system code for the incoming interfaces. |
| Document type | You have the option to select only invoices or credits or both. |
| Posting period | This is the period that the transaction was posted in. |
| Customer no | To select transactions for a specific customer, you can enter the customer number. |
| Create date | To select transactions created on a specific day, you can enter the date for that day. |
| Process no | You can specify an IP1 process number to select only specific transactions. |
- Enter the above selection criteria or leave blank to select all records, as required.
- Click OK. All the relevant transactions appears.
| Options | Description |
| Header | Accesses the header details of the selected transaction. |
| Detail | Accesses the details of the selected transaction. Item descriptions and details of the transactions can be viewed using function keys. |
| Delete | An un-posted transaction can be deleted, if required. |
| Validate | The selected transaction will be checked for errors, if any errors are encountered then the status of the transaction will be changed to ‘X’=Error. |
| Post | Post option will generate distribution sales invoice and the corresponding AR transaction. This option will only be valid for a transaction that is not in error and is not yet posted. |
| Link | If the selected transaction is posted this option will display the related Transaction Inquiry. |
- Select the required transaction and click the relevant option.
