Sage 100

 View Only

  • 1.  We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 06:45
    We need an Invoice Form that prints the lines in a specific order...by CATEGORY 1 value. I created a new form an everything prints perfect. I just added in the SORTING option the CATEGORY 1... When I then print out the Invoice CERTAIN lines are duplicated. I dont see any logic to only certain lines and not all. Could anyone help how to accomplish this???? By the way. some of the items are lot valuation.


  • 2.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 07:27
    Did you create a new Group for Cat1 in the .rpt? Feel free to post the .rpt.


  • 3.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 07:42
      |   view attached
    here you go..I will start my prayers now... there are some UDFs in CI_Item...you can delete those from the report...

    Attachment(s)

    rpt
    SO_Invoice2.rpt   771 KB 1 version


  • 4.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 08:27
    @LourdesSobrino - This 90M, not Sage. No need to pray!


  • 5.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 09:20
    In detail section A (where the items information is displayed) add logic to suppress if the lot/serial number is NOT blank add: **OR _ {SO_InvoiceWrk.LotSerialNo}<>""""** here is the full suppression logic for detail section a **formula = {SO_InvoiceWrk.ItemType} in array ("""", ""4"") or {@AllowExpandedItemCodes} = ""Y"" or _ PreviousValue({@InvoiceNoLineNo}) = {@InvoiceNoLineNo} OR _ {SO_InvoiceWrk.QuantityShipped} = 0 OR _ {SO_InvoiceWrk.LotSerialNo}<>""""**


  • 6.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 09:23
    I think that will work, I could duplicate what you were seeing with serialized and lot valued items. When I made that change it corrected the issue. (I did have to remove all of your UDF'S from the formulas but I don't think that had any bearing on the issue.


  • 7.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 10:47
    I tried what you mentioned...but now I get ramdon LOT LINES...very weird...


  • 8.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 11:07
    I see! I didn't notice, since your sorting by category1 the lot/serial numbers are not grouped with the appropriate item code. Create a new formula (I called my CategorySort). the formula is simply **{SO_InvoiceWrk.Category1}+{SO_InvoiceWrk.ItemCode}+{SO_InvoiceWrk.LotSerialNo}** then sort by that new formula (take out the category1 sort that you currently have in the record sort expert and replace it with that formula) I've only done minimal testing but I think that will help.


  • 9.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 11:15
    I'd take your category1 field and concatenate that with the Sage report's GroupField and use that formula for your new group 1 data.


  • 10.  RE: We need an Invoice Form that prints the lines in a

    Posted 05-03-2018 12:21
    I think we...sorry, YOU got it right this time.. I didnt need to do the concatenate, but I will keep it in mind as an option next time. THANKS....best geek squad ever...


Related Content