SOP distribution link

[swabunn]

GP 8:00
SQL SERVER 2003

I am making a report in crystal where I want to link sop distribution for inventory back to inventory items. does seqnumbr field in sop10102 have some link to the line items say with sop30300 or any other table

Thanks

-swabunn

 

[Dukester0122]

Let me understand what you want to accomplish here. do you want to show the SOP distribution accounts of all the items in an invoice/order/etc?

if yes then here's what you need to do in Crystal:

1) Add tables SOP10102, GL00100. GL00100 should be added a couple of times which depends on how your Chart of Account is structured. Example, your COA is 3 segments so you'll add GL00100 to your Crystal 3X. The first one would be GL00100 then succeeding tables would be called GL00100_1,etc.

2) Link SOP10102 to every GL00100 tables by using ACTINDX then left-outer join

3) Insert 2 groups: a) SOP10102.SOPNUMBE(Document Number) b) SOP10102.ACTINDX

4) In GL00100 drag ACTNUMBR_1 to the SOP10102.ACTINDX then repeat this to GL00100_1 drag ACTNUMBR_2 to the same group. Repeat the process 'til you have all your segment.

5) Do a test run on one document then compare in Great Plains

6) If everything looks good, you can go further by creating a Formula that would show the segments in one field instead of many.

Hope this helps. Goodluck!!!