Vendor Balance Descrepency After Latest Update (Version 4.19)

Hi,
I hope this message finds you well. I am writing to bring to your immediate attention a critical issue that has emerged subsequent to the latest system update (4.19). The vendor balances within our ERP system have been severely disrupted, leading to significant discrepancies that require urgent resolution.

Here are an example highlight the disparities:
SHOAIB IQBAL ENGINEERING ALUMINUM
Actual Balance: Cr. -87,008.22
CETEC System Balance: Cr. -38,461,301.85

We kindly request your immediate attention and action to investigate and resolve this matter. Please prioritize this issue and provide an update on the steps being taken to correct the vendor balances back to their accurate values as soon as possible.
Best Regards,
Rana Muneeb

@rana826

I have reached out to our accounting team and we are looking into this now.

Thanks,

Cetec ERP Support Team

@rana826

We can see that there are likely Debit Memo objects creating the excess debit balances in error on the AP by Vendor Aging report for this vendor, seen in header totals >90 days & Total column, that reflect the same $$ value seen on the Vendor record in Accounting information.

We are escalating this ticket to engineers for resolution. Our support team will get back to you as quickly as possible.

Best,

CETEC ERP Customer Support Accounting Team

Rana,

Engineers indicate there is a fix for this issue that should deploy to your production environment this weekend.

Let us know if you have any questions or need further assistance with this or another issue.

Best,

CETEC ERP Customer Support Accounting Team

Hi @cetecerp16,
Thank you for your update.
The issue appears to be partially resolved. The AP balance discrepancy for our local Pakistani vendors has been corrected. However, the issue still persists for some of our international vendors.

For example:

  • Vendor: BT
    • Actual Balance: 0
    • Cetec Balance: -33,038,580.58
      Cetec ERP
  • Vendor: JY
    • Actual Balance: -4,026,187.50
    • Cetec Balance: -7,932,425.78
      Cetec ERP

Please review the international vendor balances.

Best regards,
Rana Muneeb

Hello Rana,

I am reopening the prior support ticket to include the additional information you’ve sent in the Forum for engineers. I have also edited the Vendor information showing in the Forum discussion to show only the initials of the Vendor to protect Gold Star’s Vendor information from public view. The links you sent are already protected in that they only show a “CETEC ERP” hyperlink and are inaccessible to outside access, fyi. Thank you for the additional information.

We will reply back to you both here in the forum and on the support ticket email as to status of your issue.

Best,

CETEC ERP Customer Support