You’re offline. This is a read only version of the page.
7
Hello,
I'm trying my first custom script, but I'm getting this error that doesn't exist in the documentation: The custom script is not allowed to access the AccountingEventSourceDocumentLineLink table. Based on the logs, it appears that the script was executed successfully, but failed for some reason. Any ideas?
I try to reverse the reception of a command, the script is executed successfully in the development environment and I test it as administrator in the UAT.
Find bellow part of the script execution log
[5/30/2023 02:52:47 pm] Database activity:
Table AccountingDistribution is accessed 2 times using a Read operation.
Table AccountingDistribution is accessed 1 times using a UpdateRecordSet operation.
Table AccountingDistributionEventTmp is accessed 1 times using a InsertRecordSet operation.
Table AccountingDistributionTmpForValidation is accessed 1 times using a InsertRecordSet operation.
Table AccountingDistributionTmpJournalize is accessed 1 times using a InsertRecordSet operation.
Table AccountingDistributionTmpJournalize is accessed 1 times using a Read operation.
Table AccountingEvent is accessed 2 times using a Read operation.
Table AccountingEvent is accessed 1 times using a Update operation.
Table AccountingEventDateTmp is accessed 1 times using a InsertRecordSet operation.
Table AccountingEventSourceDocumentLineLink is accessed 1 times using a InsertRecordSet operation.
Table AccountingEventTmp is accessed 1 times using a Create operation.
Table AccountingEventTmp is accessed 1 times using a InsertRecordSet operation.
Table DimensionAttributeLevelValue is accessed 1 times using a Read operation.
Table DimensionAttributeLevelValueView is accessed 2 times using a Read operation.
Table DimensionAttributeValueGroupCombination is accessed 1 times using a Read operation.
Table DimensionAttributeValueSetItem is accessed 3 times using a Read operation.
Table FiscalCalendarPeriod is accessed 39 times using a Read operation.
Table FormletterParmTable is accessed 2 times using a Read operation.
Table InventBatch is accessed 1 times using a Update operation.
Table InventSumDelta is accessed 1 times using a Create operation.
Table InventSumDelta is accessed 2 times using a Update operation.
Table InventTrans is accessed 2 times using a Create operation.
Table InventTrans is accessed 4 times using a Read operation.
Table InventTrans is accessed 3 times using a Update operation.
Table InventTransOrigin is accessed 3 times using a Read operation.
Table InventTransPosting is accessed 2 times using a Create operation.
Table LogisticsPostalAddress is accessed 7 times using a ReadFromCache operation.
Table MarkupTrans is accessed 1 times using a Read operation.
Table NumberSequenceDatatypeParameterType is accessed 3 times using a Read operation.
Table NumberSequenceList is accessed 2 times using a Read operation.
Table NumberSequenceList is accessed 2 times using a Update operation.
Table NumberSequenceTable is accessed 3 times using a ReadFromCache operation.
Table NumberSequenceTable is accessed 1 times using a Update operation.
Table NumberSequenceTTS is accessed 1 times using a Create operation.
Table PdsVendBatchInfo is accessed 1 times using a Update operation.
Table PurchLine is accessed 1 times using a DoUpdate operation.
Table PurchLine is accessed 1 times using a Read operation.
Table PurchLine is accessed 1 times using a Update operation.
Table PurchParmLine is accessed 1 times using a Update operation.
Table PurchParmLine is accessed 1 times using a UpdateRecordSet operation.
Table PurchParmSubTable is accessed 1 times using a DoUpdate operation.
Table PurchParmTable is accessed 1 times using a Update operation.
Table PurchParmUpdate is accessed 1 times using a Update operation.
Table PurchTable is accessed 1 times using a DoUpdate operation.
Table SourceDocumentHeader is accessed 1 times using a Update operation.
Table SourceDocumentLine is accessed 2 times using a Read operation.
Table SourceDocumentLine is accessed 1 times using a Update operation.
Table SourceDocumentLine is accessed 1 times using a UpdateRecordSet operation.
Table SourceDocumentLineItemTmp is accessed 1 times using a Create operation.
Table SourceDocumentLineRecIdTmp is accessed 1 times using a InsertRecordSet operation.
Table SourceDocumentLineTmpJournalize is accessed 1 times using a InsertRecordSet operation.
Table SourceDocumentLineTmpJournalize is accessed 1 times using a Read operation.
Table SubledgerJournalAccountEntry is accessed 1 times using a InsertRecordSet operation.
Table SubledgerJournalAccountEntry is accessed 4 times using a Read operation.
Table SubledgerJournalAccountEntry is accessed 1 times using a UpdateRecordSet operation.
Table SubledgerJournalAccountEntryDistribution is accessed 1 times using a InsertRecordSet operation.
Table SubledgerJournalAccountEntryDistribution is accessed 1 times using a UpdateRecordSet operation.
Table SubledgerJournalAccountEntryTmpClearing is accessed 1 times using a InsertRecordSet operation.
Table SubledgerJournalAccountEntryTmpDetail is accessed 1 times using a DeleteRecordSet operation.
Table SubledgerJournalAccountEntryTmpDetail is accessed 2 times using a InsertRecordSet operation.
Table SubledgerJournalAccountEntryTmpDetail is accessed 2 times using a Read operation.
Table SubledgerJournalAccountEntryTmpDetail is accessed 1 times using a UpdateRecordSet operation.
Table SubledgerJournalAccountEntryTmpForValidation is accessed 1 times using a InsertRecordSet operation.
Table SubledgerJournalAccountEntryTmpSummary is accessed 2 times using a InsertRecordSet operation.
Table SubledgerJournalAccountEntryTmpSummary is accessed 2 times using a Read operation.
Table SubledgerJournalEntry is accessed 1 times using a Create operation.
Table SubledgerJournalEntry is accessed 2 times using a Read operation.
Table SysCacheFlush is accessed 1 times using a Update operation.
Table TaxData is accessed 1 times using a Read operation.
Table TaxUncommitted is accessed 4 times using a Read operation.
Table TaxWorkRegulation is accessed 1 times using a DeleteRecordSet operation.
Table TmpTax is accessed 1 times using a Create operation.
Table TmpTax is accessed 1 times using a Read operation.
Table TmpTax is accessed 1 times using a Update operation.
Table TmpTaxWorkTrans is accessed 1 times using a Create operation.
Table TmpTaxWorkTrans is accessed 1 times using a DoUpdate operation.
Table TmpTaxWorkTrans is accessed 5 times using a Read operation.
Table TmpTaxWorkTrans is accessed 1 times using a Update operation.
Table TmpTaxWorkTrans is accessed 1 times using a UpdateRecordSet operation.
Table TransactionLog is accessed 1 times using a Create operation.
Table VendDocumentSubTableMap is accessed 1 times using a DeleteRecordSet operation.
Table VendDocumentTableMap is accessed 1 times using a DeleteRecordSet operation.
Table VendPackingSlipJour is accessed 1 times using a Create operation.
Table VendPackingSlipJour is accessed 1 times using a ReadFromCache operation.
Table VendPackingSlipJour_Intrastat is accessed 1 times using a Create operation.
Table VendPackingSlipTrans is accessed 1 times using a Create operation.
Table VendPackingSlipTrans is accessed 1 times using a Read operation.
Table VendPackingSlipTrans_Intrastat is accessed 1 times using a Create operation.
Table VendPackingSlipVersion is accessed 1 times using a Create operation.
Table VendPackingSlipVersion is accessed 1 times using a ReadFromCache operation.
[5/30/2023 02:52:47 pm] Infolog:
Purchase order PO-00055511 reception reversed
The custom script is not allowed to access the AccountingEventSourceDocumentLineLink table.
[5/30/2023 02:52:47 pm] Completed
Hi André, please find below the code I am trying to execute. Can you help me understand the login behind the protection please? Is there any Microsoft documentation or link? And what are the limitations?
Models included are :
Application Common
ApplicationFoundation
ApplicationPlatform
Application Suite
Directory
FiscalBooks
SourceDocumentation
SourceDocumentation Types
public static void main(Args _args)
{
PurchLine purchLine;
PurchFormLetter purchFormLetter;
PurchFormletterParmData purchFormLetterParmData;
PurchParmUpdate purchParmUpdate;
PurchParmTable purchParmTable;
PurchParmLine purchParmLine;
PurchTable purchTable;
PurchId purchId;
Num packingSlipId;
LineNum lineNum;
PurchQty correctedQty;
;
purchId = 'PO-00055511';
packingSlipId = 'FAS-000103-1';
lineNum = 1;
correctedQty = -1;
changecompany('CAN')
{
ttsBegin;
// Create PurchParamUpdate table
purchTable = PurchTable::find(purchId, true);
purchFormLetterParmData = PurchFormletterParmData::newData(DocumentStatus::PackingSlip, VersioningUpdateType::Initial);
purchFormLetterParmData.parmOnlyCreateParmUpdate(true);
purchFormLetterParmData.createData(false);
purchParmUpdate = purchFormLetterParmData.parmParmUpdate();
// Set PurchParmTable table
purchParmTable.clear();
purchParmTable.TransDate = str2Date('04/01/2023', 213);
purchParmTable.Ordering = DocumentStatus::PackingSlip;
purchParmTable.ParmJobStatus = ParmJobStatus::Waiting;
purchParmTable.Num = packingSlipId;
purchParmTable.PurchId = purchTable.PurchId;
purchParmTable.PurchName = purchTable.PurchName;
purchParmTable.DeliveryName = purchTable.DeliveryName;
purchParmTable.DeliveryPostalAddress = purchTable.DeliveryPostalAddress;
purchParmTable.OrderAccount = purchTable.OrderAccount;
purchParmTable.CurrencyCode = purchTable.CurrencyCode;
purchParmTable.InvoiceAccount = purchTable.InvoiceAccount;
purchParmTable.ParmId = purchParmUpdate.ParmId;
purchParmTable.insert();
// Set PurchParmLine table
select firstonly purchLine
where purchLine.PurchId == purchTable.purchId && purchLine.LineNumber == lineNum;
if(purchLine)
{
purchParmLine.InitFromPurchLine(purchLine);
purchParmLine.ReceiveNow = correctedQty;
purchParmLine.ParmId = purchParmTable.ParmId;
purchParmLine.TableRefId = purchParmTable.TableRefId;
purchParmLine.setQty(DocumentStatus::PackingSlip, false, true);
purchParmLine.setLineAmount();
purchParmLine.insert();
}
purchFormLetter = PurchFormLetter::construct(DocumentStatus::PackingSlip);
purchFormLetter.transDate(str2Date('04/01/2023', 213));
purchFormLetter.proforma(false);
purchFormLetter.specQty(PurchUpdate::ReceiveNow);
purchFormLetter.purchTable(purchTable);
purchFormLetter.parmParmTableNum(purchParmTable.ParmId);
purchFormLetter.parmId(purchParmTable.ParmId);
purchFormLetter.purchParmUpdate(purchFormLetterParmData.parmParmUpdate());
purchFormLetter.run();
ttsCommit;
}
info(strFmt('%1 updated',purchId));
}
Hi,
Execution of custom scripts works different than running a class with the class runner object. Some tables are restricted and some operations are being blocked for consistency/protection reasons.
Can you share the x++ coding for the script you used? Please use the richt formatting and then Insert > Code where you can paste coding.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,524
Super User 2024 Season 2
#2
Martin Dráb
228,469
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (