[Axapta-Knowledge-Village] AccountInterval Upload
Hello everybody, I uploaded Chart of Accounts and I would like to upload the Totals range for Account Type Total. I have created the template by using AccountInterval Table. This table contains the following fields: Table: Record ID: From:GL Account No. To : GL Account No. Invert Sign: No Could anybody tell me what should I enter in Table and Record ID? Your help is appreciated. To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] AccountInterval Upload
Just A guess haven't even looked at it ,but it Table id is probably the ledgertable num(if you areusing the ledgertable),and For the rec/More than likely Accountrecid You need to get the Rec id of the Ledgertable Account that you want the totals to be Mapped to. i.e.)Copy the ledgertable into excel (This way you will have a map of the Ledgeraccount and the related Recid) Hope it helps Regards Jason Crook Financial Systems Consultant Exordia(A Division Of PricewaterhouseCoopers) Tel : (011)797-4782 Fax : (011)209-4782 Cel : 082 887 0914 e-mail : [EMAIL PROTECTED] From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Asrar AhamedSent: 05 August 2005 02:53 PMTo: AxaptaSubject: [Axapta-Knowledge-Village] AccountInterval Upload Hello everybody, I uploaded Chart of Accounts and I would like to upload the Totals range for Account Type Total. I have created the template by using AccountInterval Table. This table contains the following fields: Table: Record ID: From:GL Account No. To : GL Account No. Invert Sign: No Could anybody tell me what should I enter in Table and Record ID? Your help is appreciated. To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Master Scheduling: Error Messages
I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated. Thanks - we're new to Axapta Master scheduling. Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h7ue9k1/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123260149/A=2894352/R=0/SIG=11fdoufgv/*http://www.globalgiving.com/cb/cidi/tsun.html;Help tsunami villages rebuild at GlobalGiving. The real work starts now/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta
Title: Message Hi, You must pay for additional financial dimensions not for item or storage dimensions. For those you just can add them yourself in code. I guess someone already helped you with that. Maurice Cohen Advanced Systems Integration, Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 ph: 949-597-2170 fax: 949-597-0720 cell: 949-533-5966 From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of James Flavell Sent: Thursday, August 04, 2005 5:14 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta Thanks Barry, I want to add an 'invenotry dimension' I(Warehouse,location,batch number) not a 'finanical dimension' (department, cost centre, purpose)which I think is what you are referring to when you say you must pay for extra dimensions (can someone confirm additional 'inventory dimensions' do not require addition to license) Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Bayliss, Barry Sent: 05 August 2005 10:04 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta Hello James, My understanding is that users must pay for extra dimensions as part of the licensing. Is there a reason why you want to add the dimension only in the inventory section, and not across the whole Axapta product? Barry. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of James Flavell Sent: Friday, 5 August 2005 9:57 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta Hi Barry, I wish to add a new field Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Bayliss, Barry Sent: 05 August 2005 07:22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta James, Are you trying to: 1. Add a new dimensional field 2. Add a new dimensional value to an existing dimensional field? Barry. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of James Flavell Sent: Thursday, 4 August 2005 2:16 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta I would like to know is there any document to describe adding an storage inventory dimension to Axapta v3.0? I recall seeing a post that the steps for a new dimension are in the Axapta dev guide but when I look I can only find about adding a new FINANCIAL dimension but not invenotry dimension. I would appreciate if anyone can help me find this document (if it exists) or adivse from your experience of what needs to be done and how long it might take and how riskysuch a modification is. Thanks James Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Re: SQL script to do record count
SQL Server has an inbuilt functionality that will give you this information. on the enterprise manager right click on the database and select View - taskpad. This will give you 3 tabs of database related information. The table info tab will provide the list of all the tables and their record count. You have to remember that this record count on a table represents all Company records. SSK --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell [EMAIL PROTECTED] wrote: Hi Does anyone have a SQL script that I can run against a Axapta DB to get a simple output of table name and record count for the table? I need to do a check of record counts from a SQL 7 to SQL 2000 upgrade to be sure everything is in order after the upgrade. Thank you very much James Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h2645e4/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123263043/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
That's a possibility. We just converted and went live last month. How could I identify this? just match the BOM lines against InventTable items? --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0 from another system. Our problem was that we had imported BOM lines pointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error Messages I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated. Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h6cj306/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123269518/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
Exactly. Just create a small job that runs through all BOM lines and lookup each itemid. The ones, that do not exist in InventTable, will create problems. /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 19:19 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages That's a possibility. We just converted and went live last month. How could I identify this? just match the BOM lines against InventTable items? --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0 from another system. Our problem was that we had imported BOM lines pointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error Messages I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated. Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hcfo8ij/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123283030/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
Hi Philip, I suggest you to do following. As you are aware, since we also migrated huge volume of SAP to axapta, we too have these kind of problems due to bad data. as per my experience , I suggest you to do the following. 1. As Jens mentioned you can write a simple job to get the info log of all the missing items. However, at the same time you may need to check reqItemTable, InventItemlocation etc ect for that missing items. 2. I strongly suggest to run consistency check for the whole company on all the modules. Its very important to run consistency check after you migrated the data. Eventhough consistency check will not tell everything, but defintely catch these kind of problems. Best of Luck. Thanks, subbu Jens Strandberg [EMAIL PROTECTED] wrote: Exactly. Just create a small job that runs through all BOM lines and lookupeach itemid. The ones, that do not exist in InventTable, will createproblems./Jens-Oprindelig meddelelse-Fra: Axapta-Knowledge-Village@yahoogroups.com[mailto:[EMAIL PROTECTED] vegne af Philip R.FreimannSendt: 5. august 2005 19:19Til: Axapta-Knowledge-Village@yahoogroups.comEmne: [Axapta-Knowledge-Village] Re: Master Scheduling: Error MessagesThat's a possibility. We just converted and went live last month.How could I identify this? just match the BOM lines againstInventTable items?--- In Axapta-Knowledge-Village@yahoogroups.com, "Jens Strandberg"[EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0from another system. Our problem was that we had imported BOM linespointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne afPhilipR. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error Messages I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? "Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated." Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta.Yahoo! Groups Links__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.