Sage Intelligence reporting

SOLVED

Trying to run a report that will access the "Ship Via" field that is available in individual invoices. The only option is the "Customer Ship Via" that I can find, and while that is great to know how they prefer shipment, I need to know how the item was actually shipped! Am I missing this column or is it just not available through Intelligence reporting? If not, why???

  • 0

    It is possible to access that field, but the only way I could figure out a way was to use the Connector Module.

    If you have the Connector Module, the Ship Via option is inside the General_Inv table. You can add the General_Inv container in the Connector Module, and then select the ShipViaDesc fields.

  • 0 in reply to Muttaqi

    Thanks for the info... off to learn about the Connector Module now!

  • 0 in reply to Muttaqi

    ok, so this is the answer for sure, now I guess I will have to find someone that can help create the correct JOIN sql to get it working. Not sure where to join the fields into the existing container that the original report used (I have recreated that original JOIN in this new container, just not sure how to add these ShipViaDesc fields). Thanks for pointing me in the right direction though!

  • +1 in reply to mudmixer
    verified answer

    Well, paid the ransom for a connector license and after a bit of learning I did find the Gen_Inv table you referenced but the field I was looking for was actually in the JrnlHdr table and labeled "ShipVia". What I was after was the actual ship method used for each invoice and this field does the trick. Ended up being simply adding the expression to the container and presto, my problem was solved!