Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / one account multiple b...
Microsoft Dynamics GP (Archived)

one account multiple budget

(0) ShareShare
ReportReport
Posted on by Sheila Marie Diaz 105

We have a particular account (EMI-GAD-XXXXXX-FOHI-RMMOD) which is used as PESO in currency.  All the items in Inventory and budget were set up as PESO under this account.  However, we wolud like to add another currency which is US DOLLAR.  How can we apply this to our company?  How can we upload a budget in PESO and US Dollar in one Account Number?  Or do you have any suggestion to make this senario possible?

The set up will be:

 EMI-GAD-XXXXXX-FOHI-RMMOD - Item# 23987 with currency PESO

 EMI-GAD-XXXXXX-FOHI-RMMOD - Item# 23988 with currency US DOLLAR

Thank you.

Sheila Marie Diaz

 

 

*This post is locked for comments

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: one account multiple budget

    Hi Sheila,

    So you may need forecaster, how much to buy in $ for a specific item for future months. Is this correct? You will have to elaborate your requirement. Do you need amounts? Quantities? etc. Your original enquiry is dollar budget, I assume you are doing it in peso at the moment. How are you doing it in Peso at the moment?

  • Sheila Marie Diaz Profile Picture
    Sheila Marie Diaz 105 on at
    Re: one account multiple budget

    Hi,

    No, we need the dollar budget for our monthly order of items.

    Thanks.

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: one account multiple budget

    Hi Sheila,

    So then if so, you can create another budget ID perhaps call it a Dollar budget. In GP you can create unlimited Budget ID.

    Up front dollar budget is not available as it is assumed that budgets are expressed similar to your functional currency. But on the other hand it can not stop you from importing dollar amounts budget per GL account code.

    Where do you need to see your dollar budget, do you need it in Frx?

  • Sheila Marie Diaz Profile Picture
    Sheila Marie Diaz 105 on at
    Re: one account multiple budget

    Hi Frank,

    Thanks for clarification.

    Sheila

  • Sheila Marie Diaz Profile Picture
    Sheila Marie Diaz 105 on at
    Re: one account multiple budget

    Hi,

    yes we are using a code which is called Account in GP.

    Sheila

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: one account multiple budget

    Sheila, you won't see your Functional Currency (PESOS in this case) in the currencies available in the Select Account Currencies window because your account transactions are automatically reflected in PESOS because it's your Functional Currency.  You only select the other currencies you want to display in here.

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: one account multiple budget

    Sheila,

    The GL budget is the same as what you get from Cards>financial...

    There is no inventory item budgeting in GP, unless you are creating 1 GL code per item in your inventory. Are you?

  • Sheila Marie Diaz Profile Picture
    Sheila Marie Diaz 105 on at
    Re: one account multiple budget

    Hi,

    Sorry for the confusion, but what is GL budget.  We didn't use this term.  Maybe what I'm saying is Inventory item budget in US$ and PESO.

    Thanks,

    Sheila

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: one account multiple budget

    Hi,

    Same as Ian, please clarify if you need a GL budget or an inventory item budget in US$.

  • Sheila Marie Diaz Profile Picture
    Sheila Marie Diaz 105 on at
    Re: one account multiple budget

    Hi Ian,  

    Yes, we are registered as multicurrency (our default is "PESO") but in Account Maintenance I can't see "PESO" only YEN and Dollar is available.

    Yes, Item# 23987 is in Inventory items.

    About the budget, we want to have a Dollar and Peso budget in same account (EMI-GAD-XXXXXX-FOHI-RMMOD).  We upload the budget in GP>>FINANCIAL>>CARDS>>BUDGETS>>EXCEL>>IMPORT FROM EXCEL  one template for DOLLAR AND one template for PESO but we didn't have one account with two currency.  

    Thanks,

    Sheila    

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans