Stock items not appearing

View: New views
17 Messages — Rating Filter:   Alert me  

Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,

I'm in a doubt related to perp_orders/inventory. I have some items registered in my stock, but when I try to create a new sales order that items are not found. I would like to know what informations are essential for the stock items and how can I make it appear in sales orders.

Can you explain for me?

Since now, thanks and regards


Re: Stock items not appearing

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 6-Jan-09, at 9:43 AM, PCS-Lists wrote:

>
> Hello,
>
> I'm in a doubt related to perp_orders/inventory. I have some items
> registered in my stock, but when I try to create a new sales order  
> that
> items are not found. I would like to know what informations are  
> essential
> for the stock items and how can I make it appear in sales orders.
>
> Can you explain for me?

First, make sure you have at least one sales area (usually your city),  
sales category (Stuff, Computers, etc.) and sales type (Store, MSRP,  
Manufacturer Direct).
You need at least one price list, configured for the correct sales  
category, etc.
Then you need to set the price for that item on that price list.
Items that are not available on a price list are not sold.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I followed your steps but the stock items still not appearing. Can I create a price list effective since now or only effective from tomorrow?

Thanks.



Nathan Gray wrote:
On 6-Jan-09, at 9:43 AM, PCS-Lists wrote:

>
> Hello,
>
> I'm in a doubt related to perp_orders/inventory. I have some items
> registered in my stock, but when I try to create a new sales order  
> that
> items are not found. I would like to know what informations are  
> essential
> for the stock items and how can I make it appear in sales orders.
>
> Can you explain for me?

First, make sure you have at least one sales area (usually your city),  
sales category (Stuff, Computers, etc.) and sales type (Store, MSRP,  
Manufacturer Direct).
You need at least one price list, configured for the correct sales  
category, etc.
Then you need to set the price for that item on that price list.
Items that are not available on a price list are not sold.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Stock items not appearing

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 7-Jan-09, at 9:10 AM, PCS-Lists wrote:

>
> I followed your steps but the stock items still not appearing. Can I  
> create a
> price list effective since now or only effective from tomorrow?

Ok, so you have a price list, with at least one item on it that has a  
price.

Did you set the AR config option 'Use individual client price lists /  
discounts' option to true?  If so, that requires an extra step.

If not, you should be able to create a sales order (with an order date  
after the price's effective date), and at least that one item should  
show up.

The most common things to go wrong are:
- No price list for the client's sales area / sales type
- Price list is not effective on the order date
- Price is set to N/A for the order date

Some other things to check:
1.  GL -> New Journal Entry.  See if the Account box will drop down.
2.  AR -> New Invoice.  See if the client box will drop down.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Stock items not appearing

by constant :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

.
Hi Nathan,

I had this problem until I started using individual price lists.
.


Nathan Gray wrote:
On 7-Jan-09, at 9:10 AM, PCS-Lists wrote:

>
> I followed your steps but the stock items still not appearing. Can I  
> create a
> price list effective since now or only effective from tomorrow?

Ok, so you have a price list, with at least one item on it that has a  
price.

Did you set the AR config option 'Use individual client price lists /  
discounts' option to true?  If so, that requires an extra step.

If not, you should be able to create a sales order (with an order date  
after the price's effective date), and at least that one item should  
show up.

The most common things to go wrong are:
- No price list for the client's sales area / sales type
- Price list is not effective on the order date
- Price is set to N/A for the order date

Some other things to check:
1.  GL -> New Journal Entry.  See if the Account box will drop down.
2.  AR -> New Invoice.  See if the client box will drop down.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello Nathan, Constant,

I discovered a strange behavior in perp_orders, when adding a new sales order. If I start the order searching for stock items to add to the order, the items are showed normally, the search works and I get to add lines in the sales order. However, if I fill the other fields related to the client, the stock items search stop working and not get any item.

Does it make sense?


.
Hi Nathan,

I had this problem until I started using individual price lists.
.


Nathan Gray wrote:
On 7-Jan-09, at 9:10 AM, PCS-Lists wrote:

>
> I followed your steps but the stock items still not appearing. Can I  
> create a
> price list effective since now or only effective from tomorrow?

Ok, so you have a price list, with at least one item on it that has a  
price.

Did you set the AR config option 'Use individual client price lists /  
discounts' option to true?  If so, that requires an extra step.

If not, you should be able to create a sales order (with an order date  
after the price's effective date), and at least that one item should  
show up.

The most common things to go wrong are:
- No price list for the client's sales area / sales type
- Price list is not effective on the order date
- Price is set to N/A for the order date

Some other things to check:
1.  GL -> New Journal Entry.  See if the Account box will drop down.
2.  AR -> New Invoice.  See if the client box will drop down.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers


Re: Stock items not appearing

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 8-Jan-09, at 10:01 AM, PCS-Lists wrote:

>
> Hello Nathan, Constant,
>
> I discovered a strange behavior in perp_orders, when adding a new  
> sales
> order. If I start the order searching for stock items to add to the  
> order,
> the items are showed normally, the search works and I get to add  
> lines in
> the sales order. However, if I fill the other fields related to the  
> client,
> the stock items search stop working and not get any item.
>
> Does it make sense?


It sounds like that client is not allowed to purchase anything, for  
some reason.

Try constant's suggestion of turning on individual price lists.
Set the AR config option 'Use individual client price lists /
discounts' option to true, then explicitly allow your client's account  
access to your price list.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Nathan,

I checked the AR config option 'Use individual client price lists /  
discounts' and it's true.
- My price list has client's sales area / sales type
- Price list is effective
- All prices are set to a value;
- in GL -> New Journal Entry. The Account box is dropping down.
- in AR -> New Invoice. The client box dropping down.


I don't understood what means "turning on individual price lists...explicitly allow your client's account  
access to your price list."

Can you explain for me?


Thanks
------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers



Re: Stock items not appearing

by constant :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

.
Hi,

In Admin->Accounts Receivable near the top you'll see:

Use individual client price lists / discounts

Tick that check box, then go to:

Accounts Receiveable->Clients->edit client->Accounts tab->edit account

And tick the check box/s for the price list/s you want available to that customer.

Regards
J.D.

PCS-Lists wrote:
Nathan,

I checked the AR config option 'Use individual client price lists /  
discounts' and it's true.
- My price list has client's sales area / sales type
- Price list is effective
- All prices are set to a value;
- in GL -> New Journal Entry. The Account box is dropping down.
- in AR -> New Invoice. The client box dropping down.


I don't understood what means "turning on individual price lists...explicitly allow your client's account  
access to your price list."

Can you explain for me?


Thanks
------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers


Re: Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,


I followed your tips and I found the field about prices, but there's no options to select. When creatinhg price lists, I don't have any optios that indicate wich customer can access the price list. How can I do this?



regards,


constant wrote:
.
Hi,

In Admin->Accounts Receivable near the top you'll see:

Use individual client price lists / discounts

Tick that check box, then go to:

Accounts Receiveable->Clients->edit client->Accounts tab->edit account

And tick the check box/s for the price list/s you want available to that customer.

Regards
J.D.

PCS-Lists wrote:
Nathan,

I checked the AR config option 'Use individual client price lists /  
discounts' and it's true.
- My price list has client's sales area / sales type
- Price list is effective
- All prices are set to a value;
- in GL -> New Journal Entry. The Account box is dropping down.
- in AR -> New Invoice. The client box dropping down.


I don't understood what means "turning on individual price lists...explicitly allow your client's account  
access to your price list."

Can you explain for me?


Thanks
------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Stock items not appearing

by constant :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

.
You do it on an individual customer basis,and it's done in the client account section, not in Sales Orders.

In the client account section, if everything else has been setup correctly, there should be the correct price list/s for that client available to tick the check box to use it/them.

If you don't have a price list appearing then I would suggest doing the things Nathan said about:

- No price list for the client's sales area / sales type or currency
- Price list is not effective on the order date
- Price is set to N/A for the order date

Some other things to check:
1.  GL -> New Journal Entry.  See if the Account box will drop down.
2.  AR -> New Invoice.  See if the client box will drop down.

Regards
J.D.



Hi,


I followed your tips and I found the field about prices, but there's no options to select. When creatinhg price lists, I don't have any optios that indicate wich customer can access the price list. How can I do this?



regards,


constant wrote:
.
Hi,

In Admin->Accounts Receivable near the top you'll see:

Use individual client price lists / discounts

Tick that check box, then go to:

Accounts Receiveable->Clients->edit client->Accounts tab->edit account

And tick the check box/s for the price list/s you want available to that customer.

Regards
J.D.

PCS-Lists wrote:
Nathan,

I checked the AR config option 'Use individual client price lists /  
discounts' and it's true.
- My price list has client's sales area / sales type
- Price list is effective
- All prices are set to a value;
- in GL -> New Journal Entry. The Account box is dropping down.
- in AR -> New Invoice. The client box dropping down.


I don't understood what means "turning on individual price lists...explicitly allow your client's account  
access to your price list."

Can you explain for me?


Thanks
------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers


Re: Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> No price list for the client's sales area / sales type or currency
> Price list is not effective on the order date
> Price is set to N/A for the order date
>Some other things to check:
>1.  GL -> New Journal Entry.  See if the Account box will drop down.
>2.  AR -> New Invoice.  See if the client box will drop down.

Hello,

all this steps are ok, except the price of the stock item, that is set to N/A. How can I change it?

thanks

Re: Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> No price list for the client's sales area / sales type or currency
> Price list is not effective on the order date
> Price is set to N/A for the order date
>Some other things to check:
>1.  GL -> New Journal Entry.  See if the Account box will drop down.
>2.  AR -> New Invoice.  See if the client box will drop down.

Hello,

all this steps are ok, except the price of the stock item, that is set to N/A. How can I change it?

thanks

Re: Stock items not appearing

by constant :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

.
Hi,

You need to setup price lists in Sales Orders and associate the item with a price list.

Regards
John

PCS-Lists wrote:
> No price list for the client's sales area / sales type or currency
> Price list is not effective on the order date
> Price is set to N/A for the order date
>Some other things to check:
>1.  GL -> New Journal Entry.  See if the Account box will drop down.
>2.  AR -> New Invoice.  See if the client box will drop down.

Hello,

all this steps are ok, except the price of the stock item, that is set to N/A. How can I change it?

thanks

Re: Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi constant,

forgive me, I didn't explain me correctly. I already set a price list and associated the items with the sales category of my price list (in the tab "pricing" of the stock items), but maybe something else should to be done, because when I edit my price list and it shows the stock items, the filed "Price" of each item is set to N/A and I can't change it. What can I do?

One more information: Price list Effective To* 01/09/2009 and Price changes effective at* 31/08/2009

Thanks for patience, regards


constant wrote:
.
Hi,

You need to setup price lists in Sales Orders and associate the item with a price list.

Regards
John

Re: Stock items not appearing

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 3-Sep-09, at 8:00 AM, PCS-Lists wrote:

> ...
> "Price" of each item is set to N/A and I can't change it.

Please elaborate on "can't change it".  What do you try, and what does  
pERP do?

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Stock items not appearing

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>Please elaborate on "can't change it".  What do you try, and what does  
>pERP do?

Nathan,

I already understood what I was making wrong. Price list was effective to a past date. Forgive me.

Only one more silly doubt: is there a way to make a price list effective since now, or always it will be effective on next day?

Thanks.