Hi James,
Yes that is my exact question. "So it will go through 40,000 items even
though only 1,000 will be shown in
the results of the master plan." For howing the results, master plan is
scanning for all item codes. This is a question for tecnical purpose, because
one o
Hi everyone,
I am in the middle of an upgrade from Sp1 to SP4 and have come across an
issue that the item unit on the sales line is mandatory but on the purchase
line it is not. In SP1 it is not mandatory on either.
I vaguely recall (I think but my memory could be fooling me) that at some
stage
Mmm okay
Then I suggest you try a few things:
1) Print the 'Specify inventory' report and check the results like sensible
(I am just wondering whether the financial invenotry was originally unticked
but then later ticked, so a change can I am sure mess things up...). I
think if you have it tick
Unfortunately, it is ticked.
Thanks,
Yuliana
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of James Flavell
Sent: Friday, March 24, 2006 11:09 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] N
Okay then please check what is you settings in the inventory dimension group
for the item.
Is 'Fiancial inventory' ticked at the warehouse level, I am expecting it is
not...
Thanks
James
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behal
Make one bom and one item.
attach item to bom with 1 per series.
Make the item to stock thro journal for 100 no's.
Create a sale order for 100 no's for BOM.
Run MP only for the BOM.
Question is?
Will it plan the item also for 100no's, r will it consider the stock of
100 no's
Wat u get is the
Hi James,
It's happen at Item by Warehouse Level, it's not Item Level.
I've checked the transaction, and I don't have any floating Transaction. All
transaction has been financially updated.
We use FIFO method.
Thanks,
Yuliana
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.
Hi If I understand what oyu are asking
The master planning will always run through ALL the item master records (if
you did not filter the item master selection).
So it will go through 40,000 items even though only 1,000 will be shown in
the results of the master plan.
I believe that is how tech
If u want to plan it only for the zz warehouse as in ur case and u dont
want to take the stock that are in the other warehouses, then it will
plan only for the zz warehouse if u run only for the zz warehouse.
The answer for ur question is it'll plan only for the 1000 item codes.
The order for the
Hi,
I am doing an upgrade from Sp1 to Sp4 and know that now Axapta requires the
item units to be used (i.e. cannot be left blank).
I don't seem to be able to find any scripts in the upgrade process to turn
my blank unit records into something. Is any such script provided?
If not I was wanting t
Consumption acocunt happens because your returning cost is different to the
original cost
This is because Axapta uses estiamted avg for issue etc.
Anyway to fix you can do two ways:
1) Use negative recv now on the original PO line
2) Use makring to mark return line with original line (this way A
Hi,
First thing:
Is your 0 qty but value at the item level or when you print by warehouse,
location etc?
If really you get it at the item level then supposedly you recalc and
closing usually sorts it out BUT of course if you have allowed negative
stock etc then potential even recalc and closing m
Hi Matrish,
Thank you for the reply.But i need to select the record
dynamically.i dont have to specify a range because my value might
start with any value and also dynamically selected the datasource is
like i might have more records and will be very slow too.I need an
equivalent sql state
The thing I like about using X++ Code and ODBC through classes over the Custom
Import Def. is that you can do a lot as far as creating UOM, etc. and creating
secondary data, in other tables with the same based data given.
To me the X++ Classes and ODBC gives you much great flexibility than the
We find that using the type "custom" option in Axapta instead of an excel
file for imports gives the same performance increase as described below with
the odbc class. Strangely enough, the Canadian zip code file (ascii 2.4mb)
is magnitudes larger than the US file (ascii 800k). I think Canada has
Dear,
Did anyone ever experience the same AOS problem as described below?
We use Axapta 3.0 SP3
Since two weeks we have a strange behaviour on one of our production
AOS servers.
In production we have 3 AOS servers in cluster. Two weeks ago we did
a cutover of our application (copy of devel
I tell you the best way to upload data. Create Classes in X++ that use ODBC. I
always upload customer data into Axapta during implementations using X++ and
ODBC.
To give you and example, we had a functional consultant take Zipcode data and
try and upload that into Axapta through the Excel impor
Hi all,
I have 40 000 item codes for my item table and all have lots of transactions
for different warehouses.
I work with including warehouse dimension to the coverage, and exclude some
warehouses from my master planning.
I have the warehouses aa, bb, cc, dd, xx, yy, z
Hi,
Use CSV file to upload. It is faster than excel upload. Create the same excel
spreadsheet, but you may have to map later to create definition for upload. We
had uploaded 4 years balances for 3 companies, thats lot of records but the
load was much much faster. Another soultion is ATLAS/
Hi Raj,
Do one thing create one instance of query class, then dynamically add
datasource in that query & then add range in that query& finally provide
value for this range in same manner ('234334','345345','34534'). Then Create
one an object of queryrun class & then iterate for values by this way u
hi pankaj,
if you have the recordId than
use this
tablename_ds.findrecord(record).
bye
Prem SS <[EMAIL PROTECTED]> wrote:
Hi All,
I want to know how to bring the focus on particular record in Axapta. I am
doing a process in which when I trigger an event a process b
Hi Group
I tried to upload Ledger Transactions thru Axapta Excel Template, using
LedgerJournalTrans table. I uploaded 378 lines with minimal data at each
line level. It took almost 15 minutes.
What i would like to know, is there any way to optimize the Data Upload
thru Axapta?
Is there a way to
Hi,
As in Axapta, we have different types of security keys based on
"RecordTypes" e.g. securitykey, MenuItemDisplay, Table etc...
There is a system table "AccessRightsList" which keeps track of alloted
securiy keys.If all the children security keys are having same permission as
their pare
Hi,
When a Customer packing slip journal is printed i have to update the
status of the field "printed" in the table "CustPackingSlipJour".
When the packing slip is printed when posting packingslip
from "salesTable" form
(or)
when opening the "CustPackingSlipJournal" form + "Show" Menubutton
Hi All,
I want to know how to bring the focus on particular record in Axapta. I am
doing a process in which when I trigger an event a process brings one record
into Axapta database and after successful completion of this process, the
cursor should focus on that record. How can we do this i
Hi, all!
I'm Eugene from Korea.
Could you help me?
I had a issue in the process of Credit note(Accounts payable>purchase
order-Functions-) about Purchase Order.
That is something about Consumption Account.
Sometimes I have got financail voucher with consumption account as
the result of credi
Hi Eddie ,
You can not do much at Sales Order level as both orders have same delivery
dates.But at the Production Order level you can assign HIGHER Priority number
(Production Order --> Setup tab) for the promotion parts . Then when you run
Scheduling for Multiple production orders, Higher
dear all
who can use attach file on axapta
thank you
nip
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-te
Hi,
Recalculation/Closing will correct the inventory.
Some times if negetive inventory is allowed , ie item is sold or conumed
before purchasing or adjusted , closing will not have any impact
Regards
Samuel Pramod
"Tany, Yuliana" <[EMAIL PROTECTED]> wrote:
Hi Samuel,
This
Dear All,
I have an requirement like selecting records for Purch Items
for 'n' number of Purchase order. This is like Select * from PurchLine
where purchid in ('234334','345345','34534'). Could any one kindly
help me doing this equillent in Axapta SQL. This is an urgent
requirement pl
Hi Samuel,
This condition will happen if you haven't run the closing.
If you've run the recalculation / closing, you shouldn't have this problem
right?
Thanks,
Yuliana
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of samuel pramod
Hi,
This happens because of following reasons
Item A Purchased 100 qty Cost 0
Item A Inventory adjusted -100 qty Cost 10
in above case Inventory value shows 0 qty with cost 10
Hope it is clear now
regards
Samuel Pramod
"Tany, Yuliana" <[EMAIL PRO
32 matches
Mail list logo
