My Products
Help
ummya
CONTRIBUTOR **

Fetching and updating customers payment in Business NXT

by ummya

I want to Fetch payment ID, Invoice Id, invoice no,cid, rest of payment, date

 

Secondly,

I want to update payment information such as unpaid to paid, 

2 REPLIES 2
ummya
CONTRIBUTOR **

by ummya

Hi, I tried these two but but both giving me null 

query GetpaymentInfoFromCustomerTransaction {
useCompany(no: 3867961) {
customerTransaction(

filter:
{
voucherType:{_eq:11}

paidStatus:{_in:[3,4]}
}
)
{
totalCount
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
items {
customerNo
orderNo
invoiceNo
voucherNo
voucherType
amountDomestic
outstandingAmountDomestic
cid
dueDate
crossReference
paidStatus
paidLast
createdDateTime
changedDateTime
voucherDate
}
}
}
}

----------------------------------------------------------

query GetPaymentLines
{
useCompany(no: 3867961)
{
paymentLine(first: 1)
{
items {
paymentNo
lineNo

currency : joinup_Currency {
isoCode
}

supplier : joinup_Associate_via_Supplier {
bankAccount

country : joinup_Country {
isoCode
}
}
}
}
}
}

by Marius Bancila

What have you tried? What didn't work? What did you get?