Control Sales Module transaction of change Selling Price with a Password

**Example: Sales Invoice

Create [Password] field in Sales Invoice

1. Go to Tools > Customization Centre

2. Expand Model and double click on “QNE Optimum”

3. Expand BOModel

4. Expand QnEBS.BO.Sales > expand SalesInvoices

5. Right click OwnMembers > select Add… > click NonPersistent

6. On Right hand side, setup as following

 i. IsPassword = True

ii. Name = Password

iii. Type = System.String

iv. Size = 10

v. Caption = Password

vi. Id = Password

7. Click Save and logout then login back for system to reload with newly created field “Password”

Setup exact Password for field [Password]

8. Go to Tools > Customization Centre

9. Expand Model and double click on “QNE Optimum”

10. Expand Validation

11. Right click Rules > select Add… > click RuleCriteria

12. On Right hand side, setup as following

 i. SkipNullOrEmptyValues = True

ii. TargetContextIDs = True

iii. Criteria = [Password] = ‘123456’

iv. TargetType = QnEBS.BO.Sales.SalesInvoices

v. CustomMessageTemplate = Incorrect Password. Please try again.

vi. Id = Sales_Invoice_Password

Create Validation Rules to validate Unit Price with Stock Selling Price

13. Right click Rules > select Add… > click RuleRequiredField

14. On right hand side, setup as following:

i. SkipNullOrEmptyValues = False

ii. TargetContentIDs = Save

iii. TargetCriteria = [UnitPrice] <> [Stock.ListPrice] AND [UnitPrice] <> ?

iv. TargetPropertyName = SalesInvoice.Password

v. TargetType = QnEBS.BO.Sales.SalesInvoiceDetails

vi. CustomMessageTemplate = Please key in Password to change Selling Price.

vii. ID = Change_Selling_Price_Password

Setup New field [Password] into Sales Invoice’s layout

15. Expand View

16. Expand QnEBS.BO.Sales

17. Expand QnEBS.BO.Sales.SalesInvoices

18. Select Layout

19. Right Click on the Layout shown on Right side

20. Click [Column Chooser] > click [Add] > select [Password] and click ok

21. Drag out [Password] to the Layout

22. Click Save and logout then login back for system to reload with newly set Validation Rules and layout

Let's try it out on System

**Example Item = AMD-XP/1800 with Sales Price 685.00

1. Go to Sales > Sales Invoice > new

2. Select Stock Code “QMD-XP/1800”

3. Change the Unit Price to 500.00 (different with Sales Price <685.00>)

4. Without key in Password

5. System Will prompted messages inform to key in Password.

6. Then Key in the Password to allow change Selling Price

7. System will allow to save Sales Invoice with Stock Item Price different in Stock Items.

To view full document, please click at the attachment. Thank you.