70
Hello,
I am trying to create a report layout from scratch for sales order.
From my understanding the logic for getting blanket sales order no. in the dataset will be :
Main Table : Sales Header 1
2nd table : Sales Lines(Linked to sales header 1 on salesheader1.no. = saleslines.documentno.)
3rd table: Sales header 2(Linked to sales line on salesline.blanketsalesorderno. = salesheader2.no.)
But the field shows blank, anything wrong I am doing here ?
As far as I remember, the blanket order is not deleted when converting to order. The fully invoiced blanket sales order remains in the system until it is deleted, either by deleting individual blanket orders manually or by running the Delete Invoiced Blanket Sales Orders batch job.
Otherwise, you may need to customize BC to archive the blanket order upon deletion.
What kind of information do you need from Blanket Order? If the Blanket Order is already deleted, I would guess that the Blanket Order already served its purpose and there is no need to check the Blanket Order. If you want to know how many orders have been shipped, you might want to check the posted tables.
Elaboration : I was working with dataset and dataitem within it. Was asking the link for sales order with blanket sales order in dataitem. Now i realized that blanket sales order has been deleted because it was converted to sales order. How can i get the number of deleted blanket sales order now ?
Can you elaborate more ?
Did you also filter the document type ? Did you create a report layout (rdlc) ?
Share
Report
All responses (
Answers (
