Ceres5.00.92 - Correct Invoice creation criteria for Import CC Transactions Excel

Service Request or Support Case:

Issue addressed: For the Import CC Transactions Excel process, Ceres5.00.76 (Correct Sorting Sequence for Import CC Transactions Excel), corrected creation of the Invoice when the sorting sequence in the Excel sheet was different.  Ceres5.00.76 incorrectly included evaluation of Global Dimension 1 and Global Dimension 2 in the Invoice creation criterial which resulted in multiple Invoices being created for the same Vendor and Invoice No. when the import lines contained different Global Dimension 1 and Global Dimension 2 values.

Objects Affected:

Type               ID                    Name

Table              81                    Gen. Journal Line

Report            14012543      Import CC Transactions Excel

This release presents a change in system usage methodology. The following procedure documents were updated accordingly.

1. Vendor Purchases via Credit Card

Resolution: 

The Import CC Transactions Excel (RP 14012543) was updated to only consider Vendor No. and Invoice No. (e.g. Ext. Doc. No.) when creating Invoices so import transactions with different Global Dimension 1 and Global Dimension 2 values with the same Vendor No. and Invoice No. will be combined on the same Invoice.