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

Modified on Mon, 10 Apr 2023 at 07:32 AM

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. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article