Exporting Vendor payment status by Dataentity

/// <summary>
/// Entity for exporting file of payment status.
/// </summary>
public class KGSPMIVendorPaymentStatusEntity extends common
{

/// <summary>
/// Updates the unmapped fields after population.
/// </summary>
public void postLoad()
{
str recordTypeValue = '600';
str paymentMethodCheck = 'C';
VendTrans tmpVendTrans;
VendSettlement vendSettlement;
super();
vendSettlement = VendSettlement::find(this.RecId1);

this.RecordType = recordTypeValue;
this.TotalAmount = abs(this.SettleAmountCur);
this.PaymentDate = date2Str(this.TransDate,321,2,DateSeparator::None,2,DateSeparator::None,4);
this.Account = VendTable::find(this.AccountNum).vendorName();
if(this.PaymMode == "Check")
{
this.PaymentMethod = paymentMethodCheck;
}
else
{
this.PaymentMethod = "";
}
tmpVendTrans = VendTrans::findByCompany(vendSettlement.company(), vendSettlement.TransRecId);
this.Invoice = tmpVendTrans.Invoice;
}
}


1.1            Privileges


1.1.1.1                     KGSPMIVendorPaymentstatusEntityMaintain


Entry points

Name
Object Name
Object Type
Access Level
KGSPMIVendorPaymentStatusEntity
KGSPMIVendorPaymentStatusEntity
DataEntity
Delete

 

1.1.1.2                     KGSPMIVendorPaymentStatusEntityView


Entry points

Name
Object Name
Object Type
Access Level
KGSPMIVendorPaymentStatusEntity
KGSPMIVendorPaymentStatusEntity
DataEntity
Read


1.1.1.1                     KGSPMIVendorPaymentStatusEntity


Change type: Add

Field name
(Extended) data type
Change type
Configuration key
Other properties
RecordType
Str
ADD
 
 
PaymentDate
Str
ADD
 
 
Account
Str
ADD
 
 
PaymentMethod
Str
ADD
 
 
Check
BankChequeNum
ADD
 
 
InvoiceValue
VendInvoiceId
ADD
 
 
Currency
CurrencyCode
ADD
 
 
Reserved1
Description255
ADD
 
 
Reserved2
Description255
ADD
 
 
Reserved3
Description255
ADD
 
 
Reserved4
Description255
ADD
 
 
Reserved5
Description255
ADD
 
 
TotalAmount
Real
ADD
 
 
TransDate
TransDate
ADD
 
 
Voucher
Voucher
ADD
 
 
SettleAmoountCur
Real
ADD
 
 
AccountNum
VendAccount
ADD
 
 
RecId1
RefRecId
ADD
 
 
PaymMode
PaymMode
ADD
 
 

Methods (Put NA if not used) but keep the section

Method name
Method signature
Pseudo code
Remarks
PostLoad( )
public void postLoad()
//implement most of their business logic related to integrations
To update unMapped fields on update as we are not receiving these in the file and these are mandatory for Vendor Payment Status.

1.1.1.1                     KGSPMIVendorPaymentStatusStaging

Change type: Add
This table is the staging table of data entity created for Vendor Payment Status Export.
Fields (Put NA Is not used)
Field name
(Extended) data type or Enum
Change type
Configuration key
Other properties
DefinitionGroup
DMFDefinitionGroupName
ADD
 
 
ExecutionId
DMFExecutionId
ADD
 
 
IsSelected
DMFIsSelected
ADD
 
 
TransferStatus
DMFTransferStatus
ADD
 
 
RecordType
Str
ADD
 
 
PaymentDate
Str
ADD
 
 
PaymentMethod
Str
ADD
 
 
InvoiceValue
VendInvoiceId
ADD
 
 
Reserved1
Description255
ADD
 
 
Reserved2
Description255
ADD
 
 
Reserved3
Description255
ADD
 
 
Reserved4
Description255
ADD
 
 
Reserved5
Description255
ADD
 
 
Account
str
ADD
 
 
TotalAmount
Real
ADD
 
 
Check
BankChequeNum
ADD
 
 
Currency
CurrencyCode
ADD
 
 
 
Field groups (Put NA Is not used)
Field group name
Fields
Justification
ExtensionList
DefinitionGroup
 
 
ExecutionId
 
 
IsSelected
 
 
TransferStatus
 
Field groups (Put NA Is not used)
Field group name
Fields
Justification
AutoIdentification
DefinitionGroup
 
 
ExecutionId
 
 
InvoiceValue
 
 
Indexes (PUT NA is not used)
Index
Allow duplicates
Fields
Justification
StagingIdx
No
DefinitionGroup, ExecutionId, InvoiceValue
 
Relations
Relation
Table
Validate
Justification
DataEntity
KGSPMIVendorPaymentStatusEntity
No
 

Comments

Popular posts from this blog

Data entites method calling sequence in D365FO

How to Extend Sales Order Update Functionality to Custom Fields in D365 Finance and Operations

To generate dimension and find the account value - KGSPMIDimensionUtility