sales invoice sub form

(0) Share

Report

Posted on by Community Member Microsoft Employee

for sales invoice sub form:

1. The user can select only the Item and the blank value in the type Column. How can I restrict this will entering the data entry fro sales invoice sub form

2. How can I show the invoice header posting date message box, if users select yes, then post the invoice..

Thanks

*This post is locked for comments

All responses (3)

Answers (1)

Verified answer

Mohana Yadav 60,157 Super User 2025 Season 1 on at

Like (0)

Report

RE: sales invoice sub form

1. High Level code is

if "Document Type" = "Document Type"::Invoice then

if NOT (Type in [Type::"",Type::Item]) THEN

ERROR('error message');

2. You need to write code like

if "Document Type" = "Document Type"::Invoice then

IF NOT CONFIRM(

'Posting Date is %1.. Do you want to contineu?',FALSE,

"Posting Date")

THEN

EXIT;
Community Member Microsoft Employee on at

Like (0)

Report

RE: sales invoice sub form

Thanks

1. Yes, can you pls help with the code, it is better, if it on the form level

it should accept item and blank in the type column

2. yes
Suggested answer

Mohana Yadav 60,157 Super User 2025 Season 1 on at

Like (0)

Report

RE: sales invoice sub form

1. You can write code in Table 37 - Sales Line Type OnValidate trigger to show errror message when user has select other option while Documnet Type is Invoice.

2. When you click on Post button in Sales invoice, you want to show a conform message of Posting date and if user presses yes then you want to post the invoice, Am I right?