Recent content by Distinctive-Tom

  1. D

    Sage 50 accounts 2014 - Link stock records for 2 products

    Hi We are currently using two separate product records for a lot of products, one uses supplier product codes with cost prices in euros and the other uses our product codes with cost prices converted to sterling. The product with the supplier product code is only used for purchase orders and...
  2. D

    Help needed generating an invoice in sage

    I tried copying the joins over but I just received the 'No data to report' error message on every account. I guess the only thing I can do is personalize one of the statement layouts that begins with 2008 and start using that one permanently? Thank you for all of your help! Much appreciated!! Tom
  3. D

    Help needed generating an invoice in sage

    Hi John, The statements with 2008 at the beginning of the name work fine once I have removed the ADDRESS.LETTER_TYPE_ID = 4 line. If it is a problem with the joins am I safe to copy the joins from the 2008 statement to my personalised statement? Thanks for your help. Tom
  4. D

    Help needed generating an invoice in sage

    Hi John, Oh I see, Sorry I misunderstood. I will test those now. Thanks. Tom.
  5. D

    Help needed generating an invoice in sage

    Hi John, Thank you for your reply. I've just tested a few and it seems that the costs are not duplicated on statements from accounts that were opened after 2008. Kind Regards. Tom
  6. D

    Help needed generating an invoice in sage

    Hi, I have recently had a similar problem with invoicing but it only affected one customer account. I have overcome the problem with invoicing by following the solution suggested by John. (Removing the LETTER_TYPE filter) I am now having a problem with the same customer account but with...