Totally Agree with
@Bruce Strom,
you're chasing the wrong car here :-).. This is budgeting data which anyways calls usually for rounded numbers to the dollar, if not even to the 10 or 100 dollars per line item.. Importing a budget isn't by any means to serve as a purpose of an "exact" control of your actually, since those numbers can be influenced by many external factors, like exchange rates and rounding issues with your inventory items.
The budget function in GP has a purpose to limit the spend amounts per account in the POP process (using POE) or in requisitions workflow, and to track in your Financial Reports (in MR 2012 for example) where you're sit with your Actuals vs. Budget throughout the year. On top of that, budget usually gets adjusted quarterly with a fresh upload and may (or may not) override your initial budget for the year, depending on how you manage it. We used to have year-start budgets and then an outlook revision at each quarter end (budgets would be named accordingly like Budget-2019, Budget-2019-OL1, Budget-2019-OL2, etc..)
------------------------------
Beat Bucher
Business Analyst, Dynamics GP SME
Montreal QC/Canada
@GP_Beat
http://www.gp-geek.comMontreal QC GPUG Chapter Leader
MBS MVP (2015-2018)
------------------------------
Original Message:
Sent: 02-23-2019 12:13 PM
From: Bruce Strom
Subject: Budget Import
Why are you loading seven cents into a budget anyway? Since budgets are estimates anyway, you should always round budget amounts to the nearest dollar.
------------------------------
Bruce Strom
Programmer Analyst
Associated Grocers of Florida / Supervalu
Sunrise FL
Original Message:
Sent: 02-21-2019 07:56 PM
From: Sue Imose
Subject: Budget Import
FYI. Our GP partner recreated the issue in both GP2015 R2 and GP2018 and will be reporting it to Microsoft.
------------------------------
Sue Imose
The Gas Company, LLC
Honolulu HI
Original Message:
Sent: 02-21-2019 04:47 PM
From: Sue Imose
Subject: Budget Import
It's just .07 amounts Amounts that end with .07 load fine.
I think we will end up updating the budget amounts directly once we find them all.
Thanks.
------------------------------
Sue Imose
The Gas Company, LLC
Honolulu HI
Original Message:
Sent: 02-21-2019 02:13 PM
From: Audrey Forrest
Subject: Budget Import
We use budget import on this version and I have not had any problems. Are you budgeting for the amount $0.07? Or just amounts that end in ##.07? I looked through our previous budget amounts and we have imported amounts that end in .07 ok. If the issue is limited, you could upload the budget in excel, and then edit the amount on the Account card>Budget? I have had to do that once or twice on last minute changes before launching.
------------------------------
Audrey Forrest
Senior Accountant and Business Analyst
GP 2015 R2, D365 CRM V9
CRMUG Chapter Leader - Seattle
Original Message:
Sent: 02-20-2019 08:25 PM
From: Sue Imose
Subject: Budget Import
We are currently on GP2015 R2. When importing a budget it seems that one specific amount .07 is being loaded as 7.00 and we can't figure out why. Other small amounts for the same account e.g. .08, .09 load fine. Has anyone else experienced this?
------------------------------
Sue Imose
The Gas Company, LLC
Honolulu HI
------------------------------