Results 1 to 7 of 7

Thread: Pastel Invoices/Summary

  1. #1
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Location
    Rustenburg
    Posts
    927
    Thanks
    175
    Thanked 136 Times in 108 Posts

    Pastel Invoices/Summary

    I have set my invoicing to round to the nearest 50 cents.
    The printed invoice is fine and does the rounding perfectly, showing the original amount and the rounding difference.
    However when I print the invoice summary, it reflects the original and not the rounded amount, with the result that the cash box does not balance with the summary.
    How now ?
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.
    www.straptite.com

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

  2. #2
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Location
    Rustenburg
    Posts
    927
    Thanks
    175
    Thanked 136 Times in 108 Posts
    Quote Originally Posted by Martinco View Post
    I have set my invoicing to round to the nearest 50 cents.
    The printed invoice is fine and does the rounding perfectly, showing the original amount and the rounding difference.
    However when I print the invoice summary, it reflects the original and not the rounded amount, with the result that the cash box does not balance with the summary.
    How now ?


    Anyone ??
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.
    www.straptite.com

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

  3. #3
    Bronze Member Elijah's Avatar
    Join Date
    May 2012
    Location
    Cape Town
    Posts
    129
    Thanks
    28
    Thanked 26 Times in 21 Posts
    Hi Marinco

    Have you tried printing to excel and using Excel's round function? Excel can round to the nearest 50c. If you using Excel to do your recon then this might be a possibilty. If so, I can give you the formula to accomplish the rounding [if this is an option for you], unless, of-course some-one like Neville can give you a direct solution in Pastel.
    Last edited by Elijah; 10-Jul-13 at 12:02 PM.

  4. #4
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Location
    Rustenburg
    Posts
    927
    Thanks
    175
    Thanked 136 Times in 108 Posts
    Quote Originally Posted by Elijah View Post
    Hi Marinco

    Have you tried printing to excel and using Excel's round function? Excel can round to the nearest 50c. If you using Excel to do your recon then this might be a possibilty. If so, I can give you the formula to accomplish the rounding [if this is an option for you], unless, of-course some-one like Neville can give you a direct solution in Pastel.
    Thanks Elijah,

    First prize would obviously be if the situation can be solved directly in Pastel but yes, this is an option.

    Thanks

    Martin
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.
    www.straptite.com

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

  5. #5
    Bronze Member Elijah's Avatar
    Join Date
    May 2012
    Location
    Cape Town
    Posts
    129
    Thanks
    28
    Thanked 26 Times in 21 Posts
    Hi Martinco

    If no-one can assist you within Pastel, then try this formula =MROUND(CELLADDRESS,0.5) . The MROUND function needs the analysis toolpak addin to be installed if you running excel version prior to Excel 2007.
    Let me know if this works for you.

    Regards
    Elijah

  6. Thanks given for this post:

    Martinco (15-Jul-13)

  7. #6
    Gold Member Martinco's Avatar
    Join Date
    Oct 2008
    Location
    Rustenburg
    Posts
    927
    Thanks
    175
    Thanked 136 Times in 108 Posts
    Will this work on Open Office as well ?
    Martin Coetzee
    Supplier of Stainless Steel Band and Buckle and various fastening systems. Steel, Plastic, Galvanized, PET and Poly woven.
    We solve your fastening problems.
    www.straptite.com

    You may never know what results will come from your actions, but if you do nothing, there will be no results... Rudy Malan 05/03/2011

  8. #7
    Bronze Member Elijah's Avatar
    Join Date
    May 2012
    Location
    Cape Town
    Posts
    129
    Thanks
    28
    Thanked 26 Times in 21 Posts
    Hi Martinco

    Only used open office once and briefly at that. What I do re-call though is that it does have all/most of excel's functions, So it should work there as well, but as I mentioned don't know much abt Open Office. But I am 90% certain it would work in open office.

  9. Thanks given for this post:

    Martinco (16-Jul-13)

Similar Threads

  1. Inserting logo onto Pastel invoices
    By KimH in forum Accounting Forum
    Replies: 82
    Last Post: 22-Sep-16, 11:56 AM
  2. Printing Company on Pastel Invoices
    By Ramesh in forum Accounting Forum
    Replies: 1
    Last Post: 17-Dec-12, 06:22 PM
  3. [Question] Recurring Invoices Pastel Xpress?
    By fuzegraphics in forum Accounting Forum
    Replies: 3
    Last Post: 22-Nov-12, 07:29 AM
  4. Pastel - Multiple invoices at once?
    By mother in forum Accounting Forum
    Replies: 6
    Last Post: 18-Jul-11, 09:59 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •