[Axapta-Knowledge-Village] AOS Error:100

[Srivastava Ashish]

Hi,

Good Morning!!
we are in process of upgrading Axapta 3.0 to Microsoft Dynamics Ax 4.0
Following are the steps I followed during the Data Upgrade:
1) Installed Microsoft Dynamics Ax(cleared the checkbox "Start the AOS
Windows Service as part of installation")
2) Run the Dynamics AX DB Upgrade Tool
3) copy the updated application files to Microsoft
Dynamics\4.0\Application\Appl\Standard
4)Delete the index file(Axapd.aoi)
5) Start the AOS


while starting the AOS it is throwing error:

The Dynamics Server$01-Company1 service terminated with service-specific
error 100 (0x64)



any help will be appreciated



Thanks

Ashish

Re: [Axapta-Knowledge-Village] Inventory related query - MOST URGENT

[Srivastava Ashish]

Hi Prasanna,

Add new Account type statistical in LedgeAccountType Base Enum
create ledger account in chart of account and assign statistical account
type
go to InventPosting Form and set your ledger account as offset account
you will have to add your own voucher for posting in updatenow method of
salesformletter_invoice
for your qty and zero amount.
 ledgerVoucher.addTrans(
LedgerVoucherTransObject::newCreateTrans(
ledgerVoucher.findLedgerVoucherObject(),
LedgerPostingType::SalesDisc,
accountDisc,
salesLine.Dimension,
salesLine.CurrencyCode,
discValue,
this.ledgerRefTableId(),
this.ledgerRefRecid(),
0,
this.fixedExchRate(),
this.fixedExchRateSecondary(),
this.fixedEuroTriangulation(),
false,
ProjLedger::newInventSales(salesLine.ProjId,
   salesLine.ProjCategoryId,
   salesLine.InventTransId,
   number,

inventMovement.projAdjustRefId(;

this is just an idea to post the qty with zero amount you will have to
change it as per your requirement.

Regards
Ashish
On 5/28/08, prasanna govindan <[EMAIL PROTECTED]> wrote:

>Hi ashish,
>
> Thanks for the solution. I find your solution will work out for me.
>
> It will be helpful, if you can send me any documentation related to it.
>
> If nor possible, could you please elaborate your suggestion.
>
> Thanks in advance
> Regards
> Prasanna
>
>
> - Original Message 
> From: Srivastava Ashish <[EMAIL PROTECTED]>
> To: Axapta-Knowledge-Village@yahoogroups.com
> Sent: Wednesday, 28 May, 2008 10:43:15 AM
> Subject: Re: [Axapta-Knowledge-Village] Inventory related query - MOST
> URGENT
>
>
> It can be done through statistical accounts with that only qty is posted in
> account no financial transaction is done.
> But for this you need to do some customization like you need to add new
> accounting type in Ledger Accounting Type and some setup in InventPosting.
> You need to change the code for posting of sales order to create voucher for
> qty only with zero amount.
>
> Ashish
>
> On 5/27/08, James Flavell <[EMAIL PROTECTED] com <[EMAIL PROTECTED]>> wrote:
>>
>>You could do:
>>
>> Make a new posting type for gift in the inventory posting so then you can
>> control where the COGS goes for the item when its a gift.
>> Month end you can then either run a report of COGS for gift items and then
>> push this back into the onhand inventory value or accept it as a P/L
>>
>> This is not fully automatic but it is fairly easy to do and flexible if
>> later they decide on all kinds of ideas of where to put the gift COGS :)
>>
>> Thanks
>> James
>>
>>
>>  --
>> *From:* Axapta-Knowledge- [EMAIL PROTECTED] 
>> ups.com[mailto:Axapta-Knowledge-
>> [EMAIL PROTECTED] ups.com ] *On
>> Behalf Of *prasanna govindan
>> *Sent:* Wednesday, May 28, 2008 11:37 AM
>> *To:* Axapta-Knowledge- [EMAIL PROTECTED] 
>> ups.com
>> *Subject:* [Axapta-Knowledge- Village] Inventory related query - MOST
>> URGENT
>>
>>
>>
>>  Dear all,
>>
>> I have a peculiar requirement regarding the inventory. My clients used to
>> give gifts from his stock.
>> He requires that Item quantity has to be depleted, but NO entry has to be
>> passed in the books of accounts.
>>
>> I tried through Movement journals & Profit & Loss journal, but if the
>> receipt has the value, then system automatically passes the issue entry and
>> passes the necessary entries in chart of accounts.
>>
>> What I should to address the following requirement:
>> a. I should deplete the stock for the quantity & no entry has to be
>> passed.
>> b. If I do it for the zero value by through set ups or customisation, My
>> existing stock will be overvalued. How can I adjust that value?
>> C. Inshort, Inventory module to get affected, but ledger accounts should
>> not get affected. How to do this?
>> *P.S. It is not specific to separate item groups or Items. The same item
>> is used for sale & also for gifting. So, I can do through Inventory Model
>> Group.*
>>
>> Kindly suggest what to do, any set up will address this issue or
>> Customisation has to be done?
>> If customisation, wh

Re: [Axapta-Knowledge-Village] Inventory related query - MOST URGENT

[Srivastava Ashish]

It can be done through statistical accounts with that only qty is posted in
account no financial transaction is done.
But for this you need to do some customization like you need to add new
accounting type in Ledger Accounting Type and some setup in
InventPosting.You need to change the code for posting of sales order to
create voucher for qty only with zero amount.

Ashish

On 5/27/08, James Flavell <[EMAIL PROTECTED]> wrote:
>
>You could do:
>
> Make a new posting type for gift in the inventory posting so then you can
> control where the COGS goes for the item when its a gift.
> Month end you can then either run a report of COGS for gift items and then
> push this back into the onhand inventory value or accept it as a P/L
>
> This is not fully automatic but it is fairly easy to do and flexible if
> later they decide on all kinds of ideas of where to put the gift COGS :)
>
> Thanks
> James
>
>
>  --
> *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto:
> [EMAIL PROTECTED] *On Behalf Of *prasanna govindan
> *Sent:* Wednesday, May 28, 2008 11:37 AM
> *To:* Axapta-Knowledge-Village@yahoogroups.com
> *Subject:* [Axapta-Knowledge-Village] Inventory related query - MOST
> URGENT
>
>
>
>  Dear all,
>
> I have a peculiar requirement regarding the inventory. My clients used to
> give gifts from his stock.
> He requires that Item quantity has to be depleted, but NO entry has to be
> passed in the books of accounts.
>
> I tried through Movement journals & Profit & Loss journal, but if the
> receipt has the value, then system automatically passes the issue entry and
> passes the necessary entries in chart of accounts.
>
> What I should to address the following requirement:
> a. I should deplete the stock for the quantity & no entry has to be passed.
>
> b. If I do it for the zero value by through set ups or customisation, My
> existing stock will be overvalued. How can I adjust that value?
> C. Inshort, Inventory module to get affected, but ledger accounts should
> not get affected. How to do this?
> *P.S. It is not specific to separate item groups or Items. The same item
> is used for sale & also for gifting. So, I can do through Inventory Model
> Group.*
>
> Kindly suggest what to do, any set up will address this issue or
> Customisation has to be done?
> If customisation, what classes has to be changed.
>
> Regards
> Prasanna G
>
>
> - Original Message 
> From: Subbu <[EMAIL PROTECTED]>
> To: Axapta-Knowledge-Village@yahoogroups.com
> Sent: Wednesday, 28 May, 2008 6:31:52 AM
> Subject: [Axapta-Knowledge-Village] Re: Abnormal shutdown of AOS
>
>
> ummm It would be very difficult without looking into code.
> And where do you live?. do you mind sending a gotomeeting request to
> me so that I can take a look at this. if not, can you please send me
> the project xpo so that I will give a shot in my local axapta ( Ax4.1)
>
> Subbu
>
> --- In Axapta-Knowledge- [EMAIL PROTECTED] 
> ups.com,
> Mohsin Zia
>  wrote:
> >
> > Hi Subbu,
> >  
> > Customisation is done as to consolidate all the vendTransOpen
> records from all the companies, and post it to one central finance
> company.
> >  
> > I have created one table with the SaveDataPerCompany property set
> to NO. Storing all the retrieved records in them.
> >  
> > Point is in Standard Ax its retrieving the records from Curext() as
> u said, hence no issues.
> > But when it comes to this multi company retrieval i am facing this
> issue. Everything is happening correctly. But only when deleting the
> records and creating PP again i am facing the issue.
> >  
> > I have been to Microsoft Tech Site. This kinda functionality is
> gonna be built in Ax later releases may be 5.0 and later. However
> this we are creating in 4.0.
> >  
> > Any help would be indeed helpful.
> >
> > --- On Sun, 5/25/08, Subbu [EMAIL PROTECTED] wrote:
> >
> > From: Subbu [EMAIL PROTECTED]
> > Subject: [Axapta-Knowledge- Village] Re: Abnormal shutdown of AOS
> > To: Axapta-Knowledge- [EMAIL PROTECTED] 
> > ups.com
> > Date: Sunday, May 25, 2008, 10:35 AM
> >
> >
> >
> >
> >
> >
> > Just a quick question:
> >
> > I didnt quite understand your customization.
> > "
> > I am able to get the records from all companies and
> > >
> > > > then transfer it to ledgerJournalTrans( Payment
> > >
> > > > Journal). "
> >
> > Did you make any code changes to bring in all the vendTransopen and
> > then transfer to payment proposal?.
> >
> > When you bring in from ALL companies, where are you storing them?.
> >
> > to isolate the issue
> >
> > 1. Run the payment proposal just for curext() and delete the lines.
> > see what happens?
> >
> > 2. Could you please tell me why you are trying to consolidate all
> > companies' vendorTrans open records and create one payment
> > proposal ?. I believe its a odd practice..Could you please inform
> me
> > on the requirement? .
> >
> > Kind regards,
> > Subbu
> >
> > --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Mohsin Zia
>

Re: [Axapta-Knowledge-Village] Hi

[Srivastava Ashish]

Hi Gyan

you can upload inventory through cycle count journal in inventory module.

Regards
Ashish
On 4/22/08, gyanendra sahoo <[EMAIL PROTECTED]> wrote:
>
>Hi,
>Anybody tell me how to upload inventory physical quantity?
>
> Thanks
>
> Gyan
>
> --
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
> now.
>
> 
>

Re: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock

[Srivastava Ashish]

I have written a job that will help to create movement journal and post it.
Try this job

static void MovementJournalImportExcel(Args _args)
{
 InventJournalTrans inventJournalTrans;
 InventDim  inventDim;
 InventJournalTable inventJournalTable;
 InventJournalCheckPost journalCheckPost;
 InventJournalIdjournalId;
 journalTableData   journalTabledata;
 InventBatchinventBatch;
 InventBatchlocalInventBatch;
 NumberSeq  numberSeq;
 NumberSequenceReferencenumberSequenceReference;
 InventSerial   inventSerial;
 InventSerial   localinventSerial;
 int j,countno=0,i,k;
 real Scarp;
 FilenameOpenfilename;

 Sysexcelapplication excelapp=sysexcelapplication::construct();
 sysexcelworksheet excelworksheet;
 sysexcelrange excelrange;
 sysexcelcells excelcells;
// comvariant cellvalue=new comvariant();
;

// Creating Journal Header
inventJournaltable.initValue();
inventJournalTable.JournalNameId = 'ERecover';
numberSeq = new NumberSeq();
numberSequenceReference = InventParameters::numRefInventJournalId();
numberseq = NumberSeq::newGetNum(numberSequenceReference);

inventJournalTable.JournalId = numberseq.num();
inventJournalTable.Description = InventJournalName::find(
inventJournalTable.JournalNameId).Description;
inventJournalTable.insert();


excelapp.workbooks().open('C:\\Documents and
Settings\\asrivastava\\Desktop\\ElectronicData_OnlyWstatus_10032007.xls');
excelworksheet=excelapp.worksheets().itemFromNum(1);
excelcells=excelworksheet.cells();

// Creating Unit Numbers
 for(i=301;i<=5600;i++)
 {
inventBatch.clear();
inventBatch.initValue();
inventBatch.itemId = excelcells.item(i,11).value().bStr();
inventBatch.inventBatchId = excelcells.item(i,1).value().bStr();
localinventBatch = InventBatch::find(inventBatch.inventBatchId,
inventBatch.itemId);

if(!localinventBatch)
{
inventBatch.OakSerialUnit = excelcells.item(i,2).value().bStr();
inventBatch.insert();
}
 }

//Creating Appartment Numbers
 for(k=1;k<=648;k++)
 {
inventSerial.clear();
inventSerial.initValue();
inventSerial.InventSerialId = excelcells.item(k,8).value().bStr();
inventSerial.ItemId = excelcells.item(k,11).value().bStr();
localinventSerial = InventSerial::find(inventSerial.InventSerialId,
inventSerial.ItemId);

if(!localInventSerial)
{
inventSerial.ProdDate = systemDateGet();
inventSerial.insert();
}
 }

 // Creating Journal Lines
 for(j=301;j<=5600;j++)
 {
inventJournalTrans.clear();
inventJournalTrans.initValue();
inventJournalTrans.TransDate = systemDateGet();
inventJournalTrans.LedgerAccountIdOffset = "9";
inventJournalTrans.JournalType = InventJournalType::Movement;
inventJournalTrans.JournalId = inventJournalTable.JournalId;
numberSeq = new NumberSeq();
numberSequenceReference =
InventParameters::numRefInventJournalVoucherId();
numberseq = NumberSeq::newGetNum(numberSequenceReference);

inventJournalTrans.Voucher = numberseq.num();
inventJournalTrans.ItemId  = excelcells.item
(j,11).value().bStr();
// defaulting branch and item name
inventJournalTrans.CostAmount  = InventTable::find(
inventJournalTrans.ItemId).inventTableModuleInvent().Price;
inventJournalTable = InventJournalTable::find(
inventJournalTrans.JournalId);
inventDim.InventLocationId =  excelcells.item
(j,10).value().bStr();
inventDim.inventBatchId= excelcells.item
(j,1).value().bStr();
inventDim.inventSerialId   = excelcells.item
(j,8).value().bStr();
inventJournalTrans.InventDimId =
inventDim::findOrCreate(inventDim).inventDimId;
inventJournalTrans.Qty = 1;
inventJournalTrans.AdjustmentNotes = "Initial Data Load";
inventJournalTrans.LineNum = j;


inventJournalTrans.insert();
 }


excelapp.workbooks().item(1).saved(true);
excelapp.workbooks().close();

// Posting Journal
journalTableData = JournalTableData::newTable(inventJournalTable);
journalTableData.updateBlock
(JournalBlockLevel::InUse,JournalBlockLevel::None);
if (!infolog.num(Exception::Error))
{
infolog.clear(0);
journalCheckPost =
InventjournalCheckPost::newJournalCheckPost(JournalCheckPostType::Post,InventJournalTable);
journalCheckPost.parmAutoBlock(true);
journalCheckPost.run();
}
 }



Regards

Ashish




On 10/7/07, madhubabu_r <[EMAIL PROTECTED]> wrote:
>
>   Hi Ashwani,
>
> Thanks for such a detailed information which would be useful to all
> our fello

Re: [Axapta-Knowledge-Village] CRTL+ALT+F4 (go to maintable) doesn't work anymore

[Srivastava Ashish]

The problem can be because of security setting Please check the security
key.

On 9/17/07, Sumit Loya <[EMAIL PROTECTED]> wrote:
>
>   Hi,
>
> One problem i can figure out is may be due to different OS.
>
> Like the shortcut key you specified in ur mail will not work on
> windows 2000 OS while it will work on windows XP.
>
> hope this information helps.
>
> Regards,
> Sumit
>
> On 9/14/07, roland_poletti <[EMAIL PROTECTED] >
> wrote:
> > Hi all
> > i got the problem the the shortcut CTRL+ALT+F4 (same as right-click
> > and go to maintable) doesn't work anymore for some users. Some other
> > user still have this functionality.
> > Does anybody know what happened?
> >
> > I deleted already the *.axc-file but it still doesn't work.
> >
> > Thanks in advance for helping.
> > Best regards
> > Roland
> >
> >
> 
>


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] flow of the return items

[Srivastava Ashish]

You need to use subcontracting process for repairing.
There is a well defined setup to use subcontracting in Axapta.
You need to create a vendor type warehouse from there u need to create
transfer order.
Hope it will help you.

Regards
Ashish


On 8/1/07, AX CONS <[EMAIL PROTECTED]> wrote:
>
>   Hi all,
>
> I have a problem with the flow of the return items. When we get the return
> item, we should repair and send the item again with the same number and
> serial number. Return Item and repair process is limited within Axapta.
> Any
> idea?
>
> Thank you
>
> [Non-text portions of this message have been removed]
>
> 
>


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] BOM from X++

[Srivastava Ashish]

what is the need to create the BOM through X++

On 1/16/07, gennarociulla <[EMAIL PROTECTED]> wrote:
>
>   Hi, there's a way to build and approve a BOM via X++?
> Thank you.
>
> 
>


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] Invoicing a lease monthly

[Srivastava Ashish]

Hi BOB,

In stead of using Sales Order, use Subscription functionality from Service
Management module (AX 4.0).

Regards,
Ashish Srivastava


On 12/12/06, bobchamp5 <[EMAIL PROTECTED]> wrote:
>
>   HI
>
> Is there a way to enter a sales order for a billable lease that will
> invoice each month until order is filled. Can this be done with
> subscription?
>
> Thanks
> Bob
>
> 
>


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] Purchase Return from Quarantine order

[Srivastava Ashish]

in this case only the inventory loss account will be affected with the
amount of 20 qty but physically it will show only 80 qty in general
warehouse.

On 12/13/06, santu_rajpur <[EMAIL PROTECTED]> wrote:
>
>   Hi,
>
> I am finding a strange issue in quarantine order.
>
> Objective:Purchase return of bad quality items.The material will be
> received and quality checked.If some material is good it will be send
> to main warehouse and rest will be rejected.The rejected material
> will go to some different warehouse where from the material will be
> picked up while making Purchase return
>
> Process:
> The same has been thought through quarantine order process.I have
> linked a quarantine w/h with the default w/h for the item.The
> inventory model group has been quarantine order activated.
>
> When material is packing slip updated the quarantine order is
> automatically generated.Now the quality person goes to quarantine
> order.cilck on functions and then scrap.When scrap is clicked it asks
> for the qty to be scrapped.Say for a receipt of 100 pcs one rejects
> 20 pcs.Select 20 and click ok.
> The rest 80 will be available for report as finished.
>
> The rest 20 is going out of the system.Logically it should go to some
> warehouse called scrap warehouse so that it will enable you to make
> purchase return from the scrap warehouse.But when you try to track
> the inventory it is not possible to find the rejected 20 pcs.
>
> Where those items go and how to go about it.
>
> Regards,
>
> 
>


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] Import Records from Excel to Axapta

[Srivastava Ashish]

Hi Bhasker,

For importing data in Item Master, you need to populate data in InventTable,
InventTableModule & InventItemLocation Tables. Only importing data in
InventTable will not work.

So delete records imported in InventTable and try importing for these 3
tables.

Please let me know, what error you are getting for LedgerTable?

Regards,
Ashish Srivastava


On 12/12/06, bhaskerv1 <[EMAIL PROTECTED]> wrote:
>
>   Hi,
> Iam Bhasker, New to the group.
>
> Iam getting error messages at the time of importing records from Excel
> to Axapta as "Item number already existing, it cannot be created".
> This problem is related to the tables " LedgerTable" & "InventTable".
>
> After importing the data from Excel to Axapta in the given format, the
> Data is not appearing in the respective form but where in it is
> appearing in the table( which we can see through table browser).
>
> So can anyone help me how to upload the data from ExcelFile to Axapata
>
> Regards
> Bhasker
>
> 
>


[Non-text portions of this message have been removed]