Auto numbering for a custom Object

(0) Share

Report

Posted on by Sab21

130

Hi,

I have a customization requirement in Cash manager module where i need to get the details like Party name, mode of payment & Receipt number in to the system, along with the usual entries in the "Details" section in the Transactions screen..

Name & mode of payment can be entered by the user but i want the Receipt number to be auto generated by the system..

Can anyone kindly tell me how this can be done?

*This post is locked for comments

All responses (3)

Answers (0)

KenF58 1,035 on at

Like (0)

Report

RE: Auto numbering for a custom Object

Custor should read Customer!!!
Suggested answer

KenF58 1,035 on at

Like (0)

Report

RE: Auto numbering for a custom Object

This code finds the last custid, adds 1 to the value and sets the result in the CustID field on the customer maintenance screen.

I guess you could do something similar...

Private Sub btnNext_Click()

Dim SqlStr$, nextCustid$

SqlStr = "UK%"

SqlStr = "select max(CustId) from Custor where Custid like" + SParm(SqlStr)

Call sql(c1, SqlStr)

serr1 = SGroupFetch1(c1, bCustMax, LenB(bCustMax))

Call IncrStrg(bCustMax.CustId, 8, 1)

nextCustid = Trim(bCustMax.CustId)

' Call SetStatusBarText("Next UK Customer is " + nextCustid, "")

serr = SetObjectValue("cCustid", nextCustid)

End Sub
Community Member on at

Like (0)

Report

RE: Auto numbering for a custom Object

From which screen do you enter the payment?