Purchasing Fixed Assets through Purchase order processing

Purchasing Fixed Assets through Purchase order processing

Use purchase order processing to purchase fixed assets

To enter a standard purchase order:

1.    In the navigation pane, choose the Purchasing button, and then choose the Purchase Order Transactions list.

2.    In the New group or its overflow menu, choose Standard Purchase Order to open the Purchase Order Entry window.

3.    Enter a purchase order number or accept the default entry.

4.    Enter or select a buyer ID.

5.    Accept the default date or enter a date that will be used to update your purchasing records.

6.    In multicurrency transactions, the exchange rate used is based on the document date, the currency ID, and associated rate type that’s entered for the transaction.

7.    Choose the Date expansion button to open the Purchasing Date Entry window, where you can enter a contract expiration date for the purchase order. Choose OK to return to the Purchase Order Entry window.

8.    Enter or select the vendor that you’re ordering the item from.

9.    Enter or select a currency ID, or change the default currency ID.

10.    If the currency ID is not the company’s functional currency, a rate type and associated exchange rate table is assigned to the transaction.

11.    Enter or select the number of the item you’re purchasing.

1. Enter the item quantity.
2. If you’ve entered a non-inventoried item, enter the unit cost. If you’ve entered an inventoried item, you can modify the default unit cost.
3. Enter a site ID, or accept the default site.

Sites are required for line items. You must enter a site ID before continuing to the next line. To mark the item as a capital item select the arrow highlighted to the right of the line item column labeled “item.” This will open the Receiving Item Detail Entry window.

    6. Mark the capital Item checkbox

7. Continue to enter all the line items for the purchase order.

8. Continue entering all the Purchase order data

9. Save the purchase order or Transfer to be received or receive and invoice.

If you’re buying multiple assets and need each one with a different serial number in the Fixed assets module 

select the arrow highlighted to the right of the line item column labeled “item.” This will open the Receiving Item Detail Entry window.

.    Click on the blue arrow of the capital item as shown below

.    mark on create Multiple fixed assets 

Note: you can define all the asset info from the below part "additional fixed assets information" and if you are using Dynamics GP 2013 R2 and later you can also add the class ID next serial number to the asset.

After posting the purchase order go to the fixed assets

Use the fixed assets general card to add new purchased assets to the fixed assets module

Financial >> Cards >> Fixed Assets >> General

A new drop down list will appear after purchasing a capital item called purchases as shown below

. From the drop down list in the purchases select the asset that you want to place in the fixed assets module

Note: if a mistake is done while choosing the item from the drop down list click on Clear to clear all entered data and return the chosen asset to the drop down list again

 . Fill all data of the asset and save

Regards,

Creating Macro in Dynamics GP

Creating Macro in Microsoft Dynamics GP

1. Open which screen you would to insert data and don’t insert any char [Example: HR-

--> Position]

2. Start Recording the Macro

3. Name your Macro

4. Start insertion of the data

5- Stop Macro Recording

2- Fill the Macro file with all required data for upload.

a- Open Macro created file with Microsoft Word

b- From Mailing Tab --- Select Recipients --> Use Existing List

c-Select Data Source [Pre- prepared File .XLS contains all required Data for each record]

d- if the excel sheet contains multiple sheets, select which tab contains the data

e- the Macro file code will be like below:

f- Highlight each screen filed and map it with data file sheet column form

g- Make the previous step for each filed of the screen.

h- At the End choose merge all form

Note: - the main Macro file pages will increased by number of XLs file data records.

i- Finally save that file as .TXT file the replace file extinction from .txt ---> .mac

3- Play the prepared Macro file to insert all data required.

a- Open Dynamics GP and close all windows

b- Open which screen you would to insert data and don’t insert any char [Example: HR-

--> Position]

d- Start Playing the Macro

The Macro will run with all the data inserted in the excel sheet till it finishes 

Kindly Regards,