Skip to main content

I’m working on a GI that will have show in a line or partial line on a sales order is allcated.  We use the Product Configurator so if we have a order with 10 configured products on it and one of the 1 is allocated the report will show a line for the one that is allocated and separate line for the 9 that are not.   i can’t see to find the table name for the “Line Details” table on the SOLine that shows if a item is allocated or not and if that is the right table.

I’m currently using the SOLineSplilt and getting the duplicates.  

 

Below are the Relations that i currently have but i have changed each one to no avail. 

any help would be much apricated.

Our Production Team uses this report to keep track of what they have and have not build and sent to shipping.  Shipping allocates the Non Configured Products and the Production Order auto allocates them as they are completed on the Prod. Ord.  

 

either way they drop off the Production list to build. 

@rdillard64 SOlineSplit is the Table and IsAllocated is the boolean field which shows whether or not the item is being allocated or not.

The Fact is SOLineSplit can have multiple lines for each LineNbr from SOLine but those records have exclusive SPlitLineNbr. In case you group them by SplitLineNbr then you will have one to one relation with SOLine Table but that would completely eradicate the usage for Split Table.

Thank you very much for the guidance.   i don’t think i added enough detail. in every case there is a duplicate it is always 2 of the same sales order line.   i tried to see what was unique about those sales orders that were showing duplicate lines  but i can’t find any one item.

i do know if i uncheck the SOLineSplit in the  Relations tab the duplicates go away  and the report only shows one line.

in the section of the report below i had actually shipped a partial of each line so there is a shipment but in other cases there is no shipment.  

 

Reply


Terms & ConditionsCookie settings