webERP Forum

Full Version: Need Help
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi i have done the installation & was loading items one by one, tried importing but was not going through, after that i have gone to phpmyadmin & imported parts data directly from .csv to stockmaster. however when i try to see the part in item it shows no record, when i search the part while entering Sales order it shows but while adding the part in sales order it shows item not present

can any one help me solution i can not delete all data & do new installation ( i had already entered lots of other data as well )
You could run the Z_MakeStockLocns.php script
(07-30-2015 11:15 AM)phil Wrote: [ -> ]You could run the Z_MakeStockLocns.php script

Thanks phil

now the error coming is
WARNING Message Report : The item code 2N3773G does not have a cost set up and order entry is set up to prohibit sales of items with no cost data entered

how do i fix this
It would appear that you did not fill in a value for the materialcost (or any of the other cost fields) field of stockmaster when you imported the items. You can change the configuration to allow sales with zero costs (in Setup->Configuration Settings) but as an accountant I wouldn't advise it as you will end up with some odd accounting records.

Thanks
Tim
(07-30-2015 07:43 PM)falkoner Wrote: [ -> ]It would appear that you did not fill in a value for the materialcost (or any of the other cost fields) field of stockmaster when you imported the items. You can change the configuration to allow sales with zero costs (in Setup->Configuration Settings) but as an accountant I wouldn't advise it as you will end up with some odd accounting records.

Thanks
Tim

hi tim

thanks this issue is solved by allowing zero cost parts in SO

now i have created customer login & when trying to add SO below error is comming

Database Error 1452 : The order cannot be added because
Cannot add or update a child row: a foreign key constraint fails (`ecxsgs9y_webe384`.`salesorders`, CONSTRAINT `salesorders_ibfk_3` FOREIGN KEY (`fromstkloc`) REFERENCES `locations` (`loccode`))

thebug13

Interesting stuff guys.

volvo service
Is the customer setup to allow access to the location? Do they have update permissions to that location?
Hi Andrew this is an old thread the new post is just spam
Tim,
Realized the post above mine was spam - didn't realize previous stuff was old or resolved. Hadn't seen it before.
Thanks.
sorry guys - now ditched the spam
Reference URL's