Purpose: This page describes data value crosswalks and data element mapping for the migration of Invoice data from Aleph to Alma. This migration guide and video from ExLibris provide instructions to complete a migration form prior to the automated migration of Aleph data to Alma. The decisions we need to make about invoice data migration are outlined on this page.
...
In Alma, there is an invoice line type which is a change from Aleph where we only had an invoice type on the header. I have an open question to ExLibris about how the PO line type is populated for invoices migrated from Aleph (#111 on the question log) .
This remainder of this section is a discussion of a configuration decision rather than a data migration decision, but I'm putting it here as a placeholder. We'll need to decide whether we want to set the "split additional charges parameter" to true. This would allow individual invoice lines to have different types other than the ones that come out of the box.
Out of the box, in addition to the Regular line, the standard additional invoice-line types Shipment, Insurance, Overhead, Discount, and Other are automatically enabled for each invoice - see the screen shot below. We can enable and disable additional line types in the Invoice Line Types code table (Configuration Menu > Acquisitions > Invoices > Invoice Line Types). The Invoice Line Types option only appears in the menu when the customer parameter invoice_split_additional_charges is set to true, so if we want to change how this is setup we'll need to ask ExLibris to enable the split additional charges parameter so that we can access that in the Configurations area. The full list of possible invoice line types is available in the ExLibirs documentation here.
...
| Z77_P_STATUS Payment status | Description | Count(10/3/23) |
|---|---|---|
| C | Paid and sent to R/3 | 216029 |
| Y | Payment authorization given | 311 |
| P | Paid | 4 |
| N | Not ready to be paid | 89 |
| R | Ready to be paid | 3 |
| null | 194 |
10/3/23: Per Chana at EL, they determine that the invoice is closed by the following mapping. I've included counts to list how many records in Aleph as of 10/3/23 match that criteria.
Next Step
Review the table below to determine whether any data cleanup is needed or if we're OK with invoices moving to Alma with the status values listed in the blue section of the table.
If Aleph invoice contains these values... | Migrate invoice to Alma as... | |||||
|---|---|---|---|---|---|---|
Z77_P_STATUS Payment status | Z77_I_DATE Invoice date | Z77_P_DATE Payment Date | Other/notes | Count of invoices matching this criteria in Aleph (10/3/23) | Alma Payment Status | Entry point in Alma |
| 'P' Paid | 4 | PAID | CLOSED | |||
| null | != 0 (an invoice date value exists) | != 0 (a payment date value exists) | 0 | PAID | CLOSED | |
| Any other custom values taken from tab48.lng (At Duke we use 'C' - Paid and sent to R/3) | != 0 (a payment date value exists) | 215451 | PAID | CLOSED | ||
| Any other custom values taken from tab48.lng (At Duke we use 'C' - Paid and sent to R/3) | = 0 (a payment date value doesn't exist) | 578 | PENDING | NEW | ||
| null | = 0 (an invoice date value doesn't exist) | Incomplete invoice header | 194 | Won't migrate to Alma | ||
| null | != 0 (an invoice date value exists) | = 0 (a payment date value doesn't exist) | 0 | PENDING | NEW | |
| 'N' Not ready to be paid | 89 | PENDING | NEW | |||
| 'R' Ready to be paid | Z77-APPROVAL_DEPARTMENT is null | 0 | PENDING | WAITING_APPROVAL | ||
| 'R' Ready to be paid | Z77-APPROVALDEPARTMENT is not null | 3 | PENDING | WAITING_SEND | ||
| 'Y' Payment notification sent | 311 | PENDING | WAITING_PAYMENT | |||
...
This table describes the Alma target field for each Invoice field in Aleph. Note: Much of this content was copied from Harvard's data mapping guides, last updated in 2018. Please consider this page a draft until the Duke team verifies that this mapping information is current and concurs with Duke's migration decisions. For reference, Aleph invoice screenshots are included below.
| Aleph Field | Alma Field | Additional Information |
| Aleph General Invoice | ||
| Line items (count) | doesn't migrate to Alma | |
| Total Amount Gen. Invoice | Total Amount | |
| Total Amount Line Items | Total invoice lines amount | |
| Vendor Code | Vendor Code | |
| Invoice Number | Invoice Number | |
| Net Amount | doesn't migrate to Alma | |
| Shipment Amount | Shipment | |
| Overhead Amount | doesn't migrate to Alma | There is data in this field: 16,492 contain a value greater than zero; 198,865 records contain 0. (7/26/23) |
| Insurance Amount | doesn't migrate to Alma | 98 records contain a value greater than zero (7/26/23) |
| Discount Amount | doesn't migrate to Alma | 7510 records contain a value greater than zero (7/26/23) |
| Total Amount | Total amount | VAT is included in the total invoice amount. |
| Total Amount incl. VAT | ||
| Local Amount | ||
| Refers to Invoice | Invoice Reference # | |
| Type | Notes?, Payment method - see crosswalk above | Do we want to map the Aleph value to Notes for reference? This value also sets the Payment Method in Alma. See crosswalk above. |
| Status | Status | |
| Currency | Included in Total invoice lines amount | |
| Explicit Ratio | doesn't migrate to Alma | |
| Debit | Total invoice lines amount does not include a minus sign. | |
| Credit | Total invoice lines amount includes a minus sign. | |
| Invoice Date | Invoice Date | |
| Received Date | doesn't migrate to Alma | |
| Shipment Date | doesn't migrate to Alma | |
| VAT Recipient | Not used in Aleph - all records null in 77_VAT_RECEIVER as of 7/26/23 | VAT details are mapped to Alma invoice and invoice lines notes (Z77_VAT_CODE, Z77_VAT_AMOUNT, 77_VAT_RECEIVER, Z75_VAT_CODE). |
| VAT Percent | n/a | |
| VAT Amount | VAT details are mapped to Alma invoice and invoice lines notes | |
| VAT per Line Item | n/a | |
| Add VAT to Amount | n/a | |
| Note | Notes Tab | |
| Payment Date | Payment Date | |
| Check Number | Payment Identifier | |
| Amount | Payment Amount | |
| Status | Payment Status | Values in Alma are
|
| Approval Dep. | Notes Tab "Approved by <Approval department> | 10/3/23 Notes from Chana on Basecamp: "All invoices will be migrated at the institutional level with institution as the owner. We check Z77_APPROVAL_DEPARTMENT if it's null to determine whether an invoice is WAITING_APPROVAL and in a note to indicate "Approved by … <value in Z77_APPROVAL_DEPARTMENT>. So the information will end up in a note field on the invoices." |
| Approval Number | Notes Tab | |
| Aleph Line Item Form | ||
| Vendor Code | Vendor | |
| Invoice Number | In banner at top of screen | |
| Net Amount | Price | |
| Estimated Price | n/a | |
| Added Amount | n/a | |
| Currency | Included in Amount | |
| Total Amount | Total Price | |
| Object Code | Reporting Code | |
| Total, Incl. VAT | n/a | |
| VAT Percent | n/a | |
| Local Amount | n/a | |
| VAT Amount | n/a | |
| Number of Units | Quantity | |
| Debit | Invoice line amount does not include a minus sign. No - in Total invoice lines amount | |
| Credit | Invoice line amount does not include a minus sign. | |
| Note | Note | |
| Aleph Invoice Line Items columns | ||
| Seq. | Line # | |
| Order No. | PO Line # | |
| Net Amt. | Price | |
| Total Amt. | Total Price | |
| Note: | Note | |
| Budget | Funds | |
| Object Code | Reporting Code | |
| Local Amt. | Allocated Fund Transaction - Amount | |
| Units in Ord | Available in invoice line view | |
| Units in Inv | Available in invoice line view | |
...