Inventory visibility
1. InventInventoryDataServiceBatchJobTask => Method (create)
2. InventSum => InventInventoryDataServiceInventSumBatchJobTask
3. OnHandChangeSchedule => InventInventoryDataServiceOnhandChangeScheduleBatchJobTask
4. WhsInventReserve => InventInventoryDataServiceWhsInventReserveBatchJobTask
[ExtensionOf(classStr(InventUpd_Reservation))]
final class InventUpd_ReservationCls_SAN_Extension
{
void updateNow()
{
if(movement != null && movement.buffer())
{
curBuffer = movement.buffer();
switch(curBuffer.TableId)
{
case tableNum(SalesLine) :
salesLine = curBuffer;
salesTable = salesLine.salesTable();
break;
}
if(salesLine && salesTable)
{
if()// add requires if needed for reservsation skip
{
reservation = 0; //To stop reservation
}
}
next updateNow();
}
GRID => Properties
"Export Label" => "SalesReportMexico"
To get download file with custom naming.
validateExistCommonRecord(
RefTableId _refTableId,
RefRecId _refRecId)
{
boolean ret = true;
if (!_refTableId || !_refRecId)
{
ret = CheckFailed(strFmt("Incorrect parameter for the function called ", funcName()));
}
if (ret)
{
Common record = new DictTable(_refTableId).makeRecord();
select firstonly RecId from record
where record.RecId == _refRecId;
if (!record.RecId)
{
ret = checkFailed("Record not found");
}
}
return ret;
}
Content copied from AI.
Azure
Function Apps provide a serverless, event-driven compute service that lets
you run code in languages like C#, Python, JavaScript, and Java without
managing infrastructure. They scale automatically, offering a cost-effective
"pay-per-use" model suitable for processing data, integrating
systems, and building APIs.
Key
Aspects:
Prerequisites:
Azure Functions => Trigger types (Most commonly used triggers)
//Get or adjust tax calculation using TAXDOCUMENT framework (Tax calculation service)
TaxRegulation taxRegulationDetail;
TmpTaxRegulation tmpTaxRegulationDetail;
SalesTotals salesTotals;
salesTotals = SalesTotals::construct(SalesTable::find(salesLineParentPOl.SalesId), SalesUpdate::All);
salesTotals.calc();
taxRegulationDetail = TaxRegulation::newTaxRegulation(salesTotals.tax());
tmpTaxRegulationDetail.setTmpData(taxRegulationDetail.tmpTaxRegulation()); // Get all current tax by order wise
//Get this buffer "tmpTaxRegulationDetail" to get all tax related data
//To adjust
TaxTable taxTable;
select firstonly tmpTaxRegulationDetail
where tmpTaxRegulationDetail.TaxCode
join taxTable
where taxTable.TaxCode == 'SAN_IPI';
if(tmpTaxRegulationDetail)
{
taxRegulationDetail.updateTaxRegulationAmount(tmpTaxRegulationDetail, (<Updated tax amount after adjustment>), true); // to adjust use this call to do
taxRegulationDetail.saveTaxRegulation(); //
}
--Vendor default primary address
Select vt.AccountNum, vt.Party, vt.RecId, lpd.RECID, dpl.LOCATION, lpd.ADDRESS from VENDTABLE vt
join DirPartyLocation dpl on dpl.Party = vt.Party
join LogisticsPostalAddress lpd on dpl.LOCATION = lpd.LOCATION
where vt.DataAreaId = 'usrt' and dpl.ISPRIMARY =1 and lpd.VALIDTO = '2154-12-31 23:59:59.000'
--Warehouse default primary address
Select it.InventLocationId, it.INVENTSITEID, it.RecId, lpd.RECID, lpd.ADDRESS
from INVENTLOCATION it
join InventLocationLogisticsLocation illl on illl.INVENTLOCATION = it.RECID
join LogisticsPostalAddress lpd on lpd.LOCATION = illl.LOCATION
where it.DataAreaId = 'usrt' --and dpl.ISPRIMARY =1
and illl.IsPostalAddress =1 and illl.IsPrimary =1 and lpd.VALIDTO = '2154-12-31 23:59:59.000'
WMS Mobile app flow
=> Adding Detour fields for Process guided framework custom implementation
Before fix:
Adding code fix to get thos requires field.
/// <summary>
/// WHS APP FLOW Detour fields implementation SAN_WHSMobileAppFlowPOLMovementLPCreation
/// Run Create Default setup from Mobile device steps
/// </summary>
[WHSWorkExecuteMode(WHSWorkExecuteMode::SAN_MovementLP)]
class SAN_WHSMobileAppFlowPOLMovementLPCreation extends WHSMobileAppFlow
{
protected void initValues()
{
// add available fields
this.addAvailableField(extendedTypeNum(InventSerialId));
this.addAvailableField(extendedTypeNum(WHSLicensePlateId));
this.addAvailableField(extendedTypeNum(ItemId));
}
}
Post fix:
Reference class: RetailSyncOrdersSchedulerTask
Error readable:
private str generateHumanReadableErrorDetail(System.Exception _exception, str _errorDetail = '')
{
str errorDetail, exceptionType, stackTrace, exceptionMessage;
errorDetail = _errorDetail;
// When the CLR error encounters it gets the inner exception message, call stack and stores in Database.
if (_exception && _exception.InnerException)
{
if (_exception.InnerException.InnerException && _exception.InnerException.StackTrace)
{
// Use inner exception if it is available as it is often more descriptive.
errorDetail = errorDetail ? errorDetail +
_exception.InnerException.InnerException.Message : _exception.InnerException.InnerException.Message +
_exception.InnerException.StackTrace.ToString();
}
else if (_exception.InnerException.StackTrace)
{
errorDetail = _exception.InnerException.Message + _exception.InnerException.StackTrace.ToString();
}
else
{
// When the exeption not returns a call stack, we get the call stack from the <c>Xsession<c> object.
errorDetail = _exception.InnerException.Message + con2str(xSession::xppCallStack());
}
}
return errorDetail;
}
Replaces the value of the specified dimension attribute from source to target =>
LedgerDimensionDefaultFacade::serviceReplaceAttributeValue(<source dimension>, <target dimension>, DimensionAttribute::findByName("<Dimension name>").RecId);