[Axapta-Knowledge-Village] Re: working time not specified

2005-01-11 Thread birzanto
Dear all, I really need this information. Today, I found also the same problem when I click the Net Requirements and Explosion. Working time '' has not been specified for '1/11/2005' Although the work center related has been specified on that date forward. Please kindly help ! Rgds, ---

Re: [Axapta-Knowledge-Village] Branch Definition within an Entity and attachment of documents to Branch

2005-01-11 Thread Nitesh
Hi How u r generating the different invoice number to different location? Regards Nitesh - Original Message - From: bhgopal12 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, January 10, 2005 2:53 PM Subject: [Axapta-Knowledge-Village] Branch Definition

RE: [Axapta-Knowledge-Village] Re: working time not specified

2005-01-11 Thread Yifat Halili
Hey there, I have not read your previous mails, but have you created the calendar with the working times? Basic- setup - calendar - working times template, then create the calendar using the working times template, make sure that the date that you are refer to is in fact been

RE: [Axapta-Knowledge-Village] Question from a (future?) customer in France

2005-01-11 Thread Neil Ferguson-Lee
Philippe, If your customer is working in a production environment without production orders, it is possible they are operating in a Lean Manufacturing environment. Lean Manufacturing modules, including kanban, are provided by eBECS Limited in the UK and they do provide a French language

[Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data

2005-01-11 Thread Danny Gaethofs
Jesper, Running ax3.0SP3. You are absolutely right. I tested it today and the data disappears after synchronization. ## SQL Administration You suggest SQL Administration, Table, Synchronize could to the trick. I have tested this but it deletes the data also. You probably ment to say use SQL

[Axapta-Knowledge-Village] Closing Subscription Purchase Orders

2005-01-11 Thread frodnew57
We have subscription orders with many of our vendors, but wish to have them expire at the end of the year and be replaced with new subscription orders. Unfortunately, the old subscription orders still appear as open. This invites transactions being posted to the wrong order. We would like

[Axapta-Knowledge-Village] SysPrintForm/Email

2005-01-11 Thread Danny Gaethofs
Dear all, Can someone tell me how the selection made in the SysPrintForm is returned to the form SalesEditLines. When selecting email I want to influence the outlook id that is used for sending the message. Is it possible to use another sender id then the outlook id of the user/employee.

RE: [Axapta-Knowledge-Village] Branch Definition within an Entity and attachment of documents to Branch

2005-01-11 Thread Jesper Kehlet
Number sequence groups if within the same company. From: Nitesh [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 11, 2005 5:14 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Branch Definition within an Entity and attachment of documents to Branch

Re: [Axapta-Knowledge-Village] One report with data from all companies

2005-01-11 Thread Girish B
you need to include the table which will be populated with the records (and used in the report) , in the virtual company which has access to all the companies. now you can write a function to populate the data and use the changecompany() function to change to another company. this will

RE : [Axapta-Knowledge-Village] Multiple Tables in a View DataSource

2005-01-11 Thread Steeve Gilbert
I don't have a clear answer for you but here are some tips: - If you want to create a view like this: MainTab + SubTab1 + SubTab2 You can do this : SubTab1 + MainTab + SubTab2 This way, both table will be able to link with MainTab. It's not very clean but it get you out of

[Axapta-Knowledge-Village] Make 2 Production Order, 1 Production Order.

2005-01-11 Thread Cenk Ince
Hi all; I make some modificationas on prodtable. I have 2 PO and i want to make them 1 PO if they have same route, same itemid and same bom. But when i make union them with code below i lose inventtrans references. How can i keep references? Thanks void UnionPO(ProdId ProdIdMain,ProdId

[Axapta-Knowledge-Village] RE: Make 2 Production Order, 1 Production Order.

2005-01-11 Thread Harry Deshpande
Hi Cenk! Is there any particular reason as to why you have to do it this way? If not then then what you could potentially do is Take 2 identical POs, reset the status back to created, increase PO quantity of main PO, delete child PO and the increase the status of the main PO to

[Axapta-Knowledge-Village] query range - like

2005-01-11 Thread anton_tjiptadi
I want to create query range with like and or criteria, something like this : (SQL Statement) select accountnum, voucher, * from ledgerjournaltrans where voucher like '%CPP%' or voucher like '%RV%' My statement rises an error if I wrote it like this one in X++ : sCrit = strFmt('((Voucher

Re: [Axapta-Knowledge-Village] query range - like

2005-01-11 Thread Lalith Jayantha
Hi anton Create a string type Extenderd data type and asign the string value to Extenderd data type ex: if Extenderd data type is "Likestring" assign the string value Likestring = '%RV%' select accountnum, voucher, * from ledgerjournaltrans where voucher like Likestring ; Lalith

[Axapta-Knowledge-Village] Re: query range - like

2005-01-11 Thread anton_tjiptadi
thanks, but I need to create it in querybuildrange, not in 'select statement' rgds, --- In Axapta-Knowledge-Village@yahoogroups.com, Lalith Jayantha [EMAIL PROTECTED] wrote: Hi anton Create a string type Extenderd data type and asign the string value to Extenderd data type ex: if

RE: [Axapta-Knowledge-Village] query range - like

2005-01-11 Thread Steve Wright
I think sCrit should be a comma separated list "*CPP*,*RV*" as this is standard Axapta syntax when entering filters, eg in the Ledger Transactions Inquiry form. You should not need to know ANY SQL to do an Axapta query - tableid and fieldid/values should be enough. S From:

[Axapta-Knowledge-Village] What shoule be consider when import table object?

2005-01-11 Thread ptmhki
What shoule be consider when import table object? Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts!

[Axapta-Knowledge-Village] Change label question

2005-01-11 Thread ptmhki
What is the mean of system field and how to change its label? Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts!

Re: [Axapta-Knowledge-Village] What shoule be consider when import table object?

2005-01-11 Thread Nitesh
Hi, While importing the the table u should have to take care of the TableID,Data of that table And the layer in which u r Exporting/Importing the table Regards Nitesh - Original Message - From: ptmhki [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday,

[Axapta-Knowledge-Village] Re: query range - like

2005-01-11 Thread anton_tjiptadi
correct, I just found it. the criteria string should be like this : sCrit = strFmt(('%1, %2'),'*CPP*', '*RV*'); thanks for your reply rgds, --- In Axapta-Knowledge-Village@yahoogroups.com, Steve Wright [EMAIL PROTECTED] wrote: I think sCrit should be a comma separated list *CPP*,*RV*