Notifications
Announcements
No record found.
I am pulling a report from the Sales Payment Work and History table. What does the 'payment type' values represent.
I am seeing 4 and 6, in some instances there is a bank ID associated.
*This post is locked for comments
Hi Rose Mary,
if the document type is Payment then its value is 9
4 is for Finance Charge and 6 is for Warranty.
ROSEMARY,
Where did you get the Sales Work and History report? From Smartlist or SQL?
In Smartlist, then please mention the smatlist name or SQL, then mention the Table name and exact field name. Because the Payment Type field is not available in Receivable only available in Payables.
Hi Rosemary,
If I'm looking at the right table, here is what the types mean. The field I am referring to is the RMDTYPAL field
0 - reserved for balance forward customers
1 - sales/invoices
2 - scheduled payments
3 - debit memo
4 - finance charge
5 - service / repair
6 - warranty
7 - credit memo
8 - return
9 - payment
Kind regards,
Leslie
I am using Smartlist Builder and my apologies, the file name is Sales Payments Work and History.
I guess no column "Payment Type" found in Sales Payment smartlist. I think Payment Type is nothing but the Cash Receipt Type(Check, Cash and Credit Card). For confirmation, can you attach the screen shot for your smartlist with Payment Type?
I got this, thanks
I checked the actual transaction and you are correct
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
