Question Need larger than 9 decimal numerical digits on reports

[Krist]

Dear all,

We are in the process of implementing QAD 2013 EE. One of the problem is the biggest number the standard financial reports is 9 decimal numerical digits. Obviously we need bigger number than that.
We are new in progress and QAD,
Could anybody here please kindly advise :
- How can I know which xxxxx.p programs should I modify to get larger number digits on the report ?
- In which part of the above progress program usually the numerical format is defined in the reports ?
It seems that its in different location for different programs.

Sorry for this newbie question, yes indeed we are new and quite overwhelmed by this product.

Many thanks for your help
Krist

 

[rzr]

I have never worked on QAD products... but you should start by looking at the "FORMAT" keyword in help pages.
Ex:

DEFINE VARIABLE iField1 AS INTEGER  FORMAT "999999"  NO-UNDO.
DEFINE VARIABLE iField2 AS INTEGER  FORMAT "9999999999"  NO-UNDO.
 
ASSIGN iField1 = 123456
       iField2 = 1234567890.
DISPLAY iField1 iField2.

 

[rzr]

- How can I know which xxxxx.p programs should I modify to get larger number digits on the report ?

If you know the field(s) in question that need the larger number digits then you could "grep" for these fields in your source code. This should give you the list of programs that use this field.

- In which part of the above progress program usually the numerical format is defined in the reports ?

FORMAT can be defined at time of definition or display.

DEFINE VARIABLE cSalary AS INTEGER FORMAT "999,999,999" NO-UNDO.
or...
DISPPLAY / PUT    cSalary FORMAT "999,999,999".

 

[Krist]

Hi RZR,
Thank you very much for your help.
Regards,
Krist