New Member

[stewartsetter]

Hi All, I'm new to the forum and also new to Progress.

Sorry to jump in with my first query, but I need to find the where MFG Pro v9 holds the period no. i can get to the date field but not to where the actual period is.

Example

Date = 01-04-2008
Period = 4

Many thanks,
Stewart

 

[tamhas]

You might try asking on the QAD MFGPro forum here or elsewhere.

 

[klebaum]

what do you mean with "period"?
The month?
If yes, you can use month(variable) and you'll get the month.

I hope I had helped you.

- Kleber
klebaum@gmail.com

 

[tamhas]

Accounting period is only accidentally related to calendar months. Many companies, e.g., Progress Software, start the fiscal year on a month other than January and others use fiscal periods other than months, e.g., 26 two week blocks.

So, fiscal period is going to be specific to the software implementation.

 

[stewartsetter]

what do you mean with "period"?
The month?
If yes, you can use month(variable) and you'll get the month.

I hope I had helped you.

- Kleber
klebaum@gmail.com

Hi Kleber,

how would the month(variable) if into the below:

define





date Date_from = parameter/cls prompt "Enter date from" default
todaysdate ;
date Date_to = parameter/cls prompt "Enter date to" default todaysdate ;
string Prod_Line_Channel = invoice_history:Channel + Prod_Line;
file addressdet = access ad_mstr, set ad_mstr:ad_addr =
invoice_history:bill_to;


where
( invoice_date >= Date_from and invoice_date <= Date_to )
and ( value_gbp <> 0 )
and ( prod_line <> "ZV" )
and ( prod_line <> "ZDNP" )
and ( Prod_Line_Channel <> "SUPPLYCONS" )
and ( Prod_Line_Channel <> "WARRANTYPUGE" )
and ( Prod_Line <> "ZAAG" )

sum/duplicates/xls/domain="invoice_history"
invoice_history:value_gbp/decimalplaces=2

by
invoice_history:inv_year
invoice_history:Invoice_Date
Prod_Line_Channel
invoice_history:bill_cust_name
addressdet:country_code
addressdet:country

Thanks,
Stewart

 

[tamhas]

I don't see any reference to either month or fiscal period in there. What is it that you want?

 

[zee]

The period number is stored in glc_cal, fieldname glc_per. You may need to use glc_start and glc_end to determine the appropriate period (period start and end dates).

HTH