Share
ReportIs it possible to modify web service GetCashReceiptByKey to return the amount remaining of the payment?
Categories:
You’re offline. This is a read only version of the page.
63
Is it possible to modify web service GetCashReceiptByKey to return the amount remaining of the payment?
You can with GP Power Tools.
Just install it, activate the trial period and try it.
As I understood, we cannot receive the amount remaining via API (
Same answer as the other forum you have open that I just answered, RE: community.dynamics.com/.../microsoft-dynamics-gp-doesn-t-return-gltransactionbykey-and-glpostedtransactionbykey
If you look at the GetCashReceiptByKey method in the Help file mentioned previously, it shows the Return Value as this:
Return Value:
Value Type Description
GetCashReceiptByKeyResult CashReceipt A cash receipt object.
Click on the 'CashReceipt' link and it shows a list of properties. This is what this method is able to display/show.
From this, it appears that the only Amount we can get from this method is the Amount/MoneyAmount, which is the cash receipt transaction amount.
CustomerKey
CustomerKey
N/A
N/A
The customer key object that uniquely identifies the customer for the cash receipt.
CorporateAccountKey
CustomerKey
N/A
Empty
If the customer is part of a corporate (national) account, the customer key that specifies the parent account.
Key
ReceivablesDocumentKey
N/A
N/A
The receivables document key object that uniquely identifies the receivables document for the cash receipt.
CheckCardNumber
string
20
Empty
The check or payment card number.
PaymentCardTypeKey
PaymentCardTypeKey
N/A
N/A
The payment card type key object that uniquely identifies the type of payment card for the transaction.
BatchKey
BatchKey
N/A
N/A
The batch key object that uniquely identifies the batch to use for the cash receipt.
AuditTrailCode
string
N/A
N/A
The internally assigned audit trail code that gets saved on the record at the time the transaction is posted. This property is read-only.
Type
CashReceiptType
N/A
N/A
Indicates whether the cash receipt type is check, cash or payment card.
BankAccountKey
BankAccountKey
N/A
N/A
The bank account key object that uniquely identifies the bank account for the transaction.
Date
dateTime
N/A
If not provided, defaults to the system date.
The date of the cash receipt.
PostedDate
dateTime
N/A
N/A
The date the cash receipt was posted.
PostedBy
string
N/A
N/A
The user who posted the cash receipt.
GeneralLedgerPosting
Date
dateTime
N/A
If not provided, defaults to the system date.
The general ledger posting date of the cash receipt.
ModifiedDate
dateTime
N/A
N/A
The date the cash receipt document was last modified. This property is read-only.
ModifiedBy
string
N/A
N/A
The user who last modified the cash receipt document. This property is read-only.
Amount
MoneyAmount
N/A
N/A
The cash receipt transaction amount.
Description
string
30
Empty
The description of the cash receipt transaction.
CurrencyKey
CurrencyKey
N/A
N/A
The currency key object that uniquely identifies the ISO code used for the cash receipt.
ExchangeRate
decimal
N/A
0
The exchange rate for the cash receipt transaction.
ExchangeDate
dateTime
N/A
N/A
The exchange date associated with the exchange rate provided.
IsVoided
boolean
N/A
N/A
Indicates whether the cash receipt has been voided.
VoidDate
dateTime
N/A
N/A
The date the cash receipt was voided.
Distributions
ArrayOfCashReceiptDistribution
N/A
N/A
A collection of cash receipt distributions for the cash receipt.
Derek, do you have any updates as to the amount remaining of payments?
Derek, if the API doesn't support the amount remaining of payment, is it possible to:
- add the amount remaining to the response for service GetCashReceiptByKey and patch it?
- use another alternative to receive the amount remaining? If yes, what alternatives and how to use them.
- extend the web service GetCashReceiptByKey? If yes, how to do it?
Thank you!
Derek,
Thank you a lot!
I will wait impatiently because without remaining we cannot handle payments correctly (
Looks like this method returns a Cash Receipt. The only 'amount' value I see mentioned is the cash receipt transaction amount.
It doesn't appear to return the amount remaining on the payment, testing this method, it returns the customer id and then an amount value, which from the sample code for this method, would be the customer id and amount value for the cashReceiptKey.Id value mentioned in the method code.
If I find anything more I'll update this forum, but taking a quick look, I don't seem to find anything in the list of Web Services methods nor eConnect procedures.
Thanks
#1
André Arnaud de Cal...
291,784
Super User 2024 Season 2
#2
Martin Dráb
230,476
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
