Giridhar,
The simplest SQL approach would be:
select *
from bmssa.SalesLine SL
where SL.dataareaid = 'your company id'
and SL.custaccount = '1234567890'
Note that the custaccount is the sold-to customer, and is available at the
order line level. If you need to search using the invoic
The module type for Inventory is 0, not 1.
--- In Axapta-Knowledge-Village@yahoogroups.com, "new_it_guy_ar"
wrote:
>
> We are running AX 3.0 SP6. We have recently decided to write off a number of
> items from our spare parts inventory. I have created a movement journal to
> zero out the cost
Nitesh,
Are the missing warehouses perhaps associated with a different Site?
--- In Axapta-Knowledge-Village@yahoogroups.com, Nitesh Ranjan
wrote:
>
> Hi All,
>
> I have an observation in AX 2009 Std.
>
> 1)Log in to AX 2009
> 2)Go to AP
> 3)Create a PO Header
> 4)Create a PO Line (enter It
Kishore,
I'm not sure I completely understand your issue, but it sounds like you're
trying to retrieve both the sales price and purch price from InventTableModule
using the same join. If that's true, the problem is that the same Price field
is used for Invent, Purch and Sales price and you need
Maverick,
As I understand it, RecId (in 3.0) goes from 0 to 20, then
switches sign and proceeds from -20 back toward zero. When
it passes zero and starts numbering forward again, you'll be OK until
it tries to duplicate an ID already in the same table (RecID numbers
are assigne
Vijay,
Movement: Allows offset account to be entered manually or defaulted
from the journal name setup.
Profit/Loss: Similar in function to Movement, except that the offset is
driven by the Profit or Loss account in the posting profile setups (per
item, item group, or All).
Transfer: Provides
Vijay,
In order to default the offset account per item group you could use
the Profit and Loss journal type instead of Movement journals. The
drawback is that Profit and Loss journals don't provide a means of
varying the account for different adjustment reasons (i.e., by direct
entry or journa
Hi,
Can Subbu or anyone who received additional information about
inventory close-generated cost adjustments please e-mail me?
Thanks,
Joe
--- In Axapta-Knowledge-Village@yahoogroups.com, DIEGO MARIANO
GAGLIANO <[EMAIL PROTECTED]> wrote:
>
> Hi James,
>
> Long time a go I have the same
Hello all,
There's one exception to what Hans wrote. If you use
Axapta's "record level security" feature, a restriction via one group
will override access granted via other groups. This is because
Axapta RLS is basically a filter, rather than an extension of normal
security.
--- In Axapta
9 matches
Mail list logo
