Re: [Axapta-Knowledge-Village] Item Dim with BOM?

2006-03-10 Thread In Memories
Well "Z" must be mandatory in Purchase orders and inventory transactions. thanks Raj J <[EMAIL PROTECTED]> wrote: What if . Make Item Dim X & Y as "Primary Stocking" and Make 3rd Dim "Z" as seconday stocking allowing "Blank issue/receipt" in Dimension Group. Best Regards,

RE: [Axapta-Knowledge-Village] Inventory Module vs GL Module

2006-03-10 Thread James Flavell
A fw things: The 50 dolalr posting is probalby purchase cosumption (i.e. the return cost - avg - on the credit note is different to the original PO invoice cost). Check out what is the psoting type on the ledger trans will tell you what type of transaction it is. If you want to return the actua

[Axapta-Knowledge-Village] Re: Creating reports on the basis of "CASH" system of accounting

2006-03-10 Thread Hardi
Hi Yogesh I hope I understand the situation clearly now. So axapta system you wish to run is located in the US or India? and the subsidiary is under separate company account or not? Under the same data, you want to have: -Sales report based on "real payment" -Sales report based on "proforma invoic

Re: [Axapta-Knowledge-Village] system administration question

2006-03-10 Thread Varden Morris
The export of the user group permissions works fine. Has anyone ever been able to import the user group permission? The import button is always grayed out. Also the standard export/import for the tables UserInfo, UserGroupList and UserGroupInfo works fine to export these tables but it never

Re: [Axapta-Knowledge-Village] system administration question

2006-03-10 Thread Mike Matta
Thanks Malcolm. I'll try that. Best Regards, Mike - Original Message - From: Malcolm Burtt To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, March 10, 2006 11:51 AM Subject: RE: [Axapta-Knowledge-Village] system administration question Yes, its back to the standa

[Axapta-Knowledge-Village] Inventory Module vs GL Module

2006-03-10 Thread Luxflux
Hi to all: I have this problem: I´m comparing the Inventory balance and the GL Balance of an account and an item. This balances are different because of the credit notes. We have Weighted avg. in the Inventory Model group, so Axapta does the next. Inventory G

[Axapta-Knowledge-Village] How to detect TableId

2006-03-10 Thread Padmaja Iyingar
Hello , I am try to detect the next TableID . I thought it would create next number off of the sqlDictionalry system table for any new created Table. can you please educate me on how to find the what TableID it assigns for any newly created Table? advance thanks, Pa

RE: [Axapta-Knowledge-Village] system administration question

2006-03-10 Thread Malcolm Burtt
Yes, its back to the standard Import/Export tool for that. The tables you need are... * SysUserInfo - User table (1:1 relation to kernel UserInfo table) * UserGroupInfo- User groups (kernel table) * UserGroupList- User group memberships

Re: [Axapta-Knowledge-Village] system administration question

2006-03-10 Thread Mike Matta
Malcolm, That's great for exporting the group permissions. Thanks! Any idea how I could I export the users? We have setup over 100 users on one system and would like to copy those users over to the other installations. Thanks, Mike - Original Message - From: Malcolm Burtt T

RE: [Axapta-Knowledge-Village] Creating reports on the basis of "CASH" system of accounting

2006-03-10 Thread Bonk, David
Yogesh; Axapta like all other ERP systems are an accrual based system so it would be very hard to run this on the cash basis. But depending on the type of business they are ie manufacturing, distributor or financial it may be easier to design work flow outside of Axapta so that postings are made

RE: [Axapta-Knowledge-Village] SOX/SAP....Segregation of duties etc

2006-03-10 Thread Bonk, David
James; A good example of this is that a person can enter a PO, receive the goods or services and post the invoice for payment all in one form. There is no control on this other than form level security which is very hard to set-up and maintain. I do not know SAP but in Baan you had different menu

RE: [Axapta-Knowledge-Village] system administration question

2006-03-10 Thread Malcolm Burtt
Mike As I said, the security import/export function is on User Group Permissions form itself (Administration -> Setup -> Security). There are buttons there for Export and Import. You don't need to use the database import/export tools that you're referring to. Just open the user group permissions

Re: [Axapta-Knowledge-Village] system administration question

2006-03-10 Thread Mike Matta
Hi Malcolm, We are using AX3.0, SP4. I am trying to learn more about the export/import function. It appears that you have to setup a definition group and use the "table setup" feature to indicate what tables you want to export. I don't know what tables contain this info. Do you? or does an

RE: [Axapta-Knowledge-Village] system administration question

2006-03-10 Thread Malcolm Burtt
Hi Mike What version are you using? Axapta 3.0 has an import/export option on the user group permissions setup form which allows you to write the permission of one user group to a file and then import that file to another user group. There is no reason why those user groups need be in the same Ax

[Axapta-Knowledge-Village] system administration question

2006-03-10 Thread Mike Matta
Hi All, I am new to Axapta and having trouble finding an easy way to copy user permissions from one instance of Axapta to another. Does anyone know of any easy way to export/import user permissions? Thanks, Mike [Non-text portions of this message have been removed] Sharing the knowledge on

[Axapta-Knowledge-Village] Upgard Ax. 2.5 SP 2 to AX 3.0 SP4

2006-03-10 Thread pbercher
Hi, during the upgrade i get the error: InfoMessage (13:26:31) Run job 'updateCustSalesLinkTable' ordered by 'Admin' in database 'pa1'. Error Message (13:26:31)\Table CustPickingListSalesLink Reference for call of number sequences is not specified. any ideas wht i miss

Re: [Axapta-Knowledge-Village] Re: Creating reports on the basis of "CASH" system of accounting

2006-03-10 Thread yogesh kasat
Hi Hardi, Thanks for your reply. Our Client in India & has subsidiary in USA. Main business area of client is providing different services. For subsidiary in USA, They need to submit reports on the basis of Cash system to - IRS (USA) At the same time, they need to submit reports on the basis

[Axapta-Knowledge-Village] Re: Creating reports on the basis of "CASH" system of accounting

2006-03-10 Thread Hardi
Hi Yogesh officially what is the rule, should it be entered into journal based on accrual or cash basis? maybe you can check with the auditor for this; you have to be careful if you are dealing with ledger posting because it will subject to be audited by the government authorities usually. One

Re: [Axapta-Knowledge-Village] Re: Creating reports on the basis of "CASH" system of accounting

2006-03-10 Thread yogesh kasat
Hi, But by doing this we will not able to get reports on basis of accrual system of accounting. Our client want reports generated on the basis of Cash system of accounting as additional feature to meet few regulatory reporting fomalities. Client's current software (Quick books) supports generat

[Axapta-Knowledge-Village] Re: Creating reports on the basis of "CASH" system of accounting

2006-03-10 Thread Hardi
Hi, I am thinking of utilizing "Proforma Invoice" in standard Axapta, but of course need some report modifications since the INVOICE NUMBER is not there during proforma invoice generation. I might think of adding one field connected to number sequence to achieve this. After the real payment com

[Axapta-Knowledge-Village] grid

2006-03-10 Thread su yavas
hi, how do i load xml data into grid? please help me best regard, su __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for ax