Page 1 of 1

Invoice Pub..1000+ error?

PostPosted: Sat Oct 11, 2014 5:55 am
by schmutly
In the Order entry demo if i add items up to $999 all is fine.
The moment i go over $1000 i get an error in the grand Total :/
I changed tax to 0.1 for 10% gst ..the Tax and total work fine up to $999.99
If i try the ship cost really high..its seems fine until you click done
the go back in to view it:
Image after click DONE then REOPEN-->Image

Anyone know what im doing wrong? The subroutines are the same as orig.
I went back and RAN the demo from MyDocuments and i get the 1000+ error too
but i hope i didnt play with that example long ago.

Rather then reinstall the example is there the orderentry PUB on its own so i can test this thanks?
I am trying to use RMB and am using the Yuan symbol but it seems to work until i go over the 1000.

I noticed in the subroutine for the setfieldprops if i
comment out these:
.dbpSetFieldProperties "Orders" "Invoices" "Tax" "DisplayFormat=[Orders.Config.CurrencySymbol]#,#0.00"
.dbpSetFieldProperties "Orders" "Invoices" "ShipCost" "DisplayFormat=[Orders.Config.CurrencySymbol]#,#0.00"
.dbpSetFieldProperties "Orders" "Invoices" "GrandTotal" "DisplayFormat=[Orders.Config.CurrencySymbol]#,#0.00"
I don't get the is the #,#0.00 setup different in my PC for these?
Theyre a little confusing to me they really need to be used and my PC is set for Australia so does this affect
Thanks again,

Re: Invoice Pub..1000+ error?

PostPosted: Sat Oct 11, 2014 10:02 am
by Neosoft Support
It's the display formatting that's causing the errors in the calculation. The Order Entry pub contains a subroutine called "FixForumla" that is used to remove the currency and thousands separator characters from the numbers before the calculation. Replacing this subroutine with the following should solve the problem:

StrReplace "[Formula]" "[Orders.Config.CurrencySymbol]" "" "[Formula]"
StrReplace "[Formula]" "," "" "[Formula]"

Re: Invoice Pub..1000+ error?

PostPosted: Sat Oct 11, 2014 6:03 pm
by schmutly
Thank you Dave,
That fixed it :D