Would anybody have a solutionto can change the Units Conversion for the Packing list which already posted?
The scenario is.
1) New item was created without proper Units conversion (just selected Pcs)
2) Then Packing slip was posted with Pcs. On-Hand it showing 1Pc.
3) But, it should be 1set
Hi All,
I seem to remember seeing a utility long time ago that would create
the standard methods on tables (exist, find etc.)
It's just a pain haveing to do it everytime for simple tables.
Cheers,
Carsten
Yahoo! Groups Sponsor ~--
Has
Hi!
Has anybody ever done this kind of modification?
I should do a collection picking list, e.g. when several picking
lists are registered at the same time, the system prints out a list
of items and amounts that should be picked physically from
warehouse. For example, if there is an order
Hi!
It's SalesTable.initFromCustTable (e.g. SalesTable own methods).
Always look for initFromXXX - methods for the table, usually the
trick is done there, sometimes in classes.
Hope this helps! :-D
Regards
Nitta
--- In Axapta-Knowledge-Village@yahoogroups.com, buckee_d
[EMAIL PROTECTED]
Hi all,
I want to post an Sales order and also invoice it. The data required
to create a sales order is there in an excel sheet. I want to write a
code such that the data is picked from the excel sheet and all the
necessary validations present in a Sales order form is done and then
invoiced.
This is possible using the Axapta Business Connector. You can use VBA in excel to upload the data via the Business Connector. When you use the Business Connector all the business logics in Axapta are available for posting and validation.
VardenMorris
J. Wray Nephew Ltd. - Group I.S.
234
Hi Tushar,
this can be done (more or
less) easy.
First you have to access
your Excel sheet use the COM object Excel.Application for that. Excel
provides a good help on programming using the document object model for Excel.
Within Axapta save your
data in a table and use the
Dear all,
I have a SalesLine record that is not shown in the form SalesTable
while the record is available in the table SalesLine.
One can even create a new line and it will be added to the Table
SalesLine with the same line number as the one that is not visible.
Using the debugger I have
sorry this is a stupid question of mine , do you see
the salesId in the salesLine table?? and how r u
populating the salesline table ?
--- Danny Gaethofs [EMAIL PROTECTED] wrote:
-
Dear all,
I have a SalesLine record that is not shown in the
form SalesTable
Girish,
We are not seeing the salesid in the form. I have checked the table
salesLine and saw that the record is in there.
Something happened when the user was processing the sales order.
The salesID in the salesLine table is equal to the salesId in the
salestable table and still the record
Girish,
We are not seeing the salesid in the form. I have checked the table
salesLine and saw that the record is in there.
Something happened when the user was processing the sales order.
The salesID in the salesLine table is equal to the salesId in the
salestable table and still the record
I run a simple report from a button in a form based on ProjTable. I
want the ProjId-range in the report to be pre-filled with the ProjId
in the actual record in my form. So I don't have to fill it in
manually. How can I do this?
Yahoo! Groups Sponsor
Hi
Some of the information you could get using the table browser or by creating a
small addin to display the information...
If we know why you need this information it would be easier to help you
Best
Steen
dmunro54923 [EMAIL PROTECTED] wrote:
Yahoo! Groups
See if the table definition report suits
your needs, if not you may be able to expand on it to supply the properties you
want
(Menu Bar)-Tools\Development Tools\Table
Definitions.
-Preston
From: dmunro54923
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 18, 2005
9:05
Dear all,
There seems something wrong with the InventDim table. Once I removed
the table from the Form (made a duplicate) I can see the salesLine.
regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, Danny Gaethofs
[EMAIL PROTECTED] wrote:
Girish,
We are not seeing the
Hello everyone
I have created a number of purchase orders(status received) which I
would now like to pay. I have registered the supplier invoices
(journal type Invoice register) and have gone into Invoice
approval (type Approval).When pressing the button Fetch vouchers
nothing is selected
I guess your button is a MenuItemButton. If so, set its DataSource has
ProjTable. In your report init() you can do this :
ProjTable projTab;
super();
projTab = element.args().record();
element.query().dataSourceTable(tableNum(TableOfYourRange)).addRange(...).value(projTab.ProjId);
or
Check to see if an inventdimId exists in the salesline. If the inventory
dimension does not exist on the salesline the record will not show. The
innerjoin linktype property of the datasource on the inventDim table has to
have a record to match a record of InventdimId from the salesline. Once
Xrecord may help you, I guess?Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"Take a guess" [EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Take a guess" [EMAIL PROTECTED]Fecha: 18/01/2005
You will have to pass the record as parameter to report; In the report you will have to program code that catches this record, and then modify the QueryRange of the Range you want, before executing the query. You will have a little work doing this...Raúl Llorente Peña Análisis, Desarrollo e
Myrl,
Indeed somebody has been juggling with the inventDim. I copied the
value from the inventDim record back into the salesLine but it is not
solving the problem.
Any other possibilities?
regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, Myrl Stadnick
[EMAIL PROTECTED]
Thanks all for your help.
Second attempt copying the InventDimId to the salesLine did solve the
problem.
regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, Danny Gaethofs
[EMAIL PROTECTED] wrote:
Myrl,
Indeed somebody has been juggling with the inventDim. I copied the
Hi,
I am trying to upload master BOM data from SAP to Axapta3.0 using Import wizards. Well, I have populated all the data for Item Master and then Configurations with the appropriate relevent data.
After that, I created another wizard to import BOM data. On the BOM lines form (
you need to write
inventdim.clear();
inventdim.config = value;
...
inventdim = inventdim::findorcreate(inventdim);
BOM.inventdimId = inventdim.inventdimId;
well i had created jobs in order to import the BOM,
BOMTable and BOMVersion for our clients. the above
lines would include the required
All we were telling it to you...Not at all. ;-)Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"Danny Gaethofs" [EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Danny Gaethofs" [EMAIL
Hi All,
I have a Customized new form in BUS layer which also has CUS layer
and USR layer modifications. This form has salesline as the
underlying datasource .
Q1. Will the performance be affected becuase of different layer
of modification?
Thanks
TJJ
Yahoo!
Hi all:
I would like to know if it is possible insert a ledeger account like
in the following example:
LEDGER ACCOUNT: 11-20-002
It could be cause a future error?
Should I enter it of this form? 1120002
Thanks for your help
Yahoo! Groups Sponsor
Excellent. My job is working fine. Thanks a lot to Girish. You are great!.
subbu,
SDBCGirish B [EMAIL PROTECTED] wrote:
you need to write inventdim.clear();inventdim.config = "value";...inventdim = inventdim::findorcreate(inventdim);BOM.inventdimId = inventdim.inventdimId;well i had created
Yeah, now it's working.
Thanks!
Raul Llorente Pea/OPENSOLUTIONS wrote:
Have a look over the dictTable class:
dictTable dt;
int numberOfFields;
int fieldId;
int i;
;
dt = new dictTable(tableNum(CustTable));
//name of table
Hi all
I want to use markuptrans with AmountCur 0 zero. It craetes voucher but the
value AmountCur is 0.
Does it make any problem for or axapta, because for some reason i will insert
hundreds of these markuptrans records every month.
Thanks.
Yahoo! Groups
Hi,
I have a report using InventSum and InventDim giving me ItemID, ItemName,
InventLocationID, and AvailPhysical. I need to modify the report so that I
only retrieve those ItemID's
that have AvailPhysical at more that one InventLocationID from InventDim.
I don't see how you can do this with
--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente
Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote:
I don't mean to be smart but I don't have a clue what your saying.
When I said I was new to Axapta SQL, I meant it.
Yahoo! Groups Sponsor
Hi
Putting a range in covcalc will muck up things. To explain this will
need a long discussion.
why don't you just put a range on inventTable while running a master
plan (i.e. when you open Master Scheduling menu)?
You still have a problem with settings on the master planning parameters
which
--- In Axapta-Knowledge-Village@yahoogroups.com, Preston A.
Larimer [EMAIL PROTECTED] wrote:
See if the table definition report suits your needs, if not you
may be able
to expand on it to supply the properties you want
(Menu Bar)-Tools\Development Tools\Table Definitions.
Preston,
--- In Axapta-Knowledge-Village@yahoogroups.com, Steen Rabol
[EMAIL PROTECTED] wrote:
Hi
Some of the information you could get using the table browser or
by creating a small addin to display the information...
If we know why you need this information it would be easier to
help you
david bonk wrote:
... Axapta has to make this entry because the alternative is to put
an item into inventory at a cost different form standard and this
is not possible.
I partially agree - but to me the alternative is to record the
negative cogs at the current standard, not the old
Hi
I have some time on my hand and here is the full discussion (or at least
an attempt).
Option 1: Create 2 different plans and ask the users to run different
plan per site. In this case both the plans will overwrite the same
dynamic plan specified on reqparameters. Ofcourse you can change this
Hi Tushar,
This can be done easily , withinn Axapta only. Write a
utility ( class ) , that will access the Excel data
and will import that to the AxaptaTables ( sales order
related) using the correct classes .
Once the Salesorder created its very simple to invoice
them . here is the code for
Here is quick and dirty way to get the
lens in the report
The report is named sysTableDefintion
Open the Class Delcaration, Add this
Line
int
size; //Var to Hold Field Size
Open the following node on the report, its
a method
Hi,
Please double check your AOS
configuration.
Regards,
From: Morris Mendoza
[mailto:[EMAIL PROTECTED] Sent: Wednesday, January 19, 2005 11:19
AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject:
[Axapta-Knowledge-Village] Axapta Object Servers
Im having problems starting my
There could be multiple reasons for this
behavior, Copy your config settings to a 2-tier configuration and see if a
2-tier client runs from the server, if it does your most likely dealing with permissions,
does the AOS service have rights to read the application, can it find the SQL
--- In Axapta-Knowledge-Village@yahoogroups.com, Preston A.
Larimer [EMAIL PROTECTED] wrote:
Here is quick and dirty way to get the lens in the report.
The report is named sysTableDefintion
Open the Class Delcaration, Add this Line
Preston,
Thanks for the code sample. I
Hi harry
It will be easy to use it because i want my records to be linked to invoice and
to be removed form salesorder after billing.
So it will be easy to use markuptrans. One more reason they are real misc.
charges which is not shown in my Accounting System but which is shown to
customer.
Title: Message
Hi,
I have a serious
problem and hope someone can help..
When doing closed
transaction editing in Sales Ledger, I select a payment and Axapta then selects
all corresponding invoices. I then click reverse to unlink the payments
and invoices in the settlement. Axapta
Theorically not; but you must note that the layer files are greater, somanaging them takes more memory in the client(2-tier) or server(3-tier). And, is yet more noticeably harder to the applicattion admin/programmer to manage those objects (time and error costs). So, try to have objects in
45 matches
Mail list logo