How to create Sales Order and how to retrieve invoice number for that Sales Order in SSMS

Creation of a Salesorder

Open the front office or front end, then pick the company.

On the left side, we have a Hamburg symbol; click on it and select Accounts Receivable.

Then select all sales orders under the orders tab. The sales order page will open.

Select New on the action pane. From the right side, we can see the sales order creation page. Select the customer name and give the site and warehouse details.

Click OK.

Next, attach the item, units, and unit price to the new sales order. save it.

Later, go to the action pane, click on pick and pack, and under Pick and Pack, select Generate. Under Generate, select Generate, and under Generate, select Generate Picking List.

After clicking Ok, it will show you one pop-up, which is "You are about to post the document without printing it." Select OK.

Next, select "picking list registration" under Generate.

Then it will open the new page to "update" it. Select update all under Update. 

Later that, come back to Sales Order and select your newly created sales order. In the action pane, we have the Invoice tab, which is under Invoice=>Select Generate=>Select Invoice.

it will show you Pop ups to conform the sales order

Invoiced the order.


SQL script:
Scenario: Get the Invoiceid , Salesstatus, AccountNum, AccountName for the Salesorder which is created.

 

I wrote the Query to find InvoiceId, Accountnum and SalesStatus for the perticuler SalesId.

Hope this info is useful to you....🙂 Thanks for the Visit....👍