Sage 100

 View Only
Expand all | Collapse all

How To Assign a Package Number to an Invoice Line Item

  • 1.  How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 10:27

    The customer uses SO Shipping Data Entry and assigns package numbers to each line item.  How can I print the package number on a packing list line Item using Crystal Reports?  The invoice no, package no, and item code is in SO_PackageTrackingByItem.  I hoped there would be a package no field in SO_InvoiceDetail or a line key in SO_PackageTrackingByItem, however I don't see one.  is there a field I am missing or am I missing another table that connects the dots?  



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 10:33

    Also - they can have the same item on a shipment more than once.  For example, line 1 could have qty shipped 14 of item ABCDEF and then line 5 could have qty shipped 25 of item ABCDEF.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 11:02



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 11:19

    Thank you @Kevin Moyes



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 5.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 15:28

    On the primary packing list the per unit item weight is SO_PackingListWrk.ItemWeight. On the additional packing lists I am using SO_AdditionalPackingListWrk.Weight.  Does anyone have a theory as to why the weight prints on the primary packing list and does not print on the additional packing lists? 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 6.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 15:32

    Well, if you've looked in the Wrk file and the field is empty, I'd say... BUG.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 7.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 15:39

    I'm about to pull a Wayne and lose my S*$% !!  Another one?? I was hoping the additional packing lists used actual weight that was somehow assigned during the shipping process and I was missing where that process occurred.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 8.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 15:53

    Somewhere, there is a HUGE pile of S* that people have lost over the years.  If only someone who NEEDED some S&! was able to find this lost pile and make use of it. Sad. Of course, this assumes the losers do not want their S^$ back, which may not be the case.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 9.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 16:18

    LOL!  What's frustrating is that this work table must not had been subject to even basic quality assurance testing.  The first test should be insuring all of the fields in the table could get populated with data from the permanent table!  Now it's supposed to be my job to explain it to Sage, reply to four or five of their emails, then wait for communication from a senior analyst.   This issue has more than likely been discovered before, but the person discovering it simply joined the CI_Item table to get the weight which is what I am going to do.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 10.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-24-2024 16:37

    Unfortunately, I think that's what happens a lot - we find a way around it and don't bother letting Sage know about the issue.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 11.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-25-2024 12:00

    @Doug Higgs - This sounds so familiar with what I encountered in the late aughts when I lived in Iowa (also sometimes confused with heaven in movies).  I needed a field in AdditionalPackingListWrk table (it was available in the PackingListWrk table) and there was no workaround.  I had two options at the proverbial fork in the road - report it to Sage and then move on or just move on.  I chose the easier path by simply moving on.  Sad but true.  Client was happy with what was accomplished.

    FWIW, maybe the Minds could convince Sage of the need of a simple bug report website for RESELLERS only.  More often than not, bugs reported are determined to be Working As Designed instead of Working As Desired!!!  Worth a shot.  Chances are slimmer than a snowball in Hades (the pushback for the reversing JE date still burns in memory) but call me Pollyanna....  Maybe one day.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 12.  RE: How To Assign a Package Number to an Invoice Line Item

    Posted 05-25-2024 15:48

    @Jeff Schwenk  I love your idea about the bug report web site.  It would be more efficient to report a suspected bug and then have Sage investigate it. 

    Besides doing a work around, I am going take one for the team and report this to Sage next week.  It is a bit frustrating because this is the third bug I have discovered in the last month.  This current one could have been easily found with some basic QA testing.  below are the other two bugs I reported:

    4/22/2024
    Case#8010056829 - Data is not selected for report printing when running AP Cash Requirements Report and selecting AP_Vendor UDF value in selection screen.  Scott Brady wrote and published Knowledgebase entry:Solution ID: 240422232343990 and Defect# 117024.

    5/13/2024
    Case#8010080313 - Sage 100 redirects tracking package to wrong carrier.  Scott Brady wrote and published Knowledgebase entry:Solution ID: 240511012040197 and Defect#117091.
     



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------