add new Order

[n-art-m]

hey,
i'm trying to add a new sales order. prices list are set and working so far.

it's terrible... when i add a clientaccount and search for a item to sell it appears "no matches found".

If i let the clientaccount blank, the stock item i'm looking for appears. sounds like a wrong configuration, or not? at time a got no idea where to look for it...

thanks

[Nathan Gray]

On 17-Apr-09, at 12:37 PM, n-art-m wrote:

>
> hey,
> i'm trying to add a new sales order. prices list are set and working  
> so far.
>
> it's terrible... when i add a clientaccount and search for a item to  
> sell it
> appears "no matches found".

Please elaborate on "working so far" in this context.

> If i let the clientaccount blank, the stock item i'm looking for  
> appears.
> sounds like a wrong configuration, or not?

Could be.  Do you have "Use individual client price lists / discounts"  
set (Admin -> AR -> Site Config)?
Do the price list settings match the client account settings?
Check effective dates on the price list, prices, and the order date of  
the Sales Order.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[n-art-m]

Nathan Gray wrote:

On 17-Apr-09, at 12:37 PM, n-art-m wrote:

>
> hey,
> i'm trying to add a new sales order. prices list are set and working  
> so far.
>
> it's terrible... when i add a clientaccount and search for a item to  
> sell it
> appears "no matches found".

Please elaborate on "working so far" in this context.

price list appears in Sales orders --> price lists.
"Price changes effective at" is in time. parts or assemblies for the price list are set.

> If i let the clientaccount blank, the stock item i'm looking for  
> appears.
> sounds like a wrong configuration, or not?

Could be.  Do you have "Use individual client price lists / discounts"  
set (Admin -> AR -> Site Config)?
Do the price list settings match the client account settings?
Check effective dates on the price list, prices, and the order date of  
the Sales Order.

Now I got a working configuration. I set "sales area" and "sales type" equal for client and price list. now the price list appears.
previously the "sales type" for the client was set as "all". nothing appeared.
I thought it would be equal, and when I set it to all, all types would be considered. I'm wrong?  

But now there's a new problem.
The manufacturing modul prints following:
"    * Unable to set work order. Given work order detail is not for the correct item.
    * Invalid SQL: SELECT * FROM perp_build_option_exclusion : Table 'egroupware.perp_build_option_exclusion' doesn't exist
"

[Nathan Gray]

>> Could be.  Do you have "Use individual client price lists /  
>> discounts"
>> set (Admin -> AR -> Site Config)?
>> Do the price list settings match the client account settings?
>> Check effective dates on the price list, prices, and the order date  
>> of
>> the Sales Order.
>>
>>
> Now I got a working configuration. I set "sales area" and "sales type"
> equal for client and price list. now the price list appears.
> previously the "sales type" for the client was set as "all". nothing
> appeared.
> I thought it would be equal, and when I set it to all, all types  
> would be
> considered. I'm wrong?

No, that sounds like a bug.

> But now there's a new problem.
> The manufacturing modul prints following:
> "    * Unable to set work order. Given work order detail is not for  
> the
> correct item.

This is caused by a mis-match between the item(s) on the work order,  
as entered in Manufacturing, with the item you tried to add to the  
Sales Order.  Usually, this is caused by manually setting the Work  
Order number for that line on the sales order, and getting the wrong  
work order.  Check to make sure the work order does actually contain  
the item you're trying to sell.

>    * Invalid SQL: SELECT * FROM perp_build_option_exclusion : Table
> 'egroupware.perp_build_option_exclusion' doesn't exist

Your database does not match your code.  Make sure you have updated  
the application in Setup.


Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Nathan Gray]

On 20-Apr-09, at 1:14 PM, Nathan Gray wrote:

>> ...
>> previously the "sales type" for the client was set as "all". nothing
>> appeared.
>> I thought it would be equal, and when I set it to all, all types
>> would be
>> considered. I'm wrong?
>
> No, that sounds like a bug.

Should be fixed in rev 3356.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers