568
I am attempting to update a check status to "Void" in the table BANKCHEQUETABLE using a custom script class job. When I execute it in Sandbox, I receive the message, "The custom script is not allowed to access the BankChequeTable table." Does anyone know if this table is accessible to update via a custom script?
Response from Microsoft, "Finance team confirmed that bankchequetable cannot be used with X++ custom scripts as there are some tables that naturally prevent execution."
Looks like it just cannot be done.
Thank you, for your time and help.
Thanks again, I'll give it a try now.
public static void main(args _args)
{
BankChequeTable BankChequeTable;
int successCounter = 0;
int failCounter = 0;
ttsBegin;
while select forupdate BankChequeTable
where
(BankChequeTable.RecID == 5637144598)
{
BankChequeTable.ChequeStatus = ChequeStatus::Void;
if (BankChequeTable.ChequeStatus == ChequeStatus::Cancelled
|| BankChequeTable.ChequeStatus == ChequeStatus::Rejected
|| BankChequeTable.ChequeStatus == ChequeStatus::Void)
{
bankChequeTable.voidPositivePay();
}
BankChequeTable.update();
successCounter++;
}
}
ttsCommit;
info(strFmt("%1 records updated successfully.", successCounter));
info(strFmt("%1 records failed to update.", failCounter));
}
Thanks for your assistance.
I don't think this will work in a single-class custom script, though. Am I wrong? Can you demonstrate how this will fit into the custom script I provided earlier?
Below is the standard code you need to try :
if (_chequeStatus == ChequeStatus::Cancelled
|| _chequeStatus == ChequeStatus::Rejected
|| _chequeStatus == ChequeStatus::Void)
{
bankChequeTable.voidPositivePay();
}
The standard method in the table BankChequeTable:
public static void setChequeStatus(
CompanyBankAccountId _accountID,
BankChequeNum _chequeNum,
ChequeStatus _chequeStatus,
TransDate _transDate,
Voucher _voucher,
BankChequeRecipientType _recipientType,
CompanyId _recipientCompany,
CustVendAC _recipientAccountNum,
CurrencyCode _currencyCode,
AmountCur _amountCur,
BankNegInstRecipientName _recipientName,
RemittanceAddress _remittanceAddress = 0,
RefTableId _sourceTableId = 0,
RefRecId _sourceRecId = 0)
{
BankChequeTable bankChequeTable;
select firstonly forupdate bankChequeTable
where bankChequeTable.AccountID == _accountID
&& bankChequeTable.ChequeNum == _chequeNum;
if (!bankChequeTable)
{
throw error(strfmt("@SYS76941", _accountID, _chequeNum));
}
bankChequeTable.ChequeStatus = _chequeStatus;
bankChequeTable.TransDate = _transDate;
bankChequeTable.Voucher = _voucher;
bankChequeTable.RecipientType = _recipientType;
bankChequeTable.RecipientCompany = _recipientCompany;
bankChequeTable.RecipientAccountNum = _recipientAccountNum;
bankChequeTable.RecipientTransVoucher = _voucher;
bankChequeTable.CurrencyCode = _currencyCode;
bankChequeTable.AmountCur = _amountCur;
if (_recipientName)
{
bankChequeTable.BankNegInstRecipientName = _recipientName;
}
if (_remittanceAddress)
{
bankChequeTable.RemittanceAddress = _remittanceAddress;
}
if (_sourceTableId
&& _sourceRecId)
{
bankChequeTable.SourceTableId = _sourceTableId;
bankChequeTable.SourceRecId = _sourceRecId;
}
bankChequeTable.BankCurrency = BankAccountTable::find(_accountID).CurrencyCode;
if (_currencyCode == bankChequeTable.BankCurrency)
{
bankChequeTable.BankCurrencyAmount = _amountCur;
}
else
{
bankChequeTable.BankCurrencyAmount = CurrencyExchangeHelper::curAmount2CurAmount(_amountCur, _currencyCode, bankChequeTable.BankCurrency, bankChequeTable.TransDate);
}
if (_chequeStatus == ChequeStatus::Cancelled
|| _chequeStatus == ChequeStatus::Rejected
|| _chequeStatus == ChequeStatus::Void)
{
bankChequeTable.voidPositivePay();
}
bankChequeTable.update();
}
internal final class CheckStatusToVoidTest1
{
public static void main(args _args)
{
BankChequeTable BankChequeTable;
int successCounter = 0;
int failCounter = 0;
ttsBegin;
while select forupdate BankChequeTable
where
(BankChequeTable.RecID == 5637144598)
{
if (BankChequeTable.validateWrite())
{
BankChequeTable.ChequeStatus = 3;
BankChequeTable.update();
successCounter++;
}
else
{
failCounter++;
}
}
ttsCommit;
info(strFmt("%1 records updated successfully.", successCounter));
info(strFmt("%1 records failed to update.", failCounter));
}
}
Hi,
Can you please share the code where you can update the table?
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
