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.
...
According to this Aleph to Alma migration guide, the Aleph Invoice Payment Status maps to the Alma Payment Status. This The first table below lists the record counts in Aleph for each payment status. From the documentation, "If you generally did not include the payment status of the invoice in Aleph, it is highly recommended that you update the relevant payment statuses for all invoices before migration. Invoices with a payment status other than Paid migrate to Alma with InReview status. Having large amounts of invoices with this status makes it difficult to manage the workflow of invoices in Alma.
Next steps
Ask ExLibris if we can create a crosswalk for our Invoice Status values since we generally use the custom Duke "C" value rather than P. If not, investigate the best method to edit the non-P records.
...
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:
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 |
...
Data Mapping
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. | ||
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 |
...