FRX Report Date is not setting.

frx report date not setting

frx report date not setting

In this situation the FRX dates are not sticking to newer periods.  The fiscal periods at Dynamics GP has been created, the old period has been closed.  The problem was associated to only one user. The sticky situation was resolved as follows:

1) The sysdata directory was backed up.

2) All users using FRX were requested to log off.

3) All G32 files at the SYSDATA folder was deleted.

4) Logged as user who did not have the did not have the sticky date issue.

5) Created indexes.

The issue was resolved of all users.

Cheers!
Sanjay

 

FRX – Cannot find GL Index database – [path].G32

Frx index not found

Frx index not found

Though FRX is retired, it is still used in production. There are situations where index files (*.G32 at sysdata folder) needs to be deleted, for example the date is not setting properly when running the report. Once the index files are deleted, it needs to be re-created.

Indexes for the company can be created by making the logged in company the default company @ Company -> Information -> Set as default.

However the indexes for the forecaster company is not created when the logged in company is set at default. In order to create the indexes for the forecaster company, first identify the forecaster company from the Company -> Information screen of the logged in company. Next select the forecaster company and make it default. Indexes for the forecaster company is created.

Select the company to be logged in make it the default company to revert back to the reporting company.

At this point indexes for the company and the forecaster company is generated and all set for reporting.

PS: Always backup the sysdata folder before any operation deletion or rebuild operation in FRX.

Cheers!
Sanjay

Dynamics GP – Company Remit To Address on Sales Invoices

The requirement here is to get the second REMITTO  address defined at company set added to sales invoice report.

Lets start by creating the second address for the company at
Tools >> Setup >> Company >> Company >> Address

Address 2

Set the default address to primary
Company Address 1

Next lets modify the invoice report.  Open any invoice, and click on the printer icon at top right corner of the sales transaction inquiry window.sales invoice

Tick mark invoice and select blank paper and click print
print invoice

At the report destination window, select standard for report type and screen for
destination:

Report Destination

Generate the report by clicking ok and modify the report by clicking on the modify button
modify report

Now we are all set to add the second address to the report.  Select calculated fields at fields drop down and click new.
calcualted fields

Let’s create the first field remit to contact name.  Enter the field definition as follows:
calcualted field defination 1

Click on add
calculated field 2

Click on constants and fill the type as string and constant as REMITTO,  the address ID of the company address whose contact name will be placed on the report.
calculated field 3

Click on add
calculated field 4

Change the type to integer and constant to 1 ( 1=Contact Name)
calculated filed 5 Click on add
calculated filed 7

Complete the process of creating the calculated field by clicking on “OK” .  The filed now  appears at the calculated filed drop down list.
calculated field 8

Follow the same process to create other calculated fields for REMITTO company address. The second parameter value pair is as follows:

2 = Address 1
3 = Address 2
4 = Address 3
5 = City
6 = State
7 = Zip
8 = Country
9 = Phone 1
10 = Phone 2
11 = Phone 3
12 = Fax
13 = Country Code
14 = County
15 = Address Name
16 = Address ID

I am not going create all the fields in this post.  Once created, drag the calculated filed and drop into the invoice layout.
calculated filed 10

Close the layout, save all the changes and return to Dynamics GP.

Provide access to modified report to the user at Tools >> Setup >> System >> Alternate Forms and Modified report.
modifed report access

Save security updates.

Generate the invoice report  to check if the REMITTO contact name appears on the sales invoice report …..  It does!
remit to address on invoice 2

Cheers!
Sanjay

Dynamics GP – Payable Inter company Invoice entry example.

In this example an inter company payable transaction is demonstrated.  For this purpose two test companies are used:

Company Id Description
TWO Fabricam
THREE Tree (copy of TWO)

Inter company setup (created at TWO):
Tools >> Setup >> System >> Inter Company
internet

The inter company transaction:
Company TWO records an invoice related to company THREE in its books of accounts and issues payment to the vendor on behalf of company THREE.  Company TWO will record an inter company invoice as follows:

Transaction >> Purchasing >> Transaction Entry:

intercoinvoice

Create the distribution as follows:

icodist

Note for line one of distribution the account number is picked from company THREE.  For Line two the account number is picked from company TWO.  Click OK.

GP will prompt  an alert

icoalert

Click Yes.  Update the corresponding company ID for the second linecorrespondingico

and post the invoice.  The resulting AP  posting journal is as follows:

icojournal

GP has passed the required inter company entries at AP – Good.

Check the Journal entry at TWO:

TWOJOURNAL

Check the GL journal entry passed by GP at THREE

THREEJOURNAL

Looks good!

Cheers!

Sanjay

 

Which AD Group my user account belongs to ?

This week end the plan was to  dissect Dynamics GP 2013  web client install.   While going through the documentation one of the requirement was the need to have Active Directory user group names for web client administrators and users.  As it was the week end did want to spoil the well earned week end of our IT folks, then the question was can we query the active directory and get couple of group names which I belonged to when you don’t have access to the active directory users and computer MMC.  Figured it out and it can be done, and just to keep a record of my finding I thought would write a blog post

Steps to identify active directory group membership for a given user:

1) Click on windows start button and type command.start button

2) Mouse over to command prompt at search resultscommand

3) Right click command prompt and run as administrator.

4) At the command prompt  type the following command:

net user <domain user name> /domain

and press enter. This should list full details of the user account which includes a complete list of users group membership.

Capture
Cheers!
Sanjay

 

 

 

 

 

 

 

Dynamics GP Report Writer Global Functions Quick Reference – Part 4 – Data retreival

Dynamics GP Report Writer Global Data Retreival Functions

FunctionParam TypeParamReturn TypeReturn
RW_CityStateZipstring
string
string
inCity
inState
inZipCode
stringoutCityStateZip
RW_CoAddrIDInfoAddress Code
integer
IN_Address_Code
IN_Field
stringOUT_String
RW_GetCommentTextstring
integer
integer
IN_CommentID
IN_characters
IN_line
stringOUT_string
RW_GetInternetInfostring
string
string
string
IN_MasterType
IN_MasterID
IN_AddressID
IN_field
stringOUT_string
RW_GetInternetPromptintegerIN_fieldstringOUT_string
RW_GetInternetTextstring
string
string
integer
integer
IN_MasterType
IN_MasterID
IN_AddressID
IN_characters
IN_line
stringOUT_string
RW_GetMsgintegerimsgstringsmsg
RW_GetMsgDisplay
RW_GetNoteTextcurrency
integer
integer
IN_NoteIndexstringOUT_string
RW_GetPOPTypeStringPOP TypenPOPTypestringsPOPType
RW_GetPOTypeStringPO TypenPOTypestringsPOType
RW_GetSOPTypeStringintegernSOPTypestringrw_GetSOPTypeString
RW_GetWFApprovalStatusStrin 'Workflow Approval Status'nWrkflwApprvlStatusstringrw_GetWFApprovalStatusStr
RW_GetWFPriorityStr'Workflow Priority'nWrkflwPrioritystringrw_GetWFPriorityStr
RW_PMAddrIDInfoVendor ID
Address Code
integer
IN_Vendor_ID
IN_Address_Code
IN_Field
stringOUT_String
RW_POPHDRCommentTextstring
integer
integer
IN_Number
IN_characters
IN_line
stringOUT_String
RW_POPLINECommentTextinteger
string
long
integer
integer
IN_Type
IN_Number
IN_Ord
IN_characters
IN_line
stringOUT_String
RW_RMAddrIDInfoCustomer Number
Address Code
integer
IN_Customer_Number
IN_Address_Code
IN_Field
stringOUT_String
RW_SOPHDRCommentTextinteger
string
integer
integer
IN_Type
IN_Number
IN_characters
IN_line
stringOUT_String
RW_SOPLINECommentTextinteger
string
long
long
integer
integer
IN_Type
IN_Number
IN_LineItem
IN_Component
IN_charactes
IN_line
stringOUT_String
Dynamics GP Report Writer Global Data Retreival Functions

Cheers!
Sanjay