Inventory sheet to track, order & reduce quantity from master.
I want to build a workbook to track and order inventory.
On one sheet (Master sheet) I have the entire inventory listed
-columns included the lot number, product code, item number,
description,expiration, and quantity available. I want to compare
it to a column that has the quantity on hand in the Master sheet -
and subtract the number from the Master sheet to track inventory.
If a quantity needs to be ordered, I would type the product number
and the inventory sheet would lift the description, lot numbers
available for distribution, expiration dates, and quantities
available from th...How to track inventory..of a non-inventory item...
I know it sounds like a codundrum, and I suppose it is...
I would like to track sales of a particular supplier, in this case,
my supplier is a Tattoo Artist (we run a Tattoo Studio in a mall).
I don't want to track sales as a cashier, becasue I want to eliminate any
error of not having a cashier sign ino or the sale going to the wrong person.
So, currently I have a supplier set up for each artist. Once they are done,
I use a barcode from a printout, that then tracks their sale.
The problem is, I then have to have the tattoo entered as inventory. It's a
workaround, but when doing the...High Standard Cost Revaluation Amount
In GP Manufacturing 10.0, what are some things that typically cause the
Standard Cost Revaluation account to be so large in one month and not so
large in the other months?
First of all, running it each month is not normal. Most SC firms revalue
one, two, or four times a year. However.....
Look for manufacturing costs variances by using the Order Variance window
under Inquiry->Manufacturin->MOs->Order Variance. Look for material
variances here as the rollup will pull actual material costs at the proposed
rate of consumption but only proposed labor an...Real Time inventory transaction posting from visual studio sdk
I'm trying to enter an inventory transaction (update/transfer) from
developer toolkit (visual studio sdk, not eConnect).
I don't manage to do that or to find the relevant procedures which enable me
to post a transaction.
Does any body have any idea regarding that or its only possible to do that
through dexterity and eConnect?
I'm trying to decrease depandancy from Dexterity and work either through the
code in c# or issuing transaction directly to DB to the relevat tables
according the sdk instructions.
my clients can not afford eConnect or integration manager as well they a...Multicurrency Revaluation
I have a cash account and an expense account that both have Canadian Dollars
and Australian Dollars as their originating currency. The functional currency
is US Dollars. (I am using the Fabrikam Company for testing purposes)
I posted a credit to the cash account and a debit to the expense account in
each of the currencies.
I want to revalue the amounts and post to an unrealized gain and loss
account for each of the currencies. The exchange rates have changed.
When I use revalue, it creates a multicurrency revalue batch and when I try
to post it I get the following error and it will not...Is there a way to deduct inventory that are not part of kit?
Hi, I have a question on inventory and hoping someone might be able to help
or point me to the right direction.
We have a lot of inventory set up in GP as "sales inventory" item type. For
every SKU #100 we sell, we need to add in 1 lock (SKU #L). For every SKU
#101 we sell, we need to add in 2 locks (SKU #L). We also sell SKU# 100, SKU
#101 and SKU #L individually. If I set up SKU #100 as a kit, it won't let me
enter itself as a component. I don't want to set up a new SKU and then add
#100 and #L as components.
Is SKU #100 curre...Problem With Physical Inventories
We are currently having a problem with commiting phyical inventories. We keep
getting this error message.
"Invalid count date. In order to continue, itmes must not have count dates
that are earlier than the physical inventory open time"
I am guessing that it is a timestamp problem. We have checked the calendars
and clocks on all the machines and they are all correct. When we goto
calclate the inventories we get this message. We have gotten this message at
various times but the weird thing is that some counts we enter are a couple
of days after the counts are created.
Does...Inventory Batch re-create after checklink
I saw a orphaned batch in Inventory, therefore I deleted it and I checked the
SY00500 table to make sure it is gone.
However; I ran the CheckLink, it is recreated itself, why? I tried a couple
times, and check the SY00500 table too. Whenever I ran the checklink, the
inventory batch created itself.
After checklink, the report said...
Batch number XXXX has been added.
Apparently there is an unposted transaction sitting out there. When
you run checklinks, it is re-creating a batch associated with the
transaction(s). Run a Smartlist on inventory transactions and filter
...revalue parts that have zero standard cost only
You should be able to revalue items that have zero standard cost without
revaluing all parts. New items are being added to our system daily which need
a cost associated with them and we can not wait till we revalue every part to
get a cost on them.
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 open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agre...Financial Series Revaluation
What is the difference on financial series revaluation between the
a. Realized Gain/loss
b. Unrealized Gain/loss with revesing entry unmarked.
With the financial series reval, the only difference is which set of
accounts gets used to post the revaluation transactions and, in the latter
case, if a reversing entry in the next period is made.
"Jack Tundra" <firstname.lastname@example.org> wrote in message
> What is the difference on financial series revaluation between the
> a. Realized G...Revaluation Error
This is a multi-part message in MIME format.
Good day. I would like to ask whether anyone has encountered an error =
saying "This year does not exist" when performing Multicurrency =
Basically we have already checked the Fiscal Period Setup as well as =
verified the Audit Trail Code Setup and everything seems to be okay. Is =
there any other thing we may need to check?
Thanks in advance!
------=_NextPart_000...Inventory Allocation Accounts
I am using a system that was set up before I got here and the installers are
not available. The Inventory Offset is set to the same GL account as
Variances and Assembly Variance (inventory account). Purchase Price
Variance is a different inventory account. Plain "Variance" is an expense
account. The Applied Overhead account is an expense account and I do not see
where it is relieved...Year end JE? I work in GP alot, but only in
inventory/manufacturing on a surface level. Is there info out there for
details on set up and function? I have gone thru the regular s...Need to create inventory, customer in excel
Trying to get several files such as inventory, customer, vendor, etc. over to
a MS Excel file. I need all data fields offered brought over.
There are 2 ways,
1. Open report giving you desired info. select coulmns (Show hide columns)
you want, there is an option at the top to export it to any desired format.
2. Go to administrator, use SQL query to give you all required fields. Go to
File > Export to export it to CSV format.
> Trying to get several files such as inventory, customer, vendor, etc. over to
> a MS Excel file. I ne...Inventory: Average Lead Time vs Planning Lead Time
In "Cards > Inventory > Vendors" (ie. Item Vendors Maintenance) there is a
field called "Average lead Time". I see that this is a calculated field and
that makes sense. The Help for this field says:
Average Lead Time - Enter the average number of days that pass between the
time you place an order with this vendor and the time you receive the order.
There is another field here called "Planning Lead Time". It's Help says:
Planning Lead Time - Enter the number of days you use in planning between
the time you place an order with this vendor and th...Revaluation.
I have problem with reverse transaction revaluation. All the times, return
empty report. I run a revaluation to 13/02/06 and 14/02/06, when I try to
reverse this revaluation I have no result on the report. The main problem is
that if I revaluate againg, the report acumulate all values for each document.
I appreciate any help...
...Inventory Transfer #5
I am using RMS1.3 I need to know, How HQ know Inventory transfer between
Mr. Ibrahim Zubair
? ?? ??
HQ ? during a data request upload...all stores data will be updated in
HQ.Now if you want the status of each Inventory Transfer, there is a report
that will tell you InventoryTransfer status-->In HQ
Manager-->View-->Inventory Transfer Status...
I hope it help.. :)
"Ibrahim Zubair" wrote:
> I am using RMS1.3 I need to know, How HQ know Inventory transfer between
> Mr. Ibrahim Zubair
...Bank Management Revaluation
We would like to request a separate revaluation process for Bank Management.
This is becasue when you use the Revaluation process in GP a Bank GL account
can potentially have 3 different currencies in it. For example, if the
functional currency is NZD, if you transfer from a USD dollar cheque book to
a AUD cheque book. In the AUD Bank GL account originating DR/CR is in USD.
All other payments from this cheque book are in AUD. When you use the
revaluation process in GP (and posting the revalue amount to the Bank Acount
NOT a financial offset account) the results are incorrect - that is t...Negative allocations in Inventory
Client is experiencing negative allocatons in inventory whenever they delete
an order. I know they can run the RECONCILE procedure to fix the problem,
even though it will take time to run through every item in inventory. WHAT
WOULD CAUSE THE SYSTEM TO CREATE NEGATIVE ALLOCATIONS?
We have had similar problems using Feed Mill Manager with Great Plains. Not
sure what the cause is, but the reconcile is the only thing so far that
corrects the issue. BTW, how many items are in your item master table?
Also how many sites? We have over 600,000 item/site combonations, and it
takes about 7 ...POP Transaction Revaluation
Is it possible to do multicurrency revaluation on tractions originating
from POP and SOP same like tractions originated from Purchasing
Transaction Entry and Sales Transaction Entry in receivable and payable.
...Inventory Purchase Receipts
There is a Smartlist called Inventory Purchase Receipts which, I think,
shows you your FIFO stack. Unfortunately, there is not date associated with
the qty sold column. Does anyone know how I can get dates for the qty sold
column in there? I have Smart List Builder so if someone could tell me where
to find it, I could probably put it together. Thanks!
You should be able to get that from IV30101 and/or IV30102.
> There is a Smartlist called Inventory Purchase Receipts which, I think,
> shows you your FIFO stack. Unfortunately, there is ...Item backorders on Inventory Transfer to Site
Is there any way to leave a qty on "backorder" on an Inventory Transfer ?
For example, we want to transfer 10 of item ABC to another site. The main
site only has 4 right now. How do we have the system track that the other
site still requires an additional 6 units of that item, and when the main
site receives more of item ABC, it should flag that the other site still
We will be using the order points to give us suggested levels, but there are
times when we require more, and want the system to track that ?
...use of non inventory item for discounting
I have used non-inventory items for discounting purposes, but am not sure if
i am doing it properly! I usually have all the items in one department
called offers - but then i accumulate a big negative amount for that
department, and am over-stating my sales for the other departments.
I got around that by putting the item in the department that the discount
related to, but that only works for item specific discounts...
if i have a coupon worth -�10 and people can spend that on anything they
want, then how would people usually deal with that?
any feedback on this would be great! Ta!
Hello, I am preparing an inventory worksheet with +300 items and I am
recording opening balance, issues, receipts, adjustments and balance. I have
eough worksheet space for each item (I call it a separate card) to allow
multiple entires with a running balance occurring by formula.
I need the bottom of the item column (last line) to read the balance as the
lines above are adjusted for an inventory transaction, and this last line
will automatically adjust as entries are made.
If necessary, I can send a page of the worksheet to anyone that responds
with help or suggestions.
Ph...To rerun a revaluation or not.
I forgot to change the "Post Results To" option to "Account" from "Financial
So when the revaluation ran, the financial offset account was updated, when
I wanted the adjustment to be done to the account.
Do I run the revaluation again? Or do I make a journal entry to correct?
Don't run the revaluation again...just post a correcting je
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"Rich" wrot...POS 2.0 upgrade from 1.0
We took pictures of 100's of inventory items and could see the pictures when
we looked at the inventory items in POS 1.0. After upgrading to POS 2.0,
pictures are still there in file manager in the proper "directory", but they
are NOT linked to the inventory items.
We did create the pictures with names that match the item numbers, so a
carefully constructed SQL update might do the trick, but I wonder whether
this is a bug?
Can I get a sample SQL from anyone? (and instructions?) I have a lot of
experience with SQL on mainframes, UNIX and Linux, but none on SQL server.