x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 60 subscribers
  • Views 2440 views
  • Users 0 members are here
Browse Forums
Announcements
78
topics
166
replies
General Discussion
5k
topics
16k
replies
Installation and Upgrades
985
topics
3k
replies
Inventory, Projects, and Departments
340
topics
1k
replies
Payables and Receivables
1k
topics
4k
replies
Payroll
1k
topics
3k
replies
Reconciliation and Banking
319
topics
997
replies
Reporting and Analytics
207
topics
401
replies
Soutien Technique - Français
633
topics
1k
replies
Year End Activities
225
topics
596
replies
LaFamiliaSanchez

Recurring Transaction with GST rounding ... how to make it stick?

SUGGESTED
Posted By

Good Morning,


I have saved a recurring Payable Invoice to save me time as the Invoice is always the same. The only issue is that there is a rounding issue.  My system gives me 14$ of GST while the Invoice is 13.98.  Usually that is no problem as I just manually change it but I noticed that the change does not stick to the Recurring Invoice.  I have to remember to change the GST amount every time I pull it up.  Am I doing something wrong?  There should be a way to keep the Invoice the way I want it!!

Any suggestions would be appreciated as at the moment I have a line that looks like this: ********** GST rounding -0.02 ***********  but even with that, if I'm in a rush I might not remember to change the GST to 13.98.  I only noticed the problem last Bank rec, fortunately for some reason I had paid the correct amount!!! All I had to do was fix the Invoice and the payment in Sage...

  • 0
    SUGGESTED

    LaFamiliaSanchez said:
    Any suggestions would be appreciated as at the moment I have a line that looks like this: ********** GST rounding -0.02 *********** 

    I usually do exactly that, and put the $.02 against the GST Paid account, and save the recurring transaction.   Check that the GST is correct in the journal entry with control-J.

    Make sure you save the recurring transaction (posting it does not save your changes, only reschedules what was previously stored)

    Or, you could over-ride the GST calculation on one or more detail lines. Recurring purchase transactions have a field on each line for the tax amount, and store a flag 'bTaxAmtDef' that remembers whether you over-rode the amount. 

    There does seem to be an over-ride stored on the total GST, not sure why it's not working there.

    I hope that helps, please post back.

    Randy

  • 0 in reply to RandyW
    It is just weird, it doesn't matter how I try to save the recurring invoice:

    I tried to change the GST in one of the lines and save ... NOPE --- when I open the Recurring Invoice the GST is back to what it wants to be.
    I tried making a separate line with -0.02 in the GST column, but that too will not stick.
    I tried changing the GST at the bottom of the Invoice where you do a general change and that too will not stick.

    The recurring entry keeps the GST the way it WANTS it to be. I think that is really odd.
  • 0 in reply to RandyW
    What is flag 'bTaxAmtDef' ?
  • 0 in reply to LaFamiliaSanchez
    It's a field in one of the tables that stores the information for the recurring entries. In this case, it is being ignored. I just reset it manually on a sales recurring invoice and it ignored the stored tax amount and the program recalculated the tax amount when the entry was recalled. So it looks like you found a bug that can't be fixed at the end-user level.

    However, posting a $0.02 entry on a separate line that posts directly to the GST Paid liability account does work.
  • 0 in reply to LaFamiliaSanchez
    Have a separate line with the -0.02 in the amount column, not the GST column, and post it to the GST account (eg. 2315). Save the recurring transaction. Note that this will not show up if you are using the GST reports to calculate and remit your GST, but the GST reports are a nightmare anyway and I always suggest that people use the actual GL accounts and P&L report for their GST remittance amounts instead.

*Community Hub is the new name for Sage City