Recommended Mapping
The mappings can be configured individually as required by each company. The following mappings should act as a guideline and recommendation.
Customer Ad-Hoc
BC Table: Customer (18)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Customer Ad-Hoc | Active | On |
| BC Table | 18 | Save outgoing documents immediately | Off |
| Document Type Text | N/A | Allow multiple versions | Off |
| Category No. | 70 | Show message after archiving | Off |
| Subcategory Field No. | 1410 | Default for archive immediately in Drag&Drop | On |
| Mapping Type | Drag & Drop | Disable Drop Zone | Off |
-
The Therefore™ category has a Document-Type keyword field configured as a sub-category to easily distinguish the type of the document.
-
The macro [CURRENT_DATE] is used to insert the current date when saving a new document.
-
The macro [USER_ID] will insert the name of the user currently logged into Therefore™ through the Connector.
-
All options except for Active and Default for Archive Immediately in Drag&Drop are disabled and no reports are configured, as this mapping is just used for Ad-Hoc saving of documents on the customer card.
Vendor Ad-Hoc
BC Table: Vendor (23)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Vendor Ad-Hoc | Active | On |
| BC Table | 23 | Save outgoing documents immediately | Off |
| Document Type Text | N/A | Allow multiple versions | Off |
| Category No. | 71 | Show message after archiving | Off |
| Subcategory Field No. | 1424 | Default for archive immediately in Drag&Drop | On |
| Mapping Type | Drag & Drop | Disable Drop Zone | Off |
-
The Therefore™ Category has a Document-Type keyword field configured a as sub-category to easily distinguish the type of the document.
-
The macro [CURRENT_DATE] is used to insert the current date when saving a new document.
-
The macro [USER_ID] will insert the name of the user currently logged into Therefore™ through the Connector.
-
All options except for Active and Default for Archive Immediately in Drag&Drop are disabled and no reports are configured since this mapping is used for ad-hoc saving of documents on the vendor card only.
Outgoing Sales Order
BC Table: Sales Header (36)
Report: Sales - Confirmation (1305)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Outgoing Sales Order | Active | On |
| BC Table | 36 | Save outgoing documents immediately | On |
| Document Type Text | Sales Order | Allow multiple versions | On |
| Category No. | 64 | Show message after archiving | Off |
| Subcategory Field No. | 0 | Default for archive immediately in Drag&Drop | On |
| Mapping Type | Drag & Drop/Backend | Disable Drop Zone | Off |
-
This mapping will be processed a Sales Order is printed and the generated report will be saved to Therefore™.
-
Posting a Sales Order will make it a posted Sales Invoice which would be handled by a different mapping. A posted Sales Invoice will inherit all Therefore™ documents from the Sales Order.
-
The option Save outgoing documents immediately needs to be activated since the Sales Order might no longer be there later due to posting.
-
The option Allow multiple versions avoids the creation of multiple documents in Therefore™ when the Sales Order needs to be printed again after a change.
-
The Mapping Type will control if the Connector will be shown or if it will save the created documents in the background only.
Outgoing Sales Quotes
BC Table: Sales Header (36)
Report: Sales - Quote (1304)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Outgoing Sales Quotes | Active | On |
| BC Table | 36 | Save outgoing documents immediately | On |
| Document Type Text | Sales Quote | Allow multiple versions | On |
| Category No. | 65 | Show message after archiving | Off |
| Subcategory Field No. | 0 | Default for archive immediately in Drag&Drop | On |
| Mapping Type | Drag & Drop/Backend | Disable Drop Zone | Off |
-
This mapping is processed when the Sales Quote is printed and the generated report will be saved to Therefore™.
-
Converting a Sales Order out of the Sales Quote will not inherit any Therefore™ documents associated to it.
-
The documents will remain in Therefore™ but they will not be shown in the Drop Zone on the Sales Order.
-
The option Save outgoing documents immediately needs to be activated, as the Sales Quotes might no longer be there later (due to converting it to a Sales Order).
-
The option Allow multiple versions avoids creation of multiple documents in Therefore™ when the Sales Quote needs to be printed again after a change.
-
The Mapping Type will control if the Connector will be shown or if it will save the created documents in the background only.
Outgoing Sales Invoices (Posted)
BC Table: Sales Invoice Header (112)
Report: Sales - Invoice (1306)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Active | ||
| BC Table | Save outgoing documents immediately | ||
| Document Type Text | Allow multiple versions | ||
| Category No. | Show message after archiving | ||
| Subcategory Field No. | Default for archive immediately in Drag&Drop | ||
| Mapping Type | Disable Drop Zone |
-
This mapping is processed when a Sales Invoice is posted and the generated report will be saved to Therefore™.
-
The option Save outgoing documents immediately can be disabled to speed up posting. The report will then be generated and saved to Therefore™ by the NAS Job Queue as a background task.
Outgoing Sales Shipment (Posted)
BC Table: Sales Shipment Header (110)
Report: Sales - Shipment (208)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Active | ||
| BC Table | Save outgoing documents immediately | ||
| Document Type Text | Allow multiple versions | ||
| Category No. | Show message after archiving | ||
| Subcategory Field No. | Default for archive immediately in Drag&Drop | ||
| Mapping Type | Disable Drop Zone |
-
This mapping is executed when a Sales Shipment is posted (e.g., by posting a Sales Invoice or Sales Order). The associated report will generate a document that is then saved to Therefore™.
-
The option Save outgoing documents immediately can be disabled to speed up posting. The report will then be generated and saved to Therefore™ by the NAS Job Queue as a background task.
Purchase Receipts (Posted)
BC Table: Purch. Rcpt. Header (120)
Report: Purchase - Receipt (408)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Active | ||
| BC Table | Save outgoing documents immediately | ||
| Document Type Text | Allow multiple versions | ||
| Category No. | Show message after archiving | ||
| Subcategory Field No. | Default for archive immediately in Drag&Drop | ||
| Mapping Type | Disable Drop Zone |
-
This mapping is processed by posting a Purchase Receipt, created alongside posting a Purchase Invoice and the generated report will be saved to Therefore™.
-
The option Save outgoing documents immediately can be disabled to speed up posting. The report will then be generated and saved to Therefore™ by the NAS Job Queue as a background task.
-
The Status field with the Text value 1 is needed for Late Document Linking.
Purchase Receipts (Posted) Late Linking
BC Table: Purch. Rcpt. Header (120)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Active | ||
| BC Table | Save outgoing documents immediately | ||
| Document Type Text | Allow multiple versions | ||
| Category No. | Show message after archiving | ||
| Subcategory Field No. | Default for archive immediately in Drag&Drop | ||
| Mapping Type | Disable Drop Zone |
-
With the Mapping Type Late Linking this mapping will only be used for the Late Document Linking feature.
-
The NAS Job Queue will search in Therefore™ for documents with the specified Reference ID and Status of 0. If a document with a matching ID is found a link to the posted Purchase Receipt is created so it shows up in the Drop Zone.
-
Empty index data fields in Therefore™ will be updated as well. The Status will be set to 1.
-
For purchase receipts the Vendor No. and the Vendor Order No. were chosen as Reference ID, as they will form a unique key together.
Purchase Invoices (Posted)
BC Table: Purch. Inv. Header (122)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Active | ||
| BC Table | Save outgoing documents immediately | ||
| Document Type Text | Allow multiple versions | ||
| Category No. | Show message after archiving | ||
| Subcategory Field No. | Default for archive immediately in Drag&Drop | ||
| Mapping Type | Disable Drop Zone |
This mapping will be used when posting a Purchase Invoice to update the index data of the invoice that originated from Therefore™. It can also be used for ad-hoc saving of documents.
Purchase Invoices (Additional)
BC Table: Purchase Header (38)
| Setting | Configuration | Setting | Configuration |
|---|---|---|---|
| Description | Active | ||
| BC Table | Save outgoing documents immediately | ||
| Document Type Text | Allow multiple versions | ||
| Category No. | Show message after archiving | ||
| Subcategory Field No. | Default for archive immediately in Drag&Drop | ||
| Mapping Type | Disable Drop Zone |
-
Posting a Purchase Invoice will make it a posted Purchase Invoice which would be handled by a different mapping. A posted Purchase Invoice will inherit all Therefore™ documents from the Purchase Invoice.
-
The Therefore™ category also has a Created by and Creation date field which are set by Therefore™ macros and not by the mapping.
-
All options except for Active and 'Default for Archive Immediately in Drag&Drop' are disabled and no reports are configured, as this mapping is just used for Ad-Hoc saving of additional documents to a posted Purchase Invoice.
Additional Mappings
The following mappings are not as frequently used as the recommend ones, but still relevant:
| Name | Table | Document Type | Report | Processed when |
|---|---|---|---|---|
| Issued Reminder | 297 | - | 117 | Issuing |
| Service Quote | 5900 | Service Quote | 5902 | Printing |
| Service Order | 5900 | Service Order | 5900 | Printing |
| Service Invoice | 5900 | Service Invoice | - | Printing |
| Service Credit Memo | 5900 | Service Credit Memo | - | Printing |
| Posted Service Shipment | 5900 | - | 5913 | Printing |
| Posted Service Invoice | 5992 | - | Printing | |
| Posted Credit Memo | 5994 | - | 5912 | Printing |