Forum Discussion
Whilst I appreciate the response, and with all due respect – this is a politician’s answer. It neither acknowledges that there is a problem, nor does it proffer any solutions. The ATO accepts two methods of applying the GST: either taxable supply method or total invoice. There is no real reason for MYOB to be recalculating the GST for the entire invoice as each line is being imported – especially not if I have already explicitly passed through an already pre-calculated GSTamount . I mean if the GST field were left blank in the import file for MYOB to determine and apply the GST, then sure – knock yourself out. But what is the point of passing through a line rate and a GST amount only to then have MYOB ignore both and run some funky process that not only ignores the amount of GST you have passed through but then also recalculates the line rate to some absurd level of precision. Who would voluntarily exculpate this?If it absolutely must validate line by line, then validate the GST amount being passed through from the import file to ensure it is within some sort of acceptable level of rounding tolerance.
But again, to reiterate the original point – sometimes people just need to be able to import invoice pricing that is inclusive of the GST. If I go to McDonalds and buy myself a Happy Meal, I am forking over $6.45 – not $5.86 (ex.) or as MYOB would have you occasionally believe $6.4500222 (inc.).
As it stands, the INCLUSIVE flag seemingly serves no other purpose other than to forcibly trigger the corresponding click event on the box in the editor upon completion of the import. Surely, a more apt use of field would be to allow inclusive prices to be truly imported – put an X into the inclusive field, set $6.45 as the rate and then have MYOB do whatever it needs to do to ensure the inclusive amount remains at $6.45 when the line is imported. To be clear - the flaw is in the import routines, not anything that is occurring once that transaction is in the editor. If you go and create a manual invoice with 1 lot of something and bill it at $49, the editor is more than capable of maintaining the correct product rate, line GST and total invoice GST - even after multiple edits. But export that same invoice and then reimport it back in and it all goes pear shaped.
Just so I know - are we the only idiots in the country that have opted to charge $49 inc. for something?
Hi JohnSeytabla , my post clarifies how MYOB processes invoice line amounts, and demonstrates that it is not currently possible to match GST-inclusive values in the source transaction. This is a failure in the program design.
The import process in the former V19 versions allowed inclusion of exclusive, GST and inclusive values, which was a far better design.
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Learn, solve, grow
Level up your skills and find answers across all MYOB products