Need to change qty. From a decimal to a whole number

Question

0.00/5 (No votes)

See more:

I have ZERO coding experience so please be kind (I'm only a bookkeeper!)
I don't even know what tag to select so it's probably wrong.
Here is the section of code on my invoice:
Begin UserDefinedField Database
Type = 4
Top = 3.697917
Left = 0
Height = 0.1666667
Width = 1.25
FontBold = False
FontUnderline = False
FontName = Arial
FontSize = 9.75
FontItalic = False
FontStrike = False
ForeColor = 0
Description = Line Item - Quantity
Format =999,999,999.9999-
VisualInfo = 3
Frequency = 2
FieldCode = DQTY
TableName = ARInvoiceLineItem
DbFieldTyp = 2
TFieldName = ARInvoiceLineItem.Quantity
END
I know the problem is the 999 number (anyone could figure that out). I've gotten it down to showing Qty. "1." but cannot remove the decimal point. Can anyone help?

What I have tried:

Changing the 999,999,999.9999- to:
999,999,999.
makes my Qty. display as: 1.
Taking away the decimal point and it tells me the form has an error when I try to print it in the program it originates from.
If anyone answers please speak VERY basically and specifically I don't know any coding terms.
Thank you in advance!

Posted 16-May-16 5:46am

Steely deb

Add a Solution

Comments

Richard Deeming 16-May-16 12:12pm

Do you know what program you're using? There's nothing obvious that matches the format of that code block on Google.

OriginalGriff 16-May-16 12:15pm

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
And "Linux" is an operating system, not something your would normally use to process numbers directly. If you like, it's like saying "I can't add numbers correctly" and saying "it's an iPhone" - it doesn't tell us what App you are trying to enter the numbers with!
I'm guessing it's some kind of spreadsheet or database, but we have no idea what kind, or how you are displaying the "Qty" on your invoice. So please, try to explain more precisely what you are doing so we even know what questions to ask you! :laugh:
Use the "Improve question" widget to edit your question and provide better information.

Steely deb 16-May-16 13:14pm

how can I help clarify? I checked Properties and it didn't tell me a program name. This is just all in a program file that came with a application we use called The Construction Manager in our C drive. It is a basic sales invoice that gives Qty, item name, item cost, total amt. etc. I only put the lines of code that deal w/the qty but there is a ton more lines for every category on the invoice. Every adjustment I make to the 999 number changes how the Qty. is displayed on the invoice. I just thought maybe it was a universal coding question that someone could just say "ok change that 999 number to this and it will display a whole number" Please let me know what other info I could give to help, and thank you.

OriginalGriff 16-May-16 14:02pm

OK - in the application is there a "help" or "about" at all?
If so, does that list a company who might have written it, or (better) give a web address / email?

Steely deb 16-May-16 14:09pm

I must sound so stupid, I'm really not I promise! The Construction Manager is it's own thing, it's got A/P, A/R, G/L etc. when you go to their help all it gives you is help topics for those things. I'm not even supposed to be touching the code so they don't give instructions for that. The .txt document that I've been toying with opens up in notepad, and that definitely does not offer any help! I'm starting to feel maybe I should just give up and live with the 1.0 quantity. But we sell conveyors and steel structures, we won't ever have a fraction of one so it really bothers me!

OriginalGriff 16-May-16 14:37pm

No - not stupid at all.
If I tried to price a custom conveyor system I'd sound easily as bad in your speciality! :laugh: (And I have no idea what A/P, A/R, or G/L mean, so you're not the only one feeling stupid!)
If that's in a text file, then it could be anything, is the problem. And changing it without knowing exactly what it's going to otherwise affect is something I'd be reluctant to recommend, particularly when it's such a mission critical function as invoicing (and one which is so closely inspected by the IRS!) Not an area where I want "unexplained irregularities" :laugh:
You really need to find out who wrote the software - have you got the original invoice when it was bought, or do you bay an anual maintenance contract for it?
Does it look like any of these:
http://www.capterra.com/construction-management-software/
I'm guessing not - it's probably the wrong type of "construction".
A quick check on A/P, A/R, and G/L suggests "General Ledger", "Account Pending" and "Account Receivable" - which means it's financial software of some form - which almost certainly means there is an annual charge for updates (the taxman does so love his changes after all) and that might be a very good place to start looking. Find who you pay, and you should be able to find who wrote it - and they will almost certainly have technical support that can tell you what to do.

Steely deb 16-May-16 14:48pm

you are correct about the annual fee, and also they are the first people I tried. She was even more clueless than me, originally the form had 4 four decimal places in the item pricing and she told me it could not be changed. I dug up the coded file buried in our C drive and fixed it myself, lol. If there's anything I could try there's honestly NO risk whatsoever. I've dicked with it so much already, the worst it does it tell me it's an invalid form then I go back and change the number to 9.9 and it goes back to how it was before. So if you could think of anything at all..I'm not messing w/the cost of the thing (so no IRS worries!), just trying to format the quantity.

Patrice T 17-May-16 18:07pm

Did you tried to change from 999,999,999.9999- to 999,999,999- ?

Steely deb 18-May-16 9:09am

That's one of the first things I tried..it actually makes it worse! First I changed the number to 999,999,999- and saved it, then when I put qty. 1 in the form it makes it read 1.000000000! So frustrating!

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)