![]() ![]() ![]() In both cases, the GST is calculated at 31 cents according to the "History" function. ![]() If I create a new sale with the same price and quantity, I get a seemingly identical document without the discount. Importing this data set results in a line with price, total and tax as expected, and a discount of -0.65% in the item's discount field. It does not match anything in the import interface and appears to be harmless. Tax rate is an extra field that shows the rate used to compute the derived figures, and it is somewhat like 10/11. The import data looks like this (transposed for your reading convenience) Date Heres whats going to happen: AccountEdge Pro replaces last years. And owing to the magic of my product, people buy them in sets of eleven.Įleven of these things cost 11 x 0.31 = 3.41. The purge might happen in 2020 (rather than in 2021, data too close to an election. My test case is one particular product where the inc-tax price is $0.31. 'GST Amount' (derived from 'Inc-tax Total' - 'Total').'Total' (which is ex-tax) (derived from 'Price' x 'Quantity' where price is rounded to whole cents).'Price' (which is ex-tax) (derived from 'Inc-tax Price' x 10 / 11 can be a repeating fraction).'Inc-tax Price' (derived from 'Inc-tax Total' /'Quantity' always computes to whole cents).This is, obviously, hokey, - it should record the price, tax and other stuff, but it was written by PHP programmers, evidently with no input from accountants. My online store records only the line total and the quantity. If I enter the same item in a sale manually with the same numbers, I do not get a discount, and I am guessing that this is because the GST is calculated internally. Most of them are perfect, but some grow a small discount (plus or minus a percent or part thereof) which I presume relates to rounding of GST. My sales orders can have upwards of 100 items. There is one minor issue that I would like to solve. On the whole, the process was successful, although the amount of trial-and-error does not speak well of the documentation. While you were all standing in the sun all day waiting for midnight fireworks, I managed to convince my online store and MYOB to co-operate on importing a sales order. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |