We would like Great Plains to have the ability to have different costs
(standard and current) for items at each location where the item exists.
We currently have several warehouses in different countries and parts of the
world. The cost of our items vary greatly at each warehouse, due to
transportation costs, dutys, etc.
Currently Great Plains only stores the cost at the item level. It is
impossible to have an accurate picture of our sales margin on items with only
one cost per item.
We have tried to go around this by creating multiple item numbers, each with
different costs. But t...Charging 1 or 2 Taxes on items automatically
I have 4 columns, A1-item, B1-tax, C1-tax, D1- Total. Some items are taxable
on both, others only on 1, is there a way to automatically charge 1 or 2
taxes on the total.
It is easy:
set the values in columns B and C as percents. Then D would have something
With this set-up you can remove a column B or C tax just by setting the
value to zero.
> I have 4 columns, A1-item, B1-tax, C1-tax, D1- Total. Some items are taxable
> on both, others only on 1, is there a way to automatically charge 1 or 2
&...Inventory Transactions using Integration Manager
I am trying to import inventory transactions (adjustmnet) using the IM, the
key thing is I want all lines in a single transaction.
I memic the sample in IM. but its not working imports all linesbut I am
getting this error: Object 'Adjustment 1' already exists -- cannot Insert.
I think the problem is related to te documnet number, I am using a cloumn
that conatains the same number for all rows (in order to import all the lines
in a single trx)
Am I missing anything? any hint?
Look at the "group by" function in the IM manual.
An import will consist of hea...Serial number already entered for selected item
On a SOP Return I'm getting the message "This serial number has already been
entered for the selected item" when trying to specify a serial number. I've
checked serial number inquiry and this particular serial number is not
listed. I found a KB article that described the problem but didn't have a
This serial number has been sold, returned, sold again and is now being
returned again. The first 3 transactions areposted and all are listed in
SOP10201. I've also checked in IV00200 and it's not listed there. Any idea
where else this serial number co...Oops! Deleted the wrong item
We were adding items on multiple stations and one got duplicated that was
already on file. I deleted the duplicate but it turns out I deleted the wrong
item. The one I removed was on four layaways. Now I can't recall the layaways
(error 204) to fix them. I tried adding back the item with the original
lookup code, but that didn't help.
How can I fix those four layaways or remove them so they can be re-entered?
when you deleted your item, a record was inserted into the RecordDeletedLog
table in the database, if you look there it will tell you what the ID number
w...Viewing Digitally Signed Sent Items
Upgraded to Outlook 2007 recently, stacks of issue's, dealing with them one
at a time..
Here's the next in the list :-
I use a Verisign Digital certificate, and have finally overcome the problem
where it asks for permission to use the key each time I send a mail (Export
the key and delete it, then double clikc on the exported key file and folloz
your nose seems to get round that one) but still have a problem when I try
an view messages in the Sent Items folder.
Each message I try and view produces a dialog box that complains I've
changed the message contents and I need...How do I reference non-contiguous columns in another sheet and th.
I have a worksheet that contains several years of montlhy data on cost
increases and decreases. I have another sheet w/ one column that summarizes
the first quarter's data. How do I fill across on the second sheet so that
the cells contain the correct data from the monthly sheet and the correct
forlmulas from the first column on the quarterly sheet? This means the second
sheet has to reference non-contiguous columns on the first sheet.
I understand the difficulty: since elements on the first sheet are not
contiguous, creating out...Closed Account and Savings and spending budget
I have recently closed a couple of bank accounts that I no longer use. In
Money 2007 I set both the accounts to closed. When I went to my budget the
accounts no longer show up and none of the transactions show up. This screws
up my monthly budgets prior to when I closed the accounts and it screws up
the annual budget as well. How can I mark the accounts closed but still have
them show up in budget.
Also I would like to stop the online updates for these accounts. I read an
earlier post that says to stop online updates for the bank in question and
then set up online updates again and onl...Backordered Item Received Report from Transfer
Is there a report similar to the POP Backordered Items Received Report that
one can run after transferring inventory into a warehouse location? We
would like to use assembly transactions, but not sure how to get this
visibility if we don't receive into the warehouse location.
There is no canned report that will give you this information. This would
be a report you would have to create.
This posting is provided "AS IS" with no warranties and confers no rights.
> Is there a report sim...Item Price Lists
I am looking for a little help trying to work out the item price lists
to show in a custom SmartList.
My set up
GP10 with latest patch
Items are set up to use a percentage of list price and I have had to
use the rounding screens to get the prices to match what we charge our
In the Item Price List card I see the correct price, along with the %
When trying to build the Smartlist, I have a calculated field that
takes the List price from IV00105 and the discount from the UOMPrice
field in IV00108, but I cannot work out how to apply the rounding
method from IV00107.
An...kit item return
There should be an option in the Store Op Manager --> Configuration -->
Option Tab to allow the ability when returning a Kit Item to either return
the quantity back to the Kit Items Inventory or to the Kit Item COMPONENTS
Effectively breaking out the Kit Item automatically when the item is
returned to inventory.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to op...windows live mail error: cannot send mail as account inactivated!
Am unable to send mail as account deactivated. I have only just opened
account and was sending all contacts my new address. Help! How do I
email address: email@example.com
No one in this forum(this is a public newsgroup, not Microsoft/Live Support). Persons in this newsgroup are your peers. No one
works for Microsoft.
First and foremost...do not post your email address in a public newsgroup where it can be harvested by spammer and their address
For Windows Live support these are your options.
Support for Windows Live Essential applications and...GP Alert Formula
I need to create a business alert that contains only certain inventory items.
Is there a way to include items based on item number? For example, I need
to create a report that includes all inventory items that begin with "A" or
...Business Unit Admins Can't view Account sharing information
We have multiple regions in our company set up as Business Units. Each
Business Unit has a user with an admin role that has just about unlimited
rights within their respective BU. These admins can share accounts just
fine but can't see the existing sharing information (i.e. what users an
account is already shared with). I, as the company system administrator, can
see all the sharing information without a problem.
I can send screen shots as necessary
...Can I tack a note onto a to do list item or an email?
Can I tack a note onto a to do list item or an email?
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"guitar man" <guitar firstname.lastname@example.org> wrote in message
> Can I tack a note onto a to do list item or an email?
...The item cannot be displayed in the preview pane
I have recently migrated users from outlook IO to Exchange. The are a slew
of messages that I cannot preview or open. When I click on the mail message
I get "The Item cannot be displayed inthe preview pane. Open the item to
read its contents". When I try to open the message "Cannot open this Item.
The operation failed". If I change the outlook client back to IO and import
the PST, I can read the message again. Help.
...Cannot delete mailbox/email account from Outlook 2003
Hello All -
I'm a systems admin at a company that use exchange server. Someone
added a mailbox to an e-mail account, and it appears as a second
mailbox in the folder list. The only problem is, I can't delete it. If
I right click the mail account, select "close mailbox...", I receive
the error that the mailbox is associated with an account, and to remove
it I need to go to Tools, E-mail accounts, view or change, blah blah
If I go to that route, I can delete the Microsoft Exchange Server
account that exists. However, in the "Deliver new e-mail to the
following loca...Scientific plotting, non-zero x-axis origin, and number labeling
I want to plot some spectroscopy data. The range of x-data (wavelength) is
from 270 to 1100 nm. However, I would like the x-axis lablels to read only
300, 400, etc., rather than 270, 370, 470... Is there any way in Excel 2003
or later to change the position on the axis where number labeling begins? I
know this is possible in other plotting programs, but would prefer Excel for
student use. Thanks for any help one way or the other.
"Viterbo Mike" <Viterbo Mike@discussions.microsoft.com> wrote in message
>I wa...Item activity
I have a lot ot items in my database that I don't carry
any longer. Is there any way to identify them and either
delete or make them inactive? Any help is appreciated.
In the Item Properties there is an Inactive option.
In addition to Jason's suggestion, you can make a group of items inactive
through the Inventory Wizard.
"JD" <email@example.com> wrote in message
> I have a lot ot items in my database that I don't carry
> any longer. Is there any way to i...Default accounts are not displayed
My client is using a dynamics version 7. When they are using their cash
receipts, the default account defined in the checkbook ID is not used as the
default debit account. Instead, it always displays account not found. But
when I checked the setup of the checkbook ID, the account is defined. And the
account is existing in the account maintenance. Can someone help me on this
Hope to have a reply...
Look at the customer card->accounts to see where the cash account is pulled
from. It might be pulling from the customer card rather than the checkbook.
Visit us at ...Using VBA to select Items in multiselect Listbox
How can you programatically select items in a multiselect list box based on
their lables? Certain groups of items in my multiselect listbox will be
frequently selected together. I want to have check boxes elsewhere on the
form that a user can click that will cause a group of items to be selected in
the list box. The list box itself is used to make an sql statement. Thanks.
"bymarce" <firstname.lastname@example.org> wrote in message
> How can you programatically select items in a mult...Extender Windows on Inventory Transfer Scroll
We have a request to enter the item's Pallete Number and Carton number
during the item transfer entry. I was thinking of using Extender to
add in those fields and activate them during Item Transfer Entry when
each detail item line is entered.
I created a WINDOW in Extender under Form Item Transfer Entry, Window
= IV_Tranfer Scroll.
I faced 2 problems:
(a) Under IV_Transfer Scroll, I only find Item Line Sequence but not
Document Number. As such I could not create a right Key Fields for the
(b) I wanted the system to auto open the window after Field Exit from
Qua...Recipients of Non-delivery Reports (NDRs)
We are running an exchange 2003 server in our company LAN.
For some reason I keep getting all the NDRs sent by the exchange server in
our network. I am not able to find where to set who will receive these
notifications when email delivery fails.
In Exchange System Manager, bring up the properties of your SMTP virtual
server. On the Messages tab, look in the field called 'send copy of
non-delivery report to' - that will probably contain your SMTP address.
"Mourad" <Mourad@discussions.microsoft.com> wrote in message
news:F756...deleting items via supplier ID
what quary would I need to delete all items attached to a specific supplier.
ie delete all items suppied by the xyz company
Do you want to actually delete the items or do you want to just delete the
association to that Supplier?
To get X do this first:
SELECT ID FROM Supplier WHERE SupplierName = 'XYZ Company'
This will delete the Items from your database:
DELETE FROM Item WHERE Supplier.ID = 'X'
If you want to keep the items in the database but want to delete any
associations between items and a specific supplier do this:
DELETE FROM SupplierList WHERE Suppl...Account locked out after 1 try
Hi! I do not know what's happening, but my password policy
is by 3 tries. When I try to access my mail via Outlook my
account get locked out after the first bad password entry.
If I try to access via OWA there's no issue. Please help